How should a medical or dental practice set up its bookkeeping in QuickBooks or Xero?

The chart of accounts is where most practices get this wrong. A generic QuickBooks or Xero setup treats all revenue as one line item, and that tells you almost nothing about how a healthcare practice actually makes money. You need income accounts broken out by payer type at a minimum. Create separate revenue accounts for each major insurance payer (Aetna, Cigna, Blue Cross, United, Medicare, Medicaid, etc.), patient copays and coinsurance, self-pay collections, and lab or ancillary fees. This lets you see which payers are actually paying, how quickly they pay, and where your revenue mix is shifting over time.

On the expense side, your chart of accounts needs to reflect the cost structure of running a clinical operation. Clinical staff payroll (doctors, hygienists, nurses, assistants) should be separated from administrative staff payroll. Malpractice insurance, medical supplies, lab costs, equipment maintenance, and continuing education all deserve their own accounts rather than being lumped into generic categories. When you can see clinical labor as a percentage of revenue and track supply costs per provider, you have numbers that actually help you manage the practice.

The hardest part of healthcare bookkeeping is reconciling bank deposits. In most businesses, today’s sales roughly match today’s deposits. In a medical or dental practice, that’s never the case. You bill an insurance company today and get paid in 30, 60, or 90 days. The deposit that hits your bank on a Tuesday might represent claims from three different weeks across a dozen patients. If you try to match bank deposits to daily production, you’ll spend hours chasing discrepancies that aren’t really discrepancies at all.

The solution is tracking production and collections as two separate processes. Production is what you billed. Collections is what you received. Your practice management software (Dentrix, Kareo, Open Dental, Epic, or whatever you use) tracks production and aging of claims. Your accounting software tracks collections as they hit the bank. Monthly, you reconcile the two by comparing total production to total collections and monitoring your accounts receivable aging to make sure nothing is falling through the cracks.

Integration between your practice management system and QuickBooks or Xero is critical for making this work without doubling your administrative burden. Some systems offer direct integrations or export features that push revenue summaries into your accounting software. Others require a manual journal entry process. Either way, you want a consistent method for getting the data from your clinical system into your books without re-entering every transaction by hand.

Set up your payroll with proper categorization from the start. Clinical staff, front desk, and management should be tracked separately so you can calculate meaningful ratios like revenue per clinical hour or support staff cost as a percentage of collections. If you’re running Northern Virginia small business bookkeeping services through a single payroll expense account, you lose all of that visibility.

One more thing that trips up practice owners is handling insurance adjustments and write-offs. When you bill $500 for a procedure and the contracted rate with that payer is $350, the $150 difference is a contractual adjustment, not bad debt. Your bookkeeping needs a clear process for recording these write-offs so your receivables stay accurate and your revenue reflects what you actually expect to collect.

Getting this setup right from the beginning saves significant time and frustration down the road. A practice running on a poorly configured chart of accounts for two or three years ends up with financial statements that can’t answer basic questions about profitability by provider, payer performance, or where the money is actually going. Cleaning that up later is always more expensive than building it correctly from the start.