Office Breakdown
| Office | Patients | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 18 (8 new) | $4,479 | — | $4,407 | $58 1% | — | — | 100% | 54% | 0 |
| Carnival Dental | 1 (0 new) | $5 | — | $5 | $0 0% | — | — | 0% | 100% | 0 |
| Carousel Dental | 9 (6 new) | $8,295 | — | $8,180 | $0 0% | — | — | 100% | 98% | 0 |
| Globo Dental | 15 (3 new) | $3,751 | — | $3,751 | $238 6% | — | — | 100% | 40% | 0 |
| Laguna Dental | 25 (3 new) | $6,982 | — | $6,982 | $250 4% | — | — | 100% | 68% | 0 |
| Marina Dental | 16 (1 new) | $5,994 | — | $5,994 | $49 1% | — | — | 100% | 64% | 0 |
| NLD Dental | 10 (8 new) | $5,174 | — | $5,174 | $379 7% | — | — | 53% | 92% | 9 |
| Embrace Ortho Jul 12 not in Cloud9 daily yet | — | — | — | — | — | — | — | — | — | — |
| TOTAL | 94 | $34,679 | — | $34,493 | $974 | — | — | 91% | 9 |
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 Oct 29
| Office | Next Ortho Day | Exams That Day | Starts (MTD) |
|---|---|---|---|
| Arcade Dental | Wed, Nov 04 | 6 | 12 |
| Carnival Dental | Tue, Nov 03 | 10 | 18 |
| Carousel Dental | Fri, Oct 30 | 18 | 7 |
| Globo Dental | Thu, Oct 29 | 14 | 22 |
| Laguna Dental | Wed, Nov 04 | 13 | 11 |
| Marina Dental | Thu, Nov 05 | 21 | 28 |
| NLD Dental | Sat, Oct 31 | 11 | 34 |
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 Oct 29, 07:30 AM CT — 7 offices checked, 1 with issue.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Oct 24 (4 biz days behind) | Stale | $9,688 | $17,350 | -44% |
| Carnival Dental | Oct 29 | Current | $19,178 | $18,705 | +2% |
| Carousel Dental | Oct 29 | Current | $15,093 | $12,188 | +24% |
| Globo Dental | Oct 29 | Current | $21,953 | $21,953 | -0% |
| Laguna Dental | Oct 29 | Current | $18,077 | $16,841 | +7% |
| Marina Dental | Oct 29 | Current | $21,546 | $21,546 | -0% |
| NLD Dental | Oct 29 | Current | $27,610 | $27,610 | -0% |