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.
Northern Virginia's Bookkeeping & Advisory Firm
First Step:
Tell Us About Your Business
Every engagement starts with a conversation. Tell us what's going on with your books and we'll give you our honest assessment.
More Questions
How do contractors handle change orders in their books?
Approved change orders increase the total contract value and should be updated in the WIP schedule immediately. Unapproved change orders are riskier and need to be booked as unbilled receivables with a reserve if collection is uncertain.
Read answerHow do dental and medical practices account for supplies and inventory?
Most small practices expense supplies when purchased under the cash method. Larger practices, especially dental offices with high-value materials like crowns and implants, may need perpetual inventory tracking to manage costs accurately.
Read answerWhat payroll setup does a medical or dental practice need?
Healthcare practices need payroll configured for multiple employee types with different pay structures. Owner compensation, provider bonuses, clinical hourly staff, and admin each require distinct setup for pay, benefits, and tax treatment.
Read answerWhat's the difference between a repair and a capital improvement on a rental property?
A repair restores something to working condition and is deducted in the current year. A capital improvement adds value, extends useful life, or adapts the property to a new use, and must be depreciated over 27.5 years for residential or 39 years for commercial property.
Read answerHow do I handle client trust account interest and IOLTA remittances?
IOLTA interest gets remitted to the Virginia Law Foundation by your bank. Non-IOLTA trust account interest belongs to the client and must be tracked individually, with 1099-INTs issued at year-end.
Read answerHow should a Virginia law firm set up its IOLTA trust account bookkeeping?
Virginia law firms must maintain a separate interest-bearing IOLTA trust account with individual sub-ledgers for each client matter. Monthly three-way reconciliation is required, and the Virginia State Bar actively audits for compliance.
Read answer

