How do I set up QuickBooks for a medical practice with multiple revenue streams?
The biggest mistake medical practices make in QuickBooks is dumping all revenue into a single income account. When insurance reimbursements, patient self-pay, capitation payments, and ancillary services all land in the same bucket, you have no visibility into which revenue streams are growing, shrinking, or underperforming. Setting it up correctly from the start saves you from a painful cleanup later.
Start by creating classes in QuickBooks Online for each major revenue stream. A typical setup looks like this: Insurance Reimbursements, Patient Self-Pay, Capitation Payments, and Ancillary Services. Ancillary covers things like lab work, imaging, retail products, or any other services outside your core clinical work. Classes let you run profit and loss reports filtered by revenue type so you can see how each stream performs independently.
Under your income accounts, build out sub-accounts for each payer category. For insurance reimbursements, create sub-accounts for your major payers like Aetna, Blue Cross, UnitedHealthcare, Cigna, Medicare, and AHCCCS (Arizona’s Medicaid program). You don’t need a sub-account for every single payer, but your top five to ten carriers should each have their own line. Group smaller payers into an “Other Insurance” sub-account. For patient self-pay, separate copays, deductibles, and direct-pay patients. For capitation, break it out by the plan paying you.
This structure gives you reporting that actually means something. You can see that Medicare reimbursements dropped 8% this quarter or that ancillary product sales are growing faster than clinical revenue. Without that detail, you’re flying blind.
Your practice management system is your source of truth for charges, payments, and adjustments. QuickBooks is your source of truth for actual bank deposits and expenses. These two systems need to agree. Reconcile them monthly by comparing total deposits in QBO against total payments posted in your PMS. They should match within a small tolerance for timing differences. When they don’t match, dig in immediately. The gap usually comes from unposted payments, incorrect write-offs, or deposits that got miscategorized in QuickBooks.
On the expense side, set up accounts that reflect how a medical or dental practice actually spends money. Clinical supplies, lab fees, equipment leases, malpractice insurance, and staff wages should all have their own accounts. Don’t lump clinical supplies in with office supplies. They behave differently and you need to track them separately.
If you have multiple providers or locations, use locations or additional classes to track revenue and expenses by provider or office. This tells you which provider is generating the most revenue relative to their costs and which location is most profitable.
One more thing that gets overlooked. Contractual adjustments (the difference between what you bill and what insurance actually pays) should be tracked as a contra-revenue account, not buried in expenses. This keeps your gross charges visible and shows you the true discount rate by payer. That information matters when you’re deciding whether to stay in-network with a particular carrier.
The setup takes some thought up front but it pays off every month when you can actually read your financials and make decisions from them. If your books are already a mess or you’re not sure how to structure this correctly, getting help from someone who understands both QuickBooks and how practices operate is worth the investment. We handle construction job costing in Phoenix and medical practice bookkeeping with equal attention to the specific reporting each industry needs.
Your Valley of the Sun Bookkeeper
The Next Step:
A Quick Conversation
Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.
More Questions
Should I capitalize or expense tools and small equipment purchased for construction jobs?
Tools and equipment under $2,500 per invoice can be expensed immediately if you have a written accounting policy. Items over that threshold should be capitalized and depreciated, though Section 179 often lets you deduct the full cost in the year of purchase.
Read answerHow does Arizona tax construction contractors differently under TPT?
Arizona taxes prime contractors on 65% of the total contract price under the prime contracting TPT classification. Subcontractors, spec builders, and owner-builders each follow different rules. Getting the classification wrong is one of the most common filing mistakes.
Read answerHow do I track and account for medical equipment financing and lease payments?
The accounting depends on whether you have an equipment loan, capital lease, or operating lease. Recording the full monthly payment as an expense is the most common mistake. Each arrangement requires different treatment on your balance sheet and income statement.
Read answerWhat reports should I review monthly as a small business owner?
Five reports give you the clearest picture each month: Profit & Loss, Balance Sheet, Cash Flow Statement, A/R Aging, and A/P Aging. Reviewing trends across months matters more than looking at any single month in isolation.
Read answerHow do I track maintenance requests and repair costs by property and unit?
In QuickBooks Online, use sub-customers for each property and classes for individual units. This lets you run reports showing exactly what you've spent on maintenance and repairs at every level of your portfolio.
Read answerWhat is the difference between bookkeeping, accounting, and controller services?
Bookkeeping records your daily transactions and keeps the books accurate. Accounting interprets those numbers for tax planning and financial statements. Controller services provide financial oversight and strategic reporting. Most small businesses start with bookkeeping and add layers as they grow.
Read answer