SheetSmart Template Co.
Daycare Business Spreadsheet

Daycare Business Spreadsheet, Home Childcare Tracker for Excel and Google Sheets, Sign In Sign Out Sheet, Attendance, Tuition Billing

$7.49 USD
Buy on Etsy

Instant digital download for Microsoft Excel and Google Sheets. Checkout and delivery are handled securely by Etsy.

Daycare Business Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Keep enrollment, guardian contacts, daily sign in and sign out, tuition and expenses in one organized file, and see your monthly income at a glance. Perfect for home daycare and family childcare providers. ✨ NOW INCLUDES 4 FILES: a SAMPLE version filled with example data so you can see how it works, plus a BLANK version ready for your own info, each for Excel and Google Sheets. ★ WHAT'S INCLUDED ★ • 10 tabs with a clickable Start Here cover page and a How To Use guide with FAQ • Dashboard: 8 KPI tiles (enrolled, tuition billed, collected, outstanding, expenses, net income, child-days this month, late pickups), a monthly income summary (billed, collected, food, supplies, expenses, child-days, net income), family balances, upcoming birthdays, plus a billed vs. collected vs. expenses chart and an expenses by category chart • Children & Families (60 rows): birthday and age, start date, schedule, days, sibling discount, weekly rate, status, two guardians with phone and email, authorized pickup, emergency contact and the care notes each family gives you, plus days this month, billed, paid and balance • Sign In / Sign Out (5,000 rows): drop-off and pickup times and who did each, with hours and late pickup minutes and fees worked out • Monthly Attendance: pick a month to see each child's days, hours, late pickups and late fees, plus a day-by-day grid of hours with weekends shaded • Tuition Billing (1,500 rows): tuition from weeks x weekly rate (or days attended for drop-in), late fees added automatically, other charges, discounts, due date, paid, balance and status • Payments (2,000 rows) from families, subsidy or agency deposits and employer benefits • Expenses (800 rows): food and snacks, supplies, toys, diapers, cleaning, insurance and more, with totals by category • Setup: program name, year, hours, late pickup fee and grace period, terms, sibling discount, capacity, tuition rates and lists • Sample data from a small home daycare so you can see how it works ★ PERFECT FOR ★ ✓ Home daycare and family childcare providers ✓ Small childcare centers and preschools ✓ Nannies and nanny shares who bill families ✓ Before and after school programs ★ COMPATIBILITY ★ • Microsoft Excel (desktop, Mac, web) • Google Sheets (upload to Google Drive and open with Google Sheets) • 4 files included: Excel (sample) + Excel (blank) + Google Sheets edition (sample) + Google Sheets edition (blank) • Not designed for Apple Numbers ★ HOW IT WORKS ★ 1. Download and open the file in Excel, or upload it to Google Drive and open with Google Sheets. 2. On Setup, add your hours, late fee, sibling discount and tuition rates. 3. Enroll each child, then sign them in and out every day. 4. Bill tuition, record payments and log expenses. The Dashboard shows your monthly income. Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol. ★ PLEASE NOTE ★ • This is a di
Free Monthly Budget Starter Kit

5 printable pages: a monthly budget sheet, a 12-month bill checklist and 3 savings-goal trackers. Free when you join the email list.

Get the free kit