Most independent pharmacies reconcile at the level of “did the deposit roughly match the statement”. That catches a missing payment. It does not catch a claim that was paid, paid on time, and paid wrong, and those are where the recoverable money sits.
This is a walkthrough of what arrives, what has to balance, and where the gaps usually turn up.
Two streams, two reconciliations
Pharmacy benefit claims adjudicate in real time over NCPDP D.0, with B1 for billing, B2 for reversal and B3 for rebill. Payment follows on a cycle as a remittance statement, a portal export, or an 835 electronic remittance advice where the payer supports it.
Medical benefit claims are a different animal. Vaccines billed under the medical benefit, point-of-care testing, and an increasing volume of clinical services go out on an 837P and come back on an 835, through a clearing house, with different denial codes, different ageing, and usually a different person chasing them.
Pharmacies that reconcile only the first stream tend to have an unexamined pile of medical claims in various states of denial. If that is you, start there. It is normally the fastest money in the building, and it is the reason claim capture for clinical services is worth treating as its own workflow rather than an afterthought.
Make the claim findable before you do any arithmetic
To join a remittance line back to the fill you need the prescription and fill number, the date of service rather than the date of billing, the NDC in 11-digit billed format, quantity dispensed in metric decimal units, days supply, and BIN, PCN and Group ID.
The plan identifiers are the ones people skip. Two fills of the same drug on the same day under different BIN and PCN combinations are two different economic events priced from two different rate tables. Analysis aggregated to “Caremark” or “Express Scripts” without the PCN cannot tell you which contract is losing you money, which is why so much reimbursement reporting produces a feeling rather than an action.
If your remittance does not carry BIN and PCN per line, pull them from the dispensing system and join on prescription plus date of service.
The amounts that must balance
The NCPDP response carries a fixed relationship between the pricing components. Reduced to the fields that matter most of the time:
Total Amount Paid (509-F9)
= Ingredient Cost Paid (506-F6)
+ Dispensing Fee Paid (507-F7)
+ Incentive Amount Paid
+ Other Amount Paid
+ Sales Tax Paid
- Patient Pay Amount (505-F5)Total Amount Paid is the plan’s share, not the gross value of the fill. Comparing it directly to acquisition cost without adding the patient portion back will manufacture phantom losses on every high-deductible claim you fill, and January is full of them.
Two more fields earn their storage. Basis of Reimbursement Determination (522-FM) tells you which method priced the ingredient cost, which is the fastest triage you have. Additional Message Information (526-FQ) frequently carries the text a PBM will quote back at you during an appeal.
Three reconciliations, in this order
Claim to remittance
Every dispensed, non-reversed claim should appear on a remittance inside the payment cycle your contract states. Anything that has not is your first worklist.
Usual causes, roughly in order of frequency: reversed at the counter and dispensed anyway without a rebill; a partial fill whose completion claim never went out; billed to the wrong plan and corrected into a later cycle; a secondary coordination of benefits claim that was never submitted after the primary paid.
Remittance to deposit
Statement total against money received. Differences are almost always netted fees or statement-level adjustments: per-claim transaction fees, network or administrative fees, prior-period corrections, and audit recoupments.
Statement-level adjustments are the least examined line in independent pharmacy finance because they are the hardest to attribute. Insist on the detail behind them. Where an adjustment references an audit, ask for the claim list, and keep it. Frier Levitt’s 2025 audit guidance notes that PBMs are increasingly classifying reviews as investigations rather than audits, a framing that reduces the protections available under state fair audit laws, so the contemporaneous record you keep at the time of the adjustment is worth more than the one you assemble later. This is the specific job Attergo Audit exists to do: hold the claim, the invoice, the signature log and the adjustment together as one evidence trail rather than four systems you have to reassemble under deadline.
Contract to claim
The one that finds real money, and the one almost nobody runs.
For each claim, compute what it should have paid and compare it to what it did. Where the contract is a discount off AWP plus a fee, that is directly computable. Where the generic was priced from MAC, you cannot derive the expected amount from the contract at all, so benchmark instead: your net acquisition cost for that NDC, and the published NADAC for the same NDC and unit.
Sort variances by dollars, not by percentage. A 60 percent shortfall on a $4 claim is noise. A 12 percent shortfall recurring across 200 claims a month is a line item.
Where the money usually is
Reversals never rebilled. Pure loss, and invisible to any report that starts from the remittance rather than from the dispense.
Secondary claims never billed. The primary paid, the balance sat, nobody submitted.
Below-cost claims whose appeal window opened and closed. Several MAC appeal deadlines run in business days from the initial claim. A monthly review cadence arrives after the window on most of them by construction.
Usual and customary overrides. Field 522-FM makes these obvious the moment you look at it, and invisible until you do.
Medical benefit denials with correctable causes. Administration code mismatches, eligibility, place of service. They sit because they are outside the pharmacy system’s normal workflow, which is exactly the gap Attergo Billing is built to close.
Consistent short pays on one BIN and PCN. Invisible in payer-level totals, obvious the second you group by plan.
Cadence beats technique
The single change that matters more than anything above is how often you do it. Reconciling last quarter tells you what happened. Reconciling last week lets you appeal, rebill, and change what you buy.
A workable weekly rhythm: pull claims dispensed, join remittances received, list the unmatched, list everything paid below net acquisition cost, and work the top twenty by dollar variance. Twenty lines is enough to expose a systemic pattern and small enough that it actually gets done on a Tuesday.