Home Daycare Spreadsheet, Time-Space Percentage Tracker, Family Child Care Business, Attendance & Parent Statement, Google Sheets Excel

Keep a home daycare's money and records in one place: tuition, payments from parents and agencies, daily sign-in and sign-out, expenses and the time-space percentage for shared home costs, with a printable year-end statement for each family.
WHO IT'S FOR
Licensed or registered family child care and in-home daycare providers caring for up to 40 children.
WHAT IT DOES
• Tuition plans (weekly, monthly or daily) with sibling discounts and custom rates; tuition charges fill in from each child's rate
• Payments by child from parents, subsidy agencies or dependent-care FSAs, with family balances
• Daily sign-in and sign-out log (3,000 rows) with hours and late-pickup minutes after your closing time, plus a suggested late fee
• Expense log (1,000 rows) where each category is Business 100%, Food, Shared home or Personal
• Time-space worksheet: rooms and square feet, regular and exclusive use, business hours logged, and the combined percentage applied to shared home expenses
• Monthly P&L on a cash basis, with care hours and children attending
• One-page year-end payment statement for each family, split by who paid
• Dashboard with received, billed, owed, net, time-space %, alerts and charts
TABS
Start Here · Dashboard · Settings · Families (up to 40) · Attendance (3,000 rows) · Charges · Payments · Expenses · Hours Log · Time-Space · Monthly P&L · Family Statement
WHAT YOU GET
• Instant digital download — no physical item is shipped.
• Excel workbook (.xlsx) plus a Buyer Access PDF with your Google Sheets copy link.
• Works in Microsoft Excel 2010 or later (Windows and Mac), Excel for the web, and Google Sheets (free Google account). No macros, add-ins or subscriptions.
• Fictional sample data is included so you can see how it works. Clear it when you're ready to start.
GOOD TO KNOW
• Formula cells are protected so they can't be overwritten by accident (no password). Light-tinted cells are for your entries, and dropdowns keep entries consistent.
• The time-space worksheet follows the general approach described in IRS Publication 587 to organize your records. Your tax preparer decides what you can deduct and how.
• Family statements show the payments you recorded. They are not a tax form; parents should ask their own preparer how to use them.
• Licensing, ratio and subsidy rules vary by state.
• Because this is a digital download, returns aren't accepted. If something doesn't work, message the shop and we'll help.
AI disclosure: This listing was made with the help of AI tools. AI helped draft the spreadsheet formulas, the listing text and the layout of the preview images. Every formula was then recalculated and checked for errors before listing, and the preview images show the real workbook's sample numbers.
Please note: This is a record-keeping template. It is not financial, tax, accounting, legal or HR advice, and it does not guarantee compliance with any law, regulation or rule. Check important results with a qualified professional.
Original design by SystemSheets. For personal or internal business use; please don't resell or share the file.