Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHealth & FitnessClinic & Practice ManagementPatient Appointment Schedule

SpreadsheetClinic & Practice ManagementFree

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.

Shown with sample data

Colour

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.

Appointments
10
No-show rate
10%
Of all booked visits
Average wait (min)
11.5
Arrival to seen
Minutes lost
30
No-shows and cancellations
Entries by visit type
  • Follow-up4
  • Annual check2
  • New patient1
  • Procedure1
  • Telehealth1
  • Urgent1
Share of entries by visit type
  • Follow-up440%
  • Annual check220%
  • New patient110%
  • Procedure110%
  • Telehealth110%
  • Urgent110%

How to use it

  1. 1Enter tomorrow’s appointments in time order with provider, room and visit type.
  2. 2Use initials or a chart number in the Patient column rather than full names.
  3. 3Change Status as each patient arrives, is roomed and checks out, and type the arrival and seen times.
  4. 4At the end of the day read the no-show rate and average wait, then copy the sheet for the next day.

In this workbook

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

About this template

Run the day from one sheet. List each appointment with its provider, room and visit type, then update the status as patients arrive, are seen and leave. The sheet works out how long each patient waited, how full each provider’s day is and what share of the day was lost to no-shows and late cancellations, so the practice manager can see where the schedule is leaking time.

Who it’s for

  • Small clinics and group practices
  • Dental, physiotherapy and specialist offices
  • Front desks without a full scheduling system

What’s included

  • Schedule sheet: Every appointment for the day, in time order.
  • Summary by Visit type sheet: The number of entries for each visit type, calculated from the Schedule sheet.

How to use it

  1. 1Enter tomorrow’s appointments in time order with provider, room and visit type.
  2. 2Use initials or a chart number in the Patient column rather than full names.
  3. 3Change Status as each patient arrives, is roomed and checks out, and type the arrival and seen times.
  4. 4At the end of the day read the no-show rate and average wait, then copy the sheet for the next day.

Tips

  • Confirm appointments the day before; most no-shows are forgotten appointments.
  • Keep one or two same-day slots open per provider for urgent visits.

Questions

How is wait time worked out?

Minutes between the arrival time and the time the patient was seen, for visits with both times entered.

Can I use it for a week?

Yes. Add a Date column value for each day and filter by date; the key figures cover every row.

Related searchesappointment scheduleclinic schedulepatient schedulingfront deskno-show ratemedical office

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 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.

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

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
Medical Supplies Inventory2 sheets

Items to reorder

4

Expiring within 60 days

2

Expired

1

ABCD
1ItemCategoryUnitStorage area
2Nitrile gloves, mediumPPEBox of 100Store cupboard
3Surgical masksPPEBox of 50Store cupboard
4Gauze swabs 10 x 10 cmWound carePack of 100Treatment room 1
5Adhesive dressings, assortedWound careBoxTreatment room 1
Supplies
SpreadsheetClinic & Practice Management

Medical Supplies Inventory

Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.

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