2027 Nurse Shift & Pay Planner | Shift Log, Overtime, Night & Weekend Differential, Paycheck Check, CE Hours | Excel & Google Sheets

Log every shift, see what it should pay, and catch the paycheck that's missing your differentials.

What it does:

- 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.

What 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.

Honest notes:

- 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.

You might also like

- 2027 Paycheck Budget: plan each paycheck.

- Sinking Funds tracker: save for license renewal, scrubs and shoes.