What is Accounts Receivable Aging Report? Definition, Formula, and Benchmark

The Accounts Receivable Aging Report is the operational decomposition of total outstanding AR into time-based buckets. Standard buckets are 0–30, 31–60, 61–90, 91–120, and 120+ days from the claim's billed date or service date (conventions vary). The aging report is the workhorse of daily RCM collections work: it tells the biller which claims need follow-up, which denials are accumulating, and which patient balances are sliding toward bad-debt write-off.

Aging reports are typically sliced by payer, provider, location, and specialty, producing a matrix that surfaces problems at the level where they can be acted on. For example, a sudden rise in 31–60-day aging for a single payer often signals a payer-side processing slowdown, a clearinghouse routing issue, or a recent contract change. A 91–120 increase for a specific specialty often signals a coding or authorization issue introduced months earlier. A rising 120+ patient AR suggests statement or collection workflow gaps.

Healthy AR aging looks like a declining staircase: the majority of AR sits in 0–30 (recent claims awaiting adjudication), less in 31–60, and progressively smaller amounts in older buckets. A flat or inverted distribution — significant AR in 91–120 or 120+ — indicates a broken cycle somewhere. The most-watched derived metrics are percent AR >90 days (best-in-class <15%, healthy <20%, broken >30%) and percent AR >120 days (best-in-class <10%).

The report has two canonical variants. Date-of-service aging starts the clock at the encounter date and measures the full cycle including late charge capture and initial submission. Billed-date aging starts the clock at initial claim submission and measures only the adjudication-and-follow-up cycle. Most HFMA benchmarks use DOS-based aging for comparability. Internally, most organizations work from billed-date aging for collections action because it isolates work controllable after submission.

Aging reports also drive reserve accounting. Finance teams use bucket-based historical collection rates to compute expected collections and allowance for doubtful accounts. A claim in the 120+ bucket might have a historical net collection rate of 20%, while a 0–30 claim might collect at 92% — those probability weights flow into the balance sheet.

In day-to-day revenue-cycle operations, Accounts Receivable Aging Report is most useful as a diagnostic — a sudden move in Accounts Receivable Aging Report almost always points upstream to a front-end workflow that has drifted: eligibility coverage, scheduling, registration, charge capture, or coding turnaround. Reviewers on this site therefore pair every Accounts Receivable Aging Report reading with days in ar and ar aging in the same weekly dashboard view, so the story a single metric tells cannot hide a broader pattern. The most common mistake teams make with Accounts Receivable Aging Report is reacting to the headline number rather than decomposing it by payer, provider, and specialty; once the outlier segments are visible, the remediation step is usually obvious and cheap.