The $800K Blind Spot: What’s Actually Sitting in Your Aging Report Right Now

There’s a number on your aging report that you already know about.

Maybe you glance at it when you run your monthly financials. Maybe you’ve stopped looking at it altogether because it’s just there, growing, doing its quiet damage. Either way, for a lot of law firms, that number is bigger than it should be — and it’s been that way for a while.

Here’s what that number actually represents at most small and mid-size firms, and why it keeps building up despite everyone’s best intentions.

What the Aging Report Really Looks Like

When Matt Darner, co-founder of CollBox, walks into a new firm relationship, he’s seen hundreds of law firm billing situations at this point. And the picture is almost always the same.

For firms with three to ten attorneys, the 90-days-plus bucket on the aging report consistently holds somewhere between $300,000 and $800,000 in unpaid invoices. Not total billings. Just the portion that’s been sitting past due for at least three months.

Matt shared this pattern in a recent interview on Ruby Powers’ Power Up Your Practice podcast, alongside the data that gives it real weight: by 90 days of delinquency, firms have already lost as much as 47% of collectability on those invoices.

That’s not a typo. For a small firm, that aging report number represents a house, tuition, years of vacation. Whatever your reason for running the business, seeing it live in a report and go unaddressed year after year is its own kind of drain.

And yet it just sits there.

Most of it lives in closed matters, work that was completed, delivered, and billed, where the legal relationship has technically ended but the invoice never got paid. Once a matter closes, the natural urgency to resolve billing issues tends to evaporate on both sides. The attorney moves on to active cases. The client, having received what they needed, has little incentive to prioritize a bill they’re no longer being reminded about consistently.

That’s how $300,000 becomes $500,000 becomes $800,000. Not through negligence exactly, but through the accumulation of closed matters where nobody circled back with any real persistence. It’s the same pattern Clio’s Legal Trends Report has documented at the industry level, where the average firm carries a 93-day lockup period — nearly three months between performing work and getting paid.

Why Nobody Fixes It

Understanding why this happens doesn’t require anything complicated. A few dynamics show up repeatedly.

First, attorneys are genuinely uncomfortable confronting clients about money. This isn’t a character flaw — it’s a professional culture issue baked into legal practice. Matt has described it as the “ick factor” in multiple conversations, including his appearance on the ABA’s Law Practice Podcast, where he was featured in the Best of 2025 episode for his work on law firm cash flow. The relationship with a client is supposed to be about the law, and asking for payment feels like it disrupts that. So it gets avoided, delayed, or delegated to someone else.

Second, the person it usually gets delegated to is not the right person for the job. It often falls to a paralegal, office manager, or assistant who is already managing a full load of other responsibilities and who has no real training in AR follow-up. They send a reminder email or two and, when ignored, move on. The invoice ages. Our look at how to talk to clients about money gets into why this delegation problem runs deeper than most firms expect.

Third, and maybe most importantly, there’s no system in place that treats past-due invoices as requiring the same urgency as a court deadline. Without a consistent trigger and a defined escalation path, overdue invoices just accumulate. Our piece on simplifying your billing process covers what a real system looks like in practice.

The result is that glaring number at the bottom of the aging report. Firms know it’s there. It offends them. But there’s no obvious moment when it becomes someone’s clear responsibility to do something about it.

The Gray Zone Problem

One reason firms avoid addressing the aging report is a kind of paralysis about what to do. The full amount feels uncollectible. Writing it all off feels wasteful. So nothing happens.

Not every invoice in that 90-plus bucket is recoverable, but not all of it belongs in the write-off pile either. It’s shades of gray. Each one behaves differently depending on the client’s circumstances, the nature of the matter, the strength of the relationship, and how long ago the work was completed.

The useful exercise isn’t treating the number as a monolith. It’s bucketing it. Which invoices are genuinely recent enough that a phone call might resolve them? Which ones have gone cold but are worth a structured 60-day effort? Which ones are old enough that the write-off decision is the right one?

That bucketing exercise alone, done with some rigor, usually produces immediate recoveries. Firms often find that a meaningful portion of their 90-plus balance consists of clients who just needed someone to actually follow up. For practice areas like family law and immigration, where leverage evaporates quickly at case close, this triage is especially important. Our breakdown of the unique collections challenges in family law covers why timing matters so differently in that practice area.

The Cash Flow Reality Behind the Number

The aging report number doesn’t just represent money not yet received. It represents a real distortion of how a firm understands its own financial health.

A firm can look profitable on paper, with strong billings and growing revenue, and still be in genuine cash flow trouble because too much of what was earned is sitting uncollected. Darren Wurz illustrated this vividly on his Lawyer Millionaire podcast: a firm generating $1.5 million in annual revenue was contemplating bankruptcy because of $500,000 in accumulated debt and a cash flow gap it had never addressed. Revenue was masking the problem. As we explored in our piece on law firm debt and cash flow, the gap between billing and collecting is where firms quietly get into trouble.

Matt raised the same issue in his Financially Legal appearance with Emery Wager, available here, framing lockup as a structural problem rather than a discipline problem. Firms aren’t failing to collect because they’re careless. They’re failing to collect because no one has built a system that makes consistent follow-up the default.

The 93-day lockup crisis compounds this. When it takes three months on average to get paid for completed work, any disruption to the follow-up process creates a backlog fast. And the backlog, once it forms, almost never shrinks on its own.

What the Right Firms Are Doing Differently

The firms that consistently keep their aging report clean share one trait: they treat AR follow-up as a defined process with a clear owner, not an informal task that falls to whoever has time.

For most firms, that means either building an internal system with explicit triggers and escalation paths, or working with a service that handles it externally. CollBox was built to be that external system. It integrates with Clio, MyCase, and Smokeball to automatically detect invoices as they age past due, then initiates a structured follow-up sequence that combines automated email reminders with real phone calls from trained AR specialists.

The impact of that kind of systematic follow-up is documented in the Pines Federal case study, where a firm rebuilt its entire collections process by pairing CollBox with Tempello for time tracking and billing. The combination of capturing hours accurately and following up consistently is what actually closes the gap between what a firm earns and what it gets paid.

CollBox’s approach and results were recognized at the 2026 ABA TECHSHOW Startup Alley, where the firm won first place out of 15 legal tech startups — voted to the top by an audience of attorneys who recognized the problem from their own firms. The win was covered by LawNext, the ABA Journal, and Law360 Pulse.

If that $300,000 to $800,000 number is sitting on your aging report right now, a conversation with Matt is a useful first step toward understanding what’s actually there — and what’s realistically recoverable.

CollBox helps law firms recover what they’ve already earned through a purpose-built AR management process that integrates with your existing practice management system. Firms using CollBox recover an average of $66,000 per month and get paid 40% faster. Winner of Clio’s 2025 Best Business of Law App Award and the 2026 ABA TECHSHOW Startup Alley competition. collbox.co