Daycare P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros or add-ins needed. Start with the Monthly P&L sheet and review the pre-loaded revenue and expense categories. Most daycare centers can use the template as-is with minor adjustments: confirm your age group structure matches the room labels, verify that your subsidy programs are listed correctly, and add any enrichment programs or fee types that aren't already included. Initial setup takes 15–20 minutes and you only need to do it once.

Each month, pull your tuition billing records, subsidy payment remittances, and expense summaries and enter the totals by category. If you use childcare management software like Brightwheel, Procare, or HiMama, most can export a monthly revenue report you can use as your source. Fill in the licensed slots and current enrollment figures in the Occupancy & Revenue Tracker to unlock the occupancy rate calculations — that single number drives more staffing and expansion decisions than anything else on the P&L.

Come back at month close to review the full picture — it takes 20–30 minutes once you're in the routine. The labor cost ratio is the most important number to watch: if payroll and benefits are consistently above 65–70% of revenue, the center needs to either raise tuition, reduce overtime, or improve occupancy before other cost-cutting measures will make a meaningful difference. Directors who review their P&L monthly consistently catch staffing overruns, subsidy billing gaps, and underperforming rooms weeks before the problem compounds.

Daycare is a labor-intensive business running on tighter margins than most owners expect. Payroll alone consumes 50–70% of revenue for most centers, licensing ratios set a hard floor on staffing costs, and raising prices is constrained by what local families and subsidy programs will pay. At the same time, revenue looks more stable than it is — flat tuition billing masks the fact that a single withdrawal can erase an entire room's profit if that room was already running lean on enrollment. Without a monthly P&L to surface those dynamics, problems stay hidden in the bank account until they become urgent.

A daycare P&L needs a structure that reflects how childcare revenue actually works. Tuition income should be tracked by age group because infant and toddler rooms generate higher revenue per child but also carry higher licensing costs (lower ratios mean more staff per child). Subsidy payments need their own line because they arrive on a different billing cycle and at different rates than private tuition — and because subsidy dependency as a percentage of total revenue is a risk metric lenders and investors look at. Food program reimbursements through CACFP are often entered as income by some centers and as an offset to food costs by others; the template handles both approaches clearly so your net food expense reflects reality.

The occupancy rate is the operational lever that makes everything else on the P&L move. A center running at 85–90% occupancy with a labor cost ratio below 65% and a net margin of 10–15% is in a healthy financial position. Below 80% occupancy, most centers start running into cash flow problems regardless of how tight their expense management is — there just isn't enough revenue per room to cover fixed staffing costs. This template tracks occupancy by room so you can see which rooms are pulling weight and which need attention, whether that means marketing, a waitlist, or renegotiating a staff schedule.