Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHealth & FitnessClinic & Practice ManagementPatient No-Show & Cancellation Tracker

SpreadsheetClinic & Practice ManagementFree

Patient No-Show & Cancellation Tracker

Log missed and cancelled appointments with reason and notice given, and see the lost revenue by provider and reason.

Shown with sample data

Colour

Patient No-Show & Cancellation Tracker

Log missed and cancelled appointments with reason and notice given, and see the lost revenue by provider and reason.

Missed or cancelled
8
Revenue lost
$470
Slots not refilled
No-shows
4
Slots refilled
25%
Revenue lost by type
  • No-show$330
  • Late cancellation$70
  • Cancellation with notice$70
Share of revenue lost by type
  • No-show$33070%
  • Late cancellation$7015%
  • Cancellation with notice$7015%

How to use it

  1. 1Add a row for every no-show or cancellation with the visit value.
  2. 2Choose the reason and the notice given.
  3. 3Mark Slot refilled when another patient took the time.
  4. 4Review the summary by reason each month and act on the top cause.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Missed appointments cost a practice money and cost other patients a slot. Record each no-show and late cancellation with the reason, how much notice was given and whether the slot was refilled. The tracker shows lost revenue, the most common reasons and which patients need a reminder call, so you can target the fix.

Who it’s for

  • Reducing no-shows with evidence
  • Deciding on a cancellation policy
  • Monthly practice reports

What’s included

  • Log sheet: One row per missed or cancelled appointment.
  • Summary by Type sheet: Revenue lost and Visit value and the number of entries for each type, calculated from the Log sheet.

How to use it

  1. 1Add a row for every no-show or cancellation with the visit value.
  2. 2Choose the reason and the notice given.
  3. 3Mark Slot refilled when another patient took the time.
  4. 4Review the summary by reason each month and act on the top cause.

Tips

  • Two reminders (three days and one day before) usually cut no-shows more than a fee does.
Related searchesno-show trackermissed appointmentscancellation logclinic revenueappointment reminders

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetClinic & Practice ManagementFree

Patient No-Show & Cancellation Tracker

Log missed and cancelled appointments with reason and notice given, and see the lost revenue by provider and reason.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Clinic & Practice Management
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More clinic & practice management templates

View all
Patient Appointment Schedule2 sheets

Appointments

10

No-show rate

10%

Average wait (min)

11.5

ABCD
1DateTimeProviderVisit type
2Nov 1208:30Dr PatelAnnual check
3Nov 1208:30NP RiveraFollow-up
4Nov 1209:00Dr PatelNew patient
5Nov 1209:15Dr OkaforProcedure
Schedule
SpreadsheetClinic & Practice Management

Patient Appointment Schedule

A day sheet for the front desk: every appointment by provider and room, with arrival status, wait time and the day’s no-show rate.

10 min setupPreview

New Patient Intake Form

Please complete this form before your first visit. Your answers help us prepare for your appointment.

Full name *

Date of birth *

Phone *

Send my details
FormClinic & Practice Management

New Patient Intake Form

Registration details, emergency contact, insurance and a short health history, collected before the first visit.

10 min setupPreview
Nurse Shift Schedule

Shifts rostered

53

Hours rostered

636

16171819202122
Amara NwosuDDDOffOffOffD
Ben CarterOffOffOffOff
Chloe MartinOffOffOffDDDOff
Dev SharmaOffOffOffOff
SpreadsheetClinic & Practice Management

Nurse Shift Schedule

A two-week unit roster with day, evening and night shifts, hours per nurse and a staffing check for every shift.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ