Most practices review numbers monthly, which means a problem that started in the first week of March gets noticed in the second week of April. By then the hygiene schedule has holes five weeks out, the aging report has a new bucket, and whatever caused it has run unopposed for six weeks.
A weekly dashboard fixes that, but only if it is short enough that someone actually produces it. The failure mode is not too few numbers; it is thirty numbers, a spreadsheet nobody maintains, and a meeting that quietly stops happening. This post gives a one-page layout, names the report each number comes from, explains how to read a trend without chasing noise, and assigns an owner to every line. Our KPI post covers which metrics are worth tracking at all; this is about turning the useful ones into a routine.
Key takeaways
- Sixteen numbers is enough. A dashboard you produce every Monday beats a comprehensive one you produce twice.
- Pair every lagging number (collections) with the leading number that predicts it (scheduled production, treatment accepted, claims submitted).
- Read trends against a rolling 13-week average, not against last week. Single-week swings in a dental practice are mostly noise.
- Every line needs a named owner and a threshold that triggers a conversation, otherwise the dashboard is a report rather than a management tool.
- Pull every number from the same report every week. Changing the definition mid-year destroys the trend.
- The meeting matters more than the spreadsheet. Fifteen minutes, same time every week, same agenda.
What a weekly dashboard is for
A dashboard has one job: surfacing a change early enough to act on it. That sets three design rules.
- Only include numbers you would act on. If a metric moves 20% and your response is "huh," it belongs on the monthly review.
- Include leading indicators, not only results. Collections reflect work done four to eight weeks ago. Scheduled production for the next two weeks tells you what collections look like in two months.
- Keep the definitions frozen. "Production" can mean gross, net of adjustments, or net of write-offs. Pick one, write it down, and never change it without noting the date on the sheet.
The one-page weekly dashboard
Sixteen numbers in six blocks. Below is the layout, then a section on each block explaining where the number comes from and how to read it. All values in the table are hypothetical and shown only to illustrate the format.
| Block | Metric | This week | 13-week average | Trigger | Owner |
|---|---|---|---|---|---|
| Money | Net production | $38,400 | $36,900 | Below 90% of average two weeks running | Owner |
| Collections | $35,100 | $35,400 | Below 95% of production over a rolling month | Business manager | |
| Collection ratio (collections / net production, rolling 4 weeks) | 96% | 97% | Under 95% | Business manager | |
| Schedule | Doctor hours scheduled next 2 weeks (% of available) | 88% | 91% | Under 85% | Scheduling coordinator |
| Hygiene hours scheduled next 2 weeks (% of available) | 82% | 89% | Under 85% | Hygiene lead | |
| Broken appointments and same-day cancellations | 9 | 6 | More than 8 in a week | Scheduling coordinator | |
| New patients | New patients seen | 7 | 8 | Two consecutive weeks below average | Owner |
| New patient calls | 11 | 12 | Tracked with answer rate | Front desk lead | |
| Phone answer rate | 84% | 88% | Under 85% | Front desk lead | |
| Treatment | Treatment diagnosed (dollars) | $52,000 | $49,000 | Below 80% of average | Owner |
| Treatment scheduled or started (dollars, same week) | $31,000 | $32,500 | Acceptance under 60% | Treatment coordinator | |
| Receivables | Total A/R | $78,000 | $74,000 | Over 1.2x average monthly collections | Business manager |
| A/R over 90 days (% of total) | 14% | 12% | Over 15% | Business manager | |
| Claims outstanding over 30 days (count and dollars) | 23 / $19,400 | 19 / $16,800 | More than 25 claims | Insurance coordinator | |
| Hygiene and recall | Hygiene reappointment rate | 88% | 91% | Under 90% | Hygiene lead |
| Patients past due for recall | 412 | 398 | Rising three weeks running | Recall coordinator |
Print it on one page and keep the last eight weeks visible. A single week's column tells you almost nothing. Eight columns side by side tells you the story instantly, without any charts. If you want one chart, make it collections against a 13-week moving average.
Block 1: Money
Net production and collections
Where they come from: the production report for the date range, net of adjustments and contractual write-offs, and the period income report or your deposit records. In Open Dental these are the production and income reports; see the reports and queries module. Reconcile collections to the bank, not to the software, at least monthly.
Definition discipline: decide once whether you report gross production or production net of insurance write-offs. Net is more useful because it reflects what you can actually collect and keeps the collection ratio meaningful. Write the definition at the top of the sheet.
How to read them: weekly production is lumpy, and a week with two big cases seated means nothing by itself. Compare to the 13-week average and, if you have a seasonal pattern, to the same week last year. Collections trail production, so comparing this week's collections to this week's production is meaningless; use a rolling window on both sides.
Collection ratio
What it is: collections divided by net production over the same rolling window. This is the single best indicator of whether the revenue cycle is working.
How to read it: a persistent ratio meaningfully under 100% over a long window means money is leaking somewhere: unworked claims, uncollected patient balances, adjustments being made that should not be, or fee schedules loaded incorrectly. Our revenue cycle chapter walks the stages where it leaks, and the write-off calculator helps separate contractual write-offs from actual leakage.
A rising collection ratio is not automatically good. If production drops and collections catch up on old A/R, the ratio goes above 100% while the practice is shrinking. Always read the ratio next to the production line, never alone.
Block 2: Schedule
Hours scheduled in the next two weeks
Where it comes from: a schedule utilization or open time report, or counting open hours in the appointment book by column, as a percentage of available hours.
Why two weeks: far enough out to fix, close enough to be real. A four-week view looks alarmingly empty and causes panic about nothing; a one-week view is too late.
How to read it: your most valuable leading indicator. Scheduled hours today become production in two weeks and collections in six to ten. A hygiene column drifting from 92% to 82% over three weeks is the earliest warning that recall is slipping, long before collections move.
Broken appointments and same-day cancellations
Where it comes from: your software's broken appointment tracking, if your team is disciplined about marking them correctly. This number is only as good as the data entry.
How to read it: look at the count, the dollars, and the pattern. Broken appointments cluster: a specific day of week, a specific appointment type, a specific booking lead time. Our no-show post covers what to do with the pattern once you see it.
Track how many broken slots got refilled. A practice with 9 breaks that refilled 6 is in much better shape than one with 6 breaks that refilled none. The refill rate measures your short-notice list, which is a system you can build.
Block 3: New patients and the phone
New patients seen
Where it comes from: a new patient report filtered to patients with a first completed visit in the period. Decide whether transfers and family members of existing patients count, and be consistent.
How to read it: compare to your target, which should come from your capacity math and your attrition rate, not from a benchmark. A practice that loses 15% of its active base a year needs enough new patients to replace that before it grows at all. Our capacity post covers the active patient base side.
New patient calls and answer rate
Where it comes from: your phone system's reporting. If you cannot produce these, that is a reason to upgrade; see our phone systems post.
How to read it: together these two diagnose whether a new patient problem is marketing or front desk. Calls down with a steady answer rate means marketing. Calls steady with answer rate or conversion down means the front desk or the schedule. Those problems have different solutions and cost very different amounts to fix. If you advertise, add cost per new patient as a monthly number; see the marketing budget post.
Block 4: Treatment diagnosed and accepted
Treatment diagnosed, and treatment scheduled or started
Where they come from: the treatment planned procedures report (the dollar value of what the doctor and hygienist recommended), and the dollar value of planned procedures that moved to scheduled or completed in the period.
How to read them: a drop in diagnosed dollars usually means one of three things: fewer patients seen, less comprehensive examination, or a doctor who has stopped presenting certain treatment because acceptance has been poor. All three deserve a conversation, and none show up in collections for months. The ratio of scheduled to diagnosed is your case acceptance rate; track it as a rolling four-week number, because week to week it swings wildly on one large case.
A caution on case acceptance rate. It is easy to improve by diagnosing less. If acceptance goes up while diagnosed dollars go down, nothing good is happening. Read the two lines together, always. Our case presentation chapter covers the conversation side, and accurate treatment estimates covers the most common reason patients stall.
Block 5: Receivables and claims
Total A/R and the over-90 percentage
Where it comes from: the aged receivables report, split into current, 31 to 60, 61 to 90, and over 90 days. Run it the same day each week.
How to read it: total A/R in isolation is meaningless, because a growing practice has growing receivables. Express it relative to average monthly collections; a rough guide is that it should not exceed about one to one and a half times that figure, with payer mix affecting where in the range is normal. The over-90 percentage is the number that matters, because money past 90 days is disproportionately money you will never collect. A rising over-90 share with flat total A/R means new money is coming in while old money is stuck, which points at unworked denials, patients with no follow-up, or claims held for a missing attachment.
Claims outstanding over 30 days
Where it comes from: your insurance aging or outstanding claims report.
How to read it: track both count and dollars. A rising count with flat dollars means small claims are getting stuck, often a coding or attachment issue. A rising dollar figure with a flat count means one or two large claims are hung up, which is a phone call, not a process problem. Our denials post and the denials and appeals lesson cover working the list.
Set the trigger on the over-90 percentage, not on total A/R. Practices that manage to total A/R end up writing off old balances to make the number look better, which is exactly the wrong behavior. Managing to the over-90 percentage forces you to work the old accounts instead.
Block 6: Hygiene and recall
Hygiene reappointment rate
What it is: the percentage of hygiene patients who leave with their next recall appointment scheduled. Most systems report it directly; otherwise tally it for a week to set a baseline.
How to read it: the highest-leverage single number in a general practice, because every point compounds into the schedule six months out. A drop usually traces to a specific cause: a new front desk person who is not asking, a schedule too full to offer a time, or a hygienist who stopped walking patients to the desk.
Patients past due for recall
Where it comes from: the recall or continuing care report, filtered to patients whose due date has passed.
How to read it: a number that grows three weeks running means the recall system is losing ground faster than it is gaining. That is a leading indicator of a hygiene production problem roughly one to three months out. Our recall system post and the recall lesson cover the mechanics of working it down.
If hygiene is a persistent concern, add hygiene production per hour as a monthly number and run the analysis in the hygiene profitability post.
How to read a trend without chasing noise
Dental practice numbers are noisy at a weekly grain. Four rules keep you from reacting to randomness.
- Compare to the 13-week rolling average, not to last week. Thirteen weeks is long enough to smooth vacation weeks and holidays and short enough to catch a real change.
- Require three points before you call it a trend. One week is an event. Two is a coincidence. Three in the same direction is a trend worth acting on.
- Look at the pair, not the number. Production and collections. Diagnosed and accepted. Calls and answer rate. Total A/R and over-90. Every single metric on this dashboard has a partner that makes it interpretable.
- Account for the calendar. Weeks with holidays, doctor vacation, or a staff absence are not comparable. Note them on the sheet so that six months later you know why week 27 looks odd.
Seasonality is real and varies by market. Many general practices see slower summers and a December surge as patients use remaining insurance benefits. Some markets are the opposite. Do not diagnose a management problem from a pattern that repeats every year. After two years of dashboard data you will know your own pattern, which is more useful than any published benchmark.
The meeting, which is the actual product
The dashboard is an input. The weekly meeting is where it does its work.
Weekly numbers meeting, fifteen minutes
- Same day and time every week, ideally Monday morning before patients or Friday at the end of the day
- Dashboard produced and distributed before the meeting, not during it
- Attendees: owner, business manager, and the leads who own lines on the sheet
- Go block by block. Each owner says the number and whether it is inside or outside the trigger.
- Discuss only the lines outside the trigger; everything inside gets a nod
- For each line outside, name one action, one owner, and one date
- Close by reading last week's actions and whether they happened
- No clinical discussion, scheduling arguments, or personnel issues. Those get their own time.
This is a different meeting from the morning huddle, which is about today's schedule. The weekly numbers meeting is about the direction of the practice. Keep them separate or the numbers meeting will be swallowed by today's problems every single week.
Building it: three ways
| Approach | How it works | Best for | Watch out for |
|---|---|---|---|
| Manual spreadsheet | One person runs six or seven reports Monday morning and types the numbers into a shared sheet | Almost everyone, to start | Takes 20 to 30 minutes weekly. It will stop happening unless it is someone's explicit job. |
| Software-native dashboards | Use the reporting or dashboard module built into your practice management system | Practices whose software produces the metrics they want | Definitions may not match yours, and you may not be able to change them |
| Third-party analytics platform | A product that connects to your practice management database and produces dashboards automatically | Multi-location groups, or owners who will not sustain the manual version | Monthly cost, a business associate agreement requirement, and definitions you need to verify against your own reports before trusting |
Start manual for at least a quarter even if you plan to automate. Building it by hand teaches you what each report actually contains and where your software's definitions differ from your assumptions. Practices that start automated often spend a year quoting a number they cannot reproduce. Which reports exist and how easily they customize is a real difference between systems, worth raising during demos; see our software comparison post.
What belongs on the monthly review instead
Keep the weekly page short by pushing these to a monthly meeting with your P&L:
- Overhead by category as a percentage of collections, against your trailing twelve months and the published benchmarks
- Production and collections by provider; hygiene production per hour and department profitability
- Supply and lab costs as a percentage of collections; see controlling supply costs
- Cost per new patient by marketing channel
- Active patient count and attrition; payer mix and average reimbursement by plan
- Write-offs by type, separating contractual adjustments from courtesy and other adjustments
Our financial management chapter covers the monthly financial rhythm those numbers belong to.
Common ways dashboards fail
- Too many numbers. Thirty metrics means nobody knows which three matter.
- No owner per line. A number without a name next to it is a number nobody fixes.
- No trigger. Without a threshold, every week's discussion is a judgment call and most weeks it gets skipped.
- Changing definitions. Switching from gross to net production mid-year destroys the trend and every comparison built on it.
- Only lagging indicators. Production, collections, and A/R describe the past. Add the schedule and recall numbers.
- Using it punitively. Once the dashboard becomes a tool for blaming the front desk, data quality degrades because people record things differently. It is a shared instrument panel.
- No connection to action. If the same line is outside its trigger for six weeks and nothing changes, the meeting is theater.
Where to go from here
Build the sheet this week with whatever numbers you can pull today, even if two of the sixteen are missing. Run it for four weeks before you change anything about it. The first month's value is learning which reports produce which numbers in your specific system.
Related on ChairsideSource: the KPIs worth tracking for why these metrics and not others, the free dental business calculators including the PPO write-off calculator and the associate pay calculator, financial management for practice owners for the monthly layer, and systems and workflows for building the routines the dashboard measures.
Educational content only. It is not legal, financial, tax, or clinical advice. Prices and ranges are approximate and vary by region, condition, and year. Verify current rules with your state dental board and qualified professionals. ChairsideSource is not affiliated with any manufacturer, the ADA, or the DAT.