Free gym membership Excel sheet (download)

This is a free gym membership Excel sheet you can use today. It lists your members, works out each end date from the plan, flags who is expiring or expired, tracks payments, and totals the month.

Download the gym membership tracker (.xlsx)

It has no macros and no sign-up. Open it in Excel, or import it into Google Sheets (File, Import).

What each sheet does

• Members. One row per member: ID, name, phone, plan, start date. End date, monthly fee and status fill in by themselves. Status reads Active, Expiring in 7 days, Expired or Not started, and the last two get a colour. Use the filter arrow on Status to see who to call.
• Payments. One row per payment: date, member ID, amount, and method from a dropdown (cash, UPI, card). The member's name appears from the ID, so a wrong ID shows "Unknown ID" at once.
• Summary. Pick a month and see what you collected, how many members are active, how many expire this week and how many have expired.
• Plans. Your plan names, months and monthly fee. The plan dropdown on Members reads this list, so edit it once and it applies everywhere.
• How to use. The steps below, plus how to lock the formula cells.

How to set it up in ten minutes

1. Open Plans and enter your own plans, for example Monthly, Quarterly, Yearly, with months and monthly fee.
2. On Members, clear the three sample rows in the yellow cells (columns A to E). Leave columns F to H alone, they hold formulas.
3. Type each member into the next free row. Pick the plan from the dropdown.
4. When someone pays, add a row on Payments with their member ID.
5. Each morning, filter Members by Status. Expired and Expiring in 7 days are your fee reminder list.

Keep the formula cells safe. Protect the sheet so only the yellow cells can be edited, and never sort one column on its own, or rows will separate from their members. Sort the whole table or use the filter arrows.

Works in Google Sheets

Open Google Sheets and choose File, Import, Upload. Select the file, then Replace spreadsheet or Insert new sheets. Share it with a trainer as view only if you do not want fee columns edited.

The honest limits of a spreadsheet

A sheet is a fine register for one owner and a small gym. It is a good fit while you are the only person who types into it. It starts to cost you when:

• A trainer or front desk also edits it, and one sort or paste breaks a formula.
• You chase late payers by copying names and numbers into WhatsApp one at a time.
• You want a PDF receipt for each payment.
• You need staff to see attendance but not fees. A hidden column is not access control.
• You work from a phone, where a wide sheet is slow to edit.

When a few of these are true every week, an app starts to pay for itself. The Excel vs gym app comparison goes through it job by job. If reminders are the main pain, see the gym fee reminder app. If it is receipts, see gym billing software.

Questions

Use the questions below for the common ones. If you keep outgrowing the sheet, Varzish Mate is built for the same job on a phone, with a 30-day free trial.