Invoice Aging Report: What It Is and How to Use One
An invoice aging report groups your outstanding invoices by how overdue they are, giving you a single view of where collection risk is concentrated instead of scanning through invoices one at a time. It’s one of the simplest tools for keeping accounts receivable from quietly getting out of hand.
How the aging buckets work
Most aging reports use a standard set of buckets based on days past due:
- Current — not yet due
- 1–30 days overdue
- 31–60 days overdue
- 61–90 days overdue
- 90+ days overdue
Reading the report
A healthy AR position has most of its balance in "current" and "1–30," with little or nothing in the older buckets. A meaningful chunk sitting in "61–90" or "90+" is a clear signal — those invoices need active follow-up or escalation, since the odds of collecting drop the longer an invoice ages.
Using it to prioritize collections
Rather than following up on every overdue invoice with the same effort, an aging report lets you focus first on the oldest and largest balances, where the risk of the debt becoming genuinely uncollectible is highest. Smaller, recently overdue invoices are usually lower-effort to resolve with a simple reminder.
A simple report structure
For each client, list the total outstanding amount split across the aging buckets, with a grand total at the bottom for each bucket across all clients. Even a basic spreadsheet version — client name, invoice number, amount, and days overdue, sorted by age — delivers most of the value without needing dedicated software.
FAQ
How often should I run an aging report?
Weekly is common for businesses with several active clients; monthly is a reasonable minimum for smaller operations. The point is catching invoices as they cross into an older bucket, not reviewing them long after the fact.
What percentage of AR in the 90+ bucket is concerning?
There’s no universal threshold, but a bucket that’s growing over time, or holding a disproportionate share of your total AR relative to how much revenue that period represents, is worth investigating regardless of the exact percentage.
Does an aging report include paid invoices?
No — it’s specifically a view of outstanding, unpaid invoices. Paid invoices are excluded since they no longer represent collection risk.
Can I build an aging report without accounting software?
Yes — a spreadsheet with invoice date, due date, amount, and a formula calculating days overdue can replicate the core function for a small number of clients.
Put this into practice with a real invoice.
Try the free Invoice GeneratorRelated Guides
- Accounts Receivable: A Plain-English Guide for Small Businesses
A plain-English guide to accounts receivable for small businesses. Learn the AR process, key metrics, common mistakes, and how to get paid faster.
- Days Sales Outstanding (DSO): What It Is and How to Reduce It
What Days Sales Outstanding is, the DSO formula, a worked example, what counts as a good DSO, and practical ways to reduce it and get paid faster.