A member at the desk with a friend
A member arrives on Tuesday with a friend and says she has a guest pass left this month. The receptionist opens the membership spreadsheet, which shows her as active with four passes a year. It does not show how many she has used. The direct debit provider's dashboard would show that her last payment failed, but reception does not have a login. She is waved through with her friend.
At month end the office manager reconciles the direct debit report against the spreadsheet and finds six failed payments, two members who asked to freeze during a holiday and were still charged, and one who cancelled by email and was not taken off.
The member list and the money live apart
Membership is a small subscription business inside the spa. It needs a member list, a payment status, entitlements and a history of use. Most spa booking systems handle appointments well and memberships loosely, if at all.
- The member list is a spreadsheet updated by whoever signs someone up.
- Payments are taken by a direct debit provider such as GoCardless or by Stripe, with no link back to the list.
- Guest passes, member treatment discounts and freeze periods are tracked by memory or notes.
- Cancellations arrive by email and are actioned when someone remembers.
- Reception cannot see whether a member is up to date.
Where the membership quietly leaks
Members with failed payments keep using the spa. Members who should have been frozen are charged and ask for refunds. Guest passes are given out more generously than the terms allow, or less, which annoys members who counted theirs. The office spends a day each month reconciling. And because nobody can see usage, you cannot tell which members are about to cancel because they have stopped coming.
How we build a spa membership record
- We set up a membership record for each member: plan, start date, entitlements such as thermal access, guest passes and member rates, and status.
- The record connects to your payment provider through its API, so a failed or cancelled payment updates status the same day and alerts the office.
- Freezes, upgrades and cancellations are made through the record, which also pauses or changes the payment, following the terms you set.
- At check-in, scanning a member card or searching the name shows status, guest passes left and any payment issue, and records the visit.
- Guest passes and member discounts are applied from the record, not from memory.
- Reports show members by status and by last visit, so you can contact those who have stopped coming before they cancel.
| Event | Before | After |
|---|---|---|
| Payment fails | Found at month end | Status updated, office alerted |
| Member asks to freeze | Email, sometimes missed | Freeze set, payment paused |
| Guest pass used | Not recorded | Deducted at check-in |
| Member stops visiting | Unnoticed | Shown on last-visit report |
Membership admin, reduced to exceptions
Reception sees a green or amber status when a member checks in and knows what they are entitled to. Failed payments are handled within days by the office, politely, with the facts on screen. The month-end reconciliation disappears because the record and the payments already agree. The manager can see visit patterns and plan member events or offers around real usage.
Renewals and price changes get easier as well. When a plan's price changes from a date, the record knows which members are affected and when their next payment falls, so the notice letter goes to the right people at the right time rather than to everyone on the spreadsheet.
Is your membership held together by a spreadsheet?
- Your member list is a spreadsheet.
- Reception cannot see payment status.
- Guest passes are counted by memory.
- Freezes and cancellations are sometimes missed.
- Month-end reconciliation takes a day or more.