A nursing home schedule template that holds up

A useful nursing home schedule template does more than put names on day and night rows. It shows whether each unit has the right role coverage, what a call-out changed, and how scheduled hours turn into reportable hours.

What the template needs to capture

Long-term care facilities subject to 42 CFR Part 483 Subpart B must electronically submit direct-care staffing information through CMS's Payroll-Based Journal, including agency and contract staff.Source: CMS
PBJ hours are reported as paid-to-work hours by calendar day, so a night shift is split at midnight rather than reported as one block on its start date.Source: CMS
CMS requires a 30-minute meal-break deduction from each full shift paid to work, which makes a 12-hour shift 11.5 PBJ hours when the full shift is paid to work.Source: CMS
PBJ separates nursing job categories such as RN, LPN/LVN, CNA, nurse aide in training, and medication aide or technician instead of treating all direct-care hours as one pool.Source: CMS

Why a name grid is not enough

Use the template as a control sheet, not a substitute for judgment. One view checks role coverage by unit and shift. Another records changes after publication. A full-looking month can still hide a short night or a replacement that changes overtime exposure.

Label HPRD as an internal target unless counsel or your state agency says otherwise. Federal requirements and state rules are separate questions.

Start with the fields that answer real questions

Make one row for each unit and shift, then attach employee assignments. A facility total is useful later, but it can hide an empty hall.

Field	What it answers	What to record
Date and shift	When is coverage needed?	Date, day or night, start, end
Unit or wing	Where is the person assigned?	Unit, census snapshot, area
Role	What coverage is present?	RN, LPN/LVN, CNA, nurse aide in training, medication aide, or other approved role
Employee and status	Who is working?	Employee ID, employee, agency, contract, float, or PRN
Hours	What is planned and reportable?	Start, end, paid hours, meal deduction, PBJ date split
Change log	What changed after publication?	Call-out time, replacement, approver, reason, change time

Most templates omit the change log. A replacement can change the unit, role mix, overtime exposure, and later reconciliation.

A daily grid you can copy

Here is an illustrative grid for a 60-bed facility with 54 residents on the day shown. The counts are a planning example, not a staffing requirement. Adjust them to your acuity model, state rules, resident needs, and facility policy.

Area	Residents	Shift	RN	LPN/LVN	CNA	Float or relief
North unit	28	Day	1	1	3	1
North unit	28	Night	1	1	2	0
South unit	26	Day	1	1	3	0
South unit	26	Night	1	1	2	0

Now test the grid instead of admiring it. If the South-unit night CNA calls out, change the row to CNA 1 and mark the missing slot before you start calling. If a float CNA takes the assignment, record the float source and the new unit. If nobody accepts, leave the open slot visible. Do not turn an unresolved gap into a green total because the facility still has enough aides somewhere else.

For employee rows, add the actual person, shift, unit, role, and planned paid hours below this summary. That gives the scheduler a fast coverage view while preserving the detail needed for an audit.

Work the HPRD math before you publish

HPRD is reported hours divided by the resident count used for the calculation. Calculate it by role as well as in total. A single total can rise while RN hours fall.

Illustrative day: 54 residents, 4 RN shifts, 4 LPN/LVN shifts, and 10 CNA shifts. If each is a full 12-hour shift paid to work, CMS's rule makes each one 11.5 PBJ hours.

Role	Shifts	PBJ hours per shift	Reported hours	HPRD at 54 residents
RN	4	11.5	46.0	0.85
LPN/LVN	4	11.5	46.0	0.85
CNA	10	11.5	115.0	2.13
Total	18	11.5	207.0	3.83

207 divided by 54 equals 3.83 total HPRD. This is not a legal threshold. It is a check before publication. An 11:00 p.m. to 7:00 a.m. shift also needs a split between two calendar dates. Scheduled hours and PBJ hours are not interchangeable.

Build a call-out workflow into the sheet

A call-out row should force a decision. Use a small status field such as Open, Contacting, Covered, or Escalated, then record the time and person who changed it.

Mark the missing employee and the exact unit, role, and shift.
Check the float or relief list for someone qualified for that assignment.
Check the replacement's hours, rest period, approved availability, and facility overtime policy.
Record the contacts made and the outcome, including a refusal or an agency request.
Recalculate the affected unit, role totals, HPRD view, and employee hours before publishing the change.

Do not use a generic note such as "short staffed". Several state mandatory-overtime laws treat chronic short staffing differently from an unforeseeable emergency, and facility coverage is not uniform across states. Pennsylvania, New Jersey, and New York clearly reach long-term-care settings in the research reviewed here. Washington's coverage depends on the facility and licensing context. Put the state-policy check outside the formula, and have counsel confirm the rule that applies to your facility.

Know when the spreadsheet has reached its limit

A spreadsheet works when one scheduler owns it and the final schedule is checked before release. It fails when copies multiply or the published grid no longer matches hours worked.

Failure mode	Expose this	Response
Unit hidden by facility total	Coverage by unit, role, and shift	Resolve the unit row before release
12-hour shift copied as 12 PBJ hours	Paid-to-work hours and meal deduction	Reconcile before the quarter file
Night shift on the wrong date	Midnight split into two PBJ dates	Review overnight rows separately
Call-out changes the plan silently	Original, replacement, and timestamp	Keep both schedule versions
Employee appears on two units	Conflict check by employee and time	Resolve before publishing

The missing feature is a shared record that recalculates conflicts and coverage when an assignment changes, then keeps the change history with the schedule.

Where schedule templates break

A facility-wide total can show full coverage while one unit has an empty night-shift slot.
Copying 12 scheduled hours into PBJ fields misses CMS's 30-minute meal-break deduction.
An overnight shift recorded only on its start date puts paid hours on the wrong PBJ day.
A call-out without a timestamp or replacement record leaves the published schedule impossible to reconcile.
A spreadsheet can show the planned role mix while hiding an employee overlap or an overtime-policy conflict.

When to move beyond the spreadsheet

Shiftd keeps unit coverage, role hours, HPRD calculations, conflicts, overtime checks, and schedule changes in one record. It handles scheduling and auditability, not payroll or timekeeping.

See Shiftd in action →

Questions schedulers ask

What should a nursing home schedule template include?

Include the date, shift, unit, resident count, role, employee, staffing source, planned hours, open slots, and change log. Keep roles separate.

How do I calculate HPRD from a schedule?

Divide reported hours by the resident count used for the calculation. Keep role totals separate because one total can hide a change in coverage.

Are scheduled hours the same as PBJ hours?

No. PBJ uses paid-to-work hours by calendar day. A full 12-hour shift becomes 11.5 hours after the meal-break deduction, and nights split at midnight.

Should I use a 12-hour shift pattern in a nursing home?

That depends on coverage, availability, fatigue policy, and state law. Show consecutive shifts, overnight assignments, open slots, and overtime exposure first.

Is a spreadsheet enough for a nursing home schedule?

It can work with one owner and a final review. Once copies multiply or call-outs change coverage, use a shared record that recalculates conflicts and preserves changes.