Stackrows
Personal Training Sales Forecast Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Assumptions
Monthly Revenue Forecast
Client Pipeline
Actual vs Forecast
Scenario Planner
Dashboard

Personal Training Sales Forecast Template

Forecast revenue across one-on-one sessions, packages, group classes, and online coaching — with assumptions you can actually adjust for January peaks and summer drop-off.

$29Save 4+ hours vs. building a revenue forecast spreadsheet from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx215 KB6 sheetsUpdated 2026-03-23

What's Inside This Personal Training Sales Forecast Template

This template includes 6 worksheets, each designed for a specific part of your personal training financial workflow:

1

Assumptions

The starting point for your entire forecast. Enter your active client count, average sessions per client per month, session rates for each service type (one-on-one, semi-private, group classes, online coaching, and nutrition add-ons), and your expected new client acquisition and churn rates each month. These inputs drive every projection in the other sheets, so updating one assumption — like raising your session rate or adding a new coaching package — ripples through the whole forecast automatically. There's also a seasonality adjustment row where you can dial up January and September volumes and dial down the summer and holiday months to match how personal training businesses actually behave.

2

Monthly Revenue Forecast

A 12-month breakdown of projected revenue by service line: one-on-one sessions, training packages, group classes, online coaching, and add-on services like nutrition coaching or programming. Each row pulls from your Assumptions sheet so there's nothing to recalculate manually — change your package rate and the full year updates. Subtotals by service line let you see which parts of your business carry the most weight and where growth is coming from. Monthly totals at the bottom give you a full-year revenue picture at a glance.

3

Client Pipeline

Tracks the flow of clients through your business month by month: starting active clients, projected new client sign-ups, expected churn or drop-off, and ending active client count. This sheet makes your revenue projections defensible — rather than forecasting a revenue number in isolation, you can see exactly how many clients you need to hit each target and whether your assumed acquisition rate is realistic given your current referral and marketing activity. It also calculates your retention rate automatically so you can track whether your client base is growing, holding, or shrinking over the forecast period.

4

Actual vs Forecast

Enter your real monthly revenue and client numbers as the year progresses, and this sheet calculates the dollar variance and percentage variance against your forecast for every service line. Color-coded formatting highlights where you're tracking ahead of plan and where you're falling short. Most personal trainers use this monthly — it takes about 10 minutes to update and immediately shows whether a shortfall is coming from client drop-off, fewer sessions per client, or a pricing issue. Catching a trend in month two is far easier to address than discovering it in month six.

5

Scenario Planner

Models three versions of your business side by side: a base case using your Assumptions inputs, an upside scenario (more new clients, higher retention, or a rate increase), and a downside scenario (slower growth, higher churn, or a pricing rollback). Each scenario shows projected annual revenue and the gap between them so you can understand your range of outcomes before committing to expenses or lease decisions. Personal trainers expanding into a studio space or adding a second trainer often use this sheet to stress-test whether the numbers work under conservative assumptions, not just optimistic ones.

6

Dashboard

A one-page visual summary with charts for monthly revenue by service line, client count trends over the forecast period, and a cumulative revenue-to-date chart that shows how fast you're pacing toward your annual target. All charts update automatically as you enter actuals in the Actual vs Forecast sheet. Designed to be readable without spreadsheet expertise — useful if you want to share your forecast with a business partner, accountant, or lender without sending them a raw data file.

Personal Training Sales Forecast Template Features

  • Revenue projections by session type, package, and online coaching
  • Client pipeline tracker with new client acquisition and churn modeling
  • Seasonality adjustments for January peaks and summer drop-off
  • Actual vs forecast variance tracking with color-coded alerts
  • Three-scenario planner (base, upside, downside)
  • Pre-built dashboard with client count and revenue trend charts

How to Use This Personal Training Sales Forecast Spreadsheet

Start with the Assumptions sheet — it takes about 15 minutes to set up. Enter your current active client count, your rates for each service type (one-on-one sessions, packages, group classes, online coaching), and your best estimate of how many new clients you expect each month and how many you typically lose. If you're not sure about churn, look at the last three months and count how many clients dropped off — that's your baseline. Adjust the seasonality row to reflect your January surge and summer slowdown if those patterns apply to your business.

Once the assumptions are in, the Monthly Revenue Forecast and Client Pipeline sheets are already calculated. Review the 12-month totals and ask whether the numbers look realistic — if your forecast assumes 40 active clients but you've never had more than 25, adjust your acquisition rate down. The Scenario Planner is useful here: model your conservative case first, then see what the upside looks like if retention improves or you add a group class revenue stream. This is also the right moment to decide whether your current pricing supports your income goals.

Through the year, update the Actual vs Forecast sheet monthly. Enter your real revenue by service line and your actual ending client count, and the sheet calculates how you're tracking against plan. Most personal trainers find that the variance analysis changes how they work — if one-on-one session revenue is consistently below forecast but package sales are strong, that's useful information for how you structure your offerings. The Dashboard gives you the same picture visually, which is helpful for quarterly reviews with an accountant or for your own month-end check-in.

15 minutes from download to your first revenue forecast

Download the template, enter your client count and rates, and see a full 12-month projection with client pipeline, scenario planning, and variance tracking built in.

Why Personal Trainers Need a Sales Forecast

Personal training businesses look simple from the outside — you have clients, you charge per session, money comes in. But the revenue picture is more complicated once you're mixing one-on-one sessions at different rates, multi-session packages that pay upfront but get delivered over weeks, group classes with variable attendance, and online coaching with its own pricing structure. Without a forecast, it's easy to hit a great month in January and assume you're on track — then realize in March that you lost four clients and your recurring revenue dropped 20% without any visible warning.

The core mechanics of a personal training forecast are client count, average revenue per client, and retention. A trainer with 30 clients at $250/month per client runs a $90,000 annual business — but only if retention holds. If 20% of clients churn each quarter and aren't replaced, that same trainer ends the year at $60,000. Forecasting forces you to model these dynamics explicitly rather than assume your client base is stable when it isn't. January sign-ups are real revenue, but they're not reliable — the drop-off through spring is predictable enough to plan around if you've tracked it.

A well-maintained sales forecast also helps you make better pricing and capacity decisions. If you're fully booked at $80/session and your forecast shows you'll hit an income ceiling at $75,000 for the year, that's the data you need to raise rates, add semi-private sessions, or launch an online program to scale beyond your hourly capacity. Personal trainers who use a forecast regularly tend to make these decisions earlier — not because they're better at math, but because they've already modeled what happens if they don't.

Personal Training Industry at a Glance

Financial templates built for personal trainers and fitness coaches — from solo trainers billing individual clients to studio owners managing packages, group classes, and recurring memberships.

Revenue Drivers

  • One-on-one sessions
  • Training packages
  • Group classes
  • Online coaching
  • Nutrition coaching add-ons

Key Cost Categories

  • Gym rental or facility fees
  • Equipment and supplies
  • Liability insurance
  • Certification and continuing education
  • Software and scheduling tools
  • Marketing and referral costs

Typical Margins

Gross: 70-85% · Net: 30-55%

Seasonality

January and September are peak sign-up months; summer and the holiday stretch see higher drop-off. Renewal cycles are often tied to 4-, 8-, or 12-week package structures.

Key Performance Indicators

Client retention rateAverage revenue per clientSession utilization ratePackage renewal rateRevenue per hour

Personal Training Sales Forecast Template FAQ

Personal Training Sales Forecast Template

$29