An aging report is the most looked-at document in a practice and one of the least useful in the form most people read it.
Every line looks the same. A balance submitted last week and a balance past its filing deadline sit in adjacent rows, formatted identically, and the report offers no way to tell them apart. One of those is money. The other never will be.
How do I read an aging report properly?
Stop reading it by age and start reading it by category. Age tells you how long a balance has been open, which is the least useful thing about it. What matters is whether the balance is still collectible, who has to act next, and whether the age on the line is the real age of the claim.
What the report is actually recording
Every line is something you have asked for and not yet received.
That is a narrower statement than it appears. It excludes everything you have delivered and not yet billed, because a balance does not exist until a claim goes out. It includes balances that will never pay. And it presents both alongside genuinely active claims with no distinction between them.
So the total at the bottom is not what you are owed. It is what you have asked for, minus what has already arrived, plus whatever has stopped being collectible without anybody removing it.
The four categories hiding inside it
Sort any aging report by what each balance actually is and four groups fall out. They behave completely differently and only one of them is worth working today.
Active and collectible. Claims inside the normal adjudication window, balances recently sent to patients. Nothing is wrong. Working these harder achieves very little, because time is doing the work.
Stalled and recoverable. Claims aged past what is normal for that payer, denials never appealed, balances nobody has followed up. This is the group that repays attention and it is usually smaller than the report makes it look.
Dead but still listed. Past the filing or appeal window, so uncollectible as a matter of contract. Nothing on the report says so, and it keeps aging alongside live balances indefinitely.
Not really outstanding. Payments received and never posted, duplicate charges, balances cleared by a code that moved them rather than removing them. Money that has already arrived or never existed.
Two of those four make your receivables total larger than reality, and neither of them ever makes it smaller. The distortion runs one direction only, which is why a practice consistently believes it is owed more than it is.
Why the age on the line may not be the age of the claim
Worth knowing before you trust the buckets at all.
When a claim is corrected and resubmitted, the age on many reports restarts from the resubmission. A claim first sent ninety days ago and rebilled last week can appear in the current column looking healthy.
Which means a practice with a lot of rework can post an aging profile that looks tighter than the reality, and the claims most in trouble are the ones most likely to have been resubmitted.
The check: compare the age since original date of service against the age the report shows. Where the two diverge, the report is describing the last attempt rather than the claim.
What the report cannot show you at all
Everything before a claim exists.
A visit delivered and not yet documented, a note signed with no charge created, a claim built and never released. None of it appears in receivables, because a receivable begins when you ask for payment. HFMA‘s own standard for billed accounts receivable excludes any account not yet billed.
So a practice can carry weeks of delay upstream while its aging report looks entirely healthy, and the two facts are perfectly compatible. The report is not wrong. It is silent about a stage it was never built to observe.
That is worth holding onto when the report looks fine and the bank balance does not.
Getting deeper visibility from your AdvancedMD data
The standard aging view sorts by age and by payer, which answers the questions it was designed for.
Three additions turn it into something you can act on, and all three draw on records the system already holds.
A filing deadline flag. Every payer has a submission and appeal window. Comparing each balance against the relevant limit separates dead from stalled, and that separation is the difference between working a list and working the right list.
Original date of service alongside the report age. Surfaces claims where the age restarted on resubmission.
An unposted remittance count next to the total. Tells you how much of the balance has already been paid and simply not applied.
None of that requires anything beyond what is already recorded. It requires deciding the aging view should answer a different question than the one it currently answers.
What this means for you
Take your current aging report and sort it into the four categories rather than by age. Active, stalled, dead, and not really outstanding.
What is left in the stalled column is your actual work list, and in most practices it is a fraction of the total everybody has been looking at. That is a better week’s work than chasing a number that includes money already in your bank.
Grab 30 minutes with us. Prep nothing. You will see which of your receivables is money and which was never going to be.
Questions people ask
How do I read an aging report properly?
Sort by category rather than by age. Active and collectible, stalled and recoverable, dead but still listed, and not really outstanding. Only the second group repays attention, and it is usually smaller than the total suggests.
Why does my aging report show balances that will never pay?
Because nothing removes them. A balance past its filing or appeal window is uncollectible as a matter of contract, and it keeps aging alongside live claims. The report has no way to mark the difference.
Can the age on an aging report be wrong?
It can describe the last attempt rather than the claim. When a claim is corrected and resubmitted, the age often restarts, so a claim first sent ninety days ago can appear current. Compare against the original date of service.
Does an aging report include unbilled work?
No. A receivable begins when you ask for payment, and HFMA’s standard excludes any account not yet billed. A practice can carry weeks of upstream delay while its aging report looks healthy.
Why does my receivables total always look too high?
Because every distortion runs one direction. Dead balances, unposted payments, and duplicates all inflate the total, and nothing deflates it. A practice consistently believes it is owed more than it is.
PracticePath is not affiliated with, endorsed by, or sponsored by AdvancedMD. AdvancedMD is a trademark of AdvancedMD, Inc. All references are for descriptive purposes only.