Month end at head office
You run four gyms. Each site manager sends a monthly summary: members, joins, cancellations, freezes and income. Two use the same template. One sends a screenshot from the management system. One is late. Head office combines them in a spreadsheet, then tries to reconcile the income with what the direct debit provider paid out.
The numbers never quite agree. One site counts frozen members as members; another does not. One counts a cancellation when it is requested, another when it takes effect. By the time the report is finished, it is halfway through the following month, and the questions it raises are about last month.
Each site measures things its own way
Gym chains grow one site at a time. Each new site is set up slightly differently, and site managers develop their own habits for reporting.
- Sites may be on separate accounts in the management system, or different systems entirely.
- Definitions differ: active member, cancellation date, freeze, joiner.
- Payment data from the direct debit provider is not split by site in a useful way.
- Visit data from door systems is not linked to membership reporting.
- Monthly reports are built by hand, and formulas are copied month to month.
The result is that head office cannot compare sites on a fair basis, or see a problem early.
Decisions made on last month's guesses
When a site starts losing members, the signs are there early: fewer joins, more cancellations, falling visits. In a monthly spreadsheet built weeks later, they show up too late to act on quickly.
Head office time is also consumed by building reports rather than reading them. And disagreements with site managers about whose numbers are right take energy away from the conversation that matters, which is what to do about them.
Members who move between sites complicate everything. A member on a multi-site plan who joined at one gym and trains mostly at another may be counted at both or neither, depending on who built the report. Income may be allocated to the joining site while the visits land somewhere else, which makes each site's performance look different from reality.
Price and plan comparisons suffer too. Without consistent data, you cannot say whether a new plan launched at one site is doing better than the old one at another, or whether an introductory offer brought members who stayed.
One dashboard with one set of definitions
- We connect to each site's gym management system, payment provider account and access system through their APIs or scheduled exports.
- We agree one set of definitions with you: what counts as active, when a cancellation counts, how freezes are treated.
- Data is pulled daily, cleaned and mapped to those definitions, so every site is measured the same way.
- A dashboard shows each site and the whole chain: active members, joins, cancellations, freezes, failed payments, income collected and visits.
- Trends are shown weekly as well as monthly, with alerts when a site moves outside the range you set.
- Site managers see their own site's figures, using the same definitions as head office.
- Payment provider payouts are reconciled by site, so income figures match the bank.
| Measure | Definition agreed once | Updated |
|---|---|---|
| Active members | Paying or frozen, by your rule | Daily |
| Joins | First successful payment | Daily |
| Cancellations | Effective date, not request date | Daily |
| Income collected | Payouts by site | As paid out |
| Visits | Door access entries | Daily |
We can use Google Sheets as the output if head office prefers a spreadsheet, as long as the data behind it is pulled automatically.
Head office with live numbers
On any morning, head office sees each site's position without waiting for anyone. Site managers stop building reports and use the same figures to run their site. When a site's cancellations rise, it shows up in a week, not a month.
Meetings with site managers start from agreed numbers. And when you consider opening another site, you have a clear picture of how each existing site has grown since it opened.
Investor or lender reporting also becomes easier, because the figures are consistent across sites and can be produced for any period without a month of rebuilding.
Does this sound like your chain?
- Monthly reports are built by combining site spreadsheets.
- Sites define members and cancellations differently.
- Income figures do not match payment provider payouts easily.
- You find out about a site's decline weeks after it started.