Fitness Studio P&L Tracker — Monthly & Annual Profit/Loss Template

Fitness Studio P&L Tracker — Monthly & Annual Profit/Loss Excel Template

Finally know if your fitness studio is actually making money — and exactly what to fix if it isn't.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

💪 WHO THIS IS FOR

Built specifically for independent gym owners, boutique fitness studios, yoga and pilates studios, CrossFit boxes, martial arts schools, and personal training businesses. If you're running a fitness business on spreadsheets — or worse, nothing at all — this template gives you real financial clarity in under 30 minutes per month.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📋 WHAT'S INSIDE (4 Powerful Sheets)

🔧 Studio Setup — Enter your pricing tiers, staff pay rates, and fixed costs once. Every other sheet pulls from here automatically.

📅 Monthly P&L — Track every revenue stream (memberships, drop-ins, personal training, merchandise, events) and every expense category, month by month. Gross profit, EBITDA, net profit, and break-even point are all calculated for you.

👥 Membership Tracker — Monitor active member counts, new sign-ups, cancellations, churn rate, retention rate, class fill rates, and revenue per member across all 12 months. Spot retention problems before they kill your revenue.

📈 Annual Summary Dashboard — One-page view of your entire year: total revenue, net profit, EBITDA margin, average churn, break-even analysis, and year-over-year comparison. Know your numbers at a glance.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⚡️ KEY FEATURES

✅ 40+ pre-built financial formulas — no Excel expertise needed

✅ Break-even calculator shows exactly how many members you need to profit

✅ Churn rate & retention tracking built in

✅ Revenue per member, revenue per class, and class fill rate metrics

✅ Year-over-year comparison with automatic variance calculations

✅ Color-coded cells — yellow to fill in, blue calculates automatically

✅ Works with Excel 2016, 2019, 2021, Microsoft 365, and Mac Excel

✅ Fully unlocked — customize for your studio's unique revenue streams

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎯 WHAT PROBLEMS THIS SOLVES

Most fitness studio owners feel busy but aren't sure if they're actually profitable. This template shows you exactly where revenue is leaking, whether your rent-to-revenue ratio is healthy, how your churn rate compares month to month, and what revenue target you need to hit before you pay yourself. Stop guessing. Start knowing.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📥 INSTANT DOWNLOAD — One purchase, use it every year. Update your fiscal year in the setup tab and reset in minutes. No subscriptions, no logins, no recurring fees.

Take control of your studio's finances today.