REQUIRED: Use Excel to prepare an electronic spreadsheet of an accounts receivable aging report for Garret for April 30. Organize spreadsheet with the following columns heading above.

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