Daily Overview

Wednesday, September 04, 2024
to
Data health: 1 issue right now — live, updates on every page load
  • Laguna Dental: OpenDental vs Kasper production off +23% (Jul 24-Jul 31)
See Data Health ↓
New Patients
23
across all locations
Patients Seen
73
patients seen
Gross Production
$21,668
before adjustments
Net Production
$20,303
after adj & writeoffs
Collections
$17,092
78.9% of production
Show Rate
100%
75/75 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 19 (12 new) $5,616 $5,609 $3,672 65% 100% 21% 0
Carnival Dental 5 (1 new) $1,241 $617 $3,163 255% 100% 27% 0
Carousel Dental 13 (5 new) $3,989 $3,989 $2,083 52% 100% 34% 0
Globo Dental 0 (0 new) $0 $0 $0 0% 0% 0% 0
Laguna Dental 21 (2 new) $4,978 $4,244 $5,108 103% 100% 80% 0
Marina Dental 15 (3 new) $5,843 $5,843 $3,066 52% 100% 96% 0
NLD Dental 0 (0 new) $0 $0 $0 0% 0% 0% 0
TOTAL 73 $21,668 $20,303 $17,092 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 02, 07:30 PM CT — 7 offices checked, 1 with issue.

Office OD Data Through Status OpenDental Prod Kasper Prod Variance
Arcade Dental Aug 01 Current $33,948 $32,434 +5%
Carnival Dental Jul 30 (2 biz days behind) Lagging $13,272 $13,272 -0%
Carousel Dental Aug 01 Current $24,362 $23,045 +6%
Globo Dental Aug 01 Current $24,486 $24,284 +1%
Laguna Dental Jul 31 Current $24,087 $18,663 +29%
Marina Dental Jul 31 Current $12,732 $12,025 +6%
NLD Dental Aug 01 Current $26,660 $26,480 +1%

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