On an exact-match report, both show up the same way: a billed line with no matching purchase. The report cannot tell that one is a manufacturer swap and the other is a missing purchase. Without family-level mapping, every swap masquerades as a shortage - and every real shortage is camouflaged among them.
NDC Swaps vs True Shortages: Telling Them Apart
In a naive reconciliation, a phantom shortage and a real one look exactly the same. The whole value of swap detection is being able to tell them apart - so your team only investigates discrepancies that actually matter.
Open a reconciliation report built on exact NDC matching and you will see a list of shortages and overages. The trouble is that most of them are not real. They are NDC swaps in disguise. To run a pharmacy on that report, you first have to separate the phantoms from the genuine gaps.
Definitions that matter
- NDC swap (phantom shortage). The drug was purchased and dispensed, but billing and purchasing recorded different NDCs for it. No real gap exists.
- True shortage. You billed for a quantity of a drug that your purchase records do not account for. A genuine gap that costs money or invites audit questions.
Why they look identical
How detection separates them
Swap detection adds a step the spreadsheet cannot: it normalizes each NDC and maps it into a drug family before matching. Then the logic is simple:
- If a billed NDC pairs with a purchased NDC in the same family at matching quantity, it is a swap and resolves automatically.
- If a billed quantity still has no matching purchase after family mapping, that is a true shortage and stays flagged.
- If a billed line is short by part of its quantity, the swap resolves and the remaining gap is flagged as a partial true shortage.
Why this is the whole game
A reconciliation report is only useful if you can act on it. When 80% of the flagged items are phantom swaps, the report is noise - and the real shortages, the ones worth recovering or defending in an audit, hide in that noise. Separating swaps from true shortages is what turns a reconciliation from a confusing list into a short, actionable worklist.
Once you can tell the two apart, the natural next question is how much an undetected swap actually costs you. The next article walks through a worked example, line by line.
Frequently Asked Questions
What is the difference between an NDC swap and a true shortage?
An NDC swap is a phantom discrepancy: the drug was purchased and dispensed, just recorded under a different NDC in billing versus purchasing. A true shortage is real: you billed for a quantity you did not actually purchase. They look identical in a naive exact-match report, but only the true shortage represents a genuine reconciliation gap worth investigating.
Why is it important to separate swaps from real shortages?
If you cannot tell them apart, phantom shortages bury the real ones in noise. Your team wastes time chasing discrepancies that are not real, while genuine shortages - the ones that cost money or create audit exposure - go unaddressed. Separating the two is what makes a reconciliation report actionable.
How does software tell a swap from a true shortage?
Detection software normalizes NDCs and maps them into drug families. If a billed NDC and a purchased NDC belong to the same family in matching quantities, it is a swap and resolves automatically. If, after family mapping, a billed quantity still has no matching purchase, that is a true shortage and gets flagged.
Can a true shortage hide inside an NDC swap?
Yes. A drug can be both swapped and short - for example, you billed 100 units of NDC A, your wholesaler shipped 60 units of NDC B (same drug). Family-level reconciliation resolves the swap and still surfaces the 40-unit real shortage, so you see the genuine gap without the swap obscuring it.
Related reading
See Only the Discrepancies That Are Real
RxDelta resolves NDC swaps automatically and surfaces genuine shortages and overages - so your team stops chasing phantoms. Plans from $200/month.