Skip to content
Renvara Health Partners

Medical Billing & AR

AR Aging Review Guide

A step-by-step worksheet for performing a monthly AR review: report setup, payer table, claim sampling, deadline risk, patient AR, credits, and reporting.

Calculator held over printed financial charts during an AR review
PublishedGuide4 min read
What this guide is for: a repeatable method for performing an AR review — the steps, the worksheet, and the decisions. For what AR aging means and how leadership should interpret it, read Understanding AR Aging in a Physician Practice first. Plan on two to four hours for a first review; later monthly reviews take less.

Before you start: set up the report

Run the AR aging report from your practice management system with these settings, and write them down so next month's review is comparable:

  • Aging basis: date of service (preferred for review) or original bill date — not last bill date
  • Buckets: 0–30, 31–60, 61–90, 91–120, 120+
  • Split: insurance AR and patient AR shown separately
  • Grouping: by payer (primary), with the ability to drill into claims
  • Credits: credit balances shown separately, not netted against receivables
  • As-of date: the last day of the month, after posting is complete

Step 1 — Record the headline numbers

Fill in the summary worksheet. Keep last month's and three months ago's figures beside it.

MeasureThis monthLast month3 months ago
Total insurance AR
Total patient AR
Insurance AR over 90 days (% of insurance AR)
Patient AR over 90 days (% of patient AR)
Credit balances (total)
Days in AR (using your standard definition)

Look for: any measure that moved noticeably. Write one line on why you think it moved — you'll test it in the next steps.

Step 2 — Review insurance AR by payer

Build a payer table sorted by dollars over 90 days, highest first.

PayerTotal AR0–3031–6061–9091–120120+% over 90

Flag any payer that:

  • Holds a larger share of aged AR than its share of total charges
  • Moved more than a few percentage points into the older buckets since last month
  • Has balances stuck in 31–90 with no denial on file
  • Has secondary balances waiting after primary payment

Step 3 — Sample the aged claims

For each flagged payer, pull a sample of claims over 60 days — 10 to 20 is usually enough to see the pattern. For each claim, record:

Claim #DOSAmountCurrent statusLast action & dateRoot causeNext actionOwnerDeadline

Status options: never received by payer · pending/in process · denied · underpaid · paid but not posted · patient responsibility not transferred · other.

Root cause categories: registration/eligibility · authorization · coding · documentation requested · payer policy · enrollment · timely filing risk · posting error · follow-up not done.

Step 4 — Check deadline risk

For every aged claim, compare the date of service and denial date with the payer's filing and appeal limits.

  • List every claim within 30 days of a filing or appeal deadline
  • Assign each one an owner and a completion date this week
  • Confirm the practice has proof of timely filing (clearinghouse acceptance reports) for claims near the limit

Filing limits vary by payer and program; see Timely Filing Limits.

Step 5 — Review patient AR

  • Total patient AR and trend
  • Balances over 90 days: are statements going out on schedule?
  • Balances that should have been billed to a secondary payer instead of the patient
  • Accounts on payment plans that are current vs. behind
  • Accounts meeting the practice's written criteria for next steps under its financial policy

Step 6 — Review credit balances

  • Identify credits by type: patient overpayment, payer overpayment, posting error
  • Resolve posting errors first — they distort the rest of the report
  • Route overpayments for refund review according to payer contracts and applicable rules

Step 7 — Decide and assign

Summarize what the review found in three lists:

  1. Work now — deadline-risk claims and high-dollar recoverable balances, each with an owner and date
  2. Fix upstream — root causes that appeared more than once in the sample (for example, an authorization gap for one payer)
  3. Close — balances with no realistic path to collection, documented and adjusted according to policy and approval rules

Step 8 — Report and repeat

Report to leadership using the same format every month:

  • The headline table from Step 1
  • The top three payers by aged AR, with the main cause for each
  • Upstream fixes opened and their status
  • Amount worked, recovered, and adjusted since the last review

Repeat monthly. The value of the review builds over time: the second and third months show whether last month's fixes changed anything.

Common pitfalls

  • Aging by last bill date, which makes rebilled claims look current
  • Reviewing only totals, which hides one failing payer inside healthy averages
  • Working newest claims first because they're easiest
  • Treating symptoms — adding follow-up effort when the cause is an upstream workflow step
  • Changing report settings between months, which makes trends meaningless

For how AR measures fit with other indicators, see Revenue Cycle Metrics Every Practice Leader Should Understand.

Key Takeaways

  • Fix the report settings — aging basis, buckets, splits — and keep them the same every month.
  • Sample aged claims for flagged payers and record status and root cause, not just balance.
  • End every review with three lists: work now, fix upstream, and close.

Sources & References

Regulations, program rules, and payer policies change. Educational content only — confirm current requirements with the payer, program, or your advisors before acting.

Related Renvara Solution

Revenue Cycle Management

Want to discuss how this applies to your practice?

Book a Practice Assessment to talk through this operational area with Renvara.