Key takeaways
- Late pickup minutes become fees on the weekly invoice.
- The family portion is tuition net of the subsidy expected.
- The daily ratio is checked against your licensed maximum.
- Each family's account reads Current, Behind or Well behind.
A home daycare in Fort Collins has seven children, an owner, an assistant and a substitute on call. On a Wednesday in August the assistant is out sick, all seven children turn up, and for one day the house is over its licensed ratio. Nobody noticed at the time. The same week, two families paid short and a subsidy claim came back denied for a missing signature. DaycareDesk US records those days and those dollars so the owner sees them on Friday rather than at renewal.
Late pickups become fees
Attendance records the hours each child was there and the minutes a pickup ran late, and the late fee derives in fifteen-minute blocks at the rate stored on the family's record.
That fee then lands on the family's invoice for the week, which is the difference between a late fee policy in the handbook and a late fee that gets collected.
Tuition net of the subsidy
Each weekly invoice carries the tuition due and the subsidy expected for that family, and the family portion is the difference, so a subsidized family is only ever asked for their share.
Subsidy claims live on their own sheet with the amount claimed, received and the status, so a claim denied for a missing signature is a receivable you can see rather than money you assumed was coming.
The ratio, checked every day
The daily ratio sheet counts children present from attendance and adults from staff shifts, divides one by the other and compares it to the licensed maximum you enter for the day.
A day that reads Over ratio is a day to explain, and finding it yourself on Friday is a very different conversation from a licensing visit finding it in October.
Who is behind, and by how much
The family summary totals tuition billed, subsidy expected, late fees, what the family was billed and what they paid, and labels the account Current, Slightly behind, Behind or Well behind.
Staff shifts carry an hourly cost, so the week's labor is a figure beside the week's tuition, which is the number that decides whether a second assistant is actually affordable.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
DaycareDesk US Google Sheets Edition is designed for use with a Google account and current desktop Google Sheets.
No state licensing or compliance filing, no subsidy program portal integration, no payroll or tax withholding for staff, no parent app or check-in kiosk, and no child health, immunization or incident records.

