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 much cash reserve should an HVAC contractor keep for the slow season?
Plan for three to six months of fixed overhead in a dedicated savings account. HVAC businesses have predictable seasonal dips during the shoulder months between heating and cooling demand, so building that reserve during peak season is the move.
Read answerWhat bookkeeping records does a licensed contractor need to keep for state board compliance?
Arizona's Registrar of Contractors requires financial records that demonstrate solvency. That means keeping job contracts, invoices, receipts, payroll records, insurance certificates, and license renewal documentation with a minimum three-year retention period.
Read answerCan I deduct hand tools and power tools as a self-employed electrician or do I depreciate them?
Most hand tools and power tools under $2,500 can be deducted immediately using the IRS de minimis safe harbor election. Tools over $2,500 can be fully deducted through Section 179 or depreciated over 5 to 7 years. Either way, keep every receipt because tool deductions are a common audit flag for trades.
Read answerHow do I account for tip income and tip reporting requirements at my salon?
Your obligations depend on whether your stylists are W-2 employees or booth renters. Employees must report all tips to you, and tips over $20 per month are subject to FICA. Booth renters handle their own tip reporting on Schedule C.
Read answerHow do I account for security deposits and tenant improvements in property management books?
Security deposits are liabilities on your balance sheet, not income. Tenant improvement allowances get capitalized as leasehold improvements and amortized over the shorter of the useful life or remaining lease term.
Read answerHow do I track retainage in QuickBooks for construction projects?
QuickBooks Online doesn't have a built-in retainage feature. You need to create a Retainage Receivable account and a Retainage Payable account, then use line items and journal entries at each billing cycle to track what's being withheld.
Read answer