What Is an A/R Aging Report in Medical Billing?

An A/R aging report has two axes: time across the columns and money (and usually claim counts) down the rows. The columns are the aging buckets — 0-30, 31-60, 61-90, 91-120, and 120+ days — and each bucket holds the dollars and claims that have been outstanding for that length of time. The 'age' clock starts either on the date of service or the date the claim was billed; most billing systems let you choose, and the date-of-service basis is the more conservative (older-looking) view because it includes the lag between the visit and claim submission.

The rows let you slice the same dollars different ways. The three most useful slices are:

1. By payer. This is the highest-value view. It shows whether your aging A/R is concentrated in one carrier (a payer-specific problem — a contract, enrollment, or systematic-denial issue) or spread across all of them (a workflow problem inside your practice).
2. By insurance vs. patient. Insurance A/R and patient A/R age and behave completely differently. A 90-day insurance balance is a follow-up failure; a 90-day patient balance is a statement-and-collections cadence failure. They need different teams and different playbooks.
3. By provider or location. Useful for multi-provider groups to spot a credentialing gap, a documentation problem, or a front-desk eligibility issue isolated to one provider or site.

What you are actually looking for. Do not read the report top-to-bottom. Read it in this order: (1) total A/R and the percentage over 90 days — that is your health check; (2) the 120+ bucket in dollars — that is your most-at-risk cash; (3) the by-payer breakdown of everything over 60 days — that tells you where to point staff this week. A report that only shows a single total A/R number with no aging breakdown is nearly useless, because it hides the age that determines collectability.

In our A/R clean-up engagements, the first thing we run is the report by payer for everything over 60 days — and more often than not, a single payer accounts for a disproportionate share of the aged balance, usually because of a fixable enrollment, COB, or systematic-denial issue rather than a true collection problem.

Each bucket carries a different meaning and a different urgency. The percentages below are the share of total A/R that should sit in each bucket for a healthy practice, drawn from MGMA and HFMA-aligned benchmarks. These are directional targets, not contractual guarantees — your specialty, payer mix, and patient-responsibility share will shift them — but the over-90 ceiling of 25% holds broadly across outpatient practices.

The one number that matters most: the combined 91-120 plus 120+ share — your A/R over 90 days. Best practice keeps total A/R over 90 days under 25%; top-performing practices run it under 18%. When that figure climbs toward 30% or higher, it is a reliable signal of a broken follow-up process, a payer enrollment gap, a rising denial rate, or a patient-collections cadence that has stalled.

Why the 120+ bucket is so dangerous. Three forces compound past 120 days: timely-filing windows close (many commercial payers allow only 90-180 days from the date of service to file, and appeal windows are tighter still), staff attention moves on to newer claims, and patient balances go cold as people forget the visit or lose their statements. Every dollar that crosses into 120+ is statistically harder and more expensive to collect — which is exactly why the report exists: to force action while the dollar is still young enough to recover.

Numbers make this concrete. Consider a practice with $500,000 in total A/R distributed across the buckets as follows. The table shows the dollars, the percentage of total A/R in each bucket, and how that compares to the benchmark.

How to read this practice's health. Total A/R over 90 days is $105,000 — that is 21% of the $500,000 total, which is inside the under-25% benchmark, so on the headline metric this practice is acceptable. But the report tells a more nuanced story: the 0-30 bucket is a little thin (46% vs. the 50%+ target), suggesting either a charge-entry/billing lag delaying claim submission or a recent dip in visit volume; the 61-90 bucket at 14% is at the high edge and is the leading indicator — those claims are about to roll into the danger zone next month if nobody works them; and the $60,000 sitting in 120+ represents the most-at-risk cash, of which historical norms suggest roughly $15,000-$18,000 may ultimately be unrecoverable if it is not triaged now.

The action this report dictates: work the 61-90 bucket aggressively this month to stop it aging into 91-120; triage the entire $105,000 over-90 balance by payer to find the systematic cause; and fix whatever is suppressing the 0-30 bucket (almost always charge-entry or claim-submission lag) so the front of the pipeline refills. A single snapshot like this, read correctly, converts a vague sense that 'collections feel slow' into a precise, prioritized worklist. Pair the aging view with your days in A/R figure and your net collection rate to confirm whether the slow buckets are a follow-up problem or a contractual/write-off problem.

When A/R over 90 days breaks past 25%, it is rarely a single broken thing — it is usually a stack of small failures compounding. Diagnosing it means asking which of these is dragging the number up.

1. A follow-up gap. No-response claims (claims the payer never acknowledged or never finished adjudicating) silently age because nobody is calling or checking the portal at the 30-day mark. This is the single most common cause of a bloated over-90 bucket and the most fixable.
2. A rising denial rate that is not being worked. Denials that are not reworked within days simply age. If your denial rate is climbing and the denial worklist is not being cleared, those denied dollars march straight into the danger zone. Aged A/R is very often unworked denials in disguise.
3. A payer enrollment or credentialing lapse. Claims for a provider whose enrollment lapsed (or who was never enrolled with a payer) deny or pend, and they pile up by payer in the over-90 buckets until someone notices the pattern. This is why the by-payer slice is so valuable.
4. Coordination-of-benefits (COB) holds. Secondary claims sitting without the primary EOB, or claims where the payer thinks another carrier is primary, age indefinitely until the COB is resolved.
5. A stalled patient-collections cadence. Patient balances that age past 90 days usually mean statements stopped going out, no payment plan was offered, or balances were never moved to a collections workflow. With high-deductible plans, patient responsibility is a growing share of A/R, and it ages faster than insurance A/R if not actively managed.
6. Timely-filing losses already baked in. By the time a balance is over 90-120 days, some of it may already be past the payer's filing or appeal deadline — meaning a portion of that aged A/R is not slow, it is dead, and needs to be identified and written off so it stops inflating the number and hiding the recoverable balances behind it.

The practical test: if your over-90 percentage is high, run the over-90 balance by payer and by insurance-vs-patient. If it concentrates in one or two payers, you have a systematic (and usually fast) fix. If it is spread evenly, you have a workflow capacity problem — your follow-up team cannot keep up with the volume, which is the most common reason practices bring in accounts receivable follow-up services.

Each bucket needs a different action, because the reason a claim is in 0-30 is completely different from the reason a claim is in 120+. Working the report means assigning the right play to each bucket and clearing them in order of risk-adjusted value — generally oldest-recoverable first.

0-30 days — Monitor, do not chase. These claims are in normal adjudication. The only action here is prevention: confirm claims are actually going out clean and fast (charge lag and claim-submission lag are what keep this bucket from filling). If this bucket is thin, your problem is upstream in charge entry or claims submission, not in collections.

31-60 days — First-touch follow-up. Once a claim passes the payer's clean-claim payment window (typically 14-30 days for electronic claims) without paying, touch it. Check claim status on the payer portal or via a 276/277 status inquiry before calling — most no-response claims reveal themselves here as 'not on file' (resubmit) or 'pending additional info' (respond). Catch early denials now, while there is plenty of timely-filing runway.

61-90 days — Active, documented follow-up. Every claim in this bucket gets a documented action: a call, a portal check, a corrected claim, or an appeal started. The goal is to stop these from aging into 91-120. Categorize by reason — denial, no response, COB hold, eligibility issue — and route each to the team that owns it. Reference the denial code on the EOB and work it specifically (a CO-16 information denial needs a corrected claim; a CO-97 bundling denial needs a modifier review or write-off decision).

91-120 days — Escalate and protect the deadline. Collectability is dropping and timely-filing or appeal deadlines may be near. Escalate to a senior biller or supervisor. File appeals with documentation, submit corrected claims through the proper corrected-claim path (not as new originals, which trigger duplicate denials), and flag any claim approaching its filing deadline for same-day action. For patient balances, this is the point to move to a firmer statement, a phone call, or a payment plan.

120+ days — Triage hard: recover or write off cleanly. Split this bucket into recoverable and unrecoverable. Recoverable: claims still inside an appeal window, claims with a clear payer error, large-dollar balances worth a focused push, and patient balances that respond to a final notice or collections referral. Unrecoverable: claims past timely-filing or appeal deadlines, tiny balances where the cost to collect exceeds the dollar, and bad-debt patient balances. Write off the unrecoverable with a reason code — not to hide it, but to stop dead dollars from inflating your A/R and masking the balances you can still save. A clean 120+ bucket is one where every remaining dollar has a documented next action or a documented write-off reason. Our full step-by-step recovery method for the oldest balances is laid out in how to recover aged A/R.

The cadence that keeps it clean: run the aging report at least weekly, work oldest-recoverable first, document every touch, and measure the over-90 percentage trend month over month. The report is only as valuable as the worklist it generates — a beautiful aging report that nobody acts on is just an expensive way to watch your cash get older.

A large share of aged A/R is not 'slow-paying' claims — it is denied claims that were never reworked. When you triage your over-90 bucket, you will repeatedly encounter the same denial codes, and each has a specific, fast fix that gets the dollar moving again. Map the EOB denial code as you work each aged claim:

The pattern is consistent: aged A/R that concentrates around a single denial code is a systematic problem with a single upstream fix (a scrubber rule, an enrollment correction, an eligibility check), not a claim-by-claim slog. Categorizing the aged bucket by denial reason — not just by age — is what turns a daunting six-figure over-90 balance into a short list of fixable root causes. This is also why a focused denial management workflow so often unlocks aged cash that a pure 'call the payer' follow-up effort leaves on the table.

The aging report and days in A/R measure related but distinct things, and you need both to diagnose your revenue cycle accurately. Reading one without the other leads to the wrong conclusion.

Why you read them together. Days in A/R is a single average — it can look perfectly healthy at 38 days while a toxic chunk of your A/R quietly rots in the 120+ bucket, because a mountain of fast-paying small claims averages out a handful of huge old ones. The aging report exposes that hidden tail. Conversely, the aging report is a static snapshot that does not tell you your collection velocity or whether the buckets are improving or deteriorating over time — days in A/R, tracked monthly, does. Use days in A/R as the speedometer and the aging report as the map: the speedometer tells you the practice is collecting slowly; the map tells you exactly which payers and which aged claims to work first. Full formula and benchmarks for the speedometer are in our days in A/R guide, and tying both into your monthly close is the discipline that keeps cash moving. Add net collection rate as the third leg — it tells you what share of collectable money you are actually capturing once write-offs are accounted for — and together the three give a complete read on revenue cycle health.