Accounts
Receivable Aging Schedule
The accounts receivable aging schedule is a listing of the customers
making up your total accounts
receivable balance. Most businesses prepare an accounts receivable
aging schedule at the end of each month. Analyzing
your accounts receivable aging schedule may help you identify
potential cash flow problems.
The typical accounts receivable aging schedule consists of 6 columns:
- Column 1 lists the name of each customer with an accounts receivable
balance.
- Column 2 lists the total amount due from the customers listed in
Column 1.
- Column 3 is the "current column." Listed in this column
are the amounts due from customers for sales made during the current
month.
- Column 4 shows the unpaid amount due from customers for sales made
in the previous month. These are the customers with accounts 1 to 30
days past due.
- Column 5 lists the amounts due from customers for sales made two
months prior. These are customers with accounts 31 to 60 days past
due.
- Column 6 lists the amount due from customers with accounts over 60
days past due.
The following is a sample accounts receivable aging schedule from Roth
Office Supply:
Accounts Receivable Aging Report
Roth Office Supply
October 31, 2000 |
Customer Name |
Total
Accts.
Rec. |
Current |
1-30
Days
Past
Due |
31-60
Days
Past
Due |
Over
60 Days
Past
Due |
Quick Computer Supply |
$1,600 |
$ 300 |
$ 500 |
$ 500 |
$ 300 |
Kitchens by Voels |
2,800 |
2,800 |
---- |
---- |
---- |
Jansa's Sport Stores |
1,000 |
1,000 |
---- |
---- |
---- |
Bradley Farms, Inc. |
1,600 |
---- |
1,600 |
---- |
---- |
TrueBrew Unlimited |
2,000 |
1,100 |
500 |
400 |
---- |
Enneking Enterprises |
400 |
---- |
400 |
---- |
---- |
Hove & Sanborn LLC |
600 |
600 |
---- |
---- |
---- |
J. Siegel, CPA |
1,200 |
1,200 |
---- |
---- |
---- |
Total |
$11,200 |
$7,000 |
$3,000 |
$ 900 |
$ 300 |
|
If you're using one of the many available accounting
software packages for billing and accounts receivable
processing, check it first to see if it prepares the aging
schedule automatically. Most accounting software packages
will prepare an accounts receivable aging schedule at the
touch of a button!
|
|
|