Aging Buckets: The Detail Behind a Single DSO Number

A single average DSO figure can look perfectly healthy while hiding a genuinely serious problem sitting in one specific slice of the receivables balance - which is exactly why serious credit management goes a level deeper, into what's called an aging schedule.

What an Aging Schedule Actually Shows

An accounts receivable aging schedule sorts every outstanding invoice into buckets based on how long it's been unpaid - commonly current (not yet due), 1-30 days past due, 31-60 days, 61-90 days, and over 90 days past due. This breakdown reveals something a single blended DSO average genuinely cannot: two companies with an identical average DSO of 45 days can have very different underlying risk profiles if one has that total spread evenly across mostly-current invoices, while the other has a large concentration of severely overdue balances offsetting a pile of very promptly-paid ones.

A Worked Comparison

Company B's much larger share of severely overdue receivables represents real collection risk that an averaged DSO figure alone would completely obscure - both companies could report a similar headline DSO despite carrying very different actual collection risk.

The Direct Link to Bad Debt Reserve Accounting

Aging buckets aren't just an internal management tool - they directly drive a required accounting estimate called the allowance for doubtful accounts (or bad debt reserve), the amount a company sets aside against receivables it doesn't expect to fully collect. Standard practice applies a higher expected loss percentage to older, more overdue buckets (since the longer an invoice goes unpaid, the less likely it is to ever be collected) and a lower percentage to current, not-yet-due invoices. A company whose aging schedule is shifting toward the older buckets over time, even with a stable average DSO, should logically be increasing its bad debt reserve to match - and a company that fails to do so while its aging profile deteriorates is likely understating its true expected credit losses.

Applying This When DSO Looks Fine But Something Feels Off

Whenever a company's reported DSO looks stable or healthy but qualitative signals (customer complaints, industry stress, a large customer's own financial trouble) suggest collection risk might be rising, requesting or estimating the underlying aging schedule - rather than trusting the single blended average - is the way to actually see whether that risk is concentrated somewhere the headline number is hiding.