Why don't our insurance collections match what actually hits the bank?

The short answer is that your practice management system and your bank are not looking at the same record. Payments get posted from the remittance. The bank records the deposit. Those are two separate transactions from the payer, and they rarely line up neatly.

There are three documents involved. The ERA (electronic remittance advice) is the payer’s explanation of how each claim was paid, adjusted, or denied. The EFT is the actual money moving into your account. The EOB is the explanation of benefits sent to the patient. The EOB is useful for patient questions but isn’t meant for reconciling your accounts. Reconciliation happens between the ERA, what your billing team posted, and the bank.

The most common reasons the numbers drift apart are predictable. The EFT often arrives a few days before or after the ERA, so payments posted on the 30th may not hit the bank until the 2nd of next month. One deposit usually covers dozens of claims across many patients. The ACH memo line on your bank statement often doesn’t show the trace number that ties the deposit back to its remittance, so someone has to match them by amount and date. Adjustment codes get misread, and a contractual write-off (CO) gets posted as patient responsibility (PR) or the other way around. Payers also take back old overpayments by subtracting them from a later check. If nobody posts that recoupment, the billing system shows more cash than the bank ever received.

A typical month might look like this. The billing system shows $62,400 in insurance payments for March, and the bank shows $58,150. Of the $4,250 gap, $2,900 is an ERA posted March 31 whose deposit landed April 2. Another $1,100 is a recoupment netted out of a Blue Cross payment that was never posted. The last $250 is a payment someone entered twice. None of it is mysterious once you trace it, but nobody traces it unless it’s part of a routine.

That routine is a three-way match. On a set schedule, weekly for busier practices, compare ERAs, payments posted in the practice management system, and bank deposits. Anything in the bank that can’t be tied to a remittance gets held as unapplied cash, not guessed at. Each unmatched item gets an owner and a follow-up date so it doesn’t sit there for six months.

The match also surfaces underpayments. When a payer pays below your contracted rate and the difference gets written off as contractual, the books balance but you’ve lost money. Reviewing remittances regularly is how those get caught and appealed.

This check is built into our monthly bookkeeping for practices that bill insurance. We confirm that what your billing system says was collected actually reached the bank, and we flag the gaps for your billing team to resolve. Clean collections data matters at year end too. Revenue that’s double counted or missing throws off the numbers behind your return, which is why our tax services for physicians start with books that tie to the bank.