Stackrows
Daycare Balance Sheet Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Balance Sheet
Enrollment & Receivables
Fixed Assets
Period Comparison

Daycare Balance Sheet Template

See exactly what your daycare center owns, owes, and is worth — a balance sheet built for childcare with government subsidy receivables, family tuition deposits, playground equipment schedules, and deferred revenue tracking.

$29Save 4+ hours vs. building a daycare balance sheet spreadsheet from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx215 KB4 sheetsUpdated 2026-03-22

What's Inside This Daycare Balance Sheet Template

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

1

Balance Sheet

The core financial statement organized around the daycare chart of accounts. Current assets include cash and operating checking accounts, tuition receivables from private-pay families who owe for the current billing cycle, government subsidy receivables (CCDF vouchers, state childcare assistance program payments, Head Start reimbursements, and any CACFP meal reimbursements in transit), prepaid expenses such as insurance premiums, annual licensing fees, and curriculum subscriptions, and supply inventory on hand. Non-current assets cover classroom furniture (cribs, toddler tables, cubbies, learning centers), outdoor playground equipment, educational technology, vehicles if the center provides transportation, and leasehold improvements to the facility — each tracked at cost net of accumulated depreciation with totals fed from the Fixed Assets sheet. Current liabilities include accounts payable to vendors and supply companies, accrued wages and payroll taxes (labor runs 50–70% of revenue at most centers), accrued paid time off for staff, enrollment deposits held from families who have reserved a spot, deferred tuition revenue for fees billed and collected in advance of the service period, and any current portion of equipment loans. Long-term liabilities cover SBA loans, equipment financing, and building mortgages if the center owns its property. Owner's equity tracks contributed capital, retained earnings, and owner draws for for-profit operations — with a separate net assets section if the center operates as a nonprofit. A built-in accounting equation check flags any imbalance immediately.

2

Enrollment & Receivables

A period-end summary of tuition and subsidy balances that feeds accounts receivable and deferred revenue figures into the balance sheet. The tracker lists each enrolled family in a roster with their billing arrangement (private pay, government voucher, or a combination), monthly tuition rate, current balance owed, and any deposits on file. For government subsidy accounts, the sheet separates what has been billed to the state or CCDF agency, what has been received, and what remains outstanding as a receivable. This matters because subsidy payment cycles can lag 30–60 days behind service delivery, meaning a significant portion of earned revenue may be sitting as a receivable at any point in time. The sheet also flags deferred tuition — fees collected in advance before the enrollment period starts — which must be recorded as a liability, not revenue, until the care is actually delivered. Directors who maintain this tracker monthly have accurate receivables and deferred revenue figures on the balance sheet without needing to pull a separate aging report from their billing software.

3

Fixed Assets

A fixed-asset register tracking every major piece of equipment and improvement the center owns. Each asset is listed with its description, purchase date, original cost, useful life in years, depreciation method (straight-line by default), and accumulated depreciation to date. The sheet calculates net book value for each asset and rolls up to category totals — classroom furniture and fixtures, playground and outdoor equipment, educational technology and tablets, vehicles, and leasehold improvements — that feed directly into the non-current assets section of the balance sheet. Playground equipment represents one of the largest single asset categories for most centers and depreciates over 10–15 years; tracking it separately from indoor furniture gives you a clearer picture of replacement timing. Leasehold improvements — buildout costs for infant rooms, toddler classrooms, and outdoor play areas — are amortized over the lease term and can represent significant capital investment that lenders and licensing boards want to see documented. The register also helps with insurance scheduling: knowing the replacement value and net book value of each asset category makes annual insurance renewals faster.

4

Period Comparison

A side-by-side view of two balance sheet dates — typically the current period-end against the prior year-end, or the same month from one year to the next. Enter figures for both periods and the sheet calculates dollar and percentage change for every line item across assets, liabilities, and equity. For daycare centers, the most useful comparisons are whether subsidy receivables are trending up (indicating slower state payment cycles or growing voucher enrollment), whether enrollment deposits are increasing (a leading indicator of stronger future enrollment), whether deferred revenue is being recognized consistently or building up unexpectedly, and whether owner's equity is growing over time or being drawn down. This view is valuable for SBA loan renewals, childcare licensing renewals that request financial statements, and any conversations with investors or lenders who want to see the center's financial trajectory rather than just a point-in-time snapshot.

Daycare Balance Sheet Template Features

  • Government subsidy receivables tracked separately from private-pay tuition receivables
  • Deferred tuition revenue recorded as a liability until the care period is delivered
  • Fixed asset register with depreciation for playground equipment, classroom furniture, and leasehold improvements
  • Enrollment deposit liability tracked by family to reconcile against billing records
  • Accounting equation check — automatically flags any imbalance between assets and liabilities plus equity
  • Period-over-period comparison for SBA renewals, licensing boards, and grant applications

How to Use This Daycare Balance Sheet Spreadsheet

Start with the Fixed Assets sheet before entering anything else. Pull your depreciation schedule from last year's tax return or your accountant's records and list every major asset: classroom furniture, playground equipment, educational technology, vehicles, and leasehold improvements from your facility buildout. Enter the original cost, purchase date, and useful life for each item, and the sheet calculates accumulated depreciation and net book value automatically. These totals flow into the balance sheet's non-current assets section — so getting this right first means you won't need to manually reconcile fixed asset values later.

Next, work through the Enrollment and Receivables tracker. Pull your billing roster and record each family's current balance along with any outstanding subsidy payments from CCDF, state voucher programs, or CACFP reimbursements. The sheet separates what's been billed but not yet received from the state versus private-pay balances owed, and captures any deposits and prepaid tuition sitting as liabilities. These figures feed the receivables and deferred revenue lines on the balance sheet. Then complete the rest of the balance sheet: pull cash from your bank statement, accounts payable from your vendor bills, accrued payroll from your last payroll run, and any equipment loan balances from your lender statements.

Update the balance sheet monthly or at least every quarter. For daycares with significant government subsidy enrollment, monthly updates are especially important — subsidy receivables can shift meaningfully between periods as payment cycles and enrollment levels change. Use the Period Comparison sheet when you're preparing for a licensing renewal, SBA loan application, childcare grant reporting, or a review with a board of directors. Childcare centers that maintain organized, current balance sheets — particularly ones that correctly show subsidy receivables, deferred tuition, and playground equipment depreciation — move through lender and regulatory reviews significantly faster than centers presenting only a bank statement and P&L.

15 minutes from download to your first daycare balance sheet

Download the template, enter your enrollment, subsidy, and asset data, and see your childcare center's full financial position — assets, liabilities, deferred tuition, and owner's equity included.

Why Every Daycare Center Needs a Balance Sheet Template

Most daycare owners track tuition revenue and payroll closely but rarely maintain a formal balance sheet. That's a gap that creates real problems. The P&L tells you whether you covered expenses last month; the balance sheet tells you what the business is actually worth, how much cash you can weather a slow enrollment period with, and whether your subsidy receivables or deferred tuition balances are being handled correctly. Childcare centers operate on thin margins — typically 10–16% net — and financial resilience depends entirely on the balance sheet position: cash on hand, what families and state agencies owe you, and whether you have significant liabilities sitting unrecognized.

Three items on a daycare balance sheet are frequently missing or mishandled. The first is government subsidy receivables: state CCDF payments, Head Start reimbursements, and CACFP meal subsidies are real earned revenue that may not arrive for 30–60 days after service delivery. Treating those as income only when received — rather than accruing the receivable when earned — understates your assets and distorts your financial picture. The second is deferred tuition revenue: when a family pays a month in advance or you collect an annual registration fee in August for a full school year, that cash is a liability on your balance sheet until the care period is delivered. Recording it as immediate revenue overstates income and misstates your obligations to enrolled families. The third is enrollment deposits: security deposits collected from families when they join a waitlist or hold a spot are liabilities until applied to tuition — they should sit on the balance sheet, not flow through income.

Lenders, licensing boards, and childcare grant reviewers evaluate daycare balance sheets on a few key questions: Is there enough working capital to cover payroll and operations if a subsidy payment is delayed? Are the center's assets — particularly its playground, classroom setup, and facility improvements — documented and insured? And is equity growing over time, indicating that the center is building a financially sustainable operation? A daycare director who can answer those questions with a current, organized balance sheet — one that correctly reflects subsidy receivables, deferred revenue, and asset depreciation — presents a very different picture than one who shows up with only a bank statement. Organized financial statements are often the difference between a straightforward licensing renewal and one that requires additional documentation.

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 Balance Sheet Template FAQ

Daycare Balance Sheet Template

$29