Billing & Claims

What is 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.

Pharmacy billing reconciliation is the cornerstone of financial health for independent pharmacies. Without regular reconciliation, pharmacies routinely lose 2-5% of their prescription revenue to billing discrepancies, PBM underpayments, and undetected errors.

Why Reconciliation Matters

For a pharmacy processing $300,000 per month in prescription revenue, a 3% discrepancy rate translates to $9,000 per month - or $108,000 per year - in lost revenue. These losses are often invisible because they occur across thousands of individual transactions.

The Reconciliation Process

A complete reconciliation cycle involves three key comparisons:

  1. Billing vs. Purchasing: Comparing what was dispensed and billed to insurers against what was purchased from wholesalers
  2. Billing vs. Remittance: Verifying that PBM payments match the expected reimbursement amounts
  3. Inventory vs. Records: Ensuring physical inventory aligns with recorded dispensing and purchasing activity

Common Discrepancies Found

  • NDC swaps: The same drug billed under different NDC codes, creating phantom shortages
  • Quantity variances: Differences between billed quantities and purchased quantities
  • Price discrepancies: Reimbursement amounts that don't match contracted rates
  • Missing claims: Prescriptions dispensed but never billed or reimbursed

Manual vs. Automated Reconciliation

Traditional manual reconciliation using spreadsheets takes 4-6 hours per cycle and cannot reliably detect NDC swaps. Automated platforms like RxDelta complete the same analysis in under 3 minutes with 98%+ accuracy, including automatic swap detection and insurance-level breakdowns.

Related Terms

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.

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.

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.

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.

Automate Your Pharmacy Reconciliation

RxDelta handles NDC matching, swap detection, and variance analysis automatically - so you can focus on patients, not spreadsheets.

Get StartedView Pricing