Personal Trainer Income Tracker | Client Session & Gym Profit Log (Google Sheets, Excel)

FREQUENTLY ASKED QUESTIONS

Q: What files do I receive upon purchase?
A: You receive an instant digital download containing a PDF with a direct copy link to access the Google Sheets* version in Google Drive*, an editable Microsoft* Excel* (.xlsx) file, and a step-by-step Instructions PDF.

Q: Which software and devices are supported?
A: The template works in Google Sheets* (accessible via browser or Google Sheets* mobile app on Mac*, Windows*, iPhone*, and Android*) and Microsoft* Excel* 2019 or newer, including Microsoft 365*.

Q: Is this beginner friendly and safe from accidental formula deletion?
A: Yes. Yellow cells indicate where to type, while grey cells contain automatic formulas. If a formula is typed over, the cell turns red as a visual alert. Google Sheets* also displays edit warnings, and no tabs or cells are password locked.

Q: Can I customize this for my packages, gym rent model, and currency?
A: Absolutely. You can adjust dropdown lists, package pricing, tax set-aside percentages, and gym floor rental arrangements (flat monthly fee, per session rate, hourly rent, or percentage revenue split) You can also switch the currency symbol with a few clicks (steps are in the Instructions PDF).

Q: Is there a subscription fee, and what is your refund policy?
A: There is no subscription fee; this is a one-time purchase. Because this is an instant digital download, sales are final and non-refundable, but ProFormaGrid is always available to help if you have any questions.

Stop guessing your business earnings and take control of your fitness coaching income with this personal trainer spreadsheet and online fitness coach tracker. Designed specifically for freelance personal trainers, online fitness coaches, hybrid coaches, and independent gym contractors who rent floor space, this client session tracker sheet and gym business profit template eliminates chaotic admin work. Track staggered client session packages row by row, manage monthly recurring revenue from online programming, subtract gym rent deductions automatically, and uncover your true hourly coaching rate in one clear dashboard.

What's inside:
• Start Here: Quick start guide, color-coding key, and template health check.
• Dashboard: 8 main KPI cards (revenue, net profit, true hourly rate vs target, online MRR this month, active clients, prepaid sessions owed, packages running low, clients to check in), Renewal Radar list, Check-In list, and 4 visual charts.
• Settings: Rent model selection, tax set-aside percentage, target hourly rate, admin hours, alert thresholds, menu of 12 customizable packages, and editable dropdown lists.
• Clients: 150 rows tracking lifetime revenue, sessions left, last session date, days since last session, and automated alerts for Renew Package and Check In.
• Packages: 300 rows tracking staggered client package purchases with sessions used, sessions left, expiration dates, prepaid value owed, and package status.
• Session Log: 1,200 rows tracking session attendance (including charged late cancellations and no-shows), automated gym fee deductions per session, net earned income, and total hours coached.
• Online Coaching: 150 subscriber rows tracking monthly recurring revenue (MRR), churn rate, and client lifetime value.
• Other Income: Income log for drop-ins, e-books, and workshops.
• Expenses: 500 rows to categorize and record trainer business operating expenses in this trainer income expense sheet.
• Monthly Summary: January to December breakdown of cash in, cash out, net profit, tax set-aside, take-home pay, total hours, and hourly rate before vs after gym rent to show your true hourly rate.
• Rate Calculator: Pricing calculator that recommends session rates along with 10-pack and 20-pack package prices built from your target take-home income goal.
• Instructions: Complete step-by-step documentation for every tab and feature.

Why coaches love it:
• Calculates your true hourly rate by accounting for floor rental fees and unpaid admin hours.
• Handles staggered session packages so you never lose track of prepaid sessions owed or expiring packages.
• Tracks recurring online coaching income alongside in-person training in one unified sheet.
• Simple color-coded design that protects formulas and works on desktop or mobile.

How it works in 3 steps:
1. Set up your rent model, package options, tax percentage, and hourly goals in the Settings tab.
2. Log client packages, completed sessions, online subscribers, and general expenses.
3. Review your Dashboard and Monthly Summary to monitor net profit, renewal alerts, and your true hourly earnings.

What you receive:
• PDF document containing the Google Sheets* copy link.
• Standalone Microsoft* Excel* file (.xlsx format).
• Instructions PDF (setup, resizing cells safely and protecting formulas).

Please note:
• This product is an instant digital download. No physical product will be shipped.
• For personal and internal business use only. Redistribution, resale, or sharing is strictly prohibited.
• This spreadsheet is an organizational tool and does not constitute formal accounting, legal, financial, or tax advice.
• Google*, Google Sheets*, Google Drive*, Microsoft*, Excel*, Microsoft 365*, Mac*, Windows*, iPhone*, and Android* are trademarks of their respective owners. ProFormaGrid is not affiliated with, sponsored by, or endorsed by Google* or Microsoft*.

More templates: ProFormaGrid.com