pre-Jul 16, 2026 insurance is from the SoftDent conversion
Office Breakdown
| Office | Visits | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| SL Dental | 11208 (426 new) | $4,876,070 | $1,956,668 | $4,299,386 | $3,632,708 74% | $1,171,760 | — | 99% | 0% | 121 |
| JT Dental Group | 7494 (480 new) | $6,968,900 | $2,149,887 | $6,865,104 | $5,025,264 72% | $1,626,435 | — | 99% | 0% | 81 |
| Stannum | 7136 (598 new) | $2,812,618 | $1,077,255 | $2,802,770 | $2,288,635 81% | $761,162 | — | 100% | 0% | 2 |
| San Bruno | 10736 (683 new) | $5,947,629 | $2,159,356 | $4,262,192 | $4,615,410 78% | $1,527,983 | — | 100% | 0% | 5 |
| TOTAL | 36574 | $20,605,217 | $7,343,166 | $18,229,451 | $15,562,017 | $5,087,340 | — | 100% | 209 |
Patient Mix age & insurance
Breakdown of patient visits by age (18+ vs under 18) and by insurance type. Insurance comes from each patient's active primary coverage: Medicaid includes Medicaid, CHIP and STAR managed-care plans (DentaQuest, MCNA, UHC/Molina/Superior, TMHP); any other active dental insurance counts as PPO; no active coverage = Cash. Patients missing a birthdate are left out of the age split.
| Office | 18+ (Adults) | Under 18 (Kids) | New Pts 18+ | New Pts <18 | Cash | PPO | Medicaid |
|---|---|---|---|---|---|---|---|
| SL Dental | 7748 90% | 837 10% | 250 | 28 | 2809 25% | 1760 16% | 6639 59% |
| JT Dental Group | 5201 90% | 605 10% | 294 | 16 | 2184 29% | 4961 66% | 349 5% |
| Stannum | 5373 91% | 525 9% | 379 | 31 | 1447 20% | 2412 34% | 3277 46% |
| San Bruno | 8234 92% | 691 8% | 381 | 74 | 2170 20% | 3800 35% | 4766 44% |
| TOTAL | 26556 91% | 2658 9% | 1304 | 149 | 8610 24% | 12933 35% | 15031 41% |
Age Mix by Office
Insurance Mix by Office
Net Production by Insurance Cash · PPO · Medicaid
Net production (gross + debit adj − credit adj − write-offs) attributed to each patient's payer type, using the same classification as Patient Mix. The three buckets add up to the Net Prod column in Office Breakdown.
| Office | Cash | PPO | Medicaid | Total Net |
|---|---|---|---|---|
| SL Dental | $1,100,255 26% | $861,327 20% | $2,316,674 54% | $4,278,256 |
| JT Dental Group | $2,082,481 30% | $4,624,755 67% | $158,193 2% | $6,865,429 |
| Stannum | $502,040 18% | $1,394,533 50% | $906,197 32% | $2,802,770 |
| San Bruno | $1,123,548 26% | $1,695,918 39% | $1,579,647 36% | $4,399,113 |
| TOTAL | $4,808,324 26% | $8,576,533 47% | $4,960,710 27% | $18,345,567 |
Net Production by Insurance
Payer Share of Net Production
Phone Metrics (Kasper) answer rate = answered / (incoming + 2×voicemails), Kasper's formula
Partial range: Kasper phone data starts Oct 01, 2026, so these call counts cover Oct 01, 2026 onward only.
| Office | Total Calls | Incoming | Outgoing | Answered | Missed | Abandoned | Answer Rate |
|---|---|---|---|---|---|---|---|
| SL Dental | 4346 | 1934 | 2305 | 1452 | 481 | 249 | 67.6% |
| JT Dental Group | 2884 | 1449 | 1417 | 1274 | 175 | 85 | 85.8% |
| Stannum | 2236 | 1215 | 919 | 878 | 337 | 145 | 61.9% |
| San Bruno | 4349 | 1814 | 2384 | 1292 | 521 | 173 | 61.1% |
| TOTAL | 13815 | 6412 | 7025 | 4896 | 1514 | 652 | 68.3% |
Data Health
OpenDental is the source of truth for production; Kasper is an independent cross-check. Kasper cross-check covers the last 7 days on which Kasper has production (Kasper trails OpenDental 1–3 days). Freshness tracks the latest completed-procedure date each office has synced through the API.
Verified Auto-verified twice daily (OD↔Kasper reconciliation, days 3–10 back). Last run Oct 27 09:31 PM CT — 4 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| SL Dental | Oct 27 | Current | $49,842 | $67,920 | -27% |
| JT Dental Group | Oct 27 | Current | $160,359 | $155,109 | +3% |
| Stannum | Oct 27 | Current | $60,026 | $59,694 | +1% |
| San Bruno | Oct 27 | Current | $99,889 | $96,106 | +4% |