Skip to content
Spreadsheet

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

Not affiliated with MENTOR or any mentoring standards body, and it reproduces no published benchmark. Your screening, supervision and closure practices remain yours to set and to defend.

Keep going

Related free tools

Stop 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.

Create Free Account