Most multi-store independent owners run the business from a stack of single-store exports that never quite line up. The executive scorecard is the antidote: one screen with every store's headline metric — margin, volume, generic rate, inventory turns, adherence, and below-cost loss — side by side, so the strongest and weakest locations are obvious at a glance.
What this report answers
Which store leads, which lags, and on what? The Store Scorecard page carries six top-line KPIs — total net reimbursement, total gross profit, blended net margin rate, total scripts filled, generic dispensing rate, and underwater loss dollars — over a one-row-per-store table that lines up every pillar's headline measure per location: scripts filled, net reimbursement, gross profit, net margin, GDR, inventory turn rate, underwater loss, PDC adherence, and clinical revenue. Bars rank gross profit, net margin, and underwater loss by store.
The metrics that matter
Blended net margin rate is the chain's health number, but the per-store row is where decisions live — a store with strong volume and weak margin has a contract or below-cost problem, not a traffic problem. Underwater loss dollars by store flags where the Below-Cost Claims report should be opened next. Generic dispensing rate by store separates the locations leaving margin and star points on the table. The gap between the best and worst store on any metric is usually the biggest addressable opportunity in the business.
Why the data is trapped across the systems
A multi-store view is the hardest join of all: each store's dispensing data (often the same platform, sometimes mixed), each store's PBM remittances, and each store's wholesaler cost, all reconciled to comparable per-store metrics. Even owners running PioneerRx across every site can't get net-margin-after-DIR, GDR, turns, and underwater loss on one comparable screen without exporting and aligning every store by hand.
How to read it
Read down the KPI strip for the chain, then across the store table for outliers. Use rate metrics — net margin, GDR, adherence, turn rate — to compare a large store and a small one fairly, since totals just reflect size. A store lagging the others on one metric is a targeted fix, not a company-wide program; the scorecard's job is to tell you which store, and which single-store report, to open next.
The sample uses synthetic stores and made-up figures — no real data.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Net Reimbursement | Net reimbursement across all stores in the period. |
| Total Gross Profit | Gross profit across all stores. |
| Blended Net Margin Rate | Total gross profit ÷ total net reimbursement across all stores. |
| Total Scripts Filled | Scripts filled across all stores. |
| Generic Dispensing Rate | Generic scripts ÷ substitutable scripts across all stores. |
| Underwater Loss Dollars | Below-cost claim losses across all stores. |
Used by: Multi-store owners and pharmacists-in-charge comparing every location on one screen
Frequently asked questions
What should a multi-store pharmacy owner track weekly?
The headline set spans every pillar: net reimbursement and gross profit (revenue), blended net margin rate (profitability), scripts filled (volume), generic dispensing rate (margin and quality), and underwater loss dollars (below-cost leakage) — plus inventory turns, adherence, and clinical revenue per store. The scorecard puts all of them on one screen and compares them across locations.
How do I compare stores of different sizes fairly?
Use rate-based metrics — net margin rate, generic dispensing rate, adherence rate, inventory turn rate — rather than raw totals, so a large store and a small one sit on the same footing. The per-store table is built around these ratios for exactly that reason.
Can I build this across my own stores' data?
Yes. Export each store's dispensing, PBM remittance, and wholesaler cost data and use this as a template — we model comparable per-store metrics into a Power BI report. The sample is fully synthetic, so there's no PHI here.
Build this report on your own data
Clone this Independent pharmacies template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →