The Numbers a Youth Program Is Actually Judged On

Every youth program can report how many young people it served and how many hours it delivered. Almost none can say which matches have quietly stopped meeting, which students are four days short of counting toward the outcome they report, or which chaperones will not be cleared in time for the trip in three weeks. Here is how to compute the second set — and six free workbooks that do it.

Every youth program can tell you how many young people it served and how many hours it delivered. Almost none can tell you, without going and looking, which matches have quietly stopped meeting, which students are four days short of counting toward the outcome they report, or which chaperones will not be cleared in time for the trip in three weeks. The first set of numbers goes in the annual report. The second set is the one that decides whether the first set means anything.

This is a guide to the second set — what each number is, why the usual way of tracking it fails, and how to compute it instead. Every workbook mentioned is free, needs no account, and is linked at the bottom.

MAXIFSWhy a last-contact column should not be editable

30Days that has defined a federal regular attendee

6Free workbooks in the toolkit

$0What any of this should cost a 20-match program

1. The number that lies: “last contact”

Open almost any mentoring or tutoring tracker and you will find a Last Contact column. Somebody is supposed to keep it current. Here is what actually happens: it gets updated in batches, from memory, in the week before a board meeting or a funder report, by a coordinator reconstructing what they think happened.

Which means the column reports precisely the opposite of what it was built to catch. A match that stopped meeting in March still reads green in June, because green is what somebody typed. The failure mode of a manually maintained recency field is that it is most wrong exactly when it matters most.

What most templates do

An editable Last Contact date, filled in by whoever is preparing the report. It is a claim about the past written by someone with an interest in the answer, and it degrades silently.

What to do instead

Log every contact in a separate sheet, and derive the most recent date with MAXIFS. A match then looks current only if somebody actually logged something. There is no cell to update out of habit.

The second half of this is a distinction most trackers collapse: “no contact ever logged” is not the same problem as “overdue.” An overdue match is a relationship that is slipping. A match with no contact ever recorded is either not really a match, or a record-keeping failure severe enough that you do not know whether it is one. Both need attention; they need completely different conversations.

The practical version. Pick your contact interval and write it down — weekly, fortnightly, monthly, whatever your program design actually is. A program that cannot state its interval does not have one, and cannot be late against it. Then compute lateness against that number rather than against a feeling.

2. Hours are the easiest number to report and the least useful one

Total tutoring hours is a satisfying figure. It goes up, it is easy to add, and it sounds like impact. It also hides the entire distribution.

A hundred hours spread thinly across forty students and a hundred hours concentrated on twelve students are the same headline. They are not the same program, and they will not produce the same outcomes, because how much a student actually receives is the thing that moves the needle. The forty-student version will report a respectable total and show almost no measurable gain, and the program will conclude that tutoring does not work.

The fix is to compute dose per student — sessions per week, measured from your term start — and compare it against the target your program intends. Then the students receiving far less than designed become a list you can act on rather than an average you cannot see.

On target dosedesigned

Below targetat risk

Well below targetwill show no gain

Illustrative bands, not data — the point is that all three sit inside the same “total hours” figure.

One more distinction worth building in: a student no-show and a tutor absence are different events. In an hours total they are identical — a session that did not happen. In reality one is a student drifting away and the other is a program failing to show up for a child, which is the kind of thing that ends a tutoring relationship for good. Record them separately or you cannot tell which problem you have.

3. The threshold you can still move

Many youth programs report against an attendance threshold. For federally funded 21st Century Community Learning Centers, the definition used for GPRA reporting has been attending 30 days or more across the academic year — that is the federal figure, and your state or funder may define it differently, so it is a starting point rather than your rule.

Here is the operational insight, and it is worth more than the number itself. Attendance templates total days at the end of the term. That tells you what your figure will be at exactly the moment you can no longer change it.

A student four days short in October and a student four days short in June are the same number and completely different situations. In October, four days is a phone call to a family, a transport problem you did not know about, a schedule clash that can be fixed. In June it is a rounding error in a report.

So track it continuously and surface the near-misses. The useful output is not “we have 62 regular attendees.” It is “these 14 students are within five days of the threshold, here are their names, somebody call their families this week.” That list is the difference between reporting an outcome and reporting an attendance figure.

4. Closure: the part almost nobody builds

Mentoring programs invest heavily in recruitment, screening, training and matching. The end of a match gets almost no infrastructure at all, and it is the stage with the clearest capacity to do harm.

An abrupt, unexplained ending — a mentor who stops replying, a match dissolved without anyone speaking to the young person about it — can leave a child worse off than if the match had never been made. They have already had adults disappear. Doing it again with your program’s logo on it is not a neutral outcome.

What a closure record needs to capture is not complicated:

Planned or unplanned, and if unplanned, who initiated it.
Whether a closure meeting actually happened, rather than the match simply going quiet.
Exit conversations with both sides separately — the mentor’s reason and the young person’s experience are different pieces of information, and the second one is the one that improves your program.
Whether the guardian was informed, and whether a rematch was requested.

Track the share of closures that are unplanned over time. Every program has unplanned closures; that is not a scandal. A rising share of them is a signal about screening, expectation-setting or match support, and it is invisible unless you write closures down.

5. Clearance: work backwards from the date, not forwards from the list

School districts and youth organizations commonly run tiered volunteer clearance. A parent helping at a classroom party with a teacher present is not held to what an overnight chaperone is held to, and the tiers carry different requirements — and, critically, different lead times. A fingerprint-based check does not come back the same week; some districts ask for submissions weeks ahead of the activity, and clearances typically expire and need renewal on a cycle.

The specific requirements are set by your district and your state, and they differ everywhere, so nobody should be taking those numbers from an article. What is universal is the failure mode:

The trip is in three weeks. The chaperone list is final. Nobody did the subtraction. Every element of that sentence is normal and none of it is anyone’s fault — it is simply that the arithmetic runs backwards from a date, and nothing in the process prompts anyone to do it.

So do the subtraction mechanically. Every event gets an apply-by date computed from its required level’s lead time. Every chaperone assignment then resolves to one of four states, each with a different remedy:

Ready Cleared at the right level, and still valid on the day Nothing to do. Worth noting this is the only state that requires checking three separate things at once, which is exactly why people do not check it by eye.

Not cleared No clearance recorded at all The useful output here is not the status, it is the date: tell the coordinator when applications for this event were actually due, so they know whether this is fixable or whether they need a different chaperone.

Expires before event Cleared today, lapsed by the trip The one that catches everybody, because the volunteer genuinely is cleared right now. Comparing the expiry date against the event date rather than against today is the whole trick.

Wrong level Cleared, but not for this Common where someone has helped for years in a supervised role and is now being asked to do something that is not supervised. Long service is not a clearance level.

6. On the money side, independence comes before arithmetic

Parent groups, booster clubs and small youth nonprofits typically do an annual review of the books. Guidance from parent-teacher organizations is consistent on the part that gets skipped: the review is only worth something if the people doing it are independent of the people who handled the money.

Concretely, that generally means the review committee excludes anyone with signature authority on the account, relatives of anyone with signature authority, and the treasurer — who answers the committee’s questions rather than sitting on it. Two-signature rules on checks are a related control, and several states require them.

This is the control most often skipped, and almost never for bad reasons. In a group where the same six people do everything, finding three who are genuinely independent is a real problem. But a review conducted by the people who wrote the checks is a formality, and everyone involved knows it.

It is also worth saying clearly: an internal review of this kind is not an audit as an accountant uses the word, and describing it as one to a membership is a mistake. Some states require organizations above a revenue threshold to engage a licensed professional. What applies to you is set by your bylaws, your state and your national affiliate.

One control worth more than most of the checklist: cash counted by two unrelated people, with the total written down before it leaves the building. Money at youth fundraisers goes missing almost never on purpose. It goes missing because one person counted it alone and there was no independent record of what there was. The control protects the volunteer who did the counting at least as much as it protects the money.

7. The one nobody warns small programs about: student data

A spreadsheet of students’ names, grades, attendance and assessment scores is not a neutral working file. Records you receive from a school can be protected education records under FERPA, and your state may add student-privacy obligations of its own.

Small programs are routinely handed a roster by a partner school without anyone explaining what came with it. The file then lives in a shared Drive folder that every volunteer can reach, which is the most common way this goes wrong and the quietest.

The decisions to make — before the file exists, not after — are unglamorous and take about ten minutes: where it lives, who can open it, how long you keep it, and who you are permitted to show it to. If you hold records from a school, the school’s agreement with you is the place to start, and they will know.

What programs are usually charged for all this

Worth being specific, because pricing in this sector is quietly aggressive for organizations often running on a single grant. Dedicated mentoring and volunteer platforms generally price per participant as an annual seat fee, per program as a flat fee per cohort, or as an enterprise annual licence. At the small end that lands around $25 to $75 a month tiered by volunteer count; mid-market volunteer platforms commonly sit near $100 to $140 a month, or roughly $1,200 a year billed annually.

None of which is an argument that the platforms are worthless. Above a few hundred participants they clearly earn it, and automated matching, participant logins, integrated surveys and audit trails are real things a spreadsheet cannot do.

It is an argument that a twenty-match mentoring program should not be paying a per-seat fee to find out when a match last met. That is a formula.

The workbooks

Every calculation described above is built into a free, branded Excel workbook. No account, no email gate, no watermark, and nothing is hard-coded to somebody else’s rule — thresholds, intervals, clearance levels and lead times are all cells you fill in.

Mentor Match & Closure Tracker — derived contact recency, match support check-ins, and the closure log from section 4.
After-School Attendance & Regular Attendee Tracker — the near-miss list from section 3.
Volunteer Tutor Session Log & Growth Tracker — dose per student, and no-shows counted apart from tutor absences.
School Volunteer Clearance & Chaperone Readiness — the backwards subtraction from section 5.
PTO / PTA Annual Financial Review — independence tested first, then 21 steps, then findings.
Student Service-Learning Hours Tracker — verified hours counted separately from claimed ones.

All six sit on the youth program toolkit hub, which also carries the pricing comparison and the FERPA notes in more detail.

Where screening fits

Three of those workbooks hold a screening date, and the honest thing to say about any of them is that a background check is only current on the day it ran. A mentor cleared in 2024 and still matched in 2026 has a two-year-old check and a spreadsheet cell that says so in the same confident black text as a check run last week.

The workbooks work fine if you run checks elsewhere and keep the dates by hand — they are registers, and you owe us nothing for them. If you would rather the dates maintained themselves, VolunteerBadge screens mentors, tutors, chaperones and program volunteers for $5 per adult with automatic rescreening on a schedule you set. It is also worth reading what background checks actually catch in youth programs, which is more candid about the limits than a company selling them probably ought to be.

Common questions

What metrics should a youth mentoring program track?

Beyond the counts every program reports, four are worth computing continuously: contact recency per match (derived from a contact log rather than typed), the number of matches with no contact ever logged, the share of closures that are unplanned, and time on the waiting list for young people not yet matched. The first two predict quiet failures, the third is a signal about screening and match support, and the fourth is the only honest measure of a recruitment problem.

What is a “regular attendee” in 21st CCLC reporting?

For federal GPRA reporting the definition used has been a student attending 30 days or more across the academic year. States and individual funders may define it differently and requirements change, so confirm the definition in your own award terms rather than relying on a general figure.

How many tutoring sessions per week does a student need?

There is no universal number, and any article giving you one without knowing your model, subject and student population is guessing. What is well supported is the general principle that dose matters — a student receiving occasional sessions is not a smaller version of a student receiving regular ones. Set the target your program is designed around, then measure who is actually getting it.

Is an internal financial review the same as an audit?

No. An internal review carried out by your own volunteers is not an audit, review or compilation as those terms are defined for accountants, and it should not be described to a membership as one. Organizations above certain revenue thresholds may be required to engage a licensed professional; what applies to you depends on your bylaws, your state and any national affiliate.

Can we put student names in a spreadsheet?

You can, but records received from a school may be protected education records under FERPA, and your state may impose additional student-privacy obligations. Decide where the file lives, who can open it, how long you keep it and who may see it before you create it, and ask the partner school what your agreement with them requires.

A note on sources

Attendance-threshold figures come from U.S. Department of Education and state education agency material on 21st Century Community Learning Centers reporting, read in September 2026. Financial-review practices reflect published guidance from parent-teacher organizations. Software pricing figures are indicative ranges gathered from published vendor pricing and software directories in September 2026 and change frequently. VolunteerBadge and ScreenForge Labs, LLC are not affiliated with, endorsed by or connected to MENTOR, the U.S. Department of Education, any state education agency, any funder or any standards body, and nothing here reproduces a published standard or benchmark. This article is not legal, accounting or compliance advice — confirm what applies to your program against your own award terms, bylaws and district policy.