Turn your state's licensing rules into a record list, give every document an expiry date in one tracker, and have AI compare each staff and child file against that list to flag gaps. Then run a mock inspection a few weeks before the real one. The AI checks a coded tracker, never the documents themselves.
The reason to do it this way is that inspections rarely fail on big things. They fail on a first aid certificate that lapsed in March, a fire drill that was done but not logged, or a signature missing from one of thirty enrolment files. Those are exactly the faults a sheet and a patient assistant find quickly and a busy director does not.
Start from the rules, not from a template
Search results for this subject are mostly generic checklists. They are a fine prompt for your own thinking, but the inspector works from your state's licensing rules, and the rules for staff qualifications, child records, drills and postings differ between states and between types of setting. So the first job is to build your own list from the source.
- Download the current licensing rules for your type of setting (centre-based, group home, school-age) from the licensing agency. Note the date you downloaded it and the version number.
- Paste one chapter at a time into a Claude or ChatGPT Project, such as "Staff records", and ask for every item the rules say a provider must keep, post, test or report. Ask for the rule number beside each.
- Read the AI's list against the chapter. This step is not optional. Tools sometimes merge two rules or drop a condition such as "for staff working alone with children".
- Sort the result into the five families below and put them in a sheet: one row per requirement, with the rule number, the proof you keep, who owns it and how often it is checked.
Even a short rule set produces a few dozen requirement rows, and each one multiplies across every staff member or child file it applies to. That is why the sheet is the product, and the AI is the clerk that built and later checks it.
The five record families
| Family | Typical items (confirm in your rules) | How you will prove it |
|---|---|---|
| Child files | Enrolment form, emergency contacts, authorised pickup list, health or immunisation records, allergy plans, signed policies | One checklist sheet per file; a "complete" tick and date |
| Staff files | Application, qualifications, background check outcome, first aid and safeguarding training, orientation sign-off, health statement | Tracker row per person; expiry dates |
| Premises and safety | Fire drills, evacuation plan, extinguisher and alarm checks, hazard checks, water temperature or similar logs | Dated logs signed by the person who did the check |
| Daily operations | Attendance, ratios on the day, sign-in and sign-out, incident and medication logs, menus | The records themselves, sampled across a month |
| Policies and postings | Licence on display, parent handbook, discipline and emergency policies, required notices posted | A walk-round photo log and a version-dated policy index |
Where an item is filed in your records matters as much as whether it exists. An inspector asks "show me" and a two-minute hunt through five folders reads as disorganisation. The last column of your sheet should say exactly where, such as "Staff cabinet B, drawer 2, red folder" or a file path.

The Complete Excel Course with AI Integration
From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.
By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner
Buy nowCheck staff files without uploading them
Staff files are the most sensitive set you hold: identity documents, background check outcomes, sometimes health details. They do not belong in a chat tool. What works is a tracker with one coded row per person and a date or Yes/No in each column. AI looks at the tracker.
A cut-down version of the tracker, with invented codes and dates for illustration:
| Code | Role | Start | Qualification seen | Background check outcome filed | First aid expiry | Orientation signed |
|---|---|---|---|---|---|---|
| S01 | Director | 2019-04-08 | Yes | Yes | 2027-02-14 | Yes |
| S02 | Room Leader | 2021-09-01 | Yes | Yes | 2026-12-03 | Yes |
| S03 | Assistant | 2026-08-17 | Yes | No | none | Yes |
| S04 | Assistant | 2024-01-22 | No | Yes | 2026-11-20 | No |
Export it as CSV or copy the cells, then use a prompt like this:
Below is a staff records tracker for a daycare. Today is [date].
Our licensing rules require: qualification seen, background check outcome
filed, first aid valid, orientation signed before unsupervised work.
1. List every person with a missing item, one line each: code, item, why it matters.
2. List first aid expiries within 60 days, soonest first.
3. Flag anyone whose start date is before today and has "none" for first aid.
4. Do not guess. If a cell is blank or unclear, say "unclear".
Tracker:
[paste]
On the four rows above, an assistant should report that S03 has no background check outcome filed and no first aid certificate, that S04 has no qualification seen and no signed orientation, and that the first aid certificates for S02 and S04 both expire within 60 days if today is early November. It should say nothing else. If it reports more, it is inventing, and you tighten the prompt.
The wider question of what staff may and may not paste into chat tools sits in what a daycare can and cannot put into ChatGPT.
The expiry tracker that reminds you before the date
A tracker only helps if something nudges you. Two cheap pieces do that, and neither needs AI at runtime.
A formula in the sheet. In Google Sheets or Excel, add a status column. If the expiry date is in column F and today's date should drive the result:
=IF(F2="","MISSING",IF(F2<TODAY(),"EXPIRED",IF(F2-TODAY()<=60,"DUE SOON","OK")))
Add conditional formatting so EXPIRED is red and DUE SOON amber. The director opens the sheet on Monday and the colours do the reading. Our Google Sheets AI prompts tutorial covers how to ask an assistant for a formula like this, and how to check it.
A calendar reminder. For each expiry date, create a reminder 60 days and 14 days ahead, addressed to the director. Google Calendar can import events from a CSV file in which only two columns, Subject and Start Date, are required (the help page says the headers must be in English), so one export from the tracker creates all the reminders at once. Each row arrives as a one-off event, and the help page's example date is written month first (05/30/2020), so test a single row and check it lands on the right day before you import fifty.
AI does the part in between: once a quarter, it reads the tracker and writes a short note of "what needs doing in the next 90 days, by owner". That note is the thing the director forwards to the people concerned.
Main worked example: a nine-person centre, one afternoon
Consider an illustrative centre with 38 children and nine staff, six weeks before an expected visit. The director builds the sheets from the licensing rules: 12 items per staff member (108 checks) and 9 items per child file (342 checks for 38 files), plus 14 premises and policy items. That is 464 checks. She enters the data, a task that takes about two hours with the files in front of her, because the sheet is mostly Yes, No or a date.
The AI then checks the tracker and returns a gap list. In this example it finds 21 problems:
- 3 staff files missing one document each (two orientation sign-offs, one qualification copy).
- 2 first aid certificates expiring within 45 days.
- 7 child files with an incomplete item (four missing a signed policy page, two with an out-of-date emergency contact, one without an allergy plan although the enrolment form says "allergy").
- 5 premises logs with a gap: two fire drills not logged in the last quarter, three weekly checks missed.
- 4 notices that were not up to date on the wall in the walk-round photo log.
The director fixes 14 within the week: signatures, copies, a booking for the two first aid renewals. The remaining seven go into the corrective-action log with an owner and date. The work that once took two days of file-flipping now takes an afternoon plus the fixes, and the director goes into the visit knowing the real gaps, not guessing at them. The numbers are an illustration, not a benchmark, but the shape is typical: many small gaps, a few that matter, and a handful of dull jobs to clear.
A mock inspection that uses staff, not just paper
Inspectors do not only read files. They ask staff questions and watch routines. A mock inspection tests that, and AI is a decent inspector for the first draft of the questions. Give it the relevant rules chapter and ask for twelve questions an inspector might put to each of: the director, a room leader, an assistant, the cook.
Some examples of the kind of question you want (illustrative, check them against your own rules):
- To the director: "Show me the last three fire drills, who led them and the time it took to clear the building."
- To a room leader: "What is your ratio now, and what would you do if one of you had to leave the room for ten minutes?"
- To an assistant: "A parent you don't recognise says she is collecting a child. What do you do?"
- To the cook: "Which children in the building have food allergies, and where is that listed?"
- To anyone: "Where is the first aid kit, and who here holds a current first aid certificate?"
Then run it as a role-play. A second member of staff plays inspector, reads the questions, and notes each answer as Confident, Hesitant or Wrong. Do not let an AI listen in on the room: use it afterwards, with no names, to turn the notes into a short training list.
What a hesitant answer tells you
A hesitant answer almost always means there is no written place the member of staff can point to. If an assistant cannot say where the allergy list is, the fix is not a lecture; it is a laminated list in the kitchen and a line in the orientation checklist. Ask the AI to draft the one-page "know-where" sheet from the answers.
The corrective-action log
When a gap is found, by you, by the AI or by an inspector, it goes in a log. One log, one row per issue, kept for as long as your rules and insurer require. This is the document that turns a finding into evidence that you manage your own standards.
| Ref | Found | Issue | Rule | Action | Owner | Due | Closed, with proof |
|---|---|---|---|---|---|---|---|
| CA-014 | Mock check, 3 Nov | Two fire drills not logged in the last quarter | (rule number) | Hold a drill, log it; add the drill to the monthly calendar | Director | 10 Nov | Drill log page, signed 9 Nov |
| CA-015 | Tracker, 3 Nov | Orientation sign-off missing, S04 | (rule number) | Walk S04 through orientation, sign and date on the day it happens | Room Leader | 7 Nov | Signed form, filed |
Note the wording in the second row: the sign-off is dated on the day it happens. A late signature is a gap you then closed; a back-dated signature is a falsified record, and no tool or template changes that. When an inspector does write findings, paste the text without names into your Project and ask for the log rows, then edit them. If a written corrective-action plan is requested, the assistant can draft the plan from the log in the inspector's own headings.
Child files: a sampling method and a filled-in sheet
With 38 children, checking every file every month is overkill, but checking none is how gaps hide. Check a rotating sample instead: shuffle the list of file codes once (a column of random numbers in the sheet, sorted, does it), then work down that list ten files a month rather than picking whichever folders are on top. With 38 files, every file has been seen within four months, the order still cannot be predicted, and new enrolments are always checked in their first week.
Each file gets the same one-line check. Here is a filled-in version for one illustrative file, using a code in place of the name:
| Item | Result | Note |
|---|---|---|
| Enrolment form signed and dated | Yes | Signed on start date |
| Emergency contacts: two, both reachable | Yes | Tested by text on 12 Oct |
| Authorised pickup list matches front-desk copy | No | Grandparent added in July on desk copy only |
| Health or immunisation record present | Yes | Next update due 14 Jan |
| Allergy plan matches kitchen list | N/A | No recorded allergy |
| Policies page signed | No | Photo-consent page missing |
Two "No" results, and neither is a disaster. But the pickup list mismatch is the kind of thing that matters on a real afternoon, and it only surfaced because someone compared two copies. A tool can run that comparison on coded lists in seconds: paste two lists of authorised-adult codes for the same child and ask which codes appear in only one. Keep the real names out; the codes are enough to flag a mismatch.
Asking AI to turn the rules into the checklist, with a sample result
This is the first prompt of the whole routine, so it is worth getting right. Paste one rules chapter, then:
From the text below, list every record a child care provider must keep,
post or complete. For each, give: the rule number as written, the exact
record, how often it must be done or renewed, and any condition
(for example "only for children under two"). Quote the rule's own words
for the frequency. If the text does not say, write "not stated".
Do not use anything outside the text.
[paste chapter]
A good answer on a made-up extract ("Rule 12: A provider shall hold an emergency evacuation drill every month and record the date, time and number of children present") would look like: Rule 12, evacuation drill, monthly, "every month", record date, time and number of children present. You then add the "proof" and "where filed" columns yourself. A bad answer adds "and test the alarm" because most rule sets include it somewhere. If it is not in your text, it does not go in the sheet, or it goes in a separate "good practice" list so it never gets confused with a licensing requirement.
Walk the building with the checklist
Records are half of the visit; the rooms are the other half. Once a quarter, walk each room and the outdoor area with the premises sheet and take dated photos of postings and exits for your own file, with no children in the frame. Typical walk-round items: licence displayed, emergency numbers and evacuation plan posted at child height or as required, exits clear, first aid kit stocked and in date, cleaning chemicals locked, outdoor equipment checked. Your rules decide the exact list.
The photos feed the AI step too. You can ask a tool to compare a photo of the notice board against the list of required notices and say which are missing, but only with an image that shows the wall and nothing else. Treat the answer as a prompt to look, not a result, since image reading misses small print and dates.
Where AI misreads your rules and tracker
- Invented requirements. It states a rule number or a retention period that is not in the text you pasted. Rule: it may only cite what you gave it, and you check each citation.
- Mixed states. Asked from memory, it will blend several states' rules. Never ask it what "the rules say" without the text in front of it.
- Treating a blank as a Yes. A blank cell in the tracker can be read as "not applicable". Make the sheet use "N/A" explicitly and tell the tool a blank is a gap.
- Date confusion. 03/11 means 3 November in some places and 11 March in others. Store dates as 2026-11-03 in the tracker so there is only one reading.
- Counting the wrong person. Cover staff and volunteers often have different requirements from permanent staff. Add a role column and say so in the prompt.
The folder and the walk-through for the day itself
Preparation helps on the day if it is visible. Keep an "inspection folder" in one place: a one-page index of where each record family lives, the licence, the current policy list with version dates, the last quarter of logs, and the corrective-action log. Decide in advance who walks round with the inspector and who covers their room. Ratios are looked at on the day, so see planning a ratio-compliant daily schedule for building a rota that holds at peak times.
For nursery-style settings that are inspected against a wider framework, the pattern is the same; the sibling on building an evidence folder for a nursery inspection shows how to organise evidence by theme.
The monthly routine that keeps you ready
- Update the tracker with new starters, leavers and renewed certificates.
- Ask the AI for the 90-day action list and forward it to owners.
- Check the month's ten sampled child files and five days of attendance against the checklist.
- Close or escalate any corrective-action log rows past their due date.
- Once a quarter, run the mock questions and pick two staff to coach.
If you want the sheet, the reminders and the monthly AI note set up around your own software, that is what an AI implementation consultation is for.
What stays with the director
Interpreting an ambiguous rule, deciding whether something is reportable, and talking honestly with the inspector. AI can make you better prepared, but it cannot tell you what your licensing officer meant, and an inspector will always prefer a director who knows the rule to one who read it from a summary.
Before you hand records to an AI tool
Can AI read my staff files directly?
It can, but it should not need to. Staff files hold identity documents, background check results and sometimes health details. Build a tracker with one row per person and a Yes, No or date in each column, then let AI check the tracker. The documents stay in your locked cabinet or secure drive.
Can AI tell me what my state requires?
It can summarise rules you paste in, which is useful for building the checklist. It cannot be trusted to recall your state's requirements from memory, because rules differ and change. Paste the current text from your licensing agency and check every line it produces against that text.
How often should we run a mock inspection?
Once a quarter is a sensible rhythm for most settings, plus a lighter monthly tracker check. Run an extra one after any change of director, any new room or after a real inspection that found issues.
What if the tracker shows a gap the day before an inspection?
Fix what you can honestly fix, and log the rest in the corrective-action log with a date. Never back-date a document. An inspector who finds a dated fix and a plan is far less concerned than one who finds an altered record.
Further reads
- Daycare Incident Reports With AI: Factual, Name-Free Narratives — Incident files are among the first things an inspector asks for.
- Childminder Paperwork Checklist: Which Records to Keep, and Where AI Helps — A parallel records checklist for home-based childcare.
- Can AI Write a Nursery Self-Evaluation Form From Your Evidence? — Turn your evidence into a written self-assessment.
- AI for Daycares: Nine Admin Jobs From Enquiry to Pickup Message — More admin jobs where a structured sheet plus AI saves hours.
- Early Years AI Policy Template for Nurseries and Childminders — The policy an inspector may ask about when you say you use AI.
- Nursery Data Protection Policy: Draft and Update It With AI — Keep the records themselves covered by a current data policy.
- Adult Day Care Software for a Small Centre: Billing and AI Notes Checklist — A grouped checklist for a small adult day centre choosing software for attendance, transport, billing and care notes, with AI drafting kept under review.
- After School Club Booking System: Bookings and AI Reminders — Compare free, generic and dedicated booking tools for an after school club, then use AI to draft reminders without exposing children's details.
- Brightwheel vs Procare: Which Daycare Software Has Real AI? — Brightwheel's AI assistant against Procare's RoomRunner and Camber, with quote-only pricing questions and a scored demo for a small daycare.
- Child Care Subsidy Billing: Can AI Match Payments to Attendance? — How a daycare can match subsidy remittances to attendance with AI-built formulas, find shortfalls and write top-up notices without names.
- How to Start a Preschool: First-Year Costs and Where AI Fits — A first-year cost table for a small preschool, the licensing route, enrolment targets, and the forms and parent messages AI can draft from day one.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: your own state's child care licensing rules and the licensing agency's inspection guidance (check the current text); Google Sheets function list and the Google Calendar help page on importing events from a CSV file (checked November 2026).