pre-Jul 16, 2026 insurance is from the SoftDent conversion
Office Breakdown
| Office | Patients | Gross Prod | Kasper Prod | Net Prod (excl. conv) | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| SL Dental | 54 (0 new) | $15,858 | — | $15,858 | $24,037 152% | — | — | 100% | 0% | 0 |
| JT Dental Group | 3 (1 new) | $880 | — | $880 | $5,313 604% | — | — | 100% | 0% | 0 |
| Stannum | 23 (1 new) | $13,765 | — | $13,765 | $4,404 32% | — | — | 100% | 0% | 0 |
| San Bruno | 36 (1 new) | $17,491 | — | $17,491 | $22,791 130% | — | — | 100% | 0% | 0 |
| TOTAL | 116 | $47,994 | — | $47,994 | $56,545 | — | — | 100% | 0 |
Patient Mix age & insurance
Breakdown of patients seen 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 | 28 85% | 5 15% | 0 | 0 | 21 39% | 5 9% | 28 52% |
| JT Dental Group | 1 50% | 1 50% | 0 | 1 | 1 33% | 2 67% | 0 0% |
| Stannum | 16 100% | 0 0% | 1 | 0 | 7 30% | 3 13% | 13 57% |
| San Bruno | 22 100% | 0 0% | 0 | 0 | 15 42% | 10 28% | 11 31% |
| TOTAL | 67 92% | 6 8% | 1 | 1 | 44 38% | 20 17% | 52 45% |
Age Mix by Office
Insurance Mix by Office
Net Production by Insurance Cash · PPO · Medicaid
Net production (gross + debit adj − credit adj − write-offs, excluding SoftDent conversion adjustments) 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 | $3,371 21% | $1,890 12% | $10,596 67% | $15,858 |
| JT Dental Group | $400 45% | $480 55% | $0 0% | $880 |
| Stannum | $5,567 40% | $2,176 16% | $6,022 44% | $13,765 |
| San Bruno | $10,047 57% | $2,532 14% | $4,912 28% | $17,491 |
| TOTAL | $19,386 40% | $7,078 15% | $21,530 45% | $47,994 |
Net Production by Insurance
Payer Share of Net Production
Phone Metrics (Kasper) answer rate = answered / (incoming + 2×voicemails), Kasper's formula
| Office | Total Calls | Incoming | Outgoing | Answered | Missed | Abandoned | Answer Rate |
|---|---|---|---|---|---|---|---|
| SL Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| JT Dental Group | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Stannum | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| San Bruno | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
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 30 01:40 PM CT — 4 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| SL Dental | Oct 30 | Current | $60,062 | $24,672 | +143% |
| JT Dental Group | Dec 31 | Current | $114,006 | $79,692 | +43% |
| Stannum | Oct 30 | Current | $76,674 | $60,483 | +27% |
| San Bruno | Oct 29 | Current | $92,056 | $78,246 | +18% |