How do I reconcile insurance reimbursements with patient charges in QuickBooks?
Insurance companies almost never pay the full billed amount. Between contractual adjustments, denials, co-pays, deductibles, and coinsurance, there is always a gap between what you charge and what you collect. If you only record deposits into QuickBooks, you lose all visibility into where that gap comes from and whether it is a problem.
Start by recording every patient service at the full billed amount. Create an invoice in QuickBooks for the gross charge when the service is performed. This establishes an accounts receivable entry at the full rate, which becomes your baseline for tracking everything that happens next. Don’t record at the expected payment amount. You need the gross figure as your starting point so the math works downstream.
When the Explanation of Benefits arrives from the insurance company, you will see the allowed amount, the insurance payment, and the patient responsibility portion. In QuickBooks, apply a partial payment to the original invoice for what insurance actually paid. Then record the contractual adjustment as a separate line item, typically using a credit memo or write-off against a dedicated adjustment account. The contractual adjustment is the difference between your billed amount and the insurer’s allowed amount. Whatever remains after insurance payment and the adjustment becomes the patient’s responsibility.
Set up distinct accounts in your chart of accounts for different adjustment types. You want separate accounts for contractual adjustments, claim denials, and bad debt write-offs. Contractual adjustments are expected and normal. Denials represent lost revenue you might recover by reworking the claim. Bad debt is money patients owe but never pay. Lumping these together makes it impossible to tell whether you have a payer contract problem, a billing accuracy problem, or a patient collections problem.
Keep insurance receivables and patient receivables visible as separate categories. The strategies for collecting from each are completely different, and the aging patterns tell you different things. Insurance AR aging beyond 60 days usually means claims need follow-up or resubmission. Patient AR aging beyond 90 days often becomes a write-off candidate.
The metric that ties all of this together is your net collection rate. Calculate it by dividing total collections by gross charges minus contractual adjustments. A healthy medical or dental practice typically runs at 95% or higher. If yours consistently falls below 90%, money is leaking through unworked denials, uncollected patient balances, or billing errors that nobody is catching.
QuickBooks is not a practice management system and it will not replace your billing software for claims submission and tracking. But it is where your financial picture lives, and if insurance reconciliation is sloppy in QuickBooks, your profit and loss statement is unreliable. Proper setup matters. Having your chart of accounts structured for healthcare from the beginning saves you from a painful cleanup later. Our Orange County small business bookkeeping services include configuring QuickBooks specifically for practices that deal with insurance reimbursements so that your reports actually reflect how your practice is performing.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
What chart of accounts should a dental or medical practice use in QuickBooks?
Medical and dental practices need a chart of accounts with revenue split by provider or service line, insurance versus self-pay income, and expense categories for supplies, malpractice insurance, equipment leases, and EHR subscriptions. The standard QuickBooks template doesn't include these.
Read answerHow should a restaurant categorize expenses in QuickBooks?
The default QuickBooks chart of accounts doesn't work for restaurants. You need expense categories that separate food costs, beverage costs, labor, occupancy, and supplies so you can track prime cost and see where your money actually goes.
Read answerHow should a salon owner categorize tip income and tip payouts in bookkeeping?
Credit card tips flow through your merchant processor as part of the full deposit. Record the tip portion as a liability you owe stylists, not as your revenue. When you pay tips out, run them through payroll for proper tax withholding.
Read answerHow do I track property management fees and contractor payments for rental properties?
Track management fees as an expense allocated to each property, and record every contractor payment with enough detail to file 1099-NECs at year end. Keeping expenses separated by property is the only way to know which ones are actually making money.
Read answerWhat is the best way to do inventory management and bookkeeping for a convenience store?
Track inventory by category rather than individual items, run weekly physical counts on high-value products, and let your POS data drive purchasing decisions. Gross margin by category tells you what's actually making money.
Read answerWhat bookkeeping challenges are unique to medical practices compared to other small businesses?
Insurance reimbursement lag, the gap between charges and collections, and the cash vs. accrual accounting decision create bookkeeping complexity that most small businesses never deal with. Medical practices also face provider compensation tracking, regulatory compliance costs, and multi-entity structures.
Read answer