Tools · Scheduling & Capacity

What a No-Show Costs: The Appointment Business Calculator

What a No-Show Costs: The Appointment Business Calculator

Your 2pm didn't show. The materials come back — the hour never does. Here's what the empty chairs cost, and the two sentences that stop it.

$24 one-off

Buy — $24

What-a-No-Show-Costs-Appointment-Business-Calculator.xlsx · 4 tabs, live formulas, no macros

Instant download, nothing ships. Works in Excel, no subscription. If it does not do what you needed, tell me and I will make it right.

In the worked example — 55 appointments a week, an 8% no-show rate — the empty slots cost $14,960 a year in profit. About $299 a week, gone without a receipt. Most owners know it vaguely and have priced it never, because the fixes feel awkward. This workbook prices the leak, prices each fix, and hands you the words.

How it works

  • The Leak — six numbers from your scheduling app → no-shows and late cancels per year, and the profit they take with them (an empty slot costs its contribution, which for time-sellers is most of the ticket — your hour was going to be there anyway)
  • The Fix Stack — reminders, deposits, card-on-file, waitlist backfill: each priced alone, then your chosen combination multiplied honestly (two 40% fixes don't make 80%) with net recovery and ROI — 19.4× in the sample
  • The Policy Kit — the exact scripts: the card-on-file ask said flatly, the deposit phrased as a down payment, the first-offence waiver that buys your policy its reputation for fairness, the one-line waitlist text, and the posted policy with the clause that makes customers accept it: because the time was held for you

Built for

Salons, barbers, lash and nail studios · pet groomers · auto detailers · photographers · tutors and instructors · massage and wellness studios · anyone whose product is a time slot.

What you get

One .xlsx file, four tabs, instant download. Excel, Google Sheets, Apple Numbers, LibreOffice. No macros, no subscription. All reduction rates editable — replace the defaults with your own results after sixty days.

A look inside

More in Scheduling & Capacity

Can I Take This Job? Capacity Planner

"Yeah, we can get to that in a couple of weeks."

$32

The Owner's Hour: Time Audit & Delegation Calculator

You are doing $16-an-hour errands while owning a $32-an-hour job — and the $81 selling hours go undone.

$24

The Job Pipeline Tracker (Airtable Template)

Your pipeline number is a lie. This base tells you the honest one.

$24