Template · Published Nov 19, 2026
Medical Practice KPI Dashboard Template: 12 KPIs, Free Excel
For the owner or office manager who wants one monthly view of the practice. You leave with 12 KPIs that come from reports you already have, a red, amber and green line for each, and a workbook that keeps 12 months of trend.
The free Excel workbook: a monthly entry sheet for 16 numbers you already have, 12 KPIs colored red, amber or green, 12 months of trend with six charts, a dollar figure for what no-shows, open slots and recall cost a year, and a 14-case playbook for when a KPI turns red.
Get the free KPI dashboard template (Excel)A medical practice KPI dashboard is one monthly sheet of about 12 numbers, each colored red, amber or green against a line you set: visits, no-shows, schedule fill, phones, recall, revenue per visit, staff cost, overhead and days of cash. MGMA's no-show benchmark was 6.81% in 2023 (MGMA Stat, 2025). Start with the free template below.
Key takeaways
- Costs keep climbing: 84% of medical groups reported higher operating costs in 2026 than in 2025, about 11% on average (MGMA Stat, Jun 2026), after 90% and 11.1% in 2025 (MGMA Stat, Jun 2025).
- Volume is softening: the median primary care physician's encounters fell from 2,971 in 2024 to 2,813 in 2025, and encounters fell in all 23 specialties MGMA tracks (MGMA DataDive, June 2026).
- No-shows are drifting up: 6.81% in 2023 after 5% in 2021 and 2022 (MGMA Stat, Jan 2025), and 32% of groups saw higher no-shows in 2026 (MGMA Stat, Aug 2026).
- Count payroll all in: benefits were 29.6% of total compensation in health care in June 2026 (BLS, 2026), so a wage-only staff cost ratio reads low.
- Cash is the floor: the median small health care services business held 30 days of outflows in cash, and a quarter held 14 or fewer (JPMorgan Chase Institute, 2016; 2015 data).
The 12 KPIs and the line for each
Twelve numbers answer the four questions an owner asks every month: is the schedule full, is the front door working, is the money keeping up with costs, and how long could the practice run on the cash it holds. Each one comes from a report the practice already has: the schedule, the phone system, the recall list, the bank deposits and the payroll register.
| KPI | How to calculate it | Green | Red | Where the line comes from |
|---|---|---|---|---|
| Visits completed | Completed visits, all providers, telehealth appointments included | Within 5% of your 12-month average | More than 10% worse | Your own trend, or your budget |
| Visits per provider day | Visits completed / provider days worked | Within 5% of your 12-month average | More than 10% worse | Your own trend |
| New patients seen | First visits by patients new to the practice | Within 5% of your 12-month average | More than 10% worse | Your own trend |
| No-show rate | No-shows / visits scheduled | 5% or less | Above 7% | MGMA aggregate: 5% in 2021 and 2022, 7% in 2019 (MGMA Stat, 2025) |
| Schedule fill rate | Visits scheduled / slots offered | 95% or more | Under 90% | Our starting target, not a benchmark |
| Phone answer rate | Calls answered live / calls received in open hours | 90% or more | Under 80% | A goal of 10% or fewer missed calls (MGMA, 2023); red is our line |
| Recall completion | Recall patients booked or seen / recall patients due this month | 80% or more | Under 60% | Our starting target, not a benchmark |
| Revenue collected | Money collected for patient care in the month | Within 5% of your 12-month average | More than 10% worse | Your own trend, or your budget |
| Revenue per visit | Revenue collected / visits completed | Within 5% of your 12-month average | More than 10% worse | Your own trend; it depends on visit mix |
| Support staff cost ratio | Support staff pay, payroll taxes and benefits / revenue collected | 25% or less | Above 30% | Roughly a quarter of revenue (MGMA Stat, 2025); red is our line |
| Overhead ratio | Operating costs without provider and owner pay / revenue collected | Within 5% of your 12-month average | More than 10% worse | Your own trend; no free current median |
| Days cash on hand | Cash at month end / (the month's outflows / days in the month) | 30 days or more | Under 14 days | Median and 25th percentile, health care services (JPMorgan Chase Institute, 2016) |
Six lines come from published figures or are labelled as our starting target. The other six have no public line that fits a 1 to 10 provider practice, so the workbook judges them against your own 12-month average: green within 5%, red when more than 10% worse. MGMA's tables lean toward larger groups, and your own trend is the fairer test for counts like visits and revenue.
Worked example: 12 months on the dashboard
Worked example
A 3-physician family practice with one nurse practitioner, about 1,500 visits a month and about $223,000 collected in an average month. The office manager typed 14 months into the workbook, Sep 2025 to Oct 2026. Every number below is the workbook's own output; a worked example, not a client.
| KPI | Oct 2026 | Status | 12-month average | Oct 2025 |
|---|---|---|---|---|
| Visits completed | 1,440 | On target | 1,491 | 1,530 |
| Visits per provider day | 18.0 | Watch | 19.1 | 19.6 |
| New patients seen | 82 | Act | 94 | 98 |
| No-show rate | 7.9% | Act | 6.3% | 4.9% |
| Schedule fill rate | 90% | Watch | 94% | 95% |
| Phone answer rate | 79% | Act | 88% | 92% |
| Recall completion | 66% | Watch | 74% | 80% |
| Revenue collected | $218,900 | On target | $223,367 | $224,900 |
| Revenue per visit | $152 | On target | $150 | $147 |
| Support staff cost ratio | 27.1% | Watch | 27.3% | 25.5% |
| Overhead ratio | 62.3% | On target | 60.7% | 57.7% |
| Days cash on hand | 19 | Watch | 25 | 33 |
Revenue and revenue per visit held, so the top line looked calm. The front door did not. Across the 12 months the no-show rate climbed from 5.5% to 7.9%, the phone answer rate fell from 93% to 79%, new patients fell from 110 to 82 and cash on hand fell from 34 days to 19. In Oct 2026, 3 KPIs were red and 5 amber, and the no-show rate had been red for three months running, which the workbook flags as a system problem rather than a bad month.
The Dashboard then puts the gaps in dollars at the practice's own numbers. Each line takes the last three months, compares them with the green line and turns the difference into visits a year, priced at the 3-month revenue per visit ($152 here).
| Gap, last 3 months against the green line | Visits a year | Dollars a year |
|---|---|---|
| No-shows above 5% | 499 | $75,700 |
| Open slots below 95% fill | 787 | $119,300 |
| Recall below 80% completion | 402 | $61,000 |
| Visit gaps, total (no-shows plus the larger of open slots and recall) | 1,286 | $195,000 |
The formula for the first line: (3-month no-show rate minus 5%) x 3-month visits scheduled / 3 x 12. Recall and open slots overlap, because a recall patient brought back fills an open slot, so the total counts the larger of the two. The same sheet counts 2,768 calls a year not answered live beyond the 90% line, and shows $81,600 of cash needed to get back to 30 days. It puts no dollar figure on missed calls, because no public figure says how many of those callers would have booked.
Type last year's months into the workbook and the Dashboard shows which KPIs are red, how long they have been drifting and what the gaps cost a year.
Get the free KPI dashboard (Excel)How to choose KPIs a small practice can move
Keep a KPI only if it passes three tests. It comes from a report you already run, so nobody builds a spreadsheet to feed the spreadsheet. One named person can move it: the front desk lead owns the phone answer rate, the scheduler owns fill and recall, the office manager owns staff cost. And someone reads it every month and acts on it. A dashboard with 40 numbers gets read once.
Then read the 12 in order. The front door numbers move first: calls, fill, no-shows, recall and new patients. The money numbers follow weeks later: revenue, staff cost, overhead and cash. In the worked example the phones and no-shows started slipping in May, and cash days followed. An owner who only reads the profit and loss statement sees the problem last.
This workbook is the monthly record. For a weekly look, the Owner Dashboard is a one-screen view for Friday (its free file is at the owner dashboard download). Many practices run both: weekly to catch a bad week, monthly to see a trend.
Setting the red, amber and green lines
A line is a decision, not a fact, so write down where each one comes from. Use a published figure where one fits, label your own starting target as yours, and judge the rest against your own average.
| Color | KPI with a green and a red line | KPI with no line (judged against your own 12-month average) |
|---|---|---|
| Green: on target | At or better than the green line | Better than the average, or within 5% of it |
| Amber: watch | Between the green and the red line | 5% to 10% worse than the average |
| Red: act | Past the red line | More than 10% worse than the average |
No-shows. MGMA's single-specialty aggregate was 7% in 2019, 5.55% in 2020, 5% in 2021 and 2022, and 6.81% in 2023 (MGMA Stat, Jan 8, 2025). The template's green line sits at the low end of that range and its red line at the high end, so a practice at the 2023 average shows amber, not fine. In August 2026, 32% of groups said no-shows were higher than in 2025, and MGMA's 2024 data showed only 27.40% of canceled visits rescheduled within 30 days (MGMA Stat, Aug 12, 2026).
Phones. One health system found some of its clinics sent more than 50% of incoming calls to voicemail and set an organization goal of a missed call rate of 10% or lower; missed calls and schedule use moved together, with a correlation of -0.69 (MGMA, Sep 26, 2023). The template's green line is that goal, 90% answered live. Its red line, 80%, is ours.
Support staff salaries and benefits alone typically account for roughly a quarter of total practice revenue.MGMA Stat, Jun 11, 2025 (source)
Staff cost. The green line is MGMA's rule of thumb. Count it all in: in health care and social assistance, employers paid $35.13 an hour in wages and $14.80 in benefits in June 2026, so benefits were 29.6% of compensation (BLS ECEC, June 2026). Payroll typed without taxes and benefits makes the ratio look about 30% lower than it is.
Cash. The JPMorgan Chase Institute defines cash buffer days as the days of outflows a business could pay from its balance if its inflows stopped. In 2015 bank data on 597,000 small businesses, the median health care services business held 30 days and the 25th percentile 14 (JPMorgan Chase Institute, Sep 2016). The data are older than 2021, so read 30 days as a floor, not a goal.
Once you have 12 months of your own numbers, reset the lines once a year at the budget meeting, and write the reason next to any line you move. The operations budget guide covers that meeting.
Why a monthly trend, not a year-end report
Costs rise every year, and they rise faster than a once-a-year review can catch. In June 2026, 84% of medical groups reported operating costs above 2025 levels, about 11% higher on average, with wages, benefits and staffing shortages the main drivers (MGMA Stat, Jun 24, 2026).
Volume moved the other way. The median primary care physician's total encounters fell 5.32%, from 2,971 in 2024 to 2,813 in 2025, and in March 2026 only 60% of groups were meeting or beating their productivity goals (MGMA DataDive, June 2026). Rising costs and softer volume squeeze the same margin, which is why visits per provider day and the overhead ratio sit side by side on the dashboard. When both move the wrong way, run the break-even analysis to see how many visits a day the practice now needs.
How to run it each month
- By the 10th, after the month-end close. The office manager types 16 numbers from the same reports every month. The month-end close checklist produces the money figures.
- Fix the checks. The workbook flags a duplicate month, a blank key input, no-shows larger than visits scheduled and payroll that sits outside operating costs.
- Read red first. The status board says what to check first for each red or amber KPI.
- Fifteen minutes in the monthly meeting. Pick one KPI, one owner and one date, and write it in that month's Note. The staff meeting agenda has a slot for it.
- Once a quarter, read the charts with the owner. A line that has drifted for three months is a system problem, not a bad month.
Two KPIs point to specific fixes. A red no-show rate is usually a reminder and waitlist problem; the no-show cost calculator prices it. A falling cash line with steady revenue is a timing problem the 13-week cash flow forecast shows weeks ahead, and the internal controls checklist covers who may move the money.
Mistakes to avoid
- Changing a definition mid-year. Decide once whether a late cancellation counts as a no-show and which phone report counts calls. A new definition looks exactly like a real change in the trend.
- Payroll without taxes and benefits. In health care, benefits add about 42% on top of wages ($14.80 on $35.13 an hour, BLS, June 2026).
- Reading counts in a short month. A holiday closure or a provider out drops visits and revenue. Read visits per provider day and the rates, and compare with the same month last year.
- Acting on one month of a small number. A rate built on 20 events swings 5 points on one patient. Read the 3-month figure.
- Numbers with no owner. A red KPI that belongs to everyone stays red.
- Download the workbook and delete the 14 sample months.
- Find the report behind each of the 16 inputs and write it on the Definitions tab.
- Type the last 12 months, oldest first, and fix every row the checks flag.
- Put the red KPIs on the next monthly meeting agenda, each with an owner.
By the numbers
| Figure | What it measures | Source and date |
|---|---|---|
| 6.81%; 5%; 5.55%; 7% | MGMA single-specialty aggregate no-show rate: 2023; 2021 and 2022; 2020; 2019 | MGMA Stat, Jan 8, 2025 |
| 42% (622 responses) | Medical groups that charge a no-show fee | MGMA Stat, Jan 8, 2025 |
| 32%; 19.95%; 27.40% | Groups with higher no-shows in 2026 (190 responses); cancellation rate, 2024; canceled visits rescheduled within 30 days, 2024 | MGMA Stat, Aug 12, 2026 |
| Over 50%; 10% or lower | Calls to voicemail at some clinics before the fix; the missed call goal (one health system) | MGMA, Sep 26, 2023 |
| 90%; 11.1% | Groups with higher operating costs in 2025; average rise | MGMA Stat, Jun 11, 2025 |
| About a quarter | Support staff salaries and benefits as a share of practice revenue (MGMA rule of thumb) | MGMA Stat, Jun 11, 2025 |
| 84%; about 11% (251 responses) | Groups with higher operating costs in 2026 than 2025; average rise | MGMA Stat, Jun 24, 2026 |
| 2,971 to 2,813; 23 of 23 | Median primary care encounters per physician, 2024 to 2025; specialties where encounters fell | MGMA DataDive, June 2026 |
| 60%; 40% | Groups at or above their productivity goals in March 2026; below | MGMA DataDive, June 2026 |
| 29.6%; $14.80 of $49.93 | Benefits as a share of compensation per hour, health care and social assistance | BLS ECEC, June 2026 |
| 30; 14; 67; 27 | Cash buffer days: health care services median, 25th and 75th percentile; all small businesses median (2015 data) | JPMorgan Chase Institute, Sep 2016 |
| $195,000 | Visit gaps a year in the worked example | ClinicOps calculation in the workbook |
- Practice numbers: KPIs, overhead, valuation and sale
The numbers pillar this dashboard belongs to, with medical and dental benchmarks.
- The independent medical practice hub
Every owner system for a 1 to 10 provider practice.
- Medical practice break-even analysis
How many visits a day the practice needs to cover its costs, with scenarios.
- The owner dashboard
The weekly one-screen view that pairs with this monthly workbook.
- What an operations consultant costs
When you want the front door fixed, not just measured.
Find out which of your 12 numbers is costing the most
The workbook shows which KPIs are red and what the gaps cost a year at your own numbers. If three or more are red at once, start with the free Chaos Audit; our Practice Diagnostic ranks the fixes that pay back first, in dollars.
Frequently asked questions
What KPIs should a medical practice track?
Track about 12 numbers you can pull from reports you already have: visits completed, visits per provider day, new patients, no-show rate, schedule fill, phone answer rate, recall completion, revenue collected, revenue per visit, support staff cost ratio, overhead ratio and days cash on hand. Read them monthly, each against a line you set.
What is a KPI dashboard for a medical practice?
It is one sheet that shows the practice's key numbers for the latest month, each colored red, amber or green against a target, with the last 12 months beside it. The point is to see a drift early and give each red number one owner and one action.
What is a good no-show rate for a medical practice?
MGMA's single-specialty aggregate was 6.81% in 2023, after 5% in 2021 and 2022 and 7% in 2019. The template sets green at 5% or less and red above 7%. MGMA data lean toward larger groups, so track your own rate by visit type and watch the trend.
How many days of cash should a medical practice keep?
There is no rule for medical practices. In a JPMorgan Chase Institute study of 2015 bank data, the median small health care services business held 30 days of outflows in cash and a quarter held 14 or fewer. The template uses 30 days as green and under 14 as red: a floor, not a goal.
What is a good support staff cost ratio?
MGMA says support staff salaries and benefits typically run roughly a quarter of total practice revenue. Count pay, employer payroll taxes and benefits together, because benefits were 29.6% of compensation in health care in June 2026. The template sets green at 25% or less and red above 30%.
Can I use the KPI dashboard template in Google Sheets?
Yes. Upload the Excel file to Google Drive and choose File, then Save as Google Sheets. The formulas and colors carry over; check the six charts once after the upload, because Sheets redraws Excel charts in its own style.