26 Aging of AR
docx
keyboard_arrow_up
School
Wisconsin Indianhead Technical College *
*We aren’t endorsed by this school
Course
22894
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by DoctorRaccoon2667
Principles of Finance
Accounts Receivable Management
Aging of Accounts Receivable 28/28
Name: _________Alissa Mack____________________
1.
An aging of accounts receivable report is a summary of all amounts due. It tells you at a
glance:
Which client owes you money
How much money they owe
How much of their account balances are past due
This report should be created monthly.
Please create an accounts receivable aging report based on the following customer
information and assuming today is March 13. Terms are 2 10 net 30. Please remember,
customers who don’t pay in 30 days will be charged interest.
Customer
Invoice Date
Amount Due
Days
In the Pen Co. March 10
$1,000
3
Technocolor Co. March 7
$4,000
6
Crayola Co. Feb 9
$1,500
32
In the Pen Co. Feb 5
$1,000
36
Technocolor Co.
Jan 31
$500
41
Dutiful Co. Jan 2
$2,000
70
Sing Co. Jan 1
$2,000
71
Crayola Co. Dec 30
$1,500
73
In the Pen Co.
Dec 28
$1,000
75
Technocolor Co. Dec 27
$500
76
Dutiful Co.
Dec 5
$3,000
98
Sing Co.
Dec 4
$2,000
99
1
Assignment:
Complete the accounts receivable aging report below listing the customer with the largest outstanding balance first on the report
:
11pts
Aging of Accounts Receivable
Collegiate Accounting Services
1900 College Drive
Rice Lake, WI 54868
March 13, 200X
Customer
Total
Due
0-30
Current
31-60
Days
61-90
Days
91-120
Days
% Not
Current
Dutiful 5,000
2,000
3,000
100%
Technocolor 5,000
4,000
500
500
20%
Sing
4,000
2,000
2,000
100%
Crayola 3,000
1,500
1,500
100%
In The Pen
3,000
1,000
1,000
1,000
66.67%
Column Totals
20,000
5,000
3,000
7,000
5,000
75%
% of Total
100%
25%
15%
35%
25%
2
Questions 5 pts
:
2.
How does this aging of accounts receivable report help you spot problem accounts?
It shows you by customer how much they owe and how much is late and within what
days its late.
3.
List below any customer whose entire account balance is over 60 days past due?
Dutiful and Sing
4.
What concerns would you have with customers whose account is over 60 days old?
That they aren’t going to pay us.
5.
Explain why Collegiate Accounting Services may want to stop extending credit to some
of their customers
If they stop lending credit to customers it will get the customers to pay.
6.
Describe three ways Collegiate Accounting Services can try to get their past due
customers to pay faster or to pay their outstanding amounts due
Contact the customers by phone
Charge an interest fee for being late
Send the customers to collections
3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
7.
Swenson Electric Company sells on terms of “net 30”. Given the following information
on its receivables, complete the aging of accounts schedule below as of September 1,
showing the percentage of accounts that are current, 1 to 30 days past due, 31 to 60 days
past due, 61 to 90 days past due, and over 90 days past due. (Assume 30 days in each
month)
Account Number
Invoice Date
Amount Due
Days
1311
August 15
$1315
17
1773
July 14
721
49
1217
July 25
677
38
1319
August 14
1711
18
1814
April 10
325
144
1713
August 5
917
27
1443
May 8
493
116
1144
June 28
211
65
1972
May 5
755
119
1011
April 21
377
133
1619
August 28
1550
4
1322
August 13
275
19
1173
March 5
675
180
1856
August 12
695
20
1317
June 10
720
83
Fill in the table below for this problem 12 pts
Current
1-30 Past
Due
31-60 Past
Due
61-90 Past
Due
90+ Past
Due
Total
0-30
31-60
61-90
91-120
120+
$6,463
$1,398
$931
$1,248
$1,377
$11,417
56.61%
12.24%
8.15%
10.93%
12.06%
100%
8.
Give your opinion on the following: Should you allow any customers to take discounts past the discount period (i.e. terms 2/10 n 30 and customer takes discount but pays on day
27)? 2 pts
No, I would not let them take the discount after the discount date. It is a discount period for a reason, you have an expected amount of discounts if you allowed them to get a discount after the period you’d be going over your expected amount of discounts.
4
Related Documents
Related Questions
answer correct this time with all work thanks
arrow_forward
CANDY'S CLEANING SERVICES
Bank Reconciliation
April 30, 2020
$33,452 Book balance
Bank balance
$28,934
Add:
Deduct:
Interest
$47
NSF, customer Bonne
412
Error Chq #93
99
146
$29,080
Outstanding cheques:
Deduct:
#879
$2,600
Service Charge
40
#100
1,400
4,412
Adjusted bank balance
$29,040 Adjusted book balance
$29,040
In comparing the bank reconciliation to the Cash account In the general ledger, you notice a problem. You investigate further and
come up with some additional Informatlon as follows:
a. The Cash account in the general ledger showed the followling:
Cash
Acct. No. 101
Date
Explanation
PR
Debit
Credit
Balance
2020
March 31 Balance
28,934
৪4,934
21,051
April 30
CR16
56,000
30
CD21
63,883
b. The error in cheque #93, for Utilitles Expense, resulted from the bank Incorrectly debiting our account for $99; the correct amount
entered in the accounting records Is $199.
c. The bank statement showed interest expense of $47; there was no other Interest.
d. The bank debited our account…
arrow_forward
Question 10 of 18
Which of the following increases the reported receivables in the financial statements?
Select the correct response:
a credit balance in an account payable
offsetting a credit balance in an account receivable
O adjustment to eliminate a debit balance in account payable
a credit balance in an allowance account
< Previous
arrow_forward
None
arrow_forward
Accounts Receivable
Beg. Bal. $ 187
18
150
6
64
15
19
End. Bal. $ ?
Which of the following is an accurate description of the transactions effecting Accounts Receivable?
Group of answer choices
A. Customers of Careful charged more on their accounts than they paid.
B. Customers of Careful paid more on their accounts than they charged.
C. Careful incurred more debt than if paid off.
D. Carefeul paid off debt.
the ending balance of Accounts Receivable for Careful is:
Group of answer choices
A. $401 debit
B. $343 debit
C. $343 credit
D. $ 58 credit
arrow_forward
Questions and Bank Reconciliation Problem
Question 26 of 27
50 / 100
View Policies
Show Attempt History
Current Attempt in Progress
The following information pertains to Concord Corporation.
1.
Cash balance per bank, July 31, $7,763.
2.
July bank service charge not recorded by the depositor $37.
3.
Cash balance per books, July 31, $7,784.
4.
Deposits in transit, July 31, $1,750.
5.
The bank collected $1,166 in July for Concord through electronic funds transfer. The collection has not been recorded by
Concord.
6.
Outstanding checks, July 31, $600.
(a)
Your answer is correct.
Drena o o
rOcenciliotionat luly 21 (List itoms th
ease coch halance fret Docencile ca
halo
II
arrow_forward
Account Title
Beginning Balance
Ending Balance
Accounts receivable
$28,600
$40,500
Allowance for doubtful accounts
1,760
2,160
Notes receivable
47,200
47,200
Interest receivable
930
4,234
The note receivable has a two-year term with a 7.00 percent interest rate. What amount of interest revenue was recognized during the period? How much cash was collected from interest?
Please explain how you find the cash received for interest
arrow_forward
Question 11
What's used to validate the bank and credit card account balances on
a balance sheet?
Trial balance
Transaction Detail report filtered by account
Reconciliation reports
O Cash flow projection
Statement of Changes in Financial Position
arrow_forward
A bank statement
☐ is a bill from the bank for services rendered
☐
lets a depositor know the financial position of
the bank as of a certain date
О shows the activity which increased or
О
decreased the depositor's account balance
is a credit reference letter written by the
depositor's bank
arrow_forward
The following selected transactions are from Garcia Company.
Year 1
Dec. 16 Accepted a $20,400, 60-day, 12% note in granting Rita Griffin a time extension on his past-due account receivable.
31 Made an adjusting entry to record the accrued interest on the Griffin note.
Year 2
Feb. 14 Received Griffin's payment of principal and interest on the note dated December 16.
2 Accepted a $9,000, 6%, 90-day note in granting a time extension on the past-due account receivable from Wright Co.
17 Accepted a $7, 200, 30-day, 10% note in granting Wang Lee a time extension on her past-due account receivable.
Mar.
Apr. 16
May 31 Wright Co. dishonored its note.
Aug. 7 Accepted a $22,000, 90-day, 10% note in granting a time extension on the past-due accourt receivable of Collins Co.
Lee dishonored her note.
3 Accepted a $11,400, 60-day, 10% note in granting Maria Gonzalez a time extension on his past-due account receivable.
2 Received payment of principal plus interest from Gonzalez for the September 3…
arrow_forward
Bank Reconciliation and Related Journal Entries
The book balance in the checking account of Lyle's Salon as of November 30 is $3,277.77. The bank statement shows an ending balance of
$2,109.00. By examining last month's bank reconciliation, comparing the deposits and checks written per books and per bank in November, an
noting the service charges and other debit and credit memos shown on the bank statement, the following were found:
a. An ATM withdrawal of $150.00 on November 18 by Lyle for personal use was not recorded on the books.
b. A bank debit memo issued for an NSF check from a customer of $19.20.
c. A bank credit memo issued for interest of $20.00 earned during the month.
d. On November 30, a deposit of $1,186.00 was made, which is not shown on the bank statement.
e. A bank debit memo issued for $16.80 for bank service charges.
f. Checks No. 549, 561, and 562 for the anounts of $181.00, $24.00, and $9.50, respectively, were written during November but have not yet
been received…
arrow_forward
Required information
Knowledge Check 01
The company's bank reconciliation at June 30 included interest earned in the amount of $150. Complete the necessary
journal entry by selecting the account names and dollar amounts from the drop-down menus.
View transaction list
Journal entry worksheet
<
1
The company's bank reconciliation at June 30 included interest earned in the
amount of $150. Complete the necessary journal entry by selecting the
account names and dollar amounts from the drop-down menus.
Note: Enter debits before credits.
Date
June 01
FRAN
FA
O
General Journal
< Prev
144
19
► 11
Debit
of 19
H
Credit
Next
+
prt sc
←
delete
backspac
arrow_forward
Provide correct answer general Accounting question
arrow_forward
Question 9
Which one of the following accounts appears on
the credit side of a pre-adjustment trial balance?
Select one:
a. Fixed deposit
b. Interest on loan
c. Bank overdraft
d. Debtors control
arrow_forward
Please kindly help me with the following question
arrow_forward
ro.14 Defining common receivalles terms
Metch the terms with their correct definition.
Lear
Definitions
Terms
a. The party to a credit transaction who takes on an
obligation/payable.
b. The party who receives a receivable and will collect cash in
1. Accounts receivable
2. Other receivables
3. Debtor
the future.
C. A written promise to pay a specified amount of money at a
particular future date.
4. Notes receivable
5. Maturity date
d. The date when the note receivable is due.
e. A miscellaneous category that includes any other type of
receivable where there is a right to receive cash in the
future.
6. Creditor
f. The right to receive cash in the future from customers for
goods sold or for services performed.
arrow_forward
Emporium bank lends money to a customer on a six month note. What journal entry does the bank prepare?
A. Debit note receivable and credit cash
B. Debit cash and credit note receivable
C: debit note receivable and credit service revenue
D. Debit cash and credit note payable
arrow_forward
1. A note receivable due in 18 months is listed on the balance sheet under the caption
A. current assets
B. investments
C. long-term liabilities
D. fixed assets
2. Two methods of accounting for uncollectible accounts are the
A. direct write-off method and the accrual method
B. direct write-off method and the allowance method
C. allowance method and the accrual method
D. allowance method and the net realizable method
3. What is the type of account and normal balance of Allowance for Doubtful Accounts?
A. contra asset, debit
B. asset, credit
C. contra asset, credit
D. asset, debit
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Related Questions
- answer correct this time with all work thanksarrow_forwardCANDY'S CLEANING SERVICES Bank Reconciliation April 30, 2020 $33,452 Book balance Bank balance $28,934 Add: Deduct: Interest $47 NSF, customer Bonne 412 Error Chq #93 99 146 $29,080 Outstanding cheques: Deduct: #879 $2,600 Service Charge 40 #100 1,400 4,412 Adjusted bank balance $29,040 Adjusted book balance $29,040 In comparing the bank reconciliation to the Cash account In the general ledger, you notice a problem. You investigate further and come up with some additional Informatlon as follows: a. The Cash account in the general ledger showed the followling: Cash Acct. No. 101 Date Explanation PR Debit Credit Balance 2020 March 31 Balance 28,934 ৪4,934 21,051 April 30 CR16 56,000 30 CD21 63,883 b. The error in cheque #93, for Utilitles Expense, resulted from the bank Incorrectly debiting our account for $99; the correct amount entered in the accounting records Is $199. c. The bank statement showed interest expense of $47; there was no other Interest. d. The bank debited our account…arrow_forwardQuestion 10 of 18 Which of the following increases the reported receivables in the financial statements? Select the correct response: a credit balance in an account payable offsetting a credit balance in an account receivable O adjustment to eliminate a debit balance in account payable a credit balance in an allowance account < Previousarrow_forward
- Nonearrow_forwardAccounts Receivable Beg. Bal. $ 187 18 150 6 64 15 19 End. Bal. $ ? Which of the following is an accurate description of the transactions effecting Accounts Receivable? Group of answer choices A. Customers of Careful charged more on their accounts than they paid. B. Customers of Careful paid more on their accounts than they charged. C. Careful incurred more debt than if paid off. D. Carefeul paid off debt. the ending balance of Accounts Receivable for Careful is: Group of answer choices A. $401 debit B. $343 debit C. $343 credit D. $ 58 creditarrow_forwardQuestions and Bank Reconciliation Problem Question 26 of 27 50 / 100 View Policies Show Attempt History Current Attempt in Progress The following information pertains to Concord Corporation. 1. Cash balance per bank, July 31, $7,763. 2. July bank service charge not recorded by the depositor $37. 3. Cash balance per books, July 31, $7,784. 4. Deposits in transit, July 31, $1,750. 5. The bank collected $1,166 in July for Concord through electronic funds transfer. The collection has not been recorded by Concord. 6. Outstanding checks, July 31, $600. (a) Your answer is correct. Drena o o rOcenciliotionat luly 21 (List itoms th ease coch halance fret Docencile ca halo IIarrow_forward
- Account Title Beginning Balance Ending Balance Accounts receivable $28,600 $40,500 Allowance for doubtful accounts 1,760 2,160 Notes receivable 47,200 47,200 Interest receivable 930 4,234 The note receivable has a two-year term with a 7.00 percent interest rate. What amount of interest revenue was recognized during the period? How much cash was collected from interest? Please explain how you find the cash received for interestarrow_forwardQuestion 11 What's used to validate the bank and credit card account balances on a balance sheet? Trial balance Transaction Detail report filtered by account Reconciliation reports O Cash flow projection Statement of Changes in Financial Positionarrow_forwardA bank statement ☐ is a bill from the bank for services rendered ☐ lets a depositor know the financial position of the bank as of a certain date О shows the activity which increased or О decreased the depositor's account balance is a credit reference letter written by the depositor's bankarrow_forward
- The following selected transactions are from Garcia Company. Year 1 Dec. 16 Accepted a $20,400, 60-day, 12% note in granting Rita Griffin a time extension on his past-due account receivable. 31 Made an adjusting entry to record the accrued interest on the Griffin note. Year 2 Feb. 14 Received Griffin's payment of principal and interest on the note dated December 16. 2 Accepted a $9,000, 6%, 90-day note in granting a time extension on the past-due account receivable from Wright Co. 17 Accepted a $7, 200, 30-day, 10% note in granting Wang Lee a time extension on her past-due account receivable. Mar. Apr. 16 May 31 Wright Co. dishonored its note. Aug. 7 Accepted a $22,000, 90-day, 10% note in granting a time extension on the past-due accourt receivable of Collins Co. Lee dishonored her note. 3 Accepted a $11,400, 60-day, 10% note in granting Maria Gonzalez a time extension on his past-due account receivable. 2 Received payment of principal plus interest from Gonzalez for the September 3…arrow_forwardBank Reconciliation and Related Journal Entries The book balance in the checking account of Lyle's Salon as of November 30 is $3,277.77. The bank statement shows an ending balance of $2,109.00. By examining last month's bank reconciliation, comparing the deposits and checks written per books and per bank in November, an noting the service charges and other debit and credit memos shown on the bank statement, the following were found: a. An ATM withdrawal of $150.00 on November 18 by Lyle for personal use was not recorded on the books. b. A bank debit memo issued for an NSF check from a customer of $19.20. c. A bank credit memo issued for interest of $20.00 earned during the month. d. On November 30, a deposit of $1,186.00 was made, which is not shown on the bank statement. e. A bank debit memo issued for $16.80 for bank service charges. f. Checks No. 549, 561, and 562 for the anounts of $181.00, $24.00, and $9.50, respectively, were written during November but have not yet been received…arrow_forwardRequired information Knowledge Check 01 The company's bank reconciliation at June 30 included interest earned in the amount of $150. Complete the necessary journal entry by selecting the account names and dollar amounts from the drop-down menus. View transaction list Journal entry worksheet < 1 The company's bank reconciliation at June 30 included interest earned in the amount of $150. Complete the necessary journal entry by selecting the account names and dollar amounts from the drop-down menus. Note: Enter debits before credits. Date June 01 FRAN FA O General Journal < Prev 144 19 ► 11 Debit of 19 H Credit Next + prt sc ← delete backspacarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education