Practice management software can produce hundreds of reports. Consultants sell dashboards with forty tiles. Meanwhile, many owners still find out about a problem when payroll feels tight, which is usually three months after the numbers started moving.
A good KPI does one job: it tells you early that something needs attention, and it points at what to fix. This post covers the dozen or so metrics that meet that bar for a general practice, with exact formulas, where to pull them, and rough healthy ranges. It also names the popular numbers that look important and rarely change a decision.
Key takeaways
- A KPI is worth tracking only if it is measured consistently, reviewed on a set schedule, and tied to an action you would actually take.
- The core set for most practices: net collection rate, production per hour (doctor and hygiene), active patients, new patients, hygiene reappointment rate, case acceptance, unscheduled treatment, A/R over 90 days, broken appointment rate, and overhead.
- Definitions matter more than targets. "Active patient," "collection rate," and "case acceptance" are calculated many different ways. Pick a definition, write it down, and never change it quietly.
- Healthy ranges in this post are approximate, commonly cited figures that vary by practice type and market. Your own trend line is the most useful benchmark you have.
- Gross production alone, total patients in the database, and daily patient counts are popular numbers that rarely tell you what to do.
What makes a KPI worth tracking
Before adding any number to a dashboard, run it through three tests:
- Can you measure it the same way every month? If the number depends on someone remembering to mark a checkbox, it will drift.
- Does it lead or only lag? Collections are a lagging result. Hygiene reappointment and unscheduled treatment are leading indicators of future collections. You want both kinds, but leading indicators give you time to act.
- Is there an action attached? If the number moved 10% in the wrong direction, what would you do? If the honest answer is "nothing," it does not belong on the dashboard.
The core KPI dashboard
The table below is the short list. Ranges are rough, typical figures commonly used by dental consultants and CPAs; they vary with payer mix, specialty, and region, and should be read as a starting point rather than a standard.
| KPI | Formula | Approximate healthy range | Review |
|---|---|---|---|
| Net collection rate | Collections divided by (gross production minus contractual write-offs) | High 90s percent | Monthly |
| Doctor production per hour | Doctor production divided by doctor clinical hours scheduled | Your own trend; varies widely by procedure mix | Monthly |
| Hygiene production per hour | Hygiene production divided by hygiene hours scheduled | Your trend; compare to hygienist cost (see below) | Monthly |
| Active patients | Unique patients with a completed visit in the last 18 months (or your written definition) | Stable or growing | Quarterly |
| New patients | Patients with a first completed visit in the period | Enough to exceed attrition | Monthly |
| Hygiene reappointment rate | Hygiene patients who leave with next visit scheduled, divided by hygiene patients seen | Commonly targeted in the high 80s percent or better | Weekly |
| Case acceptance (dollars) | Dollars of treatment scheduled or completed, divided by dollars presented, in a defined window | Your trend; varies with case size | Monthly |
| Unscheduled treatment | Dollars of diagnosed, accepted-or-pending treatment with no appointment | Declining over time | Monthly |
| A/R over 90 days | Patient and insurance balances over 90 days, divided by total A/R | Commonly targeted below about 10% to 15% | Monthly |
| Broken appointment rate | Broken or no-show appointments divided by appointments scheduled | Low single digits percent | Weekly |
| Overhead | Normalized operating expenses divided by collections | Roughly 58% to 65% for a GP, excluding doctor pay | Monthly (trailing 12) |
Eleven numbers. A practice that reviews these consistently will catch most problems months before they show up in the owner's paycheck.
Defining each KPI correctly
Net collection rate
This is the percentage of collectible production you actually collect. The key word is collectible: contractual PPO write-offs are removed from production first, because you never had a right to those dollars. A practice with $1,000,000 in gross production, $220,000 in PPO write-offs, and $765,000 in collections has a net collection rate of $765,000 divided by $780,000, or about 98%. Its gross collection rate is 76.5%, which is a useful fee schedule indicator but not a collections performance measure.
Two cautions. First, a collection rate over 100% for a single month is normal (last month's claims got paid); use a trailing three or twelve months. Second, a high rate can hide a practice that is quietly adjusting off balances instead of collecting them. Watch non-contractual adjustments as their own number.
Production per hour
Total production is a volume number. Production per scheduled hour is an efficiency number, and it is the one that tells you whether the schedule is built well. Split it by provider type. Doctor production per hour moves with procedure mix, scheduling strategy, and assistant support. Hygiene production per hour moves with perio diagnosis, adjunctive services, and schedule fill. Our scheduling strategy chapter covers how to build a schedule that raises it.
Active patients
The most commonly used definition is a patient with a completed visit in the last 18 months, though some practices use 12 or 24. Whatever you choose, write it down and use it forever. When buying a practice, ask exactly how the seller counted, because loose definitions inflate the number. The trend matters more than the count: an active base that has shrunk 3% a year for three years is a slow emergency even if new patient numbers look fine.
New patients and net growth
New patients alone can mislead. What matters is whether new patients exceed attrition. A simple quarterly check: active patients this quarter minus active patients the same quarter last year. If that number is negative while you are seeing plenty of new patients, your retention problem is bigger than your marketing problem. Track new patients by source so you know which channels work; our marketing budget guide explains how to turn that into cost per new patient.
Hygiene reappointment rate
This is the single best leading indicator of future practice stability, which is why buyers examine it in diligence. Measure it as hygiene patients who leave with their next hygiene appointment scheduled, divided by hygiene patients seen in the period. Exclude patients who are deceased, moved, or transferred. A falling reappointment rate predicts a thinner hygiene schedule four to six months out, and with it fewer exams and less restorative diagnosis.
Case acceptance
Define it in dollars, not in number of plans, and set a fixed window (for example, treatment presented in a month that is scheduled or completed within 60 days). Counting plans gives the same weight to a single filling and a full-arch case. Most practices track this poorly because treatment plans are not consistently marked as presented. Fix the process before trusting the number. Our case presentation chapter covers both the process and the conversation.
Unscheduled treatment
Diagnosed treatment with no appointment is revenue the practice has already earned the right to pursue. Track the dollar total monthly and assign someone to work the list. A rising total means either acceptance or scheduling follow-up is breaking down.
A/R over 90 days
Look at patient and insurance aging separately. Insurance over 90 days usually means claims were denied, lost, or never sent. Patient balances over 90 days usually mean estimates were wrong or statements are not going out. Both are process problems with specific fixes, covered in our billing and A/R module.
Broken appointment rate
Measure broken and no-show appointments against total scheduled, separately for hygiene and doctor. A rising rate in hygiene is often the first sign of confirmation process problems. In the doctor schedule, it often points at large cases scheduled before the financial conversation was finished.
The KPIs that aren't worth your attention
| Metric | Why it misleads | Track this instead |
|---|---|---|
| Gross production by itself | Inflated by write-offs you will never collect; rewards high fees on paper | Net collections and net collection rate |
| Total patients in the database | Includes people who left years ago | Active patients, with a fixed definition |
| Patients seen per day | Rewards volume regardless of what was done | Production per scheduled hour |
| Number of treatment plans presented | Easy to inflate; says nothing about value accepted | Dollar-based case acceptance |
| Monthly overhead percentage | Swings with payroll timing and bulk orders | Trailing twelve-month overhead by category |
| Website visits or social followers | No link to patients unless you track conversion | New patients by source and cost per new patient |
| Star rating alone | Moves slowly and is shaped by review volume | New reviews per month and response time |
None of these are useless as context. The problem is that they get treated as results, and chasing them can make things worse. A practice that pushes patients seen per day up can easily push production per hour and case acceptance down.
Where to pull the numbers in Open Dental
If you use Open Dental, most of the dashboard comes from the Standard Reports list (Reports, then Standard). Report names below are from the Open Dental online manual; availability and options can vary by version. Other practice management systems have equivalents under different names.
| KPI | Open Dental report |
|---|---|
| Production, collections, write-offs | Production and Income reports; Daily Write-off Report; PPO Write-offs Report |
| Active patients | Active Patients Report (confirm how it defines active in your version) |
| New patients and sources | New Patients Report; Referral Analysis Report |
| Case acceptance | Treatment Plan Presentation Statistics Report; Presented Treatment Production Report |
| Unscheduled treatment | Treatment Finder Report |
| A/R aging | Aging of Accounts Receivable (A/R) Report; Insurance Aging Report; Outstanding Insurance Claims Report |
| Broken appointments | Broken Appointments Report |
| Production goals | Monthly Production Goal Report |
Hygiene reappointment rate usually is not a single standard report. The Recall List (opened from Appointment Lists) shows patients by recall due date, but a true reappointment percentage generally requires a user query. Our reports and queries module and scheduling and recall module cover the setup.
Save the settings, not just the numbers. Many reports let you choose date ranges, providers, and how write-offs are counted. Write down the exact settings you use for each KPI and use them every month. Otherwise a new office manager can change a number without changing anything about the practice.
Worked example: reading one month's dashboard (hypothetical)
Hypothetical example. A two-doctor practice reviews its trailing three months in September. All numbers are invented.
| KPI | Same period last year | This year | Signal |
|---|---|---|---|
| Net collection rate | 98.5% | 97.9% | Stable |
| Doctor production per hour | $640 | $655 | Stable |
| Hygiene production per hour | $185 | $172 | Down 7% |
| Hygiene reappointment rate | 88% | 79% | Down 9 points |
| Broken appointment rate, hygiene | 4% | 8% | Doubled |
| New patients per month | 38 | 41 | Up |
| Unscheduled treatment | $210,000 | $265,000 | Up 26% |
Collections look fine and new patients are up, so a quick glance says all is well. The leading indicators say otherwise. Reappointment has dropped nine points and hygiene breakage has doubled, which together predict a thinner hygiene schedule this winter. That in turn means fewer exams and less diagnosis, which is already visible in the growing unscheduled treatment total.
The likely cause is a process change in hygiene checkout or confirmations, perhaps a new front desk hire or a change in who schedules the next visit. That is a fixable problem, and catching it in September instead of February is the whole point of the dashboard.
How often to look at what
| Cadence | What to review | Who |
|---|---|---|
| Daily (morning huddle) | Today's scheduled production vs. goal, open hygiene slots, unscheduled treatment for today's patients | Whole team |
| Weekly | Hygiene reappointment, broken appointments, next two weeks' schedule fill | Office manager and owner |
| Monthly | Collections and collection rate, production per hour, new patients by source, case acceptance, unscheduled treatment, A/R aging | Owner, office manager |
| Quarterly | Active patient trend, overhead by category (trailing twelve), fee schedule and payer mix | Owner, with CPA as needed |
The morning huddle is the right place for the daily items; our systems and workflows chapter describes a huddle format that covers them in ten minutes.
Setting up your KPI dashboard
- Write a one-line definition for each KPI, including date windows and exclusions
- Record the exact report and settings used to pull each number
- Pull twelve months of history so you have a trend from day one
- Assign an owner for each KPI who explains changes at the monthly review
- Pair every KPI with the action you would take if it moved the wrong way
- Review leading indicators (reappointment, breakage, unscheduled treatment) weekly
- Drop any number nobody has acted on in six months
Start small and stay consistent
If you track nothing today, start with four: net collection rate, hygiene reappointment rate, new patients, and unscheduled treatment. Add the rest once those are pulled reliably every month. A short dashboard reviewed consistently beats a long one reviewed when someone remembers.
From here, read how to measure hygiene profitability for the hygiene side of the dashboard, overhead benchmarks by category for the expense side, and Financial Management for Practice Owners for how these numbers connect to the P&L. If you are evaluating a practice to buy, the same KPIs are the backbone of operational diligence in our acquisition guide.
Educational content only. It is not legal, financial, tax, or clinical advice. Prices and ranges are approximate and vary by region, condition, and year. Verify current rules with your state dental board and qualified professionals. ChairsideSource is not affiliated with any manufacturer, the ADA, or the DAT.