Gym Fee Receipt Format (Free Download: Excel, Word, PDF)

A clear, accurate fee receipt prevents member disputes, stops cash leakage at the front desk, and keeps your gym accounts clean.

Introduction

When a member pays for their gym membership, having an official fee receipt is essential. It confirms the membership duration, records whether the money was paid via Cash or UPI, and shows any remaining pending balance.

Below, you will find standard receipt formats for Excel, Word, and printable PDF, along with a modern system to automate receipts completely.

Essential Fields for Every Gym Receipt

Whether you use a paper counterfoil book, a spreadsheet, or a digital app, every receipt must contain these basic details:

• Receipt Number & Date: A unique serial number (e.g. REC-1024) and transaction date.
• Member Name & Mobile Number: The member's full name and WhatsApp contact number.
• Membership Plan & Dates: The plan purchased (e.g. 3 Months) with exact start and end dates.
• Payment Mode: Clearly marked as Cash or UPI / Online.
• Amount Paid & Balance Due: Total cost, amount received today, and any balance remaining.
• Collected By: The name of the staff member or manager who accepted the fee.

Sample Gym Fee Receipt Structure

Here is a standard layout you can print or copy into Microsoft Word or Google Docs:

Excel Register Format Columns

If you track member payments in Microsoft Excel or Google Sheets, structure your columns like this:

• Column A: Receipt No
• Column B: Payment Date
• Column C: Member Name
• Column D: Mobile Number
• Column E: Plan Duration (Months)
• Column F: Total Plan Amount (₹)
• Column G: Paid Amount (₹)
• Column H: Balance Due (₹) =F2-G2
• Column I: Payment Mode (Cash / UPI)
• Column J: Collected By (Staff Name)

Where Paper & Excel Receipts Fail

While manual receipts work when starting out with 10–20 members, they quickly break down as your gym grows:

• Lost Receipts: Members misplace paper slips and ask for duplicate records months later.
• Cash Accountability: If cash is missing at the end of the day, there is no audit log showing who accepted it.
• Part Payments: Tracking who paid partial fees and when the remaining balance is due becomes chaotic.
• Front Desk Rush: Writing receipts by hand during morning and evening rush hours creates long queues.

FitOS: Free Payment Tracking & WhatsApp Receipts

FitOS is a free gym management app for gym owners and staff (Android app and Web admin panel). It handles daily operations seamlessly:

• Free Forever: Manage members, record payments (Cash & UPI), track pending dues, and download PDF reports at zero cost.
• Collected By Audit Log: Every recorded payment is tagged with the staff member's name.
• Automatic Balance Tracking: Record instalments and part-payments with the remaining balance calculated instantly.
• WhatsApp Automation (Pro): Upgrade to Pro (₹999/month or ₹10,000/year) for automatic WhatsApp payment receipts and pending dues reminders.

Conclusion

While paper slips and Excel templates are fine for day one, digital payment records eliminate disputes and save hours every week. Try FitOS for free to record gym payments effortlessly and keep your finances crystal clear.