Accounts Receivable Aging Report: How to Read It and What to Do About Each Bucket

An accounts receivable aging report lists every unpaid invoice you have issued and sorts the balances by how overdue they are, normally in 30-day buckets: current, 1 to 30 days, 31 to 60, 61 to 90, and 90 plus. Read right to left. The columns furthest right are the balances closest to becoming bad debt, and they are where your collections time belongs. Every accounting system produces one, almost nobody acts on it systematically, and that gap is where most of the money that gets written off each year actually disappears.

This is the practical version: what the report contains, what a real one looks like, how to read it in about ninety seconds, and the specific action that belongs to each bucket.

What is an accounts receivable aging report?

An accounts receivable aging report is a schedule of everything customers owe you, grouped by how long it has been outstanding. It is sometimes called an AR aging report, an aging schedule, or an accounts receivable aging summary when it shows only customer totals rather than individual invoices.

The mechanics are simple. Every open invoice has an issue date and a due date. The report takes the number of days since the due date (some systems use the invoice date, which matters, more on that below) and drops the balance into the matching bucket. Add the buckets across a row and you get what one customer owes. Add them down a column and you get how much of your total receivables sits at each level of risk.

What does an accounts receivable aging report look like?

Here is a small one, with the numbers a real services business might see:

Total receivables are $64,400. That is the number most owners look at. The number that actually matters is $21,500, the 90 plus column, which is 33% of the book. Two customers account for all of it, and one of them, Westgate Media, is paying nothing in any bucket while balances keep stacking up. That is not a slow payer. That is a customer who has stopped paying, and the report has been saying so for three months.

How to read an accounts receivable aging report

Five things, in this order, and it takes about ninety seconds once you are used to it.

1. Read the bottom row right to left. Start at 90 plus, not at the total. Those balances have already survived every reminder your process sends. Ask what percentage of the book they represent. Under 5% is healthy for most businesses. Above 10% means your escalation is not working.

2. Find the customers with balances in three or more buckets. A single late invoice is a mistake or a cash flow hiccup. Amounts spread across 31 to 60, 61 to 90, and 90 plus mean the customer is paying you last, or not at all, and continuing to order. Westgate Media in the table above is the textbook shape.

3. Check concentration. If one customer is more than about 20% of total receivables, your cash flow is exposed to their payment behavior no matter how good your process is. That is a credit decision, not a collections one.

4. Compare to last month's report. A single aging report is a photograph. Two of them are a trend. What you want to see is dollars moving left, from older buckets into paid, not simply a total that goes up because sales went up.

5. Sanity check the current column. If almost nothing is current, you have an invoicing problem rather than a collections problem, and no amount of chasing will fix an invoice that went out three weeks late.

What is the purpose of an accounts receivable aging report?

It does three separate jobs, and most businesses only use the first one.

Prioritizing collections. This is the daily use. The report tells you which five phone calls or letters are worth more than the other forty. It is also what stops collections work from defaulting to whoever emailed most recently.

Forecasting cash. Buckets carry probabilities. Current invoices mostly get paid on time. Balances chased inside 90 days past due recover at roughly 70% or better as an industry norm, while balances past 180 days often recover below 15%. Apply rough collection rates to each bucket and you get a far more honest 60-day cash forecast than multiplying total receivables by optimism.

Supporting the allowance for doubtful accounts. Under GAAP you have to estimate the receivables you will not collect. The aging report is the standard evidence for that estimate, and the percentage-of-receivables method applies a higher reserve rate to each older bucket. If your CPA has ever asked for an aged trial balance at year end, this is the report they meant.

What to do about each bucket

The report has done its job when every bucket has a standing action attached to it, one that happens without anybody deciding to start it.

The wording for the middle stages is the part people get stuck on, because it has to escalate without torching a customer relationship you would rather keep. We have the exact sequence written out, courtesy note through final notice, in our overdue invoice email templates, and the formal stage in our guide to writing a demand letter for payment.

Where to find the report in QuickBooks and Xero

In QuickBooks Online it is under Reports, then Who owes you, as either Accounts receivable aging summary (customer totals only) or Accounts receivable aging detail (every individual invoice). Use the detail version for collections work and the summary for a quick health read.

In Xero it is Business, then Invoices, then the Aged Receivables Summary and Aged Receivables Detail reports. Both platforms let you change the bucket size from 30 days and set the aging basis to due date or invoice date.

Set it to age by due date, not invoice date, unless you have a reason not to. Aging by invoice date makes everything on net 30 terms look 30 days worse than it is, and it quietly trains your team to ignore the report because the buckets do not match reality.

Building an aging schedule in Excel

If your invoicing lives outside an accounting system, or you are reconciling against a customer's own statement, you can build the schedule in a spreadsheet. You need four columns per invoice: customer, invoice number, amount, and due date. A TODAY() minus due date formula gives days overdue, a nested IF assigns the bucket, and a pivot table with customer as rows and bucket as columns produces the same grid as any accounting package.

The tedious part is getting the invoice data into rows in the first place, especially when what you have is a folder of PDFs from a system that will not export cleanly. Tools that extract invoice line items straight into a spreadsheet save an afternoon of retyping here, and they matter more than the formula work, because an aging schedule built on half your invoices tells you nothing useful.

The mistakes that make the report useless

Running it and not acting on it. The most common failure by a distance. A report nobody works is just a record of money you are going to lose more slowly.

Working it top to bottom. Alphabetical order is not a priority order. Sort by the 90 plus column, descending, every time.

Leaving unapplied credits and disputes in the buckets. A balance sitting at 120 days because of an unresolved billing dispute is a service problem wearing a collections costume. Flag those separately or they poison the whole report.

Waiting for month end. By the time a month-end report lands, an invoice that was 55 days late is 70 days late. Weekly is the right cadence for anything past due.

Turning the report into a process that runs itself

The honest problem with aging reports is not analysis. Most people can read one correctly within a few minutes of seeing their first. The problem is that acting on it is repetitive, slightly uncomfortable work that always loses to something more urgent, so the 61 to 90 column becomes the 90 plus column while everyone is busy.

That is a scheduling problem, and it is worth solving with automation rather than discipline. Something should move each invoice to the next stage of outreach based on its age, without a human deciding to start. That is exactly what our accounts receivable software does: it reads the open invoices, escalates the tone bucket by bucket, and produces the formal demand when the softer stages have run out, on a flat monthly fee rather than a percentage of what it recovers.

If your 90 plus column is already large, the more relevant read is how to reduce DSO, which covers the upstream changes (terms, invoicing speed, credit checks) that stop the column filling in the first place, and what a collection agency actually costs for the balances that are genuinely past saving.

One aging report read properly on a Monday morning, with an action attached to every bucket, is worth more than any other hour of financial admin a small business does. The information has always been there. Acting on it is the part that pays.

This article is general information about accounts receivable practice, not legal or accounting advice. Talk to your CPA about how the allowance for doubtful accounts should be calculated for your business.