Gym Membership Register in Excel (Free) – Renewal Alerts & Fee Receipt Format

gym membership register

Advertisement

Quick answer: A gym membership register keeps one row per member with these columns:

  • name and phone
  • plan and start date
  • end date (start + plan months − 1 day)
  • days left and a status: active, renew soon or expired
  • fee, amount paid and balance

Download the free Excel register below. It works out the end date and days left, highlights members due for renewal in orange and expired members in red, and prints a fee receipt for any member.

Key takeaways

  • End date and days left are worked out from the plan. Monthly, quarterly, half-yearly and yearly plans are included, and the names, months and fees can be changed.
  • Renewal alert: members expiring within 7 days turn orange and expired members turn red.
  • Fee, paid and balance for each member, so part payments aren’t forgotten.
  • A printable fee receipt with the amount in words and the membership validity. Free, with no macros.

↓ Jump to the free download

FOR GYMS & STUDIOSKnow who to renew this week.XploreGym tracks memberships, renewals and fees, and sends WhatsApp reminders in one click.See XploreGym — from ₹499 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreGym

Gym membership register in Excel with end date, days left and renewal status
Expiring members show in orange and expired members in red. Balances show where only part of the fee has been paid.

What to record for every gym member

ColumnWhy it matters
Name and phoneThe phone number is how you send renewal reminders, usually on WhatsApp.
Plan and start dateThese decide the end date. A quarterly plan from 21 July ends on 20 October.
End date and days leftYour renewal list: who to remind this week.
Fee, paid and balancePart payments are common. The balance column stops them being forgotten.

How the end date is calculated

End date = start date + plan months − 1 day. Excel’s EDATE function adds the months, so a monthly plan starting 19 September ends on 18 October. For a plan counted in days, such as a 15-day pass, add the days instead.

Days left = end date − today. When days left is 7 or less the member shows as “Renew in X days”. Once it goes below zero, the member shows as “Expired”.

Advertisement

Gym fee receipt format

Gym fee receipt format in Excel with membership validity and amount in words
Choose the member number and print the receipt or save it as PDF to send on WhatsApp.

A gym fee receipt should show:

  • the gym name
  • the receipt number and date
  • the member’s name
  • the plan and its validity
  • the amount in figures and words
  • any balance still due

If your gym is registered for GST, also show your GSTIN and the GST charged.

Tips to improve renewals

  • Remind before expiry, not after. A message 5–7 days before the end date gets more renewals than one a week after.
  • Offer the longer plan at renewal. Members who are already coming regularly are the most likely to move from monthly to quarterly.
  • Watch members who stop visiting. Someone who hasn’t come for 10 days is unlikely to renew. A quick call can save the membership.
Outgrown the free sheet? Here’s what XploreGym adds

Free sheetXploreGym
Freeze days & discounts—✓
Member card—✓
Monthly report with renewal rate—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreGym — from ₹499 →

Download the free Gym Membership Register

There are two sheets: Member Register (up to 100 members) and Fee Receipt. Fill in the yellow cells. It works in Excel, Excel for Mac and Google Sheets.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

Can I use it for a yoga studio, dance class or coaching?

Yes. Rename the plans, for example to “Monthly batch” or “10-class pack”, and set the months and fees. Everything else works the same.

How do I renew a member?

Change the start date to the renewal date, update the plan if it’s different, and update the amount paid. If you want to keep the full history of every renewal, XploreGym records each renewal as a separate entry.

Does a gym need to charge GST?

Gym services are taxable under GST, but a gym only needs to register once its turnover crosses the registration limit for services. Check with your CA. If you’re not registered, don’t add GST to your receipts.

Advertisement

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.