Guides
The AR Aging Report Guide: How to Read It and What to Do Next
An aging report is only useful if someone actually acts on it. Here's how to read it correctly and turn it into a real collection plan.
By Luke Ashpole, Founding Sales Rep ·
The accounts receivable aging report is arguably the single most important document in an AR function. It answers the question every finance leader needs a current answer to: exactly how much is owed, by whom, and for how long. But a report that just sits in a spreadsheet, reviewed without a defined next action, is a missed opportunity, not a working tool.
Standard Aging Buckets Explained
Current
Invoices not yet past due. This is where the majority of a healthy AR book should sit.
1–30 Days Past Due
Recently past due. Often a timing issue or a customer that simply needs a reminder, low risk if addressed promptly.
31–60 Days Past Due
Genuinely late. Worth understanding why, a dispute, a cash flow issue on the customer's end, or a process gap on yours.
61–90 Days Past Due
Materially past due and rising risk. This is typically where structured escalation should intensify.
90+ Days Past Due
High risk of becoming bad debt. Requires a clear decision, continued internal pursuit, or a determination that the file needs a different approach entirely.
Common Mistakes Reading an Aging Report
Treating every past due dollar the same is the most frequent mistake. A $2,000 invoice 35 days past due from a reliable customer and a $200,000 invoice 35 days past due from a deteriorating account require completely different levels of attention, even though they sit in the same aging bucket.
A second common error is mixing disputed invoices into standard aging buckets without a separate flag. A disputed invoice is not a collections problem, it is a dispute resolution problem, and treating it like a normal past due account wastes effort and delays the actual fix.
Turning an Aging Report Into a Collection Plan
- 1 Segment accounts by both age and dollar size, not age alone.
- 2 Assign each segment a defined follow-up cadence and a named owner.
- 3 Flag disputed invoices separately and route them to resolution, not another reminder.
- 4 Track movement between buckets over time, not just the current snapshot.
When Aging Reports Are Misleading
A weak cash application process is one of the most common reasons an aging report overstates reality. When payments are received but not matched and posted correctly, the underlying invoices still show as open, even though the cash is already collected. Clearing that backlog often improves the reported picture faster than any collections effort.
Turn Your Aging Report Into a Real Action Plan
See what a structured, prioritized collection process could recover for you.
Frequently Asked Questions
An AR aging report is a breakdown of all outstanding customer invoices, grouped by how long each has been outstanding, current, 1 to 30 days past due, 31 to 60, 61 to 90, and 90 plus. It is the primary tool for understanding where collection risk is concentrated.
At minimum weekly, though many strong AR functions review it daily for higher risk accounts. The value of the report drops quickly if it is only checked at month end, by then problems have often already aged into a harder to collect bucket.
This usually happens when cash has been received but not yet applied to the correct invoice. Unapplied cash sits in a suspense account and the underlying invoice still shows as open on the aging report, even though the money is already in the bank.
No. A disputed invoice does not respond to a normal collections cadence, it needs a resolution owner and a paper trail, not another payment reminder. Mixing disputed and undisputed invoices into the same aging bucket without distinction makes it harder to prioritize correctly.
An aging report is a snapshot, what is owed right now and how old it is. DSO is a calculated average over a period of time. They are related but answer different questions, aging tells you where to focus today, DSO tells you whether your overall process is improving over time.