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
How 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 answerWhat does a fractional CFO do and when does a small business need one?
A fractional CFO provides part-time strategic financial leadership like cash flow forecasting, financial modeling, and growth planning. Most small businesses need one when revenue passes $500K to $1M, margins start shrinking, or they're making big financial decisions without solid data.
Read answerHow should I account for security deposits received and returned on rental properties?
Security deposits are a liability, not income. Record them to a liability account when received and reverse the entry when returned. If you retain any portion for damages, reclassify that amount to income and record the repair expense separately.
Read answerHow do I clean up a messy QuickBooks file that hasn't been maintained properly?
Start with bank reconciliation month by month, then fix uncategorized transactions and clean up your chart of accounts. The process is methodical and every step builds on the one before it.
Read answerShould my construction company use cash or accrual accounting for tax purposes?
Most construction companies under $29 million in average annual gross receipts can use the cash method, which defers taxes. But cash basis hides true job profitability, so many contractors benefit from accrual-style reporting internally even if they file taxes on a cash basis.
Read answerHow do I track and value in-kind donations for nonprofit accounting and tax receipts?
Record in-kind donations at fair market value on the date received. Not all donated services qualify for recording. For gifts over $250, provide a written acknowledgment describing the gift but don't state the value.
Read answer