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)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.
| KPI | How to calculate it | Green | Red | Where the line comes from |
|---|---|---|---|---|
| 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; vendor averages 30 to 46 a month |
| New patient call conversion | New patient calls booked / new patient calls | 70% or more | Under 57% | 57.1% booked across about 50,000 dental leads (Liine, 2024, vendor); green is our target |
| Hygiene reappointment rate | Hygiene patients reappointed before leaving / hygiene visits | 80% or more | Under 63% | 63% average in 2025 (Planet DDS, 2026, vendor); green is our target |
| Recare completion | Recare due this month booked or seen / recare due | 80% or more | Under 60% | Our starting target, not a benchmark |
| Hygiene schedule fill | Hygiene hours booked / hygiene hours open | 95% or more | Under 90% | Our starting target, not a benchmark |
| Dentist chair hours used | Dentist hours booked / dentist hours open | 90% or more | Under 80% | Our starting target, not a benchmark |
| No-show rate | No-shows / appointments on the schedule | 4% or less | Above 7% | 4% at 1 to 7 locations (Henry Schein One, 2026); 6.9% overall (Planet DDS); vendor |
| Cancellation rate | Cancellations / (appointments on the schedule + cancellations) | Within 5% of your 12-month average | More than 10% worse | Your own trend; Planet DDS 12.9% as context |
| Production per dentist hour | Production at your own fees, hygiene included / dentist hours open | $529 or more | Under $371 | ADA median and first quartile, solo general dentists (ADA HPI, 2026) |
| Production per visit | Production at your own fees / patient visits completed | Within 5% of your 12-month average | More than 10% worse | Your own trend; HPI counts hygiene-only visits separately |
| Money 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 |
| Staff cost ratio | Staff payroll, taxes and benefits / money collected | Within 5% of your 12-month average | More than 10% worse | Your own trend; no free ADA split |
| Overhead ratio | Operating costs, owner pay left out / production | About 57% or less | Above 65% | ClinicOps calculation from ADA HPI medians; red is our line |
| Days cash on hand | Cash / (the month's outflows / days in the month) | 30 days or more | Under 14 days | Health 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.
| Measure | First quartile | Median | Third quartile | HPI table |
|---|---|---|---|---|
| Production per practice hour, solo dentists | $371 | $529 | $828 | Table 9 |
| Production per visit, solo dentists | $335 | $481 | $764 | Table 9 |
| Production per owner dentist, a year | $583,410 | $893,510 | $1,198,710 | Table 5 |
| Practice expenses per owner dentist, owner pay left out | $322,820 | $509,720 | $747,130 | Table 13 |
| Overhead, expenses / production (ClinicOps calculation) | not published | 57.0% | not published | Tables 5 and 13 |
| Hours a year in the office, owner dentists | not published | 1,726 (average) | not published | Table 19 |
| Patient visits per dentist hour, hygiene included | not published | 2.3 (average) | not published | Table 23 |
| Days a new patient waits for a first visit | not published | 16.0 (average) | not published | Table 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.
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.
| KPI | Oct 2026 | Status | 12-month average | Oct 2025 |
|---|---|---|---|---|
| New patients seen | 30 | Act | 38 | 42 |
| New patient call conversion | 54% | Act | 64% | 71% |
| Hygiene reappointment rate | 66% | Watch | 75% | 81% |
| Recare completion | 62% | Watch | 69% | 77% |
| Hygiene schedule fill | 86% | Act | 91% | 96% |
| Dentist chair hours used | 83% | Watch | 87% | 92% |
| No-show rate | 7.5% | Act | 6.1% | 4.9% |
| Cancellation rate | 13.2% | Watch | 12.3% | 11.0% |
| Production per dentist hour | $529 | Watch | $555 | $587 |
| Production per visit | $251 | On target | $251 | $251 |
| Money collected | $125,600 | Watch | $132,550 | $140,900 |
| Staff cost ratio | 30.3% | On target | 29.3% | 26.0% |
| Overhead ratio | 60.2% | Watch | 57.7% | 53.0% |
| Days cash on hand | 25 | Watch | 35 | 45 |
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.
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.
| Gap, last 3 months against the green line | A year | Production 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 |
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.
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).
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)
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.
| Measure | Figure | Population | Source |
|---|---|---|---|
| No-show rate | 6.9% (7.4% in 2024) | 8,500+ practices, DSOs included, 2025 | Planet DDS, 2026 |
| No-show rate | 4%; top 10% under 1% | Practices with 1 to 7 locations | Henry Schein One, Apr 2026 |
| Cancellation rate | 12.9% (15.5% in 2024) | 8,500+ practices, 2025 | Planet DDS, 2026 |
| Hygiene reappointment rate | 63% (60% in 2024) | 8,500+ practices, 2025 | Planet DDS, 2026 |
| New patients a month | 46 average; 38.8% under 20 | 8,500+ practices, 2025 | Planet DDS, 2026 |
| New patients a month | 30 average; top 10% 81 | Practices with 1 to 7 locations | Henry Schein One, Apr 2026 |
| New patient inquiries booked | 57.1%; 72.9% by phone | About 50,000 leads, 2023 | Liine, 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.
| Part of the workbook | In Google Sheets | What to do |
|---|---|---|
| Formulas | Work | Every 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 colors | Work | Conditional formatting rules carry over. Nothing to do. |
| Dropdowns and number checks | Work | Data validation carries over. Nothing to do. |
| Charts | Redrawn | Sheets redraws the four Excel charts in its own style. Check them once after the upload. |
| Navigation links between tabs | Check | Use the tabs at the bottom of the screen if a link in the navigation row does not jump. |
| Macros and links to other files | None used | Google 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
- 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.
- 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.
- 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.
- 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.
- Download the workbook, open it in Excel or Google Sheets and delete the 14 sample months.
- Find the report behind each of the 23 inputs and write it on the Definitions tab.
- Type the last 12 months, oldest first, and fix every row the checks flag.
- Read the Benchmarks tab: which ADA quarter is your production per dentist hour in?
By the numbers
| Figure | What it measures | Source and date |
|---|---|---|
| $371; $529; $828 | Production per practice hour, solo general dentists, first quartile, median, third quartile (2025) | ADA HPI, 2026, Table 9 |
| $355 to $529 | Median production per practice hour, solo general dentists, 2015 to 2025, not inflation-adjusted | ADA HPI, Table 10 |
| $335; $481; $764 | Production per visit, solo general dentists, quartiles (2025) | ADA HPI, Table 9 |
| $893,510; $509,720 | Median production and median practice expenses per owner general dentist (2025) | ADA HPI, Tables 5 and 13 |
| About 57% | Overhead implied by those medians | ClinicOps calculation from ADA HPI |
| 1,726; 2.3; 16.0 | Hours 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 rate | ADA HPI, Methodology |
| 38%; 26%; 12.0 days | Dentists not busy enough in Q3 2026 and Q2 2026; new patient wait, Q3 2026 | ADA HPI, Q3 2026 |
| 21%; 23%; 27% | Rise since January 2021 in dental office staff hourly earnings; equipment and supply prices; inflation | ADA HPI, Q3 2026 |
| 6.9%; 12.9%; 63%; 46 | No-shows, cancellations, hygiene reappointment, new patients a month (2025, vendor) | Planet DDS, 2026 |
| 4%; 30 | No-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; 67 | Cash buffer days, small health care services businesses, 25th percentile, median, 75th (2015 data) | JPMorgan Chase Institute, 2016 |
| $198,400 | What the gaps cost a year in the worked example | ClinicOps calculation in the workbook |
- Practice numbers: KPIs, overhead, valuation and sale
The numbers pillar this tracker belongs to.
- Dental practice operations: the system library
Every dental system in the order to fix it.
- The independent practice hub
Every owner system for a small practice.
- Dental office embezzlement checklist
The monthly owner review that checks production, deposits and adjustments agree.
- Medical practice KPI dashboard template
The medical version, with MGMA lines.
- What a dental operations consultant does
When you want the chairs filled, not just measured.
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.