The accounts receivable aging report is the most informative document a practice owner has about the financial health of their billing operation, and one of the least read. It is usually presented as a wall of numbers with no narrative, which is a presentation problem rather than a data problem.
Here is how to read one.
What the report is
An aging report lists outstanding balances grouped by how long they have been unpaid, usually in 30-day bands: 0–30, 31–60, 61–90, 91–120, and over 120 days. Most systems can break the same data down by payer, by provider and by location.
Every version answers the same underlying question: of the money we have billed and not collected, how long has each part of it been waiting?
Check what the aging is counted from
Before reading anything else, establish whether the report ages from the date of service or the date the claim was billed. This is not a technicality.
Ageing from the billing date hides charge entry delay entirely. If claims take two weeks to leave the practice, a report aged from billing shows a healthier picture than the reality your cash flow experiences. Where the system allows it, age from date of service — it is the measure that matches the actual gap between doing the work and being paid for it.
Read the shape before the total
The total tells you how much is outstanding. The distribution tells you whether that is normal.
A practice billing steadily will always carry a substantial balance in the 0–30 bucket, and that is not a problem — it is claims in normal adjudication. What matters is how much sits to the right of it, and whether that share is growing.
A large AR balance concentrated in 0–30 days is a busy practice. The same balance concentrated beyond 90 days is a warning.
The over-90 percentage
Calculate the share of total AR sitting beyond 90 days and track it every month. It is the single most useful number in the report.
If it is rising while total AR is flat, new claims are being collected and old ones are not being worked — a resourcing or ownership problem. If it is rising along with total AR, the problem is more likely upstream: claims are being denied or rejected and not resolved.
Break it down by payer
This is where the actionable detail lives. Sort the older buckets by payer and look for concentration.
One payer dominating the aged balance usually means one of a few things: a systematic denial pattern nobody has diagnosed, an enrollment or submission problem specific to that payer, a policy change you have not caught up with, or a payer that genuinely pays slowly. All four are addressable, but only once you know which one it is.
Separate insurance AR from patient AR
If your report combines them, you are looking at two different problems averaged together. Insurance AR is a payer follow-up job. Patient AR is a communication and collection job, and with high-deductible plans it has become a larger share of practice revenue than it used to be.
A practice with a large patient balance and a healthy insurance balance needs statements, payment plans and clearer front-desk conversations — not more payer follow-up.
Look for the dead weight
Almost every aged bucket contains balances that will never be collected: claims past their filing deadline, denials past appeal, tiny balances not worth pursuing, and duplicates.
These matter beyond the money because they distort every other number. They inflate total AR, inflate days in AR, and make the report harder to read each month. Identifying and closing them, with a documented reason, is not a cosmetic exercise — it is what makes the remaining figures meaningful.
Compare consecutive months
A single aging report is a snapshot. Two consecutive reports are information.
What moved between buckets? What was collected? What aged into the next band? What was closed? Movement distinguishes a healthy balance that is churning from a stagnant one that is merely sitting, and the totals alone cannot tell you which you have.
The four questions your report should answer
- What proportion is over 90 days, and which direction is that moving?
- Which payer holds the largest share of the aged balance, and why?
- How much of the oldest bucket is genuinely still collectable?
- What moved since last month?
If your current report cannot answer these, the issue is usually presentation rather than data — the information exists in the system but is not being surfaced in a form anyone can act on.
What to do with what you find
Reading the report is not the point; changing what it says is. In practice that means segmenting the balance by payer, aging and value, setting a follow-up cadence for each segment, documenting every touchpoint, and closing what is dead so the remaining number is honest.
The report will look worse before it looks better, because closing uncollectable balances reduces the total for reasons that are not a success. That is the correct trade: a smaller, honest number you can act on beats a larger one nobody believes.
Want this looked at for your practice?
We review your AR aging and denial patterns and send you a written summary — whether or not you go on to work with us.
Get a Free Billing & AR AssessmentFrequently asked questions
Should aging be counted from the date of service or the date of billing?
Both are used, and the difference matters. Date of service is the more honest measure because it includes any delay in getting the claim out. If your report ages from the billing date, a two-week charge entry lag is invisible in it.
How often should the aging report be reviewed?
Monthly at minimum, with the over-90 bucket reviewed more frequently in any practice where it is growing. The value comes from comparing consecutive months rather than from reading one in isolation.
Related services
This article is general information about medical billing and revenue cycle management for US practices. It is not legal, coding or compliance advice, and payer rules vary by payer, plan and state. Check the position that applies to your own practice before acting on anything here.