What is an aging of accounts receivable schedule?
Christopher Davis
Updated on February 23, 2026
An aging schedule is an accounting table that shows a company’s accounts receivables, ordered by their due dates. It’s a breakdown of receivables by the age of the outstanding invoice, along with the customer name and amount due.
How do I make an Ageing schedule?
The credit period for this firm is 30 days, so the second line of the aging schedule is 11-30 days….An Example of an Aging Schedule and How to Analyze it.
| Age of Account | Amount | % Total Value of Receivables |
|---|---|---|
| 11-30 days | 40,000 | 40% |
| 31-60 days | 20,000 | 20% |
| 61-90 days | 10,000 | 10% |
| Over 90 days | 10,000 | 10% |
How do you calculate debtors Ageing?
Finally, the debtor days ratio calculation is done by dividing the average accounts receivable by the total annual sales and then multiply by 365 days. Receivable Days Formula can also be calculated by dividing the average accounts receivable by the average daily sales.
How do you read an AR aging report?
The accounts receivable aging report will list each client’s outstanding balance. It is then sorted into columns such as: Current, 1-30 days past due, 31-60 days past due, 61-90 days past due, 91-120 days past due, and 120+ days past due.
What does the aging schedule on accounts receivable mean?
It’s called aging schedule because the accounts receivables are broken down into age categories. It indicates the total accounts receivable balance that have been outstanding for specified periods of time. The aging schedule lists accounts receivable that are less than 30 days old, less than 45 days old or more/less than 90 days old.
What do you need to know about an aging schedule?
What is an Aging Schedule. An aging schedule is an accounting table that shows the relationship between a company’s bills and invoices and their respective due dates. Often created by accounting software, aging schedules can be produced for both accounts payable and accounts receivable to help a company see whether it is current on its…
How many days past due is an aging account?
An aging schedule often categorizes accounts as current (under 30 days), 1-30 days past due, 30-60 days past due, 60-90 days past due and more than 90 days past due.
Why are there so many aging receivables on my credit report?
If the aging report shows a lot of older receivables, it means that the company’s collection practices are weak. Some customers tend to not pay their invoices when they are due, and they may wait until the second and third invoice reminders to settle their outstanding balance.
