How to Read a Receivables Aging Report Without Wanting to Cry

The first time I really looked at an aging report, I did what every owner does: scanned to the bottom-right corner, found the scary number in the 90+ column, and felt my stomach drop. That's the wrong move, and almost everyone makes it.

A receivables aging report isn't a horror story. It's a diagnostic — it tells you how fast customers pay, where collections are leaking, and which upstream habits are costing you cash. The corner number is real, but it's a lagging indicator. By the time a dollar lands in 90+, the problem happened weeks ago.

Here's the stat worth anchoring on: small businesses run a Days Sales Outstanding of roughly 27 days, and B2B late-payment studies consistently find about half of all invoices get paid late. So if it feels like half your customers are slow, you're right — that's the baseline. The report just makes it legible.

A worked example: the $500K fabrication shop

Picture a custom fabrication shop doing $500K/year, carrying about $90K in open receivables. The report sorts every open invoice into time buckets by how long it's been outstanding — Current (not yet due), then 1–30, 31–60, 61–90, and 90+ days past due. The signal is in how the money is distributed, not the total.

| Bucket | Amount | Share | What it signals | |---|---|---|---| | Current | $48,000 | 53% | Healthy — invoiced, not yet due | | 1–30 | $22,000 | 24% | Normal Net-30 friction | | 31–60 | $11,000 | 12% | Follow-up is slipping | | 61–90 | $6,000 | 7% | Active collections risk | | 90+ | $3,000 | 3% | Likely partial loss | | Total | $90,000 | 100% | |

At first glance this looks fine — most of the money is on the left. But weight on the left side means a cash timing problem; weight in 61–90 and 90+ means a collections problem. Same total, different fix. Run the three numbers and the picture sharpens.

The three numbers to watch

So the "looks fine" report is actually flashing two warnings: DSO is 2.4x the benchmark, and there's a six-thousand-dollar fire in 61–90 with a name on it.

The action each bucket triggers

• Current: Do nothing but make sure it got invoiced promptly. The faster the invoice goes out, the sooner the clock starts.
• 1–30: Friendly reminder around day 25. Most "late" invoices are forgotten, not refused.
• 31–60: A second, firmer nudge. Skip it and money walks into 61–90 by default.
• 61–90: Pick up the phone. Email isn't enough. Get a commitment and a date.
• 90+: Decide — payment plan, final demand, or write-off. Carrying dead receivables just flatters a number that isn't real.

Why the report is lagging — and where the real fix lives

The aging report is the symptom, not the disease. Every dollar in 61–90 got there through a chain of upstream misses: a quote that took four days to send, an invoice that went out a week late, a follow-up that never happened. That ~27-day benchmark isn't about chasing money harder — it's about how fast and consistent your whole quote-to-cash loop runs. Shops with clean reports aren't better at collections; they're better at not creating slow receivables. They quote fast, invoice the day the job closes, and follow up like clockwork. I broke down why 27 days is the number to beat in The 27-Day Problem.

That's the part I built Setell to own. It drafts quotes from inbound email so they go out same-day, syncs the invoice to QuickBooks when the job closes, and follows up on its own — at the autonomy level you set: Watch, Trust, or Auto. The point isn't to chase money harder. It's to stop manufacturing slow receivables.

Pull the report once a month. Read the shape, not the total. Watch DSO, percent over 60, and your biggest overdue invoice. If you want the full operational picture across the whole cash cycle — quoting speed, invoicing lag, and follow-up cadence as one system — the Cash Cycle Scorecard is free and walks through all of it.

Ready to quote faster?

Start free — no credit card. See your first AI-drafted quote in minutes.