Template · Published Nov 18, 2026

Medical Office Scheduling Template: Build the Provider Day (Free)

For practice managers and schedulers who inherited a template nobody can explain. You leave with a provider-day grid, the rules for slot types, buffers and same-day holds, the wave and modified-wave patterns compared, and an Excel builder that checks your template against demand.

A medical office scheduling template is the reusable grid that sets, for each provider and session, which slots take new patients, follow-ups, procedures and same-day holds, with buffers and release times. Access is decided here: primary care new patients waited 5 days for the third next available slot in 2022 (MGMA, 2023).

Key takeaways

  • Third next available appointment in 2022: primary care 5 days for new and 3 for established patients; nonsurgical 15 and 11; surgical 11 and 7 (MGMA data report, Aug 2023).
  • Same-day visits were 16% of primary care appointments in 2022, up from 10% in 2019 (MGMA, 2023).
  • New-patient waits averaged 31 days across six specialties in 15 large metros, and 23.5 days in family medicine, in early 2025 (AMN Healthcare survey, 2025).
  • 32% of groups reported higher no-shows in 2026 than in 2025; MGMA's advice is waitlists, releasing held slots on a set schedule and protecting same-day capacity (MGMA Stat, Aug 2026).
  • Modified wave scheduling means "patients are purposely double-booked at the front end of each hour and the end of the hour is left open for catch-up" (AAFP FPM, 2002; older).
XLSX
Medical Office Scheduling Template
  • Slot list builder
  • Week view
  • Template checks
  • Demand vs offered
  • Capacity dashboard
  • Methods compared
  • Playbook

The Excel builder behind this page: list each provider's slots once, and it draws the week, flags overlaps, back-to-back new patients and sessions that run over, sets release times for same-day holds, and compares the slots you offer with the demand you measured.

Get the free scheduling template

The scheduling template, filled in

Here is one provider's Monday as the template sets it: new patients early in each session, a buffer mid-session, same-day holds with release times, and short follow-ups at the end. Every slot has a type, a length and a reason.

One provider's Monday, built from the template (sample)
TimeMorning slotTimeAfternoon slot
8:00New patient, 40 min1:00Same-day hold (release 11:00)
8:40Follow-up, 201:20Same-day hold (release 11:20)
9:00Follow-up, 201:40New patient, 40 min
9:20Follow-up, 202:20Follow-up, 20
9:40Buffer, 202:40Follow-up, 20
10:00New patient, 40 min3:00Buffer, 20
10:40Follow-up, 203:20Procedure, 30
11:00Follow-up, 203:50Follow-up, 20
11:20Same-day hold (release 9:20)4:10Follow-up, 20
11:40Follow-up, 204:30Follow-up, 20 (ends 4:50)

Who owns it: the practice manager with one provider, never whoever books next. Who uses it: every scheduler, the online booking tool and the waitlist owner. Who changes it: only the owner, at the quarterly review, in writing.

What the template decides

The template is not the schedule. It is the rulebook the schedule is built from, and seven decisions live inside it.

The seven decisions in a scheduling template
ElementWhat it decidesThe default that hurts
Slot typesWhich visits each slot acceptsEvery slot open to every visit type
Slot lengthsMinutes per visit typeOne length for everything
PlacementWhere new patients and procedures sitNew patients stacked at the end of the day
BuffersCatch-up time inside each sessionNone, so one late patient delays everyone
Same-day holdsSlots protected for urgent needsNone, or holds that are never released
Release rulesWhen an unused hold opens to anyoneHolds that sit empty
Override rightsWho can book outside the rulesEveryone, so the template stops meaning anything

Access is set by the template

The wait a new patient hears on the phone is a template decision made months ago. The third next available appointment is the standard way to measure it, because it ignores the one-off cancellation that happens to be open today.

New patients wait longer than established patients for the third next available slotPaired bar chart, MGMA 2022 data, third next available appointment in days: primary care 5 for new and 3 for established patients; nonsurgical specialties 15 and 11; surgical specialties 11 and 7. THIRD NEXT AVAILABLE APPOINTMENT, 2022 Days, median. Teal: new patients. Grey: established patients. Primary care5 days3 days Nonsurgical15 days11 days Surgical11 days7 days Bars start at zero. Source: MGMA DataDive Practice Operations (2023 survey, 2022 data).
The template sets the wait. Primary care: 5 days new, 3 established; nonsurgical: 15 and 11; surgical: 11 and 7 (third next available appointment, 2022). Source: MGMA data report, Aug 2023. Caveat: MGMA members skew larger than a 1 to 10 physician practice; measure your own third next available slot weekly.

Patients notice: new-patient waits averaged 31 days across six specialties in 15 large metros when AMN Healthcare called 1,391 offices in early 2025 (AMN Healthcare survey, 2025). The other side of the same grid is the slot that opens and stays empty: the single-specialty no-show rate was 6.81% in 2023 (MGMA Stat, Jan 2025) and the cancellation rate 19.95% in 2024 (MGMA Stat, Aug 2026). A template with holds, release times and a waitlist handles both.

Set the new and follow-up mix from demand

Most templates set the new-patient share by habit. Set it from demand instead: pull 90 days of requests by visit type from your scheduling reports, including the ones you could not book, and compare them with the slots you offered.

Demand data and what to compute
DataComputeUse it to
New-patient requests a weekAverage, by providerSet weekly new-patient slots at or above it
Follow-up intervals ordered at checkoutVisits owed a weekSize follow-up slots
Same-day requests by weekdayAverage and busiest weekdaySize same-day holds by day
Days to the third open slot, by typeWeekly snapshotTrack access
Unfilled slots by type and timeCount a weekFind slots to convert

If new patients wait weeks while follow-up slots go unfilled, the fix is converting slots, not adding hours.

Stream, wave or modified wave

Most small practices use stream scheduling with a few deliberate exceptions. Wave and modified wave are tools for specific sessions, not a whole-practice philosophy.

Scheduling patterns compared
PatternHow it worksBest whenMain risk
StreamOne patient per slot at fixed timesVisit lengths are predictableOne late patient pushes the whole session
WaveSeveral patients share one start time (often the top of the hour) and are seen in arrival orderRooming and intake take longer than the provider timeWaiting-room crowding and long waits for the last patient
Modified waveTwo patients at the start of each hour, the end of the hour left open to catch upLate arrivals and short no-notice gaps are commonWithout real catch-up time, it is just double-booking
Double-booking or overbookingAn extra patient booked into a held or filled slotShort, predictable visits with a steady no-show rateOverrun days when everyone shows

The AAFP's description of modified wave is still the clearest: double-book the first slot of each hour and leave the end of the hour open (Chung, AAFP FPM, 2002; older guidance). Be careful with overbooking: MGMA's operations team wrote in June 2026 that it is "actively dangerous in procedural and resource-intensive settings" (MGMA, 2026). A waitlist that fills real openings, as in the medical office waitlist, is the safer way to use canceled time.

Placement and buffers

Set slot lengths from your own timing, not from habit. For two weeks, note check-in, rooming, provider-in and checkout times for a sample of visits by type, set lengths for the typical visit, and put the extra time where it can absorb the long one: a buffer.

Placement rules
RuleWhy
New patients and procedures early in each sessionThey run long; early placement lets the session recover
Never two new patients back to backTwo long visits in a row guarantee a late session
One catch-up buffer mid-sessionAbsorbs one late patient without moving everyone
Same-day holds where morning calls can reach themLate morning and early afternoon fill the same day
Short follow-ups at the end of the sessionEasier to finish on time

Late arrivals break even a good template; the rule for them is in the late arrival policy.

Check your template against these rules automatically

List your slots once and the builder flags overlaps, back-to-back new patients and sessions that run over, and shows whether your new-patient slots cover your demand.

Get the free scheduling template

Same-day holds and release times

A same-day hold is only useful if it opens on schedule when nobody needs it. MGMA's 2026 advice is to release held slots on a set schedule and protect same-day or next-day capacity where demand supports it (MGMA Stat, Aug 2026). Size holds by weekday, because Monday rarely looks like Thursday.

Same-day holds by weekday (method; use your own counts)
WeekdaySame-day requestsHolds per providerRelease
MondayYour 90-day Monday averageAverage divided by providers working2 hours before the slot
Tuesday to ThursdayYour midweek averageAverage divided by providers working2 hours before the slot
FridayYour Friday averageAverage divided by providers working2 hours before the slot

A released hold that still goes empty is a waitlist job. Primary care had already moved this way: same-day visits rose from 10% of appointments in 2019 to 16% in 2022 (MGMA, 2023).

Worked example: convert slots, not hours

Take a hypothetical family physician with 30 follow-up and 6 new-patient slots a week. The scheduling report shows 9 new-patient requests a week and an average of 6 follow-up slots going unfilled. This is a worked example; the builder's Demand tab runs it on your numbers.

Worked example (ClinicOps calculation)
ItemValueBasis
New-patient requests a week990-day average
New-patient slots offered6Current template
Short a week39 minus 6
New patients pushed out a year1443 x 48 weeks
Unfilled follow-up slots a week6Same report
Fix3Convert 6 empty 20-minute follow-ups into 3 new-patient 40-minute slots

No new hours, no new staff: the same 120 minutes a week now serve the demand that was being turned away. Recheck the third next available new-patient slot a month later to see whether the wait moved.

The quarterly template review

  1. Pull 90 days of demand by visit type and weekday, including requests you could not book.
  2. Compare with slots offered and list the types that are short and the slots that go unfilled.
  3. Check the third next available slot for new and established patients, per provider.
  4. Check the holds: how often each released, and how often a released hold still went empty.
  5. Change one thing at a time, write it down, and tell the schedulers and the online booking tool the same day.

Put the results on the owner dashboard and the day-to-day running on the daily huddle. If you would rather have the schedule capacity, provider productivity and the template read for you with the first fixes ranked in dollars, that is the Profit Leak Diagnostic; what an operations consultant costs explains how it is priced.

By the numbers

Every figure on this page
FigureWhat it measuresSource, year
5 and 3 daysThird next available, primary care, new and established, 2022MGMA, 2023
15 and 11 daysSame, nonsurgical specialtiesMGMA, 2023
11 and 7 daysSame, surgical specialtiesMGMA, 2023
16% and 10%Same-day share of primary care appointments, 2022 and 2019MGMA, 2023
31 daysAverage new-patient wait, six specialties, 15 metros, early 2025AMN Healthcare survey, 2025
23.5 daysAverage new-patient wait, family medicine, early 2025AMN Healthcare survey, 2025
6.81%No-show rate, single-specialty aggregate, 2023MGMA Stat, 2025
19.95%Cancellation rate, single-specialty aggregate, 2024MGMA Stat, 2026
32%Groups reporting higher no-shows than in 2025 (poll, 190 responses)MGMA Stat, 2026
Do this in the next hour
  1. Write down the third next available new-patient slot for each provider today.
  2. Pull last quarter's new-patient requests by week and compare with new-patient slots offered.
  3. Find every same-day hold in next week's template and check it has a release time.
  4. Name the template owner and stop all other edits until the review.

The template is one of the front-door systems in the operations system library. It works with reminders in the appointment reminder text templates and prevention in the three no-show workflow fixes.

Build the provider day on purpose

The builder lists your slots once, draws the week and checks it against your rules and your demand. If you want a second pair of eyes first, book the free 20-minute Chaos Audit: we look at one provider's week together and you leave with the first fix.

Frequently asked questions

What is a medical office scheduling template?

It is the reusable grid that sets, for each provider and session, which slots accept new patients, follow-ups, procedures and same-day holds, how long each is, where buffers sit and when unused holds release. The daily schedule is built from it.

What is wave scheduling?

Several patients share the same start time, often the top of the hour, and are seen in the order they arrive. It suits sessions where intake and rooming take longer than the provider's time, but it crowds the waiting room.

What is modified wave scheduling?

Two patients are booked at the start of each hour and the end of the hour is left open to catch up, as the AAFP described it in 2002. Without real catch-up time it becomes plain double-booking.

How many same-day slots should we hold?

Size them from your own same-day requests by weekday over 90 days, divided by the providers working that day. Give every hold a release time so it opens to anyone when nobody needs it.

How long should appointment slots be?

Time a sample of visits by type for two weeks, set lengths for the typical visit, and absorb the long ones with a buffer mid-session. One length for every visit type guarantees late sessions or idle time.

What is the third next available appointment?

The number of days until the third open slot of a given type. It is the standard access measure because it ignores one-off cancellations. In MGMA's 2022 data it was 5 days for primary care new patients and 3 for established patients.