AR Aging Analysis: How to Identify Revenue Leakage Before It Hits Your Cash Flow
Accounts receivable aging is one of the oldest metrics in medical billing. Most practices read it as a snapshot. Here's how to read it as a predictive tool for revenue leakage.
January 22, 2026 · Devanshu Patel · 8 min read
Quick Answer
AR aging analysis identifies revenue leakage by showing you which claims have been outstanding long enough that collection probability has materially declined. The critical insight is not the total balance or even the current distribution across aging buckets — it's the velocity at which AR is moving from current into the 60, 90, and 120+ day buckets. Accelerating aging velocity is a 45-day leading indicator of cash flow shortfall, detectable before it fully compounds if you're looking at the trend rather than the snapshot.
What AR Aging Actually Measures
Accounts receivable aging organizes outstanding balances by how long they've been outstanding since the service date or claim submission date. The standard buckets are current (0-30 days), 30-60 days, 60-90 days, 90-120 days, and 120+ days. Every billing system produces some form of this report.
The reason AR aging matters is probability-weighted collection value. A claim in the 0-30 day bucket has a high probability of collection — the payer hasn't adjudicated it yet, but there's no reason to expect it won't pay normally. A claim in the 60-90 day bucket has a problem: either it was denied and hasn't been worked, it's in a payment delay pattern with the payer, or it's a patient balance that hasn't been collected. A claim in the 120+ day bucket has a significantly lower collection probability than it had when it was 45 days old — and in many states, filing limits with payers make claims over 120 days from service date legally uncollectable regardless of whether there's a legitimate claim.
The pattern across the aging buckets tells you the story of your billing department's effectiveness, your payers' payment timeliness, and your patient balance collection discipline — all in one report that most practices review once a month and don't fully interpret.
The Snapshot vs. the Trend
The most common way AR aging is used: the practice manager runs the AR aging report at month-end, confirms that the 90+ day balance is within some acceptable percentage of total AR, and closes the report. This is better than nothing. It's significantly less useful than it could be.
The more informative use is tracking the aging distribution over time — not just the current snapshot but the month-over-month movement of balances across buckets. This produces two signals the snapshot cannot.
Velocity into the problem buckets. If the percentage of total AR in the 60-90 day bucket increased from 12% to 18% over three months, something changed two to three months ago in the billing pipeline — a claims submission process change, a payer policy update, a coding issue that generated a wave of denials — and that change is now showing up as aging. The 12% to 18% movement is the diagnostic; the current 18% is just the symptom.
Movement from bad to worse. When AR in the 90-120 day bucket increases simultaneously with decreases in the 60-90 day bucket, those claims aren't getting resolved — they're just aging. That pattern means the denial follow-up or patient collection processes are not keeping pace with inflow. The cash flow impact is still 30-60 days ahead of being fully visible in revenue.
Revenue Cycle Analytics from Harine Management tracks AR aging as a trended metric, with month-over-month movement across buckets visible in the same view as the current snapshot. That combination — the snapshot and the velocity — is what converts AR aging from a retrospective scorecard into a forward-looking tool.
Segmenting AR Aging to Find the Cause
An aggregate AR aging report tells you that you have a problem. A segmented AR aging report tells you where the problem is and — often — what caused it.
By Payer
Segmenting AR aging by payer immediately identifies whether the aging problem is broad or concentrated. A practice where overall 90+ day AR is 28% of total AR might be experiencing a payer-specific payment delay — one large commercial payer processing claims slowly, or a Medicaid administrative backlog in a specific state — rather than a systemic billing quality issue. The fix for a payer-specific delay (escalate through the payer's provider relations channel, or pursue a systematic appeal if the delay exceeds contract terms) is different from the fix for a systemic billing quality issue.
Payer-segmented AR aging also surfaces underpayment patterns. When a payer consistently shows high 90+ day AR but also shows a low average collected-to-allowed ratio, the issue may not be slow payment — it may be systematic underpayment followed by write-off rather than appeal.
By Provider
Provider-segmented AR aging shows whether the aging distribution differs across providers — which it typically does, in revealing ways. A provider whose claims age faster than colleagues at the same site may have documentation patterns, CPT code selection habits, or a patient population with different insurance profiles that create a systematically harder billing pathway. Surfacing this at the provider level focuses education and workflow improvement on the right person rather than applying a practice-wide intervention for a provider-specific problem.
By CPT Code
Some CPT codes have systematically higher denial and aging rates than others — either because they require prior authorization, because their clinical documentation requirements are more exacting, or because specific payers have carve-out policies for specific procedures. Segmenting AR aging by CPT code identifies these high-risk codes and allows the billing team to prioritize follow-up on claims involving them before they age past 60 days.
By Patient vs. Insurance Responsibility
After a claim is adjudicated, the outstanding balance may be the patient's responsibility (copay, deductible, coinsurance) or may be a secondary insurance or payer dispute. Mixing patient AR and insurance AR into a single aging report obscures both. Patient balance collection requires a different workflow — statements, payment plan offers, potentially collections — than insurance balance follow-up, which requires payer-specific appeal and escalation processes.
Practices with the most effective patient balance collection separate the two aging populations from the start and manage each through its own workflow.
The Financial Impact Model
Revenue leakage from aged AR compounds faster than most practice leaders intuitively estimate. Consider a practice with $2 million in monthly net revenue and an AR aging distribution where 25% of total AR is over 90 days — a level that many practices accept as "normal."
If the collection probability on 90+ day AR averages 65% (a conservative estimate, given that some of that balance will collect at 100% and some at 0%), the practice has approximately $400,000 in AR that is expected to lose 35% of its stated value — roughly $140,000 in annual revenue leakage from the 90+ day bucket alone. At a collection probability of 50% on 120+ day balances, which are often written off partially, the leakage figure rises further.
The business case for investing in AR aging analytics — daily tracking, payer segmentation, trend monitoring — is not that it generates new revenue. It is that it recovers revenue the practice already earned but is losing to a workflow problem that is both identifiable and fixable.
Want to see exactly where your practice's revenue is leaking? Schedule a discovery call and we'll show you what a properly segmented AR aging analysis looks like for your specific payer mix and billing workflow.
Key Takeaways
- AR aging is a probability-weighted revenue metric, not just an age distribution: claims in the 90+ day bucket are collecting at a fraction of their stated value, and 120+ day claims may be legally uncollectable regardless of clinical legitimacy.
- The snapshot is less useful than the velocity: month-over-month movement into the problem buckets is a 45-day leading indicator of cash flow shortfall, visible before it compounds in revenue.
- Segmentation by payer, provider, and CPT code converts the report from a scorecard into a root cause diagnostic: a broad aging problem and a payer-specific payment delay look identical in the aggregate and require completely different interventions.
- Patient balance AR and insurance AR should be tracked separately: the collection workflow for each is different, and mixing them into one aging report causes the billing team to under-resource whichever is the larger problem.
- 25% of AR over 90 days is not "normal" — it's revenue leakage with a cost model: at typical collection probability assumptions for aged AR, a practice with $2M in monthly revenue can be losing $100,000+ annually to a workflow problem that is addressable.
- Prior auth gaps create aging problems that appear 45-60 days after the service: a claim denied for missing authorization at the 30-day mark ages into the 60+ day bucket before the denial is worked — tracking prior auth completion proactively is cheaper than working those denials.