To reconcile EFT payments with EOBs, match each bank deposit to its remittance by trace number, then compare the deposit amount with the EOB or ERA total after provider-level adjustments. A zero variance means the pair is reconciled. Anything else is either an offset to explain, a remittance still missing, or a deposit posted to the wrong batch.
Matching an EFT deposit to its EOB: the trace number
Matching an EFT deposit to its EOB uses the reassociation trace number, a unique number the health plan puts on both the electronic funds transfer and the remittance that explains it. The same number on the bank side and the remittance side proves the two belong together. Amounts and dates help, but the trace number is the key.
An electronic funds transfer (EFT) is a payment sent through the Automated Clearing House (ACH) network straight to the practice's bank account. The remittance is the explanation of benefits (EOB) on paper or the electronic remittance advice (ERA), the X12 835 file. They travel separately. The X12 sample file for dollars and data sent separately shows this case: the money moves through the ACH network while the remittance goes to the provider on its own.
The CMS fact sheet on EFT and ERA payment remittance reassociation basics explains the rule behind the number. It says the adopted HIPAA standards require health plans to include a unique Reassociation Trace Number (TRN) in the payment instruction they send their bank, and a matching TRN in each corresponding ERA. In the 835 file, the trace number sits in the TRN segment. On a paper EOB, it usually prints near the payment total in the header, labelled as the EFT or trace number.
There is a catch on the bank side. The same CMS fact sheet notes that HIPAA rules do not require banks to pass the trace data along to providers in their deposit notices. A CAQH CORE operating rule instead requires health plans to tell providers, at enrollment, that they need to contact their bank to arrange delivery of that data. If your bank statement shows only "Example Health Plan HCCLAIMPMT" and an amount, call the bank and ask for the addenda with the trace number.
Once both sides carry the number, matching is a lookup. List the day's deposits with their trace numbers, list the day's remittances with theirs, and pair them.
How do you reconcile EFT payments with EOBs when amounts differ?
When an EFT and its EOB carry the same trace number but different amounts, the difference is almost always a provider-level adjustment: an offset for an earlier overpayment, an interest payment, or a fee. Compute the expected deposit from the remittance, including those adjustments, and compare that with the bank amount. Most variances disappear at this step.
The rule for the expected deposit comes from Medicare's remittance guidance. The CMS MLN booklet Remittance Advice Resources and FAQs states that the check amount is the sum of all claim-level payments, less any provider-level adjustments. It also states that positive adjustments reduce the payment and negative adjustments, such as interest on a late clean claim, increase it. So the expected deposit is the claim total minus positive provider-level amounts plus negative ones.
What provider-level adjustments are, and how recoupments link back to the original claim, is explained in the guide to PLB provider level adjustments on an 835. This section uses them only as a column on the worksheet.
A reconciliation worksheet
The worksheet below has one row per deposit or remittance. Every payer, trace number and amount is a fictional example.
| Deposit date | Payer | Deposit | Trace number | EOB/ERA claim total | PLB (net) | Expected deposit | Variance | Status |
|---|---|---|---|---|---|---|---|---|
| 10/14/2026 | Example Health Plan | $2,315.40 | 1EX0098812 | $2,410.40 | $95.00 | $2,315.40 | $0.00 | Reconciled |
| 10/14/2026 | Sample Mutual | $860.00 | 77125099 | $860.00 | $0.00 | $860.00 | $0.00 | Reconciled |
| 10/15/2026 | Demo Care Plan | $1,102.75 | 4410021 | none found | $1,102.75 | Missing remittance | ||
| none yet | Example Dental Plan | EFT55102 | $312.00 | $0.00 | $312.00 | -$312.00 | Remittance with no deposit |
Variance is the deposit minus the expected deposit. A positive variance means money with no explanation. A negative variance means an explanation with no money.
The worked mismatch
The first row started as a problem. The poster added the claim payments on Example Health Plan's ERA and got $2,410.40. The bank showed $2,315.40, a gap of $95.00. The batch would not balance.
The answer was at the end of the ERA. Two provider-level entries appeared there:
- A recovery of $120.00 for an overpayment on an earlier claim, reported as a positive amount with a reference to that claim.
- Interest of $25.00 on a claim paid late, reported as a negative amount.
The net provider-level amount is $120.00 minus $25.00, or $95.00. The expected deposit is $2,410.40 minus $95.00, which is $2,315.40. The variance is zero.
Posting finishes the job. The $120.00 recovery goes against the earlier claim it references, which reopens that claim's balance for review. The $25.00 interest goes to the account your practice uses for interest income. Neither belongs on any of today's patient claims.
Fees work the same way when a payer or payment vendor deducts one from the payment. Treat it as a provider-level item, record it in its own account, and question it if your contract or EFT enrollment does not allow it.
Unmatched EOBs and missing remittances: finding the other half
Unmatched EOBs and missing remittances are the two halves of the same problem: a deposit with no explanation, or an explanation with no deposit. Both block posting. Neither should be guessed at. Hold the item in a suspense list, give the other half a few days to arrive, then contact the payer using its written procedure.
Timing gives you a fair waiting period. The CMS reassociation fact sheet describes a CAQH CORE rule that requires health plans to release the ERA no sooner than three business days before the EFT's effective entry date and no later than three business days after it. A deposit that arrives a day before its ERA is normal.
The same fact sheet sets a point where waiting ends. It says health plans must give each provider enrolling for EFT and ERA written procedures for resolving late or missing transactions, and it defines late or missing as more than four business days after receiving either the EFT or the ERA. Keep each payer's procedure where the reconciler can find it.
A deposit with no remittance
Check these places, in order:
- Your clearinghouse inbox and rejected-file reports, in case the ERA arrived but failed to load.
- The payer's provider portal, where many remittances can be downloaded.
- Paper mail, if this payer sometimes sends EOBs on paper.
- Lockbox images, if your bank receives paper EOBs for you.
If none has it after four business days, follow the payer's late or missing procedure. Post the deposit to an unapplied account with the trace number, so the money is on the books but not on any patient.
A remittance with no deposit
Check the bank for a deposit with the same trace number under a different date or a slightly different payer name. Then check whether the remittance pays zero: a zero-pay EOB explains denials and has no deposit at all. If it shows money and no deposit arrives within four business days, contact the payer under its procedure.
Lockbox deposits raise their own gaps, because the bank's file may leave out pages or detail. The guide to lockbox EOB processing, what the bank sends and what it leaves out covers those files.
How often should EFT deposits be reconciled to posting?
EFT deposits should be reconciled to posting every business day, by someone other than the person who posted them, with a short sign-off at the end of each day and a fuller review at month end. Daily work keeps the suspense list short. Separation of duties catches errors that a person checking their own work misses.
The schedule is an internal control, and the reasons for daily work are practical. The four-business-day late or missing window in the CMS reassociation fact sheet is easier to use when items are logged the day they appear. A gap found a week late is harder to trace, and a missed recoupment can sit unnoticed against a closed claim.
A workable routine looks like this:
- Daily. Pull the bank's deposit report with trace numbers. Match each deposit to a posted batch. Log every variance on the worksheet with its status. The reconciler initials the day.
- Weekly. Review the suspense and unapplied accounts. Anything older than four business days gets a payer contact or an escalation.
- Monthly. Compare total deposits for the month with total posted payments plus the change in unapplied funds. The practice manager or controller signs off.
Who signs off depends on the size of the team. In a small office, the practice manager may reconcile and the physician owner may review monthly. In a larger billing group, a separate cash team often reconciles while posters post.
Teams weighing which parts of this to automate can compare options in the guide to payment posting automation, which covers what each payment source allows.
One EFT across several EOBs, or one EOB across several EFTs
One EFT across several EOBs, or one EOB across several EFTs, breaks the simple one-to-one match. The trace number still decides which pieces belong together. When one deposit covers several remittances, add their expected deposits before comparing. When one remittance is paid in several deposits, add the deposits.
The split cases have a few common shapes. The worksheet handles each by grouping rows that share a trace number before computing the variance.
Several remittances, one deposit
A payer may send separate EOBs or ERAs for different providers, locations or claim types, then pay them in a single transfer. Each remittance carries the same trace number. Add their expected deposits, compare the sum with the bank amount, and mark every remittance reconciled together.
A bulk paper EOB is a related case: one payment, one remittance, many patients. Reconciling it is simple. Posting it requires splitting the pages by claim, which the guide to splitting a bulk EOB by patient walks through.
One remittance, several deposits
Less often, a remittance is paid in more than one transfer, for example when a payer issues part of a payment separately. Look for deposits that reference the same remittance and add them. If the trace numbers differ, the payer's remittance or the bank addenda should say which deposit pays which part. When neither does, ask the payer before posting.
Paper checks mixed in
Some payers still pay by paper check for some claims and EFT for others. The check number plays the trace number's role for a paper payment. Keep checks and EFTs on the same worksheet, so a payer's total for the day can be checked in one place.
Keying EOB totals and payment numbers by hand adds one more chance for a mismatch. Schema Care reads EOBs and billing statements into structured fields, with a confidence score on each and uncertain values sent to a person; the list of documents Schema Care reads shows the fields for each type. How reconciliation fits with the rest of the revenue cycle is covered in the revenue cycle automation category.