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 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 terms or move them to prepayment. 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 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.