Five reports: what you collected, who joined and who left, who actually turned up, what expires in the next ninety days, and what you are owed. Read together they tell you one story about your gym, and reading them takes about twenty minutes a month.
Below I have worked all five through on the same gym — 168 members in Indore, ₹1,150 a month average — because a list of metric names with no arithmetic under it is the reason most owners read a post like this and change nothing.
Why monthly churn rate is the wrong first number in India
Almost every gym-metrics article you will find is written for a market where members pay by card on the 1st of every month. There, monthly churn is the right lens — someone cancels, the card stops, you count it. The commonly quoted benchmark is 3–5% a month, with anything over 7% meaning the gym is treading water.
That does not describe an Indian gym. Most of your members paid for three months, six months or a year in one go. Nobody cancels — they simply do not come back when the plan ends. Churn is not a monthly trickle here; it lands in lumps on expiry dates.
So the number that matters is your renewal rate: of the memberships that expired this month, what share renewed? Everything else in this post hangs off that. You can still work out a monthly churn figure if you want one for comparison — I do it below — but do not let it be the number you manage by.
Report 1 — What you collected, split by what it was for
Not "revenue". Money actually received, split into the buckets it came from. One total tells you nothing you did not already feel; the split tells you where a change came from.
| Where it came from | July 2026 | June 2026 | Change |
|---|---|---|---|
| Memberships (new + renewals) | ₹1,86,000 | ₹2,04,500 | −₹18,500 |
| Personal training | ₹22,000 | ₹20,500 | +₹1,500 |
| Joining fees and other | ₹6,300 | ₹6,500 | −₹200 |
| Total collected | ₹2,14,300 | ₹2,31,500 | −₹17,200 (−7.4%) |
The Iron Yard, Indore — a fictional but realistically sized gym used throughout this post.
A 7.4% drop in one month is worth a look, and the split has already narrowed it: PT is fine, joining fees are flat, the whole fall is in memberships. That single fact is what makes the next report worth opening. Without the split you would be guessing between a pricing problem, a collection problem and a member problem.
One thing to be careful about here: collected is not the same as earned. When someone pays ₹12,000 for a year in July, July did not earn ₹12,000. If you want the smoother version, divide long plans across the months they cover — but keep the cash view too, because cash is what pays the rent in August.
Report 2 — Members in, members out
Three numbers and one subtraction. Joined, lost, net. The trap is celebrating the first without ever printing the second.
| July 2026 | |
|---|---|
| Members at the start | 171 |
| Joined | 11 |
| Expired and did not renew | 14 |
| Net change | −3 |
| Members at the end | 168 |
| Memberships that came up for renewal | 45 |
| Renewal rate | 31 of 45 = 69% |
| Monthly churn, if you want it | 14 of 171 = 8.2% |
Fourteen lapsed members at roughly ₹1,150 a month is about ₹16,100 — which is very close to the ₹18,500 that vanished from the membership line in Report 1. The two reports have now agreed on a diagnosis. The gym did not have a bad sales month. It had a bad renewal month, and it happened to be a month with a lot of expiries in it.
For reference, the national average Indian facility carries about 265 members, from the Deloitte India and Health & Fitness Association India Fitness Market Report 2025 — the rest of those benchmarks are in our gym industry statistics post. Being under that average is not a problem in itself. Losing more than you add, three months running, is.
Report 3 — Who actually turned up
Attendance is the only report here that predicts the future rather than describing the past. A member stops coming long before they stop paying, usually by two to three months.
Do not read it as an average. Read it in buckets.
| Visits in July | Members | Share | What it means |
|---|---|---|---|
| 0 visits | 31 | 18% | Already gone, still on your list. This is next quarter's non-renewals |
| 1–4 visits | 38 | 23% | Drifting. The group where a message still works |
| 5–11 visits | 52 | 31% | Normal. Roughly once or twice a week |
| 12+ visits | 47 | 28% | Your core. Ask these people for referrals, they will say yes |
1,512 visits across 168 members — about 2.1 visits per member per week. Deloitte/HFA put the national average for paying members at 3.3 sessions a week.
The top row is the whole report. Thirty-one people paid this gym and did not walk through the door once in a month. Nearly all of them will not renew, and almost none of them will tell you why.
This is also the one number that is genuinely hard to get without a system, because a paper register can tell you who came today but not who has not come since June. If you are doing this by hand, our attendance sheet template has the exact formula for days-since-last-visit, and QR check-in is what removes the typing entirely.
Report 4 — What expires in the next 90 days
The only forward-looking report of the five. Everything else tells you what happened; this one tells you what is about to.
| Expiring in | Memberships | Fee value | Expected to renew at 69% |
|---|---|---|---|
| Next 30 days | 39 | ₹47,800 | ~27 |
| 31–60 days | 28 | ₹33,100 | ~19 |
| 61–90 days | 33 | ₹41,500 | ~23 |
| Total | 100 | ₹1,22,400 | ~69 |
Read the first row against Report 3 and the month plans itself. Of the 39 expiring in the next thirty days, pull out the ones who visited zero or one time in July — those need a conversation now, not a renewal reminder on the last day. The rest need the ordinary fifteen-day renewal sequence.
The other use of this table is planning. If about 31 of those 100 will not come back, and you add roughly 11 members a month, you already know that the next quarter is close to flat unless something changes. That is a much more useful thing to know in August than in November.
Report 5 — What you are owed, by age
Split by how old the debt is, never as one total. The age of a due tells you almost exactly how likely you are to see the money.
| Overdue by | Members | Amount | What to do |
|---|---|---|---|
| 1–7 days | 9 | ₹11,600 | One WhatsApp. Most of this clears itself |
| 8–30 days | 11 | ₹18,300 | A phone call from a person, not another message |
| Over 30 days | 9 | ₹17,500 | Decide: payment plan, or write it off and stop counting it |
| Total | 29 | ₹47,400 |
₹47,400 sitting in dues is 22% of a month's collection for this gym. Owners tend to carry that number in their head as one lump and feel vaguely bad about it. Split by age it becomes three different jobs, only one of which is unpleasant.
The bottom row is the one to be honest about. Money over thirty days late rarely arrives on its own, and leaving it on the books flatters your figures. This is the report that is worth having built rather than assembled — payment records that age the dues for you turn a monthly reconstruction job into a screen you open. Either agree a plan with the member in writing or take it off the list — we set out the whole ladder, including the messages, in reducing pending dues.
The story the five tell together
Any one of these reports on its own is a number. Read in order they are a diagnosis, and for this gym it goes like this. Collection fell 7.4%, and the fall was entirely in memberships. Fourteen members lapsed against eleven joins, so the renewal rate — 69% — is the problem, not the sales pipeline. Attendance explains why: 31 members did not visit at all in July, and people who have stopped coming do not renew. Ninety-nine more memberships expire in the next three months. And ₹47,400 is already owed, a third of it beyond saving.
The action list falls out of that on its own. Call the zero-visit members who expire in the next thirty days — that is maybe nine people, one afternoon, and it is worth more than any marketing spend this gym could make in August. And of the fourteen who already lapsed, message them: Deloitte and the HFA found that 48% of Indians who stopped a gym membership would consider rejoining. A lapsed member costs you a message; a new one costs an advertising budget.
The twenty-minute monthly ritual
- Pick a fixed slot — first Monday of the month, before the gym gets busy. A report you read when you feel like it is a report you read twice a year
- Open the five in the order above. Collection, members in and out, attendance buckets, expiries, dues
- Write one action per report. Five lines on paper, not a plan document
- Only one of those five actions has to be a phone call to a member. Make sure one of them is
- Keep last month's sheet next to this month's. The trend is the point — a single month tells you almost nothing, three months in a row tells you everything
The reports that look useful and are not
- Total lifetime members. It only ever goes up, so it cannot tell you anything. Owners quote it in conversation and never act on it
- Daily footfall on its own. It moves with weather, festivals and exam season. Look at it monthly against the same month last year, or not at all
- Revenue per square foot. Borrowed from retail. Your rent is fixed and you are not going to shrink the building
- Social media followers. Not a gym report. Nobody has ever renewed because of a reel
- Anything you cannot name an action for. If a number goes up and you would do nothing differently, stop printing it
Common questions
What reports should a gym owner track monthly?
Five: money collected split by source, members joined versus members lost, attendance grouped into visit buckets, memberships expiring in the next 30/60/90 days, and outstanding dues split by how overdue they are. Read in that order they explain each other.
What is a good renewal rate for a gym in India?
Most independent Indian gyms sit somewhere between 60% and 75% of expiring memberships renewing. Below 60% you have a retention problem that no amount of new sign-ups will cover. The more useful comparison is your own rate three months ago, not somebody else's number.
How do I calculate churn rate for a gym?
Divide the members you lost in the month by the members you had at the start of it. Fourteen lost from 171 is 8.2%. In India this figure is lumpy because plans are prepaid, so track renewal rate at expiry as your main number and treat monthly churn as a rough comparison.
How often should I look at gym reports?
Monthly for all five, in one twenty-minute sitting. Two are worth a weekly glance during a bad patch — expiring memberships and outstanding dues — because both have a window where acting still changes the outcome.
Can I track all this in a spreadsheet?
Reports 1, 2, 4 and 5 are very doable in a sheet. Report 3 is where it breaks down, because attendance needs a row written for every visit, every day, and the gaps show up exactly when the desk is busiest. That is usually the report that decides whether a gym moves off spreadsheets.
If twenty minutes a month sounds like a lot, start with two reports: attendance buckets and what expires in thirty days. Those two, read together, are where almost all of the recoverable money in a gym is sitting.