No-Show Cost Calculator for Med Spas: Revenue & Contribution

Updated September 19, 2026. Illustrative planning model by Prospyr; not a forecast or accounting advice.

How do you calculate a no-show rate?

Divide no-shows by appointments scheduled in the same defined cohort, then multiply by 100. If 20 of 200 scheduled appointments were no-shows, the rate is 10%. Define no-shows, cancellations and reschedules before comparing periods; changing the denominator changes the result.

Use one reporting period and consistent appointment statuses. Keep patient visits separate from blocked calendar time. Exclude test appointments, and decide how multi-service bookings are counted so you do not inflate the denominator.

What does a missed appointment actually cost?

Unfilled slots have scheduled revenue value, but that is not automatically lost profit. A simple contribution estimate subtracts costs you actually avoid when the service is not delivered. Fixed rent and staff costs that are paid either way should not be subtracted as if they disappeared.

The calculator below distinguishes missed appointments, backfilled slots, unfilled scheduled value and contribution at risk. It makes no claim that every missed appointment could have been filled or that an intervention will achieve the scenario you enter.

Use the no-show calculator.

Worked example: 200 appointments

With 200 scheduled appointments and a 10% no-show rate, there are 20 missed appointments. If five slots are backfilled, 15 remain unfilled. At $150 of average net service revenue and $35 of avoidable cost per service:

• Unfilled scheduled value: 15 × $150 = $2,250.
• Contribution at risk: 15 × ($150 − $35) = $1,725.

These are invented assumptions. Use collected or expected net service revenue consistently, excluding tax and gratuity. Prepaid packages and memberships may need a different accounting treatment. Do not count a retained deposit twice as new revenue; ask your accountant how deposits and later rescheduling should be treated.

A reminder and deposit workflow to test

1. Make the appointment and cancellation policy clear before booking.
2. Confirm contact information and appropriate communication preferences.
3. Send approved reminders with a practical reschedule path.
4. Assign staff to unanswered messages and high-priority scheduling changes.
5. Use a practice-approved waitlist process when a slot opens.
6. Review whether deposits are appropriate, transparent and configured consistently with your policy.

Automated reminders, 2-way SMS, workflow automation and deposits support different parts of this process. A reminder delivery receipt is not proof the patient attended.

Measure an intervention without overstating it

Track scheduled appointments, no-shows, timely/late cancellations, slots backfilled and completed visits separately. Compare similar services, providers, lead times and days of the week. Seasonal changes or a different patient mix can move the rate without proving your new reminder caused it.

Start with a small, defined workflow pilot. Review staff workload, complaints and opt-outs alongside attendance. The no-show planning worksheet records assumptions and the review owner. Discuss your scheduling workflow with Prospyr.