Skip to content
The title slide and first slides of the Household Employee Tax Tracker template

Household Employee Tax Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Families who employ a nanny, caregiver or housekeeper use this household employee tax tracker to keep payroll records tidy. The Pay log has one row per payday with hours, hourly rate, the amounts withheld and the employer taxes, and it works out gross pay and take-home pay. The Employees tab tracks the W-4 and I-9 paperwork. The Year end tasks tab lists what to finish after the last payday. The Dashboard totals wages, withholding and the full cost of employing each person.

This sheet records the figures you take from your payroll worksheet or payroll service; it does not calculate any tax. Enter hours the day you pay, and keep signed time records beside the file. At year end, hand the Pay log totals to your tax professional with the due dates, and check off every task when it is done.

Useful for

  • Track pay and withholding for a nanny or caregiver
  • Keep paperwork for each household worker in one list
  • Work through year-end wage statements and filings on time

What's included

  • 5 tabs: Dashboard, Pay log, Employees, Year end tasks, How to use
  • Dashboard: a dashboard with 6 summary figures
  • Pay log: a table
  • Employees: a table
  • Year end tasks: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Pay log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What records should I keep for a household employee?

Keep signed forms, hours worked, pay dates, gross pay, amounts withheld and employer taxes paid. This tracker gathers the figures together, and you keep time sheets and tax forms beside it.

Does this sheet calculate payroll taxes?

No. It records the amounts you enter from a payroll worksheet or service and adds them up. Rates and rules change, so take the figures from current IRS guidance or a payroll provider.

Which tasks come up when the year closes?

Add up wages and withholding for each worker, give them their wage statement, and file the required forms by their due dates. The Year end tasks tab holds a starting list; confirm the dates with a tax professional.

  • #tax-tracker
  • #household-employee-tax-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…