July 29, 2026 · ViaSheet Team
The Home Daycare & Childcare CRM Spreadsheet: Enrolment & Tuition Guide
Discover how home daycare operators, small nurseries, and childcare centers track family enrolments, waitlists, tuition payments, and emergency contacts in Google Sheets or Excel.
For home daycare operators, small private nurseries, and childcare centers, managing enrolments is about much more than maintaining a contact list. You are managing child health records, food allergy warnings, emergency contact authorizations, government subsidy vouchers, waitlist queues, and weekly tuition schedules.
According to a report by the National Child Care Association (NCCA), independent childcare providers lose up to 15% of annual revenue due to uncollected late tuition fees, unorganized waitlist management, and empty enrolment slots that could have been filled months in advance.
While dedicated childcare management platforms like Brightwheel, Famly, or MyKidReports exist, their monthly software fees ($600 to $1,800 per year) represent a heavy financial burden for home daycare operators managing 5 to 30 children.
In this comprehensive guide, we will show you how to structure an Automated Daycare & Childcare CRM Spreadsheet in Google Sheets or Microsoft Excel. You will learn how to organize child profiles, track emergency contacts, manage waitlist queues, automate tuition payment logs, and maintain 100% capacity year-round.
Why Small Childcare Providers Need a Spreadsheet CRM
Managing a daycare requires balancing regulatory compliance with small business finances. Operators often juggle parent texts, medical allergy notes, and tuition checks on paper calendars or messaging apps.
Here is why spreadsheet CRMs are the preferred choice for independent childcare providers:
- Zero Monthly Subscription Fees: Eliminating $100/month SaaS subscriptions allows small daycare owners to reinvest funds into educational toys, healthy meals, or staff compensation.
- Instant Emergency Access: Storing child allergy notes, medical conditions, and authorized pickup lists in a cloud Google Sheet allows staff to access emergency contact details instantly on smartphones or tablets during field trips or fire drills.
- Flexible Tuition & Subsidy Tracking: Childcare billing is rarely uniform. Some families pay full private tuition weekly, while others utilize government child care subsidies, vouchers, or multi-child sibling discounts. Spreadsheets allow custom formula tracking for every family agreement.
- Data Privacy & Parent Confidentiality: Keeping family records in your private Google Workspace account ensures strict access control without sharing sensitive child data with third-party software vendors.
Architecture of a Daycare CRM Spreadsheet
To keep your nursery running safely and efficiently, structure your spreadsheet into six core tabs:
[1. Enquiries & Tours] ➔ [2. Active Enrolments] ➔ [3. Child & Allergy Profiles] ➔ [4. Emergency Contacts] ➔ [5. Tuition & Payments] ➔ [6. Capacity Dashboard]Tab 1: Enquiries & Tours
Tracks prospective families from first phone call or website inquiry to facility tour, registration, or waitlist status.
Tab 2: Active Enrolments
Logs active children, assigned classroom/age group (Infant, Toddler, Preschool, After-School), weekly schedule (Full-Time vs. Part-Time Days), and enrollment start/end dates.
Tab 3: Child & Allergy Profiles
Stores child date of birth, dietary restrictions, severe food allergies (e.g. Peanut / Dairy), medical conditions, and pediatrician contact details.
Tab 4: Emergency Contacts & Pickups
Lists authorized parents, guardians, and designated emergency pickup adults with photo ID confirmation codes.
Tab 5: Tuition & Payments
Tracks weekly/monthly tuition rates, government subsidy voucher credits, payment due dates, late payment flags, and outstanding balances.
Tab 6: Capacity Dashboard
Displays real-time licensed capacity utilization per age group, upcoming aging-out transitions (e.g., Toddler moving to Preschool bay), and waitlist queue priority.
Step-by-Step: Building Your Childcare CRM
Let’s build the Child Profiles and Tuition Tracker tabs in Google Sheets or Excel.
1. Structure the Child & Allergy Profiles Tab
Create a tab named Child Profiles and set up the following headers in Row 1:
| Column | Header Name | Data Type | Description / Formula |
|---|---|---|---|
| A | Child ID | Formula | =IF(ISBLANK(B2), "", "KID-" & TEXT(ROW()-1, "000")) |
| B | Child Full Name | Text | Child’s legal name |
| C | Date of Birth | Date | DOB for age group classification |
| D | Age (Years / Months) | Formula | =DATEDIF(C2, TODAY(), "Y") & " yrs, " & DATEDIF(C2, TODAY(), "YM") & " mos" |
| E | Age Group | Formula | Automated classification (Infant, Toddler, Preschool) |
| F | Primary Parent / Guardian | Text | Parent full name |
| G | Parent Phone | Text | Emergency contact phone |
| H | Severe Allergies | Text | Critical allergy alerts (e.g., PEANUT ALLERGY - EPIPEN) |
| I | Medical / Dietary Notes | Text | Special dietary or health instructions |
| J | Allergy Warning Alert | Formula | Visual highlight for severe health notes |
2. Automating Age Group & Allergy Warnings
Automating child age calculations and allergy warnings prevents scheduling and safety errors:
A. Automated Age Group Classification (Column E)
In cell E2, automatically categorize children into age groups based on their Date of Birth (Column C):
=IF(ISBLANK(C2), "", IF(DATEDIF(C2, TODAY(), "M") < 18, "1. Infant (0-18m)", IF(DATEDIF(C2, TODAY(), "M") < 36, "2. Toddler (18m-3y)", "3. Preschool (3y-5y)")))Explanation: If a child is under 18 months, classifies as Infant. Between 18 to 36 months, Toddler. Over 3 years, Preschool. This helps home daycares maintain legal adult-to-child ratio compliance!
B. Severe Allergy Highlight Alert (Column J)
In cell J2, check if Column H contains allergy notes:
=IF(ISBLANK(H2), "✅ No Allergies Logged", "🚨 SEVERE ALLERGY ON FILE")Apply Conditional Formatting to highlight Column J in bright red (#FEE2E2) if it contains SEVERE ALLERGY.
3. Setting Up the Tuition & Subsidy Payment Tracker
Create a tab named Tuition Tracker to monitor weekly billing:
| Family Name | Child Name | Schedule | Private Tuition ($) | Subsidy Voucher ($) | Parent Share Owed ($) | Payment Status | Outstanding ($) |
|---|---|---|---|---|---|---|---|
| Johnson | Emma J. | Full-Time | $250.00 | $150.00 | =D2 - E2 ($100) | Paid in Full | $0.00 |
| Smith | Liam S. | 3 Days / Wk | $180.00 | $0.00 | $180.00 | ⚠️ OVERDUE | $180.00 |
Parent Share Owed Formula (Column F):
=IF(ISBLANK(D2), 0, D2 - E2)Automated Overdue Tuition Alert (Column G):
Apply Conditional Formatting to highlight Column G in red if payment status is marked OVERDUE.
Managing Waitlists & Enrolment Capacity
Empty daycare slots represent lost revenue that can never be recovered. Managing a dynamic waitlist ensures that when an older child graduates to elementary school, a waitlisted family fills the opening immediately.
1. Waitlist Queue Structure
On your Waitlist tab, record:
Parent Name & ContactChild DOB / Expected Due DateDesired Start DateDays Needed(Full-Time, Mon/Wed/Fri, Tue/Thu)Registration Deposit Paid ($)
2. Automated Waitlist Match Formula
Filter your waitlist queue using FILTER or QUERY to identify families waiting for a specific age group:
=QUERY(Waitlist!A:G, "SELECT A, B, C, D WHERE E = 'Toddler' AND G = 'Deposit Paid' ORDER BY D ASC")This formula automatically extracts all deposit-paid families waiting for a Toddler opening, sorted by their desired start date!
Frequently Asked Questions (FAQ)
Can I share emergency pickup lists with my assistant teachers without exposing tuition data?
Yes! In Google Sheets, create a Filter View or separate tab containing only Child Name, Emergency Contacts, and Authorized Pickup Names/Photos. Share that tab with assistant staff without giving edit access to financial tuition tabs.
How do I handle government child care subsidy voucher payments?
In the Tuition Tracker tab, Column E logs government subsidy voucher credits (e.g., state or local childcare assistance). The spreadsheet automatically subtracts the voucher credit from the total rate, leaving the net parent copay amount in Column F.
Is Google Sheets compliant for storing child health records?
Google Sheets utilizes enterprise Google Cloud security. Ensure your Google account uses Two-Factor Authentication (2FA) and limit edit access strictly to authorized daycare personnel.
Upgrade to the ViaSheet Daycare CRM Spreadsheet
Building a custom daycare database with age-group ratio classifiers, allergy highlights, tuition subsidy formulas, and waitlist queues requires hours of setup.
If you want a pre-built, beautifully formatted spreadsheet engineered specifically for childcare providers, explore our Daycare & Childcare CRM Spreadsheet.
The ViaSheet Daycare CRM features:
- Capacity & Enrolment Dashboard: Real-time stats on active enrolments, age-group occupancy, waitlist queue length, and monthly tuition revenue.
- Enquiry & Tour Pipeline: Track prospective families from first phone call to facility tour and enrolment confirmation.
- Child & Medical Profiles: Dedicated records for child DOB, severe food allergies, pediatrician contacts, and dietary notes.
- Emergency Contact & Pickup Log: Detailed database of authorized parents, guardians, and emergency pickup adults.
- Tuition & Subsidy Ledger: Manages weekly/monthly rates, government voucher credits, parent co-pays, and late fee warnings.
- One-Time Purchase: Pay just €29 once for lifetime access in Google Sheets and Microsoft Excel—no monthly fees or subscriptions ever.
Keep children safe, organize family records, and maintain 100% enrolment capacity. Download the ViaSheet Daycare CRM Template today!