# Gym memberships tracker (Excel) (free Excel template)

> Track gym members, plans, subscriptions with end dates, payments and attendance, with a renewal list, lapsed members and a monthly summary of money and visits.

Source: https://softwiro.com/templates/gym-memberships
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Gym memberships tracker (Excel)

A free Excel sheet for managing gym memberships. You enter your plans and members and record every subscription and renewal. The sheet calculates the end date and status of each member (active, expiring soon or expired), what they have paid and what is left to pay. It collects the attendance log to show who has stopped training, lists who needs to renew, and gives a summary of numbers, amounts and visits.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gym-memberships.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gym-memberships-blank.xlsx)

Excel file (.xlsx) · 310 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| كود العضو | الاسم | تاريخ انتهاء الاشتراك | أيام حتى الانتهاء | الحالة | المتبقي | النشاط |
| --- | --- | --- | --- | --- | --- | --- |
| G01 | أحمد علي | 46391 | 64 | ساري | 0.00 | نشط |
| G02 | محمد سامي | 46304 | -23 | منتهي | 300.00 |  |
| G03 | كريم فؤاد | 46328 | 1 | ينتهي قريبًا | 0.00 | نشط |
| G04 | يوسف نبيل | 46337 | 10 | ساري | 0.00 | نشط |
| G05 | ليلى حسن | 46356 | 29 | ساري | 500.00 | منقطع |
| G06 | عمر خالد | 46350 | 23 | ساري | 300.00 | لم يحضر |
| G07 | هبة مصطفى | 46248 | -79 | منتهي | 0.00 |  |
| G08 | تامر وليد | 46354 | 27 | ساري | 0.00 | نشط |
| G09 | نورا سمير |  |  | بدون اشتراك | 0.00 |  |
| G10 | باسم رضا | 46327 | 0 | ينتهي قريبًا | -100.00 | منقطع |

Example from the “الأعضاء” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- "الإعدادات" (Settings): Today's date (or =TODAY()), the number of days for the expiring-soon alert (7 in the example), the number of days that counts as lapsed (14 in the example), and any date inside the month you want summarised (October 2026 in the example).
- "الباقات" (Plans): Each plan's name, price and duration in months. The example has four plans: monthly 600, quarterly 1,500, half-yearly 2,700 and yearly 4,800, and the table holds 200 plans.
- "الأعضاء" (Members): Code, name, phone and join date, then the sheet calculates the number of subscriptions, the end date of the latest subscription and days left on it, the member's status, the value of their subscriptions, paid and remaining, visits in the last 30 days, last attendance and activity (active, lapsed or never attended). It holds 500 members.
- "الاشتراكات" (Subscriptions): Record each subscription and renewal: start date, member code, plan and discount. The member's name, plan price, net amount, duration and end date appear automatically. It holds 1000 subscriptions.
- "الدفعات" (Payments): Each amount a member pays, with date, code, payment method (cash, bank transfer or card) and a note; the member's name appears automatically. It holds 2000 payments.
- "الحضور" (Attendance): One row per visit: date and member code, and the name appears automatically. It holds 2000 visits.
- "للتجديد" (To renew): Members whose subscriptions have expired or are close to expiring, oldest expiry first, with phone, end date, days to expiry (negative means the subscription has expired) and the amount they still owe. It shows the first 50 members.
- "الملخص" (Summary): The number of members, active, expiring soon, expired and with no subscription, lapsed and never attended, the value of subscriptions, paid, remaining and paid in advance, the chosen month's figures (new subscriptions, their net value, collected, new members and visits), visits today and in the last 30 days, and a breakdown by plan and payment method.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

Open "للتجديد" (To renew) and you find who has expired or is about to, without going through a notebook. Open "الأعضاء" (Members) and see who has stopped coming while still subscribed. From "الملخص" (Summary) you know how many subscriptions are active, how much members still owe you and how many visits were recorded.

## How to use it

1. In the "الإعدادات" (Settings) sheet, enter today's date (or =TODAY() so it updates itself), the number of days for the expiring-soon alert, the number of lapse days, and a date inside the month you want summarised.
2. In the "الباقات" (Plans) sheet, enter each plan's name, price and duration in months.
3. In the "الأعضاء" (Members) sheet, record each member: code, name, phone and join date.
4. In the "الاشتراكات" (Subscriptions) sheet, enter each subscription or renewal: start date, member code, plan and any discount, and the sheet calculates the price and end date.
5. In the "الدفعات" (Payments) sheet, record every amount a member pays, and in the "الحضور" (Attendance) sheet record every visit with its date and member code.
6. Open "للتجديد" (To renew) to find members whose subscriptions have expired or are about to, and check "الملخص" (Summary) for numbers, amounts and attendance.

**Before you start:**

- End date = start date + plan duration in months − 1 day. A one-month subscription starting on 2026-10-02 ends on 2026-11-01.
- A member's status is calculated from the latest subscription that started for them: "active", "expiring soon" (within the alert days) or "expired", and "no subscription" for someone with none recorded.
- Net = plan price − discount. Remaining for a member = net of all their subscriptions − everything they paid; a negative number means they paid in advance.
- Activity is calculated only for members with an active subscription: "active", "lapsed" (has not attended for the lapse days or more) or "never attended" (no visits recorded).
- Visits in the last 30 days include today and the 29 days before it. Record one row in "الحضور" (Attendance) for each visit.
- The sheet holds 500 members, 1000 subscriptions, 2000 payments and 2000 visits, and "للتجديد" (To renew) shows the first 50 members.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gym-memberships.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gym-memberships-blank.xlsx)

Excel file (.xlsx) · 310 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: managing gym memberships (1/3)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-1.jpg)[![Cheat sheet: managing gym memberships (2/3)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-2.jpg)[![Cheat sheet: managing gym memberships (3/3)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/gym-memberships/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### How is the subscription end date calculated?

End date = start date + plan duration in months − 1 day. A monthly subscription starting on 2 October 2026 ends on 1 November 2026, so it stays active until the end of that day.

### What happens when a member renews?

You add a new row in "الاشتراكات" (Subscriptions) with the renewal start date. The sheet uses the member's latest subscription to calculate the end date and status, and the old subscriptions still count toward the value of their subscriptions.

### When is a member considered lapsed?

Activity is calculated only for members with an active or expiring-soon subscription. If it has been the number of lapse days set in the settings (14 in the example) or more since their last attendance, they are "lapsed", and if no visit is recorded for them they are "never attended".

### How is the amount remaining for a member calculated?

Remaining = net of all their subscriptions (plan price minus discount) − total they have paid. A negative number means they paid in advance.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

More free templates for: Gyms and fitness

## More free templates

- Strength workout log
- Running, cycling and swimming log
- Training load sheet for any sport (session-RPE)
- Athlete nutrition and macros sheet
- Football player match stats sheet
- Basketball player game stats
- Swimming times and personal bests
- Martial arts and boxing training log
- Tennis and padel match log
- Athletics results and personal bests log
- Padel and 5-a-side court booking sheet (hourly)
- Compound assets and periodic maintenance sheet
- Beauty salon bookings tracker (Excel)
- Gate and security sheet
- Car workshop job orders tracker (Excel)
- Compound shared facilities booking sheet
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- Poultry farm cycle tracker (Excel)

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
