Accounts Receivable Aging: The Most Honest Report in Your Bookkeeping
The single fastest diagnostic for whether a small business is in trouble is not the income statement. It is the AR aging report. Show me a 90-day bucket that has been growing month over month, and I will show you a business that does not yet know it is in real trouble.
Accounts receivable aging is the report most owners glance at and almost no owner manages. It is also the most honest document on your bookkeeper's desk — because unlike the income statement, the aging report does not let you confuse a number with a deposit. Cash that should have been in your bank account three months ago is right there, named, dated, and getting older every week.
If you do nothing else with your books this quarter, build a habit around reading this one report. The patterns it reveals are the patterns that will either fund your next year of growth or quietly bleed you out.
What the aging report is actually telling you:
- DSO is the headline number, and most owners do not know theirs. Days Sales Outstanding is the average number of days it takes you to collect on an invoice — calculated as (AR balance ÷ credit sales) × days in the period. If your DSO is 45 days against Net 30 terms, you are running 15 days late on average. If your DSO is 75 days against Net 30 terms, you are operating with a serious collection problem regardless of how clean the P&L looks. Industry benchmarks matter: professional services typically run 45 to 60, construction can run 60 to 90, retail and ecommerce should be under 5. Compare yourself to your industry, not your gut.
- The 30/60/90 buckets predict collectability with surprising accuracy. Current AR (0 to 30 days) typically collects at 95% or higher. AR aged 31 to 60 days drops to roughly 88%. AR aged 61 to 90 days drops to 75%. AR over 90 days collects at 50% or less and gets worse the longer it sits. This is not your accountant's opinion — it is a well-documented industry pattern. When you see a customer aging into the 90-day bucket, the math says you are about to write off half of what they owe you. Treat that bucket as a fire, not a footnote.
- Aging exposes customer concentration risk. A clean aging report can still hide a fatal problem: if 40% of your AR is concentrated in one customer, that customer's payment behavior is your cash flow. Operators who never break aging down by customer never see this. The day that customer disputes an invoice, slows their payments, or files Chapter 11, the business goes from healthy to scrambling overnight. Run aging by customer once a month, every month.
- Average DSO masks distribution. A 45-day DSO can mean every customer pays in 45 days, or it can mean half pay in 20 and half pay in 70. The second scenario is much more dangerous — it means a meaningful slice of your customer base is structurally slow, and slow customers tend to get slower, not faster. Looking at DSO without looking at the distribution of paying behavior misses the real story. The median is a better signal than the average; the worst quartile is the best one.
- Bad debt reserves are not optional once aging is real. If your aging report consistently shows balances over 90 days, you should be reserving for bad debt — recognizing in advance that some portion of those receivables will not collect. Owners who do not reserve and just write off bad debt when they finally give up are overstating profit in the periods they should have reserved, and then taking a lumpy hit at write-off. Lenders and buyers notice, and both penalize the inconsistency.
- Collection cadence is operational, not aspirational. The single highest-leverage intervention in AR management is consistent dunning — automated reminder at day 1 past due, phone call at day 7, escalation at day 15, formal demand at day 30, collections referral at day 60. Most businesses skip this entirely or do it in bursts when cash gets tight. Customers who learn that your business does not call them when they are late will pay everyone else first.
- Aging is also a sales-process diagnostic. When AR ages systematically across the customer base, the problem usually isn't customer behavior — it is your invoicing process. Late invoices, vague payment terms on quotes, missing PO references on bills, manual approval workflows that delay submission. The aging report is showing you the back end of a broken front end. Fixing the invoice process often shortens DSO faster than any collection effort.
- The aging trend matters more than the snapshot. A 60-day average DSO that has been 60 for two years is a different business than a 60-day average DSO that was 35 six months ago. The first is structural. The second is a deterioration that should be triggering a board-level conversation. Chart aging by bucket over 12 trailing months and the story tells itself.
What it costs to ignore your aging report: cash flow crises that should have been predictable, bad debt write-offs that compound margin pressure, and a customer base that learns to pay you last because you have trained them to.
What it earns you to manage it: a measurable improvement in DSO almost every time, a cleaner picture for lenders, and a meaningful working-capital release in the first quarter of disciplined collection.
We help small business owners build the aging discipline that turns AR from a passive ledger entry into an active part of cash flow management.