Every billing company sends an aging report. Most of them send one that rolls every location, every provider, and every payer into a single set of numbers. The report tells you how much money is outstanding and how old it is.
That is the beginning of the conversation, not the end of it. I ran a four-location occupational medicine practice and received a monthly aging report that showed our A/R at 34 days and our over-90 balance at 9%. Both numbers were within industry benchmarks.
When I pulled the report by location, one site was at 22 days and another was at 51. The group average was fine. One location was not.
The Four Buckets and What Each One Means Operationally
An aging report sorts your outstanding accounts receivable into buckets based on how many days have passed since the claim was submitted (or since the date of service, depending on how the report is configured). Each bucket tells you something different about what is happening in your billing operation.
The buckets are useful as a snapshot. Where they fail is in telling you why a claim is in a given bucket. A claim sitting at 75 days could be a complex appeal in progress with documentation already submitted to the payer, or it could be a clean claim that nobody has looked at since it was denied at day 14.
The aging report does not distinguish between those two situations. You need to ask.
Why the Group-Level Number Hides the Location That Is Failing
A multi-location practice that receives one aging report for the entire group is flying blind. The group average is an arithmetic mean that lets a high-performing site mask a struggling one.
This is not a theoretical problem. It is the most common way billing failures go undetected for months.
Here is what the group-level average actually looks like when you break it apart. These are illustrative numbers across a three-site group billing roughly $150,000 per month in aggregate.
The Worked Example: Three Sites, One Average
| Metric | Site A | Site B | Site C | Group Avg |
|---|---|---|---|---|
| Monthly charges | $65,000 | $50,000 | $35,000 | $150,000 |
| Days in A/R | 28 | 31 | 54 | 35 |
| A/R 0-30 days | 62% | 55% | 31% | 52% |
| A/R 31-60 days | 24% | 27% | 25% | 25% |
| A/R 61-90 days | 9% | 11% | 22% | 13% |
| A/R over 90 days | 5% | 7% | 22% | 10% |
| Clean claim rate | 96% | 93% | 81% | 91% |
| Claims with no payer response (30+ days) | 2 | 5 | 19 | 26 total |
The group average shows 35 days in A/R and 10% over 90 days. Both are within range. A monthly aging report for the group would not raise alarms.
Site C is a different story. More than one in five dollars is past 90 days, and the clean claim rate of 81% means nearly one in five claims is rejected on first submission.
Nineteen claims have been sitting with no payer response for over 30 days. They were either never received by the payer or lost in adjudication while nobody followed up.
The group-level report hides every one of those problems. Breaking the report by location is the only way to see them.
The Three Figures Your Aging Report Never Shows
The standard aging report answers one question: how old is the money you are owed? It does not answer why the money is aging, whether anyone is working it, or how long it took to get there. Those answers live in three figures that most billing companies do not include in the monthly report unless you ask.
A claim with no payer response is one that was submitted, received no adjudication (paid, denied, or pended), and is sitting in a queue. It may have been lost in transmission, rejected by the clearinghouse before it reached the payer, or received and never processed.
These claims do not appear in a denial report because they were never denied. They appear in the aging report as outstanding A/R, indistinguishable from claims that are in active adjudication. The only way to find them is to run a claims status report filtered for claims with no response past 30 days.
When I audited 42,020 documents across our own practice, $1.1 million in claims had no carrier response. That number sat inside our aging report the entire time, counted as outstanding A/R, aging silently toward filing limits.
The aging report shows you outstanding A/R but not what left it. When a billing company writes off a claim, the balance drops and the group total improves. Without a write-off log broken out by reason, you cannot tell the difference between a claim that was collected and a claim that was abandoned.
A write-off log should categorize every adjustment: contractual adjustment (expected), timely filing write-off (preventable), patient bad debt (expected after statement cycles), and administrative write-off (needs review). If your billing company sends a total write-off figure without breaking it into these categories, ask for the detail. The write-off log is one of the seven reports every administrator should request.
The aging report measures time from submission (or date of service) forward, not the gap between the encounter and the submission. A claim that takes 14 days to submit and then 30 days to adjudicate shows up as 30 days on the report. The 14-day lag is invisible.
Submission lag matters because it compresses the window for follow-up. A payer with a 90-day timely filing limit counts from the date of service, not from submission. Fourteen days of submission lag costs you 15% of that window before the first claim goes out.
For specialties that require prior authorization, the lag is often longer because the claim waits for auth documentation.
None of these three figures requires a special system to produce. Every practice management system can generate a claims status report filtered by response status, a write-off log grouped by adjustment reason, and a lag report measuring encounter date to submission date. The question is whether your billing company runs them and sends them to you.
How to Read the Report You Should Be Getting
The weekly cleared-versus-aged measurement is more useful than a monthly aging snapshot because it shows direction, not just position. A monthly report tells you that your over-90 balance is $42,000. The weekly version tells you whether that $42,000 is growing, shrinking, or being replaced by new aged claims as old ones get written off.
The version of the report worth requesting breaks out A/R by location, shows claims crossing the 60-day mark each week, and separates cleared balances into cash collected versus write-offs. That distinction matters: if the aged balance is shrinking because claims are being written off rather than collected, the report looks like it is improving while the practice is losing money.
Ask Your Vendor for This Version
The aging report is the most widely distributed report in medical billing, and the least useful in its standard form. Ask your billing company to break it by location, add the three missing figures, and deliver it weekly instead of monthly.
If they tell you their system cannot produce a location-level report with cleared-versus-aged tracking, that is not a system limitation. Every practice management system on the market can generate this data. The question is whether your vendor will send it to you, and whether the numbers will hold up when you compare them against your own bank deposits.
See What Your Aging Report Is Hiding
We deliver the location-level, cleared-versus-aged report weekly, starting at 4.9% of net collections, no contracts, no setup fees.
Request a Free Billing Analysis