Skip to content
The title slide and first slides of the Home Daycare Expense Tracker template

Home Daycare Expense Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

Home daycare providers use this workbook to keep the costs of caring for children apart from ordinary household spending. The Food and supplies tab records each grocery, craft and safety purchase. The Time-space share tab multiplies the share of the home used for care by the share of hours it was used. The Home costs tab applies that share to your yearly mortgage interest, utilities and repairs, and the Dashboard totals the result.

Start with the Time-space share tab, since every home cost depends on it. Enter your own area and hours; the sheet holds no fixed rates or limits. Record shopping trips the day you make them and split mixed trips at the daycare share only. Keep your attendance sheets with the receipts, and have a tax professional look over the totals before you file.

Useful for

  • Separate daycare groceries from family groceries
  • Work out the share of home costs used for care
  • Hand a clean list of totals to a tax professional

What's included

  • 5 tabs: Dashboard, Food and supplies, Home costs, Time-space share, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Food and supplies: a table
  • Home costs: a table
  • Time-space share: a ready-to-fill form
  • 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 Food and supplies 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 is the time-space percentage for a home daycare?

It is the share of your home used regularly for care, multiplied by the share of the year's hours that space was used. The Time-space share tab does that arithmetic from your own numbers. Ask a tax professional or check IRS guidance on how the method applies to you.

What records should a home daycare keep?

Keep receipts for food and supplies, bills for home costs, a floor plan with measurements, and attendance sheets showing the hours of care. This workbook holds the figures; store the paper or scanned copies beside it.

Do I count food for my own children?

Track food bought for the kids you look after. Items used by your own family are personal costs, so split a mixed grocery trip and enter only the daycare part. Check current IRS or CRA guidance on how meals are treated.

  • #tax-tracker
  • #home-daycare-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…