Scruple

How to export

Pick one. Wholesaler invoices are the easiest start, since they have no patient information. Whatever you send, delete these columns first if they're there:

patient name birthdate address phone member ID Rx number fill date prescriber

Wholesaler invoices start here

From your wholesaler's ordering site, export your invoice or purchase history for the last 3 to 6 months as Excel or CSV. Every line item with its NDC, quantity and price is what we need. Black out your account number and the wholesaler's name if you'd rather; the prices are enough. If you can't find the export, your rep can pull it for you.

What it tells you: whether you pay more than other pharmacies for the same drugs, and which prices went up.

PioneerRx

  1. Go to Analysis › Financial Reports › Rx Transaction Summary by Submission Type.
  2. Pick a date range (90 days is plenty) and run it.
  3. Export to Excel. PioneerRx lets you choose which columns to include, so leave the patient columns out.

What it tells you: what each insurer paid against your cost, by plan.

Report path from PioneerRx's own blog.

BestRx

  1. Go to Report › H. Profit Report.
  2. Pick a date range and run it.
  3. Click Export Data and save as Excel or CSV. Delete the patient columns before you send.

What it tells you: prescriptions paid below what the drug cost you.

From BestRx help.

PrimeRx

  1. Go to Reports › Custom Reports and pick a profit or claims report.
  2. Export it, then delete the patient columns.

Not sure which one? Send the form and we'll find it with you.

Liberty, Rx30, Computer-Rx, QS/1, anything else

We haven't written these up yet. Look for a profit, margin or claims report that shows what the insurer paid and what the drug cost. Or send the form without a file and we'll figure it out with you, by email or on a call.