REQUIRED: Use Excel to prepare an electronic spreadsheet of an accounts recevibale aging report for Gerret for April 30. Organize spreadsheet with the following columnd heading above.

CHAPTER 8 Revenue and Cash Collection Processes and Controls controls or does not pertain to the revenues a 53. (SC 2) Following is the April 30 Accounts Receivable Subsidiary Ledger Gerrett, Inc., a retailer of tents and camping equipment. ts Receivable Subsidiary Ledger t, Inc. 30, 20xx Open Receivables Account 43985 mer: Acme Sporting Goods Central Credit Terms: 30 days 4726 Interstate Highway 2L Credit Limit: $15,000 Devron, Kansas 76588 507-945-8800 Customer Total Amount Due Date Invoice Date Invoice Number $1,366.48 May 27 April 27 77341 4,975.00 May 1 April 1 75118 4,017.15 April 14 March 15 70698 $11,018.22 659.59 February 13 January 14 65287 Account 41772 mer: Brufton Outdoors Credit Terms: 30 days 623 Main Street NW Credit Limit: $15,000 Devron, Kansas 76588 1844 Customer Total Amount Due Date Invoice Date Invoice Number $1,946.40 March 22 February 20 67915 $8,709.50 6,763.10 February 1 January 2 61190 Account 30966 omer: Jafferty Sporting Goods Credit s: 15 days Term 8466 State Route 33 Credit Limit: $5,000 Elkton, Kansas 76541 507-312-9469 Customer Total Amount Due Date Invoice Date Invoice Number $4,067.99 $4,067.99 April 6 March 22 74555 Account 29667 tomer: Kansas Department of Recreation and Safety Credit Terms: 30 days 8466 State Route 33 Credit Limit: $25,000 Gray Mountain, Kansas 76529 507-226-6881 Customer Total Amount Due Date: nvoice Date Invoice Number $10,646.20 May 30 April 30 78021 6,653.15 May 16 April 16 77216 975.63 May 15 April 15 77089 299.00 May 1 April 1 75663 1,104.13 April 14 March 15 74277 655.31 April 6 March 7 73586 $22,177.25 1.843.83