Aging Report

An aging report, or accounts receivable aging report, is a listing of a company's unpaid customer invoices sorted into time buckets according to how long each has been outstanding. The standard buckets run from current, meaning not yet due, through 1 to 30 days past due, 31 to 60, 61 to 90, and over 90 days. Each customer's balance is spread across these columns, so the report shows not just how much is owed but how overdue it is. The pattern is the point: money sitting in the far-right buckets has gone unpaid for a long time and is far less likely to ever be collected than money that is current or only slightly late. Finance, credit, and collections teams use the aging report to see the health of what they are owed. This entry is educational, not accounting advice.

The aging report matters because a receivable is only worth something if it is actually collected, and age is the best simple predictor of collection. An invoice a week overdue will very likely be paid; one more than ninety days overdue often will not. By grouping receivables by age, the report gives an early warning of collection trouble, shows which customers are slow or at risk, and provides the basis for estimating bad debt, the allowance a company sets aside for amounts it does not expect to collect. It also guides day-to-day work, telling the collections team where to focus and informing credit decisions about which customers can be trusted with more time to pay. The same aging logic can be applied to accounts payable, showing what the company itself owes and when.

The aging report earns its keep by revealing what a single number conceals. A company's total accounts receivable, one figure for everything owed, says nothing about the quality of that money. Two businesses can report the same receivables total while one is owed almost entirely current invoices and the other is owed a mass of ninety-day-old debt unlikely to be paid. The aging report separates them by spreading the total across age buckets, exposing the distribution the headline figure hides. A related measure, days sales outstanding (DSO), collapses collection speed into a single average number of days to get paid. That average is useful, but it too can mask a dangerous tail of very old debt sitting behind an otherwise healthy mean.

So the aging report, a single receivables balance, and DSO answer progressively richer questions. The balance tells you how much is owed; DSO tells you, on average, how quickly it is being collected; the aging report tells you the full shape of the debt, how much is current, how much is slipping, and how much has aged into likely loss. For managing collections and credit risk, the distribution is what matters, because the risk lives in the tail, not the average. Relying only on the total or on DSO can leave a growing pile of uncollectible old invoices unnoticed. The aging report is the tool that makes that tail visible, which is why it, rather than a lone figure, drives collections priorities and bad-debt estimates.

Using an aging report well means acting on the distribution it reveals, not just producing it. That means reviewing it regularly, chasing overdue invoices before they age into the high-risk buckets, and concentrating collection effort where the money and the risk are greatest, often a handful of large, old balances. It means using the age profile to set the allowance for doubtful accounts realistically and to inform credit decisions, tightening terms for customers who consistently drift into the late columns. Kept current and paired with prompt follow-up, an aging report turns receivables from a static number into a managed asset. How a specific business should provision for or collect its receivables is a matter for its finance professionals.

The failures are mostly failures to act. Producing an aging report and then ignoring the old buckets lets collectible debt slip into uncollectible territory, since the odds of payment fall the longer an invoice ages. Extending more credit to customers who already fill the late columns compounds the problem. Reading only the total receivables or the average DSO, without the age distribution, hides the risky tail until it becomes a write-off. Understating the allowance for doubtful accounts by ignoring how much is badly overdue flatters the balance sheet. The discipline is to review the aging report often, chase overdue amounts early, focus on the largest and oldest balances, and let the age profile drive both credit decisions and honest bad-debt provisioning.

An aging report groups unpaid invoices by how overdue they are, surfacing the risky tail of old receivables that a single total or an average days-sales-outstanding figure hides.

Etymology: source.

Search interest for this term over the last five years:

View interest-over-time on Google Trends →

Areas of marketing where aging report is a core concern: