Medical A/R aging report: how to read it
An A/R aging report lists every open balance by how long it has been outstanding, usually in 0–30, 31–60, 61–90, 91–120, and 120+ day buckets. Read it by separating insurance from patient balances, cutting the 90+ day insurance balance by payer and by denial reason, and flagging claims with no follow-up activity, which are the ones most likely to be lost.
The columns that matter
| Field | Why it matters |
|---|---|
| Date of service | Timely-filing limits run from this date (Medicare: one calendar year, per CMS) |
| Claim submission date and clearinghouse status | Proof of timely filing; "accepted" at the clearinghouse is not "received" by the payer |
| Payer and plan | Deadlines and appeal rules are set per contract |
| Denial code (CARC/RARC) | Determines the recovery path |
| Last action date and note | Claims with no activity are the highest-risk bucket |
| Billed, allowed, paid, balance | Paid-below-contract claims hide as "paid" unless allowed is compared to the fee schedule |
| Responsible party | Insurance and patient balances are worked differently and should be aged separately |
Three cuts to run every month
- 90+ day insurance balance by payer. Concentration in one payer points to a contract, credentialing, or payer-processing problem worth escalating to provider relations.
- 90+ day balance by denial reason. Prior authorization and medical necessity need appeals; coding needs corrected claims; eligibility needs rebilling. The mix tells you what staff skills the queue needs.
- Claims with no follow-up in 60+ days. This is the unworked queue. After staff turnover or a vendor change it is often the largest bucket, and a share of it was never received by the payer.
Traps that flatter the report
- Aging from claim date instead of date of service shifts every claim younger by the submission lag. Deadlines still run from the date of service.
- Credit balances netted against debits shrink the total and hide refunds owed.
- Patient balances mixed with insurance inflate the old buckets with balances that need statements, not appeals.
- Adjusted-off claims that were never appealed. A clean report can mean the denials were written off rather than worked.
- Rebilled claims that reset the clock. Resubmitting as a new claim rather than a corrected claim can make an old claim look new and lose the original filing date.
Benchmarks to compare against
Standard metrics from the report are days in A/R and the percentage of A/R over 90 and 120 days. HFMA's MAP Keys define these, and MGMA DataDive publishes specialty-level distributions. Commonly used targets put 90+ day insurance A/R under 15–20% of total; see what percentage of medical A/R should be over 90 days?
What we ask for in an audit. A claim-level export of 90+ day insurance A/R with date of service, payer, CPT, billed, allowed, paid, balance, denial code, and last action. CSV or XLSX from the practice-management system. That is enough to return a Recovery opportunity report in 5 business days.
Sources
- CMS, Medicare timely filing requirements: claims must be filed within one calendar year of the date of service
- HFMA MAP Keys: standard revenue-cycle metrics including days in A/R and aged A/R as a percentage of total A/R
- MGMA DataDive: practice operations, A/R, and revenue-cycle benchmarks
- CMS, Administrative Simplification: HIPAA standard transactions (837 claim, 835 remittance, 276/277 claim status, 270/271 eligibility)
Figures attributed to a source are that source's; commonly used benchmarks are labeled as such. Verify deadlines against your own payer contracts.
Related articles
Related services
- Aged A/R recovery — Claims past 90, 120, and 180 days, worked by deadline and recoverability.