Daycare Tour Inquiry Tracker Excel Workbook

How this workbook can help

• Keeps prospective-family inquiries, tour details, follow-up dates, and enrollment outcomes in one structured record.
• Helps staff identify overdue or upcoming follow-ups and incomplete tour information without manually reviewing every date.
• Provides calculated indicators for inquiry volume, scheduled and completed tours, open records, enrollment outcomes, conversion rate, and average days open.
• Allows childcare-center operators to update administrative settings and dropdown choices as programs, staff assignments, and intake practices change.

What is in the file

How to get started

1. Review the administrative settings

Open the Assumptions sheet and review the follow-up due-soon period, open-age review period, accepted date limits, tour-time limits, and dropdown choices. Update the yellow input cells when the center's practices, programs, staff assignments, or available choices change.

2. Enter each prospective-family inquiry

Use one row on the Inquiries sheet for each inquiry. Assign a unique Inquiry ID and enter the prospect label, inquiry date, preferred contact method, program interest, desired start date, referral source, assigned staff member, and relevant notes.

3. Maintain tour and follow-up details

Update the tour status, date, and time as plans change. Enter the follow-up due date and completed date, then review the formula columns for days open, follow-up alerts, tour checks, and record checks. Resolve prompts by correcting or completing the related input fields.

4. Record the outcome and review the summary

Select Open, Waitlist, Enrolled, Declined, or No Response and enter an outcome date when appropriate. Use the Summary sheet to review current inquiry activity, future scheduled tours, follow-ups due now, outcome counts, decision conversion rate, average days open, and records needing review.

A Structured Inquiry-to-Outcome Workflow

A childcare inquiry can involve several dates, staff handoffs, and family decisions. The workbook creates a single operational record for the inquiry date, desired start date, tour status, tour appointment, follow-up activity, outcome, and notes. Staff can filter the Excel table to focus on a program, assigned employee, tour status, referral source, or outcome while retaining the full history in the same row.

Practical Example: From Tour Request to Enrollment Decision

Situation: A fictional preschool prospect inquires on August 10 and requests an October 5 start date. Action: Staff enter the inquiry, complete the tour on August 13, record the follow-up as completed on August 14, and enter an Enrolled outcome dated August 20. Result: The Days Open formula reports 10 days open, the Follow-Up Alert reports Closed, and the completed record contributes to the enrolled outcome count. Interpretation: The record shows that the family moved from inquiry to a recorded decision within ten days and that the planned follow-up was completed. Next decision: Staff can review similar records to decide whether current tour and follow-up timing is supporting timely decisions or whether open inquiries need earlier attention.

Using Follow-Up and Tour Prompts

The Follow-Up Alert can return Closed, Complete, Set due date, Check date, Overdue, Due today, Due soon, or Upcoming. The due-soon window comes from the Assumptions sheet and is initially set to three days. The Tour Check can prompt staff to add a tour date, add a tour time, check a status, or check a future completion date. These messages are administrative cues; staff should inspect the underlying inquiry before contacting a family or changing a record.

Common Entry Errors and Their Solutions

A duplicate Inquiry ID should be replaced with a unique identifier because column A includes duplicate checking. If a scheduled or completed tour lacks a date, add the date or correct the tour status; if a tour date exists without a time, enter the time. If the follow-up alert says Set due date, add an appropriate due date; if it says Check date, replace text or an invalid value with an accepted Excel date. A Record Check message can indicate a missing prospect label, missing or invalid inquiry date, or a start, tour, follow-up, or outcome date that precedes the inquiry date. Correct the source field rather than overwriting the formula prompt.

Workbook Comparison: Excel Tracker vs Other Methods

This comparison treats the three-sheet workbook as one complete operational method rather than comparing its worksheets with one another.

The choice depends on inquiry volume, staffing, collaboration needs, budget, and whether the center needs only a focused tracker or a larger enrollment system.

Data Handling and Administrative Boundaries

The sample records and staff names are fictional and should be replaced before operational use. Because the workbook may contain prospective-family information, the center should determine what details are appropriate to record, where the XLSX is stored, who can access it, and how long records are retained. The alerts and checks support administration but do not establish licensing, privacy, enrollment, or record-retention requirements.

Turning Summary Indicators Into the Next Decision

The Summary sheet reports inquiries logged, inquiries from the last 30 days, future scheduled tours, completed tours, follow-ups due now, open or waitlist inquiries, enrolled outcomes, decision conversion rate, average days open, and records needing review. Operators can use these indicators for human review: a rise in due follow-ups may call for reassignment, several records needing review may call for data cleanup, and a large open or waitlist count may call for a capacity or communication review. The conversion rate includes Enrolled, Declined, and No Response decisions while excluding records that remain open, waitlisted, or unset.

Frequently asked questions