An aging schedule is a table that sorts a company's outstanding receivables by how long they have been unpaid, grouping each invoice into date ranges such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days. It turns a single receivables total into a breakdown by age, so you can see at a glance how much is owed, how overdue it is, and which customers are behind. It is also called an accounts receivable aging report or an aged receivables report.
The schedule is the standard format finance teams use to read the health of their receivables. The same idea applies on the payables side too, where an aging schedule of what you owe suppliers helps you plan outgoing payments. On the receivables side, its job is to show where your money is stuck and to point your collection effort at the invoices that need it most.
A table sorted by age.Receivables grouped into date ranges so you see how overdue each balance is.
Customers down, ages across.Each row is a customer, each column an age band, with totals along the bottom.
It ranks your collections.The oldest balances rise to the top, telling you who to chase first.
An aging schedule lists each customer down the side and the age bands across the top, with a row of totals at the foot. Here is a worked example for a business owed 60,000 in total.
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Ltd | 12,000 | 0 | 0 | 0 | 0 | 12,000 |
| Bowen & Co | 6,000 | 8,000 | 0 | 0 | 0 | 14,000 |
| Crest Group | 0 | 4,000 | 9,000 | 0 | 0 | 13,000 |
| Delta Trades | 0 | 0 | 3,000 | 5,000 | 0 | 8,000 |
| Essex Supplies | 0 | 0 | 0 | 6,000 | 7,000 | 13,000 |
| Total | 18,000 | 12,000 | 12,000 | 11,000 | 7,000 | 60,000 |
Read it across, then down. Of the 60,000 owed, 18,000 is current and 42,000 is overdue, spread across the bands. The bottom row is the summary view your management accounts use; the customer rows tell you exactly who to call. Essex alone has 7,000 past 90 days, the balance most at risk. You can build this exact layout from your own ledger with the accounts receivable aging analysis calculator.
Preparing an aging schedule is a short, repeatable routine. Most accounting systems generate it for you, but knowing the steps means you can read it properly and rebuild it by hand if you ever need to.
Pull all unpaid invoices from your ledger, with the customer, invoice date, due date and amount outstanding.
For each invoice, count the days between its due date and today. That number decides which band it falls into.
Use the standard current, 1 to 30, 31 to 60, 61 to 90 and 90 plus, or adjust them to match your payment terms.
Place every balance in the column for its age, grouped under the customer who owes it.
Sum each customer across, and each age band down, so the grand total matches your receivables balance.
The one number to check is the grand total: it should tie back exactly to the receivables figure in your ledger and on your balance sheet. If it does not, an invoice or a payment has been missed. Done by hand this is fiddly and quickly out of date, which is why most teams let their accounting system or AR reporting produce a live schedule instead.
Each band signals a different level of risk, because the longer an invoice goes unpaid, the less likely it is to ever be collected. Reading the schedule this way converts a column of numbers into a clear order of who to chase and how hard.
Nothing needed beyond your normal reminders. This balance is not yet due.
A polite nudge usually works. A short reminder is all most of these need.
A more direct message and a phone call are due at this point.
Pause further credit and consider a payment plan to recover the balance.
A candidate for a final demand, an overdue receivables escalation or handing to collections. This band drives your bad debt provision.
An aging schedule is the table itself; aging analysis is the act of interpreting it; and aged debt analysis is the same thing under its British and Commonwealth name. In practice the terms overlap heavily, and the layout, the maths and the purpose are identical; only the label changes with geography.
| Term | What it is | Where you hear it |
|---|---|---|
| Aging schedule | The structured report itself: the rows and columns of receivables grouped by age. | The standard US wording for the table. |
| Aging analysis | What you do with the table: spotting trends, ranking risk and deciding actions. | The act of interpreting the schedule. |
| Aged debt analysis | The very same technique, since customers who owe money are called debtors. | The UK, Australian and New Zealand name. |
An aging schedule should age each invoice from its due date, not its invoice date, or the report will overstate how overdue your receivables really are. This is the mistake that trips up most people building one by hand. If you sell on 30-day terms and age from the invoice date, an invoice that is perfectly current looks 30 days old straight away, and the whole schedule slides one band too far right. Some systems age from the invoice date by default, so check which basis yours uses before reading too much into the numbers. The version that drives good decisions ages from the due date, because that is the point at which a balance is genuinely late. Get this setting right and the schedule tells the truth; get it wrong and you will chase customers who are not actually overdue.
An aging schedule is only useful if it is current, so run it on a fixed rhythm rather than only when cash feels tight. Monthly is the minimum, weekly if your volumes are high. The real value comes from comparing one period to the next, because money quietly migrating from the current column into the 30 and 60 day bands is the early warning that your collections are slipping, and it only shows up when you read the schedule as a trend.
The aging schedule is the difference between knowing you are owed money and knowing whether you will actually collect it. A single receivables total hides everything that matters: 60,000 that is almost all current is healthy, while the same 60,000 sitting mostly past 90 days is a cash crunch in the making. The schedule is what tells the two apart, and because debt ages gradually, a worsening report warns you weeks before the problem reaches your bank balance. It also feeds straight into the accounts. The common way to estimate bad debt is to apply a rising percentage to each band, a small allowance against current balances and a large one against the over-90 column, then add them up for a provision grounded in the real shape of your ledger. Run and acted on regularly, the aging schedule keeps the gap between invoice and payment short, which is the entire job of accounts receivable.
Don't let these critical mistakes hurt your
collections - See how to fix them, today!
Request an AI summary of Paidnice
