Gym Profit Tracker Excel for fitness studios and gyms — memberships, MRR and churn, class revenue and trainer pay, monthly expenses, and a monthly Profit and Loss dashboard. Know what every plan and every class actually…
About this template
Gym Profit Tracker Excel for fitness studios and gyms — memberships, MRR and churn, class revenue and trainer pay, monthly expenses, and a monthly Profit and Loss dashboard. Know what every plan and every class actually earns — and whether the month actually made money. Built for gym, fitness studio, yoga studio, and boutique fitness owners who need to know, plan by plan and class by class, whether the memberships cover the rent and the trainers — without accounting software. If a class is losing money after trainer pay, this workbook flags it before the next schedule goes up.
$49
Excel & Google Sheets template — instant download on Etsy
Memberships — monthly fee, members, new and churned members, monthly revenue, churn rate, and share of MRR for every plan. Total MRR, average fee per member, overall churn rate, and your best plan by revenue at the bottom. Change a fee or a member count and the whole workbook follows.
Classes and Trainers — trainer, sessions per month, average drop-ins per session, drop-in price, class revenue, trainer pay per session, trainer cost, class profit, and profit margin for every class. Class revenue is drop-in and pay-per-class income only — member classes included in a membership are not counted here, so nothing is double-counted.
Expenses — monthly amount and share of total for rent, equipment, utilities, insurance, marketing, software, cleaning, maintenance, staff wages, and other. Trainer pay lives on sheet 2, so it is not counted twice.
Monthly Profit and Loss — members, membership revenue, class revenue, other revenue, trainer cost, and operating expenses by month, Jan-Dec, with net profit, margin, and revenue per member. All formulas from sheets 1 to 3.
Dashboard — total revenue, MRR, members, churn, sessions, class profit, expenses, net profit and margin, best class, lowest-margin class, largest expense category, and membership mix by share of MRR.
Cover and How to Use — start here. Yellow cells are the only ones you edit.
Quick profit check — Gym / Fitness Studio Profit Tracker
Try the headline numbers for a typical month. The full template does this job by job with a monthly P&L and dashboard.
Frequently asked questions
What does the Gym / Fitness Studio Profit Tracker track?
The Gym / Fitness Studio Profit Tracker tracks Memberships; Classes and Trainers; Expenses; Monthly Profit and Loss; Dashboard.
What do the example numbers show?
The included example shows: Memberships: 370 members (41 new, 20 churned); MRR 15,860; average fee per member 42.86; overall churn rate 5.1 percent. Best plan is Standard at 4,655 per month, 29.4 percent of MRR.
Does it work in Excel and Google Sheets?
Yes. The workbook works in Microsoft Excel and in Google Sheets (upload the .xlsx file to Google Drive to open it in Sheets). It is an instant digital download from Etsy — no physical item is shipped.