If you train clients for a living, you already track a lot: who's booked, who's paid, and how many sessions are left on each package. Most of it is spread across a booking app, a notes app and your memory. That's fine with ten clients. Once you have twenty-five, with packages running out, late cancellations, and a mix of in-person and online coaching, simple questions get hard to answer. Am I earning more than last quarter? Which clients are about to stop coming?
This guide covers three things. First, what to record for every session. Second, how to lay out a client tracking spreadsheet so it stays easy to use. Third, the seven KPIs that show whether your personal training business is healthy, with formulas you can paste straight into Excel.
Quick answer: A good personal trainer client tracking spreadsheet logs one row per client per session. Each row records the date, client, package, session type, client goal, location, status (booked, attended, no-show or canceled), credits used and amount. Those rows add up to a handful of KPIs: active clients, attendance rate, retention, revenue per client, lifetime value, schedule fill and revenue by package.
In this guide
Why your booking app isn't enough
Booking and payment apps are great at schedules. They're less good at business questions, because the answers are spread across several reports. Sessions are in one place, package sales in another and cancellations somewhere else. A spreadsheet that logs every session in one table lets you see everything together, and you can calculate anything you like from it.
This matters even more if you work for yourself. The U.S. Bureau of Labor Statistics counted 388,400 fitness trainer and instructor jobs in 2025, and 15% of them were self-employed. (Its median pay figure, $47,160 a year, covers employees only.) When you're self-employed, nobody else is watching your retention rate or how full your calendar is. Your spreadsheet is your back office.
What to record for every session
Use one row per client per session. A small-group session with six people is six rows. That means more typing, but it keeps attendance, revenue and package credits accurate for every client.
| Column | Example | Why it matters |
|---|---|---|
| Date and time | Tue, 6:30 AM | Shows your busiest slots and quiet hours |
| Client | Jordan P. | Counts active clients and retention |
| Package | 10-Session Pack | Shows revenue by package and how many credits are left |
| Session type | Strength 1:1 | Shows what you sell most and at what price |
| Client goal | Fat loss | Shows attendance and results by goal |
| Location | Gym floor, outdoor, online, client's home | Shows where your time and money go |
| Status | Booked, attended, no-show, canceled | Drives the attendance rate and late-cancel fees |
| Credits used | 1 | Tracks how fast each package is used up |
| Amount ($) | 85 | Revenue |
Two habits save a lot of cleanup later:
- Use drop-down lists (Excel's Data Validation) for package, session type, goal, location and status. "No show", "No-show" and "noshow" mean the same thing to you, but a formula treats them as three different values.
- Never delete a canceled session. Change its status instead. Cancellations are useful data: they show which time slots and which clients are unreliable.
How to lay out the spreadsheet: Log, Data, Dashboard
The layout that holds up best uses three sheets:
- Log. The session table above. You add rows at the bottom and never rearrange it.
-
Data. Your prices, packages, session capacity and goals, plus the formulas that add up the log (mostly
SUMIFSandCOUNTIFS). - Dashboard. Charts and KPI tiles that read only from the Data sheet. You never type here, so nothing gets overwritten by accident.
Keeping inputs, calculations and charts on separate sheets is what stops a spreadsheet from breaking the first time you add a new client or change a price.
7 KPIs every personal trainer should track
You don't need dozens of metrics. These seven cover money, capacity and client health. The example formulas assume your Log has Date in column B, Client in column D, Package in column E, Status in column I and Amount in column K, with data starting in row 4. Change the letters to match your sheet.
1. Active clients
The number of different clients who trained with you, or have a session booked, this month. It's the simplest measure of how big your business is, and most other KPIs build on it.
=IFERROR(ROWS(UNIQUE(FILTER(D4:D1200,((I4:I1200="Attended")+(I4:I1200="Booked"))*(B4:B1200>=EOMONTH(TODAY(),-1)+1)*(B4:B1200<=EOMONTH(TODAY(),0))))),0)
This counts the current month and needs Excel 365 or Excel 2021.
Benchmark: My PT Hub notes that most in-person trainers max out at around 20 to 30 individual clients. If you're near that limit, growth comes from small groups, online coaching or higher prices, not from more one-on-one hours.
2. Attendance rate
Of the sessions that were due to happen, how many did? Attendance rate = attended sessions ÷ scheduled sessions × 100. Count "scheduled" as attended sessions plus no-shows plus cancellations.
=COUNTIF(I4:I1200,"Attended")/(COUNTIF(I4:I1200,"Attended")+COUNTIF(I4:I1200,"No-show")+COUNTIF(I4:I1200,"Cancelled"))
Benchmark: aim for 85% or higher (My PT Hub).
3. Client retention rate
Retention = (clients at the end of the month − new clients this month) ÷ clients at the start of the month × 100.
For example, you started the month with 30 clients, added 6 new ones and finished with 32. Retention is (32 − 6) ÷ 30 = 87%.
Benchmark: My PT Hub calls 65% to 70% retention healthy, though it doesn't say over what period.
4. Average revenue per client
Average revenue per client = revenue this month ÷ active clients. If you brought in $13,470 from 35 clients this month, that's about $385 per client. Watch the trend. If it falls while your client count rises, you're adding cheaper clients or giving away too many discounts.
5. Client lifetime value
Lifetime value = average revenue per client per month × the average number of months a client stays. If you don't know your average stay yet, estimate it from your monthly churn: 1 ÷ the share of clients you lose each month. In the retention example above, you lost 4 of your 30 starting clients (13.3%), so the average stay is roughly 1 ÷ 0.133 ≈ 7.5 months. At $385 a month, a client is worth about $2,890. That tells you what you can afford to spend to win a new one, whether it's a referral reward, a free assessment or an ad.
6. Schedule fill (capacity utilization)
Schedule fill = sessions booked or delivered ÷ sessions you could have delivered × 100. For each time slot, capacity is the number of places in that slot × the number of days you work it in the month. Add up the slots to get the month's total. For example, 220 sessions against 256 available places is 86% full.
Check the fill for each time slot as well as the total. Many trainers are fully booked at 6 AM and 6 PM and quiet at 11 AM. You can only fix that with pricing and scheduling once you can see it.
7. Revenue by package and session type
Total the revenue for each package (monthly coaching, 20-session packs, 10-session packs, pay-as-you-go, online coaching) and for each session type. Monthly and prepaid packages make your income predictable. If most of your money comes from pay-as-you-go, you have a busy calendar but a fragile business.
=SUMIFS(K4:K1200,E4:E1200,"Monthly Coaching",I4:I1200,"Attended")
Bonus: no-show and cancellation rate. Divide no-shows and cancellations by scheduled sessions. If you charge for late cancellations, give them their own status so you can count them separately. If this number creeps up, your cancellation policy isn't doing its job.
Skip the build: the Personal Trainer Dashboard
Our Personal Trainer Dashboard is an Excel workbook laid out the same way as this guide, with a Log, a Data sheet and a Dashboard. It's made for solo trainers who coach 1:1, partner, small-group and online clients.
- A Session Log with drop-downs for package, session type, client goal, location and status
- A Data sheet for your session prices, packages, capacity and goals
- A dashboard showing revenue, sessions vs. capacity, active clients, session mix, adherence by client goal, package revenue, client health and your busiest time slots, which are ranked automatically
- A month of sample data, so every chart works as soon as you open it
Personal trainer KPI benchmarks
| KPI | Formula | Healthy range |
|---|---|---|
| Active clients (in person) | Different clients trained or booked this month | 20–30 is a typical limit for 1:1 work |
| Attendance rate | Attended ÷ scheduled | 85% or higher |
| Client retention | (End − new) ÷ start | 65–70% or higher |
| Net profit margin | (Revenue − expenses) ÷ revenue | 50% or higher |
| Net Promoter Score | % promoters − % detractors | Above 50 is excellent |
These ranges come from My PT Hub. They're guides, not hard rules. Compare yourself with your own last six months before you compare yourself with anyone else.
Turning the numbers into decisions
- Mornings are full and middays are empty. Offer an off-peak rate, or move online check-ins and program reviews into the quiet slots.
- Attendance is below 85%. Tighten your cancellation policy. Many trainers ask for 24 hours' notice, charge a late-cancel fee and keep a card on file.
- Retention is slipping. Look at attendance and progress by client goal. Clients who aren't moving toward their goal are usually the next to leave.
- Revenue per client is falling. Review your discounts, and steer clients from single sessions toward packages.
- You have more than 25 active 1:1 clients. Add small-group or online coaching so you can grow without working more hours.
Do you coach tennis, golf or swimming?
Lesson-based coaching works the same way, with courts, bays and pools in place of the gym floor. We have dashboards built for each:
- Tennis Coach Dashboard: lesson packs, player levels, junior squads and court fill.
- Golf Coach Dashboard: private lessons, swing analysis and student goals such as "Break 100".
- Swim Coach Dashboard: learn-to-swim, stroke analysis, triathlon coaching and open-water sessions.
Frequently asked questions
What should a personal trainer client tracking spreadsheet include?
One row per client per session, with the date and time, client, package, session type, client goal, location, status, credits used and amount. With those columns you can calculate active clients, attendance, retention, revenue per client and schedule fill.
How many clients should a personal trainer have?
It depends on session length and how many hours you want to work. My PT Hub notes that most in-person trainers max out at around 20 to 30 individual clients. Groups and online coaching let you serve more people without adding hours.
What is a good client retention rate for a personal trainer?
My PT Hub considers 65% to 70% healthy, using the formula (clients at the end of the month − new clients) ÷ clients at the start of the month.
How do I track session packages and credits?
Record how many credits each session used, and keep a short list of the credits each client has bought. Remaining credits are the credits bought minus the credits used, so the balance updates every time you log a session.
Do I need to be good at Excel?
Not if you use a template. If you build your own, drop-down lists plus the SUMIFS and COUNTIFS functions cover almost everything in this guide.
Ready to see your numbers? The Personal Trainer Dashboard turns your session log into revenue, client-health and capacity charts. You can also browse all of our Excel dashboards.
Instant digital download. Works in Microsoft Excel (Microsoft 365 or Excel 2016 and later) on Windows or Mac.
