Template · Published Nov 19, 2026

Dental KPI Template: 14 KPIs With ADA Benchmarks Loaded

For the dental owner or office manager who wants one monthly view of the practice. You leave with 14 KPIs from reports you already have, a line for each from the ADA Health Policy Institute or labelled data, and a free workbook that keeps 12 months of trend and prices the gaps.

The free workbook, for Excel or Google Sheets: a monthly entry sheet for 23 numbers, 14 KPIs colored red, amber or green, ADA HPI benchmarks loaded with their quartiles and a live panel that shows where you sit, 12 months of trend with four charts, the gaps priced in dollars a year, and a 14-case playbook.

Get the free dental KPI tracker (Excel)

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

A dental KPI template tracks about 14 monthly numbers from reports you already run: new patients, call conversion, hygiene reappointment, recare, schedule fill, no-shows, production per dentist hour, overhead and cash. The ADA's median production per practice hour for solo general dentists was $529 in 2025 (ADA HPI, 2026). Free tracker below.

Key takeaways

  • The ADA spread is wide: production per practice hour for solo general dentists ran from $371 at the first quartile to $828 at the third in 2025, with a $529 median, up from $355 in 2015 before inflation (ADA HPI, 2026).
  • Overhead runs about 57% of production for owner general dentists: median expenses of $509,720 against median production of $893,510 in 2025 (ClinicOps calculation from ADA HPI).
  • Chairs are emptier: 38% of dentists said they were not busy enough in Q3 2026, up from 26% in Q2, and new patients waited 12.0 days for a first visit (ADA HPI, Q3 2026).
  • Hygiene reappointment averaged 63% and no-shows 6.9% in 2025 across 8,500+ practices on one platform (Planet DDS, 2026, vendor data); practices with 1 to 7 locations averaged 4% no-shows (Henry Schein One, 2026).
  • The phone is the front door: 72.9% of new patient inquiries came by phone and 57.1% became a booked visit across about 50,000 dental leads in 2023 (Liine, 2024, vendor data).

The 14 dental KPIs and the line for each

Fourteen numbers answer the questions a dental owner asks each month: are new patients getting through the phones and onto the schedule, are hygiene patients coming back, are the chairs full, is production keeping up with costs, and how long could the practice run on its cash. Each one comes from a report the practice already has: the schedule, the phone log, the recare list, the production report, the deposits, payroll and the bank.

The 14 dental KPIs, how to calculate each, and its green and red line
KPIHow to calculate itGreenRedWhere the line comes from
New patients seenFirst visits by patients new to the practiceWithin 5% of your 12-month averageMore than 10% worseYour own trend; vendor averages 30 to 46 a month
New patient call conversionNew patient calls booked / new patient calls70% or moreUnder 57%57.1% booked across about 50,000 dental leads (Liine, 2024, vendor); green is our target
Hygiene reappointment rateHygiene patients reappointed before leaving / hygiene visits80% or moreUnder 63%63% average in 2025 (Planet DDS, 2026, vendor); green is our target
Recare completionRecare due this month booked or seen / recare due80% or moreUnder 60%Our starting target, not a benchmark
Hygiene schedule fillHygiene hours booked / hygiene hours open95% or moreUnder 90%Our starting target, not a benchmark
Dentist chair hours usedDentist hours booked / dentist hours open90% or moreUnder 80%Our starting target, not a benchmark
No-show rateNo-shows / appointments on the schedule4% or lessAbove 7%4% at 1 to 7 locations (Henry Schein One, 2026); 6.9% overall (Planet DDS); vendor
Cancellation rateCancellations / (appointments on the schedule + cancellations)Within 5% of your 12-month averageMore than 10% worseYour own trend; Planet DDS 12.9% as context
Production per dentist hourProduction at your own fees, hygiene included / dentist hours open$529 or moreUnder $371ADA median and first quartile, solo general dentists (ADA HPI, 2026)
Production per visitProduction at your own fees / patient visits completedWithin 5% of your 12-month averageMore than 10% worseYour own trend; HPI counts hygiene-only visits separately
Money collectedMoney collected for patient care in the monthWithin 5% of your 12-month averageMore than 10% worseYour own trend, or your budget
Staff cost ratioStaff payroll, taxes and benefits / money collectedWithin 5% of your 12-month averageMore than 10% worseYour own trend; no free ADA split
Overhead ratioOperating costs, owner pay left out / productionAbout 57% or lessAbove 65%ClinicOps calculation from ADA HPI medians; red is our line
Days cash on handCash / (the month's outflows / days in the month)30 days or moreUnder 14 daysHealth care services median and 25th percentile (JPMorgan Chase Institute, 2016)

Two lines come straight from the ADA Health Policy Institute, three from vendor platform data (labelled), one from the JPMorgan Chase Institute and four are our starting targets, labelled as such. The other four have no public line that fits a small practice, so the tracker judges them against your own 12-month average: green within 5%, red when more than 10% worse. There are no collection-rate, plan-mix or aging metrics: every KPI here is about patients, chairs, production at your own fees and cash.

The ADA benchmarks loaded in the tracker

The ADA Health Policy Institute's Survey of Dental Practice is the benchmark most dental KPI templates cite and few load. Its gross billings are "the total amount of fees charged by a primary practice for dental care provided" (HPI glossary): production at your own fees. The 2026 survey collected 2025 data from 1,113 dentists, a 1.9% response rate, and its dollars are not adjusted for inflation, so read it as a wide, real spread rather than a precise target.

ADA Health Policy Institute benchmarks loaded in the tracker (2026 survey of 2025 data, general dentists)
MeasureFirst quartileMedianThird quartileHPI table
Production per practice hour, solo dentists$371$529$828Table 9
Production per visit, solo dentists$335$481$764Table 9
Production per owner dentist, a year$583,410$893,510$1,198,710Table 5
Practice expenses per owner dentist, owner pay left out$322,820$509,720$747,130Table 13
Overhead, expenses / production (ClinicOps calculation)not published57.0%not publishedTables 5 and 13
Hours a year in the office, owner dentistsnot published1,726 (average)not publishedTable 19
Patient visits per dentist hour, hygiene includednot published2.3 (average)not publishedTable 23
Days a new patient waits for a first visitnot published16.0 (average)not publishedTable 22

The tracker's Benchmarks tab holds these quartiles and places your last 12 months against them: bottom quarter, below the median, above the median or top quarter. Production per visit is shown but not placed, because the HPI questionnaire asks for dentist visits and hygiene-only visits separately, and a per-visit figure moves with your hygiene mix.

Median production per practice hour, solo general dentists, 2015 to 2025Line chart from the ADA Health Policy Institute's Survey of Dental Practice (Table 10): median gross billings per practice hour for solo general dentists were $355 in 2015, $357 in 2016, $400 in 2017, $385 in 2018, $436 in 2019, $463 in 2020, $431 in 2021, $448 in 2022, $502 in 2023, $523 in 2024, $529 in 2025. Not adjusted for inflation. ADA MEDIAN PRODUCTION PER PRACTICE HOUR $300 $400 $500 $529 15 16 17 18 19 20 21 22 23 24 25 Source: ADA HPI, Survey of Dental Practice, Table 10.
The median solo general dentist produced $529 an hour in 2025, against $355 in 2015. Median gross billings per practice hour, solo general dentists: $355 (2015), $357 (2016), $400 (2017), $385 (2018), $436 (2019), $463 (2020), $431 (2021), $448 (2022), $502 (2023), $523 (2024), $529 (2025). Not adjusted for inflation. Source: ADA Health Policy Institute, Survey of Dental Practice, Table 10.

Production per dentist hour is the one KPI that ties the schedule to the money. It falls when chairs sit empty and rises when they fill, long before a fee change would show. The overhead line is our calculation from the same survey: median expenses over median production for owner general dentists, about 57% in 2025. The ADA publishes no overhead percentage, so treat any "ADA overhead" figure you see elsewhere with care.

Worked example: 12 months in a two-dentist practice

Worked example

A two-dentist general practice: the owner, an associate (1.75 full-time dentists between them) and two hygienists, producing about $139,000 a month at its own fees. The office manager typed 14 months into the tracker, 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
New patients seen30Act3842
New patient call conversion54%Act64%71%
Hygiene reappointment rate66%Watch75%81%
Recare completion62%Watch69%77%
Hygiene schedule fill86%Act91%96%
Dentist chair hours used83%Watch87%92%
No-show rate7.5%Act6.1%4.9%
Cancellation rate13.2%Watch12.3%11.0%
Production per dentist hour$529Watch$555$587
Production per visit$251On target$251$251
Money collected$125,600Watch$132,550$140,900
Staff cost ratio30.3%On target29.3%26.0%
Overhead ratio60.2%Watch57.7%53.0%
Days cash on hand25Watch3545

Production per dentist hour started well above the ADA median and slid down to it, and the cause was not fees. Across the year, hygiene reappointment fell from 82% to 66%, dentist chair hours used from 90% to 83%, new patients from 48 to 30 a month, and no-shows rose from 5.1% to 7.5%. In Oct 2026, 4 KPIs were red and 8 amber. Over the last 12 months the practice still sat above the ADA median for production per dentist hour ($555) and per full-time dentist ($956,000), which is exactly why the slide was easy to miss.

Production per dentist hour by month in the worked example, against the ADA median and first quartileLine chart of the worked example's production per dentist hour from Nov 2025 to Oct 2026: $574, $565, $576, $571, $566, $561, $553, $548, $545, $538, $533, $529. ADA median $529 and first quartile $371 for solo general dentists (HPI, 2025 data). The practice slipped to the median line by October. PRODUCTION PER DENTIST HOUR, WORKED EXAMPLE $400 $500 $600 ADA median $529 ADA first quartile $371 $529 Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Source: the ClinicOps Dental KPI Tracker, worked example.
Production per dentist hour slid to the ADA median as the chairs emptied. Worked example, by month, Nov 2025 to Oct 2026: $574, $565, $576, $571, $566, $561, $553, $548, $545, $538, $533, $529. Lines: ADA median $529 and first quartile $371 for solo general dentists (2025 data). Source: the ClinicOps Dental KPI Tracker (a worked example, not a client).

The Dashboard then prices the gaps at the practice's own numbers. Each line takes the last three months, compares them with the green line and turns the difference into hours, visits or patients a year, priced at the practice's own production per visit, per booked dentist hour or per hygiene visit.

What the gaps cost a year, worked example (ClinicOps calculation in the workbook)
Gap, last 3 months against the green lineA yearProduction a year
No-shows above 4%230 visits$57,700
Dentist hours left empty below 90%181 hours$77,800
Hygiene hours left empty below 95%259 hours$48,200
Hygiene patients not reappointed below 80%331 patients$62,900
Total (no-shows + dentist hours + the larger of the two hygiene gaps)a year$198,400
Production a year lost to each gap in the worked exampleBar chart of the worked example's gaps, priced at its own 3-month production: empty dentist hours $77,800, missed hygiene reappointments $62,900, no-shows above 4% $57,700, empty hygiene hours (overlaps reappointments) $48,200. The total, $198,400, counts the larger of empty hygiene hours and missed reappointments, not both. WHAT THE GAPS COST A YEAR, WORKED EXAMPLE Empty dentist hours $77,800 Missed hygiene reappointments $62,900 No-shows above 4% $57,700 Empty hygiene hours (overlaps reappointments) $48,200 Source: the ClinicOps Dental KPI Tracker, worked example.
Empty chairs and missed reappointments cost more than no-shows. Worked example, production a year: empty dentist hours $77,800, missed hygiene reappointments $62,900, no-shows above 4% $57,700, empty hygiene hours (overlaps reappointments) $48,200. Total $198,400 (the two hygiene gaps overlap, so only the larger counts). Source: the ClinicOps Dental KPI Tracker, worked example.

The formula for the first line: (3-month no-show rate minus 4%) x 3-month appointments / 3 x 12, priced at production per visit. The same sheet counts 108 new patient calls a year not booked beyond the 70% line, with no dollar figure claimed, and shows $19,200 of cash needed to get back to 30 days.

See your own 14 numbers in 30 minutes

Type last year's months into the tracker and the Dashboard shows which KPIs are red, where you sit against the ADA quartiles and what the gaps cost a year.

Get the free dental KPI tracker (Excel)

Why the chairs matter more than the fees right now

The national picture points the same way as the worked example. In the ADA's Q3 2026 poll of 704 dentists, 38% said they were not busy enough and could have treated more patients, the highest share in the two years shown, and only 8% said they were too busy (ADA HPI, Q3 2026).

2 in 5
Two out of five dentists reported in Q3 that they are not busy enough and could treat more patients. ADA Health Policy Institute, Q3 2026 (source)
Share of dentists who said they were not busy enough and could treat more patients, Q3 2024 to Q3 2026Column chart from the ADA Health Policy Institute's quarterly poll: dentists not busy enough were 28% in Q3 2024, 24% in Q4 2024, 28% in Q1 2025, 27% in Q2 2025, 35% in Q3 2025, 33% in Q4 2025, 32% in Q1 2026, 26% in Q2 2026 and 38% in Q3 2026 (704 responses). DENTISTS NOT BUSY ENOUGH, BY QUARTER 10% 20% 30% 40% 28% Q3 24 24% Q4 24 28% Q1 25 27% Q2 25 35% Q3 25 33% Q4 25 32% Q1 26 26% Q2 26 38% Q3 26 Source: ADA HPI, Q3 2026.
The share of dentists not busy enough reached 38% in Q3 2026. Dentists who could have treated more patients: 28% (Q3 24), 24% (Q4 24), 28% (Q1 25), 27% (Q2 25), 35% (Q3 25), 33% (Q4 25), 32% (Q1 26), 26% (Q2 26), 38% (Q3 26). Source: ADA Health Policy Institute, State of the U.S. Dental Economy, Q3 2026 (704 responses in Q3 2026).

Costs have not waited. Since January 2021, dental equipment and supply prices rose 23% and dental office staff hourly earnings 21%, against 27% inflation (ADA HPI, Q3 2026, BLS data). With supply prices and pay rising, the lever a small practice controls month to month is how full the dentist and hygiene schedules are, which is why four of the 14 KPIs measure exactly that.

Vendor benchmarks, labelled

The ADA does not publish no-show, cancellation, reappointment or call conversion rates. Practice software and call tracking vendors do, from their own platforms. They are useful, they are not surveys, and some include large group practices, so the tracker names the source on every line it uses.

Vendor platform data, labelled: useful context, not ADA benchmarks
MeasureFigurePopulationSource
No-show rate6.9% (7.4% in 2024)8,500+ practices, DSOs included, 2025Planet DDS, 2026
No-show rate4%; top 10% under 1%Practices with 1 to 7 locationsHenry Schein One, Apr 2026
Cancellation rate12.9% (15.5% in 2024)8,500+ practices, 2025Planet DDS, 2026
Hygiene reappointment rate63% (60% in 2024)8,500+ practices, 2025Planet DDS, 2026
New patients a month46 average; 38.8% under 208,500+ practices, 2025Planet DDS, 2026
New patients a month30 average; top 10% 81Practices with 1 to 7 locationsHenry Schein One, Apr 2026
New patient inquiries booked57.1%; 72.9% by phoneAbout 50,000 leads, 2023Liine, 2024

Two vendors put the no-show rate at 4% (Henry Schein One, published April 2026) and 6.9% (Planet DDS, 2025). Part of the difference is who is in the data: practices with 1 to 7 locations in one, every practice on the platform, DSOs included, in the other. That range is why the tracker sets green at 4% and red above 7%. The dental no-show policy template covers what to do when the rate turns red, and the dental recare letter template covers the patients who left without a next visit.

Using the dental KPI template in Google Sheets

The tracker is an Excel file built to work in both. In Google Drive, upload it and choose File, then Save as Google Sheets.

What carries over when you open the tracker in Google Sheets
Part of the workbookIn Google SheetsWhat to do
FormulasWorkEvery function used is on Google's Sheets function list: SUMIFS, COUNTIFS, AVERAGE, IFERROR, INDEX, MATCH, EOMONTH, ROUND, TEXT and the rest. No dynamic arrays.
Red, amber and green colorsWorkConditional formatting rules carry over. Nothing to do.
Dropdowns and number checksWorkData validation carries over. Nothing to do.
ChartsRedrawnSheets redraws the four Excel charts in its own style. Check them once after the upload.
Navigation links between tabsCheckUse the tabs at the bottom of the screen if a link in the navigation row does not jump.
Macros and links to other filesNone usedGoogle says macros and linked spreadsheets in Excel files are not supported (Google Docs Editors Help); the tracker has neither.

How to run it each month

  1. By the 10th. The office manager types the 23 numbers from the same reports every month: the schedule, the phone log, the recare list, the production report, the deposits, payroll and the bank balance.
  2. Fix the checks. The CHECKS column flags a duplicate month, a blank key input, booked hours above open hours, reappointments above hygiene visits, and payroll 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.
  5. Once a quarter, open the Benchmarks tab with the dentist owner. A move from above the median to below it is worth a conversation; one amber month is not.

Two of the KPIs point straight at the front desk. A falling call conversion rate is a phones problem: the dental front desk phone scripts cover the new patient call word for word, and the dental front desk training manual covers scheduling and recare (its download is the training manual). And when production and deposits stop moving together, run the dental office embezzlement checklist. For a medical practice, the medical KPI dashboard template is the same idea with MGMA lines (its download), and the break-even analysis shows how many visits a day the costs need.

Mistakes to avoid

  • Comparing with the ADA average instead of the quartiles. The spread from the first to the third quartile is more than double. Know which quarter you are in, then watch your own trend.
  • Counting production after write-downs one month and at full fee the next. Use your own full fees every month, the way HPI defines gross billings.
  • Dividing production by chair hours instead of dentist hours. HPI's figure is per hour the dentist is in the practice. A dentist working two chairs still counts once.
  • Reading counts in a short month. A holiday week drops production and new patients. Read the rates and the 3-month figures.
  • A KPI with no owner. A red hygiene reappointment rate belongs to the hygienists and the front desk lead, by name.
Your first month with the tracker
  1. Download the workbook, open it in Excel or Google Sheets and delete the 14 sample months.
  2. Find the report behind each of the 23 inputs and write it on the Definitions tab.
  3. Type the last 12 months, oldest first, and fix every row the checks flag.
  4. Read the Benchmarks tab: which ADA quarter is your production per dentist hour in?

By the numbers

Every figure on this page
FigureWhat it measuresSource and date
$371; $529; $828Production per practice hour, solo general dentists, first quartile, median, third quartile (2025)ADA HPI, 2026, Table 9
$355 to $529Median production per practice hour, solo general dentists, 2015 to 2025, not inflation-adjustedADA HPI, Table 10
$335; $481; $764Production per visit, solo general dentists, quartiles (2025)ADA HPI, Table 9
$893,510; $509,720Median production and median practice expenses per owner general dentist (2025)ADA HPI, Tables 5 and 13
About 57%Overhead implied by those mediansClinicOps calculation from ADA HPI
1,726; 2.3; 16.0Hours a year in the office; visits per dentist hour; days a new patient waits (2025)ADA HPI, Tables 19, 23, 22
1,113; 1.9%HPI survey responses and response rateADA HPI, Methodology
38%; 26%; 12.0 daysDentists not busy enough in Q3 2026 and Q2 2026; new patient wait, Q3 2026ADA HPI, Q3 2026
21%; 23%; 27%Rise since January 2021 in dental office staff hourly earnings; equipment and supply prices; inflationADA HPI, Q3 2026
6.9%; 12.9%; 63%; 46No-shows, cancellations, hygiene reappointment, new patients a month (2025, vendor)Planet DDS, 2026
4%; 30No-show rate and new patients a month, practices with 1 to 7 locations (vendor)Henry Schein One, 2026
72.9%; 57.1%New patient inquiries by phone; inquiries booked (2023 leads, vendor)Liine, 2024
14; 30; 67Cash buffer days, small health care services businesses, 25th percentile, median, 75th (2015 data)JPMorgan Chase Institute, 2016
$198,400What the gaps cost a year in the worked exampleClinicOps calculation in the workbook
Next steps

Find out which of your 14 numbers is costing the most

The tracker shows which KPIs are red, where you sit against the ADA 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 dental practice track?

Track about 14 numbers you can pull from reports you already run: new patients, new patient call conversion, hygiene reappointment, recare completion, hygiene schedule fill, dentist chair hours used, no-shows, cancellations, production per dentist hour, production per visit, money collected, staff cost ratio, overhead ratio and days cash on hand. Read them monthly, each against a line you set.

What is a good production per hour for a dental practice?

The ADA Health Policy Institute's median for solo general dentists was $529 of production per practice hour in 2025, with a first quartile of $371 and a third quartile of $828. Production here is the practice's own fees, hygiene included, divided by the dentist's hours in the office.

What is a good hygiene reappointment rate?

No ADA benchmark exists. Across more than 8,500 practices on the Planet DDS platform, the 2025 average was 63%, which is vendor data that includes large groups. The tracker uses 80% as a starting target and treats anything under 63% as red.

What is a normal no-show rate for a dental practice?

Recent vendor platform data put it between 4% and 7%: 4% on average for practices with 1 to 7 locations (Henry Schein One, 2026) and 6.9% across all Planet DDS practices in 2025. The tracker sets green at 4% or less and red above 7%.

What is a normal overhead for a dental practice?

The ADA does not publish an overhead percentage. Its 2025 survey data for owner general dentists show median practice expenses of $509,720 against median production of $893,510, which works out to about 57%. That is our calculation, and a ratio of medians, so read it as a rough line.

Can I use the dental KPI template in Google Sheets?

Yes. Upload the Excel file to Google Drive and choose File, then Save as Google Sheets. Every formula uses functions on Google's Sheets function list and the file has no macros or links to other files. Check the four charts once after the upload, because Sheets redraws Excel charts in its own style.