Skip to content
The title slide and first slides of the Child Care Expense Tracker template

Child Care Expense Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Parents who pay for daycare, camps, after-school care or a nanny use this child care expense tracker to have every figure ready when the tax forms ask for them. The Providers tab stores each provider's address and whether you have their tax ID. The Payments tab logs what was paid, for which child, and how much a workplace plan reimbursed. The Dashboard totals the amounts per child and per provider.

Chase missing tax IDs in the spring, not at the filing deadline. The red Tax ID status shows who still owes you the number. Put payments in as they happen, then compare your yearly total with each provider's year-end statement. If the two disagree, find the gap while the receipts are fresh.

Useful for

  • Gather provider names and tax IDs before preparing a return
  • Total care costs for each child across daycare and summer camp
  • Compare your records with each provider's year-end statement

What's included

  • 4 tabs: Dashboard, Providers, Payments, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Providers: a table
  • Payments: a table
  • 2 charts 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 Providers 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 information do I need from a child care provider?

Usually the provider's name, address and tax identification number or Social Security number, plus the amount you paid. Ask for it early. This sheet tracks who has sent theirs.

How do I track child care costs paid through an employer plan?

Enter the full payment in Amount paid and the part the plan covered in Reimbursed by plan. The Paid by you column does the subtraction, and the Dashboard totals both.

Do summer camp costs count?

Rules differ by program type and by year, so the sheet records every cost and leaves the decision to you. Before you claim a payment, read current IRS guidance or talk to a tax professional.

  • #tax-tracker
  • #child-care-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…