Skip to content
Why your dental KPIs are wrong on cash basis
Problems

Why Every Dental Practice KPI Is Wrong If You’re Using Cash Basis Revenue

Greg Hudnall
Greg Hudnall

Problems  ·  7 min read

On cash basis your KPIs track how fast your insurance carriers pay, not how your practice runs, so every ratio you calculate is distorted.

Overhead percentage. Supply cost as a percent of revenue. Staffing ratio. Lab fee percentage. These are the numbers dental consultants, study groups, and industry benchmarks tell you to track. And they’re right. These KPIs are how you know whether your practice is healthy.

But here’s the problem almost nobody talks about: every single one of these KPIs has revenue as the denominator. And if your revenue number is cash basis collections, the denominator moves every month based on when insurance payments land, not based on anything you or your team did.

That means every ratio you calculate from cash basis revenue is measuring the wrong thing. You’re not benchmarking your practice performance. You’re benchmarking your insurance carriers’ processing speed.

 

The Math Behind the Problem

Almost every dental practice KPI follows the same formula:

KPI = Expense Category ÷ Revenue

Dental supply percentage: supply spend divided by revenue. Staffing ratio: total compensation divided by revenue. Overhead: total expenses divided by revenue. Lab fees as a percent of collections. Marketing spend as a percent of revenue. All of them.

When the numerator (the expense) is relatively stable month to month, which it usually is, the KPI’s volatility comes entirely from the denominator. If revenue swings 25% because of insurance timing, every single ratio swings with it.

 

A Concrete Example

Dr. Rivera’s practice has consistent monthly expenses. Staff costs are about $42,000. Dental supplies run about $9,500. Lab fees are about $8,000. These numbers don’t change much month to month.

But cash basis revenue swings:

 JanuaryFebruary
Collections$182,000$120,000
Payroll$42,000$42,000
Staffing ratio23%35%

Same expenses every month. The KPIs swing wildly. In January, staffing looks lean at 23%. In February, the same payroll looks bloated at 35%. Nothing changed operationally. The only thing that changed was when insurance checks arrived.

If a consultant looked at February in isolation, they might tell Dr. Rivera to cut staff. That would be a decision based entirely on insurance processing timing, not practice performance.

 

Which Denominator Should You Actually Use?

The answer depends on what you’re trying to measure.

Net production (gross production minus PPO adjustments) is the most stable denominator for operational KPIs. It reflects what your practice actually did, measured on the date of service. It doesn’t move based on insurance timing. When you benchmark overhead, supplies, lab fees, and staffing against net production, you’re measuring practice efficiency.

Net collections (what you actually received, minus refunds) is the right denominator for financial KPIs like profitability and cash flow analysis. But it needs to be measured over longer periods (quarterly or trailing 12 months) to smooth out the insurance timing noise. Month-to-month net collections are too volatile to benchmark against.

Commonly cited dental practice benchmarks (supplies at 5 to 7%, lab at 5 to 7%, staffing at 25 to 30%) are measured against net collections, but they’re calculated on an annual or trailing basis, not month to month. When you try to apply those same benchmarks to a single month of cash basis revenue, you’re using the right benchmark against the wrong number.

 

What Each KPI Actually Measures on Cash Basis

Here’s the uncomfortable truth about what your KPIs are actually telling you when calculated against cash basis monthly revenue:

Staffing ratio on cash basis: How fast your insurance carriers processed claims this month, relative to your fixed payroll cost. It does not tell you whether your team is appropriately sized for your production volume.

Supply percentage on cash basis: Same problem. A low-collection month makes supply spending look high. A high-collection month makes it look low. The actual supply spend didn’t change.

Lab fee percentage on cash basis: Meaningless on a monthly basis. Lab invoices are tied to procedures performed. Collections are tied to when carriers pay. There’s no reason these two numbers should align in any given month.

Overhead ratio on cash basis: The sum of all the above problems. Total overhead divided by volatile cash collections produces a number that tells you almost nothing about whether your practice is running efficiently.

Marketing ROI on cash basis: Your marketing spend is consistent. New patient revenue from marketing takes 4 to 8 weeks to show up as insurance collections. On a cash basis, you’re comparing this month’s marketing spend to last month’s patient revenue. The lag makes the calculation useless for month-to-month evaluation.

 

The Front Desk Problem

There’s another layer to this. When you use cash collections as your revenue denominator, you’re partly measuring how well your front desk collects at the point of service and how aggressively your billing team follows up on outstanding claims.

That’s not nothing. Front desk collections matter. But it’s a completely different question than whether your practice is operationally efficient. A practice with excellent production and terrible front desk collections will show great KPIs in months when old insurance payments catch up, and terrible KPIs in months when they don’t. The underlying operational efficiency hasn’t changed.

If you want to measure front desk performance, measure it directly: patient copay collection rate, percentage of claims submitted within 24 hours, days in accounts receivable. Don’t let it contaminate your operational KPIs by running everything through a cash basis denominator.

 

How to Fix This

The fix is straightforward but requires your accounting to work differently:

Step 1: Get monthly production data from your PMS. Your practice management software (Open Dental, Dentrix, Eaglesoft) already tracks production by date of service. This number needs to be pulled monthly and made available alongside your financial statements.

Step 2: Calculate net production. Gross production minus PPO contractual adjustments. This is your stable denominator for monthly operational KPIs.

Step 3: Benchmark expenses against net production monthly. Supply percentage, lab percentage, staffing ratio, total overhead. Use net production as the denominator for all of these on a monthly basis.

Step 4: Use net collections for annual and trailing benchmarks. When you’re looking at full-year or trailing 12-month numbers, net collections is appropriate because the insurance timing noise washes out over longer periods.

This gives you two sets of KPIs that each tell you something useful. Monthly production-based KPIs tell you about operational efficiency. Annual collections-based KPIs tell you about financial performance. Both matter. They measure different things.

 

What This Looks Like in Practice

Here’s Dr. Rivera’s practice with the same data, recalculated against net production:

 JanuaryFebruary
Net production$146,000$146,000
Staffing ($42,000)28%28%
Supplies6.5%6.5%
Lab5.5%5.5%

Stable. Consistent. Benchmarkable. The practice is running at about 28% staffing (within the 25 to 30% benchmark range). Supplies at 6.5% (healthy). Lab fees at 5.5% (healthy). These numbers actually tell you something about the practice. The cash basis numbers didn’t.

 

Frequently Asked Questions

Should I stop tracking collections entirely?

No. Collections matter. You need cash to pay bills. But track collections as their own metric, not as the denominator for every other KPI. Your collection rate (net collections divided by net production, measured quarterly or annually) tells you how well you’re converting production into cash. That’s the financial health metric. Your monthly operational KPIs should use production as the base.

What benchmarks should I use for production-based KPIs?

Commonly cited dental practice benchmarks are based on net collections, but the percentages are similar when measured against net production because a healthy practice collects 98 to 100% of net production over time. Use the same target ranges (supplies 5 to 7%, lab 5 to 7%, staffing 25 to 30%) but calculate them monthly against net production for operational tracking.

My consultant gives me KPIs based on collections. Are those wrong?

Not wrong, but potentially misleading on a monthly basis. If your consultant is looking at trailing 12-month collections, the insurance timing noise washes out and the numbers are reliable. If they’re reacting to a single month’s KPIs calculated against cash collections, they may be diagnosing insurance timing as an operational problem.

Can my bookkeeper calculate production-based KPIs?

A dental-specific accountant can, because they pull production data from your practice management software and integrate it into your monthly reporting. A generalist bookkeeper typically works from bank deposits only and doesn’t have access to production data. This is one of the core differences between general bookkeeping and dental-specific accounting.

P.S. Reciprocity Accounting builds your books on accrual so your dental KPIs are based on real numbers, not cash-basis distortions. See how we can help your practice.

Share this post