Daycare Cash Flow Template

Download the .xlsx file and open it in Excel or Google Sheets. Start with the Enrollment & Revenue Tracker — enter your licensed capacity and current enrollment for each age group, your tuition rates, and how many slots are filled by subsidy vouchers versus private-pay families. This gives you your baseline revenue picture and calculates your current occupancy rate immediately. Then enter your current subsidy receivables: the dollar amount that has been earned but not yet reimbursed by your state or county agency. This number is the starting point for understanding your cash position, because a center with $30,000 in outstanding subsidy isn't cash-rich — it's waiting on a check.

Move to the 13-Week Cash Flow sheet and fill in your projected tuition collections week by week. Weekly-pay families are straightforward — you can estimate collection based on current enrollment and your collection rate. Monthly-pay families all land in the same one or two weeks at the start of the month, which creates a cash spike followed by a flat period. Subsidy reimbursements should be projected based on your agency's historical payment pattern — if they pay 45 days after the care month ends, enter those inflows in the correct week. Enter your bi-weekly payroll dates and amounts in the expense rows — this is the most important thing to get right, because payroll is non-negotiable and the weeks it aligns with low tuition collection or delayed subsidy payments are where cash shortfalls happen.

Reconcile the Monthly Cash Flow sheet against your bank statements at the end of each month and update the subsidy receivables balance in the Enrollment Tracker. After a few months of data, the Annual Summary will show your labor cost ratio trend, your average occupancy rate, and the seasonal cash flow pattern for your specific center. Most daycare operators find that the July–August period and the weeks immediately after major holidays are the tightest cash windows — enrollment dips or families pause care while subsidy payments continue on their fixed reimbursement schedule. Seeing this pattern in advance lets you plan your line of credit draw or reduce discretionary spending before the trough rather than reacting to it.

Daycare centers face a cash flow structure that most business financial models aren't built for. Revenue is theoretically stable — most centers bill flat tuition regardless of attendance — but two factors create persistent cash gaps. First, government subsidy programs, which fund 20–60% of enrollment at most community-based centers, reimburse on a 30–60 day lag. A center serving 40 subsidized children at an average state rate of $800/month has earned $32,000 in a given month that won't arrive for six weeks. Second, payroll hits bi-weekly on fixed calendar dates that don't align with monthly tuition collection, so there are weeks when the payroll outflow significantly exceeds the week's cash inflows. Neither of these is a sign of a troubled business — it's just how childcare cash flow works — but it requires week-by-week visibility that a monthly income statement doesn't provide.

The financial metrics that matter most in childcare are occupancy rate and labor cost ratio. Occupancy rate — enrolled children divided by licensed capacity — needs to stay above 85% for most centers to cover fixed costs. At 70% occupancy, most centers are losing money; at 90%, they're typically profitable at net margins of 10–16%. Labor cost ratio is the operating lever: teachers, assistants, and aides need to be scheduled to meet licensing ratio requirements, which means labor costs are somewhat fixed regardless of daily attendance. The target is to keep total payroll and benefits below 65% of revenue, which requires both strong enrollment and efficient scheduling. Centers that track these two metrics monthly catch enrollment slide before it becomes a financial crisis, because the gap between 90% and 80% occupancy at a 50-child center represents roughly $4,000–$6,000 per month in lost revenue against a mostly fixed cost base.

The cash management workflow for a well-run daycare center looks like this: invoice tuition on the first of the month and collect by the fifth, track subsidy receivables by payer and expected payment date, schedule payroll based on the bi-weekly calendar and build a buffer for the weeks that fall between high-collection periods, and review the 13-week projection at the start of each month to identify any coming cash gaps that a line of credit draw could bridge. Centers that also participate in the CACFP food reimbursement program should track reimbursements as a cash inflow separately from tuition, since the timing and the administrative process differ. Getting this projection right doesn't require sophisticated accounting — it requires knowing your enrollment by billing type, your subsidy payer payment schedule, and your payroll dates. This template organizes exactly those three inputs into a usable projection.