Shift Worker Overtime Tracker Spreadsheet — Paycheck Verifier Excel for 12-Hour Shifts, Night Differential & Holiday Pay

Your paycheck is wrong more often than you think. This spreadsheet proves it — in about 60 seconds.

The SHIFT WORKER OVERTIME + PAYCHECK VERIFIER was built for 12-hour rotating shifts, not 9-to-5 timesheets. Log your shifts, type in what your paystub says, and the verifier does the math your payroll department hopes you never do.

THE HERO FEATURE: the Paycheck Verifier tab computes your expected gross — regular hours, overtime, night differential, weekend pay, holiday multiplier — and compares it to your actual paystub gross. If the difference is more than $1, the variance cell turns RED with a "check this" flag. No more guessing. No more "it probably evens out."

WHAT'S INSIDE (instant download):

- The Verifier Workbook (Excel — also works in Google Sheets, just upload the file):

- Start Here — plain-English setup, where to type, what the colors mean

- Shift Log — one log for the whole year (2,000 rows of formulas): date, day/night, clock-in/out, regular hrs, OT hrs, night-diff hrs, weekend hrs, holiday flag

- Pay Setup — your base rate, OT multiplier (default 1.5x), night-diff $/hr, weekend-diff $/hr, holiday multiplier (default 2.0x), weekly/biweekly pay periods

- Paycheck Verifier — expected vs. actual gross, RED variance flag over $1, print-ready on one page (take it to the foreman)

- Dashboard — total hours, total OT, estimated gross per month at a glance

- PTO & Sick — accrued / used / remaining with a cap warning

- Quickstart Guide (PDF) — "Log your first shift in 60 seconds," with worked overtime-math examples.

Night shifts that cross midnight are handled correctly — 6 PM to 6 AM counts as the 11.95 hours it actually is, not a negative number and not zero.

Built by a night-shift process controller who's been shorted before. Five minutes a week of logging buys you the receipt for every hour you ever work.

Pairs with our Shift Worker's Planner Pack — the planner tracks your schedule, this tracks your money.