How to Track Club Member Payments: A Template and a Software Guide for Sports Clubs

Why payment tracking is harder for sports clubs than for nonprofits

If you search for membership tracking software, almost everything that comes back is built for nonprofits and professional associations. Those organisations have a relatively simple payment problem: once a year, members pay annual dues. The system records who paid, who didn't, and who needs a reminder. Done.

A sports club has a more tangled job. In a typical week, a club secretary deals with:

• Annual membership fees on one cadence (often September or January).
• Monthly or term training fees on a different cadence, sometimes pro-rated for new joiners.
• Competition entry fees that pop up irregularly and only apply to some members.
• Equipment levies and uniform fees that happen once or twice a year.
• Family or sibling discounts applied to certain payments but not others.
• Junior vs senior pricing tiers, and sometimes a third "social" or "veteran" tier.
• Drop-in fees for casuals who aren't full members but pay per session.

Each of those has its own rule, its own due date, and its own exception list. A nonprofit tracking annual dues can get by with a single spreadsheet column. A sports club tracking all of the above ends up with seven columns, a colour-coded legend, and a note in the margin that says "ask Sarah about the U14 kit money." A table tennis club is a textbook case: annual membership, monthly training fees, and one-off competition entries all land on the same player at different points in the season. A martial arts club layers it differently but no less tangled: monthly class fees, annual membership, and grading fees that only apply to the students testing for a belt that term. A barre studio looks simpler on paper, one flat monthly membership, but thirty of them renewing on different days of the month is its own reconciliation job.

That is why generic membership tools so often fail at sports clubs. They were not built for multiple fee streams running simultaneously against the same member, and they were not built for the people doing the admin (volunteers and part-time staff with a few evenings a week, not full-time membership coordinators). Payment tracking is one piece of a wider picture; the full version sits inside our complete guide to club membership management.

What every payment tracking system has to do

Strip away the marketing language and a payment tracking system, whether it is a spreadsheet, a database, or proper software, has three jobs at a sports club:

1. Owed. Every fee type from the list above, applied to the right member at the right amount, including the exceptions (the sibling discount, the mid-season joiner on a pro-rated fee).
2. Paid. Each payment dated and matched to a specific fee, so the balance per member is a lookup, not a calculation you do in your head.
3. Late. The overdue list produced for you, not assembled by you, so chasing takes five minutes instead of an evening.

Everything else (reporting, exports, integrations, automation) sits on top. A tool that cannot do those three jobs for a sports club's real fee structure will not be rescued by its feature list.

Five practical criteria to filter the noise:

• Real-time member-facing status. Members can see their own balance without asking. This alone eliminates a chunk of admin work.
• Multiple fee types per member. Not just one annual subscription, but training fees, competitions, levies, drop-ins, all tracked separately and rolled up.
• Automatic reminders. Before the due date, after the due date, escalating if needed, without the admin having to manually send each one.
• Per-member history. A complete record of what every member has paid, when, going back as far as you've been tracking.
• CSV export at any time. Whatever system you use, your data should belong to you, not the vendor.

Now to the three realistic options for actually doing it.

Option 1: The spreadsheet method (and when it stops working)

For a small club, under about 30 to 40 members, a spreadsheet is a perfectly honest tool. It is free, it works on every device, and you do not have to convince anyone to learn new software. Most clubs start here, and many should not move off it until they actually outgrow it.

The problem is not the spreadsheet. It is that most club spreadsheets are built as a grid of ticks with no record behind them, so nobody can answer "when did the Wilson family last pay, and for what?" without scrolling through old emails. The template in the next section fixes that with two sheets instead of one.

If your spreadsheet is mostly green and you can find what you need in 30 seconds, you do not need software yet. Keep your money for something else.

The spreadsheet method breaks down when one or more of these starts happening:

• You are sharing the file with other coaches or committee members, and someone overwrites someone else's edits.
• Members start asking you what their payment status is, and you spend ten minutes looking it up each time.
• You cannot remember what you charged that one family last March, and the spreadsheet does not have a complete history.
• Reminders are not going out reliably, because manually emailing the 12 overdue parents this week is just one more thing on the list.
• You add a new fee type (say, a new competition), and have to rework the layout to accommodate it.

The threshold most clubs hit is around 40 members. Below that, a well-built spreadsheet survives. Above that, the time you spend keeping the spreadsheet honest starts to outweigh what the spreadsheet saves you.

A club payment tracking template you can copy

This is the layout that survives longest at a multi-fee sports club. It is two sheets in one Excel file. Copy the columns as they are, rename the fee columns to match your club, and you have a working club payment tracking spreadsheet in about twenty minutes. If your club charges one monthly fee per member, there is a ready-made file for that simpler case: the free club membership tracker, an Excel template with members, monthly payments, and attendance already set up.

Sheet 1: Fees. One row per member, one column per fee type, and an Outstanding column on the right. The numbers in the fee columns are not typed in; they are pulled from Sheet 2 by formula (more on that below).

Sheet 2: Payments log. One row per payment, in the order the money arrived (the first rows of the season shown here). This is the sheet that answers every "when did they pay?" question, and it is the one most clubs never build.

Three rules make the template work, and they matter more than the column names:

1. Money goes into the log first, always. Nobody types a number straight into the Fees grid. If a payment is not in the log, it did not happen.
2. The Fees grid is calculated, not typed. Each fee cell sums the log for that member and that fee (in Excel, a SUMIFS on the Member and Fee columns). Outstanding is the fee amounts the member is liable for minus the sum of their log rows. Per-group totals are one SUMIF on the Group column. Once this is set up, you never "update the spreadsheet" again; you only add log rows.
3. Status is a rule, not a colour you apply by hand. A conditional formatting rule turns a cell red when the fee's due date has passed and the cell is still below the fee amount, and yellow when the due date is inside the next 14 days. Hand-applied colours drift within a month.

Two habits to go with it. Keep a Fee schedule block at the top of Sheet 1 (fee name, amount, due date, which groups it applies to) so the formulas reference one place when the training fee changes. And when you add a fee type mid-season, add a column, not a new sheet; the log does not change at all.

How far it goes: a club with 30 to 40 members and three or four fee types runs on this for years. What eventually breaks it is not size but sharing. The moment two coaches and a treasurer are all adding log rows from their phones, rows get duplicated or lost, and the grid quietly stops being true.

Matching bank transfers, cash, and card payments to the right member

Most of the time lost in club payment tracking is not in the spreadsheet. It is in working out which of the 23 transfers on the bank statement belongs to which child, and whether the €40 the coach was handed on Tuesday ever got written down. Each payment method needs its own small routine.

Bank transfers. Give members a reference convention and repeat it on every reminder: surname, fee, month (CLARKE TRAINING OCT). A parent paying for two children puts both surnames in. Then match the statement to the log once a week, in one sitting of 15 minutes, rather than whenever someone asks. Anything you cannot match goes on an "unmatched" list at the bottom of the log with the amount and date; those are the ones you ask about at the next training, and they are almost always a parent who paid from a grandparent's account.

Cash at training. Cash is where clubs lose track, because it changes hands away from the person who keeps the records. The rule that works: whoever takes the cash writes the log row the same evening, with their own name in the note column, and the money is handed over with a matching slip. One person owns the log; everyone else either sends them a message with the four fields (member, fee, amount, date) or adds a row in the shared file, but never both.

Payment links and card. If your club collects some fees through a payment link or a card reader, the provider's payout report is your source, not memory. Once a week, copy each payout line into the log with the provider reference in the note column. The fee the provider deducts belongs in the accounts, not in the member's balance; the member paid the full amount.

Whatever the method, the test is the same: can you open the log and see, for any member, every payment they have made this season, with a date and a reference? If yes, your tracking is sound, even if it lives in Excel. If no, the tool is not the problem yet; the routine is.

Option 2: A purpose-built sports club system

Once a spreadsheet stops working, the next stop is software designed for clubs. The category includes several sports-club-fit membership tools, with different positioning depending on club size and sport.

What you get when you move from a spreadsheet to a purpose-built system:

• One profile per member with every fee type, every payment, and every contact detail in one place. No cross-referencing required.
• Live status visible to the member. Members open the app, see their own balance, see what is due. They stop asking the admin.
• Automatic reminders that fire on a schedule you set. Members get a nudge a week before, on the day, and after if necessary, without you sending a single email.
• Complete history per member. Every payment they have ever made, going back to the day they joined, in one place.
• Group-aware reporting. Who has paid in U14, who has paid in seniors, who has paid for the upcoming competition, at a glance.

The trade-off is real: you are committing to a tool, learning a new interface, and paying a subscription. For most clubs above 40 members, the time saved each month covers the subscription cost within the first few weeks. For clubs below 40 members, the maths is less obvious, and the honest answer is often "wait."

Option 3: Generic accounting tools and why they fall short for membership tracking

The third option clubs sometimes consider is using their existing accounting software, QuickBooks, Xero, FreshBooks, Wave, to track member payments. The logic seems reasonable: it is already there, the treasurer knows how to use it, and it handles money.

It works for the accounting side. It does not work as a membership tracking system. Three reasons:

1. No member-facing view. Accounting software is built for an internal user (the bookkeeper). Members cannot log in and check their own balance, which means every payment query still lands on the admin's desk.
2. Wrong cadence. Accounting tools are built around invoices, transactions, and reconciliation. A sports club's membership rhythm (recurring training fees with exceptions per member) maps badly onto this. Many clubs end up creating one invoice per member per quarter, which gets unwieldy fast.
3. No group structure. Sports clubs need to see "all U14 payments" or "who in the senior squad still owes for the tournament." Accounting software groups by account or by customer, not by squad or age group, so this kind of report requires manual work.

Where accounting tools do belong: alongside a membership system, handling the books while the membership system handles the member relationship. ClubMon, for instance, exports payment data in formats your accountant can import into QuickBooks or Xero. The two systems do different jobs and should not be asked to do each other's.

How to choose: club size plus fee complexity

Two variables decide which option fits. Club size on one axis, fee complexity on the other.

Fee complexity, roughly:

• Simple: one or two recurring fees, same for everyone, paid at the same cadence.
• Mixed: 3-5 fee types (membership, training, the occasional competition), pricing tiers by age or status.
• Complex: 5+ fee types, multiple cadences, family discounts, sibling rules, drop-ins, partial payments.

And the quick-decision matrix:

• Under 30 members, simple fees: spreadsheet is fine. Don't overcomplicate.
• Under 30 members, complex fees: software pays off earlier than you might think. The complexity, not the headcount, is what breaks the spreadsheet.
• 30 to 100 members, simple fees: spreadsheet still works, but switch to software when you notice you are spending more than two hours a month on admin.
• 30 to 100 members, mixed or complex fees: get the software. The cost is low and the time saved is real.
• 100+ members, any fee structure: the spreadsheet will not survive, even if you are very organised. Move now.

One more variable that overrides everything: who is doing the admin. If a single volunteer is absorbing the work on top of a day job, the case for software is stronger than the headcount suggests. Software pays its own subscription back in evenings reclaimed.

How ClubMon handles payment tracking specifically

ClubMon is built around the three jobs at the top of this article: record what each member owes, show what they have paid, make it trivial to chase what's late.

The product details that matter for payment tracking:

• One live profile per member, showing membership status, payment history, and group assignment. Whether you have 30 members or 500, you see exactly who is active, who is overdue, and who has quietly stopped paying without saying anything.
• Multiple fee types per member. Annual membership, monthly or term training, competition entries, equipment levies, all tracked separately and rolled up into one balance. Family discounts and tier pricing are first-class concepts, not workarounds.
• Automatic reminders on a schedule you set. Members get a nudge before the due date and another after, without you lifting a finger, and the overdue list from the template above is produced for you instead of by you.
• Member-facing payment status in the mobile app. Members open the app, see what they owe, see what they have paid. Most of the "what's my status?" questions stop happening.
• Group-aware reporting. Filter by U14, seniors, masters, by group, by membership tier. See who has paid the competition entry, who has paid this month's training, who has dues outstanding. Click a column to sort, click a name to drill in.
• Full export at any time. CSV download of any view, including the complete per-member payment history, which is the Payments log from the template, kept for you. Your data is yours.

ClubMon works with however your club already collects money: bank transfer, a Stripe link, cash at training. Members pay the way they always have, you record it in ClubMon, and the balances, reminders, and history stay accurate on their own. That focus is what keeps the product simple and the pricing low. Pricing starts free for clubs under 30 members.

Moving your payment records into ClubMon

If you built the template above, the move is mostly a mapping exercise, because the template already has the same shape ClubMon uses. Member import itself is covered in our complete guide to club membership management; the payment-specific steps are these:

1. Fee schedule block becomes your fee types. Each row of the block (name, amount, due date, groups) is one fee type in ClubMon. Sibling discounts and age tiers are set once here, not per member.
2. The Outstanding column becomes the opening balances. For every member with a non-zero Outstanding, record what they have paid so far against each fee. Work down one fee column at a time; a 60-member club with four fee types takes about half an hour.
3. The Payments log becomes history. You do not need to re-enter old log rows. Keep the Excel file as the archive for last season, and let ClubMon's per-member history start from the opening balances. From the first payment you record in ClubMon, the log is kept for you.
4. Keep the bank-matching routine, lose the typing. The weekly 15-minute statement check stays. The difference is that each matched transfer is recorded against the member once, and the balance, the overdue list, and the reminders update from it.

Run the spreadsheet alongside for the first month if it reassures you. By the second month the Outstanding column in Excel and the overdue list in ClubMon should agree line for line, and that is the moment to retire the file.

Frequently asked questions

How do you track payments at a sports club?

At a small club, a spreadsheet with one row per member and one column per fee type is usually enough. At a club above roughly 40 members, or any club with multiple fee types running simultaneously, dedicated software that handles membership, training fees, and competition entries in one place will save more time than it costs. The three things any system has to do are record what each member owes, show what they have paid, and make late payments easy to chase.

What is the best way to track club member payments?

The best way depends on club size and fee complexity. Under 30 members with simple fees, a well-built spreadsheet works. From around 40 members up, or with any club running multiple fee types (membership + training + competitions + levies), purpose-built software starts paying for itself in time saved. Generic accounting tools like QuickBooks handle the books but do not work as a membership tracking system because they have no member-facing view and no group structure for squads or age groups.

Can I track club member payments in Excel?

Yes, and many small clubs do, successfully. A working structure is one row per member, one column per fee type (annual membership, term training, competition fund, etc.), and a status colour code per cell. Add a summary row that rolls totals up by group. This works well until the spreadsheet starts being shared across coaches, members start asking about their balance, or you cross roughly 40 members. At that point the time you spend maintaining the spreadsheet outweighs what it saves you.

What is the best membership tracking software?

For sports clubs and lean studios, ClubMon is built specifically for the multi-fee structure most clubs actually have, with a member-facing app and automatic reminders included. For larger associations or nonprofits, WildApricot and MemberClicks are more established. For a full comparison across the category, see our guide to the best membership software for sports clubs, which ranks eight options with notes on which fits which kind of club.

Is there free membership tracking software for sports clubs?

Yes. ClubMon is free for clubs and studios with up to 30 members, with no credit card required. It includes member tracking, payment status, automatic reminders, and the mobile app for members. Most other purpose-built platforms offer a free trial rather than a permanent free plan. If you have under 30 members, the free plan covers everything you need without paying a cent.

What is payment tracking at a club?

Payment tracking is the running record of what each member owes, what they have paid, and what is overdue, across every fee your club charges (membership, training, competitions, equipment). At a sports club it has to cope with several fees per member on different schedules, which is why a single "paid / not paid" column breaks down. A good tracking setup has a log of every payment with a date and a reference, a per-member balance calculated from that log, and an overdue list that is produced automatically rather than assembled by hand.

How do you track club member payments online?

For bank transfers, give members a reference convention (surname, fee, month) and match the statement to your payments log once a week. For payment links or card readers, use the provider's payout report as the source and copy each line into the log with its reference. If you use club software like ClubMon, each matched payment is recorded once against the member and the balance, the overdue list, and the reminders update from it, and members can see their own status in the app instead of asking you.

How do I track monthly training fees?

Treat each month as its own fee column (Training Sep, Training Oct) rather than one "training" column you overwrite. The payment goes into the log with the month in the fee field, and the grid cell for that month fills from the log. That way a member who skipped October but paid November is visible, and pro-rated fees for a mid-month joiner are just a smaller amount in that month's fee schedule. Software does the same thing with a recurring monthly fee type, and adds the reminder before each due date.

What's the difference between payment tracking and payment processing?

Payment tracking is the record of who owes what and who has paid. Payment processing is the act of moving the money (taking a card payment, receiving a bank transfer, charging a recurring subscription). They are separate jobs. Some platforms do both inside one product; others, including ClubMon, focus on tracking and let you collect payments through whatever method your club already uses (bank transfer, Stripe link, cash, direct debit). Both approaches work; the right answer depends on whether you want collection inside the app or are happy collecting it outside.