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 do I handle security deposits in my rental property bookkeeping?

Security deposits are not income when you receive them. Record them as a liability on your balance sheet and only recognize income if you retain part or all of the deposit for damages or unpaid rent when the tenant moves out.

Read answer

How often should a restaurant owner review their books and what reports matter most?

Weekly at minimum for food cost, labor cost, and daily sales trends. Monthly for the full P&L, prime cost analysis, A/P aging, and cash flow. Thin margins mean waiting too long to review your numbers can cost thousands before you notice.

Read answer

How do I separate personal and business expenses when a doctor owns the practice building?

The standard approach is to hold the building in a separate LLC from the medical practice. The practice pays fair market rent to the property LLC, and both entities maintain completely separate books.

Read answer

What are the bookkeeping requirements for Amazon FBA sellers in California?

Amazon FBA sellers in California need to categorize FBA fees correctly, track inventory across warehouses, reconcile settlement reports to bank deposits, and understand multi-state nexus created by Amazon storing your products in other states.

Read answer

What financial statements should my bookkeeper provide me every month?

At minimum, you should receive a Profit & Loss statement, Balance Sheet, Cash Flow Statement, A/R and A/P Aging reports, and bank reconciliation confirmation. Depending on your business, you may also need budget comparisons, gross margin breakdowns, or custom dashboards.

Read answer

What 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 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