Skip to content
Skip to content

Practical clinic administration guide · By Yes AI

How to calculate your clinic's no-show rate

Published 6 min read

A no-show rate is simple to state and easy to get wrong. The result depends on what you count as a no-show, which appointments go in the denominator and how your practice software stores cancelled and deleted bookings. This guide sets out one consistent method and the checks that keep it accurate.

Quick answer

Divide the appointments marked as did not attend (DNA) in a period by the appointments still booked at their start time, which is attended plus DNA, and multiply by 100. Hypothetical example: 60 DNAs out of 1,500 appointments still booked at start time is a 4.0% no-show rate. Track late cancellations as a separate rate so you can see which problem you have.

Practice manager in a Brisbane clinic office comparing printed appointment reports with a blurred appointment book on screen

What counts as a no-show?

A no-show, or did not attend (DNA), is a booked appointment that was not cancelled and where the patient did not arrive. A late cancellation is a cancellation made inside your notice window, such as the period stated in your cancellation policy. Write down how you treat edge cases before you count: a patient who arrives too late to be seen, a telehealth patient who never joins, a patient who rings at the start time to rebook, and a group session where some participants do not come. A figure that changes definition from month to month cannot show a trend, so the written rule matters more than which option you pick.

  • Did not attend: booked, not cancelled, patient absent
  • Late cancellation: cancelled inside your notice window
  • Cancelled with notice: left out of the no-show rate
  • Arrived too late to be seen: choose DNA or attended, and record the rule

Which appointments belong in the denominator?

Use appointments that were still booked when their start time arrived: those attended plus those marked DNA. Leave out appointments cancelled with notice, blocked time, meetings, administrative bookings and test entries. Some reports divide DNAs by every appointment ever booked, including those cancelled weeks earlier. That gives a smaller percentage from the same events, which is why figures from different sources rarely compare. Either method can work if you use it every month. If you need to compare with a published figure, find out which denominator it used first. The table below shows how much the choice moves the result.

Where do the numbers come from in your practice software?

Each system stores non-attendance differently, so read its help pages before you trust a report. In Cliniko, the Missed appointments report lists appointments marked Did not arrive alongside cancellations, but filters DNAs by appointment date and cancellations by cancellation date. Cliniko's appointments schedule report leaves out appointments marked Did not arrive, so a schedule count gives attended appointments only and you add DNAs back to get the denominator. In Halaxy, the Non-attendance option sets the status to Did Not Attend and keeps the invoice, while deleting an appointment removes it from the calendar along with its invoice and linked notes.

For Best Practice, MedicalDirector, Nookal, Splose or any other system, check the status names your practice uses and run a test report on a week you can verify by hand against the appointment book.

Which counting traps distort the rate?

The arithmetic is simple; the errors come from how events are recorded. If reception deletes a no-show booking to free the slot, the DNA disappears from every report. If a no-show is recorded as a cancellation, it lands in the wrong rate. Date filters that differ between DNAs and cancellations can place related events in different months. Before you report a figure, take a sample of appointments from the month and check each status against the appointment book and any notes. Fix the recording habit as well as the number, or the same error returns next month.

  • Bookings deleted instead of marked DNA
  • No-shows recorded as cancellations
  • Different date filters for DNAs and cancellations
  • Group sessions counted once instead of per participant
  • Telehealth no-shows recorded inconsistently

How should you break the rate down?

A single practice-wide figure tells you whether there is a problem; the breakdown tells you where. Split the same month's data by practitioner, appointment type, day and time, and lead time, meaning the number of days between booking and appointment. Add new versus returning patients and, if you send reminders, the reminder outcome: confirmed, no reply or failed delivery. Each split points to a different fix. A high rate on long-lead bookings suggests a reminder or confirmation gap, while a high rate on one appointment type may mean patients are unclear about what the appointment is for.

What should you do with the figure each month?

Record the monthly rate in one place with the definition beside it, and review it with the same people each month. Change one thing at a time, such as reminder timing, a confirmation request or a waitlist process for short-notice gaps, and compare the following two or three months with the earlier trend. Use your own average fee per appointment if you want to put a dollar value on the gap; the no-show cost calculator on this site does that arithmetic. Keep the counting rules fixed while you test, or you will not know whether the change or the counting moved the number.

Hypothetical example: one month, four ways to count

MeasureNumeratorDenominatorResultWhen to use it
DNA rate on appointments still booked at start time60 DNAs1,500 (1,440 attended plus 60 DNAs)4.0%Your standard monthly figure
DNA rate on every appointment booked60 DNAs1,800 (includes 300 cancellations)3.3%Only when matching another source's method
Late cancellation rate90 late cancellations1,800 appointments booked5.0%Tracking short-notice gaps separately
Short-notice loss rate150 (60 DNAs plus 90 late cancellations)1,590 (1,500 plus 90 late cancellations)9.4%Estimating appointment time at risk before refilling

Practical checklist

  • The practice has a written definition of DNA and late cancellation, including the notice window.
  • Staff mark non-attendance with the DNA status and do not delete the booking.
  • The date basis of each report (appointment date or cancellation date) is known.
  • The denominator excludes blocked time, administrative bookings and appointments cancelled with notice.
  • A sample of appointments was checked against the appointment book before the figure was reported.
  • Breakdowns by practitioner, appointment type and lead time come from the same export.

Common questions

What is a normal no-show rate for an Australian clinic?

There is no single benchmark worth relying on. Rates vary with specialty, patient group, billing model and how far ahead appointments are booked, and published figures use different definitions and denominators. Your own trend over several months, measured the same way each time, is the more useful comparison. If you do compare with an outside figure, check its definition first.

Should late cancellations count as no-shows?

Track them separately. Both leave a gap, but they have different causes and fixes. A late cancellation gives you some notice to refill the slot from a waitlist, while a no-show gives none. Combining them hides which one is growing. If you want a single figure for lost appointment time, report the short-notice loss rate alongside the two separate rates.

How long a period should we measure?

Report monthly, but judge changes over at least three months, because a single month can be distorted by school holidays, illness outbreaks or a practitioner's leave. Keep a rolling twelve-month view so seasonal patterns are visible. When you change a process, note the date on your tracking sheet so later readers can see which months came before and after.

Do automated reminders change the calculation?

The formula stays the same. What changes is the breakdown you can add: the no-show rate for patients who confirmed, who did not reply and whose message failed to deliver. That split shows whether the reminder process or the patient response is the weak point. Make sure cancellations made through reminders are recorded with the right status so they do not appear as no-shows.

Who should own the no-show figure?

Give it to one person, usually the practice manager, who runs the report the same way each month and checks a sample against the appointment book. Practitioners should see their own figures alongside the practice figure. Reception staff need the recording rules, because the accuracy of the rate depends on how they mark each missed appointment on the day.

Sources and further reading

Continue planning

Plan the administrative handover

Describe your administrative process without including patient details. We can discuss staff review, system access and the checks needed before introducing a workflow. Clinical decisions stay with your care team.