Your privacy choices

KiwiBee uses optional Google Analytics, Google Ads, and Meta Pixel cookies to understand adult visitors, measure completed sign-ups, and improve campaigns. Essential cookies always stay on. OpenAI’s ChatGPT Ads Pixel also measures page views and completed enquiries after advertising consent, and may use hashed contact details for matching. Privacy policy

Skip to main content
Excel template

Enrolment and Waiting List Tracker

What's inside

A preview of the first rows. The file adds drop-down lists, formulas that fill in by themselves and room for more rows.

Applicants and waiting list

Days waiting counts from the application date to today.

No.Application dateChild's nameYear groupParent / guardianContactStatusOffer dateDays waitingNotes
Example: Sam LeeYear 3Kim Leekim@example.comWaiting list

Sheet: Applicants · 100 rows

Places by year group

Places free = capacity - enrolled. % full = enrolled / capacity.

No.Year groupCapacityEnrolledPlaces free% fullOn waiting list
Example: Year 330284

Sheet: Places · 15 rows

How to use it

  1. List each applicant on the Applicants sheet with their year group and status.
  2. Update Status as they move from waiting list to offered to enrolled.
  3. On the Places sheet, enter capacity and the number enrolled for each year group.
  4. Read Places free and the days on the waiting list.

About this document

For registrars and admissions teams. Keep one list of every applicant, whether they are enrolled or waiting, and how long they have been on the list. A second sheet tracks places by year group.

Comments

    Enrolment and Waiting List Tracker – Free Excel Template | KiwiBee