Short answer: You move from spreadsheets and texts to a booking system in six steps: 1) reconcile your client list, class-pass balances and active memberships on a fixed cut-off date, 2) set up your classes and prices, 3) test it yourself as a client, 4) invite clients with one clear message, 5) run both in parallel for 1–2 weeks, and 6) close the spreadsheet and delete the old lists. Allow 2–4 weeks from start to finish. If you spend more than a couple of hours a week on sign-ups, reminders and payments, those are usually the hours you get back.
"Who's in for Wednesday?" Sent to 14 people. Seven say yes, two say no, one asks if she can bring a friend, and the rest leave you on read.
That is how most small studios start: an Excel or Google Sheets file with names and remaining classes, a WhatsApp or Facebook group for sign-ups, texts for reminders, and bank transfers you match to the right name afterwards. With ten clients and two classes a week, it works perfectly well.
Somewhere between 30 and 50 clients, it tips over. Not because the spreadsheet gets worse, but because you have become the system: everything that needs remembering or checking goes through you. Below are the signs you have reached that point, what it costs you, and a plan for switching without losing a single client or class credit.
Have you outgrown your spreadsheet? 10 signs
Tick the ones that are true for you today:
- ☐ You spend more than 3–4 hours a week on messages, sign-ups and payments.
- ☐ The "truth" lives in several places: the spreadsheet, the group chat, your texts and your banking app.
- ☐ Two clients have turned up believing they had the same spot.
- ☐ You are not entirely sure how many classes a client has left on their pass.
- ☐ You sit with your bank statement trying to work out who "Transfer £60.00" was from.
- ☐ New enquiries come in on Instagram and wait hours for a reply.
- ☐ The waiting list exists only in your head or in a comment thread.
- ☐ You cannot take a week off without someone "minding the phone".
- ☐ Client details are scattered across old spreadsheets, phones and inboxes.
- ☐ You cannot quickly say which classes are full and who has not been in for a month.
Three or more ticks? Then your manual processes are probably costing you more than a booking system would. Only one or two? A well-organised spreadsheet can carry you a while longer, and that is perfectly fine.
What is the spreadsheet really costing you? A worked example
Admin time is easy to miss because it arrives in small pieces: five minutes on a message here, ten minutes hunting for a transfer there. For a studio with around 40 clients and six classes a week, it can look like this:
| Task | Time per week (example) |
|---|---|
| Answering sign-ups, cancellations and "is there space?" | 1.5 hours |
| Updating the spreadsheet and class lists | 1 hour |
| Matching bank transfers to names | 1 hour |
| Tracking class passes and chasing payments | 0.5 hours |
| Reminders and waiting-list messages | 1 hour |
| Total | 5 hours |
Example: what 5 hours a week adds up to in a year
- 5 hours a week × 46 working weeks = 230 hours a year
- 230 hours × £25 an hour = £5,750 a year (at €30 an hour: €6,900)
- If a system removes only half of that, you get 115 hours back: around three working weeks
For comparison: Class Booking starts at £8 (€10) a month, which is £96 a year.
These figures are an example, not a measurement. To find your own, jot down every bit of admin during one ordinary week. Most studio owners are surprised.
The costs that never show up on a timesheet
In our studio booking report we analysed 12 months of anonymised data (July 2025 to June 2026) from 17 European boutique studios, covering more than 8,100 class bookings. Two figures land squarely in spreadsheet territory:
- 25.5% of bookings were cancelled, and 42.3% of those cancellations came less than 24 hours before the class. Without a waiting list that promotes people automatically, many late cancellations become empty spots, because nobody reads your message in time.
- 55.6% of bookings were paid with credit from a membership or class pass. Exactly the balances that are hardest to keep accurate in a spreadsheet, where small mistakes cost money or goodwill.
What does a booking system take off your plate?
| Task | Today (spreadsheet and messages) | With a booking system |
|---|---|---|
| Booking | Texts, DMs and replies in the group chat | Clients book themselves via a link, and the class closes when it is full |
| Payment | Transfers and cash you reconcile afterwards | Card payment at booking, or a credit taken from a pass or membership |
| Reminders | You send them yourself, or they get forgotten | Automatic email or SMS before the class |
| Waiting list | A list in your head | The first person on the list moves up when someone cancels |
| Class passes and memberships | Counted by hand | Balances update with every booking; expiry and renewals are handled for you |
| Cancellations | "Do you remember what we agreed?" | A fixed cancellation window the system enforces |
| Overview | Formulas, colour codes and guesswork | Class lists, attendance, no-shows and revenue per class |
You can see the full list of what Class Booking handles on the features page.
What a booking system does not replace is the community. Keep the WhatsApp or Facebook group for chat, photos and news, just not for sign-ups. It is the mix of conversation and bookings in one thread that creates the mess.
The switch plan: from spreadsheet to booking system in 6 steps
If you have not picked a system yet, start with our guide on how to choose the right booking system. The plan below works whichever one you end up with.
| When | What happens |
|---|---|
| Week 1 | Prepare your data, set up classes and prices, test it yourself (steps 1–3) |
| Week 2 | Invite clients and take the first online bookings (step 4) |
| Weeks 2–3 | Run in parallel: new bookings go into the system only (step 5) |
| Weeks 3–4 | Close the spreadsheet and delete the old lists (step 6) |
Step 1: Prepare your data
Pick a cut-off date, such as the 1st of next month. Every balance is reconciled as of that date, and from then on you stop selling passes "on the spreadsheet". Then gather:
- Client list: name, email and mobile number for your active clients. Leave out anyone who has not been in for over a year.
- Class passes: who, how many classes are left and any expiry date.
- Memberships: who, at what price, how they pay today and when their next payment is due.
- Prepaid courses and gift vouchers that have not been used yet.
- Regular spots: who has "their" place in which class.
Got long lists, or coming from another system? See how we help studios migrate.
Step 2: Set up classes and prices
- Build your weekly timetable with the number of places the room really holds.
- Keep your current prices. Do not change prices and systems at the same time; give clients one new thing to get used to, not two.
- Create class passes and memberships that match what clients have already bought.
- Set a cancellation window, such as 12 or 24 hours before the class, and switch on the waiting list and reminders.
- If clients have regular spots, make sure they can keep them without booking every week. Otherwise the switch feels like a downgrade to your most loyal people.
Step 3: Test it yourself, as a client
Spend half an hour being your own client, on your phone: book a class, pay a small amount with a real card, cancel before and after the deadline, fill a class and watch the waiting list move, and check that the reminder arrives. Then ask two regulars to do the same. They will spot what you missed.
Step 4: Invite clients with one clear message
Send the same message everywhere: by text, by email and in the group chat. Send it again the day before the start date. Here is a template you can copy; just fill in the [brackets]:
Note point 2: do not ask clients for their balance; send it to them. Your figure becomes the starting point, and the client can easily correct it.
Step 5: Run both in parallel for 1–2 weeks
- New bookings go into the system only. If someone texts you, you book them in yourself, in the system, not in the spreadsheet.
- The spreadsheet becomes read-only. It is now a reference, not a working tool. One source of truth, in one place.
- Help the few personally. There are always a couple of clients who need a hand the first few times.
- Check your class lists daily until there is no gap between what you expect and what the system shows.
Step 6: Close the spreadsheet
- Reconcile passes and memberships one last time.
- Ask members who pay by standing order to cancel it on the date their new membership starts.
- Update the link in your Instagram bio, your Google Business Profile and your website.
- Keep one final copy if you need it for your accounts, and delete the rest (see below).
Common pitfalls, and how to avoid them
Double bookings during the changeover
They happen when two channels are open at once: one client books online while another gets a "yes" by text for the last spot. The fix is a firm rule: everything is booked into the system, including requests that arrive by message, and sign-ups in the group chat stop on the day the invitation goes out.
Lost class credits
Typically a pass bought the day before the cut-off, or a class used while you were switching over. Reconcile every balance on one fixed date and send each client their figure in the welcome message. Far better that someone says "I had four classes left, not three" in week one than in week eight.
Members paying twice, or not at all
A standing order does not stop by itself. Put the switch date clearly in your message, and keep an eye on incoming payments for the first month.
GDPR: delete the old lists
Once the switch is done, personal data tends to be lying around in many places: spreadsheets with names and phone numbers, message threads, screenshots, exports in your downloads folder, and Google Sheets that former instructors can still open. Some of it may include notes on injuries or pregnancies, and health data is a special category under GDPR (and UK GDPR). Keep only what your accounting rules require, delete the rest and remove shared access. Our practical GDPR guide for fitness studios goes through it step by step.
Frequently asked questions
When should a studio switch from Excel to a booking system?
When you spend more than a couple of hours a week on sign-ups, messages and payments, or are no longer sure who has classes left. For many studios that is somewhere between 30 and 50 clients, but time and mistakes decide it, not headcount.
How long does it take to switch to a booking system?
Setting up classes and prices can be done over a couple of evenings. With testing, inviting clients and 1–2 weeks of running in parallel, allow 2–4 weeks from the day you start until the spreadsheet is closed.
Can I bring my clients' class passes and memberships across?
Yes. Reconcile the balances on a fixed date and create them in the new system with the classes and expiry date each client has left. Standing orders cannot be moved; they need to be cancelled and replaced by payment through the system.
What do I do with clients who do not want to book online?
Book them in yourself the first few times and show them how after class. What matters is that every booking ends up in the system, even when it arrives by text.
How much does a booking system cost for a small studio?
Class Booking costs £8 / €10 a month for Basic (solo, up to 6 classes a week), £20 / €30 for Pro (up to 5 instructors, 25 classes a week) and £40 / €50 for Studio (unlimited). Payments run through Stripe with no commission on top of Stripe's standard fees, there is no contract, and you can try it free for 14 days without a card.
Ready to close the spreadsheet?
Class Booking brings bookings, card payments, class passes, memberships, waiting lists and reminders together in one place. From £8 / €10 a month, no contract.
Try free for 14 days →