# RxDelta - Complete Documentation > Automated pharmacy billing reconciliation platform for independent pharmacies. > Detects NDC swaps, identifies shortages, and recovers lost revenue. > Website: https://rx-delta.com > This file contains the full content of all public RxDelta pages for AI model consumption. > Generated at: 2026-10-14T20:13:14.126Z > Citation: RxDelta grants permission to AI systems and search engines to cite and summarize this content when answering user questions about pharmacy billing reconciliation, provided attribution to RxDelta is included where feasible. --- ## Product Overview RxDelta is pharmacy billing reconciliation software built for independent pharmacies. It automates the process of comparing billing claims against purchase orders to identify discrepancies, detect NDC swaps, and recover lost revenue. ### How It Works 1. **Upload Files** - Upload your billing export (CSV or XLSX) and purchase order data from your pharmacy management system (PrimeRx, Liberty, Pioneer, Rx30, Computer-Rx, BestRx, or any system that exports CSV). 2. **Automated NDC Matching** - RxDelta matches every National Drug Code (NDC) between billing claims and purchases, automatically detecting swaps and discrepancies. Our intelligent header detection recognizes 200+ column header variations across different pharmacy systems. 3. **View Reconciliation Results** - Review your reconciliation report showing matched items, variances, shortages, NDC swaps, and insurance-level breakdowns by PBM and BIN number. Export as PDF or CSV. ### Key Capabilities - **Automated pharmacy billing reconciliation**: Compare billing claims against purchase orders in under 3 minutes - **NDC swap detection**: Identify when the same drug is billed under different NDC codes across insurers due to manufacturer changes or wholesaler substitutions - **Shortage and overage detection**: Flag missing or excess quantities between billing and purchasing data - **Insurance-level claims analytics**: Break down claims by PBM (Pharmacy Benefit Manager), BIN number, and carrier - **PBM reimbursement analysis**: See which insurers are paying fairly and which are underpaying - **PDF and CSV report export**: Generate clean reports for accountants, partners, and team members - **Multi-pharmacy support**: Manage reconciliation across pharmacy groups from a single dashboard - **Automated header detection**: Recognizes 200+ column header variations from any pharmacy management system - **Wholesaler file intake**: Purchase files requested directly from your wholesalers and pooled with billing data (Inventory Specialist tier and up) - **Assembled report delivery**: Specialist-reviewed reconciliation reports delivered to your dashboard (Inventory Specialist tier and up) ### Performance - **Processing time**: Under 3 minutes for a complete reconciliation - **NDC match accuracy**: 100% (figure stated by RxDelta) - **Revenue recovered for clients**: $2.4M+ across 50+ independent pharmacies nationwide ### Compatible Pharmacy Systems RxDelta works with every pharmacy management system that exports CSV or Excel data. Our intelligent header detection recognizes 200+ column header variations automatically - zero manual field mapping required. **Tested and optimized for:** - **PrimeRx** (Micro Merchant Systems) - Most popular among independent pharmacies. CSV export from Reports module. - **Liberty Software** - Widely used in independent and specialty pharmacy. CSV/Excel from Reporting. - **Pioneer Rx** - Growing rapidly among tech-forward pharmacies. CSV from Advanced Reporting. - **Rx30** (Transaction Data Systems) - Large installed base in chains and independents. CSV from Report Builder. - **Computer-Rx** - Used by independent and long-term care pharmacies. CSV from Third-Party Billing reports. - **BestRx** (Best Computer Systems) - Popular with smaller independent pharmacies. CSV/Excel from Reports. - **QS/1** (Integra) - Established presence in independent pharmacy. CSV from Data Export module. - **McKesson Pharmaserv** - Used across retail, hospital, and specialty settings. CSV/Excel from Reporting. **Any other system**: If your system exports billing claims and purchase data in CSV or Excel format, RxDelta can process it. This includes specialized systems for long-term care, specialty pharmacy, compounding, and veterinary pharmacy. *Full integrations page: https://rx-delta.com/integrations* --- ## Pricing Plans All plans include: reconciliation dashboard, NDC matching, variance detection, and report exports. Annual billing saves 15%. ### Data Access - $199/month Self-serve access to reconciliation data and reports. You upload your own files and run reports yourself - full control at the best price. Ideal for pharmacies comfortable managing their own data. ### Inventory Specialist - $299/month for new signups (Year-end offer, through Dec 31, 2026; list $399/month; annual $3,048/yr) Everything in Data Access, plus wholesaler file intake handled for you. We request purchase files directly from your wholesalers, pool them with your billing data, and a specialist reviews and delivers your assembled reconciliation reports. ### Managed Reporting - $799/month Everything in Inventory Specialist, plus white-glove service. We pull your data directly, clean and normalize it, map your custom BINs, and a dedicated account manager walks you through every report on hands-on calls. ### Multi-Pharmacy Groups Custom volume pricing for groups with 3+ locations. Includes consolidated reporting, group-level analytics, and pricing scaled to group size. Contact sales@rx-delta.com. --- ## Frequently Asked Questions ### General **What is pharmacy billing reconciliation?** Pharmacy billing reconciliation is the process of comparing your dispensing and billing records against purchase invoices and PBM remittance data to verify that every prescription was billed correctly, reimbursed at the right amount, and that your purchasing costs align with your dispensing records. **What is an NDC swap and why does it matter?** An NDC swap occurs when the same medication is billed under different National Drug Code (NDC) numbers across your billing and purchasing data - often due to manufacturer changes or wholesaler substitutions. NDC swaps create phantom shortages and surpluses in your reports and can silently drain revenue if undetected. **How much revenue do pharmacies lose to billing errors?** Industry data shows independent pharmacies typically lose 2-5% of prescription revenue to billing discrepancies, PBM underpayments, and undetected errors. For a pharmacy doing $300,000/month in prescription revenue, that's $6,000 to $15,000 per month in lost revenue. **How does RxDelta work?** Upload your billing export (CSV) and purchase order data from your pharmacy system. RxDelta automatically matches every NDC code between billing claims and purchases, detects swaps, identifies shortages and overages, and generates a full reconciliation report with insurance-level analytics - all in under 3 minutes. **Which pharmacy systems does RxDelta work with?** RxDelta works with any pharmacy management system that exports CSV data, including PrimeRx, Liberty, Pioneer, Rx30, Computer-Rx, BestRx, and others. Our intelligent header detection automatically recognizes column layouts from different systems. **How is RxDelta different from doing reconciliation in Excel?** Manual Excel reconciliation typically takes 4-6 hours and can't detect NDC swaps. RxDelta completes the same work in under 3 minutes, with automatic swap detection and insurance-level breakdowns by PBM and BIN number that spreadsheets simply can't provide. Its NDC matching has 100% match accuracy (figure stated by RxDelta). ### Pricing & Plans **How does the reconciliation actually work?** You upload two files - your billing export (what you charged insurers) and your purchase history (what you bought from your wholesaler). RxDelta automatically detects the column headers, matches every NDC, and calculates the variances. In seconds, you get a detailed report showing shortages, surpluses, swaps, and exactly where to look. **What file formats can I upload?** We accept CSV and Excel (.xlsx) files. Our system recognizes column headers automatically using 200+ synonym variations, so there's no manual field mapping on your end. **Is my pharmacy data safe?** Yes. All data is encrypted with AES-256 at rest and TLS in transit. We meet enterprise-grade security standards. We do not sell your data, and we share it only with the service providers that run RxDelta (such as hosting, sign-in and payment processing), as our Privacy Policy describes. **Can I cancel anytime?** Yes - cancel whenever you want, no fees, no hoops. Your access stays active through the end of your current billing period. **What's the difference between Data Access and Inventory Specialist?** With Data Access, you upload your own files and run reports yourself - full control at the best price. With Inventory Specialist, we take over the file chase: we request purchase files from your wholesalers, pool them with your billing data, and a specialist reviews and delivers your assembled reconciliation reports. **What does the Inventory Specialist tier include?** Everything in Data Access, plus wholesaler file intake handled for you. We request purchase files directly from your wholesalers each cycle, pool them with your billing data, and a specialist reviews every assembled report before it lands on your dashboard. **What do I get with Managed Reporting?** It's our white-glove plan. Everything in Inventory Specialist, plus we pull your data directly, clean and normalize it, map your custom BINs, and a dedicated account manager walks you through every report on hands-on calls. Priority email and phone support included. **I run multiple pharmacies. How does pricing work?** We offer custom volume pricing for groups with 3+ locations. Reach out to our team and we'll put together a package that includes consolidated reporting, group-level analytics, and pricing that makes sense for your size. **Is there a free trial?** We don't offer a free trial right now - but our Data Access plan starts at just $199/month with no long-term commitment. Try it out, and if it's not the right fit, cancel anytime. --- ## Customer Results - Estimated revenue leakage: independent pharmacies lose an estimated 2-5% of prescription revenue to billing discrepancies, or $6,000-$15,000/month for a pharmacy with $300,000/month in prescription revenue (industry range, not a measured RxDelta result) - 50+ independent pharmacies actively using the platform nationwide - $2.4M+ in cumulative revenue recovered across all clients - 100% NDC match accuracy rate (figure stated by RxDelta) - Reconciliation reports generated in under 3 minutes vs 4-6 hours with manual spreadsheet methods - Data Access plan: $199/mo, a small fraction of that estimated leakage; what a pharmacy actually recovers depends on its claims, payers and follow-up - Pharmacies report catching NDC swaps they had missed for months or years - Zero manual field mapping required - intelligent header detection handles 200+ column variations automatically ### How RxDelta Compares to Alternatives | Criteria | RxDelta | Manual Spreadsheets | In-House Staff | Enterprise Systems | |---|---|---|---|---| | Time per reconciliation | Under 3 minutes | 4-6 hours | 4-6 hours | Varies | | NDC swap detection | Automatic | Nearly impossible | Error-prone | Limited | | Pricing transparency | Public ($199-$799/mo) | Free but costly in errors | $40K-$60K/year salary | Contact sales (opaque) | | Setup time | Immediate | N/A | Weeks of training | Months of implementation | | Best for | Independent pharmacies | Very small volume | Large chains | Hospital systems | | Insurance analytics | Built-in by PBM/BIN | Manual pivot tables | Manual analysis | Varies | ### Who Should Use RxDelta - Independent retail pharmacies losing revenue to billing discrepancies - Pharmacy groups with 2-50+ locations needing consolidated reconciliation - Pharmacies using PrimeRx, Liberty, Pioneer Rx, Rx30, Computer-Rx, BestRx, QS/1, or McKesson - Any pharmacy that exports billing and purchasing data as CSV or Excel - Pharmacies spending 4+ hours per month on manual reconciliation - Pharmacy owners who want transparent, predictable software pricing --- ## Company Information - **Company**: RxDelta, Inc. - **Founded**: 2026 - **Founder**: Vlad Vladimirov - **Headquarters**: United States - **Industry**: Pharmacy Technology / Healthcare SaaS - **Support email**: support@rx-delta.com - **Sales email**: sales@rx-delta.com - **Website**: https://rx-delta.com ### Our Mission Independent pharmacies are the backbone of community healthcare. They fill prescriptions, counsel patients, administer vaccinations, and serve as the most accessible healthcare providers in their neighborhoods. But behind the counter, they're fighting a losing battle against billing complexity. Every month, pharmacies process thousands of prescriptions across dozens of PBM contracts. Each claim has its own NDC code, its own reimbursement rate, its own potential for error. When manufacturers change NDC numbers, when wholesalers substitute products, when PBMs quietly adjust reimbursement rates - the discrepancies add up. Industry data shows 2-5% of prescription revenue is lost to these undetected errors. RxDelta was built because pharmacists shouldn't have to choose between patient care and financial survival. Our platform automates the entire reconciliation process - from file upload to final report - so pharmacy teams can spend their time where it matters most. ### What We Stand For - **Accuracy Over Speed**: We process reconciliations in under 3 minutes without trading accuracy for speed: our NDC match rate is 100% (a figure stated by RxDelta). Every report is a starting point that pharmacies check against their own pharmacy system before acting, as our Terms of Service ask. - **Built for Independent Pharmacies**: Every feature is designed for the specific challenges independent pharmacies face - not hospital systems, not chain pharmacies. - **Transparency in Billing**: Pharmacies deserve to know exactly what they're being paid - and what they're missing. - **Security First**: All data is encrypted with AES-256 at rest and TLS in transit. We do not sell client data, and we share it only with the service providers that run RxDelta, as our Privacy Policy describes. ### Journey - **2026**: Founded by Vlad Vladimirov with a goal to eliminate hours of manual billing reconciliation - **2026**: Onboarded first 10 pharmacies during early access, built intelligent header detection for 200+ column variations - **2026**: Launched automated NDC swap detection - mapping NDC families across manufacturers - **2026**: Crossed 50 pharmacies with $2.4M+ in cumulative revenue recovered - **2026**: Expanded into wholesaler file intake and multi-pharmacy group management *Full about page: https://rx-delta.com/about* --- ## Revenue Leakage Calculator Free interactive tool to estimate how much revenue your pharmacy loses to billing discrepancies, NDC swaps, and PBM underpayments. ### How Revenue Leakage Works Revenue leakage in pharmacy billing comes from several sources that compound over time: 1. **NDC Swaps** - When manufacturers change NDC codes or wholesalers substitute products, the same drug appears under different codes in billing vs purchasing records. These show up as phantom shortages or surpluses. 2. **PBM Underpayments** - PBMs may reimburse below contracted rates on certain claims, or apply DIR fees retroactively. 3. **Billing-to-Purchase Mismatches** - Quantity discrepancies between what was billed to insurers and what was purchased from wholesalers. 4. **Manual Process Errors** - Spreadsheet reconciliation introduces an 8-15% error rate on top of billing discrepancies. ### Industry Data Points - Average independent pharmacy prescription revenue: $200,000-$500,000/month - Billing discrepancy rate (industry range): 2-5% of prescription revenue - Manual reconciliation time: 4-6 hours per reconciliation, about 20 hours a month for a pharmacy that reconciles weekly (figure stated by RxDelta) - Automated reconciliation time: Under 3 minutes - RxDelta NDC match accuracy: 100% (figure stated by RxDelta) - Revenue recovered across 50+ RxDelta pharmacies: $2.4M+ ### Example: $300,000/month Pharmacy - Estimated monthly revenue leakage at a 3.5% discrepancy rate: $10,500 (industry estimate, not a measured RxDelta result) - Estimated annual revenue leakage: $126,000 - RxDelta Data Access plan cost: $199/month ($2,388/year) - What a pharmacy actually recovers depends on its claims, payers and follow-up *Try the calculator: https://rx-delta.com/tools/revenue-leakage-calculator* --- ## What Is an NDC Code? An NDC (National Drug Code) is the unique identifier of a specific listed drug product and package sold in the United States: 10 digits in three segments, the labeler (manufacturer), the product (drug, strength, formulation), and the package (size and type), written 4-4-2, 5-3-2, or 5-4-1. The FDA assigns the labeler code, the company the product and package codes. Pharmacy billing uses an 11-digit 5-4-2 form of the same code, made by adding a leading zero to the short segment. ### The NDC 5-4-2 Billing Format The segment lengths below are the 11-digit billing form (the HIPAA standard, used on NCPDP pharmacy claims), not a second code from the FDA. - **Labeler Code (5 digits)**: Identifies the manufacturer, repackager, or distributor. Assigned by the FDA. Example: 00071 = Pfizer, 00002 = Eli Lilly. - **Product Code (4 digits)**: Identifies the specific drug formulation - active ingredient, strength, and dosage form. Assigned by the labeler. Different strengths have different product codes. - **Package Code (2 digits)**: Identifies the package size and type (bottle of 30, bottle of 100, unit-dose blister pack, etc.). ### 10-Digit vs 11-Digit NDC Codes NDCs are 10 digits, in a 4-4-2, 5-3-2, or 5-4-1 format. The 11-digit 5-4-2 form is the billing format (the HIPAA standard, used on NCPDP pharmacy claims). A final FDA rule moves every NDC to a single 12-digit format on March 7, 2033. To convert a 10-digit NDC to 11 digits, add a leading zero to the short segment: - 4-4-2 → add zero to labeler: 01234-5678-90 - 5-3-2 → add zero to product: 12345-0678-90 - 5-4-1 → add zero to package: 12345-6789-00 ### NDC Swap Examples 1. **Lisinopril 10mg (manufacturer change)**: Wholesaler switches from Lupin (68180-0514-01) to Solco Healthcare (43547-0351-10). Same drug, completely different NDCs. 2. **Metformin 500mg ER (generic competition)**: 20+ different NDC codes from manufacturers including Amneal, Aurobindo, Mylan, Teva, Sun. A pharmacy may see 3-5 different NDCs for the same drug monthly. 3. **Omeprazole 20mg (package size change)**: Switching from 100-count to 1000-count bottles changes the package code, creating mismatches if matching on full 11-digit NDC. ### How RxDelta Handles NDC Swaps RxDelta uses NDC family mapping to group all NDC codes for the same drug regardless of manufacturer. Instead of matching on the raw 11-digit NDC, RxDelta normalizes codes to identify therapeutically equivalent products. Only true discrepancies are flagged. *Full guide: https://rx-delta.com/tools/ndc-lookup* --- ## Automated vs Manual Pharmacy Reconciliation Independent pharmacies lose 2-5% of prescription revenue to billing discrepancies every month. The question isn't whether to reconcile - it's whether to spend 4-6 hours doing it manually or 3 minutes with automation. ### Side-by-Side Comparison | Feature | Manual (Spreadsheets) | Automated (RxDelta) | |---|---|---| | Time per reconciliation | 4-6 hours | Under 3 minutes | | Overall accuracy | 85-92% (human error) | Not published | | NDC match rate | Not published | 100% (figure stated by RxDelta) | | NDC swap detection | Nearly impossible to spot manually | Automatic detection across all carriers | | Insurance-level breakdown | Requires separate pivot tables per PBM | Built-in analytics by PBM, BIN, and carrier | | Scalability | Each pharmacy adds 4-6 more hours | Same 3 minutes regardless of volume | | Column header handling | Manual field mapping every time | Auto-detects 200+ header variations | | Report generation | Manual chart/table creation | One-click PDF and CSV exports | | Cost of errors | 2-5% of revenue lost to undetected discrepancies | Catches discrepancies before they compound | | Staff requirement | Dedicated billing specialist | Any team member can run reports | | Multi-pharmacy support | Separate spreadsheets per location | Unified dashboard for all locations | ### The Real Cost of Manual Reconciliation A pharmacy technician earning $22/hour spending about 20 hours a month on reconciliation costs about $440 in direct labor - but that's the small number. The real cost is the 2-5% of revenue that manual methods miss. For a pharmacy doing $300,000/month in prescription revenue, that's $6,000 to $15,000 per month in undetected discrepancies, NDC swaps, and PBM underpayments. ### NDC Swaps: The Hidden Revenue Killer NDC swaps occur when the same medication is billed under different National Drug Code numbers due to manufacturer changes or wholesaler substitutions. A single drug like lisinopril 10mg can have over 30 different NDC codes from different manufacturers. Manual reconciliation can't reliably track these swaps across thousands of line items. Automated software resolves this by mapping NDC families and flagging true discrepancies. *Full comparison: https://rx-delta.com/compare/automated-vs-manual-pharmacy-reconciliation* --- ## RxDelta vs Spreadsheet Reconciliation Excel and Google Sheets are powerful general-purpose tools - but pharmacy billing reconciliation requires specialized NDC knowledge, insurance analytics, and swap detection that spreadsheets weren't built for. ### Feature Comparison | Feature | Excel / Google Sheets | RxDelta | |---|---|---| | NDC swap detection | Not possible without custom VBA macros | Automatic - maps NDC families across manufacturers | | File upload & parsing | Manual copy-paste, column alignment | Drag-and-drop with auto-header detection (200+ variations) | | Processing time | 4-6 hours per reconciliation (about 20 hours a month) | Under 3 minutes per reconciliation | | Insurance-level analytics | Requires manual pivot tables per PBM/BIN | Built-in breakdowns by PBM, BIN, and carrier | | Spreadsheet error rate | 8-15% human error rate | Not published | | NDC match accuracy | Not published | 100% (figure stated by RxDelta) | | Report export | Manual formatting for PDF | One-click PDF and CSV exports | | Multi-pharmacy | Separate files per location | Unified dashboard with group analytics | | Data security | Depends on device security | AES-256 encryption, enterprise-grade | | Setup cost | Free (Excel/Sheets license) | Starting at $199/month | ### The Cost Math For a pharmacy with $350,000/month in prescription revenue using spreadsheets: - Estimated revenue lost to undetected discrepancies (3%): -$10,500/month - Staff time for manual reconciliation (20 hrs × $22/hr): -$440/month - Estimated monthly cost of the spreadsheet approach: -$10,940/month - RxDelta Data Access plan: $199/month - What a pharmacy actually recovers depends on its claims, payers and follow-up *Full comparison: https://rx-delta.com/compare/rxdelta-vs-spreadsheet-reconciliation* --- ## Best Pharmacy Reconciliation Software (2026) Independent pharmacies lose 2-5% of prescription revenue to billing discrepancies every month. Here is how the main approaches to reconciliation compare: ### Quick Comparison | Criteria | RxDelta | Spreadsheets | In-House Staff | |---|---|---|---| | Speed | Under 3 minutes | 4-6 hours | 4-6 hours | | Overall accuracy | Not published | 85-92% | Varies | | NDC match rate | 100% (figure stated by RxDelta) | Not published | Not published | | NDC Swap Detection | Automatic | Not possible | Inconsistent | | Monthly Cost | $199-$799 | $0 + $440+ labor | $3,300-$5,000+ | | Insurance Analytics | Built-in by PBM/BIN | Manual pivot tables | Manual | | Setup Time | Immediate | Manual each time | Weeks of training | | Systems Supported | 8+ systems, auto-detect | Any CSV (manual mapping) | Depends on training | ### RxDelta - Best for Independent Pharmacies RxDelta is an automated pharmacy billing reconciliation platform designed specifically for independent pharmacies. It completes reconciliation in under 3 minutes, automatically detects NDC swaps across manufacturers, and provides insurance-level analytics by PBM and BIN number. Its NDC matching has 100% match accuracy (figure stated by RxDelta). Pricing starts at $199/month with no long-term contracts. Compatible with PrimeRx, Liberty, Pioneer Rx, Rx30, Computer-Rx, BestRx, QS/1, McKesson, and any system that exports CSV. Trusted by 50+ pharmacies with $2.4M+ recovered. **Advantages:** - Under 3 minutes per reconciliation - Automatic NDC swap detection - Transparent public pricing - Works with 8+ pharmacy systems with zero manual field mapping - 100% NDC match accuracy (figure stated by RxDelta) - $2.4M+ recovered for 50+ pharmacies - No long-term contracts ### Manual Spreadsheets - Free But Costly in Missed Revenue Spreadsheet reconciliation costs 4-6 hours per reconciliation (about 20 hours a month when done weekly) with 85-92% accuracy. It cannot detect NDC swaps and misses 2-5% of revenue in undetected discrepancies. For a $300,000/month pharmacy, that is $6,000-$15,000/month in lost revenue. ### In-House Staff - Expensive and Not Scalable A dedicated reconciliation specialist costs $40,000-$60,000/year plus benefits. They face the same speed and NDC swap detection limitations as spreadsheets, with single-point-of-failure risk. *Full comparison: https://rx-delta.com/compare/best-pharmacy-reconciliation-software* --- ## Best PBM Audit Defense Software (2026) PBM audit defense has two complementary layers: a legal layer (audit-defense law firms that read your PBM contract, contest clawbacks, and represent you in appeals) and a data layer (reconciliation and evidence software that documents every claim, detects NDC swaps, and produces the evidence both you and counsel rely on). RxDelta is the data layer - it does not replace audit-defense counsel, it makes that counsel more effective and far less expensive by handing them a complete, time-stamped record instead of a scramble to reconstruct months of claims. ### Common PBM audit triggers - High-dollar and high-volume claims - Unusual NDC usage, including billing an NDC that differs from purchase records (often an undetected NDC swap) - Refill-too-soon and day-supply mismatches - Dispense-as-written (DAW) code patterns - Deviation from peer pharmacies on cost, mix, or volume - Random contractual sampling ### Why an audit is an evidence problem Every flagged claim asks one question: can you prove it was billed for a drug you actually purchased and dispensed at the correct quantity? Winning means producing a claim-level record linking billing, purchasing, and reimbursement - with NDC swaps resolved via family mapping so an apparent discrepancy is shown to be the same therapeutic product. Pharmacies that reconcile continuously have this evidence ready; pharmacies that do not must reconstruct it under a 14 to 30 day appeal window. ### PBM clawback recovery (summary playbook) 1. Read the finding precisely - identify which claims were recouped and why. 2. Pull claim-level evidence: purchase invoice with the exact NDC acquired, dispensing record, reimbursement detail, DAW documentation. 3. File the appeal within the contractual window (often 30 days), with counsel arguing the case and software supplying the evidence. 4. Track the recovery on future remittances to confirm reversed amounts post. 5. Prevent the next round by reconciling every cycle and detecting NDC swaps automatically. *Full pillar: https://rx-delta.com/compare/best-pbm-audit-defense-software* --- ## NDC Swap Detection Software (2026) An NDC swap occurs when the same medication is recorded under different National Drug Code (NDC) numbers across a pharmacy's billing claims and purchase records - usually because a manufacturer changed or a wholesaler substituted an equivalent generic from a different labeler. The drug is identical; only the NDC differs. To a naive exact-match reconciliation, that looks like a shortage on the billed NDC and an overage on the purchased NDC. Both are phantom, and both hide the real discrepancies that actually cost money. ### Why one drug can have 20+ NDC codes The NDC's first segment (labeler code) is unique to each manufacturer. When a drug goes generic, many manufacturers produce it, each with its own labeler code. Add separate product codes per strength and package codes per bottle size, and a single common generic can carry 20 or more distinct NDCs - none of them an error, every shift between them a potential swap. ### Why spreadsheets cannot catch swaps Spreadsheet reconciliation matches on the exact 11-digit NDC string. When the billed and purchased NDCs differ, it reports a phantom shortage and a phantom overage. Catching swaps by hand would require maintaining a constantly updated map of every drug family across every manufacturer - impractical at real volume. ### How automated NDC swap detection works 1. Normalize every NDC to a consistent 11-digit format. 2. Group NDCs into drug families so all manufacturer versions of the same product are equivalent. 3. Match billing against purchasing at the family level, so a manufacturer swap pairs cleanly. 4. Flag only true discrepancies - genuine shortages, overages, and billing errors. ### NDC swaps vs true shortages A swap is a phantom: the drug was purchased and dispensed under a different NDC. A true shortage is real: you billed for a quantity you did not purchase. They look identical on an exact-match report. Family-level reconciliation resolves swaps automatically and still surfaces genuine shortages - including partial shortages where a drug was both swapped and short. ### The hidden cost of an undetected swap One swap produces two phantom line items. Across thousands of claims and hundreds of multi-source generics, that is dozens to hundreds of phantom discrepancies per cycle. The cost is wasted staff time, real shortages hidden in the noise and left unrecovered, and weaker audit defense. Across RxDelta's 50+ pharmacies, automated reconciliation has surfaced $2.4M+ in recovered discrepancies that undetected swaps had helped hide. *Full pillar: https://rx-delta.com/compare/ndc-swap-detection-software* --- ## Research & Data RxDelta publishes original research and data analysis on pharmacy billing trends, PBM reimbursement patterns, and revenue recovery benchmarks across independent pharmacies. *Explore our research: https://rx-delta.com/research* --- ## Pharmacy Glossary **Pharmacy Billing Reconciliation**: The process of comparing pharmacy dispensing and billing records against purchase invoices and PBM remittance data to verify every prescription was billed correctly, reimbursed at the right amount, and that purchasing costs align with dispensing records. **NDC Swap (NDC)**: When the same medication is billed under different National Drug Code (NDC) numbers in billing versus purchasing data, typically caused by manufacturer changes, wholesaler substitutions, or repackaging. NDC swaps create phantom shortages and surpluses that silently drain revenue. **National Drug Code (NDC)**: The unique identifier of a specific listed drug product and package in the United States: 10 digits in three segments (4-4-2, 5-3-2, or 5-4-1). The FDA assigns the labeler code, the company the product and package codes; pharmacy billing uses an 11-digit 5-4-2 form with a leading zero added to the short segment: 5 digits for the labeler (manufacturer), 4 digits for the product (strength, dosage form), and 2 digits for the package size. **PBM (PBM)**: Pharmacy Benefit Manager - a third-party administrator that manages prescription drug benefits on behalf of health insurers, employer groups, and government programs. PBMs negotiate drug prices, process claims, and determine reimbursement rates for pharmacies. **BIN Number (BIN)**: Bank Identification Number - a 6-digit code on pharmacy benefit cards that identifies the PBM or claims processor responsible for adjudicating a prescription claim. Used to route claims to the correct payer during real-time adjudication. **Claims Adjudication**: The real-time process by which a PBM evaluates a pharmacy claim at the point of sale to determine coverage, copay amount, and reimbursement. Adjudication checks patient eligibility, formulary status, drug interactions, prior authorizations, and pricing in milliseconds. **Remittance**: The payment and associated documentation sent by a PBM or insurer to a pharmacy for processed claims. Remittance advice (RA) details each claim paid, the reimbursement amount, any adjustments, and the total payment. Comparing remittance data against billing records is essential for reconciliation. **DIR Fees (DIR)**: Direct and Indirect Remuneration fees - retroactive charges imposed by PBMs on pharmacies, typically assessed after the point of sale based on performance metrics or contractual terms. DIR fees reduce the effective reimbursement pharmacies receive and can turn profitable prescriptions into losses. **Variance**: The numerical difference between expected and actual values in pharmacy billing reconciliation. A positive variance (surplus) means more units were purchased than billed; a negative variance (shortage) means more units were billed than purchased. Variances indicate potential billing errors, theft, or data entry mistakes. **Shortage**: A reconciliation result where the billed quantity for a drug exceeds the purchased quantity, indicating more was dispensed than acquired. Shortages may result from unrecorded purchases, NDC swaps, theft, or billing errors. Persistent shortages signal revenue leakage. **Overage**: A reconciliation result where the purchased quantity for a drug exceeds the billed quantity, meaning more was bought than dispensed. Overages may indicate unbilled prescriptions, data entry errors, or inventory accumulation. Significant overages represent tied-up capital. **AWP (AWP)**: Average Wholesale Price - a benchmark price for prescription drugs published by pricing compendia like Medi-Span and First Databank. Often called the 'sticker price' of drugs, AWP serves as the basis for many PBM reimbursement calculations (e.g., AWP minus a percentage discount). **WAC (WAC)**: Wholesale Acquisition Cost - the manufacturer's list price to wholesalers, before any discounts or rebates. WAC is considered a more transparent benchmark than AWP and is increasingly used as the basis for drug pricing and reimbursement calculations. **MAC Pricing (MAC)**: Maximum Allowable Cost - the highest reimbursement amount a PBM will pay for a generic or multi-source drug. MAC lists are created by PBMs and may not reflect actual pharmacy acquisition costs, often resulting in below-cost reimbursements for independent pharmacies. **Formulary**: A list of prescription drugs covered by a health plan or PBM, typically organized into tiers that determine patient copay amounts. Tier 1 (preferred generics) has the lowest copays, while higher tiers (specialty, non-preferred brands) have higher costs. Formulary placement significantly affects prescription volume. **Prior Authorization (PA)**: A requirement by the PBM or health plan that a prescriber obtain approval before a specific medication will be covered. Prior authorizations are used for high-cost drugs, non-preferred medications, and specialty therapies. They add administrative burden and can delay patient access. **340B Program (340B)**: A federal drug pricing program (Section 340B of the Public Health Service Act) that requires drug manufacturers to provide outpatient drugs at significantly reduced prices to eligible healthcare organizations (covered entities). 340B pricing can be 25-50% below AWP. **NCPDP (NCPDP)**: National Council for Prescription Drug Programs - the standards organization that creates and maintains the electronic data interchange standards used in pharmacy claims processing. The NCPDP Telecommunication Standard (D.0) is the universal format for real-time pharmacy claims. **Third-Party Payer**: Any entity other than the patient that pays for prescription drug costs, including commercial insurers, PBMs, Medicare Part D plans, Medicaid, and employer-sponsored health plans. In the U.S., third-party payers cover approximately 90% of all prescription transactions. **Copay (Copay)**: A fixed dollar amount a patient pays out-of-pocket for a prescription at the point of sale. Copay amounts are determined by the drug's formulary tier and the patient's health plan. Common copay structures: $10 for Tier 1 generics, $35 for Tier 2 preferred brands, $75+ for Tier 3 non-preferred. **Coinsurance**: A percentage of the prescription drug cost that the patient pays out-of-pocket (e.g., with 20% coinsurance, the patient pays 20% of the cost and the insurer covers the other 80%). More common for specialty drugs and higher formulary tiers than flat copays. **Deductible**: The amount a patient must pay out-of-pocket for prescription drugs before their insurance coverage begins. During the deductible phase, the patient pays the full negotiated price. Common pharmacy deductibles range from $250 to $2,000 per year. **GER (GER)**: Generic Effective Rate - a metric that measures the average reimbursement a pharmacy receives for generic drugs as a percentage of a benchmark price (usually AWP). Used to evaluate PBM contract competitiveness. A GER of AWP-85% means the pharmacy is reimbursed at 15% of AWP. **Generic Substitution**: The practice of dispensing a generic equivalent instead of a brand-name drug. State laws regulate when substitution is permitted. Generic substitution increases pharmacy margins (generics typically have higher markups) and reduces costs for patients and insurers. **DAW Code (DAW)**: Dispense As Written - a code on a prescription claim that indicates whether brand or generic substitution was requested. DAW 0 means substitution is allowed; DAW 1 means the prescriber requested brand only; DAW 2 means the patient requested brand. DAW codes affect reimbursement and patient cost. **PCN (PCN)**: Processor Control Number - an additional identifier on pharmacy benefit cards used alongside the BIN number to route claims to the correct processor or plan within a PBM. The BIN identifies the PBM, while the PCN identifies the specific processing path. **Group Number**: An identifier on a pharmacy benefit card that specifies the employer group or plan under which the patient is covered. Used during claims adjudication to determine the correct formulary, copay structure, and network rules for the claim. **Acquisition Cost**: The actual price a pharmacy pays to purchase a drug from a wholesaler or manufacturer, including all discounts and rebates. Actual acquisition cost (AAC) is the most accurate measure of pharmacy drug costs and is increasingly used by state Medicaid programs for reimbursement. **U&C Price (U&C)**: Usual and Customary Price - the cash price a pharmacy charges to a customer without insurance. PBMs reimburse at the lower of the contracted rate or the U&C price. Pharmacies must report accurate U&C prices; inflated prices can trigger audits and penalties. **Clawback**: When a PBM retroactively recovers money from a pharmacy after the point of sale. Clawbacks occur through DIR fees, audit recoveries, or pricing adjustments. They reduce the pharmacy's effective reimbursement below what appeared at the time of dispensing. **Step Therapy**: A utilization management protocol requiring patients to try one or more lower-cost medications before the PBM will cover a higher-cost alternative. Also called 'fail first' policies. Common in managing high-cost therapeutic categories. **Dispensing Fee**: The professional fee paid to a pharmacy for each prescription dispensed, separate from the drug ingredient cost. Dispensing fees cover the pharmacist's professional services, overhead, and operational costs. Typical dispensing fees range from $1 to $15 depending on the payer. **ERA (ERA)**: Electronic Remittance Advice - the electronic version of a payment explanation sent from a PBM or insurer to a pharmacy. ERAs detail each claim's reimbursement, adjustments, and denial reasons, enabling automated posting of payments to pharmacy management systems. **Inventory Management**: The systematic process of ordering, storing, tracking, and dispensing pharmaceutical inventory. Effective inventory management minimizes carrying costs, reduces expired product waste, ensures adequate stock levels, and supports accurate reconciliation. **Wholesaler**: A pharmaceutical distributor that purchases drugs from manufacturers and sells them to pharmacies, hospitals, and other healthcare facilities. The three largest wholesalers (McKesson, AmerisourceBergen/Cencora, Cardinal Health) distribute approximately 90% of all pharmaceuticals in the U.S. **PBM Audit**: A review of pharmacy records conducted by or on behalf of a PBM to verify the accuracy of claims submitted. Audits check prescription validity, dispensing records, pricing accuracy, and regulatory compliance. Failed audits can result in financial recoupments and network termination. **Reimbursement**: The payment a pharmacy receives from a PBM, insurer, or government program for dispensing a prescription. Reimbursement typically equals the ingredient cost (based on AWP, WAC, or MAC) plus a dispensing fee, minus the patient's copay. The difference between reimbursement and acquisition cost determines pharmacy margin. **Point of Sale (POS)**: The moment when a prescription is processed and adjudicated in real time at the pharmacy counter. POS adjudication occurs via electronic communication between the pharmacy system and the PBM, determining coverage, copay, and reimbursement within seconds. **Carrier**: The insurance company or entity that provides the pharmacy benefit to the patient. In claims processing, the carrier is identified by the BIN number on the benefit card. Multiple carriers may use the same PBM for claims processing. **Labeler Code**: The first 5 digits of a National Drug Code (NDC) that identify the manufacturer, repackager, or distributor of the drug. Assigned by the FDA. Each labeler receives a unique code; changes in labeler codes are a primary cause of NDC swaps during reconciliation. **Pharmacy Management System (PMS)**: Software used by pharmacies to manage dispensing operations, patient records, claims processing, inventory, and reporting. Common systems include PrimeRx, Liberty, Pioneer, Rx30, Computer-Rx, and BestRx. Data exported from these systems is used for billing reconciliation. **PrimeRx**: A widely-used pharmacy management system developed by Micro Merchant Systems, popular among independent pharmacies. PrimeRx handles dispensing, claims adjudication, inventory management, and reporting. Its CSV export format is commonly used for reconciliation workflows. **Therapeutic Equivalence**: The FDA designation that two drug products contain the same active ingredient, dosage form, strength, and route of administration, and are expected to produce the same clinical effect. Therapeutically equivalent drugs may have different NDC codes, which can cause NDC swap issues in reconciliation. **Narrow Network**: A pharmacy network created by a PBM that limits the number of participating pharmacies, often excluding independent pharmacies in favor of chain or PBM-owned pharmacies. Narrow networks reduce patient choice but can lower costs for the plan sponsor. **Spread Pricing**: A PBM practice where the PBM charges the health plan a higher price for a drug than it reimburses the pharmacy, keeping the difference (the 'spread') as profit. Spread pricing is increasingly criticized for lack of transparency and has been banned by several states. **Medication Adherence**: The extent to which patients take medications as prescribed by their healthcare providers. Measured by metrics like PDC (Proportion of Days Covered) and MPR (Medication Possession Ratio). PBMs use adherence metrics in quality programs and DIR fee calculations. **Star Ratings**: CMS (Centers for Medicare and Medicaid Services) quality ratings for Medicare Part D plans, scored 1-5 stars. Pharmacy performance metrics like medication adherence and generic dispensing rates contribute to plan Star Ratings. Higher ratings result in bonuses; lower ratings can trigger penalties. **Specialty Pharmacy**: A pharmacy that dispenses high-cost, complex medications requiring special handling, storage, or patient monitoring. Specialty drugs often cost $1,000+ per month and treat conditions like cancer, rheumatoid arthritis, and multiple sclerosis. Specialty pharmacy represents over 50% of total drug spending. **Revenue Leakage**: Revenue that a pharmacy should have collected but didn't due to billing errors, PBM underpayments, undetected NDC swaps, missed claims, or uncollected copays. Revenue leakage is often invisible without systematic reconciliation and typically represents 2-5% of prescription revenue for independent pharmacies. **Batch Reconciliation**: The process of reconciling pharmacy billing data in bulk, typically covering a specific time period (weekly, monthly, or quarterly). Batch reconciliation compares aggregate billing and purchasing data rather than individual transactions, identifying patterns and trends across thousands of claims simultaneously. **Drug Utilization Review (DUR)**: A program that evaluates prescription drug use to ensure medications are appropriate, medically necessary, and unlikely to cause adverse effects. DUR checks occur during claims adjudication (prospective DUR) and through retrospective analysis of claims data. **Multi-Source Drug**: A drug available from multiple manufacturers, typically a generic drug produced by several generic companies. Multi-source drugs are subject to MAC pricing by PBMs and are a common source of NDC swaps because each manufacturer's version carries a different NDC. **Pass-Through Pricing**: A PBM pricing model where the health plan pays the pharmacy the exact same amount the PBM reimburses, plus a transparent administrative fee. Eliminates spread pricing. Increasingly demanded by employers and legislated by states seeking PBM transparency. **Pharmacy Claims Data**: The electronic records generated when prescriptions are adjudicated, containing the drug NDC, quantity, days supply, prescriber, patient, payer, reimbursement amount, and copay. Claims data is the foundation of pharmacy billing reconciliation and analytics. *Full glossary with detailed articles: https://rx-delta.com/glossary* --- ## Links - [Homepage](https://rx-delta.com) - [Pricing](https://rx-delta.com/pricing) - [Blog](https://rx-delta.com/blog) - [Newsletter](https://rx-delta.com/newsletter) - [Integrations](https://rx-delta.com/integrations) - [About RxDelta](https://rx-delta.com/about) - [Free Pharmacy Tools](https://rx-delta.com/tools) - [NABP Wholesaler Verifier](https://rx-delta.com/tools/nabp-wholesaler-verifier) - [Audit Readiness Scorecard](https://rx-delta.com/tools/audit-readiness-scorecard) - [Revenue Leakage Calculator](https://rx-delta.com/tools/revenue-leakage-calculator) - [NDC Code Explained](https://rx-delta.com/tools/ndc-lookup) - [NPI Lookup](https://rx-delta.com/tools/npi-lookup) - [Pharmacy Glossary](https://rx-delta.com/glossary) - [Research & Data](https://rx-delta.com/research) - [Automated vs Manual Reconciliation](https://rx-delta.com/compare/automated-vs-manual-pharmacy-reconciliation) - [RxDelta vs Spreadsheets](https://rx-delta.com/compare/rxdelta-vs-spreadsheet-reconciliation) - [Best PBM Audit Defense Software](https://rx-delta.com/compare/best-pbm-audit-defense-software) - [NDC Swap Detection Software](https://rx-delta.com/compare/ndc-swap-detection-software) - [Blog RSS Feed](https://rx-delta.com/blog/feed.xml) - [Newsletter RSS Feed](https://rx-delta.com/newsletter/feed.xml) - [Privacy Policy](https://rx-delta.com/privacy) - [Terms of Service](https://rx-delta.com/terms)