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)

Version 1.0, Nov 19, 2026. Works in Excel and Google Sheets. Counts and totals only, no patient data.

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.

The 12 KPIs, how to calculate each, and its green and red line
KPIHow to calculate itGreenRedWhere the line comes from
Visits completedCompleted visits, all providers, telehealth appointments includedWithin 5% of your 12-month averageMore than 10% worseYour own trend, or your budget
Visits per provider dayVisits completed / provider days workedWithin 5% of your 12-month averageMore than 10% worseYour own trend
New patients seenFirst visits by patients new to the practiceWithin 5% of your 12-month averageMore than 10% worseYour own trend
No-show rateNo-shows / visits scheduled5% or lessAbove 7%MGMA aggregate: 5% in 2021 and 2022, 7% in 2019 (MGMA Stat, 2025)
Schedule fill rateVisits scheduled / slots offered95% or moreUnder 90%Our starting target, not a benchmark
Phone answer rateCalls answered live / calls received in open hours90% or moreUnder 80%A goal of 10% or fewer missed calls (MGMA, 2023); red is our line
Recall completionRecall patients booked or seen / recall patients due this month80% or moreUnder 60%Our starting target, not a benchmark
Revenue collectedMoney collected for patient care in the monthWithin 5% of your 12-month averageMore than 10% worseYour own trend, or your budget
Revenue per visitRevenue collected / visits completedWithin 5% of your 12-month averageMore than 10% worseYour own trend; it depends on visit mix
Support staff cost ratioSupport staff pay, payroll taxes and benefits / revenue collected25% or lessAbove 30%Roughly a quarter of revenue (MGMA Stat, 2025); red is our line
Overhead ratioOperating costs without provider and owner pay / revenue collectedWithin 5% of your 12-month averageMore than 10% worseYour own trend; no free current median
Days cash on handCash at month end / (the month's outflows / days in the month)30 days or moreUnder 14 daysMedian 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.

Status board, worked example, Oct 2026
KPIOct 2026Status12-month averageOct 2025
Visits completed1,440On target1,4911,530
Visits per provider day18.0Watch19.119.6
New patients seen82Act9498
No-show rate7.9%Act6.3%4.9%
Schedule fill rate90%Watch94%95%
Phone answer rate79%Act88%92%
Recall completion66%Watch74%80%
Revenue collected$218,900On target$223,367$224,900
Revenue per visit$152On target$150$147
Support staff cost ratio27.1%Watch27.3%25.5%
Overhead ratio62.3%On target60.7%57.7%
Days cash on hand19Watch2533

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.

No-show rate by month in the worked example, against the green and red linesLine chart of the worked example's no-show rate from Nov 2025 to Oct 2026: 5.5%, 5.8%, 5.4%, 5.1%, 5.6%, 6.0%, 6.3%, 6.6%, 6.9%, 7.2%, 7.6%, 7.9%. Green line at 5%, red line at 7%. The rate crossed the red line in August and reached 7.9% in October. NO-SHOW RATE, WORKED EXAMPLE 4% 6% 8% Green line 5% Red line 7% 7.9% Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Source: the ClinicOps KPI workbook, worked example.
The no-show rate crossed the red line in August and kept climbing. Worked example, no-show rate by month, Nov 2025 to Oct 2026: 5.5%, 5.8%, 5.4%, 5.1%, 5.6%, 6.0%, 6.3%, 6.6%, 6.9%, 7.2%, 7.6%, 7.9%. Green line 5%, red line 7%. Source: the ClinicOps KPI workbook (a worked example, not a client).

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).

What the gaps cost a year, worked example (ClinicOps calculation in the workbook)
Gap, last 3 months against the green lineVisits a yearDollars a year
No-shows above 5%499$75,700
Open slots below 95% fill787$119,300
Recall below 80% completion402$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.

See your own 12 numbers in 30 minutes

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.

How the workbook colors a KPI
ColorKPI with a green and a red lineKPI with no line (judged against your own 12-month average)
Green: on targetAt or better than the green lineBetter than the average, or within 5% of it
Amber: watchBetween the green and the red line5% to 10% worse than the average
Red: actPast the red lineMore 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).

MGMA single-specialty aggregate no-show rate, 2019 to 2023Column chart from MGMA Stat (Jan 8, 2025): the single-specialty aggregate no-show rate was 7% in 2019, 5.55% in 2020, 5% in 2021 and 2022, and 6.81% in 2023. MGMA NO-SHOW RATE, 2019 TO 2023 2% 4% 6% 8% 7% 2019 5.55% 2020 5% 2021 5% 2022 6.81% 2023 Source: MGMA Stat, Jan 8, 2025.
No-shows fell after 2019 and climbed back toward 7% by 2023. MGMA single-specialty aggregate no-show rate: 7% (2019), 5.55% (2020), 5% (2021), 5% (2022), 6.81% (2023). Source: MGMA Stat, published Jan 8, 2025. MGMA data lean toward larger groups.

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.

25%
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.

Cash buffer days held by small health care services businesses and all small businessesRange chart from the JPMorgan Chase Institute (Sep 2016, 2015 bank data on 597,000 small businesses): health care services businesses held 14 cash buffer days at the 25th percentile, 30 at the median and 67 at the 75th; all small businesses held 13, 27 and 62. CASH BUFFER DAYS, SMALL BUSINESSES Health care services 14 30 67 All small businesses 13 27 62 0 20 40 60 80 Days of outflows held in cash. Line: 25th to 75th percentile; dot: median. Source: JPMorgan Chase Institute, Sep 2016 (2015 data).
Half of small health care businesses held less than a month of cash. Cash buffer days, 25th percentile, median and 75th percentile: health care services 14, 30 and 67; all small businesses 13, 27 and 62. Source: JPMorgan Chase Institute, Cash is King, Sep 2016 (2015 data, older than 2021).

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).

Share of medical groups reporting higher operating costs than a year earlier, 2025 and 2026Bar chart from MGMA Stat polls: 90% of medical groups reported year-to-date operating costs above 2024 levels in June 2025, with an average rise of about 11.1%; 84% reported costs above 2025 levels in June 2026 (251 responses), with an average rise of about 11%. MEDICAL GROUPS WITH HIGHER OPERATING COSTS 2025, poll of Jun 10 (average rise 11.1%) 90% 2026, poll of Jun 23 (average rise about 11%) 84% Source: MGMA Stat, Jun 11, 2025 and Jun 24, 2026.
Nine in ten groups saw costs rise in 2025, and more than eight in ten in 2026. Share of medical groups reporting year-to-date operating costs above the prior year: 90% (June 2025, average rise 11.1%) and 84% (June 2026, average rise about 11%, 251 responses). Sources: MGMA Stat, Jun 11, 2025 and MGMA Stat, Jun 24, 2026. Polls of MGMA members, which lean toward larger groups.

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

  1. 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.
  2. 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.
  3. Read red first. The status board says what to check first for each red or amber KPI.
  4. 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.
  5. 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.
Do this this week
  1. Download the workbook and delete the 14 sample months.
  2. Find the report behind each of the 16 inputs and write it on the Definitions tab.
  3. Type the last 12 months, oldest first, and fix every row the checks flag.
  4. Put the red KPIs on the next monthly meeting agenda, each with an owner.

By the numbers

Every figure on this page
FigureWhat it measuresSource and date
6.81%; 5%; 5.55%; 7%MGMA single-specialty aggregate no-show rate: 2023; 2021 and 2022; 2020; 2019MGMA Stat, Jan 8, 2025
42% (622 responses)Medical groups that charge a no-show feeMGMA 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, 2024MGMA Stat, Aug 12, 2026
Over 50%; 10% or lowerCalls 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 riseMGMA Stat, Jun 11, 2025
About a quarterSupport 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 riseMGMA Stat, Jun 24, 2026
2,971 to 2,813; 23 of 23Median primary care encounters per physician, 2024 to 2025; specialties where encounters fellMGMA DataDive, June 2026
60%; 40%Groups at or above their productivity goals in March 2026; belowMGMA DataDive, June 2026
29.6%; $14.80 of $49.93Benefits as a share of compensation per hour, health care and social assistanceBLS ECEC, June 2026
30; 14; 67; 27Cash buffer days: health care services median, 25th and 75th percentile; all small businesses median (2015 data)JPMorgan Chase Institute, Sep 2016
$195,000Visit gaps a year in the worked exampleClinicOps calculation in the workbook
Next steps

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.