Daycare Budget Template

Getting started takes about 15 minutes. Download the .xlsx file and open it in Excel or Google Sheets — no macros or plugins required. Start with the Monthly Budget sheet and review the pre-loaded categories. Most daycare owners keep the expense categories as-is and spend their setup time on the revenue side: enter your licensed capacity and current enrollment by age group, confirm your tuition rates for each room, and add any subsidy or voucher programs you participate in. The formulas calculate occupancy rate and projected revenue from there.

Once your baseline is set, work through the expense side. Payroll is almost always your largest line item — enter your staffing by role and whether each position is full-time or part-time. Add your rent, food program costs, insurance, and supplies. If you're not sure on some numbers, use last month's bank statements and QuickBooks or your accounting software as a reference. The goal on day one is a reasonable starting point, not perfect accuracy.

Come back each month and enter your actual numbers in the Budget vs Actual sheet. This is where the template pays for itself: you'll see whether your occupancy rate is hitting target, whether payroll is creeping up as a percentage of revenue, and whether subsidy reimbursements are arriving on schedule. Most directors who stick with this monthly review say it takes 20–30 minutes and catches problems — a classroom running at 60% occupancy, a food program cost that's been rising for three months — before they turn into budget crises.

Childcare center budgeting is hard because revenue and costs move in ways that don't always line up. Tuition comes in on a weekly or monthly schedule, but subsidy payments from state and federal programs often arrive weeks late. Payroll goes out every two weeks regardless. Enrollment spikes in August and January, drops in summer for school-age programs, and every withdrawal from an infant room immediately hits your bottom line because infant ratios are expensive to staff and hard to backfill quickly. Centers that don't budget at the line-item level often discover cash flow problems only when payroll is due.

The numbers that matter most in childcare are occupancy rate and labor cost ratio. Occupancy should run between 85% and 95% of licensed capacity — below that, you're paying for staff and space you're not monetizing. Labor cost should stay below 65% of revenue; most healthy centers run 55–62%. Gross margins of 30–50% are typical, but net margins after overhead and licensing costs usually land in the 10–16% range. If you don't know these numbers for your center right now, that's exactly the gap this template fills.

The most practical use of a daycare budget isn't annual planning — it's monthly comparison. Set your revenue and expense targets at the start of each year, then spend 20 minutes each month entering actuals and reviewing where you're off. An occupancy shortfall of two infants looks small in isolation but can represent $2,000–$4,000 per month in lost revenue depending on your market. A labor cost ratio that ticks from 60% to 68% over six months is the kind of trend that's easy to miss without a monthly tracker but obvious in hindsight. This template is built around that monthly review cycle.