A small urgent care chain doesn't fail all at once — it fails one center at a time, and the laggard hides inside the group total. This dashboard puts every center on one screen, one row each, with the headline KPIs from every other report — throughput, revenue, mix, denials, and productivity — so an owner or regional director can rank performers and spot the outlier in seconds instead of reconciling six spreadsheets.
What this dashboard answers
The executive scorecard page answers the ranking question in a single conditionally formatted matrix: one row per center with visits, net collections, net reimbursement per visit, the <45-minute rate, self-pay share, denial rate, visits per provider-hour, and occ-med revenue share — the weak cells light up so the laggard is obvious. The rank-and-trend page sorts centers by net reimbursement per visit and by the <45-minute rate, and trends net collections by month per center so you can see who is climbing and who is sliding.
The metrics that matter
Net reimbursement per visit and the <45-minute door-to-door rate are the two ranking metrics that capture both sides of the business — the economics of a visit and the experience that drives repeat volume. Self-pay share and denial rate are the risk flags that explain a weak performer. Visits per provider-hour ties efficiency to the labor cost. The point of the scorecard is that no single metric tells the story; seeing all of them in one row per center is what surfaces the center that needs attention.
Why the data is trapped
This is the report that's hardest of all to build by hand, because it pulls from every system at once: visits from Experity, eClinicalWorks, or athenahealth; the <45-minute rate from Solv or Clockwise.MD; net collections and denials from Waystar 835s; productivity from scheduling. Today most operators rebuild it as a monthly spreadsheet where someone copies numbers out of six dashboards into one tab — which is exactly why the comparison is so often late, inconsistent, or skipped.
How to read it
Read the matrix as a heatmap: the center with red cells across reimbursement, the <45-minute rate, and denials is the one to visit this month. Use the ranking bars to confirm the spread — a wide gap between your best and worst center on reimbursement per visit is a coaching opportunity, not a market fact. The per-center monthly net-collections trend tells you whether a weak center is recovering or still sliding.
The sample on this page uses entirely synthetic center-month data — anonymized centers, made-up dollar amounts, no real patient or financial records.
Metrics it tracks
| Metric | What it means |
|---|---|
| Total Visits | Sum of visits across all center-months in the group. |
| Net Collections | Sum of net collections across all center-months. |
| Net Reimbursement per Visit | Net collections ÷ visits — blended realized revenue per visit across the group. |
| <45-Min Door-to-Door Rate | Visits under 45 minutes ÷ visits — the group-wide throughput service level. |
| Group Self-Pay Share | Self-pay visits ÷ visits — group-wide self-pay exposure. |
| Visits per Provider-Hour | Visits ÷ provider hours — group-wide productivity. |
Used by: Owners, medical directors, and regional operations directors ranking every center
Frequently asked questions
Why do urgent care groups need a multi-site scorecard?
A struggling center hides inside the group total. Putting every center on one row — with reimbursement per visit, the <45-minute rate, self-pay share, denials, and productivity side by side — lets an owner or regional director rank performers and find the laggard in seconds instead of reconciling separate reports from each site.
Which metrics belong on an urgent care executive scorecard?
The set that captures the whole business is visits, net collections, net reimbursement per visit, the <45-minute door-to-door rate, self-pay share, denial rate, visits per provider-hour, and occ-med revenue share — one row per center, with conditional formatting so weak cells stand out at a glance.
Can I build this across all my centers' data?
Yes. Export center-level totals from your EMR/PM, clearinghouse, and scheduling systems, and use this as a template. We roll them up to one row per center per month; the sample here uses synthetic data for a small de novo chain so you can see the finished layout first.
Build this report on your own data
Clone this Urgent care 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 →