Accounts receivable aging report: how to read & use it
An accounts receivable aging report groups everything your customers owe you by how overdue it is — it's the single fastest way to see which invoices need chasing first and how much of your cash is at risk. Read this way, a one-page report tells you exactly where to spend your follow-up time, before a small delay quietly turns into a bad debt.
What is an accounts receivable aging report?
An accounts receivable (AR) aging report is a snapshot of every unpaid invoice you're owed, sorted into columns by how long each one has been outstanding. Instead of one lump “receivables” figure, it breaks the balance into age bands — typically current, 1–30, 31–60, 61–90, and 90+ days — so you can see the shapeof what you're owed, not just the size.
Two businesses can be owed the same €30,000 and be in completely different health. If almost all of it is current, you're fine. If a chunk has drifted past 60 days, that's cash you can't count on and a collections problem that's already underway. The aging report is what makes that difference visible.
What are the standard AR aging buckets?
The standard AR aging buckets are current (not yet due), 1–30 days, 31–60 days, 61–90 days, and 90+ days overdue. Each band counts days past the due date, and the further right an invoice lands, the lower the chance it's paid in full. The bands turn “a bit late” into a precise, actionable signal.
| Bucket | What it means | Risk level |
|---|---|---|
| Current | Invoiced but not yet past its due date. Nothing wrong here — it's simply outstanding. | None to low |
| 1–30 days | Just slipped past the due date. Almost always an oversight rather than a refusal. | Low |
| 31–60 days | Late enough that a reminder has clearly been missed or ignored. Worth a direct ask. | Moderate |
| 61–90 days | Seriously overdue. Either there's a dispute, a cash-flow problem, or you're being deprioritised. | High |
| 90+ days | Long overdue. Collection rates fall sharply here, and some of it may become bad debt. | Very high |
Some teams use 30-day bands all the way out (90–120, 120+) or split out a separate “1–7 days” nudge zone. The exact boundaries matter less than using the same ones every month so the trend is comparable.
A sample aging report, read line by line
A sample aging report lists each customer across the buckets, with a row total per customer and a column total per bucket. Here's a small one for a service firm owed €30,000 in total. Read it both ways: down the columns to size your risk, and across each row to understand a single customer.
| Customer | Current | 1–30 | 31–60 | 61–90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Studio | €4,200 | €1,800 | €0 | €0 | €0 | €6,000 |
| Berg Consulting | €0 | €2,500 | €3,000 | €0 | €0 | €5,500 |
| Cobalt Media | €9,000 | €0 | €0 | €0 | €0 | €9,000 |
| Delft Logistics | €0 | €0 | €1,200 | €2,400 | €3,500 | €7,100 |
| Estell Design | €1,500 | €0 | €0 | €0 | €900 | €2,400 |
| Totals | €14,700 | €4,300 | €4,200 | €2,400 | €4,400 | €30,000 |
How to read it:
- Most of the money is healthy.€14,700 of the €30,000 is current and another €4,300 is only 1–30 days late. Roughly two-thirds of the book isn't a worry yet.
- The risk is concentrated.€4,400 sits in 90+ and €2,400 in 61–90 — and almost all of it is one customer, Delft Logistics (€2,400 + €3,500 long overdue on a €7,100 balance). That's your first phone call, not your biggest invoice.
- Big isn't the same as urgent.Cobalt Media owes the most (€9,000) but it's all current — no action needed beyond a courtesy reminder before it's due.
- Watch the small, old balances too.Estell's €900 in 90+ is easy to forget because it's tiny, but old debt rarely fixes itself. Decide whether to chase it firmly or write it off, not to ignore it.
That's the whole value of the format: in about thirty seconds it told you who to call first, which big number to leave alone, and where money is genuinely at risk.
What each bucket tells you to do
Each aging bucket maps to a specific follow-up action: current invoices get a pre-due reminder, 1–30 a friendly chase, 31–60 a firm follow-up and a call, 61–90 a final demand, and 90+ an escalation decision. Letting the bucket — not your mood — set the response keeps every customer on the same fair, consistent process.
| Bucket | What to do |
|---|---|
| Current | Send a short courtesy reminder a few days before the due date. This prevents more lateness than any after-the-fact chase. |
| 1–30 days | A friendly first reminder. Assume an oversight: restate the invoice, amount, and an easy way to pay or confirm a date. |
| 31–60 days | A firmer written follow-up plus a phone call. Ask directly for a payment date and surface any dispute now. |
| 61–90 days | A formal final demand with a clear deadline, sent and dated, warning that recovery steps follow if it lapses. |
| 90+ days | Escalate: statutory interest and recovery costs, a payment plan, or external collections — and decide a write-off threshold. |
The wording for the first four steps is the hard part, so we've made it copy-and-paste: see our payment reminder email templates for each stage, and how a dunning process works end to end for fitting them into one repeatable sequence.
How an aging report connects to DSO and bad-debt risk
Aging and DSO measure the same thing from two angles: the aging report shows where overdue money sits, while Days Sales Outstanding turns it into a single average collection time. As balances drift into the older buckets, your DSO climbs — and a growing right-hand tail is the clearest early warning of bad-debt risk.
Watch the mixover time, not just one month's total. If the share of receivables in 61–90 and 90+ is creeping up, collections are slipping even if the headline figure looks stable — and that trend feeds straight into a rising DSO. The aging report tells you which customers are dragging the average, so you can act before it shows up in your cash position.
- Use the buckets to spot the specific accounts pushing your average up, then work the largest and oldest first. Our guide to reducing DSO covers the levers in order.
- Pair aging with a turnover view to see how many times a year you collect your whole book — the accounts receivable turnover ratio is the companion metric.
- Put a number on your own collection speed with the DSO calculator, then re-run it monthly to confirm the aging mix is moving the right way.
How to build and maintain one
You can build an aging report straight from your accounting software or in a spreadsheet. Most tools — Xero, QuickBooks, Sage and similar — have a built-in “aged receivables” report you can run in seconds. The work isn't producing it; it's running it regularly and acting on what it shows.
From accounting software
Open the aged-receivables or debtors report, set the “as of” date to today, and choose your bucket widths (the 30-day bands above are the default). Sort by the oldest bucket or by total to put the riskiest accounts at the top. This is the fastest route and stays accurate as invoices are paid.
From a spreadsheet
If your invoices live in a sheet, add a column for days overdue (today's date minus the due date), then bucket each invoice with a formula and total the columns. It works, but it's manual: you have to rebuild it every time you want a current view, and stale numbers are worse than none.
The real limitation of either approach is the same: a report tells you who to chase, but it doesn't chase anyone.It's a static photo. The follow-up — the reminders, the calls, the dated demands — still depends on someone reading the report and reliably acting on every line, every week. That's exactly where consistency tends to break down.
The bottom line
An AR aging report is the most efficient way to read your receivables: group every unpaid invoice by how overdue it is, then read down the columns to size your risk and across each row to understand a customer. Match each bucket to a fixed action — a pre-due reminder, a friendly chase, a firm follow-up and call, a final demand, then escalation — and watch the older buckets as your early warning for rising DSO and bad debt.
Run it at least monthly, act on the oldest balances first, and remember the report's one blind spot: it shows the problem but doesn't solve it. Getting paid still comes down to whether the follow-up actually happens, consistently, on every line — which is the part worth systematising.
Frequently asked questions
What is an accounts receivable aging report?
It's a snapshot of every unpaid invoice you're owed, sorted into columns by how long each one has been outstanding — typically current, 1–30, 31–60, 61–90, and 90+ days. Instead of one lump receivables figure, it shows the shape of what you're owed, so you can see which invoices need chasing first and how much cash is genuinely at risk.
What are the standard AR aging buckets?
The standard buckets are current (not yet due), 1–30 days, 31–60 days, 61–90 days, and 90+ days past the due date. Some teams extend the bands further out (90–120, 120+) or add a short 1–7 day nudge zone. The exact boundaries matter less than using the same ones every month so the trend stays comparable.
How do you read an aging report?
Read it both ways. Down the columns, the totals in the older buckets show how much of your cash is at risk. Across each row, you see a single customer's full position. The goal is to find concentrated risk — often one or two accounts with old balances — rather than to assume the largest invoice is the most urgent.
What is an aging report used for?
It's used to prioritise collections, manage cash flow, and flag bad-debt risk early. It tells you which customers to chase first and in what order, feeds into your DSO and bad-debt provisions, and gives a clear, dated record of who owes what. In short, it turns a vague sense that some invoices are late into a precise, actionable list.
How often should I run an aging report?
At least monthly, and ideally weekly if late payment is a recurring problem. Receivables change constantly as invoices are raised and paid, so a report more than a week or two old can send you chasing money that's already in. Running it on a fixed schedule also lets you compare the bucket mix over time and catch collections slipping before it hits your cash position.