What is Accounts Aging Report?
An accounts aging report (aging report) lists all outstanding client invoices grouped by how long they've been unpaid. Learn how to read an aging report, why it matters for cash flow, and how to use it to collect payments faster.
What Is an Accounts Aging Report?
An accounts aging report (commonly called an aging report) is a financial report that lists all outstanding invoices and customer balances, organized by how long they've been unpaid — typically bucketed as: | Bucket | Description | |---|---| | Current | Not yet due (or paid) | | 1-30 days | 1-30 days past due date | | 31-60 days | 31-60 days past due date | | 61-90 days | 61-90 days past due date | | 90+ days | More than 90 days past due | Think of it as a snapshot of your accounts receivable — who's paying, who's slow, and who's stopped paying entirely. It's the most important tool in your collections arsenal.
Reading an Aging Report
Here's a simplified aging report for a freelance consultant: | Client | Current | 1-30 | 31-60 | 61-90 | 90+ | Total AR | |---|---|---|---|---|---|---| | Acme Corp | $0 | $4,500 | $0 | $0 | $0 | $4,500 | | Bright Media | $8,000 | $0 | $12,000 | $0 | $0 | $20,000 | | Crestwood LLC | $0 | $0 | $0 | $7,500 | $3,200 | $10,700 | | DeTech Inc | $0 | $0 | $0 | $0 | $0 | $0 | | Totals | $8,000 | $4,500 | $12,000 | $7,500 | $3,200 | $35,200 | What this tells you: - DeTech Inc is current — paid or no outstanding invoices - Acme Corp has $4,500 just entering overdue — follow up gently - Bright Media has $12,000 in the 31-60 day bucket — needs attention - Crestwood LLC has $10,700 and it's aging badly — serious risk - Total AR at risk (31-60+): $22,700 — more than half your receivables
Why Aging Reports Matter for Cash Flow
The longer an invoice goes unpaid, the less likely you are to collect it: | Days Overdue | Probability of Collection | |---|---| | 0-30 days | 90%+ | | 31-60 days | 70-80% | | 61-90 days | 50-60% | | 90-180 days | 20-30% | | 180+ days | <10% | An aging report shows you where your risk is concentrated. If most of your AR is in the 1-30 bucket, you're in good shape. If it's concentrated in 61-90 and 90+, you have a serious cash flow problem that needs immediate attention.
Using the Aging Report for Collection Prioritization
The aging report isn't just informational — it's your collections to-do list: Priority 1 (61-90+ days): These invoices are at serious risk. Contact clients immediately. Be direct. Ask directly: "When can we expect payment?" Be prepared to offer payment plans or negotiate. Priority 2 (31-60 days): These are trending toward trouble. Send a firm reminder, possibly call. Try to understand if there's a dispute — resolve it quickly. Priority 3 (1-30 days): Usually just forgot. A friendly reminder is sufficient. Most of these will pay without escalation.
Aging Report and Financial Health
Your aging report directly impacts key financial metrics: Days Sales Outstanding (DSO): > DSO = (Accounts Receivable ÷ Total Credit Sales) × Number of Days A DSO above 60 indicates poor collection performance. Compare your DSO over time — if it's creeping up, your aging is worsening. Allowance for Doubtful Accounts: If you have significant AR in the 90+ bucket, you should probably have an "allowance for doubtful accounts" — a reserve against the likelihood that some of this AR will never be collected.
Example: Acting on an Aging Report
A freelance design studio pulls their monthly aging report and sees: | Client | 31-60 Days | 61-90 Days | 90+ Days | |---|---|---|---| | TechStart Inc | $15,000 | $0 | $0 | | GreenCo | $8,000 | $0 | $0 | | RetailMax | $0 | $22,000 | $0 | | OldTown Café | $0 | $0 | $6,500 | Action plan: - TechStart/ GreenCo: Send reminder emails — likely just forgot - RetailMax: Call directly — significant amount in 61-90 bucket. Ask about payment date and if there are any issues - OldTown Café: At 90+, it's likely uncollectable or in serious dispute. Make a final collection attempt. If no response, consider writing off or sending to collections
The Bottom Line
The accounts aging report is your early warning system for cash flow. Review it weekly, prioritize your collection efforts by bucket (older = more urgent), and track your DSO over time. If your 90+ bucket keeps growing, you have a fundamental problem with either your client selection or your invoicing/payment processes. (Manage AR proactively →) (Speed up collections →) (Understand your cash flow →) Key Takeaways: 1. An aging report groups unpaid invoices by how many days overdue they are 2. The 61-90 and 90+ buckets are serious cash flow risks — act immediately 3. Review your aging report weekly to catch problems early 4. The longer an invoice goes unpaid, the less likely you are to collect 5. Track Days Sales Outstanding (DSO) over time to measure collection performance Get real-time aging reports — Try Eonebill Free Eonebill's dashboards give you instant aging reports — so you know exactly who's paying, who's slow, and who needs aggressive follow-up. View Pricing → | Glossary Home → | Home →