Your practice management software and QuickBooks track different things. Dentrix, Eaglesoft, Open Dental, and similar systems track production, adjustments, and patient accounts receivable. QuickBooks tracks actual money moving through your bank account. Reconciliation means verifying that collections in your practice software match deposits in QuickBooks.

Start with the collection report from your practice management software. This report shows payments received during a period, broken down by patient payments and insurance payments. The total collections should match your bank deposits for that same period, with one adjustment for credit card processing fees.

Daily reconciliation is the most straightforward approach. Run your end-of-day collection report, then compare it to your deposit slip and credit card batch settlement. If you close out credit cards daily, the settlement amount after processing fees should tie back to the credit card portion of your collection report.

Insurance payments create the most confusion because the explanation of benefits shows multiple figures. The EOB includes what was billed, what was adjusted off, and what was actually paid. Your practice software records all three. QuickBooks only sees the check or electronic deposit. When reconciling, focus on the actual payment amount, not the production or contractual adjustment.

Credit card processing fees cause a consistent and predictable discrepancy. Your practice software shows $2,000 in credit card payments for the day. Your bank shows $1,940 after the 3% fee. You can either record processing fees as an expense in QuickBooks to make the numbers tie, or simply understand that deposits will always be lower than card collections by the fee percentage. Most dental practices prefer recording the fees explicitly so they can track what they’re paying in processing costs.

Timing differences become an issue at month-end. A payment entered in your practice software on the 31st might not hit the bank until the 2nd of the next month. Pick a consistent method for handling cutoffs. Either use the practice software date as the record date in QuickBooks, or use the bank settlement date. Mixing methods creates reconciliation headaches that compound over time.

When numbers don’t match, work backward from the bank deposit. Every deposit should correspond to a collection batch or report. If a deposit can’t be traced, look for payments that were collected but not posted in your practice software, or duplicate entries, or payments posted to wrong patient accounts.

How often you reconcile depends on practice volume. High-volume practices benefit from weekly review because discrepancies are easier to track down while the transactions are fresh. Smaller practices can handle monthly reconciliation without losing too much context.

The goal is not to make both systems report identical numbers. They track different information for different purposes. The goal is confirming that every dollar your practice software says you collected actually arrived in your bank account, and that QuickBooks accurately reflects your cash position. Working with Los Angeles QuickBooks bookkeepers who understand dental practice accounting can help establish a reconciliation process that catches discrepancies quickly and keeps your financial records reliable.