Collections were $141,000 last month against $180,000 of production. 78%? That sounds alarming until you remember that $27,000 of the production was never collectable, because the PPO contract said so. The real question is what happened to the other $12,000.
Net collection rate is the KPI that answers it, once the formula is right.
What is the formula?
Net collection rate = payments received divided by (gross production minus contractual adjustments), over the same trailing window.
Three choices that change the answer:
- Contractual only. Subtract PPO, HMO and Medicaid write-offs. Do not subtract courtesy adjustments, discounts or bad debt; those are collection failures and belong in the numerator’s shortfall.
- Payments received, not payments posted. Refunds come off. Prepayments for treatment not yet done should be excluded or they inflate the month.
- A trailing window. 90 days at least, 12 months for the figure you compare year to year. Claims sent in September are paid in October; a single month’s ratio is production from one month against collections from another.
A worked example, trailing 90 days:
- Gross production: $540,000
- Contractual adjustments: $81,000
- Net production: $459,000
- Payments received: $441,000
- Refunds: $3,000
- Net payments: $438,000
Net collection rate = $438,000 divided by $459,000 = 0.954, or 95.4%.
The gap is $21,000 over the quarter. That is the number to go looking for.
Gross collection rate, by contrast, is payments divided by gross production: $438,000 divided by $540,000 = 81.1%. It is a useful number for judging PPO contracts (it tells you what share of your fee each plan actually pays) and a useless one for judging the billing desk, because the desk cannot collect a contractual write-off. Keep both, and be clear which one you are quoting.
Why is there no benchmark on this page?
Because the sources that quote one do not state the formula. A practice that subtracts courtesy adjustments as well as contractual ones will report a higher rate for the same cash. A practice that uses a one-month window will report anything. If a consultant gives you a target, ask which adjustments they subtract and over what window, then calculate yours the same way before comparing. Compare yourself to yourself: this quarter against the last four.
Why does it drift down?
1. Claims not followed up. The 4 September claim that nobody chased. Check the insurance aging report: claims over 30 days, count and dollars. The insurance coordinator page has the daily routine that keeps this list short.
2. Patient share not collected at the visit. Statements sent for $40 balances cost more than they collect, and the balance ages. Check: patient AR over 90 days as a share of patient AR.
3. Adjustments misclassified. A courtesy write-off coded as a PPO adjustment moves a collection failure out of the formula. Check: run adjustments by type and by user monthly. The write-off report page covers this.
4. Insurance payments posted without the adjustment, or the adjustment posted without the payment. The first leaves a false patient balance; the second hides a short payment. Check: every insurance payment should have an adjustment on the same claim, dated the same day.
How do you fix it?
| Cause | Weekly action | Owner’s check |
|---|---|---|
| Unworked claims | 45 minutes on claims over 30 days, oldest first | Claims over 30 days, dollars, trending down |
| Patient share | Ask for the estimated share at check-in, every visit | Patient AR over 90 days as share of patient AR |
| Misclassified adjustments | Adjustment types reviewed and locked by role | Non-contractual adjustments as share of production |
| Payment without adjustment | EOB posted and adjusted by the same person, same sitting | Claims with payment and no adjustment, count |
Each point of net collection rate on $1.8 million of annual net production is $18,000. From 95.4% to 98% is about $47,000 a year, with no new patients.
What Calibic adds
The KPI dashboards and the insurance, claims and AR view are LIVE. Calibic reads production, adjustments and payments from Open Dental, Dentrix and Eaglesoft (read-only, it never changes a record), calculates net collection rate over trailing 90-day and 12-month windows with the formula shown, splits contractual from non-contractual adjustments using your own adjustment type names, and opens every figure to its rows. The dental KPIs page places this number among the other eleven.
Next step: put your own quarter into the collection rate calculator.