The accounts receivable aging report is one of the most important financial documents your business produces, yet many small business owners have never looked at one. This single report tells you exactly who owes you money, how much, and how long each debt has been outstanding. It is the early warning system for cash flow problems, bad debt risk, and clients who need a collections nudge. If you only review one financial report each week, make it this one.
What Is an Accounts Receivable Aging Report?
An accounts receivable (AR) aging report organizes all your unpaid invoices by how long they have been outstanding. Invoices are sorted into time buckets, typically Current (not yet due), 1-30 days past due, 31-60 days past due, 61-90 days past due, and 90+ days past due. Each bucket shows the total amount owed, and the report totals give you a snapshot of your overall receivables health.
The report is typically organized by client, so you can see not just the aggregate picture but also which specific clients are falling behind and by how much. This client-level detail is what makes the report actionable rather than just informational.
How to Read the Report
The Current Bucket
Invoices in the Current bucket are not yet past their due date. A healthy business should have most of its receivables here. If this bucket is consistently large relative to your revenue, it might simply mean you invoice in batches or have long payment terms. Monitor the trend over time rather than focusing on a single snapshot.
The 1-30 Days Bucket
Invoices in this bucket are slightly overdue. Some amount here is normal; not every client pays on the exact due date. However, if this bucket is growing month over month, it signals that your payment terms or collection processes need attention. A friendly payment reminder at this stage resolves most issues.
The 31-60 Days Bucket
This is where concern should escalate. Invoices that are 31-60 days late represent clients who have either forgotten, are experiencing cash flow issues themselves, or are deprioritizing your payment. This is the stage for direct outreach: a phone call rather than an email, a conversation about payment plans, or a pause on further work until the balance is resolved.
The 61-90 and 90+ Days Buckets
Invoices in these buckets are serious collection risks. Collection probability drops significantly with each passing month, and invoices beyond 90 days are often written off as bad debt. At this stage, you should be considering formal collection actions, adjusting your bad debt reserves, and evaluating whether the client relationship is worth maintaining.
Every dollar in your 90+ days bucket is a dollar you may never see. The aging report does not just track what is owed; it tracks how likely you are to actually collect it.
Key Metrics to Track
- Total AR value and its trend over time.
- Percentage of AR in each aging bucket (aim for 80%+ in Current).
- Days Sales Outstanding (DSO): Average number of days to collect payment.
- Concentration risk: Is one client responsible for a disproportionate share of overdue balances?
- Bad debt ratio: What percentage of invoices eventually become uncollectible?
Red Flags to Watch For
Certain patterns in your aging report demand immediate attention. If a previously reliable client suddenly has invoices slipping into the 31-60 day bucket, they may be experiencing financial difficulties. If the overall percentage of past-due receivables is climbing each month, your payment terms or enforcement may be too lenient. If a single client accounts for more than 20% of your total receivables, you have a dangerous concentration risk.
Taking Action Based on the Report
Weekly Review Cadence
Set a weekly appointment to review your aging report. Fifteen minutes every Monday morning is enough for most small businesses. During each review, identify invoices that have moved into a new aging bucket since last week and take appropriate action: send reminders for newly overdue items, make phone calls for 30+ day items, and escalate or write off 90+ day items.
Automated Actions
InvoiceFold generates your aging report automatically from your invoice data, with no manual spreadsheet work required. The dashboard shows a visual breakdown of receivables by aging bucket, and you can drill down to individual invoices with a click. Set up automated payment reminders at key intervals (due date, 7 days late, 14 days late, 30 days late) to address overdue invoices before they age further.
Using the Report for Business Decisions
Your aging report informs decisions beyond collections. Use it to evaluate client creditworthiness before extending payment terms, to set bad debt reserves accurately for financial reporting, to identify clients who might benefit from early payment discounts, and to decide when to require upfront deposits or change payment terms for chronically late payers.
The accounts receivable aging report transforms your receivables from an opaque number on a balance sheet into an actionable collection plan. Start reviewing yours weekly, and you will never be blindsided by a cash flow crunch again.