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).
- 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 templateThe 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.
| Time | Morning slot | Time | Afternoon slot |
|---|---|---|---|
| 8:00 | New patient, 40 min | 1:00 | Same-day hold (release 11:00) |
| 8:40 | Follow-up, 20 | 1:20 | Same-day hold (release 11:20) |
| 9:00 | Follow-up, 20 | 1:40 | New patient, 40 min |
| 9:20 | Follow-up, 20 | 2:20 | Follow-up, 20 |
| 9:40 | Buffer, 20 | 2:40 | Follow-up, 20 |
| 10:00 | New patient, 40 min | 3:00 | Buffer, 20 |
| 10:40 | Follow-up, 20 | 3:20 | Procedure, 30 |
| 11:00 | Follow-up, 20 | 3:50 | Follow-up, 20 |
| 11:20 | Same-day hold (release 9:20) | 4:10 | Follow-up, 20 |
| 11:40 | Follow-up, 20 | 4:30 | Follow-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.
| Element | What it decides | The default that hurts |
|---|---|---|
| Slot types | Which visits each slot accepts | Every slot open to every visit type |
| Slot lengths | Minutes per visit type | One length for everything |
| Placement | Where new patients and procedures sit | New patients stacked at the end of the day |
| Buffers | Catch-up time inside each session | None, so one late patient delays everyone |
| Same-day holds | Slots protected for urgent needs | None, or holds that are never released |
| Release rules | When an unused hold opens to anyone | Holds that sit empty |
| Override rights | Who can book outside the rules | Everyone, 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.
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.
| Data | Compute | Use it to |
|---|---|---|
| New-patient requests a week | Average, by provider | Set weekly new-patient slots at or above it |
| Follow-up intervals ordered at checkout | Visits owed a week | Size follow-up slots |
| Same-day requests by weekday | Average and busiest weekday | Size same-day holds by day |
| Days to the third open slot, by type | Weekly snapshot | Track access |
| Unfilled slots by type and time | Count a week | Find 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.
| Pattern | How it works | Best when | Main risk |
|---|---|---|---|
| Stream | One patient per slot at fixed times | Visit lengths are predictable | One late patient pushes the whole session |
| Wave | Several patients share one start time (often the top of the hour) and are seen in arrival order | Rooming and intake take longer than the provider time | Waiting-room crowding and long waits for the last patient |
| Modified wave | Two patients at the start of each hour, the end of the hour left open to catch up | Late arrivals and short no-notice gaps are common | Without real catch-up time, it is just double-booking |
| Double-booking or overbooking | An extra patient booked into a held or filled slot | Short, predictable visits with a steady no-show rate | Overrun 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.
| Rule | Why |
|---|---|
| New patients and procedures early in each session | They run long; early placement lets the session recover |
| Never two new patients back to back | Two long visits in a row guarantee a late session |
| One catch-up buffer mid-session | Absorbs one late patient without moving everyone |
| Same-day holds where morning calls can reach them | Late morning and early afternoon fill the same day |
| Short follow-ups at the end of the session | Easier to finish on time |
Late arrivals break even a good template; the rule for them is in the late arrival policy.
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 templateSame-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.
| Weekday | Same-day requests | Holds per provider | Release |
|---|---|---|---|
| Monday | Your 90-day Monday average | Average divided by providers working | 2 hours before the slot |
| Tuesday to Thursday | Your midweek average | Average divided by providers working | 2 hours before the slot |
| Friday | Your Friday average | Average divided by providers working | 2 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.
| Item | Value | Basis |
|---|---|---|
| New-patient requests a week | 9 | 90-day average |
| New-patient slots offered | 6 | Current template |
| Short a week | 3 | 9 minus 6 |
| New patients pushed out a year | 144 | 3 x 48 weeks |
| Unfilled follow-up slots a week | 6 | Same report |
| Fix | 3 | Convert 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
- Pull 90 days of demand by visit type and weekday, including requests you could not book.
- Compare with slots offered and list the types that are short and the slots that go unfilled.
- Check the third next available slot for new and established patients, per provider.
- Check the holds: how often each released, and how often a released hold still went empty.
- 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
| Figure | What it measures | Source, year |
|---|---|---|
| 5 and 3 days | Third next available, primary care, new and established, 2022 | MGMA, 2023 |
| 15 and 11 days | Same, nonsurgical specialties | MGMA, 2023 |
| 11 and 7 days | Same, surgical specialties | MGMA, 2023 |
| 16% and 10% | Same-day share of primary care appointments, 2022 and 2019 | MGMA, 2023 |
| 31 days | Average new-patient wait, six specialties, 15 metros, early 2025 | AMN Healthcare survey, 2025 |
| 23.5 days | Average new-patient wait, family medicine, early 2025 | AMN Healthcare survey, 2025 |
| 6.81% | No-show rate, single-specialty aggregate, 2023 | MGMA Stat, 2025 |
| 19.95% | Cancellation rate, single-specialty aggregate, 2024 | MGMA Stat, 2026 |
| 32% | Groups reporting higher no-shows than in 2025 (poll, 190 responses) | MGMA Stat, 2026 |
- Write down the third next available new-patient slot for each provider today.
- Pull last quarter's new-patient requests by week and compare with new-patient slots offered.
- Find every same-day hold in next week's template and check it has a release time.
- 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.