Every two weeks, the DON sits down and rebuilds the schedule from last pay period’s PDF, a call-out list, and memory. No clean starting point. Three to five hours of work that was done two weeks ago.
At 26 pay periods per year, that is 78 to 130 hours of DON time spent recreating a document that already existed. That is two to three full workweeks, annually, on a task a master template eliminates.
The template below is built for skilled nursing facilities — not a generic retail schedule adapted for healthcare, not a hospital day/night split repurposed for SNFs. It covers all five SNF disciplines, uses the 14-day pay period structure, includes floor assignment columns, and tracks hours to surface overtime risk before a shift is assigned.
Quick Summary
This post provides a free two-week SNF staff scheduling template in Excel format. It covers all five SNF disciplines — CNA, Nursing, Housekeeping, Laundry, Front Desk — organized by 14-day pay period, with per-floor columns and an hours tracker to flag overtime risk. It is designed for skilled nursing facilities managing PBJ compliance, not adapted from a generic workforce tool. Download it below, then use the setup guide to configure it for your facility’s census and floor layout.
Download the Free Two-Week SNF Scheduling Template
This template is built around how SNF scheduling actually works — 14-day pay periods, five disciplines with separate shift configurations, floor-level coverage columns, and a running hours tracker. Excel format, ready to customize for your census, floor layout, and shift codes.
Download includes two files: Worked Example — pre-filled to show you how it works
Blank Template — ready to fill in with your staff, floors, and shift codes
What each file includes:
- 14-column pay period grid (Day 1 through Day 14)
- Separate row groupings for each of the five SNF disciplines
- Shift code convention (D, E, N, O) with time reference per discipline
- Per-floor assignment column for each staff row
- Running hours column with conditional formatting — orange at 36 hours, red at 40 hours
- Master template tab — build once, copy forward each pay period
Why Generic Scheduling Templates Don’t Work for Nursing Homes
Every result on Google for this keyword is a template built for a restaurant, a retail store, or a hospital nursing unit. They show a column for each day of the week and a row for each employee. That is the entire structure.
A skilled nursing facility is not a restaurant. The schedule is not just an operational tool — it is a compliance document. A survey citation for staffing is not corrected by scrambling to prove coverage happened after the surveyor asks. It is prevented by a schedule structure that makes coverage verifiable from the first column.
What 3.8 HPRD Means When It Hits a Real Schedule
Generic healthcare templates typically show RN, LPN, and CNA. SNF scheduling covers five distinct staff categories: CNA, Nursing, Housekeeping, Laundry, and Front Desk.
Each discipline carries different shift configurations, different state compliance implications, and different coverage obligations. Front Desk runs two shifts. CNAs run three clinical shifts with state-mandated minimum hours per resident per day. Housekeeping and Laundry follow facility-specific schedules that must still be documented, published, and retained.
Collapsing five disciplines into a shared generic grid makes ratio compliance unverifiable and PBJ submission inaccurate. These are not formatting preferences — they are compliance failures.
SNF Schedules Run on Pay Periods, Not Calendar Weeks
Generic scheduling templates are organized by calendar week. SNF scheduling does not work this way.
Skilled nursing facilities run on 14-day pay period cycles. The pay period is the unit of measurement for staffing documentation, payroll, and PBJ submission. A Monday-through-Sunday template does not align with how SNF payroll is processed, how overtime accumulates, or how CMS expects staffing hours to be reported.
Using a weekly template for SNF scheduling creates a structural mismatch between the schedule and the compliance documentation it is supposed to support. That mismatch surfaces at the worst possible moment — during a survey or a PBJ audit.
Floor-Level Coverage Is a Compliance Requirement, Not a Preference
A surveyor reviewing staffing records does not ask how many CNAs worked on Tuesday. They ask how many CNAs were on Floor 3 during the evening shift on Tuesday.
Floor-level coverage must be documented at the schedule level — not reconstructed from memory when surveyors arrive. A template without floor columns cannot produce this documentation at the speed a survey demands.
This is the gap generic templates leave open. It is also where facilities get cited.
How to Set Up Your Two-Week SNF Scheduling Template
Column Structure — The Pay Period Grid
The primary grid runs 14 columns — Day 1 through Day 14 — mapped to the specific dates of each pay period. Each pay period has a header row showing the start and end date and a status field (Pending, Active, or Closed).
Day 1 through Day 14 are not calendar labels. They are position markers within the pay period. When you copy the master template forward, you update the date headers — the structure stays fixed.
The status field is not administrative labeling. Pending means the schedule is in progress. Active means it has been published to staff — this is the compliance gate. Closed means the period has ended and the record is archived.
Discipline Rows and Shift Codes
Organize staff rows into five discipline groups, each separated by a header row: CNA, Nursing, Housekeeping, Laundry, Front Desk. Do not mix disciplines into a single alphabetical staff list.
Each cell in the grid takes a shift code: D (Days), E (Evenings), N (Nights), or O (Off). Clinical disciplines support up to 13 shift configurations depending on the facility. Front Desk uses two: 8am–4pm and 4pm–8pm.
Shift codes instead of written hours keep the grid visually scannable across 14 columns. Call-out coverage gaps are visible at a glance without column expansion.
|
Discipline
|
Valid Codes
|
Shifts/Day
|
Coverage Note
|
|---|---|---|---|
|
CNA
|
D, E, N, O, V, SK
|
||
Floor Assignment Columns
Add a Floor column immediately to the right of each staff member’s name. The floor assignment stays fixed in the master template for permanent assignments and updates as needed when assignments change.
When a CNA is assigned to Floor 3, that assignment must appear in the schedule record — not just in a verbal handoff at the start of the shift. The floor column makes the assignment documentable without a separate assignment sheet.
For facilities managing 130 rooms across five floors, the floor column is what separates a compliance document from a headcount list.
The Below-40-Hours Column
The most common source of SNF overtime is not a staffing shortage — it is a scheduling visibility problem. The decision that triggers overtime is not the call-out. It is the shift assignment that goes to a CNA who was already at 36 hours.
Add a running Hours column at the right edge of each staff row. As shifts are assigned, the column totals scheduled hours for the pay period. A simple conditional formatting rule in Excel — yellow at 36 hours, red at 40 — flags the risk before the assignment is confirmed.
The conversation about overtime happens before the shift is assigned. Not three weeks later when the payroll report arrives.
The Master Template — Build Once, Schedule Every Pay Period
Three to five hours per pay period rebuild, 26 pay periods per year: 78 to 130 hours of DON time spent recreating a document that already existed two weeks ago. A master template reduces each pay period setup to approximately 20 minutes.
The rebuild-from-scratch cycle is not a scheduling problem — it is a missing policy problem. Facilities that rebuild from scratch every pay period do not have a master schedule. They have a temporary artifact that expires every two weeks.
The master template is the written policy. Each pay period schedule is the instance of it. That distinction matters when a surveyor asks whether your staffing approach is documented or improvised.
LTC Apps Staff Scheduling Software builds this structure natively — discipline filters, pay period management, a built-in 14-day master template, and published schedules accessible to staff without distributing PDFs. For facilities still building schedules manually, the Excel template is the right starting point.
What Goes in the Master Template
The master template holds everything stable across pay periods: staff names and disciplines, standard floor assignments, typical shift patterns for each staff member, and the full 14-column grid structure.
What does not live in the master template: specific pay period dates, call-out adjustments, temporary schedule changes, and substitutions. Those belong in the pay period instance — the copy of the master template for a specific period.
The master template is what your facility does. The pay period copy is what happened during a specific two weeks. Keeping them separate is what makes the template reusable.
How to Copy It Forward Each Pay Period
At the start of each new pay period, duplicate the master template tab in Excel. Update the date headers to reflect the new period’s start and end dates. Change the status to Pending.
Adjust for new hires, terminations, approved schedule requests, and any permanent floor reassignments. Assign shifts across the 14 days. When the schedule is complete, mark it Active — this is the publish step.
The Active status is what makes the schedule a documented record rather than a draft. A schedule that was never marked Active and distributed to staff does not have a defensible publication date if a surveyor asks when coverage was confirmed. See how the pay period lifecycle connects to PBJ compliance for the full status framework.
What Your Schedule Template Must Do for PBJ Compliance
A schedule sitting as a PDF on the DON’s desktop is not a PBJ-ready record. The Payroll-Based Journal requires documentation of actual hours worked, organized by staff discipline, submitted quarterly — 45 days after each quarter ends. (Source: CMS Payroll-Based Journal Final Rule)
Most scheduling-related survey citations are documentation production failures, not understaffing events. The staff was on the floor. The schedule existed somewhere. When the surveyor asked for organized, shift-level, floor-level records for a specific date range, producing them took an hour instead of two minutes.
The schedule structure is what determines whether documentation is retrievable in two minutes or two hours.
A disorganized template produces inaccurate PBJ submissions. Inaccurate PBJ submissions produce inaccurate Five Star staffing ratings. A one-star staffing domain rating reduces the overall Five Star score by one full star — a consequence visible to every family evaluating your facility on Care Compare. (Source: CMS Five Star Quality Rating System Technical Users’ Guide)
|
Requirement
|
Why It Matters
|
|---|---|
|
Discipline-level row organization
|
CMS requires hours reported by staff type. A template mixing disciplines cannot produce this breakdown without manual sorting.
|
|
Published Active status with date
|
The record needs a timestamp predating the period end. A schedule marked Active on Day 14 tells a different story than one marked Active on Day 1.
|
|
Archived pay period history
|
Prior periods must be accessible without searching through email attachments. Each closed tab is a compliance record.
|
See the complete guide to SNF staff scheduling compliance for the full documentation framework.
CNA Staffing Ratios and Template Design
The template structure must make ratio compliance verifiable — not something that gets reconstructed when a surveyor asks for it.
In Illinois, the requirement is 3.8 hours per resident day for skilled care residents. (Source: Illinois Administrative Code Title 77, Section 300.1230) For a 30-resident floor on a standard day shift, the calculation is: 30 residents × 3.8 HPRD ÷ 24 hours = approximately five CNAs minimum on duty during that shift.
Build the CNA row groupings in the template to reflect this minimum. If Floor 3 requires five CNAs minimum on days, the template should have at least five CNA rows for Floor 3. When fewer than five are assigned, the gap is visible before the shift starts — not after a surveyor finds it.
The federal minimum staffing rule was rescinded effective February 2, 2026, meaning state requirements now carry full enforcement weight with no federal floor beneath them. (Source: Federal Register, December 3, 2025) See Illinois CNA staffing ratio requirements in detail for the full calculation and compliance framework.
Who This Template Is For — and What Comes Next
This template is built for you if:
- You are a DON or scheduling coordinator at a skilled nursing facility rebuilding the schedule from scratch every pay period
- You manage five disciplines across multiple floors and no generic template has ever fit how your facility actually works
- You want to reduce overtime costs and improve PBJ documentation without implementing new software today
This is not the right fit if:
- You are scheduling for assisted living only, with no skilled nursing component
- You are looking for a full clinical EHR with automated staff assignment built in
The template is the right starting point. For facilities ready to eliminate the manual work entirely, LTC Apps Staff Scheduling Software gives SNFs a 14-day scheduling grid with discipline filters, pay period management, a built-in master template, and PDF, Excel, or Fillable PDF export — with every staff member added in the HR module immediately available in the Scheduler by discipline and floor.
Here is what happens when you request a demo:
- A member of the LTC Apps team reaches out within one business day to schedule a call
- We run a 30-minute live walkthrough of the Scheduler module using your facility’s discipline and floor configuration as context
- You get pricing specific to your facility size and module selection
Most facilities have a clear picture of fit and pricing within one week of reaching out.
Common questions before booking:
No long implementation timelines — most facilities are live on their first module within two to four weeks. No minimum facility size — LTC Apps works with single-facility operators and regional groups. If you are mid-contract with another vendor, a parallel evaluation now means you are ready to switch at contract end without making a rushed decision under time pressure.
Frequently Asked Questions
A nursing home staff scheduling template should include separate row groupings for each of the five SNF disciplines — CNA, Nursing, Housekeeping, Laundry, and Front Desk — organized across a 14-day pay period grid rather than a calendar week. Each row needs shift code entries per day, a floor assignment column, and a running hours total to flag overtime risk before a shift is assigned. The template should also include a status field — Pending, Active, Closed — to document when the schedule was published, which matters for both PBJ compliance and survey readiness.
Set up a 14-column grid labeled Day 1 through Day 14, with a date header row showing the specific pay period dates. Organize staff rows by discipline group — not alphabetically — and add shift codes (D, E, N, O) for each day. Include a Floor column after each staff name and a conditional formatting hours column that turns orange at 36 hours and red at 40. Download the template in this post to start with the structure already built.
A master schedule template is a 14-day repeating pattern — not tied to specific calendar dates — that represents the facility’s standard coverage model. It holds stable information: staff names, disciplines, standard floor assignments, and typical shift patterns. At the start of each pay period, duplicate the master tab, update the date headers, adjust for changes, and mark it Active when ready to distribute. This eliminates the rebuild-from-scratch cycle and reduces each new pay period setup from three to five hours to approximately 20 minutes.
CMS requires quarterly PBJ submission of actual staff hours organized by discipline type, due 45 days after each quarter ends. (Source: CMS Payroll-Based Journal Final Rule) A template that uses discipline-level row organization, a published Active status with timestamp, and archived pay period records provides the documentation foundation for accurate PBJ submission. A disorganized template produces inaccurate PBJ data, which flows directly into an inaccurate Five Star staffing rating visible to families on Care Compare. (Source: CMS Five Star Technical Users’ Guide)
Hospital scheduling is built for unit assignments and 12-hour clinical shifts across two or three staff types. SNF scheduling requires five-discipline coverage across multiple floors, 14-day pay period cycles, CNA-to-resident ratio documentation by floor and shift, and PBJ compliance records. A tool built for SNF scheduling starts from a structurally different premise than anything built for a hospital, a restaurant, or a retail store — and using the wrong structure produces compliance gaps a better-looking spreadsheet cannot fix.
The requirement varies by state. In Illinois, the standard for skilled care residents is 3.8 hours per resident day. (Source: Illinois Administrative Code Title 77, Section 300.1230) For a 30-resident floor, that works out to approximately five CNAs minimum on a standard day shift. The federal minimum staffing rule was rescinded effective February 2, 2026, meaning state requirements now carry full enforcement weight. (Source: Federal Register, December 3, 2025) See Illinois CNA staffing ratio requirements in detail for the full calculation.
A schedule built on a solid template is not just easier to manage — it is the difference between producing staffing documentation in two minutes and spending an hour reconstructing records while a surveyor waits.
Ready to Stop Rebuilding Your Schedule From Scratch Every Two Weeks?
LTC Apps Scheduler gives SNFs a 14-day scheduling grid for all five disciplines — with pay period management, per-floor coverage tracking, a master template, and PDF, Excel, or Fillable PDF export. Built specifically for skilled nursing facilities. No enterprise implementation required.
