How do I reconcile my dental practice management software with QuickBooks?
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.
LA's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a clear price for the work.
More Questions
What is the best way to categorize expenses in QuickBooks?
Consistency matters more than perfection. Pick a category that makes sense for each type of expense and use it the same way every time. Stick with standard categories that map to tax return lines and avoid creating too many custom accounts.
Read answerWhat overhead benchmarks should my dental practice be tracking?
Track staff costs (25-30% of collections), facility (5-7%), supplies (5-8%), and lab fees (varies by service mix). Total overhead should land between 55-65% for a healthy practice, leaving room for owner compensation and profit.
Read answerHow do I calculate food cost percentage for my restaurant?
Divide your food costs by your food sales and multiply by 100. For overall restaurant food cost, you need to calculate cost of goods sold using beginning inventory, purchases, and ending inventory.
Read answerWhat financial documents do buyers want to see when purchasing a business?
Buyers typically request three years of profit and loss statements, tax returns, balance sheets, bank statements, and aging reports. They're verifying the seller's claims and looking for consistency, trends, and red flags.
Read answerWhat is the best way to manage cash flow for a medical office?
Medical offices face unique cash flow challenges due to insurance reimbursement delays. Managing this effectively requires attention to accounts receivable aging, patient collections at time of service, and maintaining adequate cash reserves.
Read answerWhat questions should I ask about a business's cash flow before buying?
Focus on cash flow sustainability, not just current numbers. Ask about seasonality patterns, customer concentration, receivables aging, deferred expenses, and how owner compensation has been structured.
Read answer