Following is the April 30 Accounts Receivable Subsidiary Ledgerof Gabbard, Inc., a retailer of tents and camping equipment. (Theledger is also available for download at the end of theprompt.)

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				Account 43985 Credit Terms: 30 days Credit Limit: $15,000
	Invoice Number	Invoice Date	Due Date	Amount	Customer Total
	77341	April 27	May 27	$1,366.48
	75118	April 1	May 1	4,975.00
	70698	March 15	April 14	4,017.15
	65287	January 14	February 13	659.59	$11,018.22
Customer:	Brufton Outdoors 623 Main Street NW Devron, Kansas 76588 507?945?1844				Account 41772 Credit Terms: 30 days Credit Limit: $15,000
	Invoice Number	Invoice Date	Due Date	Amount	Customer Total
	67915	February 20	March 22	$1,946.40
	61190	January 2	February 1	6,763.10	$8,709.50
Customer:	Jafferty Sporting Goods 8466 State Route 33 Elkton, Kansas 76541 507?312?9469				Account 30966 Credit Terms: 15 days Credit Limit: $5,000
	Invoice Number	Invoice Date	Due Date	Amount	Customer Total
	74555	March 22	April 6	$4,067.99	$4,067.99
Customer:	Kansas Department of Recreation andSafety 8466 State Route 33 Gray Mountain, Kansas 76529 507?226?6881				Account 29667 Credit Terms: 30 days Credit Limit: $25,000
	Invoice Number	Invoice Date	Due Date	Amount	Customer Total
	78021	April 30	May 30	$10,646.20
	77216	April 16	May 16	6,653.15
	77089	April 15	May 15	975.63
	75663	April 1	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
Customer:	Pup Scouts of Devron 9064 State Route 16 Devron, Kansas 76588 507?312?3126				Account 33117 Credit Terms: 15 days Credit Limit: $10,000
	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
Customer:	Regents Athletic Club 22 West Adams Way Devron, Kansas 76588 507?945?2149				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
Customer:	Buddy's Sports Buff 212 Oak Street Silver Horn, Kansas 76557 507?399?7761				Account 16200 Credit Terms: 30 days Credit Limit: $10,000
	Invoice Number	Invoice Date	Due Date	Amount	Customer Total
	77115	April 15	May 15	$8,046.40
	70564	March 15	April 14	1,774.92	$9,821.32

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

Customer Name	Total Account Balance	Current Balance		Past Due Balances
				1–30 days		31–60 days		Over 60 days
		Invoice #	Amount	Invoice #	Amount	Invoice #	Amount	Invoice #	Amount

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

In addition to completing the spreadsheet, write a brief paperthat explains the following:

What is the primary purpose of an accounts receivable agingreport?

When should outstanding accounts be written off?

What controls are needed in handling aged accounts?