🎉 Free 14-day trial — No credit card required.   Start your free trial →
🗓️
Free Resource Download Updated: October 2026 (UK Rates & Regulations)

Free Staff Rota Template & Care Home Planner (Excel, PDF & Online Builder)

Free staff rota template for UK care homes, supported living, and care agencies: 4-week rolling rota with automated hour totalizers, statutory rest conflict alerts, and print-ready noticeboard formats.

Read Guide

What’s Included in This Resource

  • ✓ 4-week rolling rota view with automatic hour totalizers and shift codes
  • ✓ Built-in 11-hour daily rest window conflict formulas (Working Time Regulations)
  • ✓ Pre-configured for 12-hour day/night shifts, 4-on 4-off rotations, and sleep-ins
  • ✓ Print-ready A4/A3 layouts for staff room noticeboards
  • ✓ Companion access to the free interactive online rota generator

How to Use the Free Staff Rota Template

This Excel workbook provides a complete 4-week rolling schedule designed for UK care homes, supported living houses, and healthcare agencies. It tracks safe staffing ratios, calculates total weekly hours automatically, and enforces legal rest breaks under Regulation 18.

  1. 1

    Configure Staff Roles & Shift Types

    Input permanent and bank carers, contracted weekly hours, and standard shift codes (Early: 07:00–15:00, Late: 14:30–22:00, Long Day: 07:30–19:30, Waking Night: 19:30–07:30, Sleep-in: 22:00–08:00).

  2. 2

    Allocate Shift Lines Across 4 Weeks

    Assign carers to 4-week rotating shift patterns to guarantee rota predictability, fair weekend distribution, and continuity of care for residents.

  3. 3

    Automated Rest Window Verification

    Built-in formulas flag a compliance alert if a carer is scheduled with less than the statutory 11-hour rest window between shifts under the Working Time Regulations.

  4. 4

    Review Total Hours & Overtime Budget

    Summary dashboard tracks cumulative hours per carer and total hours per shift, preventing unbudgeted overtime and highlighting vacancy gaps.

  5. 5

    Or Build Your Rota Online in Your Browser

    Prefer not to use Excel? Build and customize a visual 7-day schedule with our free interactive online rota builder at /tools/rota-builder and download an instant PDF.

Staffing Ratio Worked Example (24-Bed Care Home)

Morning Shift (07:00–14:30) with 1 Senior Carer + 3 Healthcare Assistants:

Residents on Duty 24 residents
High Dependency (2:1 transfer) 6 residents
Medium Dependency (1:1 assist) 12 residents
Low Dependency (supervision) 6 residents
Required Care Staff Hours 30.0 hours
Scheduled Carer Hours (4 staff × 7.5h) 30.0 hours (100% safe staffing)

Direct evidence satisfying CQC Regulation 18 safe staffing requirements.

Need automated workforce management?

AsanWork automates everything in this resource directly inside our cloud platform.

Start Free Trial →

Get Instant Access

Enter your details to download Free Staff Rota Template & Care Home Planner (Excel, PDF & Online Builder) instantly.

We respect your privacy. No spam guaranteed.

Frequently Asked Questions

Yes. The template is pre-configured for residential care homes, supported living, and care agency block shifts. For complex 15-minute community visit runs with GPS route optimization, we recommend using AsanWork's dedicated care scheduling software.
The template uses dynamic =COUNTIF() and =SUMPRODUCT() formulas matching shift codes (D, E, L, N, SL) with preset shift durations, automatically subtracting unpaid meal breaks.
Formula checks compare the end time of shift N with the start time of shift N+1 for each carer. If the rest window is under 11 hours (such as a 22:00 finish followed by a 07:00 start), the cell highlights red with a compliance warning.
Yes. We offer an Interactive Care Staff Rota Builder (/tools/rota-builder) that runs directly in your web browser, allowing you to assign shifts and export a print-ready A4 PDF schedule instantly.
Yes. The template is pre-formatted with print-ready margins on A3 and A4 paper for easy display in staff rooms.