Aging accounts receivable is the practice of sorting the invoices customers still owe you by how long they have been outstanding, grouped into date ranges such as current, 1 to 30, 31 to 60, 61 to 90 and over 90 days, so you can see how much of your money is overdue and by how much. The report this produces is the accounts receivable aging report, or AR aging report. It is one of the most-used reports in any finance function, because it turns a single receivables total into a clear map of risk.
The idea rests on one reliable truth: the longer an invoice stays unpaid, the less likely it is to be paid at all. Aging your receivables makes that visible at a glance, so you can chase the right accounts in the right order, set realistic provisions for losses, and spot a cash flow problem forming weeks before it hits your bank balance.
Invoices sorted by age.Receivables are bucketed by how overdue they are, usually in 30 day bands.
The aging report is the output.It shows who owes you, how much, and how late, all on one page.
Older equals riskier.The further right a balance sits, the less likely you are to collect it in full.
An AR aging report lists each customer down the side and the age buckets across the top, then totals each column. It tells you not just that you are owed money, but exactly who owes it and how overdue each balance is. Here is a worked example for a business owed 80,000 in total.
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Northwind Ltd | 15,000 | 0 | 0 | 0 | 0 | 15,000 |
| Harbour Co | 9,000 | 10,000 | 0 | 0 | 0 | 19,000 |
| Vale Group | 0 | 5,000 | 11,000 | 0 | 0 | 16,000 |
| Orion Trades | 0 | 0 | 4,000 | 7,000 | 0 | 11,000 |
| Pike Supplies | 0 | 0 | 0 | 9,000 | 10,000 | 19,000 |
| Total | 24,000 | 15,000 | 15,000 | 16,000 | 10,000 | 80,000 |
Read across each row, then down to the totals. Of the 80,000 owed, only 24,000 is current; the other 56,000 is overdue and spread across the buckets. Northwind is no concern. Harbour and Vale need a routine chase. Orion and Pike are the worry, and Pike alone has 10,000 sitting past 90 days, the balance most likely to become a write-off. The report turns one big number into a ranked to-do list. You can build the same view from your own ledger with the AR aging analysis calculator.
Each aging bucket is a band of how overdue an invoice is, and each calls for a different response. The standard bands are current, 1 to 30 days, 31 to 60, 61 to 90, and over 90, though you can set them to fit your own payment terms. As debt ages, the probability of collecting it falls, so each bucket carries more risk than the one before.
| Bucket | Risk | What to do |
|---|---|---|
| Current | Within terms | Nothing beyond your usual reminders. Not yet due. |
| 1 to 30 days | Low | The gentle-nudge zone. A polite reminder usually clears it. |
| 31 to 60 days | Rising | A firmer follow-up and a phone call. |
| 61 to 90 days | High | Escalate, pause further credit and consider a payment plan. |
| Over 90 days | Severe | A final demand, a candidate for collections, and the band that feeds your bad debt provision. |
The same logic, under different names, is covered in aging analysis and in aged debt analysis, the term more common in the UK and Australia.
To age your accounts receivable, take every unpaid invoice, work out how many days past its due date it is, drop it into the matching bucket, then total each bucket by customer and overall. The steps are simple, and knowing them is what lets you read the report critically rather than just glance at it.
Pull every unpaid invoice, not paid ones. These are the balances you are aging.
Compare today's date to the due date, not the invoice date, since aging measures lateness against terms.
Current if not yet due, then the 30 day bands as each invoice ages.
Total each customer's invoices so you can see individual exposure.
Sum every bucket so you can see the shape of the whole ledger at a glance.
Accounting systems like Xero and QuickBooks generate this report automatically, but the logic underneath is exactly this. The closely related aging schedule is simply the table format that holds these totals.
An aging report only earns its keep if it drives action, so the goal is to work it, not file it. Run it on a fixed rhythm, monthly at least and weekly if your volumes are high, and compare it period to period rather than reading it once.
Watch the trend, not the snapshotBalances migrating right, from current into the 30 and 60 day columns, mean collections are slipping even when the total looks flat.
Sort by oldest bucketBring the highest-risk balances to the top and chase by priority, not alphabetically.
Set clear escalation triggersFor example, anything past 60 days gets a call and anything past 90 a final notice, so nothing drifts.
Feed it back into credit decisionsA customer who lives in your late buckets is one whose limit or terms deserve a review before you extend more.
Most of this cadence is repetitive, which is why it rewards automation. AR reporting in Paidnice keeps your aging picture live, and automated reminders chase each bucket on schedule so balances are worked before they harden into bad debt.
Aging your accounts receivable is the difference between knowing you are owed money and knowing whether you will actually get it. A single receivables total hides everything that matters: a business owed 80,000 that is mostly current is in fine shape, while one owed the same 80,000 mostly past 90 days is heading for a cash crunch and a string of write-offs. The age profile is what separates the two.
It is also your earliest warning system, because debt ages gradually and visibly, so a worsening aging report flags trouble long before it reaches the bank. For any business that sells on credit, it underpins protecting cash flow, setting honest bad debt provisions and deciding who to keep selling to on terms. Read and acted on regularly, it keeps the gap between invoice and payment short, which is the whole 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
