Dental Payment Reconciliation: EFT, ERA, and Bank Deposits

Dental payment reconciliation checks whether money received agrees with the payer's payment explanation and the amounts entered in the practice management system. A payment can reach the bank without being posted, or be posted before the bank receives it. Reconciliation identifies those differences and leaves a clear trail for the office manager and bookkeeper.

This guide focuses on the batch-level close: matching deposits to remittances, tying remittances to ledger entries, and carrying unresolved items into the next review. The examples and suggested review cadence are operational templates for U.S. dental practices; adapt them to your payment channels and office policies.

Payment posting and reconciliation answer different questions. Posting records how a claim was processed. Reconciliation verifies that the payment batch is complete and accounted for. A matching batch total also needs a claim-level check, because a payment placed on the wrong account can still produce the correct grand total.

The bank record confirms the deposit amount and settlement date. The explanation of benefits, or EOB, or electronic remittance advice, or ERA, explains the payer's claim processing. The ledger report shows what your team actually recorded. Keep references linking all three records so another reviewer can reproduce the match.

CMS explains that electronic funds transfer, or EFT, moves the payment, while an ERA communicates payment and adjustment information. For the adopted health care EFT and ERA standards, a matching TRN segment supports reassociation: connecting the payment with its remittance. The CMS reference below explains this relationship.

The ADA's EOB guidance explains the importance of remittance details for checking benefits and patient responsibility. Use those details when reviewing individual ledger entries; the bank deposit alone cannot explain how a claim was adjudicated.

Choose a consistent daily cutoff and record it on the reconciliation worksheet. Export settled bank activity, available remittances, and the corresponding ledger payment reports. Include the prior day's unresolved items so a late-arriving deposit or ERA is checked against existing work before anyone creates a new entry.

Keep issue date, settlement date, and posting date in separate fields. A payer may issue a payment on Friday, the bank may settle it on Monday, and the team may post it on Tuesday. Comparing all three systems using only one calendar date can make a valid payment appear missing.

Separate insurance EFTs, paper checks, patient card settlements, and other receipts before matching. A transfer between practice bank accounts should not be treated as a new patient or insurance collection. Use office-provided reports or appropriately limited access for the records needed by the reviewer.

Locate the payment reference on the remittance and compare it with the bank's available EFT detail. Use payer identity, receiving practice or location, amount, and dates as supporting checks. Two deposits for the same dollar amount are not enough to establish a match.

If the bank screen shows only a shortened description, ask the bank how to retrieve the health care EFT addenda or reassociation information. Do not assume every bank transaction ID is the payer's remittance reference. Record the identifier used and retain the evidence supporting the connection.

For a deposit covering several claims, identify the complete remittance batch. For a paper check, use the check reference and deposit documentation; one bank deposit may contain several checks. List the components rather than forcing a one-deposit-to-one-claim relationship.

Compare the remittance's claim payment detail with the ledger entries linked to that batch. Confirm that each payment reached the correct patient, claim, and location, and check whether the remittance contains reversals or adjustments affecting the total. Review both manual entries and imported entries before approving the batch.

A common duplicate occurs when an EOB is posted manually and its ERA arrives later. Search existing payment references before importing or entering another payment. If a duplicate exists, use the practice-approved correction process with an audit trail rather than hiding the difference with a miscellaneous adjustment.

A zero-payment remittance can still contain information that needs ledger or claim follow-up, but it should not create an expected cash deposit merely because an ERA was received. Identify the payment amount before adding the item to the bank-matching queue.

Suppose a fictional payer deposits $2,460. Its remittance lists four claim payments: $640, $820, $450, and $550, with no payment-level adjustment. Those amounts total $2,460, so the remittance agrees with the bank. The linked ledger batch totals only $2,010.

The unexplained difference is $450. Search the ledger for that claim and payment reference before posting anything. The payment may be missing, assigned to a different batch, or recorded under the wrong payment type. The difference suggests where to look; it does not prove that a new payment entry is needed.

If the $450 payment was omitted, enter it under the approved posting procedure and rerun the batch report. If it already exists elsewhere, correct the batch association or reporting issue through the office workflow. The completed record should explain why the original totals differed and identify the reviewed correction.

Some settlement channels deposit a net amount after a documented fee. For example, a fictional processor report might show a $1,000 payment, a $25 processing fee, and a $975 deposit. The reconciliation bridge is $1,000 minus $25 equals $975. This is an illustration, not a standard fee or a statement that all EFT payments have fees.

Record the payment and explain the fee using the processor's report and the bookkeeper's approved mapping. A processing expense does not establish that the patient owes an extra $25. Keep the deposit explanation separate from decisions about patient responsibility.

A payer offset needs its own evidence. If a remittance shows $1,200 of current claim payments and a documented $200 recovery, the net payment may be $1,000. Link the recovery to the payer notice and affected historical transaction. Escalate unclear offsets instead of reducing an unrelated current claim to make the batch balance.

These explanations support the cash match. Whether a payer paid the correct contractual amount or whether a recovery should be disputed requires a separate review, using the linked underpayment and recoupment guides.

An unmatched item needs a specific next action. Separate money received without a remittance from remittances without confirmed deposits and from ledger mismatches. Combining them under a single 'payment problem' status makes follow-up harder to assign.

Set follow-up dates using the payer or processor's documented timing and your office's review policy. A daily review is a useful operating cadence, but it is not a universal payment deadline. Keep an item open until the evidence arrives or an authorized resolution is documented.

Use one row per payment or clearly defined settlement batch. Store sensitive supporting records in the practice's approved system and use internal references in the worksheet. A reviewer should be able to find the evidence without copying full banking information into a shared task list.

At month-end, give the bookkeeper the reconciled batches plus a separate schedule of unresolved and timing items. For example, a payment posted on September 30 but settled on October 2 should appear on the cutoff schedule with both dates and its reference. Preserve the actual events instead of changing dates simply to make monthly reports agree.

Also identify deposits received but not yet allocated, checks awaiting deposit, outstanding remittances, reversals, and documented fees. The bookkeeper determines the appropriate accounting treatment. The billing team's contribution is a complete link between the cash evidence and the practice ledger.

Carry each unresolved item into the next period using the same reference. When it clears, update its existing record and include the resolution evidence. This avoids counting a carried-forward payment as new cash when the missing document finally arrives.

Review both the number and dollar value of unmatched items. A single large deposit can matter more than many small exceptions, while a recurring low-dollar difference may reveal a faulty report filter or repeated import issue. Compare trends against your own baseline before setting targets.

DentaVyro supports payment posting, deposit-matching notes, exception tracking, and reporting within a practice-approved dental RCM workflow. U.S. dental offices can use this process to give the posting team, office manager, and bookkeeper a shared record of what has cleared and what still needs attention.

Need help connecting this work to the full dental revenue cycle? See DentaVyro's Dental RCM Services for U.S. practices in the related resources below. The practice retains approval over ledger corrections, refunds, bank access, and accounting decisions.