Home Daycare Spreadsheet, Tuition & Attendance Tracker, Parent Year End Payment Totals, Enrollment and Forms Log | Excel Google Sheets
Item highlights
Seller's description
A home daycare spreadsheet that tracks tuition, daily attendance, late pickups and every parent payment, with a year-end payment total for each family. See enrolled children against your capacity, keep a waitlist, and know which enrollment forms still need a date, in Excel or Google Sheets.
WHAT'S INCLUDED
1. Home Daycare Business Kit workbook (Google Sheets + Excel), 9 tabs:
- Start Here and Setup: capacity, default weekly tuition, late fee per minute, and the year for parent totals.
- Dashboard: enrolled vs capacity, waitlist, collections, suggested vs collected late fees, attendance rate, food and other expenses, net, and how many children are missing a form date.
- Children (40): days per week, rate, two authorized pickup names, care notes (plain text), status Enrolled / Waitlist / Ended.
- Attendance (250): Present, Absent or Closed, hours, late minutes and a suggested late fee (minutes x your fee). You choose whether to charge it on Payments.
- Payments (300): tuition, late fee, registration or other, with a Check column.
- Expenses (200), including a separate food total.
- Year-End Receipts: what each family paid this year, split by type — a parent total, not a tax form.
- Forms Checklist: dates only for enrollment, emergency contacts, pickup authorization and an immunization record date. It does not store medical charts.
2. Start Here PDF with your Google copy link.
WHY IT'S DIFFERENT
- Capacity vs enrolled, with a plain-language over-capacity warning.
- Waitlist children stay off the enrolled count.
- Late minutes become a suggested fee; collected late fees are tracked separately so you can see the difference.
- Year-end totals a parent can be shown, without pretending to be a government form.
- Check columns keep unknown names and negative amounts out of the totals.
- Google Sheets AND Excel 2010 or newer, plus LibreOffice.
TESTED
25 of 25 automated checks passed over 3 rounds (sample, planted mistakes, cleared file) against an independent model.
HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip.
2. Open Daycare-START-HERE.pdf and choose "Make a copy", or open the .xlsx in Excel.
3. The Willow Nest sample is made up. Clear the yellow cells before you add real families.
GOOD TO KNOW, PLEASE READ
- An organizer, not licensing, tax, legal or medical advice. Ratio rules and required records vary by state and county.
- Care notes and immunization dates are reminders you type; they are not a health record system.
- Sample names are made up. One currency. Not designed for Apple Numbers.
- Digital download; nothing physical ships. Returns aren't accepted on digital files. Message me if something isn't working.
- For your own program. Please don't resell or share the files or links.
HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing public listing titles and descriptions for daycare forms and home-daycare kits on Etsy (many are printable PDF packets without attendance-to-payment math). I tested the headline calculations against an independent check before listing.
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$22.00
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
A home daycare spreadsheet that tracks tuition, daily attendance, late pickups and every parent payment, with a year-end payment total for each family. See enrolled children against your capacity, keep a waitlist, and know which enrollment forms still need a date, in Excel or Google Sheets.
WHAT'S INCLUDED
1. Home Daycare Business Kit workbook (Google Sheets + Excel), 9 tabs:
- Start Here and Setup: capacity, default weekly tuition, late fee per minute, and the year for parent totals.
- Dashboard: enrolled vs capacity, waitlist, collections, suggested vs collected late fees, attendance rate, food and other expenses, net, and how many children are missing a form date.
- Children (40): days per week, rate, two authorized pickup names, care notes (plain text), status Enrolled / Waitlist / Ended.
- Attendance (250): Present, Absent or Closed, hours, late minutes and a suggested late fee (minutes x your fee). You choose whether to charge it on Payments.
- Payments (300): tuition, late fee, registration or other, with a Check column.
- Expenses (200), including a separate food total.
- Year-End Receipts: what each family paid this year, split by type — a parent total, not a tax form.
- Forms Checklist: dates only for enrollment, emergency contacts, pickup authorization and an immunization record date. It does not store medical charts.
2. Start Here PDF with your Google copy link.
WHY IT'S DIFFERENT
- Capacity vs enrolled, with a plain-language over-capacity warning.
- Waitlist children stay off the enrolled count.
- Late minutes become a suggested fee; collected late fees are tracked separately so you can see the difference.
- Year-end totals a parent can be shown, without pretending to be a government form.
- Check columns keep unknown names and negative amounts out of the totals.
- Google Sheets AND Excel 2010 or newer, plus LibreOffice.
TESTED
25 of 25 automated checks passed over 3 rounds (sample, planted mistakes, cleared file) against an independent model.
HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip.
2. Open Daycare-START-HERE.pdf and choose "Make a copy", or open the .xlsx in Excel.
3. The Willow Nest sample is made up. Clear the yellow cells before you add real families.
GOOD TO KNOW, PLEASE READ
- An organizer, not licensing, tax, legal or medical advice. Ratio rules and required records vary by state and county.
- Care notes and immunization dates are reminders you type; they are not a health record system.
- Sample names are made up. One currency. Not designed for Apple Numbers.
- Digital download; nothing physical ships. Returns aren't accepted on digital files. Message me if something isn't working.
- For your own program. Please don't resell or share the files or links.
HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing public listing titles and descriptions for daycare forms and home-daycare kits on Etsy (many are printable PDF packets without attendance-to-payment math). I tested the headline calculations against an independent check before listing.
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Pet Sitting Spreadsheet, Dog Walking Booking Tracker & Client Pet Care Log, Key Log, Holiday Rates | Excel Google Sheets
$19.00
-
Digital download
Grocery Budget Spreadsheet, Meal Plan Cost Tracker & Shopping List, Recipe Cost Per Serving | Excel Google Sheets
$8.00
-
Digital download
Cleaning Business Spreadsheet, House Cleaning Pricing Calculator, Job & Client Tracker, Crew Hours, Invoice Log | Excel Google Sheets
$22.00
-
Digital download
Freelancer Quarterly Estimated Tax 2027 Spreadsheet, Self Employment Tax & Tax Set Aside Tracker | Excel Google Sheets
$13.00
-
Digital download
Medical Expense Tracker 2027, HSA & FSA Spreadsheet, Receipt Log, Contribution Limit, Use It Or Lose It, Family Bills, Google Sheets Excel
$12.00
-
Digital download
Scholarship Tracker & College Application Tracker, Deadline Countdown, Award Totals, Net Price, Senior Year | Google Sheets Excel Template
$9.00
Shoppers with similar taste loved these
-
Simple receipt pads for small businesses - (sets of 3, 5, 10 or 15), also available as seconds at a special price / invoice for small businesses
$16.31
-
Included in the set: order pad and receipt pad - for your orders, receipts and accounting made easy - also for small businesses
$11.62
-
Receipt pad with carbon copy, also for small businesses, DIN A6 portrait format, space for stamp
$21.00
-
Receipt pad / invoice pad - for small business owners. Writing receipts | invoices | small business regulations
$6.45
-
4 notepads in a set! With warmest regards: 2 x A6 + 2 x A7 - for all occasions, small gifts, party favors, invitations
$19.71
-
Receipt pad set for small business owners - bulk pack (5, 10 or 15 pieces) - for small businesses / invoice / receipt / Etsy shop
$8.80
-
Notepad “hej” | Din long | 50 sheets
$4.58
-
Digital download
Equipment Register Excel Template: Asset Tracking & Maintenance (Digital Download)
Sale Price $10.85
Original Price $14.47
-
Digital download
Health and Safety Incident Register in Excel | Manage H&S Reports and Actions \ Interactive Dashboard
$11.78
-
Digital download
Issues & Concerns Tracker Google Sheets spreadsheet, Issue tracking management template, Project risk and issue log, resolution and handling
Sale Price $3.49
Original Price $4.99
-
Digital download
Printable Certificates in Editable Excel/Google Sheets. Plus Register of the certificates awarded !
$13.55
-
Digital download
MS Access Incident Tracker Database | Accident and Incident Management register | Template
$2.11