Shop · Small Business

Club Subs & Membership: photo 1 of 5 from its Etsy listing
Small Business

Club Subs & Membership

Club Membership Tracker, Subs and Fees Spreadsheet, Who Owes List, Treasurer Template for Sports Clubs and Groups, Excel & Google Sheets

£10 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Treasurer of a club or group and tired of working out who's paid? Set your fee types once, add your members and log payments as they come in. This spreadsheet works out what each member owes on monthly, termly or yearly fees, counting from when they joined.

The Who Owes list keeps itself up to date and writes a friendly reminder for each person, ready to paste into a text or WhatsApp.

Club Subs & Membership: photo 2 of 5Club Subs & Membership: photo 3 of 5Club Subs & Membership: photo 4 of 5Club Subs & Membership: photo 5 of 5

What's inside (6 tabs)

  • Start Here: Season settings, fee types and six live totals
  • Members: Due, paid, owed and status for every member
  • Payments: Every payment, checked against your members
  • Who Owes: Who owes what, with a reminder message for each
  • By Month: Money in, joiners and leavers, month by month
  • Guide: How to use it, in plain English

What it does

  • Fee types: monthly, termly, quarterly, twice-yearly or yearly, with family and concession rates
  • Due, paid and owed for every member, from the month they joined
  • Who Owes list with a reminder message for each person
  • Payments checked against your members, so the totals add up
  • Money in by month and by payment method, with a chart

What you get

  • club_subs_tracker.xlsx with example data, so you can see how it works
  • club_subs_tracker_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • For tracking subs. It doesn't send messages or take payments itself
  • For your own business use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Club Subs & Membership £10
Buy on Etsy