The Daily Dashboard, page by page

This is the dashboard your team lives in all day: your managers and your front desk. It's focused on your collections, your conversions, and your production. Put it in the morning huddle. If the dashboard only gets opened when someone remembers, it becomes trivia.

The four tabs at the top are the whole idea: Previous Day is your report card, Today is battle day, Next Day is preparation, and This Month is the owner view. Day Search looks up any date you want.

One number rule before anything else, Ash's morning bar: "I want my collections to be at 100%, I want my recare to be above 90%, and I want my treatment conversion to be above 45%. When I see this, I know that I'm going to have a really good month."

First task every morning: audit yesterday. Net production, appointments (hygiene and non-hygiene), collections, and the three conversion percentages.

• Patient collection % below 100 is the first fire. Most of the time the number isn't a patient who refused to pay; it's a claim that was never created or a prepayment that was never allocated. Your data is not wrong, your process is wrong. The fix is three moves, in order: complete the appointment, create the claim, allocate the payment.
• Hygiene conversion below 90 means people got a cleaning yesterday and left without their next one booked. Click the tile: it shows you exactly who.
• Treatment conversion below 40 to 45 means opportunities walked out unscheduled. Every tile drills to names.

Why this matters urgently: once a patient goes back and gets work done, the chance of collecting from them later drops by 80 to 85 percent. Fix yesterday before it hardens.

"Today is obviously battle day. This is where your attention goes." The only people your team can impact with certainty are the ones already walking through the door. On a call list you have maybe a 20% chance of reaching someone. With today's patients you have a 100% chance.

• Treatment Opportunity: patients coming in today with unscheduled treatment on an active plan. These are your conversations today.
• Hygiene Opportunity: doctor-side patients who need a cleaning booked before they leave.
• Patients with Est. Bal.: who to collect from at the desk, before they're in the chair.

The two seconds it takes to schedule someone standing at your desk beats the ten minutes it takes to reach them by phone next month.

Tomorrow's list is tonight's homework. Review who's coming in, which of them are opportunities, and clean the data ahead of time: inactivate stale option-B treatment plans that aren't real anymore, so your conversion number stays honest and your doctors walk in with a game plan per patient.

Track the month against goal: net production, average daily net production, collections, and the three conversions. Every Previous Day drill has a This Month twin, so "who left unscheduled yesterday" becomes "who left unscheduled all month" with one tab.

The day's production in detail. Net production here matches Open Dental to the penny. Not approximately: to the penny. A negative day is an audit trigger; open it and find out why.

The Net Production by control at the top switches the date basis: Ins. payment date books write-offs and adjustments on the day the insurance payment posts; Procedure date books everything on the day the work was done. Same dollars, different calendar. Pick one basis for your huddle and stay consistent.

Everyone coming in for the selected day, with their next appointments and opportunity flags. Your treatment coordinators and doctors sit with this list before the day starts: pull up each account that's flagged as a treatment opportunity, make sure the plan is current, and agree on the ask before the patient is in the chair.

The names behind the count: every patient in the building today whose active treatment plan holds an unscheduled productive code. A productive code is real treatment (a crown, a filling, an extraction, an implant), not a buildup, a bone graft, or an X-ray. Nobody comes in just for a bone graft.

After each visit

• If they scheduled: done, that's a conversion.
• If they didn't: put a Reason Not Scheduled and a Follow-up Date on the patient, every single time. If they say no, ask "when should I follow up with you?" and write that date down.

Doctor-side patients with no future hygiene visit. Two kinds: reactivation (they've had a cleaning before, nothing scheduled) and potentials (never seen in hygiene at your practice). The teaching moment from a real training call: "You saw 26 patients yesterday and five of them left without a hygiene appointment. Four of them left with no future appointment at all."

The goal is not working this list harder. The goal is shutting off the tap: nobody leaves the office without their next appointment. Working lists is emptying the sink; scheduling before they leave is shutting off the tap. Tap first, always.

Who owes, what got collected, and the allocation errors behind a patient collection number that looks wrong: unallocated prepayments, missing claims, income transfer issues, per patient. The Patients with Payplan checkbox includes patients on an Open Dental payment plan; if someone claims a balance is "on a payment plan" and they don't show up when you tick it, that's a diagnosis, not a data gap.

A large uncollected list is a stop-everything event. Ash on seeing one: "I'm just looking at probably like 30 grand right here. I would tell you this is a red alarm. Like everything stops."

Who on your team is putting appointments on the books: each scheduler, how many appointments they created, and how much production those appointments added. For the first time you can see who fills your schedule and who doesn't.