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, 2011
|
| Customer Name |
Total
Accounts
Receivable |
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 and 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!
|
|