Definition
Accounts Receivable Aging is a financial report that categorizes a company’s outstanding customer invoices by the number of days they remain unpaid. The report groups receivables into age brackets (typically Current, 30-60 days, 60-90 days, and 90+ days overdue) to help businesses track collection status, identify payment issues, and assess the risk of bad debts.
Key Takeaways
- Accounts Receivable Aging helps identify slow-paying customers and potential bad debts before they become write-offs, enabling proactive collection efforts.
- The report is typically prepared monthly or quarterly and compares the aging of receivables over time to identify trends in collection performance.
- High percentages of receivables in the 90+ days overdue category signal cash flow problems, collection failures, or credit risk with specific customers.
- The aging report feeds into bad debt expense calculations and the allowance for doubtful accounts on financial statements, directly impacting reported profitability.
Importance
Accounts Receivable Aging is critical for cash flow management and financial health. Companies with many outstanding invoices tied up in receivables face cash flow stress, even if they appear profitable on paper. By categorizing receivables by age, managers can identify which invoices are most at risk of non-payment and prioritize collection efforts. Long-outstanding receivables (90+ days) are increasingly unlikely to be collected, so early identification enables proactive interventions—phone calls, revised payment plans, or referrals to collection agencies. Additionally, the aging report is essential for calculating bad debt expense and the allowance for doubtful accounts, which directly impact financial reporting accuracy and compliance with accounting standards.
Explanation
The Accounts Receivable Aging report lists all outstanding customer invoices organized by invoice date, calculating the number of days each has been unpaid. For example, an invoice issued on January 1, assessed on March 15, has been outstanding for 73 days. The report groups invoices into age categories: Current (not yet due), 30-60 days, 60-90 days, and 90+ days. Each category shows the total dollar amount and percentage of total receivables. A typical report might show: Current (40% of total), 30-60 days (35%), 60-90 days (15%), and 90+ days (10%). This distribution reveals collection performance—a healthy business typically has most receivables current or less than 30 days old. High percentages in older categories indicate collection problems, credit issues with specific customers, or disputes over invoices. The aging report informs collection strategies: customers with current or recent invoices need reminders, while 90+ day overdue invoices require escalation or write-off consideration.
Examples
1. A software company preparing its March 15 accounts receivable aging report finds: $500K current, $350K 30-60 days old, $150K 60-90 days old, and $100K 90+ days old (totaling $1.1M). The 90+ day category ($100K) represents invoices issued before December 15 that likely need write-off or intensive collection efforts.
2. A manufacturing company’s aging report shows a sudden increase in 60-90 day receivables, indicating either a recent issue with a major customer’s payments or internal collection process delays. Management investigates and finds a key customer is having cash flow problems; they negotiate a payment plan to improve collection.
3. A service company’s aging report reveals that one customer has $75K in receivables 90+ days overdue while most other customers pay within 30 days. The company decides to halt services to this customer until past-due amounts are addressed, protecting cash flow.
Frequently Asked Questions (FAQ)
How often should I prepare accounts receivable aging reports?
Most businesses prepare aging reports monthly, aligned with financial close and management reporting cycles. Some companies with large or volatile receivables prepare them weekly or bi-weekly to catch collection issues early. More frequent reports enable faster response to payment problems.
What’s a healthy accounts receivable aging distribution?
Ideally, 70-80% of receivables should be current (not yet due), and the vast majority should be less than 60 days old. If more than 10-15% of receivables are 90+ days overdue, it signals collection problems requiring investigation and action. The distribution depends on your industry and typical payment terms.
How does accounts receivable aging affect financial statements?
Aging directly impacts the calculation of bad debt expense and the allowance for doubtful accounts. Receivables in the 90+ days category are more likely to be uncollectible, so companies increase bad debt reserves based on aging data. This reduces reported profits but reflects realistic accounting of collection risk.
What should I do if a large portion of receivables are 90+ days overdue?
Investigate immediately. Contact customers to understand payment delays, confirm they received invoices, and negotiate payment plans. If disputes exist, resolve them quickly. For truly uncollectible amounts, write them off as bad debt. Implement collection process improvements to prevent future aging problems.
Can I use accounts receivable aging to forecast cash flow?
Yes. The aging report helps estimate when receivables will convert to cash. If you know that 80% of your 30-60 day receivables typically collect within 10 days, you can forecast cash inflows based on aging. However, aging alone is insufficient; you also need historical collection rates and customer-specific payment patterns.
What’s the difference between accounts receivable aging and DSO (Days Sales Outstanding)?
Aging is a snapshot showing the current distribution of receivables by age category. DSO is a metric calculated as (Accounts Receivable / Daily Revenue), showing the average number of days it takes to collect receivables. DSO is more useful for trend analysis and comparing performance over time, while aging shows specific invoice-level details.
Related Finance Terms
- Bad Debt Expense
- Accounts Receivable
- Allowance for Doubtful Accounts
- Cash Flow
- Collection