Accounts receivable (AR) aging is one of the most practical tools for monitoring customer payment behavior and managing working capital. While metrics like DSO and AR turnover give a high-level view, an aging report breaks receivables down by how long they've been outstanding — making it a frontline tool for credit controllers and CFOs.
In this article, we'll cover:
What AR aging is
How an AR aging report is structured
How to extend it with dunning cohorts
How finance teams should use aging reports in collections, credit management, and cash flow planning
What is accounts receivable aging?
AR aging is the practice of categorizing outstanding invoices by the length of time they've been unpaid. The resulting report, called an AR aging report, shows receivables grouped into time "buckets," such as 0–30 days, 31–60 days, 61–90 days, and over 90 days.
The goal is simple: to identify overdue accounts quickly, track patterns of late payment, and prioritize collection efforts.
How to structure an AR aging report
A standard AR aging report includes:
Customer name: The customer or account associated with the receivable.
Invoice details: Invoice number, invoice date, due date, and outstanding balance.
Aging buckets: Receivables are grouped into categories, most commonly:
0–30 days (current, not yet due)
31–60 days (slightly overdue)
61–90 days (seriously overdue)
91+ days (high risk of default)
Totals: The report usually shows both customer-level subtotals and grand totals for each bucket.
Example layout:
Customer | 0–30 Days | 31–60 Days | 61–90 Days | 91+ Days | Total |
|---|
ABC Ltd. | $25,000 | $10,000 | $5,000 | – | $40,000 |
XYZ Inc. | $15,000 | $8,000 | – | $3,000 | $26,000 |
Total | $40,000 | $18,000 | $5,000 | $3,000 | $66,000 |
Extending AR aging with dunning cohorts
While a traditional AR aging report shows the current state, it doesn't reveal how invoices progress through time buckets. That's where dunning cohorts come in.
A dunning cohort table tracks groups of invoices by their start date (when the invoice was issued or became due) and shows how they "age" across different dates. This allows finance teams to see how quickly invoices are being resolved or slipping into later buckets.
Example: Dunning Cohort Table
Invoice Start (Due Date) | At Due Date | +30 Days | +60 Days | +90 Days | +120 Days | Status |
|---|
Jan 1, 2025 | $100,000 | $40,000 | $20,000 | $10,000 | $5,000 | $25,000 still open |
Feb 1, 2025 | $80,000 | $30,000 | $15,000 | $8,000 | $2,000 | $25,000 still open |
Mar 1, 2025 | $120,000 | $60,000 | $25,000 | $12,000 | $5,000 | $18,000 still open |
This structure shows how much of each cohort is collected over time versus how much drifts into later buckets.
Why it's valuable:
Identifies whether collections processes are improving or deteriorating across cohorts.
Highlights customers that consistently roll into later buckets.
Provides visibility into expected cash recovery over time.
How to use AR aging reports
1. Prioritize collections
The report shows which accounts are overdue and by how much, helping AR teams focus on the riskiest invoices first.
2. Monitor customer payment behavior
Aging reports reveal patterns, such as customers who consistently pay late or who are slipping into longer buckets. This can inform credit policy adjustments.
3. Estimate bad debt risk
Invoices in the 91+ day bucket are often at high risk of becoming uncollectible. Aging helps finance teams estimate allowances for doubtful accounts.
4. Support cash flow forecasting
By analyzing the timing of expected collections, AR aging provides more accurate cash flow forecasts.
5. Strengthen credit management
Consistently late-paying customers may need tighter terms, upfront deposits, or reconsideration of credit risk.
6. Provide transparency for stakeholders
CFOs, auditors, and investors often review AR aging as part of financial reporting and risk assessments.
Best practices for AR aging
Update regularly: Generate the report at least monthly, ideally weekly for high-volume businesses.
Set clear escalation policies: Decide what actions to take as invoices move through buckets (e.g. reminder email at 31 days, collections call at 61 days).
Integrate with AR automation: Modern tools can auto-generate aging reports, flag risky accounts, and trigger reminder workflows.
Combine with DSO and AR Turnover: Use aging alongside high-level metrics for a complete view of AR performance.
Analyze trends, not just snapshots: Track changes in each bucket over time to see if payment behavior is improving or worsening.
Final thoughts
Accounts receivable aging is a foundational tool in working capital management. By structuring invoices into clear time buckets, AR teams gain visibility into payment risk, collections priorities, and cash flow impacts.
When combined with metrics like DSO and AR turnover, AR aging helps finance teams act decisively: reducing late payments, improving liquidity, and protecting against bad debt.
Want to see how AI-powered AR automation can streamline aging reports and collections? Book a demo with our team.
“Accounts receivable aging is a foundational tool in working capital management. By structuring invoices into clear time buckets, AR teams gain visibility into payment risk, collections priorities, and cash flow impacts.”