Google Sheets
Nurse Shift Planner Google Sheets, Rota & Hours Tracker with Pay Estimator, Patient Board Brain Sheet & SBAR Handover Template
🩺 Shift work eats your admin time twice — once planning the rota, once trying to remember what happened on it.
This puts the whole lot in one place: your rota with days-to-go countdowns, hours and nights totalled week by week, estimated pay with unsocial and overtime uplifts, a patient board for the shift itself, and an SBAR handover you fill in as you go instead of at 19:25.
📊 WHAT'S INSIDE (6 tabs)
• Dashboard — hours this month, shifts, nights, estimated pay, next shift, overtime, busiest unit and health gauges
• Shift Planner — date, shift type, unit, hours, overtime, swap flag and a live countdown to your next one
• Patient Board — bed, initials, admitted for, key tasks, obs due, meds due, tick-off column
• Handover — SBAR boxes (Situation, Background, Assessment, Recommendation)
• Hours & Pay — week by week hours, nights, overtime, estimated pay and hours vs contracted
• Start Here — set up in five minutes
⚙️ HOW IT WORKS
1. Open your link and click "Make a copy"
2. Put your hourly rate, unsocial uplift and contracted hours in — once
3. Log each shift; hours, nights, overtime and pay all calculate themselves
4. Work the board through the shift and fill the handover as you go
🏷️ PERFECT FOR
• Ward, community and agency nurses on rotating shifts
• Student nurses and NQNs building the habit early
• Anyone juggling bank shifts across more than one unit
⚠️ CONFIDENTIALITY — the patient board is deliberately built for BED NUMBERS AND INITIALS ONLY. Never enter full names, dates of birth, NHS or patient numbers, or clinical records into a personal cloud file. Follow your employer's information-governance policy.
💻 FORMAT & ACCESS
• Made for Google Sheets — works on phone, tablet & desktop
• Nothing to install, no software fees — just a free Google account
• Delivered as a private "Make a Copy" link — one click and it's yours
• Your copy is 100% private and fully editable, forever
⚡ INSTANT ACCESS — Your template link is available immediately after purchase. No physical item will be shipped.
📌 A personal organisation aid only. It is not a clinical record and gives no clinical guidance. Pay figures are estimates, not payroll. This is a digital product; all sales are final.
Helpful guides
- Tracking Nurse Shifts and Pay: Nights, Overtime and What You Are OwedMost nurses find out their pay was wrong two months later, or never. Ten seconds of logging per shift is what turns a suspicion into something you can query.
- Med Surg Brain Sheet: What to Write Down on a Busy ShiftA brain sheet is the page that holds your shift together. Here is what actually belongs on a med surg one, how to lay it out for a full bay, and how to keep it safe.
More in Google Sheets
Quick viewGoogle Sheets Mega Bundle — The Complete Collection, All 25 Dashboards: Budget, Wedding, Business, ADHD, Renovation & More (£338 Value)
Google Sheets
£49.99
Quick viewLife OS — The Master Dashboard, Google Sheets Life Planner Spreadsheet: Today’s Top 3, Goals, Habits, Money & Weekly Review in One Live Dashboard
Google Sheets
£19.99
Quick viewHomeschool OS — Google Sheets Homeschool Planner Spreadsheet: Attendance Tracker, Lesson Planner, Progress & Curriculum Budget, Up to 4 Children
Google Sheets
£14.99
Quick viewCollege Student OS — Google Sheets Student Planner Spreadsheet: Assignment Tracker, Weighted Grade Calculator & Student Budget, Semester Dashboard
Google Sheets
£12.99
Quick viewNew Baby Budget — Google Sheets First-Year Planner Spreadsheet: Baby Checklist with Costs, Maternity Leave Cash Flow & First-Year Expense Tracker
Google Sheets
£12.99
Reviews
No reviews yet, bought this? Be the first to leave one below. Every review helps another shopper decide.
Write a review
£11.99