What Your Aging Report Is Trying to Tell You

The report owners skip

Most practice owners can recite last month's revenue from memory. Ask how much of that money is still stuck in insurance limbo, and the answer gets fuzzy. That number lives in your accounts receivable aging report, and for a lot of growing clinics it is the most honest page in the whole system.

The aging report sorts every unpaid claim by how long it has been waiting: current, 31 to 60 days, 61 to 90, and then the bucket nobody likes to look at, anything past 90. Each column tells a different story about how your billing actually works rather than how you assume it works.

Why the 90-day column matters more than the total

A large receivable balance is not automatically a problem. A practice that is growing fast will always have money in motion. What matters is where that money sits and how long it stays there.

When claims pile up past 90 days, you are usually looking at one of three things. The payer denied the claim and nobody followed up. The claim was never submitted cleanly in the first place. Or the service was delivered, documented, and billed correctly, but it slipped through a crack because the person tracking it got busy. All three are fixable, but only if you can see them.

A claim that ages past 90 days is worth a fraction of its face value, because the odds of collecting drop with every week it waits.

That last part is the piece owners tend to underestimate. Old claims do not sit there politely waiting for attention. They expire. Timely filing limits, appeal windows, and authorization lapses all work against you, and once those doors close the revenue is simply gone.

What a healthy report looks like

There is no perfect number, but a clinic with a clean revenue cycle usually keeps the large majority of its receivables in the current and 31 to 60 day columns. The 90-plus bucket stays small and, just as important, stays familiar. You should be able to look at every claim in it and know the story behind each one.

Getting there comes down to rhythm more than heroics:

• Work the aging report on a fixed day every week, not whenever someone remembers
• Touch every claim before it crosses 30 days, even if the touch is only a status check
• Track denials by reason code so you can fix the upstream problem instead of reworking the same claim forever
• Reconcile what you billed against what actually paid, line by line, every month

None of that requires new software or a bigger team. It requires someone whose job is to own the number and report on it without being asked.

The quiet cost of letting it slide

When receivables drift, the damage rarely arrives as a single dramatic event. It shows up as a slow tightening. Payroll feels harder than the revenue says it should. You hesitate before approving a hire you clearly need. A line of credit that was supposed to be a safety net quietly becomes part of how you operate.

Cleaning up the aging report fixes more than a spreadsheet. It gives you back the cash you already earned, and it hands you a forecast you can actually trust. For a practice trying to grow on purpose rather than by luck, that trust is most of the battle.

If your 90-day column has grown into a place you would rather not look, that is the best possible reason to look. The money is often still recoverable, and the patterns hiding in that report will tell you exactly what to fix first.