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.

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.
| Measure | This month | Last month | 3 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.
| Payer | Total AR | 0–30 | 31–60 | 61–90 | 91–120 | 120+ | % 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 # | DOS | Amount | Current status | Last action & date | Root cause | Next action | Owner | Deadline |
|---|---|---|---|---|---|---|---|---|
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:
- Work now — deadline-risk claims and high-dollar recoverable balances, each with an owner and date
- Fix upstream — root causes that appeared more than once in the sample (for example, an authorization gap for one payer)
- 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 ManagementWant to discuss how this applies to your practice?
Book a Practice Assessment to talk through this operational area with Renvara.
