How to read an A/R aging report

What an A/R aging report actually is

An accounts receivable aging report lists every dollar that has been billed and not yet collected, sorted by how long it has been outstanding. Almost every practice management system produces one. Far fewer practices read it properly.

The report exists to answer one question: of the money we are owed, which of it is still moving and which of it has stopped? Everything else in the report — the buckets, the payer columns, the totals — is there to help you separate those two categories, because they need completely different responses.

A large balance is not automatically a problem. A large balance that has stopped moving is.

The columns that matter, and the one that misleads

A usable aging report has at minimum a responsible party (payer or patient), a balance, and a date. The date is where practices get tripped up, because systems differ on what they age from:

• Date of service — ages from when care was delivered. This is the honest view. It includes the time a claim sat in your office before it went out.
• Claim submission or billing date — ages from when the claim left. This makes your report look better than reality, because a claim that sat unbilled for three weeks starts at day zero.

Find out which one your system uses before you interpret a single number, and prefer date of service if you can choose. If your report ages from the submission date, your true collection cycle is longer than the report shows by however long charge entry takes.

The other column to treat carefully is the total. A single aging total that mixes insurance balances, patient balances and credit balances together is close to meaningless. Split it before you act on it.

Reading the buckets

Most reports use 30-day buckets: 0–30, 31–60, 61–90, 91–120, and over 120. Read them as a story about momentum, not as five separate numbers.

• 0–30 days. Normal working inventory. Most of your balance should live here. Claims in this bucket are with the payer and have not had time to adjudicate.
• 31–60 days. Still routine for many payers, but anything electronic that is sitting here without a remittance deserves a status check. This is the cheapest place to catch a claim that was never received.
• 61–90 days. Something has gone wrong. A claim in this bucket has almost always been denied, rejected, pended for information, or never arrived. It will not resolve on its own.
• 91–120 days. Now you are fighting the clock. Appeal windows and timely filing limits start closing in this range for some payers.
• Over 120 days. The write-off bucket, unless someone works it deliberately. Synergy holds this under 10% of total A/R for the practices we manage, and that single percentage is the fastest way to judge whether anyone is actually working the report.

The shape matters more than any one figure. A report weighted heavily toward 0–30 with a thin tail is healthy. A report with a fat 120-plus bucket that grows every month is a practice writing off revenue it already earned.

Insurance A/R and patient A/R are two different problems

This is the single most valuable split you can make, and most practices skip it.

Insurance A/R is money a payer owes you under a contract. It is collectible at a high rate, it is worked by following up on claims, and when it ages the cause is almost always a process failure on one side or the other — a denial nobody worked, a claim nobody resubmitted, a request for records nobody answered.

Patient A/R is money an individual owes you. It collects at a materially lower rate, it ages for entirely different reasons — confusion about the bill, inability to pay, no card on file — and it responds to entirely different tactics: clear statements, payment plans, upfront collection at check-in.

Netting them into one total hides both problems. A practice with $180,000 in A/R over 90 days has a very different week ahead depending on whether that is stalled insurance claims or accumulated patient balances. Run the report both ways, every time.

Related: patient collections best practices covers the patient side in detail.

Slice by payer before you slice by anything else

Once insurance A/R is separated out, the next cut is by payer, not by dollar amount. Aging concentrated in one payer is a specific, fixable problem. Aging spread evenly across all payers is an internal problem.

What the payer view exposes:

• One payer with a fat 90-plus bucket — usually an enrollment issue, a contract or fee schedule loaded incorrectly, a clearinghouse routing problem, or a payer-specific edit your claims keep failing.
• The same denial reason repeating across one payer — a front-end fix, not a follow-up job. Working those claims one at a time treats the symptom forever.
• Aging that tracks payer mix proportionally — the problem is your process, not any individual payer.
• A payer with almost no A/R at all — worth checking that claims are actually going out to them, rather than assuming it is good news.

Sorting by largest balance feels productive and usually is not. The biggest single claim is one claim. A repeating denial reason across a payer might be two hundred.

The three numbers the report should be feeding

The aging report is raw material. Three derived numbers turn it into a management tool, and all three should be tracked over time rather than read once.

• Days in A/R. Total A/R divided by average daily charges, where average daily charges is your gross charges over a period divided by the number of days in it. It answers "on average, how long does a dollar take to arrive?" Watch the trend line, not the absolute number, and use the same period length every time so the comparison holds. Our guide to days in A/R covers the calculation and how to bring it down.
• Percentage of A/R over 90 and over 120 days. The clearest single indicator of whether anyone is working old claims. It is a ratio, so it does not flatter you when volume grows.
• Net collection rate. Payments collected as a share of what you were actually entitled to collect after contractual adjustments — not a share of gross charges. Gross charges are a list price nobody pays, so a collection rate measured against them tells you about your fee schedule rather than your billing.

One caution on all three: they move when your charge volume moves, not only when your collections change. A practice that adds a provider will see days in A/R shift for reasons that have nothing to do with billing performance. Read them alongside charge volume.

Credit balances: the negative numbers you cannot ignore

Aging reports frequently contain negative balances — overpayments, duplicate payments, posting errors, or payments applied to the wrong account. Two reasons they matter more than their size suggests.

First, they distort everything above. A netted total understates real outstanding A/R, so your aging looks better than it is and your days in A/R reads low.

Second, an unresolved credit balance can be a compliance exposure rather than just accounting untidiness. Under federal law, a provider that has received an overpayment from Medicare or Medicaid must report and return it within 60 days of the date the overpayment was identified — or the date any corresponding cost report is due, if that is later. The authority is 42 U.S.C. 1320a-7k(d), with implementing rules at 42 CFR 401.305 for Medicare Parts A and B, 42 CFR 422.326 for Part C and 42 CFR 423.360 for Part D. An overpayment retained past that deadline becomes an obligation under the False Claims Act.

"Identified" is a defined legal term tied to a knowledge standard, not simply noticing a negative number on your aging report, so exactly when the clock starts is a determination to make with your compliance advisor. Commercial payer contracts carry their own separate refund obligations and timelines, which differ from the federal standard and from each other. Identify credit balances on a schedule, research each one, and handle refunds under the specific payer's or program's rules rather than letting them accumulate on the report.

Run credit balances as their own report. If your system will not separate them, that is worth fixing. Synergy treats this as a standing workflow — see credit balance resolution.

What to work first

A weekly work list built from the aging report, in this order:

1. Anything approaching a filing or appeal deadline. Deadlines are among the few truly irreversible items on the report. Timely filing limits generally run from the date of service; the Medicare fee-for-service limit is one calendar year from the date of service, under 42 CFR 424.44. Appeal windows generally run from receipt of the denial notice. Confirm the trigger date with each payer, because institutional claims and secondary or coordination-of-benefits claims can differ. Everything else can wait a week; these cannot.
2. Repeating denial reasons. Highest leverage on the page. Fix the upstream cause once and the same claims stop arriving next month.
3. The 61–90 bucket. Old enough to be genuinely stuck, young enough to still be fully collectible. This is where follow-up effort pays back best.
4. Large insurance balances in 91–120. Worth individual attention before they cross into the write-off range.
5. Patient balances with no contact attempt logged. Often a statement that was never sent rather than a patient who refused to pay.
6. Credit balances. Scheduled, not reactive.

Notice what is not first: the single largest outstanding claim. It is satisfying to chase and it is rarely the best use of the hour.

What a clean-looking aging report can still be hiding

Five things that make a report look better than the practice actually is:

• Charges that were never entered. Unbilled visits never reach the aging report at all. The report can only age what was billed, so reconcile encounters against charges separately.
• Write-offs used as cleanup. Adjusting old balances off makes the tail disappear without collecting anything. Review adjustment reports next to the aging report, and know which adjustment codes are contractual versus discretionary.
• Aging from the submission date rather than the date of service, which hides charge-entry lag.
• Netted credit balances flattering the totals.
• Claims sitting in the clearinghouse. A claim rejected at the clearinghouse may never have reached the payer, and depending on your system it may not appear in A/R as a problem. Reconcile submission counts against acceptance counts.

Turning it into a routine

The report only produces money if it drives a repeating action. A workable rhythm:

• Weekly: work the deadline list, the 61–90 bucket, and any new denial reason that has appeared more than twice.
• Monthly: review days in A/R, percentage over 90 and over 120, and net collection rate against the previous month. Review credit balances. Review adjustments.
• Quarterly: review the payer-level view for contract and enrollment problems, and reconcile encounters to charges.

Assign one named owner. An aging report that is everyone's responsibility is the one that grows a 120-day tail.

How Synergy works A/R

We have been doing this for medical practices since 2005. Claims go out within 24 hours, denials are worked within 48 hours, we target a 98% clean-claim rate and 99% posting accuracy, and we hold A/R over 120 days under 10% — the number that tells you the report is being worked rather than filed.

You get the aging report split the way this article describes, with the payer-level view and the derived metrics, so you can see the same picture we do. We also take on old A/R that has already aged: see aged A/R recovery and A/R follow-up. Provider credentialing is included free, there is no long-term contract, and there is a 30-day free trial and a 90-day money-back guarantee on full revenue cycle management. HIPAA compliant throughout.

Related reading: days in A/R explained, what is denial management, and nine ways to reduce claim denials.

This article is general information about reading and working an accounts receivable aging report. It is not legal, compliance or accounting advice. Payer contracts, filing and appeal deadlines, and overpayment refund requirements differ by payer and by program and change over time — confirm specifics with each payer and with your own advisor.