Skip to content

RxDelta for Rx30 Pharmacies

Rx30, part of the Transaction Data Systems (TDS) family, serves a large base of independent pharmacies across the United States. RxDelta handles Rx30's export formats including their prescription-level billing data and wholesaler purchasing reports. Upload your Rx30 exports and get actionable insights in under 3 minutes.

Vendor: Transaction Data Systems (TDS)

< 3 min
Reconciliation time
100%
NDC match accuracy, stated by RxDelta
$0
Setup / mapping

How to Export from Rx30

  1. In Rx30, open the Report Builder
  2. Generate a billing or claims report for your target date range
  3. Export the report as CSV
  4. Generate a purchasing/wholesaler report for the same period
  5. Upload both CSV files to RxDelta

Setup and Time

What you export
A claims report (what you billed) and a purchase report (what you bought) for the same dates. From Rx30: CSV export from Report Builder.
File types
CSV or Excel (.xlsx or .xls), uploaded as exported.
Install
Nothing to install. RxDelta runs in your web browser and does not connect to Rx30: you upload the files you export.
Column matching
Automatic when RxDelta recognizes your column names. When it cannot match a needed column by name, the mapping step shows your columns so you can pick it.
Time to first report
Under 3 minutes after upload.

Columns You May Need to Match During Setup

When you upload your Rx30 files, RxDelta matches these columns by their names. A file needs the columns marked required; if one is not matched, the mapping step lets you pick it. These are the columns the mapping step shows, not every column RxDelta reads: it also recognizes others by name, such as days supply, when your export has them.

Claims file

Required

  • NDC: Unique 11-digit drug identifier - lets us match billing claims to the exact product purchased.
  • Drug Name: Human-readable drug name shown next to each NDC in the report and tooltips.
  • Date: When the prescription was filled - drives the timeline and the per-day reconciliation window.
  • Quantity: Number of units billed or purchased - the core input to every variance calculation.

Read when present

BIN, Rx Number, Package Size, Amount Paid ($), PCN, Group Number, Insurance Name, Brand/Generic, Secondary Paid, Secondary BIN, Secondary PCN, Secondary Group

Purchase file

Required

  • NDC: Unique 11-digit drug identifier - lets us match billing claims to the exact product purchased.
  • Drug Name: Human-readable drug name shown next to each NDC in the report and tooltips.
  • Date: When the wholesaler shipped the product - aligns purchases with billing dates for shortage math.
  • Quantity: Number of units billed or purchased - the core input to every variance calculation.

Read when present

Unit Cost ($), Total Cost ($), Invoice #, Package Size, Wholesaler

The RxDelta column-mapping step for an uploaded claims file: all 16 fields matched, with a preview of the first five rows. Westside Rx demo data.The RxDelta column-mapping step for an uploaded claims file: all 16 fields matched, with a preview of the first five rows. Westside Rx demo data.The RxDelta column-mapping step for an uploaded claims file: all 16 fields matched, with a preview of the first five rows. Westside Rx demo data.
The column-mapping step after a claims file upload, with every column matched automatically. Westside Rx, demo data. Select the picture to open it full size.

What RxDelta Does with Your Rx30 Data

  • Automatic recognition of Rx30 Report Builder column headers
  • Prescription-level billing export processing
  • Wholesaler purchase order data reconciliation
  • Insurance claim analytics by PBM and BIN
  • NDC swap detection across Rx30 billing data
  • Shortage and overage flagging

Frequently Asked Questions

Yes. RxDelta processes Rx30 CSV exports from the Report Builder with automatic column detection. Matching is automatic when the column names are recognized; an unmatched required column can be picked by hand in the mapping step.

Yes. RxDelta's multi-pharmacy support handles Rx30 exports from multiple locations, consolidating all reconciliation data into a single dashboard with group-level analytics.

Besides common names such as NDC, Drug Name and Date Filled, RxDelta's header detection includes the Rx30 header forms RxNbr (Rx number), Qty Dsp (quantity), DS Days (days supply), P1 BIN and P1 Paid (primary insurance), and P2 BIN and P2 Paid (secondary insurance). If a needed column is still not matched, the mapping step lets you pick it.

Start Reconciling Your Rx30 Data

Upload your Rx30 CSV exports. Nothing to install: columns are matched automatically when RxDelta recognizes them, and you pick any required column it misses. Results in under 3 minutes.

Not using Rx30? See all compatible pharmacy systems