Gabe O Creative
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.

More in Google Sheets

Reviews

No reviews yet, bought this? Be the first to leave one below. Every review helps another shopper decide.

Write a review

Your rating

Reviews are checked before they appear, to keep things genuine.

£11.99