Office Breakdown
| Office | Patients | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 17 (1 new) | $6,493 | — | $6,493 | $5,341 82% | — | $78,881 | 74% | 90% | 6 |
| Carnival Dental | 0 (0 new) | $0 | — | $0 | $108 0% | — | $92,380 | 0% | 0% | 8 |
| Carousel Dental | 13 (10 new) | $6,326 | $6,169 | $6,066 | $2,918 46% | $2,918 | $100,317 | 76% | 80% | 4 |
| Globo Dental | 14 (3 new) | $2,849 | $2,759 | $2,759 | $579 20% | $579 | — | 58% | 36% | 10 |
| Laguna Dental | 14 (4 new) | $6,766 | $4,076 | $4,076 | $1,598 24% | $1,598 | — | 100% | 30% | 0 |
| Marina Dental | 14 (4 new) | $4,379 | $2,791 | $2,791 | $2,115 48% | $2,115 | $64,062 | 100% | 17% | 0 |
| NLD Dental | 0 (0 new) | $0 | — | $0 | $27 0% | $27 | $76,776 | 0% | 0% | 0 |
| TOTAL | 72 | $26,813 | $15,794 | $22,185 | $12,687 | $7,238 | $412,416 | 72% | 28 |
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 | 67 | 21 | 46 | 14 | 7 | 0 | 66.7% |
| Carnival Dental | 195 | 49 | 146 | 38 | 11 | 0 | 77.6% |
| Carousel Dental | 92 | 26 | 66 | 25 | 1 | 0 | 96.2% |
| Globo Dental | 111 | 29 | 81 | 22 | 7 | 0 | 75.9% |
| Laguna Dental | 92 | 28 | 63 | 24 | 4 | 0 | 85.7% |
| Marina Dental | 111 | 35 | 72 | 29 | 6 | 0 | 82.9% |
| NLD Dental | 42 | 12 | 26 | 8 | 4 | 4 | 66.7% |
| TOTAL | 710 | 200 | 500 | 160 | 40 | 4 | 80.0% |
Orthodontics (Cloud9) as of Oct 19
| Office | Next Ortho Day | Exams That Day | Starts (MTD) |
|---|---|---|---|
| Arcade Dental | Thu, Oct 22 | 0 | 9 |
| Carnival Dental | Wed, Oct 28 | 17 | 12 |
| Carousel Dental | Mon, Oct 19 | 8 | 4 |
| Globo Dental | Wed, Oct 21 | 10 | 12 |
| Laguna Dental | Mon, Oct 26 | 12 | 7 |
| Marina Dental | Tue, Oct 20 | 18 | 17 |
| NLD Dental | Thu, Oct 22 | 21 | 24 |
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 Oct 19, 07:30 PM CT — 7 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Oct 17 (2 biz days behind) | Lagging | $19,447 | $19,447 | -0% |
| Carnival Dental | Oct 17 (2 biz days behind) | Lagging | $17,253 | $17,191 | +0% |
| Carousel Dental | Oct 17 (2 biz days behind) | Lagging | $33,141 | $32,605 | +2% |
| Globo Dental | Oct 17 (2 biz days behind) | Lagging | $32,834 | $31,397 | +5% |
| Laguna Dental | Oct 17 (2 biz days behind) | Lagging | $18,149 | $17,550 | +3% |
| Marina Dental | Oct 16 (2 biz days behind) | Lagging | $26,513 | $25,527 | +4% |
| NLD Dental | Oct 19 | Current | $20,607 | $20,545 | +0% |