Daycare waitlist tracker

How a daycare waitlist works

A daycare waitlist is the list of families who want a place you cannot give them yet. On its own it answers one question: who asked first. Run properly, it answers the questions that keep a director up at night: which room opens next, who gets the call, and whether the next six months of enrollment are covered.

The trick is to file every family under the room their child will be in on the day they want to start, not the room that fits their age today. A five-month-old whose parents want a place in nine months is a toddler-room family by the time the slot matters. The tracker does that math from the date of birth (or due date) and the desired start, using age cut-offs you set to match your license.

1. Set the open slots for each room. Use the number you can enroll without breaking ratio or square footage, which the classroom capacity calculator works out.
2. Open the settings and change the age cut-offs to your state's age groups. The starting values (under 12, 36 and 60 months) are only a start.
3. Clear the sample list and add your families. Mark siblings, staff children and deposits.
4. Read the green rows. Those are the families next in line for the slots you still have to offer.

Writing a fair waitlist policy

Parents accept a long wait far more easily than one they think was rigged. The fix is to write the rules down and hand them out with the application, then follow them every time. Three decisions make up most of the policy.

The priority order. A common order puts enrolled siblings first and staff children second, then everyone else by the date they joined. Pick yours, publish it, and do not make exceptions on the phone. Head Start programs are held to the same idea in federal rules: they must keep a waiting list that ranks children by the program's written selection criteria, and those criteria may count the children of staff members (45 CFR 1302.14).

Fee or no fee. A small fee to join filters out families who are listing everywhere, but it also turns the list into money held against a promise you may not keep. If you charge one, say in writing whether it is refundable and whether it comes off the first month's tuition. The childcare contract template is the place for those terms once a family enrolls.

How often you re-confirm. A list nobody has called in a year is mostly families who found care elsewhere. Pick a cycle, contact everyone on it, and drop families who do not answer by a stated date. The tracker flags anyone past your re-confirm interval.

Why the list forecasts enrollment by room

Rooms fill and empty on different clocks. An infant room turns over slowly because each place carries a tight ratio (the infant daycare ratio guide covers why), while a preschool room loses a whole group to kindergarten each fall. A single list in date order hides both patterns. Split by room, the list shows you where demand is piling up and where a slot will sit empty.

That forecast feeds staffing. If the toddler list holds twice the open slots while the infant list is short, you may be better off converting a room than hiring for it. Run the head counts through the staff-to-child ratio calculator before you decide, and check the age groups in daycare ratios by state so your cut-offs match the ones your licensor uses. Age mix matters to regulators too: Head Start's federal rules set a classroom's ratio and group size by the age of the majority of its children, fixed at the start of the year (45 CFR 1302.21).

With two open infant slots, the first two rows are the next offers. Baby Chen's family is past the 90-day re-confirm interval, so they get a call either way.

Turning an offer into an enrolled family

Make every offer in writing with a reply-by date, and mark it “Offer out” in the tracker so the slot is not offered twice. When the family says yes, collect the deposit and the signed contract before you count the place as filled. Then send the paperwork: the enrollment form builder makes the packet and the parent handbook builder makes the policies they sign for.

If the date passes without an answer, move to the next family and note the call. A declined offer stays on the sheet as a record, unnumbered, so you can show any parent who asks that the order was kept. For a program still on its first waitlist, the how to start a daycare guide covers where enrollment fits in the opening timeline.