Office Breakdown
| Office | Patients | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 19 (8 new) | $6,841 | — | $6,905 | $2,517 37% | — | $78,881 | 100% | 88% | 0 |
| Carnival Dental | 15 (7 new) | $5,265 | — | $5,119 | $1,191 23% | — | $92,380 | 80% | 51% | 4 |
| Carousel Dental | 11 (3 new) | $2,466 | — | $2,168 | $111 4% | — | $100,317 | 55% | 93% | 9 |
| Globo Dental | 9 (2 new) | $3,285 | — | $2,916 | $2,945 90% | — | — | 71% | 25% | 4 |
| Laguna Dental | 0 (0 new) | $0 | — | $0 | $2,667 0% | — | — | 0% | 0% | 0 |
| Marina Dental | 10 (3 new) | $1,663 | — | $1,311 | $2,334 140% | — | $64,062 | 100% | 14% | 0 |
| NLD Dental | 16 (9 new) | $6,267 | — | $6,218 | $2,681 43% | — | $76,776 | 86% | 83% | 4 |
| TOTAL | 80 | $25,786 | — | $24,638 | $14,446 | — | $412,416 | 81% | 21 |
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.
No age/insurance data for this date range yet. The breakdown started collecting when this section launched and back-fills about 30 days — it lands with the next hourly data cycle, so recent dates fill in automatically.
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.
No production-by-insurance data for this date range yet. Collection started when this section launched and back-fills about 30 days — it lands with the next hourly data cycle.
Phone Metrics (Kasper)
| Office | Total Calls | Incoming | Outgoing | Answered | Missed | Abandoned | Answer Rate |
|---|---|---|---|---|---|---|---|
| Arcade Dental | 41 | 17 | 22 | 16 | 1 | 0 | 94.1% |
| Carnival Dental | 106 | 25 | 81 | 21 | 4 | 0 | 84.0% |
| Carousel Dental | 102 | 33 | 68 | 29 | 4 | 0 | 87.9% |
| Globo Dental | 54 | 28 | 25 | 14 | 14 | 0 | 50.0% |
| Laguna Dental | 84 | 49 | 34 | 37 | 12 | 0 | 75.5% |
| Marina Dental | 80 | 43 | 35 | 32 | 11 | 0 | 74.4% |
| NLD Dental | 28 | 27 | 1 | 23 | 4 | 0 | 85.2% |
| TOTAL | 495 | 222 | 266 | 172 | 50 | 0 | 77.5% |
Orthodontics (Cloud9) as of Jun 10
| Office | Next Ortho Day | Exams That Day | Starts (MTD) |
|---|---|---|---|
| Arcade Dental | Sat, Jun 13 | 11 | 0 |
| Carnival Dental | Wed, Jun 10 | 18 | 15 |
| Carousel Dental | Thu, Jun 11 | 21 | 6 |
| Globo Dental | Wed, Jun 17 | 9 | 10 |
| Laguna Dental | Fri, Jun 19 | 29 | 5 |
| Marina Dental | Mon, Jun 15 | 22 | 14 |
| NLD Dental | Wed, Jun 10 | 4 | 13 |
Data Health
OpenDental is the source of truth for production; Kasper is an independent cross-check. A large negative variance means Kasper sees production OpenDental is missing — usually a stalled upload at that office.
Verified Auto-verified twice daily (upload freshness + OD↔Kasper reconciliation). Last run Sep 16, 07:30 PM CT — 7 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Sep 16 | Current | $22,765 | $21,302 | +7% |
| Carnival Dental | Sep 16 | Current | $35,060 | $34,444 | +2% |
| Carousel Dental | Sep 16 | Current | $28,001 | $27,032 | +4% |
| Globo Dental | Sep 16 | Current | $17,436 | $16,618 | +5% |
| Laguna Dental | Sep 16 | Current | $24,435 | $24,121 | +1% |
| Marina Dental | Sep 16 | Current | $22,294 | $19,706 | +13% |
| NLD Dental | Sep 16 | Current | $20,349 | $20,059 | +1% |