The short answer
An ERA, the electronic remittance advice, explains how a payer processed a claim. An EFT is the actual money landing in the bank. They're separate files, they often arrive on different days, and reconciling them for real means proving three things agree: the ERA total, what got posted in the EHR or practice management system, and the actual bank deposit. When any one of those three legs fails, cash or income is wrong even while the bank balance looks fine, and this holds regardless of which EHR a practice runs.
This post is EHR-agnostic on purpose. Every platform in this series, Tebra, AdvancedMD, Eaglesoft, SimplePractice, TherapyNotes, WebPT, ChiroTouch and the rest, sits on top of the same underlying payment mechanics described here.
Quick reference: the three-way match
Leg | What you verify | What a miss usually means |
|---|---|---|
ERA to EHR posting | Paid, adjusted and patient-responsibility amounts match what staff actually posted | A posting error, a missed claim, a wrong write-off, or an unposted ERA |
ERA to bank | The ERA payment total equals the EFT, or check, amount | A wrong deposit paired, a takeback netted in, or funds not yet received |
EHR to bank | Posted insurance batches clear to real cash | Income booked without cash, or cash booked without claim detail |
True close is when all three legs hold for the period, not when the bank alone reconciles.
ERA vs EFT in one sentence
The EFT is the paycheck; the ERA is the pay stub. Matching them is called reassociation, and it isn't a bookkeeper's invention, it's a federal operating rule. CAQH CORE's Rule 370 mandates that the healthcare EFT, built on the NACHA ACH CCD+ format, carry an X12 835 TRN Reassociation Trace Number inside its CCD+ Addenda Record, specifically so the payment can be matched back to the correct ERA (CAQH CORE). That TRN is the real match key.
The bank's own ACH network trace number is a different number entirely, used for tracking the transaction through the bank network, not for tying it to a specific remittance. CAQH CORE's own rule documentation is explicit on this point: the ACH Trace Number isn't the number used for reassociation; the TRN Reassociation Trace Number inside the CCD+ Addenda Record is. Confusing the two is a common, avoidable source of mismatched deposits.
Ask the bank to surface the full CCD+ addenda data, including the reassociation trace, on deposit notices. CAQH CORE's own rule language notes banks aren't required to report this data by default, which is exactly why many online banking views hide it unless someone specifically asks for it.
A process that works in any EHR
Enroll and receive. Enroll for ERAs, and EFT where required, with each major payer. Without ERA enrollment, a practice only gets paper EOBs and slower, more error-prone matching.
Pull a daily list of new bank insurance deposits. Note the amount, the settlement date, the payer name if the bank shows it, and any trace or reference numbers available.
Pull open ERAs for the same window. Use the EHR's remittance or payment report list, sorted by amount, payer, check or EFT date, and TRN when available. Expect the ERA to arrive a day or more before or after the deposit; that lag is normal, not a red flag on its own.
Match on TRN first, then amount plus payer plus date. Prefer the reassociation trace number. If the bank doesn't show it, match on amount and payer and document the pair explicitly. Never force two different deposits together just because the dollar amounts happen to be close.
Confirm the EHR batch is posted and closed. Insurance paid, contractual adjustments, denials and patient responsibility should already be on the patient ledgers. Provider-level adjustments, takebacks, interest, offsets, have to be included in the batch total that equals the deposit.
Clear the bank line in QuickBooks or the GL. Record the deposit against insurance income, or through undeposited funds to the bank, with a clear memo: payer, ERA or check number or TRN, and date. Never book the deposit as generic "sales" with no link back to the remittance.
Park exceptions. Unmatched EFTs, ERAs without cash, and partial takebacks stay in an exception list with a named owner and a follow-up date. Never write them off to "misc income" just to force the month closed.
Worked example
An ERA arrives from Payer A, TRN 9876543210:
Line item | Amount |
|---|---|
Claims paid (provider payment total) | $8,420 |
Contractual adjustments on those claims | $2,110 |
Patient responsibility on the remittance | $640 |
Provider-level offset (a prior overpayment) | minus $150 |
Net payment on the ERA (should equal the EFT) | $8,270 |
Bank EFT credit the same week, description includes the payer and, if the bank provides it, the same TRN | $8,270 |
EHR payment batch posted: insurance paid, write-offs, takeback applied, patient balances updated | matches |
The three-way match holds here: the ERA net of $8,270 equals the bank deposit of $8,270, which equals the EHR batch cleared to that same deposit.
The failure mode, if someone only books the bank, looks like this: QuickBooks shows $8,270 in income. The write-offs and the $150 takeback never hit the P&L. Patient balances in the EHR still look correct, so the front desk never notices anything wrong. Month-end bank reconciliation clears. The income statement does not.
Common breaks, and what to do
Symptom | Likely cause | Action |
|---|---|---|
ERA shows in the EHR, no bank deposit | A timing lag, the wrong bank account, or a payer delay | Wait a few business days, then call the payer with the TRN and claim numbers |
Bank deposit shows, no ERA | Missing enrollment, a clearinghouse delay, or a paper-only payer | Request the ERA or EOB; post from the EOB only when necessary and flag it for the ERA later |
Amounts differ by a fixed offset | A takeback, interest, or a provider-level adjustment on the ERA | Post the adjustment and match the net figure to the bank |
Multiple small deposits against one ERA | Split funding, or a mix of check and EFT | Document the split; never force it into a single bank line |
Trace numbers never appear | The bank isn't passing CCD+ addenda data | Ask the bank for the CORE minimum payment data on deposits |
How this ties to the general ledger
The EHR owns claim-level truth. QuickBooks owns cash and period income. Book summarized insurance deposits with clear references to the ERA or batch IDs involved, and keep patient names and full claim detail out of the GL entirely. Merchant card deposits are a separate stream from payer EFTs; mixing the two into one undifferentiated "deposits" account is exactly the kind of shortcut that makes next month's reconciliation harder than this month's.
How Numetix works with this process
We sit alongside whatever EHR a practice already uses. AI matches bank insurance lines to ERA and payment-batch totals using amounts, dates, and trace references when they're available. A CPA-overseen team owns exceptions, takebacks, and the monthly close, so QuickBooks and the EHR stay aligned.
A practical first step: send us two weeks of bank activity, a list of ERA or insurance payment batches for the same period, and a short note on which payers pay by EFT versus check. We'll show you the matched pairs and the open exceptions. Book 30 minutes with our team. More on how Numetix serves independent medical practices.
Frequently asked questions
Is matching the bank to the ERA enough? No. The EHR posting has to agree too. Otherwise cash is right while income or A/R is wrong, and nothing in the bank reconciliation will ever surface that.
What if the ERA and the EFT arrive days apart? That's normal. Track the gap as an in-transit item; don't post income from the ERA alone without a clear path to the cash, and don't leave a large unmatched EFT sitting unlabeled.
Should every claim line appear in QuickBooks? No. Summary deposits by payer or batch are enough for most practices. Claim-level detail stays in the EHR.
How do takebacks affect reconciliation? They reduce the net EFT relative to the gross amount paid on the claims. Post the takeback so the batch total still equals the bank deposit.
Is the bank's ACH trace number the same as the ERA's reassociation trace number? No, and this is where a lot of mismatches start. CAQH CORE's own Rule 370 distinguishes the two explicitly: the ACH Trace Number tracks the transaction through the bank network, while the X12 835 TRN Reassociation Trace Number inside the CCD+ Addenda Record is the number that actually ties the payment to its remittance.
What report should the bookkeeper ask for every week? A remittance or insurance payment report showing the ERA or check number or TRN, the payer, the payment amount, and the posted date, alongside the bank feed for the same dates.
Numetix is an AI-first accounting firm. AI runs the bookkeeping, tax, payroll, and reporting workflow. Industry experts handle the judgment, month-end close, review, and advisory. We serve founder-led service firms across law, consulting, IT, healthcare, creative, and nonprofit. Headquartered in California, serving clients nationwide.
Suggested Readings
Bookkeeping for PT and chiropractic practices on WebPT, ChiroTouch and Jane
Bookkeeping for therapy practices on SimplePractice, TherapyNotes and Jane
SimplePractice and QuickBooks
See what Numetix can do for you
Learn how the Numetix Portal streamlines communication, offers valuable insights, and saves you time so you can focus on growing your business.