Moving your studio off spreadsheets: the 7 things to set up first

Plenty of good studios run for years on a shared spreadsheet, a calendar, and a group chat. It works right up until it doesn't — and the failure is rarely dramatic. It is a credit counted wrong, a class double-booked because two people were editing the sheet, a payment you forgot to chase, a no-show you had no way to charge. Each one is small. Together they are a slow leak of money and goodwill, and they get worse exactly as you get busier.

This is a guide for the move most studio software articles skip: not switching from one tool to another, but going from no software at all to your first real system. If you teach classes, sell packs or memberships, and currently hold it together with spreadsheets and paper, this is the order to do it in, and how to do it without losing your data or your nerve.

How to tell you've outgrown the spreadsheet

You do not need all of these. Any two is usually enough:

• You book clients in by replying to texts and messages, by hand, one at a time.
• You track pack credits in a column and you have got them wrong at least once.
• You are chasing payments after class instead of taking them at booking.
• A reformer or a spot gets double-booked because the schedule lives in a file two people edit.
• No-shows cost you money you have no clean way to recover, because nothing was taken up front.

The maths is usually decisive. One avoidable double-booking or unpaid class a week tends to cost more than entry-level studio software, which starts around $39 a month. The spreadsheet is not free; it is just billing you in mistakes instead of a subscription.

Set it up in this order

The single biggest mistake people make is importing their client list first, into an empty system, and then wondering where everyone's packs went. Build the structure first; bring the people in last. Here is the dependency order.

1. Your services and class types

Everything hangs off services, so they come first. A "service" is the thing you teach — Reformer Flow, Beginner Mat, Open Level Vinyasa, a 1:1 private. Each one carries its default price, duration, and capacity. Build these before anything else, because a class needs a service to exist, a pack needs to know what it buys, and a membership needs to know what it covers. Get the layer underneath right and you never rebuild it.

2. Your schedule, with capacity and spots

Now put classes on the calendar. Each class is an instance of a service at a time, in a room, with a capacity. If you run equipment-based classes, this is where spot or reformer-by-reformer booking matters: a class of twelve reformers should let clients pick a reformer, not just take a numbered place. Set recurring classes up as a repeating pattern so you are not rebuilding next week by hand. If you run beginner blocks or teacher-training cohorts, set those up as term-based courses — sold as a block, not as twelve separate bookings.

3. Payments — through your own account

Connect your own Stripe account before you sell anything. This is the step that turns the software from a calendar into a business system: clients pay when they book, and the money lands in your account, on your processing rate, on your payout schedule. Crucially, it is your account connected to the software, not the software's processor holding your money — which means your rates and your client relationships stay yours, and leaving later does not mean re-collecting everyone's card. You can still mark the occasional cash or bank-transfer payment by hand for clients who pay that way.

4. Your packs and memberships

Now build your pricing model on top of the services. Class packs (ten classes, deducted one credit per booking) and memberships (monthly, auto-renewing, metered or unlimited) are the core of studio revenue, and this is where you decide how clients buy. Set each one to reference the right services, and decide the cancellation behaviour per plan while you are here — what a late cancel or no-show costs a pack holder versus an unlimited member is a decision worth making deliberately rather than discovering later.

5. Your storefront — the booking page

This is the page your clients actually live in. Your schedule, packs, and memberships become a public booking page where clients book and pay without an account or a phone call. Pick a theme, add your studio's name and brand, and then do the one test that matters: book a class on it yourself, as if you were a new client. If that takes more than a minute, fix it now, because every new client meets you here first.

6. Intake and policies

Set your waiver and intake form, and your cancellation window, before you open the doors. New studios often want an emergency contact and a liability waiver on a client's first booking; a conditional intake form collects exactly that once and gates the first booking on it. Set your cancellation window too — commonly 24 hours for privates and 12 to 24 hours for group classes — so the policy is published and enforced rather than improvised at the desk.

7. Automated reminders

Turn these on last, and they immediately start paying for the whole system. Automated booking confirmations and class reminders are the cheapest no-show reduction there is: a client who gets a reminder the day before either shows up or cancels in time for someone on the waitlist to take the spot. Welcome emails, failed-payment notices, and membership-renewal reminders run on the same automation, doing the chasing you used to do by hand.

Bringing your existing clients across

Only now, with the structure built, do you import people.

Export your spreadsheet to CSV and import your client list — names, emails, phone numbers. If clients have active pack balances or memberships, bring those across too, so a regular with four classes left on a pack still has four classes left, not zero. Spot-check a handful after import: pick three clients you know well and confirm their details and balances landed correctly. Getting the structure in first is what makes this step boring instead of a disaster — the packs and memberships already exist for the balances to attach to.

Keep one thing from the spreadsheet era

The discipline. The reason a good spreadsheet studio is a good studio is that someone is paying attention — to who is coming, what they have bought, who has drifted. Software does the counting so you do not have to, but it does not replace the noticing. Use the time it gives back to actually look at the numbers it now keeps for you: which classes fill, which clients are lapsing, which packs sell. The spreadsheet made you do that manually. The software should make it easier, not let you stop.

On committing without it being a one-way door

The thing that keeps studios on spreadsheets too long is, reasonably, the fear of getting locked into the wrong software. The protection against that is simple and you should insist on it: free, one-click CSV export, any time. If you can pull your full client list, booking history, and balances back out whenever you want, then trying a system is reversible, and the decision stops being a leap. Choose software that treats your data as yours — exportable for free, no exit fee — and the first commitment is a trial, not a marriage.

Where Junocal fits

Junocal is built for exactly this move. The Starter plan is $39 a month, month-to-month, with a 14-day free trial — services, schedule with spot booking, packs, memberships, term courses, storefront, intake forms, and automated reminders all included, with payments through your own Stripe account and ACH or Direct Debit from day one. Your client list imports from CSV, and it exports back to CSV for free whenever you want, so moving in is not a door that locks behind you. There is more on why I am building it this way, and a guide to setting cancellation policies that actually cut no-shows once you are running.

The short version

Build the structure before you import the people: services first, then schedule, then payments through your own account, then packs and memberships, then storefront, then policies, then reminders — and bring clients and balances across last. Connect your own Stripe so the money stays yours. Test the booking page as a client. And only move onto software you can export from for free, so leaving spreadsheets behind is a step forward you can always walk back. The spreadsheet was never free; it was charging you in mistakes. This is the upgrade that stops the leak.