Time-Space Percentage Calculator for Home Daycare: How to Work It Out

Your house is two things at once. For part of its area, and part of its week, it is a childcare business. The time-space percentage is the number that says exactly how much, and it is what converts ordinary household bills into a business deduction.

It is also the number most likely to be missing, guessed at, or quietly understated by a third.

Here is the whole calculation, worked end to end on one sample daycare. The figures are mine and chosen to be typical of a licensed family childcare home; the method is the part to copy.

The Two Fractions

Space percentage = business-use floor area ÷ total floor area.

Time percentage = hours a week the home is used for the business ÷ 168.

Time-space percentage = space × time.

That is it. Everything difficult about this number is in deciding what goes into those four inputs.

The Worked Calculation

Now apply it. The household costs below are the ones that are genuinely shared — the bills you would be paying anyway, that the business is partly responsible for:

Almost eight thousand dollars, out of bills that were already leaving the account.

Two things make this arithmetic worth automating rather than doing once with a calculator. The percentage touches twelve lines, so a corrected input means twelve corrections. And the percentage itself changes when your hours change, which they do.

What Counts as Business-Use Area

The rule that trips people up is the exclusive-use test: for most home businesses, a space only counts if it is used only for the business. Daycare providers are the well-known exception to it in the United States — the conditions and the mechanics are set out in IRS Publication 587, Business Use of Your Home (Including Use by Daycare Providers), and the deduction itself is reported on Form 8829. Outside the US the treatment is different, sometimes very different, so check what applies where you file before using any of this.

Under that exception, a room does not have to be daycare-only to count. What it has to be is regularly used for the daycare. In practice that usually means:

• Counts: the play area, the room children nap in, the kitchen (meals are prepared there), the bathroom children use, the entry and hallway they walk through, the laundry room if daycare laundry is done there, the basement if it is part of the operation, and storage space holding daycare supplies.
• Usually does not: your own bedroom, a home office used for a different job, a locked room children never enter, a garage used only for cars.

Measure it once, write the measurements down with the date, and keep that note with the calculation. The single most useful thing about the space fraction is that it does not change from year to year — which means the year you actually measure it properly is the year you stop guessing forever.

What Counts as Business Hours

This is where the money is, and where the mistakes are.

The time fraction is not “hours children are present.” It is hours the home is being used for the business. In the worked daycare, 58 hours a week breaks down like this:

Strip out everything except children-present hours and the time percentage falls from 34.52% to 26.79%, the time-space percentage falls to 17.08%, and the deduction falls from $7,946.80 to $6,165.81. That is $1,781 of deduction lost to a definition.

The evidence problem is real and it has a simple answer: track those non-care hours honestly for two or three representative weeks a year — a tally on the same sheet, not a reconstruction in April — and keep the record. A calculation is only as good as the input you can show.

Four Mistakes That Shrink the Number

1. Counting only the playroom. Providers routinely measure the one room that looks like a daycare and ignore the kitchen, bathroom, hallway and laundry that the operation could not run without. In the worked home, the playroom alone is 420 sq ft — a 22.70% space percentage instead of 63.78%, and a time-space percentage of 7.84%. Same daycare, one third of the deduction.

2. Counting only children-present hours. Worth $1,781 in the example above.

3. Putting the percentage inside formulas instead of in one cell. When the number changes — and it changes the year you open an extra day — you want to retype it once, not chase it through twelve rows.

4. Applying it to direct expenses. A cost that is wholly for the daycare — art supplies, cots, licensing fees, a child-height table, the food program groceries — is not shared. It is 100% business, and prorating it at 22.02% throws away most of it. This is the mistake that runs in the other direction, and it is the most expensive one of the four.

That last point is why every expense row needs a Direct or Shared marker before it needs anything else. Direct costs go in whole. Shared costs get the percentage. The sheet should never have to guess which is which.

A Copy-Ready Worksheet

Six cells. Put them somewhere permanent:

A. Business-use floor area (sq ft)          ______
B. Total floor area (sq ft)                 ______
C. Space percentage                = A / B  ______
D. Business hours per week                  ______
E. Time percentage                = D / 168 ______
F. TIME-SPACE PERCENTAGE          = C × E   ______

Then one table of shared household costs, each multiplied by F, and one expense log with a Direct/Shared column so the two never get mixed.

A note on the alternative: some providers use the simplified method for the home deduction instead, which multiplies business square footage by a set rate rather than costing the bills. The rate and the square-footage cap are set by the IRS and change, and daycare providers using it still have to reduce the area by the time percentage — so the time fraction above is work you do either way. Which method leaves you better off is an arithmetic question you can only answer by running both, which is another argument for having the shared-cost table sitting there already.

Where this fits in the rest of the books — attendance, tuition, capacity and compliance: the home daycare spreadsheet.

Featured on ReadySheetGo

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

A dedicated Time-Space tab walks the calculation step by step — floor area, business area, business hours, the two percentages and the product — and then applies the result to every shared household line: rent or mortgage interest, property tax, insurance, electricity, gas, water, internet, repairs, lawn care and security. Change one input and all twelve lines re-price.

The Expenses tab carries the Direct-or-Shared marker that keeps the percentage off the costs it does not belong on, and works mileage at whatever rate you type. Around them: a Children roster, Attendance with late pick-ups priced to the minute, Tuition invoices that flag themselves overdue, Payments, Capacity & Waitlist, Food Program, Compliance countdowns, a Parent Statement and a Dashboard — 14 tabs and 4,451 working formulas, pre-filled with a full sample daycare.

Nothing is hard-coded: every rate, threshold and deadline is a labelled cell on the Settings tab.

Works in Excel and Google Sheets. No macros, no add-ons. It is a record-keeping tool, not tax advice — what you can deduct depends on your own circumstances and your own country’s current rules.

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