Office Breakdown
New Pts for a dental office counts distinct patients whose first completed visit in this range is a new-patient exam (D0150, D0145, or D0180). Days add up without counting the same patient twice. Embrace Ortho's New Pts are Cloud9 dismissed new-patient exams and are not added to either total. Total excluding Embrace is the seven dental offices. Total including Embrace adds Cloud9 gross, net, collections, and QuickBooks revenue when that figure is present. A missing Cloud9 amount is not treated as zero.
| Office | Patients | New Pts | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Carnival Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Carousel Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Globo Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Laguna Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Marina Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| NLD Dental | 0 (0 new) | 0 | $0 | — | $0 | $0 0% | — | — | 0% | 0% | 0 |
| Embrace Ortho¹ | — | — | — | — | — | — | — | — | — | — | — |
| Total excluding Embrace | 0 | 0 | $0 | — | $0 | $0 | — | — | 0% | 0 | |
| Total including Embrace | 0² | 0³ | $0⁴ | —⁵ | $0⁶ | $0⁷ | —⁵ | — | 0%⁸ | 0⁹ |
- ¹ Jul 7 not in Cloud9 daily yet
- ² Cloud9 has no visit count
- ³ 0 dental · Cloud9 exams unavailable
- ⁴ Embrace production unavailable
- ⁵ Embrace is not in Kasper
- ⁶ Embrace net production unavailable
- ⁷ Embrace collections unavailable
- ⁸ dental offices only; Cloud9 has no show rate
- ⁹ Cloud9 failed appointments are not included
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 10
| 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 | 9 | 3 |
| Laguna Dental | Fri, Nov 13 | 21 | 3 |
| Marina Dental | Mon, Nov 16 | 8 | 8 |
| NLD Dental | Tue, Nov 10 | 0 | 5 |
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 Nov 10, 07:30 AM CT — 7 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Nov 10 | Current | $23,054 | $22,969 | +0% |
| Carnival Dental | Nov 10 | Current | $21,180 | $20,792 | +2% |
| Carousel Dental | Nov 10 | Current | $25,904 | $24,677 | +5% |
| Globo Dental | Nov 10 | Current | $25,334 | $25,042 | +1% |
| Laguna Dental | Nov 07 (2 biz days behind) | Lagging | $18,563 | $17,756 | +4% |
| Marina Dental | Nov 10 | Current | $33,201 | $31,988 | +4% |
| NLD Dental | Nov 09 | Current | $25,891 | $25,317 | +2% |