Daily Overview

Wednesday, October 09, 2024
to
Data health: 2 issues right now — live, updates on every page load
  • Laguna Dental: OpenDental vs Kasper production off +21% (Jul 23-Jul 30)
  • NLD Dental: OpenDental vs Kasper production off -29% (Jul 23-Jul 30)
See Data Health ↓
New Patients
39
across all locations
Patients Seen
87
patients seen
Gross Production
$30,614
before adjustments
Net Production
$29,885
after adj & writeoffs
Collections
$22,868
74.7% of production
Show Rate
100%
90/90 showed
Answer Rate
0%
0 total calls

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 (10 new) $5,778 $5,748 $4,031 70% 100% 70% 0
Carnival Dental 14 (10 new) $5,389 $5,389 $6,295 117% 100% 84% 0
Carousel Dental 14 (4 new) $3,944 $3,283 $6,399 162% 100% 95% 0
Globo Dental 0 (0 new) $0 $0 $0 0% 0% 0% 0
Laguna Dental 20 (5 new) $6,919 $6,881 $3,536 51% 100% 68% 0
Marina Dental 21 (10 new) $8,584 $8,584 $2,606 30% 100% 70% 0
NLD Dental 0 (0 new) $0 $0 $0 0% 0% 0% 0
TOTAL 87 $30,614 $29,885 $22,868 100% 0

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 Aug 01, 07:30 PM CT — 7 offices checked, 5 with issues.

Office OD Data Through Status OpenDental Prod Kasper Prod Variance
Arcade Dental Jul 29 (2 biz days behind) Lagging $15,233 $29,969 -49%
Carnival Dental Jul 30 Current $8,830 $13,272 -34%
Carousel Dental Aug 01 Current $24,362 $23,045 +6%
Globo Dental Aug 01 Current $18,836 $18,634 +1%
Laguna Dental Jul 31 Current $24,087 $18,663 +29%
Marina Dental Jul 30 Current $4,228 $12,344 -66%
NLD Dental Jul 28 (3 biz days behind) Lagging $10,999 $25,713 -57%

New Patients by Office

Production by Office

Show Rate by Office

Answering Rate by Office

Data Sources

OpenDental
Loading...
Kasper
Loading...
QuickBooks
Not configured
ADP
Not configured