Unpaid invoices rarely die in one dramatic moment. One client slips a week. Another drifts three weeks past due. Each gap feels too small to chase. Then the bank balance stops matching the pipeline, and you're short on payroll week. The invoice aging report is the tool that catches that drift early — the early-warning system most founders ignore until collections become a crisis.
This piece is for founders and operators running services firms doing $1M–$50M. You already know your revenue looks healthy. The problem is timing. Let's read the report the way a CFO would.
The report is a timeline, not a list
An invoice aging report sorts every open invoice into buckets by how many days it's overdue. The standard columns are Current, 1–30, 31–60, 61–90, and 90+ days.
Each bucket tells a different story. Current means the client hasn't hit the due date yet. The 1–30 bucket is a soft slip — usually a busy AP team, not a problem. Past 60 days, collectability drops fast. Money in the 90+ bucket often never arrives.
The mistake is reading only the total. A firm with $400K in receivables feels flush. But if $180K sits past 60 days, that's not a balance — it's a warning. The buckets show you when cash is likely to land, which is the number your runway actually depends on. Your accounts receivable total hides that timing entirely.
Small slips are the real threat
The reader question we hear most: invoices slip away quietly, and each one feels too small to chase.
That instinct is expensive. A single client 10 days late is noise. Six clients averaging 25 days late is a systemic collections gap that quietly moves your cash-in date by three weeks. You don't feel any single one. You feel the sum.
Clio's 2024 Legal Trends Report found that firms collect a meaningful slice of billed work slowly or not at all — the gap between billed and collected is where margin evaporates. The Journal of Accountancy has made the same point for decades: fees uncollected past 90 days are dramatically harder to recover.
The fix is a threshold, not vigilance. Set a rule: any invoice that crosses 15 days past due gets a chase, no exceptions and no judgment call. When the trigger is automatic, small slips never compound into a cash gap.
When the buckets are wrong, people stop trusting the report
The second reader question is just as common: aging reports show wrong buckets or balances for clients who've already paid, so people stop trusting them and stop using them.
This is real, and it's almost always a data-hygiene problem, not a math problem. The usual causes:
- Unapplied payments. A client paid, but the deposit was never matched to the invoice. The invoice still shows open.
- Duplicate invoices. The same work was billed twice, and one copy lingers in the 90+ bucket forever.
- Credits and write-offs not recorded. You agreed to a discount verbally but never issued the credit memo.
- Stale sync. Your report reads bookkeeping data that's weeks old, so payments landed but the report hasn't caught up.
A report you don't trust is a report you don't use. Clean these four monthly. The AICPA's firm practice management guidance treats receivables hygiene as a core operating discipline, not an accounting chore.
CentSight sits on top of QuickBooks and your bank as the intelligence layer — synced on demand, as often as every fifteen minutes. That freshness matters here. When a client pays Tuesday, you shouldn't be chasing them Thursday because the report was a week behind.
Pair the buckets with DSO
The aging report tells you which invoices are late. Days Sales Outstanding tells you whether late is your normal state.
DSO measures the average number of days it takes to collect after billing. A firm with 30-day terms but a 52-day DSO is financing its clients for three extra weeks — every single month. That's runway you're lending out for free.
Run the number with our DSO calculator, then watch the trend. Rising DSO alongside a fattening 31–60 bucket is the clearest signal your collections process is slipping. Oracle NetSuite lists collections speed among the KPIs consulting firms should watch monthly, and your AR turnover rate tells the same story from a different angle.
Aging is a symptom — check upstream too
A late invoice is often a billing problem wearing a collections mask. If the invoice went out late, it lands late.
Harvard Business Review notes that the strongest professional-services firms treat the full cycle — scope, deliver, bill, collect — as one connected system. Break the chain anywhere and cash slips.
Look upstream from the aging report:
- Unbilled work. Time worked but never invoiced never enters the aging report at all. It's invisible cash. See our guide on unbilled revenue.
- Milestone gaps. If you bill at project end instead of at milestones, you carry the entire balance for months. Milestone billing pulls cash forward.
- Realization leaks. Billed less than you worked? That gap compounds. LeanLaw explains realization rate and how to track it.
Fix the upstream billing discipline and the aging report gets healthier on its own. Our full accounts receivable playbook walks the whole chain, and the billing management hub collects the rest.
Your monthly aging routine
Here's the routine I'd recommend. It takes 20 minutes.
- Reconcile first. Clear unapplied payments and duplicates so the buckets are true.
- Read the shape, not the total. How much sits past 60 days? That's your at-risk number.
- Chase the 15-day line. Every invoice past the threshold gets contacted — automatically.
- Log DSO. Track the trend, not the snapshot.
- Check upstream. Unbilled work and late invoices feed next month's aging.
The takeaway: the aging report doesn't fail founders — ignoring the small slips does. Read the buckets before the gap appears, and the cash crisis never gets a chance to form. If a late invoice confirms what you already knew, you're out nothing. If it doesn't, you just found the payment that was quietly draining next month's runway.
