Booked chair-time is only revenue if the client actually shows. No-shows, late cancellations, and unfilled gaps are the most expensive recurring leak in a med spa, because the injector and room were reserved and there's rarely time to backfill. This dashboard turns the schedule into accountability — fill rate, no-show and late-cancel rates, and the dollars those missed appointments cost — by provider, appointment type, and day of week.
What this report answers
How full is the schedule against available capacity, and how does fill rate vary by provider and by day of week? What share of appointments end in a no-show or a late cancel, and is that trending up? And — the number that gets owners' attention — how much expected revenue did no-shows and late cancels cost this period? The day-of-week and appointment-type views show exactly where the losses concentrate.
The metrics that matter
Schedule fill rate is booked over available minutes — capacity actually sold. No-show and late-cancel rates are counts over scheduled appointments, kept mutually exclusive with completed so the categories never double-count. Lost revenue sums the expected revenue on the appointments that fell through, converting an attendance problem into a dollar figure that justifies a deposit policy, a confirmation cadence, or a waitlist.
Why the data is trapped across the systems
Boulevard, Mangomint, Square Appointments, and AestheticsPro mark appointments as cancelled or no-show, but they don't natively compute fill rate against available minutes or attach an expected-revenue figure to the gaps. Available capacity, appointment status, and the revenue an appointment type would have generated live in different places, so the cost of a leaky schedule — the thing that would change behavior — stays invisible until it's modeled.
How to read it
Fill rate is the capacity headline; read it by provider and day of week to find chronic soft spots — a particular day, a particular provider — that point to a scheduling or confirmation fix. No-show and late-cancel rates are the drivers behind a low fill rate, and the lost-revenue card turns them into the business case for change. Concentrated losses (one appointment type, one day) are the actionable ones; a deposit or reminder policy can target them directly.
The sample on this page uses entirely synthetic appointment data — no real schedules or patient information.
Metrics it tracks
| Metric | What it means |
|---|---|
| Schedule Fill Rate | Booked minutes ÷ available minutes — how full the schedule is against capacity. |
| No-Show Rate | No-show appointments ÷ total scheduled appointments. |
| Late-Cancel Rate | Late cancellations ÷ total scheduled appointments. |
| Completed Appointment Count | Appointments that were completed and delivered. |
| Lost Revenue from No-Shows & Late Cancels | Expected revenue on appointments lost to no-shows and late cancellations — the unrecoverable cost. |
Used by: Practice manager and front desk
Frequently asked questions
What is a good schedule fill rate for a med spa?
Schedule fill rate is booked minutes over available minutes — how much of your capacity is actually sold. Higher is better, but the real value is spotting where fill is chronically soft: a particular provider, day of week, or appointment type that points to a fixable scheduling or confirmation gap rather than a company-wide problem.
How much do no-shows and late cancellations really cost?
This report attaches the expected revenue of each lost appointment and sums it, so no-shows and late cancels become a concrete dollar figure rather than a vague annoyance. That number is usually what justifies a deposit policy, a confirmation cadence, or a same-day waitlist.
What's the difference between a no-show and a late cancel?
A no-show is a scheduled appointment the client simply doesn't attend; a late cancel is cancelled too close to the appointment to refill the slot. Both reserve an injector and room that earn nothing, which is why the report tracks them separately but rolls both into lost revenue.
Build this report on your own data
Clone this Med spas template — describe it and we’ll generate sample data so you can try it free, or upload your own export. You get a fully modeled, branded Power BI project that opens in Power BI Desktop.
Use this as a template →