Stackrows
Daycare Income Statement Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Monthly Income Statement
Annual Summary
Enrollment & Revenue Breakdown
Dashboard

Daycare Income Statement Template

Report your daycare's revenue, labor costs, and net income with an income statement built for childcare centers — pre-loaded with tuition, subsidy, and age-group categories.

$29Save 5+ hours vs. building an income statement spreadsheet from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx215 KB4 sheetsUpdated 2026-03-23

What's Inside This Daycare Income Statement Template

This template includes 4 worksheets, each designed for a specific part of your daycare financial workflow:

1

Monthly Income Statement

The core worksheet where you record each month's revenue and expenses using daycare-specific line items. Revenue is broken out by age group (infant, toddler, preschool, school-age) and funding type (private tuition vs. government subsidies and vouchers). Expenses follow the structure childcare operators actually use: payroll and benefits (split by teaching staff, aides, and directors), rent and occupancy, food and meals program, curriculum and supplies, licensing and insurance, utilities, and marketing. The sheet calculates gross profit, operating income, and net income automatically — along with key ratios like labor cost percentage and subsidy as a percent of total revenue.

2

Annual Summary

A 12-month rollup that pulls from each monthly sheet automatically. View full-year tuition revenue, total subsidy income, each expense category year-to-date, and net income for every month side by side. This is the sheet lenders, accountants, and licensing agencies typically ask for — it presents your center's financial performance in the standard income statement format without requiring you to build anything from scratch. Scroll across any row to see how a specific cost category has changed month to month throughout the year.

3

Enrollment & Revenue Breakdown

A supporting worksheet that ties enrollment numbers to revenue figures. Enter your licensed capacity and current enrollment by age group, and the sheet calculates your occupancy rate, revenue per enrolled child, and average tuition rate across the center. It also tracks the split between private-pay families and subsidy/voucher-funded spots, which affects both your cash flow stability and how you model revenue growth. This sheet feeds the revenue inputs on the Monthly Income Statement, so everything stays connected and consistent.

4

Dashboard

A visual overview with pre-built charts showing the metrics that matter most for childcare operations: labor cost ratio (target below 65% of revenue), occupancy rate, monthly net income trend, and the revenue split between tuition and subsidies. The dashboard pulls from your monthly data automatically and updates every time you enter new figures. Use it for your monthly directors' review, for reporting to a board or investors, or when applying for grants or SBA loans that require a summary of financial performance.

Daycare Income Statement Template Features

  • Revenue broken out by age group (infant, toddler, preschool, school-age) and funding type
  • Subsidy and voucher income tracked separately from private tuition
  • Labor cost ratio auto-calculated against total revenue (target below 65%)
  • Occupancy rate and revenue per enrolled child calculations
  • 12-month annual summary in standard income statement format
  • Dashboard with charts for labor ratio, occupancy, and net income trends

How to Use This Daycare Income Statement Spreadsheet

Start by opening the Enrollment & Revenue Breakdown sheet and entering your licensed capacity and current enrollment by age group. This takes about 10 minutes and sets the foundation for your revenue figures. Then move to the Monthly Income Statement: review the pre-loaded categories and adjust any line items that don't match your center's chart of accounts. Most directors keep the structure as-is and just rename a subsidy program or split out a specific expense category.

Once the categories are set, enter your actual revenue and expenses for the current month. Use your accounting software export or bank statements as your source — you don't need to reconcile to the penny on day one. The formulas calculate gross profit, operating income, and net income automatically, and the ratios update instantly so you can see your labor cost percentage and subsidy mix as you enter data. Copy the monthly sheet forward for remaining months and adjust for known enrollment changes or seasonal dips.

The real payoff comes from the Annual Summary and Dashboard. Check in monthly: enter your actuals, review the labor cost ratio and occupancy rate on the dashboard, and note any category that's trending in the wrong direction. Childcare margins are thin enough that a 3–4% labor cost overrun can turn a profitable month into a loss. Directors who review their income statement monthly typically catch those shifts within 30 days — early enough to adjust staffing ratios, fill open enrollment spots, or renegotiate a supply contract before the cost compounds.

15 minutes from download to your first income statement

Download the template, plug in your enrollment and expense numbers, and see your daycare's full financial picture — monthly income statement, annual summary, and occupancy metrics included.

Why Every Daycare Needs an Income Statement Template

Daycare centers operate on narrow margins — typically 10–16% net — and the single biggest lever is labor. Staff payroll and benefits usually consume 50–70% of revenue, which means a childcare income statement looks very different from a retail or services business. Most operators know their enrollment numbers and their tuition rates, but without a structured income statement, it's easy to miss that labor crept from 58% of revenue to 65% over six months while everything else held steady. That difference between 58% and 65% on $400,000 of annual revenue is $28,000 — enough to wipe out the year's profit.

A properly structured daycare income statement separates revenue by age group and funding type because the economics are different. Infant rooms are the most expensive to staff (lower ratios required by licensing), so infant tuition rates are higher but so are the labor costs to serve them. Subsidy income from state and federal programs tends to be reliable but pays below market rate in many states, which affects your blended revenue per child. Tracking these categories separately lets you model what happens when you shift your enrollment mix — more infants, more subsidy-funded spots, or adding a school-age before/after program.

The income statement is also the document most often requested by outside parties: CPAs during tax prep, banks when you apply for an SBA loan to expand, licensing agencies during compliance reviews, and grant funders for childcare access programs. Having one ready in standard format — revenue, cost of goods, operating expenses, operating income, net income — saves time and creates the credibility that financial data is being tracked seriously. This template is built to output that standard format while still capturing the daycare-specific detail (age group revenue, subsidy tracking, meals program costs) that makes the internal view actually useful for running the business.

Daycare Industry at a Glance

Financial templates built for daycare centers and childcare providers — pre-loaded with tuition billing categories, subsidy tracking, and the KPIs that determine whether a center is actually making money.

Revenue Drivers

  • Weekly/monthly tuition by age group
  • Government subsidies and voucher programs
  • Before/after school care
  • Drop-in and part-time care
  • Enrichment classes and summer programs

Key Cost Categories

  • Payroll and benefits (50-70% of revenue)
  • Rent and occupancy
  • Food and meals program
  • Supplies and curriculum materials
  • Insurance and licensing
  • Utilities
  • Marketing and enrollment

Typical Margins

Gross: 30-50% · Net: 10-16%

Seasonality

Peak enrollment in August-September (school year start) and January-February. Summer dip for school-age programs. Revenue is more stable than attendance because most centers bill flat tuition regardless of days attended.

Key Performance Indicators

Occupancy rate (target 85-95%)Labor cost ratio (target below 65%)Revenue per enrolled childSubsidy as % of revenueMonthly withdrawal/churn rate

Daycare Income Statement Template FAQ

Daycare Income Statement Template

$29