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.
The Hidden Cost of an Undetected NDC Swap (Worked Example)
The price of one missed swap is rarely the swap itself. It is the noise it adds, the real shortages it hides, and the staff time it burns. Walk through a concrete, line-by-line example.
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
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.
Frequently Asked Questions
What does an undetected NDC swap actually cost a pharmacy?
The direct cost of a single swap may be small, but the indirect costs compound: phantom shortages and overages inflate your discrepancy list, staff waste time investigating non-issues, real shortages hide in the noise and go unrecovered, and your audit trail looks inconsistent. Across thousands of claims and many drug families, the cumulative drag on revenue and time is significant.
How can a phantom shortage hide a real one?
When swaps create dozens of phantom shortages, a genuine shortage looks like just one more item on a long list. Teams triage by gut feel and often skip investigating, so the real, recoverable gap is never pursued. Resolving swaps shrinks the list to the discrepancies that actually matter.
How much can detecting swaps recover?
RxDelta has helped 50+ independent pharmacies recover $2.4M+ in cumulative billing discrepancies. Industry data shows pharmacies typically lose 2-5% of prescription revenue to discrepancies, and undetected swaps are a leading reason those discrepancies stay hidden. The exact recovery depends on claim volume, payer mix, and current reconciliation practices.
Does fixing NDC swaps help with PBM audits?
Yes. The discrepancy auditors most often flag is an apparent mismatch between billed and purchased NDCs - which is frequently a swap. Detecting and documenting swaps in advance means you can demonstrate the products are equivalent, turning a potential audit finding into a non-event.
Related reading
Find the Revenue Hiding Behind Phantom Shortages
RxDelta resolves NDC swaps and surfaces the real, recoverable discrepancies in under 3 minutes. Plans from $200/month, no long-term contracts.