For clubs
How to track membership dues at a tennis club
Dues are the most predictable income most clubs have, and the most scattered thing they track. When payments live in a notebook, the member list in a spreadsheet and the receipts on someone’s phone, the answer to “who owes what” only arrives at month end. This guide builds dues tracking on one idea: a running account per member.
Record dues as a debt first
There is a single reason dues tracking falls apart: at most clubs a payment is only recorded when it arrives. The correct order is the opposite — the moment a period starts, a charge is written to the member’s account, and the payment closes it. The difference between the two is that member’s balance.
The distinction looks small and changes everything. In a payment-only record you cannot produce a list of people who have not paid, because someone who has not paid has no rows at all. With charges and payments, an unpaid member is simply one whose balance is not zero — the list builds itself.
Pick one rule for billing periods
Monthly, quarterly and annual dues can coexist in the same club; what matters is that each member’s period type is recorded in exactly one place. The moment the same member is tracked both annually and monthly, duplicate charges become inevitable.
Decide up front whether periods start on the join date or on the calendar. Calendar-based (everyone on the 1st) is far easier to administer. Join-date-based is fairer, but a group of members becomes due every single day, so it needs an automated system to work at all.
Attach late payments to a rule, not to a person
Chasing overdue dues is usually left to whoever is at the front desk — which means some members get reminded and others do not. That lowers collection and creates resentment between members at the same time.
Keep the rule simple: how many days until a reminder, how many until booking is restricted. Once the rule is written down it can be automated, and it stops being something members argue about.
Keep dues in the same ledger as court and tournament income
Dues on their own are not a meaningful number. A club’s real position only becomes visible when court income, tournament entry fees, coach payouts and expenses sit in the same ledger.
With separate spreadsheets, combining them at month end becomes manual work — and because it is repeated every month, the errors compound.
Do not lose opening balances when you migrate
The most common migration mistake is importing the member list and leaving the outstanding debt behind. Everyone’s balance reads zero on day one, and old receivables are quietly written off.
The right approach is to enter the debts and credits as of the switch-over date as opening balances. The numbers stay correct without migrating any history.