Home Daycare Spreadsheet: Tuition, Attendance and the Time-Space Percentage

There are four numbers a home daycare provider almost never has, and all four of them are worth money.

How much tuition is outstanding right now. How much she has earned in late pick-up fees and not billed. How many licensed slots are sitting empty. How much of her own household bill is a business deduction.

None of them are hard. They are just spread across a paper calendar, a text thread, a shoebox of receipts and a memory of something her tax preparer said in March.

Every figure on this page comes from one fully worked sample daycare — eleven children, ten of them currently enrolled, 552 logged days, 30 invoices and 15 licensing deadlines. The dollars are mine, chosen to be typical of a licensed family childcare home running at ten children. The structure is the point, and the structure is the same whether you charge $150 a week or $350.

Here is what that daycare’s year looks like when the arithmetic is actually done:

That last line is a third smaller than the one above it, and the difference is a single percentage that most general bookkeeping templates have never heard of.

The Four Things a Generic Bookkeeping Template Cannot Do

A small-business bookkeeping sheet gives you income in, expenses out, profit at the bottom. That is genuinely most of what a freelancer needs. A childcare home needs four more things, and they are the four that take the time:

1. Attendance, because your fee is contracted but your day is not, and because a licensing inspector will ask for it.
2. The time-space percentage, because your business and your house are the same building.
3. Capacity against licence, because an empty approved slot is the most expensive thing in the business.
4. Compliance dates, because a lapsed certificate closes you.

Everything below is built around those four.

One Child, One Row

The roster is the spine of the whole thing. Every other tab reads from it, which means it is the only place a rate or a phone number should ever be typed.

A row that works holds:

• Child and parent names, plus a second emergency contact and the authorised pick-up list — the thing you need in eleven seconds, not eleven minutes
• Start date, age band and schedule (full-time, part-time, the specific days)
• The rate, typed once here and pulled by every invoice
• Sibling discount flag — 10% in the worked daycare, applied automatically rather than remembered
• Allergies and medical notes
• Immunisation status — a flag, not a folder

And then five things the sheet works out and you never type: hours logged, absences, late fees earned, billed to date, paid to date, and the balance between the last two.

That balance column is the one that changes how the business feels. In the worked daycare, five invoices carry an unpaid balance totalling $3,947.00, and three of them are already past the provider’s own ten-day window. Nobody decided not to pay. The invoices simply left the provider’s head the moment they left her hand.

Attendance: Contracted Hours Against Actual Hours

552 days logged. 473 attended, 52 absences, 27 days closed. 4,062.6 hours of care.

Two of those numbers do work beyond the licensing file.

Absences tell you whether your contract is doing its job. 52 absences across the 525 days the daycare was open is about 9.9% — normal, and in almost every home daycare contract those days are billed anyway, because your costs did not go anywhere. If you find yourself crediting absences informally, the absence count is the number that shows you what that habit costs: 52 days at a $212 weekly rate is roughly $2,200 of tuition a year you may or may not have decided to give away.

Actual hours against contracted hours tells you where your rate is wrong. A child contracted for 40 hours who is consistently in the house for 46 is not an administrative problem, it is a pricing problem, and it will not show up anywhere else in your books because the tuition is identical either way.

Log it daily. A month reconstructed on a Sunday night is a month of guesses, and guesses are exactly what an inspector is trained to notice.

Tuition That Chases Itself

An invoice is four things the sheet already knows and one thing you type:

• The child, which brings its own rate from the roster
• The billing period
• The sibling discount, if the flag is set
• Late pick-up fees accrued in that period, pulled straight from attendance
• And the amount you actually charged, if it differs

Then one more thing the sheet does on its own: an invoice that passes your overdue window flags itself. Ten days in the worked daycare. Not thirty, not “when it feels awkward” — a number set once on a settings tab, applied identically to the family you like and the family you find difficult.

That is the entire mechanism behind the $3,947.00. It is not a collections system. It is a list that exists on a Monday morning without anyone having to remember to make it.

The $807 Nobody Bills

Every home daycare handbook has a late pick-up fee. Almost none of them collect it, and the reason is not softness — it is arithmetic at 5:47 on a Friday while holding a toddler.

The worked daycare’s setting: ten minutes’ grace, then $1.00 per minute. Over the year that produced 807 chargeable minutes and $807.00 in fees — about 3.3% of its entire tuition income, from a policy that was already written down and already agreed to.

The trick is not enforcement. It is that you type the actual pick-up time into the attendance row, the same way you type everything else, and the fee lands on the next invoice without a conversation at the door.

The policy itself — grace periods, per-minute versus flat fees, what the handbook clause should say and how to raise it without losing a family: home daycare late pick-up fee policy.

The Time-Space Percentage

This is the single most valuable number in in-home childcare, and the one most likely to be wrong or missing entirely.

Your house is your business premises for part of its area and part of its time. The time-space percentage is those two fractions multiplied together, and it is what converts ordinary household bills into a business deduction.

In the worked daycare:

Applied to $36,088 of household costs — rent or mortgage interest, property tax, insurance, electricity, gas, water, internet, repairs, lawn care, security — that returns $7,946.80.

Two things about the 58 hours. First, it is not just care hours: prep, cleaning, cooking, shopping for the daycare, record-keeping and parent communication all happen in the house for the business. Second, it is the input people most commonly understate, and every hour of it is worth roughly $137 of deduction in this example. Keeping a record of those hours for a few representative weeks is one of the highest-paid pieces of paperwork in the business.

The full calculation, including which rooms count as regular business use, how to handle a room used only part of the time, and the four mistakes that make the number too small: time-space percentage calculator for home daycare.

The Food Program

Meals and snacks served, priced at your current reimbursement rates. In the worked daycare, 57 logged meal rows at $1.66 for breakfast, $3.12 for lunch and $0.93 for a snack, running to $3,140.72 of reimbursement over the year.

Two rules keep this clean. Rates change, and they differ by program, tier and region — so they belong in a settings cell you type, never inside a formula. And reimbursement is income, not a discount on your grocery bill: it goes on the income side, and the food you bought goes on the expense side. Netting them against each other is the most common way this line gets misreported.

The Empty Slot

Licensed capacity 12. Currently enrolled 10. Two open slots, four families on the waitlist. A fill rate of 83.3%.

That is the most expensive line in the business, and it never appears on a profit and loss statement because nothing happened. At a $212 weekly rate and fifty weeks open, one empty approved slot is $10,600 of tuition a year — more than twice the worked daycare’s entire annual expense budget.

A capacity tab does two things about it: it shows slots by age band against who is actually in them, so you know whether the gap is a licensing constraint or a marketing one, and it keeps the waitlist with deposits held and days waiting, so the call you make when a family gives notice takes thirty seconds rather than a week.

What the rate itself should be, and what a given weekly rate actually pays you after expenses and self-employment tax: how much to charge for home daycare.

Compliance: Fifteen Dates in One Place

Licence renewal. Annual inspection. Background check. Paediatric CPR. Food handler certificate. Fire extinguisher service. Alarm checks. Evacuation drills. Consent forms. Immunisation records.

Fifteen tracked dates in the worked daycare, with days remaining against each one. Right now: none overdue, six inside the alert window, and two enrolled children with no immunisation record on file — which is, reliably, the first thing an inspector opens with.

The value here is not the countdown. It is that the list exists at all, in the same file as everything else, so that “when does my CPR expire” is a glance rather than a search.

The January Statement

Every family asks for their year-end total in the same week, and every provider answers it by scrolling back through a payment log.

It is a dropdown. Pick the child, and the statement fills in your business name, your taxpayer identification exactly as you want parents to record it, a month-by-month breakdown of what that family actually paid, and the annual total. Then pick the next child.

What the statement has to contain, what IRS Form W-10 is for, and why a provider hands over a taxpayer number at all: year-end daycare tax statement for parents.

The Rhythm That Makes It Work

None of the above survives good intentions. It survives a routine:

• Daily, two minutes. Attendance in, actual pick-up times in, meals ticked.
• At each billing date, ten minutes. Generate the invoices, send them. The sheet has already applied the discounts and the late fees.
• Weekly, five minutes. Look at two lists: who is overdue, and what compliance date is inside the alert window.
• Monthly, twenty minutes. Receipts entered and marked Direct or Shared. Mileage logged at your own rate.
• Once a year, an hour. Update the time-space hours, print the parent statements, close the file.

That is roughly forty minutes a month against a $3,947 receivable, an $807 fee line, a $7,947 deduction and a $10,600 empty slot.

The Point

A home daycare is not a small business that happens to involve children. It is a business whose premises are a home, whose capacity is set by licence, whose revenue is contracted but whose hours are not, and whose largest single deduction is a percentage nobody else has to calculate.

Track it like a generic small business and you will get a profit line that is roughly a third too high and a licensing folder you dread.

Track those four things — attendance, time-space, capacity, compliance — and the four numbers you could not see become four numbers you act on.

The rest of this series

• Time-space percentage calculator for home daycare — the two fractions, a worked 22.02%, which rooms and hours count, and the four mistakes that shrink the number.
• How much to charge for home daycare — working a weekly rate backwards from take-home, with expenses and self-employment tax in the table.
• Home daycare late pick-up fee policy — grace periods, per-minute versus flat, the handbook clause, and how $807 goes uncollected.
• Year-end daycare tax statement for parents — what the statement contains, what Form W-10 is, and the January week it saves.

Featured on ReadySheetGo

Home Daycare & In-Home Childcare Provider Business Tracker — $18.99

Fourteen linked tabs and 4,451 working formulas — the daycare above, pre-filled with 11 children, 552 logged days, 30 invoices, 27 expenses and 15 compliance deadlines, so you can see it running before you type anything.

Settings holds capacity, hours, late pick-up grace and fee, sibling discount, overdue window, mileage rate, food reimbursement rates, floor area and business hours — nothing is hard-coded anywhere else in the workbook. Children carries contacts, allergies, the authorised pick-up list and an immunisation flag, and returns hours, absences, late fees, billed, paid and balance per child with an Action Needed column. Attendance sets contracted hours against actual hours and prices late pick-ups to the minute. Tuition builds invoices that pull in the rate, the sibling discount and that period’s late fees, then flag themselves OVERDUE on your own schedule; Payments feeds balances back to three other tabs.

Capacity & Waitlist sets licensed slots by age band against who is enrolled, with deposits held and days waiting. Expenses marks each cost Direct or Shared home and works mileage at your own rate. Time-Space shows the calculation step by step and applies it to every household line. Food Program prices meals and snacks at your current rates. Compliance counts down licence, inspection, insurance, certification and immunisation dates, gold at due soon and red at overdue. Parent Statement produces a family’s year-end total from a dropdown. Plus Dashboard, Start Here and Lists.

Not a single hard-coded tax rate, mileage rate, reimbursement rate or deadline anywhere — every one is a labelled cell you type, and the file re-prices itself the moment you change it.

Works in Excel and Google Sheets. No array formulas, no macros, no add-ons. It is a record-keeping tool, not tax advice.

Get the Home Daycare & In-Home Childcare Provider Business Tracker →