Gym cost per visit is the fee you paid divided by the number of times you actually went. Mark each visit in a simple monthly log and divide; the same fee that works out to a modest amount per visit in a busy month can look expensive in a quiet one. That figure answers the question of whether a membership is worth it better than the fee itself.
How do I keep the attendance log?
Use one column for the date and one for a short mark: Yes if you went, blank if you did not. A sheet with one row per day of the month works, and so does a list where you only add the days you attended. If you scan a card at the gym door, check whether the gym app shows your own visit history and copy from it at month end.
- Column A: date
- Column B: Yes for a visit
- Column C: optional note, such as class name or personal training
- Cell E1: the month's fee
What is the formula for cost per visit?
With visits marked in B2:B32 and the month's fee in E1, use =IFERROR(E1/COUNTIF($B$2:$B$32,"Yes"),"no visits"). The IFERROR part prevents an error message in a month when you did not go at all.
What does it look like across months?
Say the fee is ₹3,000 a month. The visit counts below are made up to show the spread.
| Month | Visits | Working | Cost per visit |
|---|---|---|---|
| April | 18 | 3,000 / 18 | ₹167 |
| June | 6 | 3,000 / 6 | ₹500 |
| August | 12 | 3,000 / 12 | ₹250 |
| November | 20 | 3,000 / 20 | ₹150 |
The fee never moved, yet the price per visit swung from ₹150 to ₹500. Over the four months here you paid 4 x 3,000 = ₹12,000 for 18 + 6 + 12 + 20 = 56 visits, which is about ₹214 a visit on average. A yearly average is more honest than the best month.
Is a quarterly or annual membership different?
The arithmetic is the same, with one twist: divide the whole fee by the whole period's visits. If you paid ₹18,000 for a year and went 96 times, the cost per visit is 18,000 / 96 = ₹187.50. Log the date you paid and the period it covers, so that when the membership ends you can compute the real figure instead of guessing.
What if I go for classes and personal training too?
Add a note for those visits and, if they are charged separately, keep them in a different column so they do not dilute the membership figure. The membership cost per visit should include only the fee and only the visits it covers.
What should count as a visit?
Decide the rule once. A common one is any day you went and trained, however briefly, counts as one visit; going twice in a day is still one. If you only used the steam room or collected a locker key, that is not a visit. A clear rule keeps the months comparable, and it stops you flattering the figure when you are feeling guilty.
Does the joining fee belong in the calculation?
Keep it separate. A one-time joining or registration fee is a start-up cost, not a monthly cost. Note it in the log once, and when you want the full picture add it to the first year's total and divide by that year's visits. From the second year onwards, the figure without it is the one to track.
Where does the fee show up?
If the gym debits your account or card every month, the charge appears on your statement. Import it into SpendixAI, categorise it under fitness, and a monthly view will show the fee next to your other health spending. The visit count stays in your own log, because the product records transactions, not attendance.
Month-end routine
- Count the visits
- Divide the fee by the count
- Write the result next to the month
- After three months, look at the average and decide if the plan still suits you
Useful ideas start with a clearer picture of your own spending.
Explore your reports

