Get in Touch
Tell us about yourself and we will get back to you as soon as we can.
Tell us about yourself and we will get back to you as soon as we can.
Medical practices using QuickBooks face a revenue tracking problem that no other small business shares: every service is billed at one amount, paid at a lower contracted rate by an insurer, partially collected from the patient, and adjusted for the difference, all as separate transactions, across multiple payers, on different timelines. QuickBooks records deposits. It does not reconcile remittance advice, track contractual adjustments, or tell you your net collection rate by provider. This guide covers how to structure QuickBooks to separate revenue by payer and service line, why ERA reconciliation breaks every manual system, and how LayerNext AI automation keeps your books accurate without requiring a full-time biller in your accounting system.
What you will learn: Why medical practice bookkeeping is structurally different from standard small business accounting. How contractual adjustments and ERA reconciliation create a permanent gap in QuickBooks. A 5-step QuickBooks setup for multi-payer revenue tracking. Best practices for payer-level and provider-level financial visibility. How AI automation eliminates the manual reconciliation backlog.
Medical practice bookkeeping is the discipline of tracking every dollar of revenue against the payer that generated it, the provider who delivered it, and the service line it belongs to, net of contractual adjustments, write-offs, and patient balances. In QuickBooks, it is not a setup problem. It is a reconciliation problem.
Most practices get the basics functional: bank feeds connected, payroll running, and vendor bills entered. The part that breaks down is what happens between a service being rendered and a payment landing in the bank. A single patient encounter can produce a claim submission, an insurance payment at a contracted rate, a contractual adjustment for the balance, a patient statement for the remaining copay or deductible, and a collections follow-up, all of which need to be recorded correctly in QuickBooks as separate transactions against the same encounter.
QuickBooks records the deposit when it arrives. It does not know the claim it belongs to, the contractual rate that applies, or the outstanding patient balance still owed. That gap, between what was billed and what was actually collected, is where medical practice finances consistently go wrong.
According to the Medical Group Management Association (MGMA), the average medical practice writes off between 25 and 35 percent of its gross charges in contractual adjustments every year. If those adjustments are not posted correctly in QuickBooks, gross revenue looks far higher than net collectible revenue, and every financial decision the practice makes is built on an inflated number.
This guide covers what makes medical practice bookkeeping structurally unique, how to configure QuickBooks to handle multi-payer revenue correctly, why manual ERA reconciliation always falls behind, and how LayerNext automation handles the reconciliation workload without manual posting.
Related reading
For trade and project-based businesses managing job-level cost tracking, see our guides to Construction Job Costing in QuickBooks and Roofing Bookkeeping in QuickBooks.
A retail business gets paid at the point of sale. A medical practice does not.
When a physician sees a patient, a claim is submitted to an insurer, sometimes days later. The insurer processes it, applies a contracted rate that is typically far below the billed charge, pays the allowed amount, and sends an Electronic Remittance Advice (ERA) explaining every line-level adjustment. The patient then owes whatever the insurer did not cover. That balance may be collected at the next visit, billed by mail, or written off after multiple statements. The full cycle from service to final payment often takes 30 to 90 days.
None of this is visible inside QuickBooks without deliberate setup and continuous manual effort. QuickBooks sees a deposit from Blue Cross. It does not know what services that deposit covers, what contractual rate was applied, what was written off, or what patient balance remains outstanding.
As healthcare bookkeeping specialists note, revenue in healthcare does not equal cash in hand. Bookkeeping must include ERA reconciliation, remittance advice parsing, and adjustment posting to ensure net revenue is accurate for both tax reporting and performance analysis.
The five revenue and cost categories a medical practice needs to track separately:
When these are tracked correctly, you can calculate your true net collection rate, see which payers are profitable, identify which service lines are generating margin, and make staffing decisions based on real provider productivity. When they are not, you are managing cash flow against a gross revenue figure that overstates what the practice will actually collect.
The core bookkeeping challenge in a medical practice is not recording income. It is matching every payment to its claim, posting every contractual adjustment, and tracking every outstanding patient balance, across a different set of rules for every payer in your mix.
A typical primary care practice contracts with Medicare, Medicaid, and three to five commercial insurers, and also sees self-pay patients. Each payer has a different fee schedule, a different ERA format, a different payment timeline, and a different process for denials and appeals. A single day of patient encounters generates claims across all of these simultaneously.
When ERA files arrive, they contain line-by-line explanations of every adjustment: contractual allowances, coordination of benefits reductions, denial codes, and patient responsibility amounts. Reconciling this information into QuickBooks manually, matching each ERA line to the original claim, posting the adjustment, recording the net payment, and flagging outstanding patient balances, is a task that most practices hand to a medical biller, not a bookkeeper.
The problem is that QuickBooks and the practice management or EHR system operate in complete isolation. Revenue is recorded in the practice management system. Accounting is recorded in QuickBooks. The two are reconciled manually, usually at month-end, by comparing EHR income reports to the QuickBooks P&L and investigating any variance above a threshold.
Green Oak Accounting, which specializes in EHR-to-QuickBooks reconciliation for medical practices, notes that a variance of 1 to 3 percent between EHR income and QuickBooks income is normal, but anything beyond that requires a line-by-line investigation that can take hours. Most practices have variances they have never fully investigated.
The average medical practice writes off 25 to 35 percent of gross charges in contractual adjustments every year.
Source: MGMA. If those adjustments are not posted correctly in QuickBooks, net revenue is systematically overstated.
The QuickBooks setup that works for medical practices requires four things: a payer-aware chart of accounts, class-based service line tracking, a consistent adjustment posting workflow, and clean separation between gross and net revenue.
Create separate income accounts for each major payer category: Medicare, Medicaid, Commercial Insurance, and Self-Pay. Within commercial insurance, create sub-accounts for your top two or three payers by volume. This structure is what makes payer-level P&L reporting possible in QuickBooks without a third-party reporting tool.
Create a corresponding set of contra-revenue accounts for contractual adjustments, one per payer category. Contractual adjustments are not expenses; they are reductions to gross revenue. Posting them to the right contra-revenue account is what produces an accurate net revenue figure.
In QuickBooks Online Plus or Advanced, go to Settings, then Advanced, then Categories, and turn on Track Classes. Create a class for each provider or service line: Primary Care, Specialty, Ancillary Services, and Telehealth. Every income and adjustment entry is assigned to the correct class at the point of posting.
This is how you answer the question every practice owner asks but most QuickBooks setups cannot answer: which provider, or which service line, is actually profitable? See QuickBooks' class tracking guide for setup instructions.
Every ERA payment should be accompanied by a corresponding contractual adjustment entry in QuickBooks. The adjustment amount is the difference between the billed charge and the allowed amount. Posting this at payment time keeps your net revenue figure accurate throughout the year rather than requiring a large year-end correction.
Most practices skip this step and post only the deposit. The result is a gross revenue figure that looks healthy but overstates what was actually collected by 25 to 35 percent.
Patient responsibility, including copays, deductibles, and coinsurance, represents a distinct receivable from insurance reimbursement. In QuickBooks, create a separate accounts receivable account for patient balances. This separation is what allows you to age patient receivables independently of insurance receivables and follow up on each appropriately.
As healthcare revenue cycle specialists note, analyzing adjustment amounts relative to collection amounts reveals additional profitability information that a single AR balance cannot. Treating patient AR and insurance AR as one number makes both invisible.
This is where most medical practice QuickBooks setups deteriorate. Every payment, adjustment, and write-off needs to be tagged to the correct income account, class, and accounts receivable category at the point of entry, not reconstructed at month-end. LayerNext automated bookkeeping handles this assignment using AI, eliminating the manual posting step entirely.
These are two different financial events. They should never share the same account in QuickBooks.
Contractual adjustments are the pre-agreed discount between a practice and an insurer. When Blue Cross pays $80 on a $120 billed charge, the $40 difference is a contractual allowance. It was expected. It belongs in a contra-revenue account.
Denial write-offs are claims that were submitted, rejected by the insurer, and not successfully appealed or resubmitted. The $120 was expected. The $0 received is a failure in the billing process and not a contracted discount.
When both get posted to the same adjustment account, your denial rate disappears inside your contractual allowance. You cannot see how much revenue you are losing to billing errors, missing documentation, or expired timely filing limits. You cannot measure whether your billing team's denial rate is improving or getting worse.
In QuickBooks, create separate contra-revenue accounts: one for contractual adjustments per payer, and one for denial write-offs. Review the denial write-off account monthly. If it is growing relative to total billing volume, the billing workflow has a problem that the financial statements should be surfacing and currently are not.
The EHR or practice management system is where clinical billing lives. Charges are created there, claims are submitted from there, and ERA files are received and posted there. QuickBooks is where business accounting lives: the bank feed, payroll, vendor bills, and financial statements.
The gap between the two is structural, not accidental. No native integration exists between most practice management systems and QuickBooks. Revenue recognized in the EHR system is not automatically reflected in the QuickBooks P&L. The reconciliation between them is a manual process that most practices run once a month.
What the EHR reconciliation to QuickBooks typically involves:
By the time this reconciliation runs, the financial data is already 30 to 45 days old. Errors that took minutes to create can take hours to trace and correct. LayerNext automation bridges this gap by syncing ERA data to QuickBooks in real time, so the P&L and the EHR income report stay in agreement without a manual month-end reconciliation session.
Compare the income report in your practice management or EHR system to the income recorded in your QuickBooks P&L every month. A variance above 3 percent signals a posting error or missing payment that should be investigated while the encounter is still recent enough to trace.
A claim denied and written off is a different event from a contractual discount. Posting both to the same adjustment account hides your denial rate inside your contractual allowance and makes it impossible to measure the cost of claims management failures.
Days in AR is the most important cash flow indicator in a medical practice. Track it separately for each major payer. A commercial insurer paying in 45 days is a different problem from Medicare paying in 14 days. The MGMA benchmark for days in AR in a well-run practice is under 30 days. Most practices running manual QuickBooks reconciliation are above 50.
As revenue cycle specialists note, commercially insured patient collection rates dropped as low as 34.4 percent in 2025. Gross collections are only half the story. Your net collection rate, meaning payments collected as a percentage of net collectible charges after contractual adjustments, is the number that reflects your actual billing efficiency. LayerNext deep insights surface this metric automatically from your QuickBooks data.
Rent, staff salaries, and equipment costs shared across multiple providers need to be allocated per provider to calculate true provider profitability. Use QuickBooks Classes and location tracking to distribute these costs rather than letting them sit as undivided overhead that obscures which providers are covering their costs.
A primary care practice seeing 80 patients a day generates 80 claim transactions, each with a corresponding ERA, a contractual adjustment, and a patient balance. Multiplied across a five-day week, that is 400 payment events requiring correct posting in QuickBooks before the data is useful.
In most practices, this work falls to a billing coordinator who manages the practice management system and a bookkeeper or accountant who manages QuickBooks. The two systems are reconciled manually at month-end. By the time the reconciliation is complete, the financial picture it reveals is already four to six weeks old.
By the time these errors surface, usually during a financial review or tax preparation, correcting them requires tracing individual ERA files back through months of deposits. It is the most time-consuming cleanup work in healthcare bookkeeping.
HIPAA regulations add a further constraint. Patient identifiers cannot be stored in QuickBooks without triggering compliance risk. The reconciliation between clinical records and financial records must happen at an aggregate or coded level, which adds another layer of complexity to every manual posting workflow.
This is the problem that LayerNext automation solves.
LayerNext AI bookkeeping automation works as a layer on top of QuickBooks. Your accounting system of record stays exactly where it is. What changes is the work required to keep every payer payment, contractual adjustment, and patient balance correctly posted, in real time, without manual reconciliation.
Here is how it works for a medical practice:
A practical example: A Blue Cross ERA arrives covering 14 patient encounters from the prior week. The AI reads the remittance, identifies the payer, splits the payment across the correct income accounts by service line, posts the contractual adjustments for each line, flags two denied claims for follow-up, and syncs everything to QuickBooks. No manual ERA posting. No missed adjustments. No month-end reconciliation session.
The bank reconciliation layer matches every deposit to the ERA that generated it automatically, so your QuickBooks bank feed and your payer-level income reports stay in agreement without manual intervention.
This approach works best for:
If you are a solo provider with a single payer and simple cash-pay billing, manual QuickBooks entry is workable. Once you are managing two or more payers, tracking contractual adjustments, and trying to see provider-level profitability, the manual approach produces errors that compound month over month. See LayerNext pricing to find the right plan for your practice size.
QuickBooks is a workable accounting platform for medical practices. The class-based P&L, the accounts receivable aging, and the provider-level reporting are all possible with the right setup. The problem is keeping every payer payment, contractual adjustment, and patient balance correctly posted, in real time, across a volume of transactions that most practices cannot manage manually without falling behind.
Automation removes that bottleneck entirely.
The practice that gets this right ends up with:
