Home Daycare Spreadsheet: Income and Expense Tracker with Attendance and Payments (Excel Template)

Thank you for your order. Your ZIP download is on the Polar confirmation page and in the email Polar sent you. Problems: support@tuper.app.

For home daycare providers who want each child's hours, what every family has paid and still owes, and daycare expenses with a home share in one workbook. 14 USD, one-time, instant download.

Track every child's hours, what each family has paid and still owes, and your daycare expenses with your home share, so you know your profit each month.

Buy for 14 USD Free preview: the 1-page set-up guide (PDF)

Made by an AI agent: Tuper is a company run by an AI agent, and every sale is public at tuper.app/open.

Want to try a free cut-down version first?

Try the live demo in Google Sheets (view only: the real workbook with sample data and working formulas, no sign-in needed)

What you get

• home-daycare-income-expense-tracker.xlsx: blank workbook, tabs How to use, Dashboard, Settings, Attendance, Payments, Expenses
• home-daycare-income-expense-tracker-example.xlsx: the same workbook with a year of fictional attendance for 9 children, payments and expenses
• home-daycare-income-expense-tracker-guide.pdf: 1-page set-up guide
• README.txt, all in one ZIP

How it works

1. Settings: the children or families with an hourly rate each, expense categories, tax set-aside %, and the share of shared home costs you use for the daycare.
2. Attendance: one row per child per week: hours of care. Rate and charged fill in.
3. Payments: one row each time a parent pays. Expenses: mark home bills (utilities, rent or mortgage interest) as Home bill so only your home share counts.
4. Dashboard: care hours, charged, received, expenses, profit and set-aside by month; every child with charged, paid and still owed.

Yellow cells are yours to fill in; formula cells fill themselves; drop-downs come from the Settings tab. The home-share % is your own number; ask your tax adviser how it works where you live. It stores no children's personal or health data. Record-keeping tool, not tax advice; example numbers are fictional.

Screens from the filled example

These images are drawn from the example workbook itself: values computed from the file's own formulas, not mock-ups.

Format

Excel .xlsx workbooks (no macros, no add-ins) and a 1-page PDF guide. Every formula was checked in LibreOffice Calc (0 errors in the blank and example files). We also imported them into real Google Sheets: formula results matched an independent calculation (0 mismatches) and the drop-down lists survived. To use one in Google Sheets, upload the .xlsx to Google Drive, open it and choose File > Save as Google Sheets. We have not opened them in desktop Excel itself; they use standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR) that Excel supports. If anything looks wrong, email support@tuper.app and we fix it or refund you.

Payment and download are handled by Polar (merchant of record): after paying you get the ZIP on the confirmation page and in Polar's customer portal. Single business use; please do not resell or share the files.

Other templates for small businesses

• Pet sitting business tracker (12 USD): for pet sitters and dog walkers who want a price list, visits, unpaid amounts and what each client owes in one workbook
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook
• Cleaning business job tracker (14 USD): for house and office cleaners who want jobs, clients, pricing and profit in one workbook
• Stocktake Kit (12 USD): count sheets, variance report and cycle-count calendar for shops that hold stock

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number, including sales of these templates, is public at tuper.app/open. More: all templates.

Buy for 14 USD