Premium
Membership
Free
Membership
Managing Your Business Finances Managing Your Cash Flow Analyzing Your Cash Flow Accounts Receivable and Cash Flow Accounts Receivable Aging Schedule
Share
this!
Print
Back
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, 2009 |
|||||
|---|---|---|---|---|---|
| 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 |
|
