The Situation
Sarah manages a nursery in Stockport with 45 children and 18 staff. She has separate spreadsheets for DBS checks, first aid certificates, safeguarding training, paediatric first aid, food hygiene and staff-to-child ratios. Every Monday she spends 90 minutes cross-referencing these spreadsheets to check nothing has expired. Before Ofsted visits, she spends an entire day preparing compliance documentation.
The Breaking Point
A new staff member's DBS check expired without anyone noticing. The spreadsheet had the renewal date in the wrong column. Fortunately it was caught during an internal audit, not by Ofsted, but the near-miss was a wake-up call. Sarah needed a system that would not let things slip through the cracks.
The Solution
I built a single compliance dashboard that replaced all 6 spreadsheets. Every staff member has a profile showing all their qualifications, certifications and training records with expiry dates. The dashboard uses colour-coded status indicators — green for current, amber for expiring within 30 days, red for expired.
Automatic email alerts go out at 60, 30 and 14 days before any expiry. The system also tracks staff-to-child ratios in real time, cross-referencing with the rota to flag any shifts where qualified coverage might be insufficient.
The Result
Sarah's Monday morning compliance check went from 90 minutes to 5 minutes — she glances at the dashboard and deals with any amber items. Ofsted preparation takes 10 minutes instead of a full day — she exports a CSV report showing every staff member's compliance status. The system cost less than one month's agency staff fees and paid for itself within weeks through time savings.
Could This Work for Your Nursery
If you recognise any of Sarah's challenges, a similar system could solve them for your nursery. Get in touch and I will give you an honest assessment of what is possible.
Got a Spreadsheet That's Driving You Mad?
Send it over — I'll tell you what an app version would look like and what it'd cost. No obligation.