physiotherapy, weight training, dumbbells, exercise balls, weight loss, workout, health, gym, therapist, physiotherapist, healthcare, fitness, wellness, rehabilitation, healing, therapeutic, weight loss, weight loss, workout, health, gym, gym, gym, gym, gym, fitness, fitness, fitness. What fitness studio software must record, and how to keep your data
Photo by stevepb on Pixabay

Guides

What fitness studio software must record, and how to keep your data

Nine things a fitness studio booking system must record to answer capacity questions, how to keep your data portable, and the numbers to read each month.

What to take away

  • Choose the booking system on what it records, not on what it displays. A dashboard you cannot export is somebody else's asset.
  • The one thing it must record is package type against every single booking. Without that, revenue per attendance cannot be calculated at all.
  • Waitlist and no-show events are data. If the system does not store them, your capacity policy is unenforceable.
  • Get your member and attendance data out once, before you need to, and confirm what the file actually contains.
  • Member data brings obligations. Ask what applies where you trade rather than assuming the vendor has handled it.

Studio software is usually chosen by watching a demonstration of the booking screen. That screen is the least important part. What matters is what the system writes down, because that is what you will still have in three years and what every useful question depends on.

What the system has to record

Nine things. A system missing any of them will eventually stop you answering a question that matters:

What the system must record

  • Every booking, with its package
  • Attendance separate from booking
  • Cancellations, timed against class
  • Waitlist entries, offers, acceptances
  • Class format, instructor, scheduled size
  • Member history in one place
  • Payments tied to package and period
  • Every booking, with the package it was made under.
  • Every attendance, separately from every booking, so a no-show is visible.
  • Every cancellation, with when it happened relative to the class.
  • Every waitlist entry, offer, and acceptance or expiry.
  • The class instance itselfformat, instructor, scheduled size, and actual size.
  • The member's history in one place, including gaps.
  • Every payment, tied to the package it paid for and the period it covers.
  • Freezes and their start and end dates.
  • Who changed what, and when, for anything a member could dispute.

Number one is the one studios discover too late. If a booking does not carry its package type, you cannot allocate a monthly fee across the attendances that member made, which means revenue per attendance is unknowable and every comparison between formats or slots rests on guesswork.

Data you must be able to take with you

Before committing, export everything and open the files. Not a demonstration of the export button: the actual files, read by you.

What a real export contains

  • Bookings and attendances as separate records
  • Package type carried on each booking
  • Unambiguous dates
  • Member history intact, not summarized
  • Not just a member list and revenue total

Check that the export contains bookings and attendances as separate records, that it carries package type, that dates are unambiguous, and that member history is intact rather than summarized. A system that exports a member list and a revenue total has not given you your data.

Then do it again once a quarter, and keep the file somewhere you control. Vendors change, terms change, and businesses close. The export you never needed costs an hour a quarter.

Security and access, in proportion

You hold names, contact details, payment arrangements, and attendance patterns. That is a real responsibility, and the practical version is unglamorous: individual accounts rather than shared ones, access removed the day somebody leaves, and a short list of who can see what.

The National Institute of Standards and Technology publishes small business quick-start guides aimed at exactly this scale of operation, and the Cybersecurity and Infrastructure Security Agency's material for small and medium businesses covers the same ground from another angle. Both are worth an hour.

What your legal obligations are regarding member data depends on where you trade and on what you collect, and a vendor's assurance is not an answer to that question. Put it in the compliance register described in the map of who owns which compliance question, with the office you asked and the date.

The numbers worth reading

Three groups, and each answers a different question.

Three numbers worth reading

Capacity

Question
Does the business work?
Measure
Attendances vs seats
Split
Peak and off-peak
Timing
Now

Retention

Question
How fragile is it?
Measure
No attendance in period
Split
Share of paying members
Timing
Moves first

Delivery

Question
How is it running?
Measure
Late starts, cancellations
Split
Cover requests
Timing
Predicts two months out

Capacity. Attendances against seats available, per slot, split into peak and off-peak. This is the number that tells you whether the business works. Everything else is downstream of it.

Retention. Members with no attendance in a set period, as a proportion of paying members. This is the fragility number, and it moves before the membership count does.

Delivery. Late starts, canceled classes, and cover requests. These are operational and they predict retention two months out.

What each of these fails to show is as important as what it shows. Define every measure in writing before you track it, and write its blind spot beside it, or two people will count the same thing differently and argue about the result.

The traps in studio reporting

Membership count rises after attendance has turned. It is the most flattering number in the business and the slowest to tell you anything.

Reporting traps and what they hide

Trap

Membership count
Rises after attendance turns
Cash-basis revenue
Cash is future obligation
Weekly averages
Peak-full, off-peak-empty
Percentages
The denominator

What it hides

Membership count
Cash-basis revenue
Weekly averages
Percentages

Revenue reported on a cash basis makes a strong intake month look like a strong trading month, when much of that cash is an obligation to deliver classes later.

Averages across the week hide the shape of the business. A studio at fifty percent average occupancy might be full at peak and empty the rest of the time, which is a completely different situation from one that is half full everywhere.

Anything the system reports as a percentage without showing the denominator. Ask what it is dividing by before you act on it.

Migrating without losing your history

Changing systems is where studios lose the data they most need, and it happens quietly. A migration typically carries members, current memberships, and forward bookings. It frequently does not carry historical attendance, package type on past bookings, or the waitlist and no-show record.

What migration carries and drops

Usually carried

Members
Yes
Current memberships
Yes
Forward bookings
Yes
Historical attendance
No
Package type on past bookings
No
Waitlist and no-show record
No

Frequently dropped

Members
No
Current memberships
No
Forward bookings
No
Historical attendance
Yes
Package type on past bookings
Yes
Waitlist and no-show record
Yes

History is what every capacity question depends on, so decide before migration what happens to it.

The usual answer: export the old system in full, keep the files somewhere you control, and accept that reporting across the boundary needs those files, not the new system. Say that out loud before you switch. In eighteen months, nobody is surprised the year-over-year comparison cannot be produced from one screen.

Software as an operational dependency

A booking system is not just a record. It is part of the operation, and when it is unavailable the studio still has to run classes. Somebody on shift needs to know how to check people in on paper, and how to reconcile afterwards.

That belongs in induction rather than in a conversation on the day, which is part of how instructors are hired and trained, and the routine it sits inside is how the operating day is sequenced.

What the system has to support commercially

The packages you sell have to be expressible in the system exactly as you sell them, including off-peak restrictions, caps, freezes, and expiry. A system that cannot express a package will quietly force you to change the package, which is the tail wagging the dog.

Before choosing, list every package you sell, including the awkward ones, and build each in a trial account. Then check that price changes, notice periods, and grandfathered rates can be handled, because those are what how membership pricing is structured will eventually require.

The demand side works the same way. To point offers at specific slots, the system must restrict an offer to a slot. That is what how demand is pointed at the hours you need filled depends on.

The room's actual capacity, which every seat calculation rests on, comes from the floor plan and the equipment on it.

Records, beyond the booking system

Financial records are a separate matter and the booking system is rarely sufficient. The Internal Revenue Service's guidance on what records a business should keep sets out what documentation supports income and expenses, and how prepaid revenue should be treated is a question for an accountant rather than for a software setting.

Staffing records are a third category. The Bureau of Labor Statistics profile of fitness trainers and instructors describes the working patterns the role involves, which is context for what your system needs to track about who taught what and when.

Common questions

How do I evaluate a booking system without committing?

Run a structured trial with your own data and your own packages, and score every candidate the same way. Watching a demonstration tells you about the demonstration.

Is an all-in-one system better than separate tools?

It is simpler and it concentrates your dependency. The question to ask is what happens if you want to leave: an all-in-one system holds more of your business, so the export test matters more, not less.

What if my current system does not record package type per booking?

Find out whether it can be configured to. If it genuinely cannot, that is a strong reason to move, because it makes the central economic question of a studio unanswerable.

How often should I look at the numbers?

Capacity weekly, retention monthly, delivery weekly. Looking at everything monthly means you find out about a slot problem six weeks after members did.

Should I keep paper backups?

Keep an offline copy of your exports, and keep a paper method for check-in that somebody on shift knows how to use. Both are cheap and both are only needed on the day everything else is unavailable.

More in Guides

Latest from Records Desk