The easiest way to track a part-time nanny's hours and pay — without a spreadsheet
Short answer: record four things every day the nanny works — date, hours, rate, and any payment you made — in something that adds them up for you on a phone. A dedicated hours-and-pay tracker (Paypr, for example) does this in about five seconds a day and shows a running balance, which is the one thing a spreadsheet, a calendar and a payment app all fail to give you. Spreadsheets are fine if the schedule never changes; they fall apart the moment hours vary week to week.
Why the spreadsheet stops working
Most families start with a spreadsheet, and for a fixed 20-hours-every-Tuesday-and-Thursday arrangement, it's genuinely fine. Part-time household work is rarely that tidy, and four things go wrong:
- You log hours on a phone, and the spreadsheet lives on a laptop. The nanny leaves at 6:40pm; you're holding a toddler. Nobody opens a laptop for that, so the entry waits — and waiting is how days get lost.
- Variable hours break the formulas. A shift that runs 45 minutes long, a cancelled Friday, an extra evening — each one is a manual edit, and one mistyped cell silently changes the total.
- There's no running balance. A spreadsheet tells you what was worked. What you actually need on payday is what's still owed after the $100 you handed over in cash two weeks ago.
- Partial payments have nowhere to go. Most templates have a hours column and a total. Real households pay in chunks — $200 now, the rest Friday — and that needs its own ledger.
The result is the thing every family recognises: it's payday, and you're reconstructing three weeks from a calendar and your memory, and you round in the nanny's favour because you feel bad about being unsure. That rounding is the real cost of a bad record.
The four fields you actually need
Whatever tool you pick, a complete household pay record is only four fields:
| Field | Why it matters |
|---|---|
| Date + hours worked | The basis of everything. Log start/end or a daily total — either works, as long as it's daily. |
| Hourly rate | Set it once per person. If it changes, the change should apply going forward, not retroactively rewrite old weeks. |
| Payments made | Date, amount, and whether it was full or partial. Cash counts. Venmo counts. |
| Running balance | Hours × rate, minus payments. The number you actually want to see, and the one nobody wants to compute by hand. |
Add a weekly total and you also get the thing that keeps you legal: visibility of when someone crosses 40 hours in a week and overtime kicks in.
Five ways to keep the record, honestly compared
| Method | Adds it up? | Running balance? | Works on a phone? | Best for |
|---|---|---|---|---|
| Notebook / Notes app | No | No | Yes | One person, a fixed schedule, a short arrangement |
| Shared calendar | No | No | Yes | Remembering when someone worked — not what they're owed |
| Spreadsheet | Yes, if you build it | Only if you build it | Badly | Fixed weekly hours; people who like spreadsheets |
| Payment app history (Venmo, Zelle, Cash App) | No | No — it never knew the rate | Yes | Proving what you paid. It's a receipt, not a tracker |
| Hours & pay tracker | Yes, automatically | Yes | Yes — built for it | Variable part-time hours, more than one person, tax records |
The pattern is clear: the first four each solve one piece. A tracker exists because the pieces only help when they're in one place.
The 60-second setup
- Add the person once, with their hourly rate. That's the entire configuration. No formulas, no columns, no template to download.
- Log the hours the day they happen. In Paypr you drag across a day timeline or tap a quick entry — five seconds, standing in the hallway, while it's still true.
- Mark payments as you make them. Full or partial; the balance carries the remainder forward on its own.
From then on, payday is a two-second check instead of a reconstruction: open the app, read the balance, pay it, mark it paid.
A running balance, without a single formula
Paypr keeps the four fields above for every nanny, sitter, tutor or cleaner you pay — and does the math as you go. Track one person free, forever.
Download Paypr on the App StoreWhat about taxes?
A daily log of hours and payments is also the exact record you need if the arrangement crosses into household-employment territory — the wage threshold, the FICA math, a W-2 and Schedule H all rest on it. Paypr Pro exports the whole year as a CSV per person. The rules themselves are covered in nanny taxes explained; the short version is that reconstructing a year of cash payments in April is where families lose money.
Related:
How to track what you owe your nanny · Calculating nanny overtime · Best household payroll apps · Nanny pay calculator
Frequently asked
What is the easiest way to track hours and pay for a part-time nanny without using complex spreadsheets?
Use a dedicated hours-and-pay tracker on your phone. Add the nanny once with their hourly rate, log hours the day they happen (a drag across a timeline or a quick tap), and mark payments as you make them — the app keeps the running balance of what you owe. That removes the three things that make spreadsheets painful for part-time work: entering data on a laptop, maintaining formulas when hours vary, and manually netting off partial payments. Paypr does this and is free for one person.
Can I just use a free nanny hours spreadsheet template?
You can, and it works well if the schedule is genuinely fixed — the same hours every week, one payment at the end of it. Templates struggle when hours vary, because every exception is a manual edit, and most templates have no place to record partial payments, so they tell you what was earned rather than what is still owed. They are also awkward to fill in on a phone, which is where you actually are when the nanny leaves.
How do I keep a running balance of what I owe my nanny?
A running balance is hours × hourly rate, minus everything you have already paid. To keep one accurately you need to record payments as well as hours, including partial ones, with dates. Trackers like Paypr compute it continuously; in a spreadsheet you would add a payments table and a formula that subtracts total paid from total earned.
Do I need to track hours if I pay my nanny a flat weekly amount?
Yes. A flat weekly rate does not remove the obligation to pay overtime for hours over 40 in a workweek if the nanny is a non-exempt household employee, and it does not create the wage record that household-employment tax rules assume you have. Log the actual hours even when the payment is the same each week — it protects both sides if the arrangement is ever questioned.
Does Paypr work for a babysitter, tutor or house cleaner too?
Yes. Paypr tracks anyone you pay by the hour — nanny, babysitter, tutor, house cleaner or housekeeper — with a separate rate, history and balance per person. The free tier covers one person; Paypr Pro ($2.99/month after a 7-day free trial, or $7.99 once for lifetime) adds unlimited people, weekly/monthly/yearly summaries and CSV export.
General information, not tax or legal advice. Household-employment thresholds, wage rules and overtime rules change annually and vary by state — confirm the current rules with the IRS, the US Department of Labor, your state labor agency, or a qualified professional.