You need two systems working together, not one system trying to do everything. Your practice management system handles claims submission, aging, and individual patient-level detail. QuickBooks Online handles the actual bookkeeping. The PMS is your source of truth for what you billed and what came back. QBO is your source of truth for the money.

In QuickBooks Online, create a customer for each insurance payer or payer class. Blue Cross, Aetna, UnitedHealthcare, Medicare, Medicaid, and so on. If you have dozens of smaller payers, you can group them into classes like “commercial” or “workers comp” to keep things manageable. The point is that when a deposit hits your bank account, you record it against the correct payer so QBO can tell you where your revenue actually comes from.

When insurance payments arrive, they rarely match what you billed. Record the payment amount, the contractual adjustment (the difference between billed and allowed amounts), and any denials. Each of these should have its own account in your chart of accounts. Contractual adjustments are expected and predictable. Denials are not, and they need to be tracked separately because a high denial rate from a specific payer is a problem you need to see clearly in your numbers.

Reconcile your PMS to QBO monthly. Pull your collections report from the PMS and compare it to what’s recorded in QuickBooks. They should match. When they don’t, find the discrepancy before moving on. This is where most practices fall behind because it takes discipline and someone who understands both systems. But skipping this step means your financial statements are unreliable.

The reason all of this matters is payer mix and effective reimbursement rates. If Blue Cross represents 40% of your claims but only 25% of your collections, that’s a problem worth knowing about. If Medicare reimburses at 62 cents on the dollar while a commercial payer reimburses at 88 cents, those numbers should drive decisions about which plans you accept and how you allocate resources. You can’t calculate any of this without tracking by payer.

This approach is conceptually similar to construction job costing in Phoenix where every dollar gets tracked to a specific project. In your practice, every dollar gets tracked to a specific payer. The level of detail is what turns your books from a tax compliance exercise into a management tool.

Patient copays, self-pay balances, and cash-pay patients should also be tracked as their own “payer” categories in QBO. These often get lumped together or lost in the mix, but they represent real revenue streams with their own collection patterns.

Don’t try to replicate your PMS inside QuickBooks. Some practice owners want claim-level detail in QBO and it creates a mess. QBO should have summary-level data by payer, reconciled monthly. Your PMS handles the granular claim-by-claim tracking. Keeping the two systems in their respective lanes makes both more useful.

If your books are currently a single lump of “insurance revenue” with no payer breakdown, the first step is restructuring your chart of accounts and setting up payer-level customers in QBO. This is exactly the kind of setup work that a bookkeeper familiar with medical and dental practices can handle efficiently. Getting it right from the start saves months of cleanup later.