⚠
Data health: 3 issues right now
— live, updates on every page load
- Carousel Dental: OpenDental vs Kasper production off -41% (Aug 14-Aug 21)
- Globo Dental: OpenDental vs Kasper production off -71% (Aug 14-Aug 21)
- Marina Dental: OpenDental vs Kasper production off +29% (Aug 14-Aug 21)
See Data Health ↓
New Patients
353
across all locations
Patient Visits
1174
total visits (not unique patients)
Gross Production
$472,369
before adjustments
Net Production
$427,365
after adj & writeoffs
Collections
$440,918
93.3% of production
Show Rate
56%
1171/2104 showed
Answer Rate
82%
14408 total calls
Office Breakdown
| Office |
Visits |
Gross Prod |
Kasper Prod |
Net Prod |
Collections |
Kasper Coll |
QBO Rev (mo) |
Show Rate |
Tx Accept |
No Shows |
| Arcade Dental |
198 (51 new) |
$77,953 |
$74,904 |
$74,378 |
$77,763 100% |
$44,657 |
$78,862 |
57% |
67% |
148 |
| Carnival Dental |
180 (64 new) |
$79,815 |
$72,207 |
$72,019 |
$52,742 66% |
$6,293 |
$46,295 |
53% |
49% |
147 |
| Carousel Dental |
178 (56 new) |
$72,371 |
$80,323 |
$64,603 |
$64,339 89% |
$53,601 |
$88,220 |
60% |
47% |
111 |
| Globo Dental |
162 (50 new) |
$47,062 |
$62,780 |
$45,381 |
$48,486 103% |
$34,372 |
— |
57% |
52% |
121 |
| Laguna Dental |
144 (29 new) |
$46,997 |
$46,642 |
$34,447 |
$52,359 111% |
$31,617 |
— |
62% |
30% |
88 |
| Marina Dental |
149 (26 new) |
$59,665 |
$48,498 |
$48,440 |
$61,547 103% |
$41,952 |
$44,076 |
46% |
40% |
179 |
| NLD Dental |
163 (77 new) |
$88,506 |
$83,486 |
$88,097 |
$83,681 94% |
$47,107 |
$62,715 |
57% |
63% |
139 |
| TOTAL |
1174 |
$472,369 |
$468,840 |
$427,365 |
$440,918 |
$259,599 |
$320,168 |
56% |
|
933 |
Patient Mix age & insurance
Breakdown of patient visits 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.
| Office |
18+ (Adults) |
Under 18 (Kids) |
New Pts 18+ |
New Pts <18 |
Cash |
PPO |
Medicaid |
| Arcade Dental |
20 10% |
178 90% |
9 |
42 |
15 8% |
8 4% |
175 88% |
| Carnival Dental |
28 16% |
152 84% |
15 |
49 |
22 12% |
34 19% |
124 69% |
| Carousel Dental |
33 19% |
145 81% |
18 |
38 |
21 12% |
17 10% |
140 79% |
| Globo Dental |
27 17% |
135 83% |
15 |
35 |
83 51% |
7 4% |
72 44% |
| Laguna Dental |
27 19% |
117 81% |
12 |
17 |
51 35% |
3 2% |
90 62% |
| Marina Dental |
18 12% |
131 88% |
10 |
16 |
24 16% |
4 3% |
121 81% |
| NLD Dental |
20 12% |
143 88% |
19 |
58 |
8 5% |
8 5% |
147 90% |
| TOTAL |
173 15% |
1001 85% |
98 |
255 |
224 19% |
81 7% |
869 74% |
Age Mix by Office
Insurance Mix by Office
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.
| Office |
Cash |
PPO |
Medicaid |
Total Net |
| Arcade Dental |
$2,579 3% |
$3,768 5% |
$68,031 91% |
$74,378 |
| Carnival Dental |
$6,364 9% |
$13,023 18% |
$52,632 73% |
$72,019 |
| Carousel Dental |
$3,583 6% |
$4,914 8% |
$56,106 87% |
$64,603 |
| Globo Dental |
$26,034 57% |
$1,499 3% |
$17,848 39% |
$45,381 |
| Laguna Dental |
$10,626 31% |
$514 1% |
$23,307 68% |
$34,447 |
| Marina Dental |
$8,656 18% |
$1,089 2% |
$38,695 80% |
$48,440 |
| NLD Dental |
$2,835 3% |
$7,816 9% |
$77,447 88% |
$88,097 |
| TOTAL |
$60,677 14% |
$32,623 8% |
$334,066 78% |
$427,365 |
Net Production by Insurance
Payer Share of Net Production
Phone Metrics (Kasper)
| Office |
Total Calls |
Incoming |
Outgoing |
Answered |
Missed |
Abandoned |
Answer Rate |
| Arcade Dental |
1710 |
412 |
1264 |
336 |
76 |
6 |
81.6% |
| Carnival Dental |
1971 |
601 |
1329 |
526 |
75 |
3 |
87.5% |
| Carousel Dental |
2252 |
591 |
1623 |
446 |
145 |
53 |
75.5% |
| Globo Dental |
2509 |
812 |
1634 |
602 |
210 |
48 |
74.1% |
| Laguna Dental |
2355 |
804 |
1534 |
707 |
97 |
13 |
87.9% |
| Marina Dental |
2028 |
918 |
1037 |
738 |
180 |
19 |
80.4% |
| NLD Dental |
1583 |
384 |
1184 |
333 |
51 |
15 |
86.7% |
| TOTAL |
14408 |
4522 |
9605 |
3688 |
834 |
157 |
81.6% |
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 24, 07:30 AM CT — 7 offices checked,
4 with issues.
| Office |
OD Data Through |
Status |
OpenDental Prod |
Kasper Prod |
Variance |
| Arcade Dental |
Aug 22 |
Current
|
$23,902 |
$23,107 |
+3%
|
| Carnival Dental |
Aug 22 |
Current
|
$18,138 |
$15,847 |
+14%
|
| Carousel Dental |
Aug 19 (3 biz days behind) |
Lagging
|
$6,562 |
$21,422 |
-69%
|
| Globo Dental |
Aug 19 (3 biz days behind) |
Lagging
|
$2,569 |
$19,797 |
-87%
|
| Laguna Dental |
Aug 19 (3 biz days behind) |
Lagging
|
$8,096 |
$17,423 |
-54%
|
| Marina Dental |
Aug 22 |
Current
|
$17,254 |
$14,848 |
+16%
|
| NLD Dental |
Aug 24 |
Current
|
$35,189 |
$30,538 |
+15%
|
New Patients by Office
Production by Office
Show Rate by Office
Answering Rate by Office
Data Sources
QuickBooks
Not configured