Published by Clinic Admin Tools UK · 2026-08-05 · Independent practice-admin guide · Not clinical, legal, or tax advice

How to calculate no-show rate for clinics

“How to calculate no-show rate” is usually asking for a method, not another opaque KPI. Here is a clear formula UK clinic teams can apply in a spreadsheet or practice system—then check with the free calculator.

Important Illustrative planning content for UK private clinic administration only. Figures and bands are not audited national statistics and do not replace advice from your accountant, solicitor, or clinical leads. See the disclaimer.

Key takeaways

  • No-show rate ≈ DNAs ÷ scheduled appointments in the same period × 100.
  • Decide how late cancellations are classified before you compare months.
  • Use the same status codes from your practice management system every time.
  • Convert rate into £ with missed-appointment and reminder ROI tools when needed.

The basic formula

For a chosen period (week, month, or quarter): count appointments that were scheduled and reached the DNA/no-show status, then divide by the number of appointments that were scheduled in that same cohort. Multiply by 100 for a percentage.

Example: 40 DNAs out of 500 scheduled appointments → 40 ÷ 500 = 0.08 → 8% no-show rate.

What to include and exclude

Include appointments that were firmly booked and expected to attend. Exclude slots that were never confirmed, blocked admin time, or cancelled early under a policy that treats them as unused capacity rather than DNA—unless your SOP says otherwise.

Late cancellations are the grey area. Some clinics fold “cancelled inside 24 hours” into a combined “failure to attend as planned” rate; others keep DNA and late cancel separate. If you mix them without labelling, peer comparisons become meaningless.

  • DNA / no-show: patient did not attend and did not cancel under your rules.
  • Late cancel: cancelled inside your policy window—track separately if fees differ.
  • Early cancel / reschedule: usually not a no-show.
  • Clinic-cancelled sessions: exclude from the patient no-show rate.

Step-by-step in your practice system

Export appointments for the period with status codes. Filter to the diaries or sites you care about. Count DNAs (numerator) and all scheduled appointments in scope (denominator). Calculate the percentage and save the export so you can audit the number later.

Segment by practitioner, site, appointment type, and new vs returning patient when volume allows. A clinic-wide average can hide one diary that needs a deposit policy or reminder change.

Turn the percentage into action

A rate alone does not tell you whether SMS reminders, deposits, or overbooking rules pay back. Estimate lost session value with the missed appointment loss calculator, then test reminder cost against recovered sessions with the reminder ROI calculator.

Clinical and safeguarding contexts matter: chasing attendance must stay consistent with professional standards and your patient communication policy.

Common questions

Is no-show rate the same as DNA rate?
In UK clinic admin language they are often used interchangeably. Confirm the status code your system labels DNA/no-show and use that consistently.
Should the denominator be booked slots or available slots?
For no-show rate, use scheduled/booked appointments as the denominator—not empty available slots. Empty slots belong in utilisation analysis.
How often should we calculate it?
Monthly is enough for most clinics; weekly if you are testing a new reminder or deposit policy. Keep the period long enough that one busy bank holiday week does not dominate.

Related calculators

Use these free tools alongside this guide—inputs stay in your browser.