Accounts Receivable Aging Analysis in Due Diligence
Accounts receivable aging analysis tells you more about a business than most financial statements. It reveals collection discipline, customer health, revenue recognition practices, and operational effectiveness. For diligence teams, AR aging is a window into the quality of the target's revenue stream.
Poorly managed receivables indicate underlying problems: disputed invoices, revenue booked before delivery, customer concentration risk, or weak credit policies. Each of these affects the reliability of historical earnings and the sustainability of forward revenue.
The Core Aging Analysis
The starting point is a detailed aging schedule, typically bucketed by 0-30, 31-60, 61-90, 91-120, and 120+ days past due. This schedule should be available at the customer level to support concentration and trend analysis.
Key metrics from the aging include:
Days Sales Outstanding (DSO). Revenue-weighted average collection period. Compare to payment terms and industry benchmarks. Rising DSO relative to payment terms signals deteriorating collections.
Overdue percentage. The proportion of AR past contractual payment terms. A rising overdue percentage, even with stable DSO, suggests collection effort is compensating for declining payment discipline.
Concentration in aging buckets. Material balances in the 90+ day buckets require specific investigation. These may represent disputed invoices, impaired customers, or revenue recognition issues.
Bad debt provision adequacy. Compare the existing allowance for doubtful accounts to the actual aging profile and historical write-off rates. Many targets under-provision, which overstates both current assets and historical earnings.
Revenue Quality Connection
AR aging is directly connected to revenue quality assessment. Anomalies in the aging schedule frequently indicate revenue recognition issues:
Channel stuffing. Large shipments to customers near quarter-end, followed by elevated returns or slow collection, suggest revenue acceleration. The AR aging will show spikes in receivables at period-end dates.
Bill-and-hold arrangements. Revenue recognized before delivery creates receivables that may age abnormally because the customer does not consider the invoice payable until goods are received.
Contract modifications. Revenue recognized on the original contract terms despite subsequent modifications or concessions. The aging may show disputes or partial payments that signal unrecorded revenue adjustments.
Related party receivables. Balances due from related parties often age differently from third-party receivables. Favorable collection terms or implicit payment deferrals should be identified separately.
Customer Concentration in AR
AR concentration analysis overlaps with but differs from revenue concentration analysis. A customer may represent a moderate share of revenue but a disproportionate share of receivables if it pays slowly.
The diligence team should analyze:
- Top 10 and top 20 customer balances as a percentage of total AR
- Aging profile of the largest customers vs. the overall portfolio
- Credit terms by major customer
- History of write-offs or provisions by customer
High concentration in AR amplifies collection risk. If the largest customer represents 30 percent of receivables and falls into financial difficulty, the impact on cash flow is immediate and material. See our discussion of customer concentration analysis for the broader framework.
Working Capital Implications
AR is typically one of the three largest components of net working capital. The diligence team must assess whether the closing balance is representative of ongoing requirements or distorted by timing effects.
Common distortions include:
- Seasonality. Businesses with seasonal revenue will have seasonal AR patterns. The NWC peg must reflect this cyclicality.
- One-time items. Large invoices for non-recurring projects or unusual billings near the measurement date.
- Collection campaigns. Targets sometimes accelerate collections before closing to improve the cash position, artificially depressing AR.
- Revenue recognition timing. Changes in billing practices or revenue recognition near the measurement date can shift AR balances.
The recommended approach is to analyze monthly AR balances and DSO over 24 months, identify the normalized range, and set the net working capital peg accordingly.
Bad Debt Provisions and EBITDA Impact
Inadequate bad debt provisions affect both the balance sheet and the income statement. If the diligence team determines that additional provisions are required:
- The balance sheet adjustment increases the allowance and reduces net AR
- The P&L impact (additional provision expense) reduces EBITDA
- If the additional provision relates to a specific one-time event, it may be treated as a non-recurring adjustment in the earnings bridge
Conversely, excess provisions that are not justified by the aging profile or historical experience may indicate earnings management. The target may be building reserves in good periods and releasing them in weak periods to smooth reported earnings.
Practical Considerations
Effective AR analysis requires customer-level detail. A summary aging schedule is insufficient for the analyses described above. The diligence team should request:
- Customer-level aging report as of the latest balance sheet date
- Monthly AR aging summaries for the diligence period
- Bad debt write-off history by customer
- Credit policy documentation
- Dispute log with resolution status
When this data is extracted early and mapped through a standardized data normalization process, the analytical work proceeds efficiently. Late or incomplete data requests are one of the most common causes of timeline pressure in working capital analysis.