A nanny overtime pay calculator worksheet sounds boring until payday arrives with a disagreement. The nanny counted 47 hours. You counted 43. Nobody kept the same record, and now a simple math question feels personal.
Overtime fights almost never come from bad faith. They come from fuzzy definitions: when the week starts, what counts as hours, and which rate applies after 40. A worksheet settles all three before the hours happen.
Pick a fixed workweek, write down every hour worked including early arrivals and late pickups, and pay hours over 40 in that week at the overtime rate. Run the same calculation twice a month, and keep the worksheet where both sides can see it.
Overtime starts with the workweek, not the day
The workweek is a fixed seven-day period, and it does not move because a schedule did. Pick one: Sunday through Saturday is the usual choice. Write it into the work agreement, and use it for every calculation, even when the nanny works a split week across two pay periods.
Daily hours matter for the schedule, but overtime is weekly math. A 12-hour day does not create overtime by itself if the weekly total stays at 40 or below, unless your state sets a daily threshold. Check your state rules, because a few states do set daily overtime, and the worksheet needs a line for it if yours does.
Fix the week first. The math follows.
The four numbers your worksheet needs
Every pay period, the worksheet needs four numbers, and only four. If a number is missing, the calculation is a guess, and guesses cause arguments.
- Regular hourly rate: the agreed base rate, in writing, before the period starts. Rate changes mid-period need a dated note.
- Total hours in the workweek: every hour worked, including early drop-offs, late pickups, and time the nanny was required to stay.
- Overtime hours: total hours minus 40, per workweek, never averaged across two weeks to hide a heavy week.
- Overtime rate: the rate that applies to overtime hours under your state rules and the work agreement, written on the sheet.
Live-in vs live-out: the one big difference
Live-in and live-out arrangements track hours differently, and the worksheet has to match the arrangement. The table shows where they diverge, so the sheet fits the job instead of fighting it.
| Item | Live-out nanny | Live-in nanny |
|---|---|---|
| Hours counted | Scheduled hours plus extras | Hours actually worked, not time at home |
| Sleep and meals | Not worked time | Only if free from duty and able to leave |
| On-call time | Counts if restricted to the home | Counts if restricted, even overnight |
| Record keeping | Daily log signed weekly | Daily log signed weekly, with sleep noted |
Run the math twice a month
Overtime math done once a month from memory is how errors happen. Run it on a rhythm, and make the worksheet visible to both sides.
- Log hours daily, in the same place, and have the nanny confirm the week total every Friday.
- Split the pay period into workweeks, and total each workweek separately before adding anything up.
- Subtract 40 from each workweek total to find overtime hours, and keep regular hours and overtime hours in separate columns.
- Multiply regular hours by the regular rate and overtime hours by the overtime rate, then add the two lines.
- Compare the result against the previous period. A sudden jump usually means a schedule change, not a math error.
- Pay on the agreed date, attach the worksheet to the pay record, and keep both for at least three years.
The Friday five-minute check
Five minutes. Every Friday. That is the whole routine, and it prevents nearly every overtime argument before it starts. Sit down with the hours log, total the workweek, and compare it against the schedule. If the numbers match, both sides sign the week and move on.
If they do not match, Friday is the time to find out why. An early arrival here, a late pickup there, and the gap is usually obvious. Small gaps stay small when caught weekly. Big gaps grow when found monthly. The check takes five minutes. The argument it prevents takes weeks.
Do it Friday. Not Monday. Monday brings a new week and a fading memory of the old one. A signed weekly log turns payday from a negotiation into a routine, and routines do not argue. Both sides sign. Both sides relax. Friday beats Monday. Memory fades fast. Check weekly, pay fairly, and keep the peace.
Put it in writing before the next pay period
The worksheet works best when it sits next to a written agreement that names the workweek, the rates, and the overtime rules. If your agreement is silent on overtime, fix that before the next pay period, not during an argument about one.
This is general information, not legal advice. Overtime rules vary by state and by live-in status, so confirm the thresholds and record-keeping rules that apply where you live.
I turned this into a free printable nanny overtime pay calculator worksheet — get the free worksheet. The full 56-page nanny kit adds 5 Excel workbook sheets and 10 annotated agreement sections, so the math and the contract finally agree.
How is nanny overtime pay calculated?
Total the hours worked in each fixed seven-day workweek, subtract 40 to find overtime hours, and pay those hours at the overtime rate set by your state rules and work agreement. Keep regular and overtime hours in separate columns, and never average two weeks together to hide a heavy week. Run the same calculation every pay period.
Does a nanny get overtime for working more than 8 hours in a day?
Usually overtime is weekly, not daily: a long day alone does not create overtime if the weekly total stays at 40 or below. A few states do set daily overtime thresholds, so check your state rules before assuming. Your worksheet should include a daily-overtime line if your state requires one, and note it in the work agreement.
Do live-in nannies get overtime pay?
Yes, live-in nannies can earn overtime, but only hours actually worked count, not time spent at home off duty. Sleep time and meal breaks generally do not count if the nanny is free from duty and able to leave. Keep a daily log that separates worked hours from off-duty time, and have both sides confirm it weekly.
What records should I keep for nanny pay?
Keep the daily hours log, the weekly totals, the overtime calculation worksheet, and the pay record for each period, for at least three years. Attach the worksheet to each pay record so the math is visible. Good records end most pay disagreements before they start, and they are required if a wage question ever escalates.