Mentor Match & Closure Tracker
Mentors, mentees, matches, a full contact log and — the part almost every program skips — a closure log. Last contact is not a column somebody updates out of habit: it is read from the contact log with MAXIFS, so a match cannot look current when it stopped meeting in March. The summary counts matches with no contact ever logged, matches overdue against your own interval, unplanned closures, and closures with no exit interview recorded.
- Mentor readiness that computes from screening and training
- Contact recency read from the log, not typed
- Closure log with exit-interview tracking
A match with no logged contact for longer than this gets flagged. Leave blank for 30 — you can change it in the workbook.
Download your workbook
Keep going
Related free tools
Volunteer Tutor Session Log & Growth Tracker
Hours are easy to count. Dosage is what predicts whether it worked.
Open toolSchool Volunteer Clearance & Chaperone Readiness
Works backwards from the trip date and says who will not be cleared in time.
Open tool
Volunteer Background Check Policy Generator
Draft a written background check policy your board can adopt.
Open toolStop screening volunteers the hard way
These free tools are built by VolunteerBadge — full national criminal background checks for just $5, with FCRA compliance built in. No monthly fees.