Dental Practice Accounting, Accounts Receivable and DSO Reporting
Practice-management software tracks production, claims and patient balances. QuickBooks tracks the general ledger. Illuminous Accounting reconciles the systems so dental owners and DSO leaders can rely on accounts receivable, location results, cash flow and management reporting.
Quick answer
How do Open Dental and QuickBooks work together for dental accounting?
Open Dental or another practice-management system records production, patient and insurance balances, adjustments and collections. QuickBooks records the general ledger, expenses, payroll and financial statements. They do not become one reliable reporting system until deposits, receivables, adjustments and accounting balances are reconciled through a consistent monthly process. Illuminous provides that accounting and reporting layer. We do not sell dental accounting software.
Dental Accounting and Reporting That Reconciles
Practice-management to ledger reconciliation
Map production, adjustments, collections and deposits from Open Dental or another practice system to the general ledger and monthly financial statements.
Dental accounts receivable reporting
Separate insurance and patient aging, identify unapplied payments and credit balances, and make collection reporting traceable to the patient ledger.
Insurance, patient and merchant reconciliation
Reconcile insurance remittances, patient payments, card settlements, financing deposits, fees and write-offs to the correct accounting period.
Multi-location and centralized billing
Standardize location, provider and service-line mappings so centralized billing and DSO reporting use consistent definitions.
Cash flow and production-to-collection visibility
Compare production, adjustments, collections and cash deposits while forecasting payroll, rent, laboratory and debt obligations.
DSO consolidation and diligence support
Produce reconciled multi-location results and supporting schedules for management, lenders and potential buyers. See our CFO and transaction-readiness service.
Why Dental Payments Do Not Match the Bank Automatically
Production, contractual adjustments, insurance remittances, patient payments, financing deposits and merchant fees move through different systems. A documented reconciliation is needed before the patient ledger and accounting records can be treated as reliable.
Different payment and adjustment channels
Insurance remittances, patient cards, financing, refunds, write-offs and merchant fees can settle at different times and at net amounts.
Unapplied and suspense balances accumulate
Bulk deposits and net settlements can remain unallocated when the remittance detail, patient ledger and bank record are not matched together.
The reporting consequence: aged receivables, collection rates, revenue and cash can be misstated when unresolved items move from one month to the next.
A repeatable reconciliation process
We map the practice-management ledger, remittance reports, merchant settlements, bank deposits and general ledger. Exceptions are identified for review, and reconciled schedules become part of the monthly close.
How We Engage
- Review the practice-management, accounting, payroll and banking data flows
- Define the monthly accounts receivable, deposit and general-ledger reconciliations
- Standardize the chart of accounts and location reporting across the group
- Build cash-flow, production-to-collection and management reporting
- Prepare supporting schedules for lender, investor or buyer review when needed
We work with the systems dental groups already use, including Open Dental, Nextech, QuickBooks, ADP, and Gusto.
Dental Accounting FAQs
How do Open Dental and QuickBooks work together?
What should a dental accounts receivable report show?
Can you standardize several dental locations?
Do you sell dental accounting software?
What information supports lender or buyer review?
Run Your Practice on Real Numbers
A call covers your systems and where the profit and cash are really going. No commitment.
Related professional services
By Gurleen Kaur
Founder of Illuminous Accounting. Experience at Deloitte and Grant Thornton.