If there's one report that every business owner should review weekly — but most ignore entirely — it's the invoice aging report (also called an AR aging report). This single document tells you more about the health of your cash flow than almost any other financial statement. Yet most business owners either don't know it exists, don't know how to read it, or check it once a quarter at tax time and move on.
What an Aging Report Is
An aging report is simply a list of all your unpaid invoices, organized by how long they've been outstanding. Most accounting software — QuickBooks, FreshBooks, Xero, and others — can generate one automatically. The report typically breaks invoices into "buckets" based on their age:
- Current: Not yet due
- 1-30 days past due: Recently overdue
- 31-60 days past due: Getting concerning
- 61-90 days past due: Requires immediate attention
- 90+ days past due: At high risk of becoming uncollectible
Each bucket shows you the total dollar amount and the individual invoices that make it up. This gives you both the big picture (how much is overdue overall) and the detail (which specific invoices and customers need attention).
What Your Aging Report Is Telling You
Healthy vs. Unhealthy Distribution
In a healthy business, 70-80% of total receivables should be in the "current" or "1-30 days" buckets. If a significant percentage of your receivables are in the 60+ day range, you have a systemic follow-up problem — not just a few difficult customers.
Customer Concentration Risk
Your aging report also reveals concentration risk. If one customer accounts for 30% or more of your total outstanding AR, you're dangerously dependent on that single customer's payment behavior. Diversification isn't just a stock market concept — it applies to your receivables too.
Pattern Recognition
Review your aging report over several months and you'll start to see patterns. Certain customers may consistently appear in the 60+ day buckets. Certain types of invoices (large projects, specific service lines) may age differently than others. These patterns are gold — they tell you where to focus your attention and which processes need improvement.
How to Use Your Aging Report Effectively
1. Review It Weekly
Not monthly. Not quarterly. Weekly. Set aside 15 minutes every Monday morning to look at your aging report. This keeps you aware of developing problems before they become crises and ensures that follow-up happens while invoices are still fresh.
2. Prioritize by Amount and Age
Not all overdue invoices deserve equal attention. Focus your energy on the largest dollar amounts in the oldest buckets first. A $25,000 invoice at 45 days past due needs attention today. A $500 invoice at 10 days past due can wait until Wednesday.
3. Set Action Triggers
Define what happens at each stage. For example: at 7 days past due, send a reminder email. At 14 days, make a phone call. At 30 days, send a formal notice. At 60 days, escalate to senior management or your AR partner. Having predefined triggers removes the guesswork and ensures consistent follow-up.
4. Track Trends Over Time
Your aging report isn't just a snapshot — it's a trend indicator. Track your total past-due amount and your aging distribution month over month. Are things improving or getting worse? Is your oldest bucket growing? Are certain customers migrating from "current" to "30+" consistently? These trends reveal whether your collection efforts are working or whether you need to change your approach.
The Cost of Ignoring Your Aging Report
Every day an invoice sits in the 60+ day bucket, the probability of collecting it drops. Data from the Commercial Collection Agency Association shows that after 90 days, the probability of full collection drops below 50%. After 120 days, it can fall below 25%. The invoices sitting in those older buckets aren't just "late" — they're actively becoming uncollectible. That's why proactive AR management — based on regular aging report review — is so critical.
If you haven't looked at your aging report recently, pull it up today. The numbers might surprise you — and that surprise is exactly the wake-up call most businesses need to start taking AR management seriously. Need help making sense of what you see? Ledger & Lane offers a free AR audit that starts with a deep analysis of your aging report and provides a clear action plan for improving your collection rates.