Know your margin on every script, PBM by PBM
Connect your pharmacy system's database, or upload its reports, and ask in plain English: scripts per pharmacist, margin by PBM, rejected claims and their codes, reversals, dead stock and refills due.
For independent and specialty pharmacies, and small pharmacy chains.
Free plan. No credit card required.
Gross margin per script by PBM last quarter: which plans pay under cost?
AI Analyst
PBM C paid under cost last quarter: −$1.10 a script across 1,960 scripts, a $2,156 loss. Across all payers the pharmacy kept $6.65 a script.
| Payer | Scripts | Margin | Per script |
|---|---|---|---|
| PBM A | 4,820 | $38,560 | $8.00 |
| PBM B | 3,140 | $11,932 | $3.80 |
| PBM C | 1,960 | −$2,156 | −$1.10 |
| State Medicaid | 2,210 | $23,205 | $10.50 |
| Cash | 640 | $13,440 | $21.00 |
Readclaimsfillsdrug_costsSQL
Keep itPin to dashboardEmail it weeklyAlert me
Every question, by who asks it
Taken from what teams in this industry ask Supaboard. Each one opens a free account with the question waiting.
01 · Dispensing and refills
- Scripts per day and per pharmacist last week, by storeAsk this: Scripts per day and per pharmacist last week, by store
- Filled scripts waiting more than 10 days to be picked upAsk this: Filled scripts waiting more than 10 days to be picked up
- Refills more than 7 days past due with no fill since, by drug classAsk this: Refills more than 7 days past due with no fill since, by drug class
- Patients under 80% PDC this year on statins, diabetes drugs or RAS antagonistsAsk this: Patients under 80% PDC this year on statins, diabetes drugs or RAS antagonists
02 · Claims and margin
- Rejected claims last month, and the NCPDP reject codes behind themAsk this: Rejected claims last month, and the NCPDP reject codes behind them
- Gross margin per script by PBM last quarter: which plans pay under cost?Ask this: Gross margin per script by PBM last quarter: which plans pay under cost?
- Reversals last month, and how many scripts went back to stockAsk this: Reversals last month, and how many scripts went back to stock
03 · Stock and purchasing
- Inventory days on hand by category, and stock with no dispensing in 180 daysAsk this: Inventory days on hand by category, and stock with no dispensing in 180 days
- Drugs whose acquisition cost rose more than 10% on the last invoiceAsk this: Drugs whose acquisition cost rose more than 10% on the last invoice
- The 20 NDCs with the highest acquisition cost last quarter, and their margin per scriptAsk this: The 20 NDCs with the highest acquisition cost last quarter, and their margin per script
Keep it running
What teams keep on a schedule once they've asked the question once.
Report · Daily 07:30
The morning list
Rejected claims still open, refills past due and scripts waiting more than 10 days, in the pharmacist in charge's inbox before the doors open.
- Timed Start
- Query Your Data
- Summarize Insights
- Send Email
Alert · Every 5 minutes
Under-cost claim watch
A SQL check on the pharmacy database finds any claim paid below the drug's acquisition cost and emails the owner the NDC, the PBM and the gap.
- Alerts
- Send Email
Datasite · Month end
The owners' datasite
Margin by PBM, scripts per store and dead stock on a private datasite the owners sign in to with Google or Microsoft.
The numbers it keeps watch on
Standard definitions, and where each one lives in Supaboard once you've asked for it.
| Measure | Definition | Source | In Supaboard |
|---|---|---|---|
| Scripts per pharmacist | Scripts filled ÷ pharmacist days on shift, per store | Common practice | Weekly report, by store |
| Gross margin per script | (Plan paid + patient copay − acquisition cost) ÷ scripts | Common practice | Monthly report, by PBM |
| Claim reject rate | Claims rejected on first submission ÷ claims submitted, grouped by NCPDP reject code | Common practice | Alert when a PBM jumps |
| Return to stock | Filled scripts not picked up within the contract window, reversed and put back on the shelf | Your PBM contracts | A rule, then a daily list |
| Proportion of days covered (PDC) | Days covered by fills of the drug or its class ÷ days from the first fill to the year's end; 80% or more counts as adherent | Pharmacy Quality Alliance | Monthly outreach list |
| Inventory days on hand | Inventory at cost ÷ average daily cost of drugs dispensed | Common practice | Monthly owners' report |
| Dead stock | Stock at cost with no dispensing in 180 days | Common practice | Ask it each quarter |
| Generic dispensing rate | Generic scripts ÷ all scripts | Common practice | Dashboard, by store |
Where your data lives
Or attach an export to a conversation, as CSV or Excel:
- XLSPharmacy-system reportsUpload
- XLSWholesaler invoice filesUpload
The tables these questions read:
- Prescriptions and fills, with NDC, quantity, days' supply, pharmacist and pickup date
- Claims, with BIN and PCN, amount paid, copay and NCPDP reject codes
- Reversals and return-to-stock records
- Drugs by NDC, with category, class and acquisition cost
- Wholesaler invoices and purchases
- Inventory on hand, by NDC and store
Teach it your definitions once
Rules are read with every question, so a term means the same thing in Chat, in Slack and in the Monday report.
- Rule“A filled script goes back to stock after 10 days without pickup.”
- Rule“Margin per script is plan paid plus copay, minus acquisition cost at the last invoice price.”
- Rule“A reject counts once per script, on its first submission, not on every retry.”
Security
HIPAA BAA
Available on Enterprise. Sign it before patient data goes into Supaboard.
Read-only by construction
Database and warehouse queries are read-only. We give you the SQL for a read-only user too.
Your data region
North America, EU or Asia, chosen when the workspace is created.
Credentials stay in the workspace
Scoped to the one workspace that connected them, never logged and never sent back to a browser.
Frequently asked questions
Does it work with our pharmacy management system?
If your system keeps its data in SQL Server, Postgres or MySQL and you can reach that database, connect it live and read-only. If it only gives you reports, upload one as CSV or Excel and ask about it. To keep the reports current on a schedule, have them copied into a database you connect.
Will Supaboard sign a BAA?
Yes. A HIPAA BAA is available on Enterprise. Prescriptions and claims are protected health information, so sign it before they go into Supaboard.
Can it change anything in our pharmacy system?
No. Database and warehouse queries are read-only. We give you the SQL to create a read-only user. Claims are submitted and reversed in your own system, as they are today.
How does it learn how we count margin?
Write it once as a rule, such as "margin is plan paid plus copay, minus acquisition cost". The agent reads its rules with every question, and you can save reviewed SQL as examples.
Can each store get its own morning list?
Yes. Schedule one report per store at 07:30 in your timezone. Each runs that store's questions, summarises what changed and emails the pharmacist in charge.
More in Healthcare & Life Sciences
- Revenue Cycle ManagementDenials, aging AR, days to bill and client SLAs, from claims and remittance data.
- Medical & Dental PracticesSchedule fill, no-shows, production by provider and collections, from your practice system.
- Senior Care & StaffingAuthorised hours, missed visits, overtime and open shifts, from scheduling and payroll data.
Ask your first question on your own data
Connect a source, ask in plain English, and keep what you find.
Start FreeBook a 30-minute demo
Free plan. No credit card required.