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
• Watch your clean claim rate monthly, since claims that go out wrong are what fill the older columns to begin with
• 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.

Frequently asked questions about the AR aging report

What is an accounts receivable aging report?

An accounts receivable aging report sorts every unpaid claim by how long it has been waiting, typically into current, 31 to 60 days, 61 to 90 days, and anything past 90. Each column describes a different part of how your billing actually works rather than how you assume it works, which is why it is often the most honest page in a practice's financial system.

What does a healthy aging report look like for an ABA practice?

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, with a small 90-plus bucket. Just as important, that bucket should stay familiar, meaning you can look at every claim in it and know the story behind each one.

Why do claims past 90 days matter more than the total balance?

A large receivable balance is not automatically a problem, since a fast-growing practice always has money in motion. Claims that age past 90 days are worth a fraction of their face value because timely filing limits, appeal windows, and authorization lapses all work against you, and once those doors close the revenue is gone rather than delayed.

How often should you work your aging report?

Work it on a fixed day every week rather than whenever someone remembers, and touch every claim before it crosses 30 days even if the touch is only a status check. The practices that collect well treat it as a rhythm with a clear owner instead of a periodic cleanup effort.

If you would rather hand the whole cycle to a team that works your aging report every week, our full-cycle RCM service does exactly that. You can also estimate how much revenue you could recover or talk it through with us.