Office Breakdown
New Pts is each office's new patients in this range: a completed new-patient exam (D0150, D0145, or D0180) on the patient's first visit. Days add up without counting the same patient twice. Embrace Ortho is Cloud9's dismissed new-patient exams and is not included in Total.
| Office | Patients | New Pts | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 11 (1 new) | 1 | $1,884 | — | $1,884 | $3,746 199% | — | — | 100% | 94% | 0 |
| Carnival Dental | 1 (1 new) | 1 | $231 | — | $231 | $2,165 939% | — | — | 100% | 100% | 0 |
| Carousel Dental | 19 (5 new) | 5 | $3,555 | — | $3,521 | $2,403 68% | — | — | 100% | 31% | 0 |
| Globo Dental | 0 (2 new) | 2 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Laguna Dental | 23 (5 new) | 5 | $5,742 | — | $5,708 | $3,459 60% | — | — | 92% | 61% | 2 |
| Marina Dental | 19 (7 new) | 7 | $7,680 | — | $7,679 | $7,738 101% | — | — | 95% | 80% | 1 |
| NLD Dental | 3 (3 new) | 3 | $1,206 | — | $1,206 | $2,130 177% | — | — | 75% | 81% | 1 |
| Embrace Ortho Jan 2 not in Cloud9 daily yet | — | — | — | — | — | — | — | — | — | — | — |
| TOTAL | 76 | 24 | $20,297 | — | $20,228 | $21,642 | — | — | 95% | 4 |
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 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Carnival Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Carousel Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Globo Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Laguna Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| Marina Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| NLD Dental | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
| TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0.0% |
Orthodontics (Cloud9) as of Nov 07
| Office | Next Ortho Day | Exams That Day | Starts (MTD) |
|---|---|---|---|
| Arcade Dental | Tue, Nov 10 | 0 | 4 |
| Carnival Dental | Tue, Nov 10 | 0 | 0 |
| Carousel Dental | Tue, Nov 10 | 0 | 2 |
| Globo Dental | Tue, Nov 10 | 8 | 3 |
| Laguna Dental | Fri, Nov 13 | 18 | 3 |
| Marina Dental | Mon, Nov 09 | 15 | 7 |
| NLD Dental | Tue, Nov 10 | 0 | 4 |
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 · notes Auto-verified twice daily (upload freshness + OD↔Kasper reconciliation). Last run Nov 07, 07:30 AM CT — 7 offices checked, 1 with issue.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Nov 07 | Current | $28,377 | $25,276 | +12% |
| Carnival Dental | Nov 06 | Current | $24,984 | $24,596 | +2% |
| Carousel Dental | Nov 07 | Current | $29,221 | $25,441 | +15% |
| Globo Dental | Nov 07 | Current | $31,153 | $29,333 | +6% |
| Laguna Dental | Nov 07 | Current | $18,674 | $12,172 | +53% |
| Marina Dental | Nov 06 | Current | $20,290 | $28,569 | -29% |
| NLD Dental | Nov 06 | Current | $18,019 | $17,445 | +3% |