How to Track Childcare Costs in a Spreadsheet

You know roughly what daycare costs each month. What you almost certainly don’t know is what childcare costs you per year — because tuition is only part of it. There’s the registration fee you paid in January, the supply fee in September, the $60-a-month meal charge, the twelve days your centre was closed and you paid a sitter, the eight weeks of summer camp, and the late-pickup fees you’d rather not add up. Families routinely discover their real number is thousands above the one in their head.

This guide builds the full picture in a spreadsheet: every cost, per child, across a full year — and then uses that number to make the one decision that’s actually worth money, which is whether to run your childcare through a Dependent Care FSA or claim the tax credit.

Everything below uses one worked example family so the arithmetic is visible. Their numbers won’t be yours; the structure will be.

The example family

Meet the Rivera household. Two working parents, married filing jointly, $120,000 adjusted gross income. Two children:

• Emma, 3 — full-time centre-based daycare
• Liam, 6 — first grade, before-and-after-school care during term, camp in summer

Every dollar figure from here on is an assumption I’ve picked to be plausible, not a national average. Swap in yours.

Step 1: Build the log per child, not per household

The single most common mistake is one column called “childcare.” It hides everything useful. You cannot answer “what does Emma cost versus Liam?” or “what happens to our budget when Liam ages out of after-care?” from a single number.

So the spine of the sheet is a monthly grid: rows for expense categories, columns for each child, repeated for all twelve months.

Four categories is enough. More than that and you’ll stop filling it in by March, which is the real failure mode of every expense tracker ever built.

Splitting by child costs you nothing and answers questions you’ll actually ask. When Liam ages out of after-school care, how much does the monthly budget free up? If a third child arrives, what’s the marginal cost — and does a sibling discount change the provider decision? Is the toddler room genuinely more expensive than the preschool room, or does it just feel that way? None of those are answerable from a single blended figure, and all of them come up.

One practical note: keep the same category rows for every child even when a row will always be zero. A ragged grid is a grid you’ll fight with when you try to total it, and consistency is what lets a formula roll twelve months into an annual figure without manual patching.

Step 2: Capture the five buckets most people miss

Tuition you’ll remember. These are the ones that turn a $17,000 year into a $26,000 year:

1. One-time and annual fees. Registration, enrolment deposits, annual supply or activity fees, curriculum or materials charges. They’re invisible monthly and material annually.
2. Separately-billed extras. Meals, diapers and wipes if the centre charges for them, field trips, picture day, late-pickup fees.
3. Closure-day care. Your centre closes for holidays, staff training days and often a week in summer. If you can’t cover those with PTO, that’s paid backup care.
4. Summer. Camp fees, deposits, and the uncovered weeks between school ending and camp starting.
5. Babysitters and backup care. Not just date nights — sick days, school closures, the gap when a nanny is on holiday.

Here’s the Riveras’ full year with all five in:

Their mental number was “about $1,970 a month” — $23,640. The real figure is $27,655, a little over $4,000 higher, and it’s 23% of gross household income.

That percentage is worth logging every year. There’s no official rule for what share of income childcare “should” be, and any benchmark you read is a guideline rather than a standard. Your own trend line is the useful thing: it shows you the year a raise got eaten by a tuition increase, and it shows you the cliff-edge saving when a child ages out.

Step 3: Now make the number do some work

A total is just a total. The reason to build it is that three decisions hang off it, and each one is worth real money.

Decision 1 — the FSA-versus-credit call

This is the big one, and it’s the decision most families get wrong by default (by doing nothing).

There are two federal ways to reduce the cost of childcare, and you can’t fully use both on the same dollars:

• A Dependent Care FSA. For 2026 you can exclude up to $7,500 from your income ($3,750 if married filing separately) — raised from $5,000 by the One Big Beautiful Bill Act, effective for tax years beginning after 31 December 2025. That money escapes federal income tax and Social Security and Medicare tax, which is why it’s often stronger than it looks.
• The Child and Dependent Care Credit. For 2026 this applies to a maximum of $3,000 of expenses for one qualifying individual or $6,000 for two or more. The percentage runs from 50% down to 20% depending on your AGI.

The catch that decides the whole thing: FSA money you exclude from income reduces the $3,000/$6,000 credit cap dollar for dollar. Elect $7,500 into an FSA with two children in care, and your $6,000 cap drops to zero. No credit at all.

For the Riveras at $120,000 AGI filing jointly, the credit percentage is 35%, so the credit route is worth $6,000 × 35% = $2,100. The FSA route, at a combined federal-plus-payroll-plus-state marginal rate of roughly 34.65%, is worth $7,500 × 34.65% ≈ $2,599. The FSA wins by about $500.

That’s not a universal answer — for a lower-income family the credit percentage can beat the marginal rate, and the credit is nonrefundable, which changes things again. The full decision, with the exact 2026 percentage ladder and three worked income scenarios, is here: Dependent Care FSA vs. the child care tax credit — which saves more.

The reason it needs a tracked annual total: you elect your FSA amount in open enrolment, months before you spend it, and dependent care FSAs are largely use-it-or-lose-it. Guessing high forfeits money. Guessing low leaves it on the table. Last year’s actual total is the only honest basis for this year’s election.

Decision 2 — is this provider actually the cheap one?

Once you have the five buckets, provider comparison stops being a tuition contest. The Riveras’ centre charges $1,450/month; a centre across town quotes $1,300. But the cheaper one has a higher registration fee, charges for meals, closes six more days a year, and bills late pickup at $25 per fifteen minutes instead of $1 per minute.

Run the true year-one number and the ranking can flip completely. Worked through in full here: how to compare daycare costs between two providers.

Decision 3 — what breaks in June

School-year childcare is a flat monthly cost. Summer is a spike, and it arrives with deposits due in February. The Riveras spend $520 a month on Liam during term and roughly three times that across the summer, plus deposit deadlines months earlier.

Tracking it lets you convert a spike into a monthly savings line. Method here: how to budget for summer childcare when school is out.

And if you’re sharing a nanny with another family — the cheapest route to in-home care and the easiest one to fall out over — the cost split needs its own arithmetic, because the employer payroll taxes and insurance are as real as the hourly rate: how to split nanny share costs between two families.

Step 4: Set the sheet up so you’ll actually keep it

Three habits make the difference between a tracker that survives to December and one that dies in March.

Log at the point of payment, not at month end. Sixty seconds when the invoice lands beats an hour of bank-statement archaeology later. If tuition is on autopay, enter all twelve months in January and only touch it if the rate changes.

Keep a running FSA balance. Your election divided across pay periods in one column, reimbursements claimed in another, balance in a third. This is what stops the November panic where you discover you have $1,900 of unclaimed FSA money and three weeks to spend it.

Keep provider details in the sheet, not in your inbox. Form 2441 requires each provider’s name, address and taxpayer identification number. Ask for Form W-10 when you enrol, not in April. A centre that changed hands mid-year will not make this easy retroactively.

A note on the tax figures above

The 2026 numbers here come from the statute itself — 26 U.S.C. §21 for the credit and 26 U.S.C. §129 for the FSA exclusion, both as amended by the One Big Beautiful Bill Act. They apply to tax year 2026, on returns filed in 2027. As of August 2026 the IRS hasn’t yet published the 2026 revision of Form 2441 or Publication 503, so check the final form before you file, and talk to a tax professional about your own situation — this is general information, not tax advice.

Putting it together

The whole exercise is one loop: log every cost per child as it happens → get an honest annual total → use that total to set next year’s FSA election, choose providers on true cost rather than sticker price, and pre-fund the summer spike. Do that and childcare stops being the line in your budget you flinch at and don’t examine.

You can build all of this yourself from the tables above — a per-child monthly grid, a five-bucket checklist, an FSA balance column and a provider comparison. If you’d rather start with it already built and formula-driven, that’s what our tracker does.