An accounts receivable aging report lists every unpaid invoice, grouped by how long it has been outstanding: typically current, 1 to 30 days past due, 31 to 60, 61 to 90, and over 90. Read it down the columns to see how much of your money is late, across each row to see which customers are slipping, and week against week to see whether things are getting better or worse.
An accounts receivable aging report is a table of a business's open customer invoices, sorted by customer and grouped into time buckets based on how many days each invoice is past its due date or invoice date. It shows who owes money, how much, and for how long, so collection effort can go where it matters most.
A sample aging report
Here is a hypothetical report for a staffing agency that bills clients weekly on net 30 terms. It is aged by due date, so "current" means not yet due.
| Customer | Current | 1–30 | 31–60 | 61–90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Regional hospital | $28,000 | $14,000 | – | – | – | $42,000 |
| Logistics warehouse | $18,500 | $6,200 | $3,100 | – | – | $27,800 |
| Food processing plant | $9,000 | $9,000 | $8,400 | – | – | $26,400 |
| Hotel group | – | $5,600 | $5,600 | $5,600 | $2,800 | $19,600 |
| Event company | – | – | – | – | $7,500 | $7,500 |
| Call center | $6,300 | – | – | – | – | $6,300 |
| Property manager | $4,200 | – | – | – | – | $4,200 |
| Total | $66,000 | $34,800 | $17,100 | $5,600 | $10,300 | $133,800 |
| Share of total | 49% | 26% | 13% | 4% | 8% | 100% |
Read down the columns: how much is late
Start with the bottom row. Just under half of this agency's receivables are current, so slightly more than half ($67,800) is past due. Most of that is in the first bucket, where a reminder usually does the job. The $15,900 in the two oldest buckets is the part to worry about: it is 12% of the book, and the older an invoice gets, the less likely it is to be paid in full.
Totals by bucket also feed your other numbers. The receivables total drives days sales outstanding, and the current column gives you best possible DSO, the figure you would have if nobody paid late.
Read across the rows: which customers are slipping
The bucket totals tell you how big the problem is. The rows tell you what kind of problem it is. Four patterns in the sample are worth recognizing, because each calls for a different response.
Late but steady
The regional hospital has $14,000 just past due and nothing older. Large institutions often pay on a fixed cycle that runs a little behind your terms. That is a timing issue more than a credit risk, and it may be worth asking their AP team when their payment runs happen, so you can time invoices to land before the cutoff.
A creeping balance
The food processing plant has roughly equal amounts in three consecutive buckets. Two months ago it was paying on time. A customer whose overdue balance grows a little each month is often under strain, or has a dispute nobody has mentioned. Call this week, before the oldest invoices age further.
Paying one invoice at a time
The hotel group has the same $5,600 in each bucket. It pays something each month, but always the oldest invoice, so it never catches up. Its balance has been stuck at about three and a half months of billing, and nothing is current only because the agency stopped sending new staff there last month. A payment plan that clears the arrears on a schedule, alongside paying new invoices on time, usually works better than a series of reminders.
All in the oldest bucket
The event company's entire balance is over 90 days. A customer that pays nothing at all is either disputing the invoice or no longer able to pay. Find out which. If it is a dispute, resolve it; if the customer has stopped responding, move to the formal steps in how to collect unpaid invoices.
What each aging bucket usually signals
| Bucket | What it usually means | Typical action |
|---|---|---|
| Current | Not yet due | Pre-due reminder on larger invoices |
| 1–30 days | Missed due date, often an oversight or a payment cycle | Automated reminder, then a past due invoice email |
| 31–60 days | Something is holding the invoice: a dispute, a missing PO, cash strain | Phone call to the AP contact; ask what is stopping payment |
| 61–90 days | Real collection risk | Call the decision-maker; consider pausing new work or orders |
| 90+ days | Unlikely to be paid in full without intervention | Payment plan, formal demand, or referral; review for write-off with your accountant |
The escalating sequence of reminders in the first three rows is what collections teams call dunning, and most of it can run automatically.
Check the settings before you trust the report
Two settings change what the report means, and it is easy to run one without knowing which you chose.
- Aging by due date or by invoice date. Aged by invoice date, a net 30 invoice sits in the 1–30 bucket for its whole life before it is even due. That makes every report look worse than it is, and invoices on net 45 or net 60 terms make it worse still. For collection work, age by due date.
- Unapplied payments and credits. A payment received but not matched to an invoice leaves the invoice showing as overdue. Credit memos and overpayments appear as negative amounts. Apply cash the day it arrives, and clear old credits, so you never chase a customer who has already paid.
The accounts receivable aging method for estimating bad debt
The aging report also does accounting work. Under the aging method, you estimate the allowance for doubtful accounts by applying a different loss percentage to each bucket, because older invoices are less likely to be collected. The percentages should come from your own collection history; the ones below are hypothetical.
| Bucket | Balance | Estimated uncollectible | Allowance |
|---|---|---|---|
| Current | $66,000 | 1% | $660 |
| 1–30 days | $34,800 | 3% | $1,044 |
| 31–60 days | $17,100 | 10% | $1,710 |
| 61–90 days | $5,600 | 25% | $1,400 |
| 90+ days | $10,300 | 50% | $5,150 |
| Total | $133,800 | $9,964 |
The agency would carry an allowance of about $10,000, or 7.4% of receivables. More than half of it comes from the $10,300 over 90 days, which shows how much an old balance weighs on the true value of the book. Your accountant can confirm the method and percentages that suit your books; the tax treatment of bad debts follows separate rules.
A weekly routine for acting on the aging report
The report is only useful if someone acts on it. This takes 30 to 45 minutes every Monday.
- Apply every payment received since last week, so the report is accurate.
- Run the report aged by due date and sort customers by total past due, largest first.
- Compare the bucket totals with last week's. If more money moved into 31–60 than left it, collections are falling behind.
- Call the top five past-due accounts. Ask a specific question about a specific invoice, and write down the promised payment date.
- Check last week's promised dates. Anyone who missed one moves up the escalation table.
- Flag any customer with a creeping balance or a fully aged balance, and decide whether to hold new orders.
- Feed expected payments into your cash flow forecast for the coming weeks.
Frequently asked questions
What is the difference between an AR aging report and an AP aging report?
An accounts receivable aging report shows money customers owe you, grouped by how overdue it is. An accounts payable aging report shows money you owe suppliers, grouped the same way. The first tells you whom to chase; the second tells you which bills to pay this week to avoid late fees and keep supplier relationships in good standing.
Should I send customers their aging details?
Send each customer a statement instead, listing each open invoice with its date and amount. It does the same job from their side and often surfaces invoices their AP team never received. Never send a customer the full report, since it shows other customers' balances. Monthly statements to every account with an open balance are a sensible default.
What percentage of receivables should be current?
There is no universal figure, because it depends on your terms and customers. Compare yourself with your own history: if the current share is falling over several months, collections are slipping. A business on net 30 where most customers pay on time should see the large majority of its book in the current and 1–30 buckets.