Daycare Spreadsheet – Tuition Tracker & Tax Statements

Name: Daycare Tuition Tracker Spreadsheet
Brand: Sorted Templates
SKU: ST-0046
Price: 7.00 USD
Availability: InStock

Overview

Running a family child care business means keeping books as well as caring for kids. Log each payment as it comes in and this spreadsheet keeps every family's balance current, flags late payments and totals your income, expenses and profit month by month.

At tax time, pick a family and their year-end statement for the Child & Dependent Care Credit fills itself in. Home expenses are multiplied by your time-space percentage, which the sheet helps you estimate from your hours and square footage. It's built for home and family child care providers.

Balances at a glance
Each family's charges, payments and amount owed, with late payments flagged.
Statements in seconds
Choose a family and their year-end tuition statement is filled in.
Time-space % built in
Estimate the business share of your home from your hours and square feet.
Meal counts too
Record CACFP breakfasts, snacks, lunches and suppers for each day.

What's inside

Families
Each child, parent, rate and balance owed
Tuition ledger
Every charge and payment, with balances and late-payment flags
Attendance
Daily grid marked present, absent, holiday or closed
Expenses
Sorted by tax category, with home expenses multiplied by your time-space %
Time-space %
Works out the business share of your home from hours and square feet
CACFP meal counts
Breakfasts, snacks, lunches and suppers each day
Year-end tax statements
Pick a family and their Child & Dependent Care Credit statement fills in
Dashboard
Income, deductible expenses, profit, balances owed and late payments by month
Example rows
Sample entries that show how each tab works

How it works

1
Buy on Etsy, then download START-HERE.pdf from your Etsy Purchases page.
2
Open your Google Sheets link from the PDF (or the Excel file) and add your daycare details and families.
3
Log payments as they arrive. Statements and totals update on their own.

Good to know

Digital download: nothing is shipped
For use in your own child care business: please don't share or resell the templates
Not tax advice: check with a tax professional for your own return
Child care licensing rules differ by state: check your state's requirements and compare every policy with them

Questions

How do I make year-end tuition statements for daycare parents?

Pick a family on the year-end statement tab and it fills in their total for the year, ready to print or send for the Child & Dependent Care Credit.

What is the time-space percentage?

It's an estimate of how much of your home is used for the business, based on the hours you care for children and the square feet you use. The spreadsheet works it out and applies it to your home expenses. Confirm the figure with a tax professional.

Does it track CACFP meals?

Yes. There's a tab for daily counts of breakfasts, snacks, lunches and suppers.

Do I need Excel?

No. It works in free Google Sheets, and it also works in Excel and Numbers.

How it's made: designed by Sorted Templates. We use AI tools to help draft text and lay out pages, and every page is reviewed and edited by us before it's listed. Lifestyle and mockup images may be AI-generated or AI-edited; the page previews show the actual files.