Imagine a single drug family - a common generic - in one reconciliation cycle. You billed one manufacturer's NDC; your wholesaler shipped another's for the same drug. Here is what an exact-match report does with that, line by line.
The exact-match report
- Billed: 100 units of NDC A, with no matching purchase of NDC A. Reported as a shortage of 100.
- Purchased: 100 units of NDC B, with no matching claim for NDC B. Reported as an overage of 100.
- Net reality: zero. The same drug was bought and dispensed. But the report now shows two discrepancies where there are none.
The compounding problem
One swap produces two phantom line items. A pharmacy filling thousands of claims a month, across hundreds of multi-source generics that swap freely, can generate dozens or hundreds of phantom shortages and overages every cycle. Each one is a thing someone might investigate - and none of them is real.
What that actually costs
- Wasted staff time. Every phantom shortage is a potential investigation. At even a few minutes each, hundreds of phantoms per cycle add up to hours of misdirected effort.
- Hidden real shortages. A genuine, recoverable shortage looks like one more item on a long, mostly-phantom list. It gets skipped. The recoverable revenue is left on the table.
- Weaker audit defense. The very mismatch a swap creates is the kind of discrepancy a PBM auditor flags. Undocumented, it becomes a finding; detected and mapped, it is a non-event.
- Eroded trust in the data. When most of the report is noise, teams stop trusting it - and stop reconciling rigorously at all.
The same cycle, with swap detection
Run the same data through NDC swap detection and the picture inverts. NDC A and NDC B are normalized and recognized as the same drug family. The 100 billed and 100 purchased pair cleanly. The two phantom line items disappear. What remains on the report is only the genuine discrepancies - the ones worth your team's time and worth recovering.
The aggregate picture
Across RxDelta's network of 50+ independent pharmacies, automated reconciliation has surfaced $2.4M+ in recovered discrepancies. Undetected NDC swaps are a leading reason those discrepancies stayed hidden in the first place: they bury the real gaps in phantom noise.
The hidden cost of an undetected NDC swap is not the swap. It is everything the swap obscures. Detection does not just clean up the report - it makes the report trustworthy enough to act on.