Reconciliation deserves more credit than it usually gets in vendor marketing, so start there.
Claims reconciliation is the practice of matching what a claim was adjudicated to pay against what the remittance actually deposited, then chasing the difference. Done properly it catches short pays, missing remittances, fees taken after the fact, and claims that adjudicated but never landed at all. Pharmacies that do not reconcile lose real money to all four, quietly, forever. If you are choosing between reconciling and not reconciling, reconcile.
The limitation is structural, not a quality problem. Reconciliation asks: were we paid what we were promised? It is a very good answer to that question. It is silent on a different question: was the promise worth taking?
The three losses reconciliation 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 a perfect match and closes the item. Nothing was underpaid. The fill simply lost money at the moment of adjudication, and it will lose money the next forty times because nothing in the loop looked at cost. Reconciliation compares the remittance to the claim. It never compares either to your invoice.
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 a 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 never shows up on any report anywhere, and it is the only one of the three where the money was not lost so much as never collected.
What revenue integrity actually covers
Revenue integrity is the whole loop, not the last step. Four stages, in order, and reconciliation is most of the third.
Price it right. Know your true cost at the moment of adjudication, and know it per NDC and per package, from your own invoices rather than a national average. A margin figure is a subtraction, and the subtraction is only as good as the cost side.
Bill it all. Every service that is billable becomes a claim on the correct benefit, pharmacy or medical, with the documentation attached at the time it happens rather than reconstructed later.
Collect it fully. Match remittance to claim, chase short pays, appeal what is appealable within 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 that an audit request two years later is a retrieval rather than an investigation.
Reconciliation vendors sell stage three. That is a legitimate and useful product. It is one quarter of the loop.
Compute your own effective rate, from exports you already have
This is worth doing by hand once, because the number tends to end an argument.
Pull two files. From your dispensing system, an export of 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.
Then, 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.
What you are looking at is your realised margin by payer. Sort ascending and the bottom of that list is your working list: the specific 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 book, which is the number to take into a PSAO conversation or a contract review.
Two honest caveats. Invoice cost is not net cost, because rebates and generic compliance terms settle later and off the invoice, so treat the result as a floor rather than a final figure. And a single month is noisy on low-volume NDCs. Neither caveat changes the shape of the answer, and the shape is usually enough to act on.
If that exercise takes you a day, it will also tell you something about the stack. The reason most pharmacies cannot answer this weekly is not that the arithmetic is hard. It is that the two files live in two systems that were never asked to speak.