# Gym Membership Tracker Excel (Free, Renewals)

> A free Excel gym membership tracker: plans, members, payments and check-ins, with an end date and status for every member and a renewals list of who to call.

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

---

Free Excel template

# Gym Membership Tracker for Excel

A free Excel gym membership tracker for a gym, studio, boxing club or any club that sells time-based memberships. You list your plans once, add each member once, and log every sign-up or renewal with its start date. The sheet works out the end date, tells you who is Active, Expiring soon or Expired, shows what each member owes, and puts the people you need to call on a Renewals list. Payments and check-ins have their own logs, and the Dashboard charts members, money and attendance. It opens in Excel, LibreOffice and Google Sheets, and it works in any currency.

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

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

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

| As of | 46342 |  |  |
| --- | --- | --- | --- |
|  |  |  |  |
| Members | 24 | Payments received (month) | 330.00 |
| Current members (active) | 18 | Outstanding balances | 55.00 |
| Expiring soon | 4 | New members (month) | 7 |
| Expired | 5 | Check-ins (month) | 76 |
| Lapsing (no recent check-in) | 2 | Members to contact (Renewals) | 8 |
| Status | Members | Month | New members |
| Active | 14 | Jan | 1 |
| Expiring soon | 4 | Feb | 0 |
| Expired | 5 | Mar | 2 |
| No membership | 1 | Apr | 1 |

Example from the “Dashboard” tab, with the numbers and formulas that are in the file.

## What is inside

- Dashboard: Members, current members, expiring soon, expired, lapsing members, payments received and new members in the chosen month, outstanding balances and how many people are on the renewals list. Four charts: members by status, current members by plan, payments by month and check-ins with new members by month.
- Renewals: The members to contact: those expiring within your warning window and those who expired recently. Each row shows phone, plan, end date, days left and balance due, in red for expired and yellow for expiring soon. Shows the first 50 members.
- Members: One row per person: ID, name, phone, email and join date. It adds status, current plan, end date, days left, billed, paid and balance due, check-ins in the last 30 days and in your no-visit window, and an activity label (Regular, Lapsing, Never visited). Room for 500 members.
- Memberships: The log of sign-ups and renewals: start date, member ID, plan and any discount. It adds the price, the net price and the end date. Room for 1,000 memberships.
- Payments: Each payment with date, member ID, amount, method and note. Room for 2,000 payments.
- Check-ins: Each visit with date and member ID. A check flags a visit by a member whose membership had already ended. Room for 2,000 check-ins.
- Plans: Your plans with price and length in months (up to 20).
- Settings: Gym name, currency symbol, the as-of date, the expiring-soon window, the no-visit window, how long expired members stay on Renewals, and the month to report.

The file opens on a start tab (“Start here”) that explains how to use it.

## What makes it different

The weak point of most gym spreadsheets is that nobody notices when a membership has run out. Here the end date is calculated from the plan, the status updates with the as-of date, and the Renewals sheet lists the people to call, so renewals do not depend on someone's memory. The sample is a small gym with 24 members and four plans, with entries in October and November 2026, so every sheet is working before you replace it with your own.

## How do I track gym memberships and expiry dates in Excel?

Give each person one row on the Members sheet, then log each membership on the Memberships sheet with its start date and plan. The end date is the start date plus the plan's months, minus one day: a one-month membership starting on 2026-10-20 ends on 2026-11-19. When a member renews, add a new row; the Members sheet always reads the latest one.

The status compares the end date with the as-of date on Settings. In the sample, as of 2026-11-16, 14 members are Active, 4 are Expiring soon, 5 are Expired and 1 has no membership. Type today's date on Settings each day, or enter =TODAY() there if you want it to move by itself.

## How do I know which members to call for renewal?

Open the Renewals sheet. It lists members who are Expiring soon (the warning window is on Settings, 7 days in the sample) and those who expired within the look-back period (60 days in the sample). In the sample there are 8 people on it, and the balance due column shows who also owes money.

The Activity column on Members helps you choose who to call first. A member who is still paying but has not checked in for 14 days is marked Lapsing, and one with no check-in at all is marked Never visited.

## How do I record payments and outstanding balances?

Log each payment on the Payments sheet with the member ID. The Members sheet adds up everything billed (price minus discount) and everything paid, and shows the difference as the balance due. In the sample, the outstanding balances come to 55.00 across two members who paid part of their fee.

A negative balance means the member paid ahead. For a view of the gym's whole cash position, see the [cash book template](https://softwiro.com/templates/cash-book-template) and the [business expenses budget](https://softwiro.com/templates/small-business-budget-tracker).

## How to use it

1. On the Settings sheet type your gym name, currency symbol, the as-of date (today), how many days count as expiring soon, the no-visit window and the month to report.
2. On the Plans sheet list each plan with its price and its length in months.
3. On the Members sheet add each person once: ID, name, phone, email and join date. The grey columns fill in by themselves.
4. On the Memberships sheet log every sign-up or renewal: start date, member ID, plan and any discount. The sheet works out the price and the end date.
5. Log each payment on the Payments sheet and each visit on the Check-ins sheet, using the member ID.
6. Open Renewals for the members to contact, and Dashboard for the counts, money and attendance charts.

**Before you start:**

- Capacity: 500 members, 1,000 memberships, 2,000 payments, 2,000 check-ins and 20 plans. The Renewals list shows the first 50 members.
- End date = start date + plan months - 1 day. A one-month plan starting 2026-10-02 ends 2026-11-01.
- A member's status comes from their latest membership: Active, Expiring soon (ends within the window on Settings), Expired, or No membership.
- Balance due = everything billed to the member (price minus discount) - everything they paid. A negative balance means they paid ahead.
- Activity is checked for members who are Active or Expiring soon: Regular, Lapsing (no check-in in the no-visit window) or Never visited.
- The sheet never reads today's date: type the as-of date on Settings, or enter =TODAY() there if you want it to move by itself.
- Expired members stay on the Renewals list for the number of days set on Settings.

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

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

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

## 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 |
| --- | --- |
| You type each check-in | Members check in at the door with a card, QR code or phone |
| You look at the Renewals sheet | Reminders go to members and to staff automatically |
| One file, one person editing | A login for every desk and coach |
| Plans and prices you edit by hand | Plans, freezes, family and corporate rates built in |
| Charts in the workbook | A live dashboard on the owner's phone |

### Extra features in the app

- Renewal reminders sent to members by message before their membership ends
- A front-desk check-in screen that reads a member card or QR code and warns when a membership has expired
- Online sign-up and payment for new members
- Several staff working at once, each with their own permissions
- Recurring billing and failed-payment follow-up
- Class booking and coach schedules linked to each member

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

## Frequently asked questions

### Is this gym membership tracker free?

Yes. Download it, use it for your gym and change anything you like. There is nothing to sign up for to open the file.

### Does it work in Google Sheets and LibreOffice?

Yes. It uses ordinary formulas such as SUMIFS, COUNTIFS, INDEX, MATCH and EDATE, so it works in Excel 2016 and later, LibreOffice and Google Sheets.

### How many members can it hold?

500 members, 1,000 memberships, 2,000 payments, 2,000 check-ins and 20 plans. When a file gets full, save a copy and start a new one with the current members.

### How do I handle a member who renews early or after a gap?

Add a new row on the Memberships sheet with the new start date. The sheet uses the membership with the latest start date, so the status and end date follow the newest one. Each membership is billed on its own row.

### Can I use my own plans and currency?

Yes. Edit the plans on the Plans sheet (price and length in months) and type your currency symbol on Settings. The symbol is only a label, so keep one currency per workbook.

### 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

- Freelance Project and Invoice Tracker for Excel
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel
- Installment Payment Tracker for Excel
- Social Media Content Calendar Template for Excel

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