How to calculate your no-show rate

The formula

The standard way to calculate a no-show rate is:

No-show rate = (no-shows / appointments scheduled for that period) x 100

The denominator should be the appointments that were still on the schedule at the start of each day, not every appointment ever booked. If a patient cancelled two weeks ahead, that appointment never had a chance to become a no-show, and counting it makes your rate look better than it is.

Some practices prefer to calculate a separate missed appointment rate that combines no-shows and late cancellations. That is useful too, as long as you report it alongside the pure no-show rate rather than instead of it.

Decide what counts before you count

The most common reason no-show numbers can't be trusted is that different people record the same event different ways. Before you run the numbers, agree on these definitions and put them in your front-desk procedures:

• No-show: the patient did not arrive and gave no notice before the appointment time.
• Late cancellation: the patient gave notice, but inside your cutoff window, for example less than 24 hours ahead. Pick a window and stick with it.
• Early cancellation: notice outside the window. Not a no-show, and usually not part of your missed-appointment rate either.
• Late arrival turned away: decide whether this is a no-show. Many practices count it as one, because the slot was lost either way.
• Walkout: a patient who checked in, waited and left before being seen. Track it separately; it is a different problem with a different fix.
• Practice-initiated changes: a provider out sick, a rescheduled block. Exclude these entirely.

A worked example

Here is an illustrative month for a two-provider practice. Every number is made up for the example.

1. Total appointments booked for the month at any point: 1,180.
2. Cancelled more than 24 hours ahead: 96. Moved by the practice because a provider was out: 24. Remove both. Appointments still on the books at the start of each day: 1,060.
3. Patients who never arrived and never called: 74. Patients turned away after arriving more than 15 minutes late (counted as no-shows by this practice's policy): 6. Total no-shows: 80.
4. No-show rate: 80 / 1,060 = 0.0755, or 7.5%.
5. Late cancellations inside 24 hours: 41. Missed appointment rate: (80 + 41) / 1,060 = 11.4%.

Getting the numbers out of your system

Most EHR and practice management systems can export the schedule with an appointment status for each visit: completed, cancelled, no-show, rescheduled and so on. Pull one full month into a spreadsheet and check a few things before you trust it:

First, look at how statuses are actually used. If staff sometimes mark a no-show as "cancelled" to clear the slot, your no-show count is understated. Second, check whether cancellations carry a date and time. Without them you can't separate early cancellations from late ones. Third, look for appointments that were simply deleted. Some systems don't keep a record of those at all.

If the data is messy, don't give up on measurement. Fix the recording habit going forward and use the next clean month as your baseline.

A simple spreadsheet setup works well. Keep one row per appointment with columns for date, time, provider, visit type, status, and the date and time any cancellation was recorded. Add one calculated column that labels each row as completed, no-show, late cancellation, early cancellation or practice change using your written definitions. Once that column exists, every rate in this article is a count and a division, and anyone on the team can reproduce it.

Slice it so it tells you something

A single practice-wide rate is a scoreboard. The useful insight comes from breaking it down. Once the monthly number is reliable, calculate the same rate by:

• Provider. Different schedules and patient panels behave differently.
• Visit type. New patients, follow-ups and procedures often have very different rates.
• Day of week and time of day. Patterns here are common and fixable.
• Lead time. Appointments booked far ahead often behave differently from ones booked this week.
• Reminder status. Compare confirmed visits with unconfirmed ones.

Turn the rate into dollars

A percentage is easy to shrug at. Convert it. In the example above, 80 no-shows at an illustrative $150 average visit is $12,000 for the month. The 41 late cancellations are another $6,150 at risk, though some of those slots can be refilled.

Track both the rate and the dollar figure every month. The rate shows whether behavior is changing; the dollars show whether it matters. Then add a third number: how many of those lost slots were refilled. That is the one that measures what your team, or your tools, actually recovered.