AR Aging Analyzer
Your aging report, decoded in seconds. Paste the export and see exactly how much of your AR is current, how much is drifting — and how much is already in the danger zone.
An aging report is the X-ray of a revenue cycle — it shows not just how much money is owed to the practice, but how long it has been sitting there. The older a balance gets, the less of it will ever be collected. Paste an aging export below (or upload the CSV) and this analyzer buckets every balance, totals the report, and shows what share of your AR is already over 90 days old. Everything runs in your browser — no data is uploaded anywhere.
Analyze an aging report
How to read the buckets
- 0–30 days is mostly claims still in the normal payer cycle — healthy, as long as it keeps moving.
- 31–60 and 61–90 are where follow-up earns its money: claims here are usually one phone call, one corrected claim or one appeal away from paying.
- Over 90 days is the danger zone. Collectability falls steeply with age, and timely-filing deadlines start closing doors — an appeal right or a secondary filing window can expire while a balance sits. As a rule of thumb, a practice wants the share of AR over 90 days as low as possible; double-digit percentages deserve a dedicated cleanup project.
- The top-5 list is your worklist. The largest old balances are where a single successful appeal moves the whole report.
The analyzer recognises common export layouts automatically: it looks for a balance/amount column and either a date-of-service column (aged against today) or a days/aging column, with an optional patient or claim identifier for the top-5 list. Pair it with the Days in AR Calculator for the other half of the picture.
Disclaimer: This tool is for educational and estimation purposes only and does not constitute billing, coding or medical advice. Coverage, coding and payment rules vary by payer and change over time — always verify with the current CMS files and the payer's own policy before submitting claims or making financial decisions.
Frequently asked questions
What percentage of AR over 90 days is healthy?
There is no universal benchmark — it varies by specialty and payer mix — but the direction is unambiguous: the older a balance, the lower the chance of collecting it, and the closer timely-filing and appeal deadlines come. Many well-run practices hold the over-90 share to a small minority of total AR; when it grows into double digits, it usually signals a follow-up backlog rather than slow payers.
Is my data uploaded when I use this analyzer?
No. The analysis runs entirely in your browser — the file is read locally and nothing is sent to or stored on any server. You can verify this by loading the page and disconnecting from the internet before running an analysis.
What format does my aging export need to be in?
A CSV with at least two usable columns: an amount or balance column, and either a date-of-service column (the analyzer ages it against today) or a days-old/aging column. A patient or claim column is optional and is used only to label the top-5 list. Exports from most EHR and billing systems match this shape.