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 is the best way to track intercompany transactions between healthcare entities in QuickBooks?
Set up Due To and Due From accounts in each entity's QuickBooks file to log every payment made on behalf of another entity. QuickBooks Online lacks built-in intercompany elimination, so you'll need manual journal entries and monthly reconciliation between entities.
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 answerDo I need separate QuickBooks files for each medical entity or can I use class tracking?
For healthcare groups with distinct legal entities like LLCs and professional corporations, separate QuickBooks Online files are generally the better choice. Class tracking in a single file can work for two or three entities but creates problems as you grow.
Read answerHow should a nephrology or dialysis practice handle bookkeeping for multiple clinic locations?
Each clinic location needs its own set of books with a standardized chart of accounts so you can produce location-level P&L reports. Shared costs like admin, billing staff, and EMR systems require documented allocation methods that hold up under audit.
Read answerHow do I set up bookkeeping for a medical practice with multiple LLCs and entities?
Each entity needs its own QuickBooks file with a consistent chart of accounts across all of them. Intercompany transactions like management fees, shared staff costs, and rent between entities must be tracked carefully and eliminated when you pull consolidated reports.
Read answer