Short answer: An accounts receivable aging report is a list of your unpaid customer invoices sorted by how long they have been outstanding, grouped into buckets like current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days. It shows you at a glance which customers owe you, how much, and how overdue each balance is, so you can prioritize collections and estimate how much of what you are owed you may never collect.
Last updated: July 2026.
The aging report is the single most useful document in receivables. Every accounting system produces one, and finance teams run it at least monthly because it turns a wall of open invoices into a prioritized action list. It answers the two questions that matter most in collections: who should I chase first, and how much of this money is genuinely at risk. Used well, it is also the raw material for estimating bad debt and for keeping cash flow honest.
What is an accounts receivable aging report?
An accounts receivable aging report, also called an aging schedule or aged receivables report, is a breakdown of every open invoice organized by the length of time it has been unpaid. Instead of one lump sum of total receivables, it splits the balance into time buckets so you can see which invoices are current and which have slipped past due. It is a core output of the accounts receivable process, and it is usually sorted by customer so you can see each account total and the mix of current versus overdue amounts inside it.
What does an aging report look like?
A standard aging report lists customers down the side and aging buckets across the top, with each invoice landing in the bucket that matches its age past the due date. Here is a simplified example:
| Customer | Current | 1 to 30 | 31 to 60 | 61 to 90 | 90+ | Total |
|---|---|---|---|---|---|---|
| Acme Manufacturing | 12,000 | 4,000 | 0 | 0 | 0 | 16,000 |
| Bright Media | 6,000 | 0 | 3,500 | 0 | 0 | 9,500 |
| Cedar Consulting | 0 | 2,000 | 2,000 | 1,500 | 4,000 | 9,500 |
| Total | 18,000 | 6,000 | 5,500 | 1,500 | 4,000 | 35,000 |
The buckets tell the story instantly. Acme is healthy, almost entirely current. Cedar is the problem: nothing current, and 4,000 dollars sitting past 90 days that may never be collected. The report tells you to call Cedar today and leave Acme alone.
What are the aging buckets?
Aging buckets are the time ranges that group invoices by how overdue they are. The most common set is current (not yet due), 1 to 30 days past due, 31 to 60, 61 to 90, and over 90 days. Some companies add a 120+ bucket for very old debt. The buckets are usually measured from the invoice due date, though some teams age from the invoice date instead; the important thing is to pick one basis and use it consistently, because the further right a balance sits, the lower the odds you will ever collect it.
How do you create an aging report?
Most accounting platforms generate the report automatically, but the logic behind it is simple enough to build by hand:
- Pull every open invoice. List each unpaid invoice with its customer, amount, invoice date, and due date.
- Calculate days past due. Subtract the due date from today for each invoice.
- Assign each invoice to a bucket. Drop it into current, 1 to 30, 31 to 60, and so on based on days past due.
- Subtotal by customer and by bucket. Sum each row (customer) and each column (bucket) so you can see both who owes and how aged the overall book is.
Accuracy depends on one upstream discipline: applying payments the day they arrive. If cash sits unapplied, paid invoices keep showing as overdue and the whole report lies to you. Getting the bank data into your ledger quickly matters here, and teams that receive a lot of paper or PDF statements often speed this up by converting the bank statement into a format their accounting software can import so deposits can be matched against open invoices fast.
What does a healthy aging report look like?
On healthy net 30 terms, most of the balance sits in current, a modest amount sits in 1 to 30, and the 90-plus bucket is small and shrinking. The exact split varies by industry and terms, so the number that matters is not any single percentage but the direction of travel: balances moving right, month over month, is the warning sign regardless of where they start.
| Pattern | What it usually means | What to do first |
|---|---|---|
| Most of the balance in current, tiny 90-plus | Terms and follow-up are both working | Nothing. Keep the cadence. |
| Large 1 to 30 bucket, small older buckets | Customers pay, just late. Often an invoicing or delivery timing issue | Check invoice dispatch dates against terms |
| Balance concentrated in one or two customers | Concentration risk, not a collections problem | Credit review on those accounts specifically |
| 90-plus bucket growing month over month | Follow-up has stopped happening, or a dispute is unresolved | Call, do not email. Separate genuine disputes from silence. |
| Everything ages evenly and slowly | Terms are longer than your process assumes | Reconcile stated terms with actual behavior |
The fourth row deserves a caution. A balance in the 90-plus bucket that is actually a disputed invoice is not a collections problem at all, and chasing it with dunning emails makes things worse. Tag disputes separately so the report shows what is genuinely uncollected against what is contested and waiting on you.
What is the difference between an aging report and a statement of account?
An aging report is an internal document that shows all customers' open balances sorted by age. A statement of account is an external document sent to one customer listing their own open invoices and payments. They are built from the same data, but only one of them is meant to leave the building. Sending a customer an aging report is a mistake more than one finance team has made. The distinction between an invoice and a statement of account covers which document does what.
What is the aging method for estimating bad debt?
The aging method, or aging of receivables method, uses the report to estimate how much of your receivables you will not collect. The idea is that older balances are far less likely to be paid, so you apply a rising uncollectible percentage to each bucket and add them up. A common pattern is something like 1 percent of current, 5 percent of 1 to 30, 15 percent of 31 to 60, 40 percent of 61 to 90, and 75 percent or more of 90-plus. The total becomes your estimate for the allowance for doubtful accounts, which is how the aging report feeds directly into your financial statements.
How do you use the aging report in collections?
The report is a prioritization tool first. Work it from right to left: the oldest, largest balances get a phone call, not another email, because every additional week in the 90-plus bucket lowers the odds of recovery. Fresh overdue balances in the 1 to 30 bucket usually just need a firm reminder. Reading the report by customer also surfaces patterns, such as a single account that is always 60 days late, which is a signal to tighten that customer's terms or move them to prepayment. Pairing the report with your accounts receivable turnover ratio tells you whether one stubborn account is the problem or collection speed has slipped across the whole book. A structured follow-up sequence, laid out in this guide to recovering late payments, turns the report into a repeatable routine rather than a monthly scramble.
How often should you run the aging report?
Run it at least monthly as part of your close, and weekly if you carry a large or fast-moving receivables book. The value is in the trend: comparing this month's aging profile to last month shows whether balances are drifting into older buckets before it shows up in your cash position or your days sales outstanding. A report you only look at during a cash crunch is a diagnosis; a report you review every month is an early-warning system.