PPAS 4130 Study Guide - Final Guide: Patriation Reference, Signify, Supreme Court Act
Document Summary
Get access
Related Documents
Related Questions
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 | |||||
Customer: | Acme Sporting Goods Central | Account 43985 | |||
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 | Account 41772 | |||
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 | Account 30966 | |||
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 | Account 29667 | |||
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 | Account 33117 | |||
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 | Account 30846 | |||
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 | Account 16200 | |||
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?