Nanny Hours and Pay Tracker Spreadsheet, Excel and Google Sheets, Babysitter Timesheet, Overtime Calculator, PTO and Mileage Log

Nanny Hours and Pay Tracker Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Track your nanny's or babysitter's hours, overtime, pay, time off and reimbursements in one place, and keep clean records for your family. Perfect for families who employ a nanny or nanny share. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 15 tabs with a clickable Start Here page • Dashboard: 16 KPI tiles, this week by caregiver, a heads-up list, the latest shifts, the latest notes from the sitter and 4 charts • Caregivers: up to 6 nannies or sitters with regular, overtime, weekend and holiday rates (or automatic rates), PTO and sick days per year, and the balance owed to each • Timesheet: 500 shift rows with start and end time, unpaid breaks and overnight shifts; hours, weekday / weekend / paid holiday, overtime past your weekly limit and pay calculate for you • Weekly Pay calculator: pick a caregiver and a week to see regular, weekend, holiday and overtime pay, paid time off and bonuses, expenses to pay back, an optional withholding amount you enter yourself, and what's still to pay, plus the last 12 weeks • Payments: 200 rows, checked against what was earned that week • Mileage & Expenses: 300 rows using your mileage rate, with receipt and paid-back tracking • Time Off: 200 rows of PTO, sick days, paid holidays and unpaid days, with balances and the next paid holidays • Schedule: a regular weekly schedule with planned hours and estimated weekly, monthly and yearly cost • Calendar: any month, showing who worked, hours, paid holidays, days off and planned hours • Kids Daily Log: 400 rows for meals, naps, mood, activities and notes for parents • Family Info: kids' allergies, medications and bedtimes, emergency contacts and house rules for a new sitter • Annual Summary: year totals by caregiver and by month for your records • Cost Planner: compare 3 schedules side by side, plus a raise calculator • 15 charts in total ★ PERFECT FOR ★ ✓ Families who employ a nanny or nanny share ✓ Parents paying a regular babysitter or date-night sitter ✓ Keeping clear records of hours and payments ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download the files right after purchase. 2. On Setup, choose your pay week, overtime rule, mileage rate and paid holidays, then add your caregivers and their rates. 3. Log each shift with a start and end time, plus time off, mileage and expenses. 4. Open Weekly Pay each payday, record what you paid, and check the Dashboard and Annual Summary. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★