How do I track patient payments and insurance claims together?
Medical practices have a billing cycle that differs from most small businesses. A patient receives care, insurance gets billed, insurance pays part of the claim, and the patient owes the remainder. The patient portion might be a copay collected at the visit, a deductible billed later, or coinsurance calculated after the claim processes. Tracking all of this requires understanding which system handles what.
Your practice management software handles the operational detail. Whether you use Kareo, AdvancedMD, athenahealth, or another platform, this is where claims get submitted, ERAs get processed, and patient statements get generated. The billing system knows which claim is pending with which payer, what insurance paid on each date of service, and what the patient still owes. Don’t try to replicate this detail in your accounting software.
QuickBooks or your accounting system holds the summary. Total revenue, total adjustments, total accounts receivable. When you record a deposit, you’re matching the bank activity to revenue categories, not tracking individual patient balances. Most practices sync daily or weekly deposits rather than individual payments.
Revenue should be recorded when you provide the service, not when you receive payment. This is accrual accounting and it’s the right approach for medical practices. When a patient visits, you record the expected revenue. When insurance pays less than billed, the difference becomes a contractual adjustment. When a patient balance becomes uncollectible, that’s a write-off.
Set up your chart of accounts to reflect how revenue actually flows. You need income accounts for services, separate accounts for contractual adjustments, and clear categories for patient write-offs and refunds. Some practices also separate revenue by service line or provider if they want that visibility in financial reports.
For deposits, insurance payments and patient payments should be easily identifiable. Insurance EFTs come with ERA files that show exactly which claims are being paid. Patient payments through credit card processors or payment portals arrive separately. Match these to the deposit entries in your books and categorize them correctly.
The monthly reconciliation is where everything comes together. Your accounts receivable in the accounting software should match the total aging from your practice management system. If they don’t tie out, something got recorded twice or skipped entirely. Either payments aren’t reducing receivables properly or charges aren’t flowing from the billing system. Catching this monthly keeps small discrepancies from becoming big problems.
Working with a bookkeeper familiar with LA County small businesses who understands medical billing workflows makes this easier. The mechanics aren’t complicated once you know which system owns which piece of information. Keep claim-level detail in your practice software and summary financials in your accounting system, and the two will work together instead of creating confusion.
LA's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a clear price for the work.
More Questions
What documents do I need to provide for bookkeeping catch-up?
Bank and credit card statements are the most important documents for catch-up bookkeeping. Beyond that, gather invoices, receipts, loan documents, and payroll records if you have them. Most bookkeepers can work with incomplete records as long as the bank statements are complete.
Read answerWhat is the best accounting software for dental offices?
QuickBooks Online is the standard choice for most dental offices. It handles everything a practice needs, integrates with common dental practice management systems, and your accountant or bookkeeper almost certainly knows how to work with it.
Read answerWhat is the difference between employees and independent contractors?
The core difference is control. Employees work under your direction while contractors control how they complete the work. California's AB5 law makes the distinction stricter than federal standards, and getting it wrong can result in back taxes, penalties, and lawsuits.
Read answerHow do short-term rental owners handle bookkeeping for Airbnb income?
Record each Airbnb payout with gross booking income and platform fees tracked separately. Keep expenses organized by property and reconcile monthly against Airbnb's transaction reports.
Read answerHow do I track 1099 income as an independent real estate agent?
Record each commission payment when you receive it, not when the deal closes. Use a separate business bank account, track gross versus net amounts, and match your records to your 1099 at year end.
Read answerWhat do I do if my books are a mess before tax season?
Start by gathering all financial documents and focus on what matters most for your tax return. You don't need perfect books, just accurate totals for income and major expense categories. Consider catch-up services if you're significantly behind.
Read answer