Club fees without a spreadsheet: references, records and reminders
Agree fee rules, use recognisable payment references and follow up on arrears. Includes online payment requirements and the limits of automatic bank processing.
Managing club fees without a spreadsheet starts with clear records: what each participant owes, when it is due and how a payment can be identified. A consistent payment reference helps you match a bank statement entry to the appropriate record. Your list of charges and recorded payments can then answer the practical question: “Who has paid for this period?”
Start with the fee rules
Write down the rules before recording payments. Otherwise, every unusual situation can become an individual agreement that is difficult to reconstruct a month later. Decide:
- The period: monthly, quarterly, half-yearly or annual fees, or a pass for a specified number of visits.
- One-off charges: joining fees or other charges recorded separately from recurring membership fees.
- The due date: when payment is expected within each period.
- Mid-month joining: a proportional charge, the full amount, a threshold rule or a charge based on the remaining classes.
- Siblings and discounts: what the second child receives and whether discounts can be combined.
- Pauses: how holidays, school breaks and longer illness affect future charges.
Explain these rules in your pricing information or club terms before enrolment. Discussing the first fee when someone joins gives the family a clearer starting point than explaining it only after a payment becomes overdue. The same principle applies when moving from a trial class to enrolment.
Give bank transfers a recognisable reference
Unclear references create extra work: “membership” without a participant name, a parent's surname instead of a child's, a transfer from a grandparent or one payment covering siblings. Agree on how payments should be identified.
- Use a consistent participant or payment reference appropriate to the system you use. In Klubownik, copy the payment details shown for the actual charge rather than inventing a reference.
- Keep a manually assigned reference short and unambiguous. Avoid characters that are difficult to enter.
- Provide a ready-to-copy title: the relevant code, what the payment covers, the period and the participant. For example: AB12CD October fee Alex.
- Offer a bank payment QR code where supported so the payer can transfer the supplied details to their banking app.
- Explain sibling payments: ask for separate transfers or clearly identifiable references for everyone covered.
A reference is a way to identify a payment. It does not remove the need to review unclear matches or reconcile the club's records.
Record payments on a regular schedule
- Review incoming payments regularly, for example weekly and after the payment deadline.
- Match clearly referenced payments first, then review the remainder using the payer and amount.
- Record overpayments, underpayments and payments for several periods when you identify them, with a concise explanation where needed.
- Record cash payments promptly in the same system as bank payments.
Send reminders with a clear purpose
An overdue payment may simply have been forgotten. Agree on a sequence that gives families useful information rather than repeated pressure:
- Before the due date: a friendly reminder with the amount, deadline and payment details.
- After the due date: explain what remains unpaid, how much is due and how to pay. Avoid discussing a family's payment in front of others.
- For a longer delay: contact the family directly. There may be a query, a needed pause or a request to discuss the payment date.
Set a sensible frequency, combine sibling information where appropriate, and check a reported transfer before sending more reminders. A payer's report that a transfer was sent is not the same as a confirmed bank receipt.
Example for a Poland-based club: Hello, our records show an outstanding October fee of PLN 150 for Alex, due on 10 October. The transfer details and payment reference are below. If you have already sent the payment, please let us know so we can check it.
Online payments have setup requirements
Online payment methods require the club to set up and verify an account with the payment provider. Provider charges apply. Check which methods are available for your club's country and currency, and which can support recurring card payments. A method available for a one-off payment is not necessarily available for an automatic monthly charge.
How this works in Klubownik
Configure passes and fees in the payment catalogue under Settings. Choose a billing period, due date and the rule for someone joining during a period. The options include monthly, quarterly, half-yearly and annual fees, visit-based passes and unlimited passes. One-off charges can be kept in the same catalogue.
- Charges: subsequent charges are created before the end of the period. Billing can be paused for a selected group.
- Bank transfer details: the parent portal shows the account, payment title and payment code, with a QR code for supported banking apps. Clubs can configure different accounts for selected groups or passes.
- Reminders: reminders before the deadline and for arrears are combined across a guardian's children, with no more than one email a day. Reporting a bank transfer in the parent portal pauses reminders for that charge for seven days.
- Discounts: sibling, length-of-membership and other automatic discounts, plus promotional codes, are available after configuration. When several automatic discounts apply, the most favourable one is used.
- Online payments: the club connects and verifies its own Stripe account. Funds go to that Stripe account. The club pays the provider's fees; Klubownik does not add its own payment commission. BLIK is available only for Poland-based clubs and does not support the recurring card payment flow.
- Cash: staff record cash receipts.
Automatic bank transfer processing is a separate feature that requires activation of the club's bank email inbox. A supported bank sends an email for each incoming payment to the address provided by Klubownik. The system reads the amount, reference and sender and can record an unambiguous match. Overpayments, underpayments and payments covering several people are held for human review with suggested matches.
This inbox feature does not connect to a bank API or read the account balance. Automatic posting from bank email notifications is for PLN payments. If the bank cannot send the required notifications, statements can be imported from supported CSV, MT940, CAMT.053, PDF or XLSX files; a person approves the matches, and monthly import allowances depend on the plan. Instalments are available for camps, not for ordinary membership fees or passes. See fees and payments and automatic bank transfers for the detailed scope and conditions. Shared club processes can also be used by school sports clubs.
Frequently asked questions
What if a parent enters the wrong reference?
Review the sender, account and amount, then provide the correct reference for future payments. Klubownik can suggest matches from those details. If a match is not unambiguous, a person must confirm it.
Does Klubownik have access to the club's bank account?
No. The bank email feature receives the incoming-payment notifications sent to its inbox; it does not connect to your bank account or see its balance. You can also upload statements yourself.
What if a child joins halfway through the month?
Choose a consistent rule: proportional, full, threshold-based or based on the remaining classes. Klubownik calculates the first fee using the rule configured in the catalogue.
For a new owner's first club, the trial lasts 30 days without a payment card. Create your first club and explore its fee settings.