2027 Nurse Shift & Pay Planner
Log every shift, see what it should pay, and catch the paycheck that's missing your differentials or overtime.
Work more than one job? Get all 5 trackers (nurse, server & bartender, hairstylist, personal trainer, dog walker) in the 2027 Work & Pay Trackers Bundle – $19 (save $16).
What's inside (one .xlsx workbook)
- Shift log: unit, shift type, start and end, unpaid break, charge; overnight shifts work
- Night and weekend differentials and estimated pay per shift
- Weekly overtime hours and premium (40-hour rule by default, editable)
- Paycheck check: enter each paystub's gross and see any gap over $25
- CE and license tracker: hours still needed and days to renewal
- Dashboard by month and year, PTO left and a chart
- Setup tab for your base rate, differentials, overtime rule and PTO accrual
New to tracking? Read how to track nurse shifts, overtime and differentials. See also the paycheck budget and sinking funds tracker.
Works in Excel 2016+, Microsoft 365, Excel for the web, and imports into Google Sheets. Instant digital download, nothing shipped. Example numbers included. Pay is an estimate before taxes and deductions; your contract, union rules and state law decide your real pay. It doesn't connect to any scheduling or payroll system. Made with AI assistance and reviewed before release. Sold through Payhip.
What's inside
- Shift log: date, unit, shift type, start and end, unpaid break, charge. Overnight shifts work. Hours, night and weekend flags and estimated pay calculate.
- Weekly overtime: hours over your weekly limit (40 by default) and the overtime premium, week by week.
- Paycheck check: type each paystub's gross. It shows the planner's estimate and highlights any gap over $25.
- CE & license: log continuing-education hours and see hours still needed and days to renewal (red when under 90 days).
- Dashboard: shifts, hours, night and weekend shifts, overtime and estimated gross for each month and the year, plus PTO left and a chart.
- Setup: your base rate, differentials, overtime rule, PTO accrual, units and shift types.
Good to know
- Numbers in the file are examples.
- Pay is an estimate before taxes and deductions. Your contract, union rules and state law decide your real pay. The paycheck overtime check is approximate.
- It doesn't connect to any scheduling or payroll system; you type your shifts.
- Made with AI assistance and reviewed before release.
Previews
Frequently asked questions
Which apps does it open in?
Excel 2016 or newer (including Microsoft 365 and Excel for the web) and Google Sheets: upload the .xlsx to Google Drive, then open it with Google Sheets. You get one .xlsx file (Excel 2016+, Microsoft 365, Excel for the web; imports into Google Sheets) plus a short how-to. Instant digital download.
What happens after checkout?
Payhip shows your download link right after checkout and emails it to you too. You download a .zip with the .xlsx file(s) and a short how-to. It's an instant digital download; nothing physical ships.
Can I edit it?
Yes. Nothing is locked: rename categories, add rows, change colors and type over the example data.
Does it connect to my bank or send reminders?
No. It's a spreadsheet, not an app: you type in your own numbers and nothing is synced or sent.
Are the numbers in the previews real?
No. Previews and the file use example data only. Delete the example rows and add your own.
Can I get a refund?
It's a digital download, so if something doesn't open or work, message the shop through Payhip (or reply to the Payhip email) and I'll help fix it. Refund requests are handled case by case under Payhip's terms.
Is this financial advice?
No. It's an organizing and planning tool with example numbers, not financial, tax, legal or medical advice.
Works in Google Sheets and Excel · Instant download · Nothing shipped
See all Cedar & Ledger templates
More templates, tools and free printables
Not sure yet? Try a free 2027 printable first. The 2027 Year at a Glance is $0 on Payhip: enter your email at checkout to get the PDF, no payment details needed. Payhip emails you the download link; that's the only email it sends. For tips by email, subscribe separately (free, unsubscribe anytime).