Why your collections report looks fine while cash is tight
You pull the A/R report. It says a couple hundred thousand dollars is outstanding. Collections look normal. Then Friday comes and payroll is tight again.
Both things are true at the same time. The report is not lying to you on purpose. It is showing you what is in the system, and what is in the system is wrong.
Here is what is usually wrong with it, and how to check yours without hiring anybody.
An A/R balance is a forecast, and nobody treats it like one
When your system says a payer owes you $234,000, you read that as money on its way in. That is the only reason the number matters to you. Nobody looks at A/R for fun.
But that balance is built on five assumptions:
- every claim was priced at the rate in your contract
- every payment that arrived got matched to a claim
- every claim in the balance is still inside the filing window
- nothing is in there twice
- nothing in there has already been paid back
Break one of those and the number is no longer a forecast. It is a story about a forecast.
The four things that inflate it
Cash that arrived and never got posted. A payment hits the bank. Nobody applies it to the claims it paid. The money is real and it is yours, but the system still shows those claims open, so your A/R includes cash you already spent. This is the most common error we find and usually the largest.
Rates loaded wrong. The fee schedule in your practice management system does not match the rate in the payer contract. Every claim at that code was recorded at a price it was never worth. You did not underbill and you did not lose money — the system just wrote down the wrong number. But your revenue is overstated and so is your A/R, and neither will ever reconcile to cash.
Claims past timely filing. Most payers give you 90 to 180 days from date of service. A claim past that window is not receivable. It is a write-off you have not taken yet. It sits in A/R making the number look better right up until someone finally asks about it.
Overpayments. The payer paid you twice, or paid more than the claim was worth. That shows up as a credit and quietly reduces your A/R total. It is not a reduction in what you are owed. It is a liability. They will take it back, usually by withholding it from a future payment, usually with no warning.
There is a fifth, less common but worth a look: the same session entered twice. Two claims, one date of service, one set of units delivered. One of them is going to deny and one of them was never real.
What this looks like with actual numbers
We were asked to check one payer’s book for a practice — roughly 4,400 claims across seventeen months — because collections felt slower than the reports suggested. Every claim got checked against what was billed and what the payer actually paid.
Figures from a completed engagement, anonymized.
The real number was $139,998. The system was overstating collectible A/R by about $94,000, and overstating revenue by about $26,000.
That $18,603 of uncollectible broke down into six buckets, none of which anyone was going to collect no matter how hard they chased:
- $4,888 — payer paid part of the claim and adjusted the rest, 58 claims
- $4,763 — claims voided and re-entered as new claims, so chasing both means chasing the same session twice, 23 claims
- $3,818 — never billed, now too old to bill, 19 claims
- $2,836 — payer took back more than it paid, 8 claims
- $2,081 — same session entered twice, 12 claims
- $217 — small adjustments already posted against open claims, 2 claims
The part that actually matters
Of the $139,998 that was real, only $14,040 was money that turns into cash by moving quickly — claims never billed, still inside the filing window. That is the only line on the whole page that shrinks while you think about it.
$83,291 was billed inside the last 45 days. Normal. Leave it alone and let it pay.
$42,667 was billed more than 45 days ago and still unpaid. Some of that pays and some of it turns out to be a write-off, and nobody can tell you which until the payer statuses each claim. That is a meeting, not a report.
And $10,149 of overpayments needed to be set aside as money to give back, not counted as income.
So: the practice thought $234,000 was coming. About $140,000 was coming. If you build a payroll plan on the first number, the gap shows up on a Friday.
Three root causes, in order of what they cost
- Payments not being posted. $70,766 unmatched.
- The fee schedule loaded wrong. $25,966 of revenue that never existed.
- Duplicates and voids never cleaned up. About $7,000, and it makes every other number in the system unreliable.
All three are configuration and process problems inside the practice management system. Not one of them is a collections problem. Nobody was chasing the wrong payer. They were chasing the wrong number.
This is why a collections-only fix does not work. If you hire someone to work the A/R and the A/R is wrong, you have paid someone to chase money that was never there.
Five checks you can run this week
You do not need anybody’s help for these. Pick one payer and one twelve-month window.
1. Cash in versus cash applied. Total everything that payer deposited into your bank. Total everything the system shows applied to that payer’s claims. The gap is unposted cash. If there is a gap, it is the first thing to fix, because until it is fixed every other number is wrong.
2. Rates, three ways. Pull your top ten codes by volume. Write down the rate in the contract, the rate loaded in your system, and the rate on the last remittance. All three should match. When they do not, the contract is right and the other two need a reason.
3. Filter A/R by date of service, not by claim age. Anything older than that payer’s filing window is not receivable. Add it up. That is your unrecorded write-off.
4. Look for credit balances. Any claim with a negative balance is an overpayment. Total them and move that total out of A/R and into a liability. If you have never done this, the number is usually larger than you expect.
5. Sort by client and date of service and look for repeats. Two claims, same client, same day, same code. One of them is wrong.
If all five come back clean, your A/R report is a forecast and you can plan against it. That is a real and useful thing to know.
If they do not come back clean, you now know roughly how wrong the number is, which is more than you knew on Monday.
A note on what to do next
Finding the problem and fixing the problem are two different pieces of work, and it is worth being clear about which one you are buying. Quantifying the damage takes a few weeks and produces a number. Repricing claims, cleaning duplicates, rebilling what can still be billed and posting the write-offs is a separate project with a separate timeline.
Do them in that order. And write off nothing until the payer confirms it in writing.
One more distinction, because the two get used interchangeably and they are not the same thing. Everything above is a claims audit. It starts after a session has been converted and billed, and it reconciles the back half of the cycle to cash. It is the right instrument when you already know which payer book is the problem.
A Leak Map is wider. It starts three stages earlier — at the reservoir, the authorized hours narrowed to what the guardian has actually agreed to and the analyst has approved; the sessions that get cancelled and never come back; and the lag between a delivered session and a submitted claim. In most practices the larger number is upstream, before a claim exists to audit.
Aimline closes the books, oversees the revenue cycle, and sits in the CFO seat for ABA practices. We run claims audits scoped to a payer book, and Leak Map Assessments that measure the full cycle — three weeks, $7,500 fixed. Either one gives us a verified number to run oversight against, and the report is yours whether or not you engage us to fix what it finds.
