Office Breakdown
| Office | Patients | Gross Prod | Kasper Prod | Net Prod | Collections | Kasper Coll | QBO Rev (mo) | Show Rate | Tx Accept | No Shows |
|---|---|---|---|---|---|---|---|---|---|---|
| Arcade Dental | 36 (17 new) | $10,932 | — | $10,639 | $10 0% | — | — | 100% | 79% | 0 |
| Carnival Dental | 7 (6 new) | $4,611 | — | $4,547 | $50 1% | — | — | 100% | 100% | 0 |
| Carousel Dental | 6 (8 new) | $1,582 | — | $617 | $717 45% | — | — | 100% | 7% | 0 |
| Globo Dental | 22 (10 new) | $7,568 | — | $7,568 | $388 5% | — | — | 100% | 97% | 0 |
| Laguna Dental | 20 (2 new) | $4,874 | — | $4,874 | $655 13% | — | — | 100% | 93% | 0 |
| Marina Dental | 25 (2 new) | $5,409 | — | $5,409 | $40 1% | — | — | 100% | 48% | 0 |
| NLD Dental | 1 (1 new) | $700 | — | $700 | $0 0% | — | — | 50% | 100% | 1 |
| TOTAL | 117 | $35,677 | — | $34,355 | $1,860 | — | — | 99% | 1 |
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 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.
Issues Auto-verified twice daily (upload freshness + OD↔Kasper reconciliation). Last run Jul 28, 07:30 PM CT — 7 offices checked, 1 with issue.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Jul 28 | Current | $26,702 | $26,575 | +0% |
| Carnival Dental | Jul 28 | Current | $32,864 | $29,074 | +13% |
| Carousel Dental | Jul 28 | Current | $39,706 | $36,996 | +7% |
| Globo Dental | Jul 28 | Current | $17,355 | $16,784 | +3% |
| Laguna Dental | Jul 28 | Current | $30,510 | $26,415 | +16% |
| Marina Dental | Jul 25 (3 biz days behind) | Lagging | $31,833 | $28,993 | +10% |
| NLD Dental | Jul 28 | Current | $16,309 | $16,309 | +0% |