Bookkeeping, payroll, and accounting services for small businesses across Orange County and Greater Los Angeles.

Call or Text: (714) 399-5126

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

How 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 answer

How does workers compensation insurance work for trucking companies in California?

California requires workers comp coverage for every W-2 employee with no exceptions. Trucking is classified as high-risk, so premiums are significantly higher than most industries. Misclassifying drivers as 1099 contractors to avoid this cost is one of the fastest ways to trigger an EDD audit.

Read answer

Do 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 answer

How do I handle sales tax for retail sales in California and what reports do I need?

California retailers must collect sales tax on most tangible goods and file returns with the CDTFA. Your rate depends on your store's location, and you'll need to track taxable sales, exempt sales, and resale certificates to stay compliant.

Read answer

How do I track purchase orders and vendor payments for a wholesale business?

Use QuickBooks Online to create purchase orders, receive inventory, and match vendor bills. Track PO status, vendor payment terms, and early payment discounts. Run A/P aging reports regularly because large orders can tie up cash for 60 to 90 days before you sell through.

Read answer

What bookkeeping records does a trucking company or owner-operator need to keep?

Trucking companies and owner-operators need to keep fuel receipts broken out by state for IFTA, maintenance logs, per diem documentation, toll receipts, load sheets with mileage, insurance records, and settlement statements from carriers. The IRS expects detailed documentation for at least three years.

Read answer

A family-owned bookkeeping and accounting firm based in Buena Park, serving small businesses across Orange County and Greater Los Angeles. Full-service bookkeeping, accounting, payroll, and advisory services led by Amrit Sarker, a Certified Public Bookkeeper and QuickBooks certified professional with 35+ years of experience in accounting and financial operations. Income tax preparation is provided through our official tax partner, Dharia Tax & Services, Inc. Offers services in English and Bengali.

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • QuickBooks Desktop Certification badge

© 2026 Sarker Accounting Services LLC