⚠
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
493
across all locations
Patient Visits
1951
total visits (not unique patients)
Gross Production
$755,718
before adjustments
Net Production
$679,627
after adj & writeoffs
Collections
$589,444
78.0% of production
Show Rate
65%
1958/3018 showed
Answer Rate
82%
19232 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 |
278 (62 new) |
$122,809 |
$117,942 |
$116,944 |
$90,117 73% |
$50,448 |
$79,138 |
62% |
66% |
169 |
| Carnival Dental |
244 (79 new) |
$91,985 |
$86,084 |
$86,018 |
$96,572 105% |
$39,488 |
$65,790 |
54% |
59% |
200 |
| Carousel Dental |
282 (71 new) |
$139,473 |
$125,160 |
$123,207 |
$88,400 63% |
$51,920 |
$85,439 |
53% |
52% |
230 |
| Globo Dental |
279 (80 new) |
$78,547 |
$75,953 |
$73,474 |
$68,628 87% |
$48,752 |
— |
71% |
39% |
118 |
| Laguna Dental |
350 (38 new) |
$106,263 |
$87,758 |
$86,175 |
$83,944 79% |
$47,067 |
— |
98% |
48% |
6 |
| Marina Dental |
273 (57 new) |
$112,003 |
$92,358 |
$90,964 |
$85,416 76% |
$47,934 |
$50,756 |
63% |
34% |
165 |
| NLD Dental |
245 (106 new) |
$104,638 |
$103,447 |
$102,845 |
$76,367 73% |
$45,407 |
$62,567 |
59% |
65% |
172 |
| TOTAL |
1951 |
$755,718 |
$688,702 |
$679,627 |
$589,444 |
$331,016 |
$343,690 |
65% |
|
1060 |
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 |
21 8% |
257 92% |
9 |
53 |
17 6% |
20 7% |
241 87% |
| Carnival Dental |
21 9% |
223 91% |
12 |
67 |
17 7% |
37 15% |
190 78% |
| Carousel Dental |
52 18% |
230 82% |
18 |
53 |
44 16% |
24 9% |
214 76% |
| Globo Dental |
51 18% |
228 82% |
27 |
53 |
140 50% |
10 4% |
129 46% |
| Laguna Dental |
49 14% |
301 86% |
12 |
26 |
92 26% |
21 6% |
237 68% |
| Marina Dental |
46 17% |
227 83% |
21 |
36 |
48 18% |
11 4% |
214 78% |
| NLD Dental |
30 12% |
215 88% |
19 |
87 |
17 7% |
16 7% |
212 87% |
| TOTAL |
270 14% |
1681 86% |
118 |
375 |
375 19% |
139 7% |
1437 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 |
$4,434 4% |
$5,287 5% |
$107,224 92% |
$116,944 |
| Carnival Dental |
$7,995 9% |
$11,719 14% |
$66,304 77% |
$86,018 |
| Carousel Dental |
$8,753 7% |
$10,441 8% |
$104,012 84% |
$123,207 |
| Globo Dental |
$35,397 48% |
$2,500 3% |
$35,577 48% |
$73,474 |
| Laguna Dental |
$20,081 23% |
$4,351 5% |
$61,743 72% |
$86,175 |
| Marina Dental |
$16,628 18% |
$5,510 6% |
$68,826 76% |
$90,964 |
| NLD Dental |
$4,615 4% |
$5,821 6% |
$92,409 90% |
$102,845 |
| TOTAL |
$97,903 14% |
$45,629 7% |
$536,095 79% |
$679,627 |
Net Production by Insurance
Payer Share of Net Production
Phone Metrics (Kasper)
| Office |
Total Calls |
Incoming |
Outgoing |
Answered |
Missed |
Abandoned |
Answer Rate |
| Arcade Dental |
2253 |
664 |
1534 |
517 |
147 |
4 |
77.9% |
| Carnival Dental |
2819 |
817 |
1923 |
631 |
186 |
25 |
77.2% |
| Carousel Dental |
3472 |
867 |
2605 |
688 |
179 |
18 |
79.4% |
| Globo Dental |
3148 |
1192 |
1952 |
1025 |
167 |
36 |
86.0% |
| Laguna Dental |
3405 |
1134 |
2225 |
968 |
166 |
20 |
85.4% |
| Marina Dental |
2205 |
1155 |
1049 |
998 |
157 |
5 |
86.4% |
| NLD Dental |
1930 |
590 |
1342 |
465 |
137 |
33 |
78.8% |
| TOTAL |
19232 |
6419 |
12630 |
5292 |
1139 |
141 |
82.4% |
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