- A useful dental KPI dashboard tracks 24 numbers at most, and a solo practice can run on seven. Every formula is below.
- Net collection ratio, hygiene reappointment rate and unscheduled treatment are the three that most often reveal money the practice has already earned but not collected or scheduled.
- Benchmarks quoted in dentistry are rules of thumb from consultants, not audited standards. Your own 12-month trend is the benchmark that matters.
- You can build the dashboard in a spreadsheet from five PMS reports. Dedicated analytics software (Practice by Numbers, Jarvis Analytics, and Dental Intelligence) earns its fee when it updates daily and turns a number into a call list.
Most practice owners can quote last month’s production. Far fewer know their collection ratio, how many hygiene patients left without a next appointment, or how much diagnosed treatment is sitting unscheduled. A KPI dashboard fixes that, but only if it shows a small number of figures the team can influence. This guide gives you the 24 that matter, the exact formulas, a spreadsheet layout, and a comparison of the software that builds the dashboard for you.
Start with seven numbers
If you track nothing today, start here. All seven come straight from standard PMS reports.
| KPI | Question it answers | Review |
|---|---|---|
| Net production | How much collectible work did we do? | Daily |
| Net collection ratio | Are we getting paid for it? | Monthly |
| New patients | Is the practice growing? | Monthly |
| Hygiene reappointment rate | Are patients coming back? | Weekly |
| Case acceptance rate | Does diagnosis turn into treatment? | Monthly |
| No-show rate | How much chair time are we losing? | Weekly |
| AR over 90 days | Is money getting stuck? | Monthly |
Production KPIs
| KPI | Formula | Why it matters | Target |
|---|---|---|---|
| Gross production | Sum of fees for all completed procedures at the office (UCR) fee | The size of the work done, before insurance adjustments. | Trend vs. same month last year |
| Net production | Gross production − contractual adjustments and write-offs | What you can actually collect. The base for almost every other ratio. | Trend; gap to gross shows PPO discount |
| Production per provider hour | Net production ÷ clinical hours worked | Compares dentists and hygienists fairly regardless of days worked. | Your own 12-month average |
| Production per visit | Net production ÷ patient visits | Shows whether the schedule is filled with productive appointments. | Your own 12-month average |
| Hygiene share of production | Hygiene net production ÷ total net production | A healthy recall program feeds restorative work. | Often cited: 25–33% |
Always pair gross with net production. A practice that adds PPO plans can grow gross production while net production, the money it can actually collect, stands still.
Collections and receivables KPIs
| KPI | Formula | Why it matters | Target |
|---|---|---|---|
| Net collection ratio | Collections ÷ net production | The single best measure of billing performance. | Often cited: 98% or higher |
| Accounts receivable over 90 days | AR older than 90 days ÷ total AR | Old balances are rarely collected in full. | Often cited: under 10–15% |
| Days sales outstanding | Total AR ÷ average daily net production | How long money takes to arrive. | Often cited: about 30 days |
| Over-the-counter collection rate | Patient portion collected at the visit ÷ patient portion due at the visit | Money collected at checkout never becomes a statement. | As close to 100% as possible |
| Clean claim rate | Claims paid on first submission ÷ claims submitted | Rejections and denials delay payment and cost staff time. | Track your trend; investigate any drop |
Worked example. Gross production $120,000, contractual adjustments $30,000, so net production is $90,000. Collections of $87,300 give a net collection ratio of 97%. The missing $2,700 a month is $32,400 a year, usually sitting in uncollected patient portions and unworked claims.
Patients and recall KPIs
| KPI | Formula | Why it matters | Target |
|---|---|---|---|
| New patients per month | Count of first completed visits | Growth input. Split by referral source. | Must exceed patients lost |
| Active patients | Patients with a completed visit in the last 18 months | The real size of the practice. | Trend |
| Hygiene reappointment rate | Hygiene patients who leave with the next visit booked ÷ hygiene patients seen | The cheapest retention tool you have. | Often cited: 85–90% or higher |
| Recall (continuing care) effectiveness | Patients seen who were due for recall ÷ patients due for recall | Reappointment counts bookings; this counts who actually came. | Trend |
| Patient attrition | (Active patients at start + new patients − active patients at end) ÷ active patients at start | New-patient numbers hide a leaking bucket. | Lower is better; watch the trend |
The tools that move these numbers are recall and reminder systems. See patient engagement platforms, most of which automate recall.
Schedule and case acceptance KPIs
| KPI | Formula | Why it matters | Target |
|---|---|---|---|
| Case acceptance rate | Dollars of treatment accepted ÷ dollars of treatment presented | Diagnosis that is not scheduled is not production. Also track by patient count. | Compare providers against each other |
| Unscheduled treatment | Dollar value of diagnosed, accepted-but-unscheduled treatment plans | The most immediate source of production; work the list weekly. | Falling balance |
| No-show and late cancellation rate | Broken appointments ÷ scheduled appointments | Each broken hour is lost for good. | Often cited: under 5–10% |
| Schedule utilization | Chair hours filled ÷ chair hours available | Capacity check before hiring or adding an operatory. | Trend by provider and operatory |
| Same-day treatment | Production from treatment started the day it was diagnosed ÷ total production | Converts open time into production without marketing spend. | Trend |
Financing options raise case acceptance on larger plans; see CareCredit vs Cherry vs Sunbit. For broken appointments, compare AI receptionists and reminder tools.
Costs KPIs
| KPI | Formula | Why it matters | Target |
|---|---|---|---|
| Overhead ratio | Total operating expenses (excluding owner-dentist pay) ÷ collections | What it costs to earn a dollar. | Often cited: around 60% |
| Staff cost ratio | Team wages, taxes and benefits ÷ collections | Usually the largest expense line. | Often cited: 25–30% |
| Supplies and lab ratio | (Dental supplies + lab fees) ÷ collections | Rises quietly with price increases and waste. | Often cited: about 5–6% supplies, 8–10% lab |
| Marketing cost per new patient | Marketing spend ÷ new patients from marketing sources | Tells you which channels to keep. | Compare channels |
Cost ratios come from your accounting software, not the PMS. Use collections, not production, as the denominator, because expenses are paid from money received.
What to review daily, weekly and monthly
| Rhythm | Numbers | Action it should trigger |
|---|---|---|
| Daily huddle | Yesterday’s production and collections vs. goal; today’s scheduled production; open time in the next two days; patients in today with unscheduled treatment or overdue family members. | Fill open time; discuss pending treatment with patients already in the chair. |
| Weekly | Unscheduled treatment list; hygiene reappointment rate; broken appointments; claims older than 30 days. | Call list for the treatment coordinator; claims follow-up. |
| Monthly | Full dashboard vs. last month and same month last year; AR aging; new patients by source; cost ratios. | One or two decisions, each with an owner and a date. |
| Quarterly | Fee schedule and PPO write-off review; provider comparison; goals for next quarter. | Fee updates; plan participation decisions. |
Build the dashboard in a spreadsheet
A single location does not need software to start. Set up a sheet with one row per KPI and one column per month, and a second tab for raw inputs.
- Run five reports at month end. Production by provider and procedure; collections and adjustments; AR aging; new patient list with referral source; appointment statistics including broken appointments.
- Enter the raw totals. Gross production, adjustments, collections, AR by age bucket, new patients, visits, hygiene visits, hygiene patients reappointed, treatment presented and accepted, broken appointments, provider hours.
- Add the formulas from the tables above. Net production, collection ratio, percentages and per-hour figures calculate themselves.
- Add three comparison columns. Previous month, same month last year and rolling 12-month average. Color a cell only when it moves more than 10% from the average.
- Chart four lines. Net production, collections, new patients and hygiene reappointment rate over 13 months.
- Review it with the team. Share the numbers they can influence. A dashboard only the owner sees changes nothing.
The limit of a spreadsheet is that it is monthly and manual. Once you want daily numbers, per-provider drill-down or automatic call lists, move to software. 25 of the 45 practice management systems we track confirm custom reporting, which may be enough on its own.
Dental KPI dashboard software compared
Analytics tools connect to your practice management system, refresh daily and present the KPIs above without manual entry. The first question is whether a tool reads your PMS.
| Tool | Index | Built for | PMS it reads (documented) | Rating | Pricing |
|---|---|---|---|---|---|
| Practice by Numbers | 6.5 | Practices of any size | Open Dental, Dentrix, Eaglesoft | 4.9 (104) | Quote |
| Jarvis Analytics | 5.7 | Practices of any size | Dentrix, Dentrix Ascend, Dentrix Enterprise, Eaglesoft, Open Dental, Denticon, Cloud 9 Ortho | 4.3 (15) | Quote |
| Dental Intelligence | 5.2 | Practices of any size | Dentrix, Dentrix Ascend, Eaglesoft, Open Dental, Denticon | 4.4 (122) | Quote |
| Gaidge | 5.2 | Orthodontic practices | not documented; ask vendor | 5.0 (1) | Quote |
| OS Dental | 4.5 | Groups and DSOs | not documented; ask vendor | — | Quote |
| Sikka Platform | 4.5 | Practices of any size | not documented; ask vendor | — | Quote |
| National Data Solutions | 4.4 | Groups and DSOs | Dentrix, Eaglesoft, Open Dental, CareStack | — | Quote |
| DentTracks | 3.8 | Practices of any size | not documented; ask vendor | — | Quote |
| Visio360 | — | Groups and DSOs | not documented; ask vendor | — | Quote |
| ClariFi Health | — | Groups and DSOs | not documented; ask vendor | — | Quote |
What separates the tools:
- Actionability. The better products turn a KPI into a task: a list of patients with unscheduled treatment, overdue recall or an unpaid balance, ready for the morning huddle.
- Depth of PMS connection. Reading the database directly is more reliable than parsing exported reports. Ask how the data is pulled and how often.
- Bundled features. Several analytics vendors also sell reminders, online booking or payments. That can replace another subscription, or duplicate one you already have.
- Definitions. Ask how each tool defines “active patient” and “case acceptance”. Two dashboards can show different numbers from the same data.
Full ranking: dental practice analytics tools (14 products, including demographic and financial analytics).
Dashboards for groups and DSOs
With several locations the problem changes from “what are my numbers” to “are the numbers comparable”.
- Normalize first. Locations on different practice management systems, fee schedules and procedure code habits produce KPIs that cannot be compared. Agree definitions centrally.
- Rank, do not average. A group average hides the two offices that need help. Show each KPI as a ranked list of locations.
- Per-provider and per-chair views. Production per provider hour and per operatory expose capacity you already pay for.
- Same-store growth. Separate growth from acquisitions from growth in existing offices.
- Data ownership. Make sure you can export the underlying data to your own warehouse or BI tool.
Tools in our database aimed at multi-site organizations: OS Dental, National Data Solutions, Visio360, ClariFi Health. For mixed-PMS groups, Jarvis Analytics documents connections to 7 systems.
Common mistakes
- Tracking too much. Thirty KPIs on a screen means none gets attention. Pick the few tied to this quarter’s goal.
- Watching production, ignoring collections. Production is a promise; collections pay the bills.
- Using gross production as the base. In a PPO-heavy practice gross figures overstate everything.
- Comparing with “industry benchmarks” uncritically. A fee-for-service practice and a Medicaid practice have different healthy ranges. Compare with your own history first.
- No owner for each number. Every KPI needs a named person who can act on it.
- Dirty inputs. If appointments are deleted instead of marked broken, the no-show rate is fiction. Fix data entry habits before trusting the dashboard.
Terms used on this page are defined in the glossary.
FAQ
What KPIs should a dental practice track?
At minimum: net production, net collection ratio, new patients, hygiene reappointment rate, case acceptance, no-show rate and accounts receivable over 90 days. Add production per provider hour, unscheduled treatment and overhead ratio once those are stable.
What is a good collection rate for a dental practice?
The target most often quoted is a net collection ratio of 98% or higher, meaning you collect at least 98 cents of every dollar of net production (production after contractual write-offs). Measure it over a rolling three months, because collections lag production.
How do you calculate case acceptance rate?
Divide the dollar value of treatment patients accepted by the dollar value of treatment presented in the same period. Track it by provider, and also by number of patients, because one large accepted case can hide many small refusals.
What is a dental KPI dashboard?
A one-page view of the key performance indicators of a dental practice — production, collections, patients, schedule and costs — refreshed from the practice management system so the owner and team can see trends and act on them.
What is the best dental analytics software?
Among KPI dashboard tools in our database with public ratings, the highest rated are Gaidge (5.0/5 from 1 reviews), Practice by Numbers (4.9/5 from 104 reviews), and Dental Intelligence (4.4/5 from 122 reviews). First check that the tool reads your practice management system.
Can I build a dental KPI dashboard in Excel or Google Sheets?
Yes. Export five monthly reports from your practice management system (production by provider, collections and adjustments, AR aging, new patients and appointments), enter the totals in a sheet with one column per month and add the formulas in this guide. It takes about an hour a month and is enough for a single location.
How often should dental KPIs be reviewed?
Daily: production, collections and tomorrow’s schedule in the morning huddle. Weekly: unscheduled treatment, open hygiene time and broken appointments. Monthly: the full dashboard against last month and the same month last year.
Method & sources
Formulas are standard accounting and practice-management definitions. Target ranges marked “often cited” are rules of thumb used by dental consultants and lenders; they are not audited industry benchmarks and vary with payer mix, specialty and region. Software facts come from our database; we have not tested these dashboards hands-on.
Product facts come from the Denture-ID database, where every field links to the vendor page or document it was taken from — open any product profile to see them. Rankings use the Data Index; vendors cannot pay to change a position. Found an error? Tell us.
- ADA Health Policy Institute: dental practice research — survey data on practice income, expenses and busyness
- ADA: managing the dental practice (finances)