Office Breakdown
| Office | Patients | 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% | — | $79,138 | 0% | 0% | 0 |
| Carnival Dental | 0 (0 new) | $0 | — | $0 | $3,107 0% | — | $65,790 | 0% | 0% | 5 |
| Carousel Dental | 0 (0 new) | $0 | — | $0 | $604 0% | $604 | $85,439 | 0% | 0% | 0 |
| Globo Dental | 0 (0 new) | $0 | — | $0 | $2,338 0% | $2,338 | — | 0% | 0% | 0 |
| Laguna Dental | 0 (0 new) | $0 | — | $0 | $3,089 0% | $3,089 | — | 0% | 0% | 0 |
| Marina Dental | 0 (0 new) | $0 | — | $0 | $1,580 0% | $1,580 | $50,756 | 0% | 0% | 0 |
| NLD Dental | 0 (0 new) | $0 | — | $0 | $5,284 0% | $5,284 | $62,567 | 0% | 0% | 0 |
| TOTAL | 0 | $0 | — | $0 | $16,001 | $12,895 | $343,690 | 0% | 5 |
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 | 21 | 20 | 0 | 17 | 3 | 1 | 85.0% |
| Carnival Dental | 19 | 19 | 0 | 18 | 1 | 1 | 94.7% |
| Carousel Dental | 29 | 29 | 0 | 23 | 6 | 0 | 79.3% |
| Globo Dental | 64 | 64 | 0 | 56 | 8 | 3 | 87.5% |
| Laguna Dental | 197 | 117 | 80 | 109 | 8 | 0 | 93.2% |
| Marina Dental | 40 | 40 | 0 | 33 | 7 | 0 | 82.5% |
| NLD Dental | 58 | 25 | 25 | 1 | 24 | 5 | 4.0% |
| TOTAL | 428 | 314 | 105 | 257 | 57 | 10 | 81.8% |
Orthodontics (Cloud9) as of Oct 15
| Office | Next Ortho Day | Exams That Day | Starts (MTD) |
|---|---|---|---|
| Arcade Dental | Fri, Oct 16 | 39 | 1 |
| Carnival Dental | Wed, Oct 28 | 12 | 12 |
| Carousel Dental | Mon, Oct 19 | 15 | 2 |
| Globo Dental | Thu, Oct 15 | 18 | 9 |
| Laguna Dental | Fri, Oct 16 | 17 | 2 |
| Marina Dental | Tue, Oct 20 | 15 | 17 |
| NLD Dental | Thu, Oct 22 | 17 | 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 15, 07:30 PM CT — 7 offices checked, 0 with issues.
| Office | OD Data Through | Status | OpenDental Prod | Kasper Prod | Variance |
|---|---|---|---|---|---|
| Arcade Dental | Oct 15 | Current | $29,617 | $29,611 | +0% |
| Carnival Dental | Oct 15 | Current | $16,217 | $16,217 | -0% |
| Carousel Dental | Oct 15 | Current | $40,376 | $39,574 | +2% |
| Globo Dental | Oct 14 (2 biz days behind) | Lagging | $25,373 | $23,728 | +7% |
| Laguna Dental | Oct 15 | Current | $28,967 | $28,166 | +3% |
| Marina Dental | Oct 15 | Current | $21,810 | $21,152 | +3% |
| NLD Dental | Oct 15 | Current | $14,895 | $14,895 | -0% |