How to reconcile insurance payments to patient accounts, with an example

Reconciling an insurance payment is not entering the check. It is recording every part of the payer's decision on each patient account, the payment, the contractual adjustment and the remaining patient balance, and then confirming that the money posted equals the money the bank actually received. Skip any of those and the account is wrong, the patient is billed the wrong amount, and the books stop tying out. This page walks a single claim through, then a batch deposit that covers several patients, so you can see exactly how it is done and where it goes wrong.

First, the three documents

Reconciliation ties three things together that arrive around the same time, so it helps to name them.

Document	What it is
Explanation of benefits (EOB)	The statement showing how the insurer processed each claim: the allowed amount, the payment, the adjustment and the patient responsibility.
Electronic remittance advice (ERA)	The electronic version of that same claim-by-claim detail.
Electronic funds transfer (EFT)	The actual money moving into the practice's bank account, often as one deposit covering many claims.

Reconciliation uses the explanation of benefits or remittance advice to post the detail to each patient account, then confirms that what was posted matches the funds transfer that reached the bank.

A single claim, worked through

Start with one claim, because everything else is this repeated. Suppose a patient has a claim that the insurer processes as follows. All amounts are in dollars.

Item	Amount
Provider's billed charge	1,000
Insurance allowed amount	700
Contractual adjustment	300
Insurance payment	560
Patient responsibility	140

The two calculations behind those numbers are simple: the billed charge of one thousand dollars minus the three-hundred-dollar contractual adjustment gives the seven-hundred-dollar allowed amount, and the seven-hundred-dollar allowed amount minus the five-hundred-and-sixty-dollar insurance payment leaves one hundred and forty dollars of patient responsibility.

Now reconcile it to the account. Before the payment arrives, the patient account carries the full billed charge, a balance of one thousand dollars. When the explanation of benefits or remittance advice is received, you post all three components.

Post to the account	Amount
Insurance payment	560
Contractual adjustment or write-off	300
Patient responsibility (remaining balance)	140

The account then becomes one thousand dollars minus five hundred and sixty minus three hundred, which equals a one-hundred-and-forty-dollar remaining patient balance. That is what the patient statement should show, assuming there is no secondary insurance. This is the whole point: payment posting is not simply entering the five-hundred-and-sixty-dollar check. You post every component of the payer's adjudication, so the account reflects what insurance paid, what was contractually adjusted, and what the patient actually owes. The three-hundred-dollar adjustment there is a contractual write-off, recorded as contra-revenue rather than an expense, which we explain in recording insurance reimbursements and contractual adjustments.

A batch deposit, worked through

Insurers rarely pay one claim at a time. In practice a single funds transfer lands in the bank covering many patients at once, and the batch has to reconcile to the penny. Suppose the insurer sends one electronic funds transfer of two thousand dollars covering five different patients.

Open the remittance advice or explanation of benefits for the batch.
Identify each patient and claim it covers.
Post each claim's insurance payment and its adjustment to that patient's account.
Add up all the individual insurance payments you posted.
Compare that total with the two-thousand-dollar deposit that hit the bank.
If the totals match, the batch reconciles and you can close it.
If they do not, investigate before moving on.

In short, the flow is always the same: remittance, then identify each patient and claim, then post the insurance payment, then post the adjustment, then calculate the patient balance, and finally compare the total posted payments with the actual deposit.

When it does not match

A mismatch is never noise, so it is worth knowing the usual culprits before you go looking.

Likely cause	What happened
Missing claim payment	A claim on the remittance was not posted, so the posted total is short of the deposit.
Incorrect posting	A payment or adjustment was entered with the wrong amount.
Recoupment	The insurer clawed back a prior overpayment inside this deposit, reducing the net funds transferred.
Wrong account	A payment was posted to the wrong patient, so the batch total is right but a patient balance is wrong.

So what for you: leaving a mismatch unresolved is exactly how a practice ends up with cash that does not tie to accounts receivable, patient balances that are wrong, and a net collection rate that cannot be trusted. Reconciling the batch before closing it is what keeps all three honest.

Why this is the work that makes the books real

Reconciliation is where the practice-management system and the accounting ledger meet, and it is the step that makes every downstream number trustworthy. Post every component of each adjudication and match each batch to its deposit, and the patient balances are right, the accounts-receivable figure is real, and the collection rate reflects what actually happened. Skip it, or post only the checks, and the books drift away from reality one deposit at a time. This is the third piece of the same payer-revenue picture: it depends on booking contractual adjustments correctly, it feeds the net collections behind provider and location profitability, and it is what makes the collection rate on the monthly dashboard mean something.

Where Numetix fits

Numetix does this reconciliation as part of the monthly close. Working from the practice's explanations of benefits and remittance advice, it posts each payment, adjustment and patient balance into the books, ties every payer deposit back to the claims it covered, and flags the mismatches for follow-up, so the ledger, the patient accounts and the bank all agree. To be clear about the boundary: Numetix does the accounting reconciliation, not medical billing. It does not submit or appeal claims; it takes the results of the billing your team or billing company produced and turns them into books and balances that are correct.

Frequently asked questions

What does it mean to post all components of the adjudication?

When an insurer processes a claim it decides how much it will pay, how much of the charge is written off as a contractual adjustment, and how much the patient owes. Posting all components means recording each of those on the account, not just the payment. If you post only the check, the account still shows the full charge minus the payment, which overstates the patient balance and hides the adjustment.

Is reconciling insurance payments the same as medical billing?

No. Medical billing submits and follows up on claims. Reconciliation is the accounting step that takes what the insurer decided, from the explanation of benefits or remittance advice, and posts it correctly to the patient account and the books, then confirms the money ties to the bank deposit. A practice needs both, and they are usually done by different people or systems.

Why can't I just record the deposit as income?

Because a single deposit usually covers many patients and hides the detail that matters. Recording it as one lump of income leaves every patient balance unresolved, the contractual adjustments unrecorded, and the accounts-receivable figure wrong. Posting from the remittance and matching to the deposit is what turns a lump sum back into accurate accounts.

How often should reconciliation happen?

Every deposit, ideally as payments arrive, and certainly before the monthly books are closed. Reconciling promptly keeps small discrepancies from piling up, and it means the patient balances and the collection rate are current rather than a month behind. A backlog of unreconciled payments is one of the most common reasons a practice's numbers stop tying out.

The figures in the examples are illustrative, not any specific practice's numbers. This article is general information, not accounting, tax, or legal advice.