How to Reconcile Insurance Payments in a Dental Practice: A Daily and Weekly Workflow

Insurance payment reconciliation is the process of matching three sources of truth: the bank deposit (what money actually arrived), the remittance (what the payer says it paid—the ERA or EOB), and the PMS ledger (what your practice expected to receive). When all three agree, your books are clean. When they don't, you have a discrepancy that is either a payer error, a posting error, or an underpayment—and every one of those is money leaving your practice if left unaddressed.

The direct answer to "how do I reconcile insurance payments?" is: post every remittance to the correct claim the day it arrives, match every bank deposit to the posted payments using the trace number, and investigate every unmatched item within the week. This guide gives you a concrete daily and weekly workflow, a checklist you can print, and the most common discrepancies you will encounter.

TL;DR

• Reconciliation matches three sources: the bank deposit (EFT/check), the remittance (ERA/EOB), and the PMS ledger—and all three must agree.
• Daily work is posting and matching: post ERAs to claims, match deposits to posted payments, and flag anything that doesn't line up.
• Weekly work is closing the loop: reconcile the bank statement, investigate every unmatched item, and review the exception queue.
• The TRN trace number is your best tool: it links an EFT deposit to its corresponding ERA, which is how you know what a deposit actually covers.

Why Reconciliation Matters

Skipping reconciliation is how practices lose money without noticing. A payer underpays a claim by $50; the payment posts, the deposit matches, and nobody compares the allowed amount against the contract. Multiply that by hundreds of claims a year and you have a five-figure leak that no one can point to.

Reconciliation is also the safety net for human error. A billing coordinator who posts a $450 payment to the wrong patient's ledger creates a mess that only surfaces when the right patient's statement goes out. A weekly reconciliation catches that before it becomes a patient dispute.

Finally, reconciliation is the source of your practice's financial truth. Days in accounts receivable, collection ratios, and production reports are only as accurate as the payment data behind them. If payments are posted late or to the wrong claims, every downstream metric is wrong.

The Three Sources of Truth

1. The Bank Deposit

The money that actually arrived—an EFT deposit, a paper check, or a lockbox payment. The bank statement tells you the amount and the date, but not which claims it covers. That is the job of the remittance.

2. The Remittance (ERA or EOB)

The payer's explanation of what it paid and why. The electronic version is the ERA (X12 835); the paper version is the EOB. The remittance tells you which claim numbers were paid, the allowed amounts, the adjustments, and the patient responsibility. If you receive an EFT, the ERA carries a TRN trace number that matches the deposit.

3. The PMS Ledger

Your practice management system's record of what was expected: the open claim, the expected payment based on your fee schedule and the patient's benefits, and the patient's balance. The ledger is where posted payments land.

Reconciliation is the act of making these three agree. For a deeper look at how the ERA, EOB, and EFT differ and connect, see our guide on dental ERA vs. EOB vs. EFT.

The Daily Workflow

Reconciliation is a daily habit, not a monthly event. Here is the daily rhythm:

Step 1: Post Every Remittance the Day It Arrives

Whether the ERA arrives in your clearinghouse mailbox or the EOB lands on your desk, post it the same day. With an ERA, this is automatic: the 835 imports and auto-posts to the matching claims. With paper EOBs, it is manual entry—slower and more error-prone, which is why most practices push for ERA enrollment.

Step 2: Match Deposits to Posted Payments

Pull the day's bank deposits and match each one to the posted payments. The TRN trace number on the ERA is the key: it matches the EFT deposit, so you know exactly which claims a deposit covers. If a deposit has no matching ERA, flag it. If an ERA has no matching deposit, flag it.

Step 3: Flag Exceptions Immediately

Anything that does not reconcile goes into an exception queue the same day:

• Deposit with no remittance
• Remittance with no deposit
• Allowed amount that differs from your contracted fee schedule
• Payment posted to the wrong claim
• Denial lines that need action

The goal is to keep the exception queue small and current. A queue that grows for weeks becomes an unsolvable mystery pile.

Step 4: Post Patient Responsibility

The patient responsibility from each remittance should flow to the patient's ledger the same day, so statements and collections stay current. This is also where balance collection starts—the sooner the patient balance is accurate, the sooner it can be collected.

The Weekly Workflow

Once a week, close the loop on everything that happened during the week:

Step 1: Reconcile the Bank Statement

Match every insurance deposit on the bank statement to a posted payment. Any deposit that cannot be matched to a remittance is a red flag—it could be an EFT whose ERA never arrived, or a payment posted to the wrong account.

Step 2: Work the Exception Queue to Zero

Every item in the exception queue gets resolved or assigned:

• Missing ERA: contact the payer or clearinghouse to request the remittance.
• Missing deposit: the payer says it paid but the money hasn't arrived—check the EFT trace and follow up.
• Underpayment: compare the allowed amount against your contract and file a dispute or request a corrected remittance.
• Wrong posting: reverse and repost to the correct claim.

Step 3: Review Denials and Adjustments

Pull the week's denial lines and large adjustments. Categorize them by payer and reason code. This weekly review is the raw material for reducing dental claim denials—you cannot fix a denial pattern you never look at.

Step 4: Verify the Ledger Totals

Run a report that compares total posted insurance payments against total expected payments for the week. A meaningful gap means something is sitting in the exception queue that should have been resolved.

The Reconciliation Checklist

Print this and keep it at the billing desk:

Daily

• [ ] Post all ERAs/EOBs received today to the correct claims
• [ ] Match today's bank deposits to posted payments (use TRN trace numbers)
• [ ] Flag deposits with no remittance and remittances with no deposit
• [ ] Compare allowed amounts against the contracted fee schedule
• [ ] Post patient responsibility to patient ledgers
• [ ] Route denial lines to the denial queue

Weekly

• [ ] Reconcile the full bank statement against posted payments
• [ ] Work the exception queue to zero (or assign every item)
• [ ] Review denials and adjustments by payer and reason code
• [ ] Verify weekly totals: posted payments vs. expected payments
• [ ] Follow up on any EFT without an ERA and any ERA without an EFT

Common Discrepancies and How to Resolve Them

EFT Without an ERA

The money arrived, but there is no remittance explaining it. Request the ERA from the payer or clearinghouse. Until it arrives, the deposit is unallocated cash—do not guess which claims it covers.

ERA Without an EFT

The payer says it paid, but the money hasn't arrived. Check the EFT trace number and the payment date. If the deposit is genuinely missing, contact the payer's provider services line.

Underpayment

The allowed amount on the remittance is lower than your contracted fee schedule. This is a payer error or an outdated fee table. Gather your contract documentation and request a corrected remittance. For a full playbook, see our guide on detecting dental insurance underpayments.

Bundled Payments

One EFT covering multiple claims, or one ERA covering a batch. Match each claim line to its portion of the deposit using the claim numbers and trace numbers. Do not post the whole deposit to one claim.

Payment Posted to the Wrong Claim

A posting error that surfaces when the correct claim still shows unpaid. Reverse the posting and repost to the right claim. This is why the weekly ledger verification matters.

How Automation Changes Reconciliation

Manual reconciliation is a full-time job at any practice with real volume. Automation changes the economics: an ERA-based workflow auto-posts every remittance, matches deposits using trace numbers, compares allowed amounts against your fee schedule on every line, and routes only the exceptions to a human. That is the difference between a billing coordinator who spends the week typing numbers and one who spends the week resolving the handful of cases that actually need judgment.

An AI employee for dental RCM like Curo is well suited to this work—posting remittances, reconciling ledgers, and flagging discrepancies continuously rather than in a weekly batch. And the upstream data matters too: if eligibility was verified accurately before treatment, the expected payment in the ledger is trustworthy, which makes reconciliation far easier. For practices that want to check coverage before the patient sits in the chair, our free dental insurance verification tool lets providers and clinics verify a patient's coverage manually—no login, no card upload, with capped free checks, and patient/member details used only for the check and not saved.

Frequently Asked Questions

Q: How often should I reconcile insurance payments? A: Daily for posting and matching, weekly for closing the loop. Posting remittances the day they arrive and matching deposits daily keeps the exception queue small. A weekly bank-statement reconciliation catches anything that slipped through.

Q: What is the TRN trace number? A: The TRN segment in an ERA (835) is a trace number that matches the electronic funds transfer (EFT) deposit. It is how you know which claims a bank deposit covers, and it is the key to matching money to remittances.

Q: What should I do when a deposit has no matching ERA? A: Flag it immediately and request the remittance from the payer or clearinghouse. Do not guess which claims the deposit covers—unallocated cash that gets posted to the wrong claim creates a mess that takes hours to untangle.

Q: How do I know if a payment is an underpayment? A: Compare the allowed amount on the remittance against your contracted fee schedule for that payer and CDT code. If the allowed amount is lower than your contract, the claim was underpaid regardless of what the paid column shows.

Q: Can software do reconciliation for me? A: Yes. ERA-based software auto-posts remittances, matches deposits using trace numbers, and flags discrepancies against your fee schedule. Your team then works only the exceptions instead of typing every number.

Conclusion

Insurance payment reconciliation is the discipline that turns payer payments into clean, trustworthy revenue. Match the bank deposit, the remittance, and the ledger every day; close the loop every week; and investigate every exception instead of letting it age. The practices that do this consistently catch underpayments, prevent posting errors, and keep their accounts receivable accurate—and they do it with a fraction of the manual effort by letting the ERA do the heavy lifting.

References and further reading

• CMS, "Health Care Payment and Remittance Advice (835) and Electronic Funds Transfer (EFT)": https://www.cms.gov/about-cms/what-we-do/administrative-simplification/transactions/health-care-payment-remittance-advice-electronic-funds-transfer
• CAQH CORE, "Operating Rules": https://www.caqh.org/core/operating-rules
• CMS, "Adopted Standards and Operating Rules" (HIPAA administrative simplification): https://www.cms.gov/priorities/key-initiatives/burden-reduction/administrative-simplification/hipaa/adopted-standards-operating-rules