Following is the April 30 Accounts Receivable Subsidiary Ledger of Gabbard, Inc., a retailer of tents and camping equipment.

Required:Use Microsoft Excel to prepare an electronic spreadsheet of an accounts receivable aging report for Gabbard for April 30. Organize the spreadsheet with the following column headings:

Be sure to include each individual invoice for each customer, and show column totals for each customer. Also show report totals for each column and be certain that the report totals cross?foot and agree with the ending Total Account Balance for all customers.

Transcribed Image Text:

Accounts Receivable Subsidiary Ledger Gabbard, Inc. April 30, 20xx Open Receivables Customer: Acme Sporting Goods Central 4726 Interstate Highway 2L Devron, Kansas 76588 507-945-8800 Invoice Number 77341 75118 Account 43985 Credit Terms: 30 days Credit Limit: $15,000 Invoice Date April 27 April 1 March 15 January 14 Due Date May 27 May 1 April 14 February 13 Amount Customer Total $1,366.48 4,975.00 4,017.15 70698 65287 $11,018.22 659.59 Accounte Receivable Subsidiary Ledger Gabbard, Inc. April 30, 20xx Open Receivables Account 41772 Credit Terms: 30 days Credit Limit: $15,000 Customer: Brufton Outdoors 623 Main Street NW Devron, Kansas 76588 507-945-1844 Invoice Number Invoice Date Due Date Amount Customer Total February 20 January 2 67915 March 22 $1,946.40 February 1 6,763.10 $8,709.50 61190 Account 30966 Credit Terms: 15 days Credit Limit: $5,000 Customer: Jafferty Sporting Goods 8466 State Route 33 Elkton, Kansas 76541 507-312-9469 Invoice Number Invoice Date Due Date Amount Customer Toal 74555 March 22 April 6 $4,067.99 $4,067.99 Kansas Deparıment of Recreation and Safety 8466 State Route 33 Account 29667 Credit Terms: 30 days Credit Limit: $25,000 Customer: Gray Mountain, Kansas 76529 507-226-6881 Invoice Number Invoice Date Due Date Amount Customer Total May 30 May 16 78021 April 30 $10,646.20 77216 April 16 April 15 April 1 6,653.15 77089 May 15 975.68 75663 May 1 299.00 74277 March 15 April 14 1,104.13 73586 March 7 April 6 655.31 67644 February 20 March 22 1,843.83 $22,177.25 Account 33117 Credit Terms: 15 days Credit Limit: $10,000 Customer. Pup Scouts of Devron 9064 State Route 16 Devron, Kansas 76588 507-312-3126 Invoice Number Invoice Date Due Date Amount Customer Total 77911 April 20 May 5 $9,737.91 75559 March 29 April 13 220.04 $9,957.95 Regents Athledc Club 22 West Adams Way Devron, Kansas 76588 507-945-2149 Customer. Account 30846 Credit Terms: 30 days Credit Limit: $5,000 Invoice Number Invoice Date Due Date Amount Customer Total 66268 January 25 March 24 $2,678.59 61119 January 2 February 1 862.35 $3,540.94