Ask most medical office managers if they reconcile insurance payments and they’ll say yes. Ask them what that means and you’ll get a range of answers — from “I check that the deposit matches the EOB” to “we post payments and assume it’s right.” The truth is, most practices aren’t reconciling insurance payments at all. They’re posting payments and hoping for the best.
Real reconciliation is a three-way match: the ERA 835 remittance advice, the claim in your practice management system, and the bank deposit. When all three agree, you know you were paid correctly. When they don’t, you’ve found money that’s either missing or misapplied. And in a typical medical practice, the discrepancies add up to thousands of dollars per month.
What Insurance Payment Reconciliation Actually Means
Reconciliation is the process of verifying that three independent records agree:
-
The ERA 835 (what the payer says they paid) — This electronic remittance file lists every claim included in a payment, the amount paid per claim, adjustments applied, and the total payment amount.
-
The claim in your PMS (what you expected to be paid) — Your practice management system has the original claim with billed amounts, fee schedules, and expected insurance portions.
-
The bank deposit (what actually arrived in your account) — Your bank statement shows deposits, but a single deposit may aggregate multiple payer payments, and the deposit amounts don’t always match the ERA totals.
True reconciliation means matching all three: confirming the payer’s reported payment matches the posted amount in your PMS, and that the total for that payer matches what was deposited in your bank account. When all three align, you have a verified, closed-loop record. When they don’t, you have a discrepancy that needs investigation.
Why Reconciliation Matters More Than You Think
Catching Underpayments
Insurance payers underpay claims more often than most practices realize. Industry studies estimate that 5-10% of claims have payment discrepancies — not outright denials, but subtle underpayments where the payer paid less than the contracted rate or applied an incorrect adjustment.
On $200,000 in monthly insurance payments, a 3-5% underpayment rate represents $6,000-$10,000 per month in revenue your practice earned but didn’t collect. Over a year, that’s $72,000-$120,000. Without reconciliation, these underpayments are invisible — they look like normal payments because no one is checking.
Preventing Incorrect Write-Offs
When payments are posted without reconciliation, adjustment codes are often accepted at face value. A contractual adjustment (CO-45) looks the same whether it’s $50 or $500. But a $500 contractual adjustment on a procedure with a $400 contracted rate means something went wrong — either the fee schedule is outdated, the wrong plan was applied, or the payer made an error.
Practices that don’t reconcile tend to write off these discrepancies as contractual adjustments, effectively giving away revenue. The write-off shows up as a normal adjustment in the PMS, and nobody questions it.
Maintaining an Audit Trail
If your practice is ever audited — by a payer, by a licensing board, or for tax purposes — you need to demonstrate that payments were received, posted correctly, and reconciled against bank deposits. An unreconciled revenue cycle has gaps that auditors flag immediately.
Beyond external audits, internal controls matter too. Without reconciliation, there’s no way to detect posting errors, duplicate payments, or (in worst cases) embezzlement. Reconciliation is a fundamental financial control.
The Manual Reconciliation Process
Here’s how most practices attempt reconciliation manually:
Step 1: Download ERA Files
Log into your clearinghouse portal, download new ERA 835 files, and organize them by payer and date. Some clearinghouses deliver ERAs automatically; others require manual downloads.
Step 2: Post Payments
Open each ERA, match it to the corresponding claim in your PMS, and post the payment. Enter the payment amount, adjustment amounts, adjustment reason codes, and patient responsibility for each claim. For a bulk payment covering 20-30 claims, this can take 30-60 minutes.
Step 3: Verify Payment Totals
After posting all claims from an ERA, compare the total posted amount to the total payment amount on the ERA. If they don’t match, you have to find the discrepancy — a missed claim, a transposed number, or a posting error.
Step 4: Match to Bank Deposits
Check your bank statement for the deposit. If the payer sent EFT, the deposit amount should match the ERA total. If they sent a check, you need to match the check amount to the ERA, then verify the check was deposited and cleared.
Step 5: Investigate Discrepancies
When numbers don’t match — and they frequently don’t — someone has to figure out why. Common causes include partial payments, combined deposits from multiple ERAs, bank processing fees, and timing differences between payment and deposit dates.
Where Manual Reconciliation Fails
The manual process described above is theoretically sound. In practice, it breaks down for several predictable reasons:
Volume Overwhelm
A 5-provider practice processes 150-300 ERA files per month across 20-30 payers. Each file contains 5-50 claims. That’s thousands of individual line items to match. Most billing teams fall behind within the first week of the month and never catch up.
The Aggregation Problem
Banks aggregate deposits. A single bank deposit on Tuesday might include EFT payments from UnitedHealthcare, Cigna, and Aetna that arrived the same day. The bank shows one deposit for $15,000 — but you need to break that into three separate payer payments of $7,200, $4,800, and $3,000 and match each to its respective ERA. Without deposit-level detail, this matching is guesswork.
Timing Mismatches
An ERA dated February 10 might correspond to a bank deposit on February 12 (EFT) or February 25 (check). When you’re reconciling at month-end, you’re trying to match ERAs from different dates to deposits from different dates, and the window of uncertainty makes exact matching difficult.
Staff Turnover and Knowledge Loss
Manual reconciliation relies on institutional knowledge. When your billing manager who “knows” how each payer structures their payments leaves, the new person starts from zero. There’s no system — just learned patterns that walk out the door with the employee.
It Simply Doesn’t Get Done
This is the most common failure mode. Reconciliation is important but not urgent — until it is. Practices prioritize posting payments (because that updates patient balances and enables collections) but skip reconciliation (because nothing visibly breaks when you don’t do it). The result is a revenue cycle that looks functional but is quietly leaking money.
The Three-Way Match Concept
The gold standard for payment reconciliation is the three-way match — independently verifying agreement between the ERA, the PMS posting, and the bank deposit. Here’s what each match catches:
ERA ↔ PMS Match: Confirms that what the payer said they paid is what you posted. Catches posting errors, missed claims, and incorrect adjustment codes.
ERA ↔ Bank Match: Confirms that the payment amount the payer reported actually arrived in your account. Catches missing payments, partial deposits, and bank processing errors.
PMS ↔ Bank Match: Confirms that your internal records agree with your bank balance. This is the reconciliation most accountants care about — it’s what makes your books accurate.
When all three match, you have a verified payment. When any pair doesn’t match, you’ve identified a specific type of discrepancy that narrows the investigation.
Common Reconciliation Errors
These are the most frequent discrepancies we see across practices:
- Payment posted to wrong patient — especially with bulk payments covering similar patient names
- Adjustment code misapplied — CO (contractual) vs PR (patient responsibility) changes who owes the balance
- Duplicate posting — the same ERA processed twice, inflating revenue
- Missing ERA — payment deposited in bank but never posted in PMS, creating phantom revenue
- Fee schedule mismatch — payer applied an outdated fee schedule, paying less than the current contracted rate
- Coordination of benefits errors — secondary insurance payment applied as primary, or vice versa
How Automation Changes the Workflow
Automated reconciliation replaces the manual process with a system that runs continuously:
- ERA files are ingested automatically from the clearinghouse — no manual downloads
- Payments are parsed and matched to claims using identifiers, patient data, and procedure codes
- Payments are posted to the PMS with correct amounts and adjustment codes
- Bank deposits are pulled via bank feed and matched to ERA payment totals
- Three-way matching runs across all records, flagging any discrepancy
- Exception dashboard surfaces only the items that need human review
The shift is fundamental: instead of your billing team doing the matching and hoping to catch errors, the system does the matching and only surfaces the errors. Your team’s job changes from data entry to exception management.
The Takeaway
Reconciliation isn’t optional — it’s how you know your practice is collecting what it’s owed. The manual process is theoretically possible but practically unsustainable at the volume most practices operate. If you’re posting payments but not running a three-way match against bank deposits, you’re not reconciling. You’re estimating.
Start by quantifying the gap. Pull your total insurance payments posted last month and compare it to your total insurance-related bank deposits. If those numbers don’t match within 1-2%, you have a reconciliation problem — and you’re not alone. Most practices do. The difference is whether you find the discrepancies before the money is gone, or after.