Home › Tools › AR Aging Analyzer

AR Aging Analyzer: Read Your Aging Report Like a Consultant

Type the four bucket totals from your aging report and get the percentages, the benchmark verdicts, and the dollar figure quietly rotting in the over-90 column.

Example: 60000
Example: 20000
Example: 10000
Example: 10000

What an Aging Report Actually Tells You

The AR aging report sorts every unpaid dollar by how long it has been owed — and its shape is the most honest health check a revenue cycle has, because unlike revenue (which lags) and denial counts (which need context), aging shows where money is stuck right now. A healthy report is front-loaded: the majority of AR in the 0-30 bucket, a fast taper through the middle, and a thin over-90 tail. An unhealthy one is flat or back-loaded — and every possible cause, from slow charge entry to unworked denials to ignored patient balances, leaves its signature in a specific bucket.

Reading Each Bucket's Story

1
0-30 is your intake speed. This bucket SHOULD be big — it is simply your recent billing awaiting normal adjudication. When it falls under half of total AR, the usual culprits are slow charge entry, claims sitting unsubmitted, or a shrinking practice.
2
31-60 is your clean-claim rate made visible. Clean claims pay inside 30 days for most electronic payers - what lands here is the first wave of rejections, pends, and slow payers. A swollen 31-60 bucket points at front-end quality and payer mix.
3
61-90 is your follow-up discipline. Claims here have been touched by a payer and bounced, pended, or partially processed — and are waiting on YOUR next move. Growth here means work queues are losing to volume.
4
Over 90 is where money decays. Collectibility drops steeply with age — appeal windows close, filing limits pass (CO-29 territory), patients move, documentation scatters. Industry experience says roughly half of aged AR is never recovered, which is the estimate the analyzer applies.

Fixing a Back-Loaded Report

  • ✔ Work the over-90 by dollar, not by date — a triage pass that ranks the bucket by recoverable value (appealable? refilable? patient-billable?) beats chronological grinding
  • ✔ Stop the inflow before draining the pool — the front-end fixes that lower your denial rate are what keep the over-90 bucket from refilling
  • ✔ Give every bucket an owner and a cadence — 31-60 worked weekly, 61-90 twice weekly, over-90 on a standing triage list; aging that belongs to everyone belongs to no one
  • ✔ Pair this view with days in AR and net collection rate — aging shows where money is stuck, AR days shows how fast it moves, collection rate shows how much ultimately arrives; the three together are a complete dashboard

A Tale of Two Reports

Two practices, identical $100,000 total AR. Practice A: $60k / $20k / $10k / $10k — front-loaded, 10% over-90, the strong-verdict shape. Its money is young, its follow-up is current, and next month's collections are largely predictable. Practice B: $35k / $20k / $15k / $30k — 30% over-90. Same total, radically different reality: roughly $15,000 of B's AR (half the aged bucket, by industry experience) will likely never arrive, its billers spend their days on archaeology instead of current claims, and every month the old bucket grows because the new work keeps arriving on top of the unworked backlog. The trap is that both practices'' dashboards show "$100,000 in AR" — which is why the aging shape, not the AR total, is the number leadership should ask for. Run your own buckets through the analyzer above, note the over-90 percentage, and put it on the monthly calendar: the direction of that one number over three months tells you whether your revenue cycle is winning or losing.

One caution on interpretation: aging mixes payer AR and patient AR, and they age differently — payer claims should resolve in 30-60 days while patient balances routinely take 90+ even in healthy practices. If your over-90 bucket is dominated by patient balances rather than unworked claims, the fix is statements, payment plans, and point-of-service collection — a different playbook from denial follow-up. Splitting the report by responsible party before reading it is the analyst's habit worth stealing.

Which Date Your Aging Runs From Changes Everything

Before comparing your aging against any benchmark, check what the clock starts on. Some systems age receivables from the date of service and others from the date of submission, and the gap between them can be weeks. A practice that ages from submission will always look healthier than an identical practice ageing from date of service, without collecting a penny more.

Date of service is the more honest measure, because it captures the delay between seeing the patient and getting the claim out — which is often where the real problem sits. A clean-looking aging report on a practice that takes eleven days to submit is describing the payer's speed while hiding its own.

The bucket that matters most is over 90 days. Under 15 percent of total A/R beyond 90 days is generally healthy; above 25 percent signals a collection problem that the average will not reveal. Read it alongside the total, never instead of it: a respectable average can conceal a growing tail of old, difficult claims being carried by fast payers around them.

One caution on the oldest bucket. Receivables past 120 days are not simply slow — many are past appeal windows and are effectively uncollectable. Carrying them inflates your A/R and makes every ratio built on it look worse. Work what is recoverable, write off what is not, and judge the result on what actually converts to cash.

FAQ

What percentage of AR should be over 90 days?
Top performers hold it at 10% or less; 10-18% is common; above 18-20% signals follow-up losing to volume. Direction matters as much as level - a rising share is the early warning.
Should the 0-30 bucket be large?
Yes - it is your recent billing in normal adjudication, and a healthy report is front-loaded. The worry signs are a 0-30 share under about half of total AR, or a report where the tail rivals the front.
How often should I run an aging analysis?
Monthly at minimum, same day each month, tracking the over-90 percentage as a trend line. The single number moving up or down tells you more than any point-in-time snapshot.
Is old AR ever worth writing off?
Yes - AR that is truly uncollectible (expired filing and appeal windows, unreachable patients) distorts every metric while it lingers. Triage the bucket, chase the recoverable, and write off the rest deliberately with documented reasons.
Should A/R age from date of service or date of submission?
Date of service is the more honest measure, because it includes the delay between seeing the patient and submitting the claim. Ageing from submission hides your own lag and describes only the payer's speed, which makes benchmark comparisons meaningless.
What percentage of A/R over 90 days is acceptable?
Under 15 percent of total accounts receivable beyond 90 days is generally healthy; above 25 percent indicates a collection problem. Always read it alongside your overall A/R days rather than instead of it, because a good average can hide a growing tail of old claims.

Related tools: AR Days Calculator · Net Collection Rate Calculator · Denial Rate Calculator · Appeal Letter Generator · All free tools

Hassan Raza AwanReviewed by Hassan Raza Awan, Founder — 4+ years of hands-on U.S. medical billing experience. General billing information — verify against current CMS guidance and your payer contracts.

Over-90 Bucket Past 18%?

We triage aged AR by recoverable dollars, work it to decision, and fix the front end so it stays drained. Free one-week billing audit.

Get Free Billing Audit Denial Management Services