Most practices open their AR aging report once a month, glance at the total, and close it. That habit is costly. This single report shows exactly where your cash is stuck and how long it has been sitting there.
When you know how to read a medical AR aging report, you can spot a slow payer, a broken workflow, or a pile of unworked denials weeks before they show up in your bank balance. This guide covers the buckets, the numbers that matter, the warning signs, and a simple weekly routine that keeps small problems from becoming write-offs.
What Is a Medical AR Aging Report?
A medical AR aging report lists every unpaid insurance claim and patient balance, grouped by how long each one has been outstanding. Think of it as a health check for your cash. It answers three questions: who owes you money, how much, and for how long.
Most reports use the same five columns, called aging buckets. Strong accounts receivable follow-up depends on watching all five, not just the total at the bottom.
- 0 to 30 days: Newly submitted claims still moving through normal payer processing.
- 31 to 60 days: Claims that should have paid by now and need a status check.
- 61 to 90 days: Claims at risk. Something is probably wrong.
- 91 to 120 days: Claims that need senior attention and a clear plan.
- Over 120 days: Claims with a low chance of collection and a closing appeal window.
Why Aging Buckets Matter More Than the Total
Two practices can both show $400,000 in AR and be in completely different financial shape. If one has most of that balance in the first two buckets, cash is flowing normally. If the other has a third of it past 90 days, it has a collection problem hiding behind the same total.
The reason is simple. The older a claim gets, the harder it is to collect. Payers have filing and appeal deadlines, documentation gets harder to find, and staff attention moves to newer work. Our guide to accounts receivable management tips covers why early follow-up consistently beats late rescue efforts.
A healthy report has its largest share in the 0 to 30 day bucket, and each older bucket gets progressively smaller. When that pattern flips, something upstream is wrong.
How to Read a Medical AR Aging Report, Step by Step
Follow this order every time you open the report. It takes about fifteen minutes once you get used to it.
- Check the report date and filters. Open the AR aging report and confirm the “as of” date and whether it ages from the date of service or the billing date. Mixing the two makes comparisons meaningless.
- Look at the total, then the distribution. Convert each bucket into a percentage of total AR. Dollar figures hide trends that percentages reveal.
- Split insurance from patient balances. Payer balances need claim follow-up. Patient balances need statements and payment plans. They are different problems.
- Sort by payer. Find out which payers hold the most money past 60 days. One slow payer often explains most of the damage.
- Scan for credits and unapplied cash. Negative balances usually mean a payment posting error or an overpayment that needs a refund.
- List your top ten oldest accounts. These get worked first, every time.
The Numbers That Tell You the Real Story
The report becomes far more useful once you pair it with a few simple calculations.
Days in AR
Days in AR shows how long it takes, on average, to turn a charge into cash. The basic formula is total AR divided by average daily charges.
Here is an example with sample numbers. If your total AR is $300,000 and you billed $720,000 over the last 90 days, your average daily charge is $8,000. Divide $300,000 by $8,000 and you get 37.5 days. Track this number monthly, because a rise of even a few days usually means cash is arriving more slowly. Many practices aim for a range of roughly 30 to 40 days, though the right target depends on specialty and payer mix, as our guide to revenue cycle management for physician practices explains.
Percentage of AR Over 90 Days
Divide the balance older than 90 days by total AR. If $72,000 of a $400,000 balance is past 90 days, that is 18%. A common working guide is to keep this figure under about 20%, and the lower the better. Rising numbers here usually signal that denials and unanswered claims are piling up.
Bucket Mix by Payer
A single average can hide a lot. When you view the same buckets payer by payer, you can see which carriers are paying on time and which ones are quietly stretching your cash cycle. Medical billing partners that report at the payer level make this far easier to act on.
Red Flags That Signal Cash Flow Trouble
Once you know what normal looks like, these warning signs stand out quickly.
- A growing 61 to 90 day bucket. This is the earliest warning. Claims are stalling before they become truly old.
- Payments that look too low. Claims closed as paid below the contracted rate vanish from the report, so only underpayment tracking brings the shortfall back into view.
- One payer dominating the older buckets. This points to a payer-specific issue such as slow processing, a policy change, or a repeated denial reason.
- Days in AR creeping up for several months. A slow rise is easy to miss and expensive to ignore.
- Large unapplied or credit balances. These suggest posting errors that distort the whole report.
- Many small balances in old buckets. Low-dollar accounts get ignored, but together they add up.
Denials are often behind these patterns, and many are not complicated. They are simply never reworked. According to a recent annual provider claims survey, 75% of providers say denials are increasing, and 40% report denial rates above 10% of claims. A denied claim keeps sitting in your aging report until someone works it, so unworked denials quietly inflate every older bucket. Fixing them early is far cheaper than appealing them months later. A strong denial management process keeps them from aging in the first place.
What Is Usually Causing the Problem
The report tells you where the problem is. You still have to trace it to a cause. These are the usual suspects.
Posting Errors and Missing Remittances
If payments are applied to the wrong claim or not applied at all, the report shows balances that are not real. Clean, accurate posting keeps your aging data trustworthy, which matters because every decision you make rests on it. Reconcile remittances against bank deposits every week so gaps surface quickly.
Slow or Inconsistent Follow-Up
Claims go quiet when no one owns them. If your team works accounts in random order, newer balances get attention while older ones age out. Assign each payer to a named person and set clear follow-up dates.
Then review the list in a short weekly huddle, so stuck claims get a decision instead of another note.
Denials That Never Got Worked
Claims denied for missing information, eligibility issues, or authorization gaps often sit untouched for weeks. Reviewing common AR denial scenarios helps your team recognize which denials are fixable and which need an appeal.
Group denials by reason, fix the root cause once, and resubmit in batches. That is faster than treating every claim as a one-off.
A Simple Weekly Routine to Catch Problems Early
You do not need a complex dashboard to stay ahead. A short, consistent habit works better than an occasional deep dive.
Every week:
- Run your AR aging report and compare each bucket’s percentage with last week.
- Review the oldest ten accounts and the top three payers by overdue balance.
- Confirm that new denials have been assigned to someone.
Every month:
- Calculate Days in AR and the percentage over 90 days.
- Look for payers whose performance shifted.
- Review write-offs and ask whether any could have been prevented.
Technology can lighten this load. Automation can flag stalled claims, match remittances, and surface payer patterns without anyone building spreadsheets. Our article on reducing revenue leakage with RPA explains how this works in practice.
Tailor the Report to Your Specialty
Benchmarks are a starting point, not a verdict. A busy emergency department, a surgical group, and a primary care clinic all have different payer mixes and billing cycles. What looks alarming in one setting may be normal in another.
Review your report against your own history first, then against specialty norms. Practices with high self-pay volume will carry more patient balances in older buckets, while hospital-based groups often wait longer on complex payer reviews. Set a separate target for each. Your own trend line matters most. If your over 90 day share held steady for a year and then jumps, that change deserves attention even if the number still looks acceptable against a published benchmark. Compare like with like by using the same aging method and date filters every time, and note any seasonal swings. Our guide to emergency department revenue cycle management shows how targets and priorities shift by care setting.
When to Bring In Outside Help
If your older buckets keep growing even after you tighten internal follow-up, the issue may be capacity or process, not effort. Many in-house teams are stretched across eligibility, billing, and patient calls, so aging accounts get the leftover time.
A good partner should give you a payer level aging view, a denial trend summary, and a clear list of next actions each month, not just a total. Ask to see a sample report with payer level detail before you commit to any agreement.
ProMantra supports providers across the country with dedicated AR follow-up, denial work, and reporting that fits into a practice’s existing systems. Our teams work within HIPAA and ISO 27001 standards, so your data stays protected while accounts get worked. If you want a closer look at the whole process, our end to end revenue cycle management services cover every stage from eligibility to collections.
Frequently Asked Questions
1. What is a good AR aging report for a medical practice?
A good AR aging report shows most of your balance in the 0 to 30 day bucket, with each older bucket smaller than the last. Many practices try to keep balances over 90 days under roughly 20% of total AR.
2. How often should I review my AR aging report?
Weekly is ideal for a quick check of bucket movement, oldest accounts, and new denials. Do a deeper monthly review that includes Days in AR, payer trends, and write-offs.
3. What is the difference between Days in AR and an AR aging report?
Days in AR is one number showing your average time to collect. The aging report breaks that balance into time buckets, so it shows where money is stuck. You need both.
4. Why is my 90 plus day bucket growing?
The usual causes are unworked denials, missed underpayments, posting errors, and slow follow-up on a specific payer. Sort the old balances by payer and denial reason to find the pattern.
5. Can I improve my aging report without hiring more staff?
Often, yes. Assign payers to owners, set a weekly review rhythm, track denials by reason, and use automation for routine status checks. If balances still age, an outsourced billing partner can add capacity without adding headcount.
Turn Your Aging Report Into an Early Warning System
Your AR aging report already holds the answers about where cash is slowing down. The goal is to read it often, read it by payer, and act while claims are still young.
If you would like a second set of eyes on your numbers, contact the ProMantra team to talk through your aging report and see where cash is getting stuck.
