Reconciliation earns its keep. Matching what a claim was adjudicated to pay against what the remittance actually deposited, then chasing the difference, catches short pays, missing remittances, fees taken after the fact, and claims that adjudicated but never landed. Pharmacies that skip it lose real money to all four, quietly, forever. If the choice is reconciling or not reconciling, reconcile.
The limit is structural. Reconciliation compares the remittance to the claim. It never compares either to your invoice, so it can confirm a perfect match on a fill that lost you fourteen dollars.
The three losses it cannot see
Adjudicated below cost. A claim comes back at ninety four dollars against acquisition cost of one hundred and eight. The plan pays exactly ninety four. Reconciliation confirms the match and closes the item. Nothing was underpaid. The fill lost money at the moment of adjudication, and it will lose money the next forty times, because nothing in the loop looked at cost.
Fee effectuation drift. DIR style fees have largely moved to the point of sale, which is an improvement, but effectuation is still where the arithmetic hides. Fees assessed at adjudication, network fees, transaction fees and clawbacks applied at plan or aggregate level do not all appear as a line against one claim. A reconciliation view that balances per claim can balance perfectly while the effective rate on a plan drifts down over a quarter. The claim was paid correctly. The contract got worse.
Unbilled but billable clinical work. A pharmacist administers an immunization, runs a point of care test, or does a genuine medication review, and no claim is ever created. There is nothing to reconcile, because reconciliation only ever sees claims that exist. This is the loss that appears on no report anywhere, and the only one of the three where the money was never collected rather than lost.
What revenue integrity actually covers
Four stages, in order. Reconciliation is most of the third.
Price it right. Know your true cost at the moment of adjudication, per NDC and per package, from your own invoices rather than a national average. Margin is a subtraction, and it is only as good as the cost side.
Bill it all. Every billable service becomes a claim on the correct benefit, pharmacy or medical, with documentation attached when it happens rather than reconstructed later.
Collect it fully. Match remittance to claim, chase short pays, appeal what is appealable inside the window, and track fees to the plan rather than only to the claim.
Defend it forever. Keep the evidence bound to the claim, so an audit request two years later is a retrieval rather than an investigation.
Reconciliation vendors sell stage three. Legitimate, useful, and one quarter of the loop.
Compute your own effective rate from exports you already have
Do this by hand once. The number tends to end an argument.
Pull two files. From your dispensing system, last month’s fills with NDC, quantity dispensed, plan or BIN and PCN, and total paid. From your wholesaler portal, last month’s invoice lines with NDC, package size and extended cost.
Per NDC, derive a unit acquisition cost from the invoice line, multiply by quantity dispensed to get cost for that fill, and subtract it from total paid. Group the result by plan.
You are now looking at realised margin by payer. Sort ascending. The bottom of that list is your working list: the plan and NDC combinations that are structurally unprofitable rather than occasionally unlucky. Compare total paid against total cost within a payer and you have that payer’s effective rate on your own book, which is the number to carry into a PSAO conversation or a contract review.
Two caveats keep it honest. Invoice cost is not net cost, because rebates and generic compliance terms settle later and off the invoice, so read the result as a floor. And a single month is noisy on low volume NDCs. Neither changes the shape of the answer, and the shape is usually enough to act on.
If that exercise takes you a day, it has told you something about the stack too. The arithmetic is not hard. The two files live in two systems that were never asked to speak.
Attergo Margin runs that comparison on every fill as it adjudicates, with the cost basis attached to each number, and Attergo Billing closes the third gap by turning the clinical encounter into a claim on the medical benefit. Book a demo to see both against your own month.