How to reconcile dental deposits in QuickBooks
To reconcile dental deposits in QuickBooks, match every bank deposit to what explains it: each insurance EFT to its ERA by trace number, each check to its EOB, each card payout to the payments inside it. Confirm those were posted in your practice system, then book one entry per deposit, with fees on their own lines.
Book a demoBy the ScoutIQ AI teamPublished 6 min read
Key takeaways
- A bank deposit rarely equals one claim or one patient payment. Match it to what explains it first, then book it.
- Insurance EFTs match their ERA by trace number; checks match their EOB; card payouts break back into the payments inside them.
- Confirm every claim and payment on the deposit was posted in your PMS. Deposits that never got posted are money missing in plain sight.
- Book one entry per bank deposit, with card fees, virtual card fees and recoupments on their own lines, by location.
- Reconcile daily or weekly, not only at month end, and never spread an unidentified credit across patients.
Why dental deposits are hard to match
A payer does not send one deposit per claim. It sends one EFT for everything it paid in that run: many patients, sometimes more than one location under the same tax ID, minus any recoupments. The bank line shows a payer name, a trace number and one total.
Patient payments bundle the same way. Two days of cards from three terminals and the online page can arrive as one payout, after fees. So a deposit in QuickBooks rarely equals any single claim or payment in your practice system, and matching the two is the work.
Every kind of deposit, and what it matches to
| Deposit | What the bank shows | Match it to |
|---|---|---|
| Insurance EFT | Payer name, a trace number and one total, often for many patients | The ERA with the same trace number, then each claim posted in your PMS |
| Insurance check | The check amount, often deposited with other checks | The paper EOB that came with it, then each claim posted in your PMS |
| Virtual card payment | A processor payout, net of the card fee | Its EOB and the processor deposit; the fee is an expense |
| Patient card payout | One payout for days of payments from terminals and online, net of fees | Every patient payment inside it, each posted to the right patient |
| Patient cash and checks | One deposit total | The patient payments posted in your PMS that day |
Insurance EFTs match by trace number only when the payer sends both the EFT and the ERA; see EFT and ERA enrollment. For checks and paper EOBs, see posting paper EOBs and checks.
How to reconcile, step by step
Pull the bank lines every day
Start from the bank, not the practice system: every credit that landed, with its date, amount, payer name and trace or check number.
A QuickBooks bank feed shows the deposits but not the claims or patients inside them. That detail lives in the remittances and your practice management system.
Match each deposit to what explains it
Use the strongest proof first: the trace or check number on the bank line equal to the one on the remittance or payout.
Where there is no number, amount, date and payer that agree with only one bank line are a strong match. Anything looser, such as a payer alias or a small difference, is a proposal for a person to accept, not a match.
Confirm every claim and payment was posted
Check that each claim on the remittance and each payment in the payout is posted in your practice management system, to the right patient and location.
A deposit that reached the bank but was never posted leaves the patient’s balance and your A/R wrong. This is where most missing money hides.
Book one entry per deposit
Record each bank deposit once, at the amount the bank shows, with fees and recoupments on their own lines and revenue by location.
Book virtual card and card processing fees as an expense, not as a smaller payment, so collections stay true to what the payer and the patient paid.
Name every difference
A deposit with no remittance, or a remittance with no deposit, gets an owner and a date.
Money nobody can identify is held as an unidentified credit until someone names the sender. Never spread it across patients to make a number agree.
Booking it in QuickBooks
The books need one entry per bank deposit, so QuickBooks agrees with the bank line for line. Book the full amount the payer or patient paid, with card fees, virtual card fees and any interest on their own lines, and recoupments as their own negative line. For a group, book each deposit to its location, so revenue by location is right.
When the practice system postings, the bank deposits and the books all agree, that is three-way reconciliation. Before you close a period, check:
- Every bank credit this period is matched or listed as an open item with an owner.
- Every remittance is matched to a deposit, or its payment is confirmed still in transit.
- Every claim and patient payment on a matched deposit is posted in the practice system.
- Fees, virtual card fees and recoupments are booked on their own lines.
- Each location’s deposits are booked to that location.
- Whoever posted the payments did not approve their own bank match.
What it looks like at one practice
At Todaro Dental, one office on Open Dental running all three ScoutIQ modules, every deposit and payout was followed from the practice system to the bank to the general ledger, in its own records.
| Deposits | Matched automatically |
|---|---|
| Electronic insurance deposits | 178 of 185. The other 7, $4,358, had reached the bank but were never posted. |
| Card payouts | 49 of 49, $152,083 |
Full numbers and method: Todaro Dental.
How ScoutIQ handles it
ScoutIQ matches every EFT, check, virtual card and card payout to the ERA or EOB behind it and to the posting in your practice system, every day as deposits land. Each match shows its proof, and anything looser than a number or a single clear match waits for a person to accept it. Unidentified credits are held, never spread.
Deposits, card and virtual card fees and recoupments are booked to QuickBooks Online or QuickBooks Desktop, each to its own location. 99% of patient payments collected through ScoutIQ reconcile with no human touch. ScoutIQ works on 59 practice management systems, and most practices are live in 48 hours.
ScoutIQ product
Insurance Billing Automation
Sources
Insurance Billing Automation
ERAs and EOBs read; EFT, check and card payments reconciled.
See Insurance Billing Automation