The report that tells you who to chase first
Almost every cash-flow problem in a small business eventually traces back to the same place: money that's been earned but not collected. The accounts receivable aging report is the one report built to expose exactly that. It takes every open invoice and sorts it by how overdue it is, so instead of staring at a single "receivables" total you can see which customers owe you, how long they've owed it, and which dollars are quietly turning into a problem. Other guides on this site lean on the aging report constantly — for getting paid faster, for estimating bad debt, for sanity-checking your liquidity ratios. This article explains the report itself. (General education, not accounting advice.)
What the buckets actually mean
An aging report lays your open invoices out in columns by age, usually in 30-day bands:
- Current — not yet past due. Healthy. This is money in flight, working as designed.
- 1–30 days past due — slipping. Often just an oversight or an invoice that triggered a question.
- 31–60 days past due — a pattern, not an accident. The customer has now missed at least one normal payment cycle.
- 61–90 days past due — a real risk. The longer an invoice ages, the lower the odds it's ever collected in full.
- 90+ days past due — danger. Statistically, money this old is the most likely to become a bad-debt write-off.
Each row is a customer; each column is a dollar amount in that age band. The power of the report is in the shape: a business with most of its balance in Current is healthy, while one with a fat 90+ column has a collections problem masquerading as revenue. The same total receivable — say $50,000 — means something completely different if it's all current versus half of it sitting past 60 days.
DSO: the one number that summarizes it
The aging report's headline metric is Days Sales Outstanding (DSO) — the average number of days it takes you to collect after making a sale. The shape of the idea is simple: it compares your outstanding receivables to your sales over a period, and expresses the result as a number of days.
What matters is what DSO tells you, not the arithmetic:
- A low, stable DSO means cash comes in close to when you earn it — the cash-flow forecasting dream.
- A rising DSO is an early warning. It means collections are slipping before it shows up as a crisis in your bank balance. Watching the trend month over month is more useful than any single reading.
- DSO well above your payment terms (say a 45-day DSO on net-15 terms) means your stated terms and your real-world collections have come apart. That gap is cash you've financed for your customers for free.
The escalation cadence
A report you only look at changes nothing. The value comes from attaching a standard, unemotional escalation cadence to the buckets, so chasing payment is a routine the report triggers — not an awkward decision you make customer by customer:
- Current → just-due: A friendly automated reminder a few days before and on the due date. Most on-time payment comes from simply asking at the right moment.
- 1–30 days: A polite "this is now past due" email with the invoice re-attached. Often the invoice was lost, held up by a missing PO, or stuck in an approval queue — make it effortless to pay.
- 31–60 days: A firmer notice, ideally a phone call. Confirm they received it, there's no dispute, and get a committed payment date. This is also where any late fee you disclosed up front starts to matter.
- 61–90 days: A formal demand referencing your terms, and a pause on further work or orders until the balance clears. Silence at this stage is itself information.
- 90+ days: Final demand, then a decision — payment plan, third-party collections, or recognizing it as bad debt. At this point the goal shifts from "collect in full" to "stop the bleeding."
The point of writing this down is that the report decides who gets which message, not your mood or how much you like the customer. Consistency is what makes collections work.
Where the report can lie to you
An aging report is only as honest as the bookkeeping under it. Two traps:
- Unapplied payments and credits. If a customer paid but the payment was never matched to their invoice, the report shows them as delinquent when they're square. Chasing a customer who already paid is a fast way to lose them. Keeping payments and credit memos applied is what keeps the report trustworthy.
- Stale "phantom" receivables. Invoices that will never be paid but were never written off inflate every bucket and distort DSO. Reviewing the 90+ column as part of your month-end close keeps the report — and your liquidity ratios — honest.
Make it a habit, not a fire drill
The businesses that collect well aren't the ones with the toughest emails — they're the ones that look at the aging report on a schedule. Pull it weekly, work the oldest buckets first, and fold a deeper review into your month-end close. Done consistently, the report turns collections from a stressful, reactive scramble into a quiet, repeatable routine. Hosting Books generates your aging report straight from the ledger and tracks DSO over time, so the customers who need a nudge surface on their own.
This article is general information, not accounting or legal advice. Collections rules and contract terms vary — confirm specifics with a qualified professional.