The short answer: To reconcile insurance deposits, a medical practice matches four records for every payer payment: the ERA 835 remittance, the posting report, the bank deposit, and the general ledger. Link them by the EFT trace number, not the dollar amount, because two payers often pay identical figures the same day. An 835 balances when claim payments minus provider-level adjustments equal the total payment. When a deposit comes in smaller than the remittance, the difference almost always sits in that adjustment segment, not in a posting error.
Most practices believe they reconcile insurance deposits. What they usually do is post payments, glance at the bank balance, and move on. That gap is where money quietly leaves a practice, because nothing breaks when the tie-out is skipped. Countsure builds these routines into outsourced bookkeeping and monthly close work.
Key Takeaways
- To reconcile insurance deposits, match four records: the ERA 835, the posting report, the bank deposit, and the general ledger.
- Match on the EFT trace number, not the amount. HHS adopted the NACHA CCD+ carrying the X12 835 TRN segment so money and remittance share an identifier.
- Provider-level adjustments (the PLB segment) are the top reason a deposit lands smaller than the remittance total.
- An 835 balances when claim payments minus provider-level adjustments equal the total payment. Under CAQH CORE Rule 370, that 835 may arrive up to three business days either side of the payment.
- Booking the net deposit as revenue erases gross charges and contractual allowances from your books.
What Does It Mean to Reconcile Insurance Deposits in a Medical Practice
It means proving four independent records agree for every payer payment. Most guidance stops at three and treats the bank statement as the finish line. The fourth record, your general ledger, is the one an auditor, a lender, or a buyer’s diligence team will ask to see.
That is also what separates reconciliation from posting. Posting updates a patient balance. Reconciliation proves the cash arrived, which is why a practice can post every remittance perfectly and still be missing a deposit that never cleared. Sound accounts receivable management does both.
|
Record
|
What it proves
|
What it misses
|
|---|---|---|
|
ERA 835
|
What the payer paid
|
Whether the money arrived
|
|
Posting report
|
What staff applied
|
Whether the payer agreed
|
|
Bank deposit
|
What cash cleared
|
Which claims it covers
|
|
General ledger
|
What statements report
|
Whether detail was right
|
Have your insurance deposits ever actually been tied back to your billing report?
Countsure reviews a sample of recent payer deposits against your posting reports and bank feed, then tells you where the variances sit and what is causing them.
Why Your Insurance Deposit Almost Never Matches Your Billing Report
The mismatch is usually structural, not staff error. A few causes account for nearly all of it.
Provider-level adjustments, takebacks and interest
When a payer recovers a prior overpayment it does not send an invoice. It withholds the amount from your next payment and reports it at the end of the 835, in the provider-level balance segment, under codes such as WO for overpayment recovery and FB for a forward balance. These apply to the whole payment, not to a single claim, so nothing in the claim detail explains the shortfall. Interest on a late claim sits in the same place and pushes the deposit higher.
Aggregated deposits, card payments and timing
Banks aggregate ACH credits, so a single $14,800 line may be three payer payments that landed the same day. Matching it to one remittance always fails. Some payers also substitute a virtual credit card for an EFT, and the card’s merchant fees mean less reaches your account than the remittance says was paid. That gap is a fee, not a variance. Timing adds a third wrinkle: under CAQH CORE Rule 370 a plan may release the 835 up to three business days either side of the payment’s effective entry date, so a remittance trailing the cash is normal.
The 835 Arithmetic That Proves an Insurance Deposit Is Correct
A worked example
Lakeview Family Medicine receives an EFT from a commercial payer. The billing report shows $12,410 in claim payments. The bank shows $10,581, and the practice manager spends an afternoon hunting $1,829. Two lines at the bottom of the 835 explain it:
- Claim payments across the batch: $12,410.00
- WO overpayment recovery from a prior quarter: $1,860.00 reduction
- Interest on a late claim: $31.00 increase
- Total payment: $12,410.00 minus $1,860.00 plus $31.00 equals $10,581.00
The deposit was correct to the penny. What was missing was the step that reads the bottom of the file.
How to Reconcile Insurance Deposits Step by Step
Run this on days payer deposits arrive. It takes far less time than investigating a 30-day-old variance.
Step 1: Pull the three source documents
For the date being reconciled, gather the 835 files from your clearinghouse, the posting report from your billing system, and the bank transactions. Same date range, all three, before you start.
Step 2: Match on the trace number
Step 3: Post provider-level adjustments, then tie to the deposit
Step 4: Close the loop into the general ledger
Book the deposit to cash, the gross charge to revenue, and the contractual adjustment as contra-revenue. Route unidentified cash to a named suspense account with an owner and a review date, never to revenue, because aged unapplied cash overstates cash against understated receivables. A sound QuickBooks chart of accounts setup makes this a two-minute entry, and a mid-year financial review catches what slipped.
The Reconciliation Mistake That Distorts a Practice's Financials
Booking the net deposit as revenue
This is the most damaging error and the least discussed. If a $10,581 deposit is booked as $10,581 of revenue, gross charges and the contractual allowance never enter the books. Under ASC 606 a contractual allowance is a price concession that reduces the transaction price, so it belongs in the accounts as a reduction of gross revenue. Skip it and the practice cannot answer the basic question: what share of billed charges are we actually collecting?
Do your gross charges and contractual allowances actually appear in your books?
Countsure rebuilds the revenue and contra-revenue structure so your statements show billed charges, contractual adjustments and net collections separately.
Frequently Asked Questions
1. What is the difference between payment posting and reconciliation?
Posting applies a payment to a patient account. Reconciliation proves the money reached the bank and the ledger. Posting can be accurate while reconciliation still finds a deposit that never cleared.
2. Why is my insurance deposit less than the ERA total?
3. What is a PLB segment on an 835 file?
4. How do I match an EFT deposit to the correct ERA?
5. What is the difference between an EOB and an ERA?
6. Should a medical practice record insurance deposits gross or net?
7. How often should a medical practice reconcile insurance deposits?
Conclusion: How to Reconcile Insurance Deposits Without Guesswork
To reconcile insurance deposits properly, a medical practice must move past the bank statement and prove four records agree: the remittance, the posting report, the deposit, and the general ledger. Matched on the trace number and read down to the provider-level adjustments, most missing money turns out to be a takeback nobody posted. The practices that get this right reconcile daily and never let a variance age.
- Match every payer deposit on the trace number, not the amount.
- Read the bottom of every 835 before opening an investigation.
- Record gross charges and contractual adjustments separately.
Give every suspense item an owner and a review date.
Ready to hand the reconciliation routine to someone who does it every day?
Parth Shah, Managing Director
(CPA-US, FCA, RV-S&FA, DISA)
In cleanup engagements, the most common issue is not a missing payment-it’s an untouched suspense or unapplied cash account alongside revenue recorded directly from bank deposits instead of billed charges. Once revenue is recorded net, the books no longer show what the business is actually collecting, and rebuilding that history becomes costly.
The second issue is ownership. In small offices, the same person often posts and reconciles payments, removing an important control that could catch errors.
