Every medical practice bills insurance. Every practice has an “aging report” that lists unpaid balances. And almost no practice can answer the question that actually matters: for every dollar we billed, where is that dollar right now, and who is sitting on it?
This is one piece of a wider gap covered in revenue oversight, the daily job of watching every step between care delivered and cash in the bank.
The cash problem underneath the reporting problem
A medical practice pays its bills in cash on a schedule it does not control. Clinicians get paid every two weeks. Rent, software, malpractice insurance, all monthly, all fixed. But the revenue side runs on the insurance carriers’ schedule: the practice delivers care today, submits the claim this week, and gets paid whenever the carrier decides, thirty, sixty, ninety days later, or never. The practice is effectively lending money to insurance companies every single day it operates, interest free, and payroll does not wait for the loan to be repaid. The clock that measures this gap is cash conversion, and the standard version of it starts counting too late.
That timing gap is survivable when it is stable. It stops being survivable when it widens. Growth makes it worse, not better: every new clinician and every new market means more payroll now against more receivables later. Revenue on paper keeps climbing while the bank account keeps tightening, which is the specific kind of squeeze that makes an owner start asking hard questions, because it is how healthy-looking practices die.
And claims differ from ordinary slow receivables in one brutal way: this money expires. Insurance contracts set filing and appeal deadlines, commonly 90 to 180 days. A claim that sits unresolved past the deadline becomes a permanent loss, converted quietly into a write-off that no one ever has to explain.
The investigation
We recently ran a full claims-flow investigation for a nationwide medical practice running on AdvancedMD, with tens of millions of dollars in annual billed charges across roughly 180 insurance carriers. The finance team had bank statements and an accounting system. The billing team had the practice management system. Nobody had the picture in between. The owners were feeling the timing gap widen without being able to name it, and outstanding balances were aging toward filing deadlines while nobody could see which carriers, which months, or why.
Before we go further, four terms, so a non-biller can read the rest without stopping:
A claim is the bill for one patient visit. A claim carries one to three charges, the individual services performed. A remittance (the electronic version is called an ERA) is the report an insurance carrier sends back explaining what it paid and why. And a write-off is a balance the practice removes from its books. Under a contract, that is the discount the insurance agreement requires. Outside a contract, it is a balance the practice gave up on.
Here is what eighteen months of claims data showed when we finally lined it all up. The dollar figures below are rounded and lightly disguised, but every pattern is real.
First, the big picture nobody had seen
Across the period, the practice billed roughly $50 million in gross charges to insurance. About $20 million came back as cash. Another $20 million, around 40% of everything billed, was written off, which is normal when gross fees run far above contracted rates. About $8.5 million was still outstanding, and the remainder was patient responsibility.
Two numbers in that paragraph changed the executive conversation. First: of every billed dollar that had finished processing, about 48 cents became cash. That is the honest scorecard, and no standard report showed it. Second: of the $8.5 million outstanding, roughly $5 million was more than 90 days old, which is the slice where money actually dies, because insurance contracts set filing deadlines after which a claim becomes legally unpayable.
So when the owners saw the first cut of this data, the reaction was not curiosity. It was urgency on three levels: cash they had already earned was stuck at nameable carriers for fixable reasons, some of it was weeks from expiring permanently, and the problem’s next stop was the operating account. That is why this went from “interesting analysis” to “standing weekly review” in one meeting.
With the big picture established, the problems fell out one by one.
What carrier-level visibility actually looks like
Before the problem list, here is the level of detail this produces. Below are ten of the practice’s carriers, anonymized and lightly disguised, exactly as they appear in the working file (the real version carries about 180 rows, plus a month-by-month history behind every one):
| Carrier | Billed | Paid | Written Off | Still Owed | % of Claims Paid | Cash per Settled $ | Days to First Payment | What the data says |
|---|---|---|---|---|---|---|---|---|
| A. Large Blue plan | $13.9M | $7.1M | $5.8M | $0.8M | 96% | $0.54 | under 5 | Working normally |
| B. Contracted national payer | $8.7M | $4.0M | $4.1M | $0.5M | 97% | $0.49 | ~7 | Working normally |
| C. National commercial #1 | $4.2M | $1.4M | $1.8M | $0.9M | 90% | $0.43 | ~3 | Healthy rate, largest open balance |
| D. National commercial #2 | $2.7M | $1.2M | $1.3M | $0.2M | 98% | $0.46 | ~3 | Working normally |
| E. Regional plan | $2.4M | $1.1M | $0.7M | $0.7M | 83% | $0.60 | ~4 | Pays well, every payment posted by hand |
| F. State managed-care plan | $1.8M | $0.36M | $0.55M | $0.85M | 55% | $0.38 | ~25 | Broke in February; single digits since |
| G. State Medicaid program | $0.8M | $0.11M | $0.19M | $0.5M | 42% | $0.37 | ~16 | Barely paying; enrollment suspect |
| H. Medicaid specialty plan | $0.34M | $0.008M | $0.018M | $0.31M | 8% | $0.31 | ~20 | 1 in 12 claims paid; setup problem |
| I. Out-of-state Medicaid | $0.30M | $0.009M | $0.035M | $0.26M | 43% | low | ~53 | Slowest payer on the book |
| J. Regional PPO | $0.04M | $0.00M | $0.035M | $0.0M | 2% | $0.00 | n/a | Everything written off, nothing collected |
Read down that last column and notice what a practice-wide average would have hidden. Carriers A through D, roughly 60% of all billing, are fine. The problems are concentrated in F through J, and each one has a different disease: F broke mid-year, G and H are enrollment failures, I is a speed problem, J is a surrender problem. One blended “days in AR” number would have averaged all of this into mediocrity and pointed at nobody.
And every row opens up. Behind carrier F sits a month-by-month grid showing exactly when the payment rate fell off a cliff, how many claims and dollars are stuck in each aging bucket, the date of its last payment, and the date of its last electronic remittance. That is the resolution at which a conversation with a payer rep changes from opinion to evidence.
The nine problems hiding in the data
1. Carriers that never answered at all
More than 30 carriers had been billed for months and had never responded. No payment, no denial, not even a single remittance. Silence.
The pattern jumped off the page: nearly all were Medicaid plans in states the practice had recently expanded into. The practice had grown; its payer enrollment paperwork had not kept up. And behind part of the silence sat the harder version of the same failure: no EDI enrollment at all, the electronic connection a carrier requires before it will accept a claim. Those claims were going out on schedule and getting blocked at the door. Nothing entered adjudication, no rejection came back to say so, and the filing-deadline clock was running on every one.
An aging report shows these balances as “old AR.” It cannot show that the carrier has never once engaged, which is a different problem with a different fix and a hard deadline.
2. The carrier that broke
One of the practice’s ten largest carriers paid roughly 30% of billed charges all through the prior year. Then, starting in one specific month, its payment rate on newly submitted claims collapsed to under 5%, while claims kept flowing to it every week. Roughly $600,000 stalled.
Nobody noticed for months, because each individual claim just looked “in process,” and the carrier kept sending the occasional small check, which reset everyone’s sense that things were fine.
Trend the data by the month claims were submitted and the break is a cliff you can date to within a few weeks. That date is everything. It converts a vague “why is AR up?” meeting into a specific question for the payer rep: what changed in February, contract, credentialing, claim format, or policy?
3. Carriers that went quiet
Different from broken: these carriers paid normally, then stopped entirely while the practice kept billing them. We found more than a dozen. One had been silent for eight months. Each had a precise last-payment date, which matters, because the causes are mundane and fixable: a credentialing lapse, a bank-account or address change that broke the payment path, a hold nobody escalated. The fix starts with a phone call, but only if someone knows which carriers to call and can open with “you stopped paying us on December 4th.”
4. Carriers that were written off instead of collected
The sneakiest finding. A handful of carriers showed nearly clean aging, almost nothing outstanding. Healthy, right?
No. For each of them, more than half of everything ever billed had been written off, with almost no cash ever received. The extreme case: one carrier had essentially 100% of its billed charges written off, $38,000, with zero dollars collected, ever.
Write-offs make aging look clean. That is precisely the danger. An erased balance disappears from every report a billing team runs, so a practice can surrender real money while every dashboard stays green. The only way to catch it is to put written-off dollars on the same page as paid dollars, carrier by carrier, and ask of each: was that discount contractual, or was it a quiet defeat? We have watched this species of problem before, in a category nobody questions.
5. Payments typed in by hand
Out of roughly 180 carriers, only about 35 had ever sent an electronic remittance. Over 110 carriers paid money but never sent one, meaning every one of those payments was posted into the billing system manually.
The headline case: the practice’s fourth-largest carrier, more than a million dollars in payments, zero electronic remittances, ever. Every check keyed in by hand, for want of a single ERA enrollment form at the clearinghouse.
Manual posting costs more than labor. It adds lag, typos, and reconciliation risk, and it stays invisible because no report shows “how this payment arrived.”
6. “Paid” claims with no money in them
One carrier showed more than 150 charges marked paid, with a paid total of $0.00. Denials and contract adjustments were being posted as zero-dollar payments. Every “percent of claims paid” metric the practice looked at was quietly inflated by entries like these. If your reporting counts a zero-dollar posting as “paid,” your paid rate is fiction. You have to count paid-with-money separately from paid-on-paper. It is the same lesson as the clean claim rate that lies: a metric is only as honest as what it counts.
7. The aging clock that lies
At more than two dozen carriers, payments routinely arrived before the most recent submission date on the claim. Read that again: paid before submitted. It means claims were being rebilled after they were paid, or resubmitted over and over during disputes, and each resubmission resets the claim’s official age.
The consequence is worth sitting with. A claim that has been fought over for five months can appear in the 0-to-30-day bucket looking fresh. Whatever your aging report says, the truth is older. In this practice’s case, the “under 60 days” buckets were understated, which had been hiding how stale the disputes at the worst carriers really were.
8. The slow leak
Some carriers were not broken, just drifting: average days-to-payment creeping up month after month, balances sliding from the 30-day bucket into the 60s and 90s. Any single month looked acceptable. The twelve-month trend did not. Two carriers accounted for over $450,000 of slow-aging balances between them. State prompt-pay laws cap how long an insurer may take to pay a clean claim, and a documented drift past those limits is a negotiating card a practice rarely knows it holds.
9. Posted is not deposited
Everything above lives inside the practice management system. The final problem lives between systems. A payment posted in the billing system is a keystroke. Money is a bank deposit, and the accounting system is a third, separate record. Until someone matches all three, carrier by carrier and month by month, two ugly scenarios stay invisible: cash that arrived but was never posted, and postings for cash that never actually landed. That three-way match is tedious by hand and nearly automatic once the carrier-level data exists, and it is the single control a CFO cares most about.
Four of the nine were never billing problems
Look again at which problems carried the money. Problems 1, 3, 5, and 6 are configuration and enrollment work, not claims work: payer and EDI enrollments never completed in the states the practice grew into, so submitted claims had nowhere to land; ERA enrollment forms never filed at the clearinghouse; credentialing and payment paths that lapsed without an alert; posting conventions set once and never revisited.
The billing team was doing its job, working the claims in front of it. Setup work like this has no queue and no owner, because everyone assumes it ended at go-live. It does not end. Every new state, every new carrier, and every new clinician reopens it, and this practice had been growing fast. The claims were fine. The pipes they traveled through were never fully connected, and no report anyone ran was pointed at the pipes.
Why the practice’s reports never showed any of this
None of these problems is exotic, and none required wrongdoing. They persist because of how standard reporting works.
The aging report has no memory. It photographs balances at a moment in time. A carrier that broke in February and a carrier that was always mediocre look identical in a photograph; only the film shows the difference.
Write-offs remove evidence. Every standard report is organized around open balances, and a write-off deletes the balance from view. Clean aging is ambiguous: it means either well-collected or quietly surrendered, and no snapshot can tell you which.
Averages bury outliers. Practice-wide numbers blend 180 carriers into one figure. The problems live in the twenty worst carriers, and the average smooths them out of sight.
And the money trail crosses three systems that do not talk: billing, bank, accounting. The gap between them is where problems survive the longest.
What it took to see it
Nothing above required new software on day one. It required assembling data the practice already owned into one carrier-level view: what was sent, what was paid, what was written off, what is still open, in counts and dollars, by the month the claims went out, for every carrier, with every claim traced through to its outcome.
On top of that view, each of the nine problems becomes a simple, nameable test with a plain-English verdict. Each verdict reads the way an operator talks: “This carrier has never responded to us. Confirm we are enrolled before the filing deadline.” “This carrier broke in February; here is the before and after.” “This carrier pays you a million dollars a year and your staff types in every payment; one enrollment form fixes it.”
One design constraint mattered as much as the analytics: everything is carrier-level aggregate. No patient names, no dates of birth, no identifiers of any kind. The finance team, the FP&A analyst, an outside advisor, all of them can work the entire problem without ever touching protected health information.
The oversight layer
It is worth being precise about what this layer is, because owners hear “revenue cycle” and assume it means more software for the billing department. It never enters the billing department’s workflow. Your EMR and practice management system are where the work happens: scheduling, documentation, claim submission, payment posting. Your billing team lives inside that system all day, working one claim at a time, and both are doing their jobs. The operator’s questions sit at a different altitude: is the whole machine working, where is it quietly failing, and what gets fixed first?
This sits on top of that machine, the way financial controls sit on top of bookkeeping. It does not touch a single claim. It watches what the system already recorded, and every finding lands as a ranked action list with an owner attached. Priority one, the broken carrier, $600,000 at stake: payer contracting takes the before-and-after to the rep this week. Priority two, the Medicaid plans that never respond: the billing manager verifies enrollment before filing deadlines hit. Priority three, the million-dollar carrier posted by hand: revenue cycle ops files one ERA enrollment form. Each item has a dollar figure, a named owner, and a specific first move, which is the difference between a report that gets read and a report that gets executed.
The billing team keeps working claims, the way it always has. The owner finally gets to manage the system the claims flow through, with the same discipline they already apply to P&L and payroll.
Who runs the billing does not change what the layer does. In-house, it is how leadership sees the whole machine instead of a queue. Outsourced, it gives the practice and its billing service the same carrier-level picture, drawn from the practice’s own system, so the monthly conversation runs on evidence: here is the carrier that has never paid us, here is the one that needs a single ERA enrollment form, here is where the write-offs deserve a second look. Findings arrive as shared work items with the data attached, and the service working the claims is the first to benefit from knowing exactly where to aim.
It matters most at the moment of transition. Practices switch billing arrangements, or bring billing in-house, at exactly the moment when the least is known: open claims fall into the seam between teams, and the incoming team inherits balances it did not create. Run the funnel before the handoff and both sides cross over with a complete picture: exactly where every carrier stands, which balances are real and which are already lost, what corrective actions transfer on day one, and a baseline to measure the new arrangement against ninety days later. The transition stops being a leap of faith and becomes a measured handover.
And it scales past a single practice. For a PE firm or an MSO holding a portfolio, the same funnel runs on every practice and rolls up: where each one stands, where the breakdowns are, and which practices share the same broken payer. It works as diligence on a practice you are about to buy, as a 100-day baseline on one you just bought, and as the standing operating review on the ones you hold. One practice or twenty, the answer arrives in the same form: a carrier table, a ranked action list, and a named owner for every item.
The point
This practice believed it had one problem: AR was creeping up. It actually had nine, wearing a trench coat: enrollment failures with deadlines attached, a broken carrier, silent carriers, write-off leakage, manual posting, inflated paid metrics, an understated aging report, slow-pay drift, and an unverified gap between posted and deposited.
Every one was findable in data the practice already owned, and every one had been invisible for more than a year. Once the data was assembled, each came with a specific next action and a name attached.
And the funnel did not run once. It runs every week now, on fresh data, so the next carrier that breaks gets caught within weeks instead of surfacing a year later as a cash crunch. Finding the nine was the first step. Watching for the tenth is what keeps them fixed.
This is not for every practice. A group with a handful of carriers, a monthly three-way reconciliation, and numbers it trusts already has the control in place. It is for the practice that grew, added states and carriers and clinicians, and never rewired the oversight to match.
If you run a practice on AdvancedMD, your version of this story is sitting in your database right now. PracticePath is how we surface it: the same carrier-level funnel, the same nine tests, the same plain-English verdicts, portable to any AdvancedMD practice, with no patient data involved.
Grab 30 minutes with us. You’ll see your own carrier table and which of the nine problems you have.
PracticePath is not affiliated with, endorsed by, or sponsored by AdvancedMD. AdvancedMD is a trademark of AdvancedMD, Inc. All references are for descriptive purposes only.