A gym with two hundred members is not a hard business to run. It is a hard business to remember. Who paid, until when, who is training without having renewed, and how much of all that happened last month — those are questions answered from memory, while a member stands at the counter waiting. A notebook holds up to a certain size, and then it starts leaking. Not all at once: about one membership a month.
This article is about what a membership record that actually works looks like — what it has to know, where it usually goes wrong, and when moving off the notebook or the spreadsheet is worth it. It is written for gyms here, where most memberships are still paid in cash, at the counter.
The notebook is not stupid — it just does not remember dates
Before replacing it, it is worth understanding why it survived. An entry takes five seconds. It does not crash, does not ask for a password, does not need internet, and anyone who steps behind the counter can use it without training. Any system replacing it has to be at least as fast in those five seconds — because if it is not, the person at the counter will skip it when a queue forms, write in the notebook “so I don’t hold people up”, and copy it over later. Later never comes. That is how you end up with two records, and therefore none.
The one thing a notebook cannot do is speak up on its own. It says clearly that a member paid on 12 March. But nobody knows their membership ends on 12 April until somebody leafs back and works it out. The loss is not in the training — it is in the renewal nobody chased, and in the member who left without anyone noticing for six weeks.
A spreadsheet solves half the problem and introduces a new one
A spreadsheet is the right next step. You get sorting by expiry date, filters, and the ability to count a month without adding it up by hand. For a gym that is just starting, a spreadsheet is entirely enough and nothing to be embarrassed about.
The trouble starts when money begins to hang off it. There is one copy on one laptop, and then a second appears on a phone. Somebody overwrites a formula in a cell and nobody notices until the end of the month. There is no history — when an expiry date changes, the old value disappears, and neither who changed it nor why is recoverable. And there are no reminders: the sheet knows who is expiring, but it will only say so if somebody opens it and looks.
A practical rule: while the spreadsheet is a record, it is fine. The moment it becomes the accounting, it is time for a system.
Six things a membership record has to know
1. A member can exist without an account. This is the most important item and the most common mistake in off-the-shelf products. Most of them assume every member will install an app and register. They will not. In a neighbourhood gym a good share of members pay cash at the counter and never open anything — and that is fine. The member record (name, phone, plan, expiry date) has to stand on its own, and a login is a convenience for those who want one. Software that does not allow this forces you to keep both it and the notebook.
2. A membership is a date, not a state. A system that only knows “active / inactive” does not help, because somebody has to flip that state by hand. Store the expiry date and compute the status from it. Everything else then comes for free: who is active today, who expires this week, who expired a month ago and never came back.
3. A renewal extends the existing end date. A member who pays three days early must not lose those three days. If a renewal starts from the payment date instead of the expiry date, the system quietly steals days from every punctual member — and that is exactly the small thing that makes people stop trusting the software. The reverse holds for someone a month late: there the new period starts today, not from a long-past date.
4. A payment is its own record, with an amount and a method. Do not write only “renewed until”. Write how much was taken, when, on which plan, and how it was paid. Without that there is no monthly figure — and no answer to the most ordinary question of all: “I paid last month, remember?”
5. “Expiring within seven days” has to be a screen, not a report. The difference is practical. A report is something somebody has to sit down and run; a screen is what greets you when you log in. The list of people whose membership ends this week is the one part of the system that directly brings in money, which is why it belongs on the first page.
6. One record carries the whole history. Every membership, payment, order and note hangs off the same member. When somebody comes back after a year away, it should be visible that they were a member before — rather than creating a second record and losing both the history and an accurate member count.
The ninety-second test
When choosing software, ignore the feature list. Act out one payment instead. A member walks in, says they are renewing for a month, hands over cash. Time how long it takes to record that — from the first click in the search box to the moment the date is new.
If it takes more than half a minute, or requires three screens and a confirmation at the end, the system will not survive the first queue at the counter. Ask the same question of the three things that happen every day: adding a new member, selling one supplement, and answering “how long do I have left?”. All three have to be fast. Everything else in the program is used once a month and is allowed to take its time.
Supplements are the other half of the money
Almost every gym sells something — protein, creatine, water, gloves. That revenue is usually recorded nowhere, or recorded in a second notebook that is never added to the first.
When counter sales run through the same system as memberships, the monthly picture assembles itself: membership revenue, goods revenue, expenses, net. Two useful things come with it that a spreadsheet gives up grudgingly: a stock level that decreases by itself, and a margin that stays correct, because the cost price is recorded at the moment of sale — rather than read as today’s price, making last month look more profitable than it was.
Migration: the expiry dates are the one thing you cannot get wrong
Moving the existing list across is its own job, not an afterthought. An export from another program, a spreadsheet, even a tidy notebook can all be imported, and usually faster than people expect.
One thing has to be perfect: the current expiry dates. A member whose date is wrong on day one will never trust the system again, and they will be right. So keep the old record alongside for two or three weeks, until the numbers agree, and only then close it. Do not import three years of payment history in the first pass — nobody needs it, and it doubles both the work and the places to go wrong.
What to ask before you pay
Five questions separate a serious offer from a demo.
Can a member exist without an account and without an email address? If not, you have just bought a second record to keep alongside the first.
Does a renewal run from the expiry date or from the payment date? “From the payment date” means the system takes days away from the people who pay on time.
Where do I see who expires within seven days, and does it remind them on its own? If the answer is “there is a report”, ask to be shown it on the home screen.
Can a member see anyone else’s data, or the finances, by poking around in the browser? Nobody asks this one, and the answer is demonstrable — ask for a test, not a promise.
Can I change a price on the website myself, or do I call a developer?
People skip the last question most often, and then pay for it all year. If the gym’s website is a separate job from the membership record, every price or opening-hours change waits on somebody else — and the site slowly goes out of date, until the prices on it and the prices at the counter are two different things.
When building your own makes sense
Off-the-shelf software is cheaper and faster for as long as you fit its assumptions. Your own system makes sense when you do not: when you take cash and the product insists on cards, when there are no turnstiles and no reception desk, when the interface has to be in the local language because the person using it is not an IT person, or when the website, the members’ portal and the membership record have to be one and the same thing.
That is what we built. For Željezna Generacija, a gym in Hrasnica, Sarajevo, we delivered one system that is simultaneously the public website, the members’ portal and the owner’s panel — memberships, payments, supplement stock, orders, expenses and website enquiries, all in one database, with prices and stock computed in the database rather than in the browser. How we approach the whole vertical is on the page about gym management software.
And if you are still on the notebook: do not buy a system because it is time. Buy it the month you first cannot answer whose membership ends this week.
