Daycare Invoice Template

Setup takes about 25 minutes. Download the .xlsx file and open it in Excel or Google Sheets. Start with the Family Directory: add each enrolled family with their child's name, age group, care schedule, and tuition rate. If any families receive government subsidies, enter the authorization number, co-pay amount, and agency share for each. Then add your center's name, address, EIN, and license number to the Invoice sheet header — these fields persist across every invoice you generate. Once the directory is complete, creating any invoice means selecting the family from the dropdown, entering the billing period, and adding any one-time charges like late pickup fees or field trip costs. The tuition rate, discounts, and subsidy deductions fill in automatically.

At the start of each billing cycle, work through the Family Directory row by row to generate invoices for every enrolled family. For families on government subsidy programs, also log the billing submission in the Subsidy Tracker — enter the billing period, amount billed to the agency, and authorization number. As payments come in, mark invoices as paid in the Family Ledger and record the payment date and amount. For subsidy payments, log what the agency actually paid in the Subsidy Tracker and compare it against what you billed — discrepancies need to be flagged before the next reimbursement cycle, because most subsidy agencies won't process corrections more than 60-90 days after the period end.

The Family Ledger becomes more valuable as the year progresses. Review it monthly to identify families with outstanding balances before they fall more than 30 days past due — the earlier you reach out, the more likely you are to collect without damaging the relationship. At year-end, use the Year-End Receipt sheet to generate tax documentation for every family: pull up their record, verify the annual totals match the Ledger, and print or email the receipt. Most daycare operators receive the bulk of these requests in January and February. Having a template that generates compliant receipts in under a minute per family makes this process straightforward instead of a week-long administrative burden.

Billing is one of the most time-consuming and error-prone parts of running a daycare — not because the math is complicated, but because every family's situation is slightly different. One child gets a sibling discount. Another family splits payment between a parent and a grandparent. Three families are on the state subsidy program, each with a different co-pay and authorization number. A parent disputes a late pickup fee from two weeks ago. Generic invoice templates aren't built for any of this, which is why most daycare directors end up maintaining a patchwork of handwritten records, spreadsheet tabs, and billing software that doesn't quite match their policy. A template pre-structured around how childcare billing actually works eliminates most of the manual tracking.

Government subsidy billing adds a layer of complexity that catches many operators off guard. Subsidy agencies pay on their own schedule — often 30-60 days after the billing period — and they pay based on authorized attendance, not actual enrollment. If a subsidized child was absent more days than your subsidy agreement allows, the agency may recalculate the payment downward. If you don't track what you billed versus what you received for each authorization period, you can end up carrying receivables you've already mentally counted as revenue. The Subsidy Tracker in this template reconciles billing submissions against actual payments, which is how you catch discrepancies before they become write-offs.

Year-end tax documentation is the billing task that creates the most administrative pressure for daycare operators. Parents claim the Child and Dependent Care Tax Credit (IRS Form 2441) and dependent care FSA reimbursements using annual receipts from their provider. To issue a compliant receipt, you need your center's EIN, license number, address, the child's full name, dates of care, and the total paid out-of-pocket by the family — net of any subsidy credits. Assembling this for every family from manual records or billing software exports takes hours. Operators who track payments systematically throughout the year can generate accurate year-end receipts for every family in an afternoon, rather than spending the first two weeks of January hunting down records.