Most multi-site rehab owners run the group from a stack of per-location exports that never quite line up. The executive scorecard is the antidote: one screen with the headline metric from every pillar — reimbursement, productivity, capacity, attendance, completion, and growth — for the whole organization, plus a side-by-side ranking of every clinic on the same measures.
What this report answers
The Site Scorecard page is a matrix with one row per clinic and a column for each headline rate: net revenue, net collection rate, visits per therapist per day, schedule fill rate, no-show+cancel rate, POC completion rate, and referral-to-start rate — with all-sites roll-up KPI cards and bars of net revenue and fill rate by site beneath it. The Pillar Comparison page puts the visits-per-day and referral-to-start headlines on cards, then uses a clustered bar to compare every clinic across the five pillar rates and a line to trend net revenue by month per site. Together they answer the owner's weekly question: which sites lead, which lag, and on which metric?
The metrics that matter
The metrics in a rehab group are interlinked: schedule fill and attendance drive visits per therapist per day; productivity and collection drive net revenue; referral conversion drives the pipeline that feeds all of it. Looked at in isolation each site looks fine; looked at side by side the story emerges — a site with strong productivity but a low collection rate has a billing problem, not a clinical one. The gap between your best and worst clinic on any single rate is usually the biggest, most addressable opportunity in the business.
Why the data is trapped across the systems
Each clinic's revenue, schedule, attendance, completion, and referral data lives in its own instance of Prompt, Raintree, Net Health / Clinicient, WebPT, TheraOffice, Jane, or Fusion — and the canned reports stop at a single location. There is no native cross-site roll-up, so building the group view today means exporting every site and reconciling them by hand. Modeling the per-site-per-month summary into one comparable scorecard is exactly what this template does.
How to read it
Read the matrix across each rate to rank the sites, and compare on rate-based metrics (collection rate, fill rate, completion rate) rather than raw totals so a large and a small clinic sit on the same footing. The clustered pillar comparison tells you which one report to open next for the site that's behind. The sample uses fully synthetic, anonymized site data — no PHI — so you can see the finished layout before bringing your own.
Metrics it tracks
| Metric | What it means |
|---|---|
| Net Revenue | Net revenue collected, rolled up across sites and shown per site in the matrix. |
| Net Collection Rate | Payments collected ÷ allowed amount, per site — the revenue-cycle headline. |
| Visits Per Therapist Per Day | Visits seen ÷ therapist clinic-days, per site — the productivity headline. |
| Schedule Fill Rate | Filled slots ÷ available slots, per site — the capacity headline. |
| No-Show + Cancel Rate | Cancelled and no-show appointments ÷ scheduled, per site — the attendance headline. |
| Referral-to-Start Rate | Started-care referrals ÷ referrals received, per site — the growth headline. |
Used by: Multi-site clinic owner and director of operations
Frequently asked questions
What KPIs should a multi-site rehab owner track weekly?
The headline set spans every pillar: net revenue and net collection rate (reimbursement), visits per therapist per day (productivity), schedule fill rate (capacity), no-show+cancel rate (attendance), plan-of-care completion rate (outcomes), and referral-to-start rate (growth). The executive scorecard puts all of them on one screen and ranks every clinic on the same measures.
How do I compare clinics of different sizes fairly?
Use rate-based metrics — collection rate, fill rate, no-show+cancel rate, completion rate, referral-to-start rate — rather than raw totals, so a large and a small site can be compared on the same footing. The scorecard's by-site matrix is built around these ratios for exactly that reason, with net revenue shown alongside as the volume context.
Why can't I get this view out of my EMR today?
Because each clinic's data lives in its own instance, and platforms like Prompt, Raintree, Net Health, WebPT, TheraOffice, Jane, and Fusion report per location with no native multi-site roll-up. Building the group scorecard means exporting every site and modeling a comparable summary — which is precisely what this template automates.
Build this report on your own data
Clone this Rehab therapy 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 →