CSV template
Gym membership renewal tracker
Track gym members, plans, start and end dates, dues and renewal follow-ups in one sheet.
What is in it
One row per member. Sort by end date each week to see who to remind, and keep dues next to the plan.
Download membership-renewal-tracker.csv (CSV)
Opens in Excel, Google Sheets or LibreOffice Calc.
Columns
- Member ID: Your member number
- Name: Member name
- Plan: Monthly, quarterly, yearly…
- Start date: When the current plan began
- End date: When it ends
- Amount: Plan price
- Paid: Amount received
- Due: Amount minus paid (a formula in row 2 you can copy down)
- Last visit: Date of the most recent check-in
- Reminder sent: Date you reminded them
- Renewed: Yes or no
How to use it
- Enter every active member with their plan dates.
- Each week, sort by end date and remind members whose plans end in the next ten days.
- Watch the last-visit column: members who stop coming rarely renew.
Related
Useful next.
- Guide · 6 min readHow to Track Gym Membership RenewalsMany lapsed members never decided to leave; nobody reminded them in time. A renewal list, a fixed reminder schedule and one monthly number are enough to change that.
- Free toolGym membership revenue calculatorProject monthly membership revenue over a year from active members, average fee, new joins and members who leave each month. Free, runs in your browser.