Hi r/youthhockey — figured this is the right sub since most of you are either running a team's finances yourself or coaching alongside the parent who got stuck with it.
Background: 30+ years in youth hockey, last 15 as a non-parent paid coach. Same scene played out every August in every program I've been around — the new team manager opens last year's budget spreadsheet, finds a few broken formulas, gives up, and starts over. By February they're chasing dues on sticky notes. By March nobody actually knows what was spent on hotels for that one tournament.
So I built a clean template for managing ONE team's finances for ONE season. Free, no email wall, no signup, downloads as Excel or Google Sheets:
What it handles for a single team:
- Per-family dues tracker — billed, paid, balance, all auto-calculated. Color-coded for paid / partial / overdue.
- Pre-built expense categories: ice time, refs, tournaments, hotels, uniforms, fees, equipment
- Budget vs. actual by category, so you can show parents at the season-end meeting where the money actually went
- Season summary on one tab — screenshot it for your next parent meeting and you're done
- No macros, opens in Excel, Google Sheets, or Numbers — no installs, no accounts
If you're managing one team's books, this is the right tool. (If you're running a full club or multi-team program with shared overhead across teams, there's a separate web app on the same site — but most managers here probably don't need it.)
If there's a category I'm missing, reply or email and I'll add it. Easier to fix it once than have 50 people each rebuild their own version.