BOMDOXI BOMDOXI

BOMDOXI / All products / Personal Trainer Business Manager

Pro Series · Excel + Google Sheets

Personal Trainer Business Manager

A complete workbook for independent personal trainers, online coaches and small studios. Log each session and it is taken from the right package automatically: sessions left, expiry dates and statuses update everywhere. The Action Board shows who to renew, which paid sessions are about to expire and what is still unpaid. A rate calculator prices your packages from your income goal and your gym deal, and proposals, client statements, invoices and progress reports print in one click.

€16.99on Etsy

Etsy shows the price in your currency at checkout.

Also available on Payhip · Gumroad

  • 21 tabs
  • No macros
  • No subscription
  • One-time purchase
Personal Trainer Business Spreadsheet: packages and sessions, renewal alerts and rate calculator, for Excel and Google Sheets
  • Excel + Google Sheets
  • US Edition · English
  • Instant digital download
  • One-time purchase
US Edition

Personal Trainer Business Spreadsheet — Package & Session Tracker, Renewal Alerts, Rate Calculator & Invoices

Track every package and session, renew clients before their last session, and price from your own numbers, in Excel or Google Sheets.

  • No subscription
  • No macros
  • Excel & Google Sheets
  • US Edition

Never count sessions by hand

Packages and sessions are matched for you.

  • Single sessions, packs, monthly memberships, online, hybrid and gift certificates
  • Each completed session uses the client's oldest active package — or the one you choose
  • Late cancels and no-shows follow your 24-hour policy
  • Validity, freezes, refunds and monthly rollover handled automatically

Stop losing paid sessions

An Action Board to open every morning.

  • Sessions in the next 7 days, with sessions left
  • Packages to renew before the last session
  • Sessions about to expire, with the dollars at risk
  • Unpaid packages, drop-ins, leads to follow up and inactive clients

Price from your numbers

A Rate & Package Calculator built for trainers.

  • The minimum rate per session from your income goal and costs
  • A package ladder with discounts and what you keep per session
  • Online coaching and semi-private prices
  • Flat rent vs. per-session fee vs. revenue split at your volume

Look like a pro on paper

Printable documents that fill themselves.

  • Training Proposal with three options and your policies
  • Client Statement: sessions used and left, expiry and balance
  • Invoice, receipt or gift certificate
  • Your credentials line on every document

Results your clients can see

Assessments, progress and programs in one place.

  • Body measures, fitness tests and three main lifts
  • Navy tape body fat and estimated 1RM
  • Progress Report with first vs. latest numbers and a trend chart
  • Program Builder with loads from each client's 1RM

Know what you really earn

A Dashboard that separates cash from earned revenue.

  • Cash received, revenue earned and net profit
  • Sessions you owe — the work you have already been paid for
  • Hourly rate after card fees, gym fees and unpaid hours
  • Renewal rate and business health ratios
Show the full description (21 modules, specifications, what's included)Hide the full description

1. Start Here

A built-in guide to setting up and using the workbook.

  • Three paths: in person, online or hybrid
  • Set-up steps: Settings, Package Menu, Rate Calculator
  • What to do for every client, every day and every week
  • How the workbook works: blue headers for typing, gray headers calculated, the Check column (red = fix, amber = warning)
  • How packages and sessions connect, changing prices, the as-of date, refunds, validity, freezes and monthly plans
  • Definitions of every figure: cash received, net profit, renewal rate, revenue earned, sessions you owe, hourly rate
  • Capacity, gift certificate and prepaid contract notes, sales tax and disclaimer

2. Dashboard

Your business at a glance, updated from your records.

  • Period filter: this year, this month, last 30 or 90 days, all time, or each quarter of the report year
  • Eight cards: cash received, revenue earned, net profit (cash basis) with the tax set-aside, sessions you owe, hourly rate after fees and gym, renewal rate, active clients and expired unused sessions
  • Revenue by format (in-person, in-home, semi-private, small group, online live, online coaching, hybrid): sessions, revenue earned, share and earning per completed session
  • Business health with healthy ranges: late cancels and no-shows; average earned per completed session; capacity used; gym fees as % of revenue; card fees as % of payments; client tenure and average paid per client; leads that became clients; clients who referred someone; offers priced more than 25% below your single price
  • Needs attention: 13 counters, from sessions this week to entries to fix
  • Packages sold by type, gym fees owed vs. paid by location, who owes you
  • Cash in vs. cash out chart by month, top clients

3. Action Board

What needs your attention today and this week.

  • Sessions in the next 7 days: day, time, client, format, sessions left and location
  • Renew now: packages running low or used up
  • Expiring with sessions unused: expiry, client, package, sessions left, days and the $ at risk
  • Packages not fully paid, and drop-in sessions and travel fees to collect
  • Leads to follow up with their status, last contact and source
  • Inactive clients: no session for 10+ days
  • Online check-ins due, assessments due, program reviews due
  • Onboarding not complete: PAR-Q+, medical clearance or waiver missing
  • A "+ N more" line when a list has more rows than it shows

4. Clients & Leads

One row per person, from the first inquiry to a long-time client.

  • Name, phone, email, status (Lead, Consult booked, Proposal sent, Trial, Active, Paused, Former, Lost)
  • Lead source, who referred them, lead date, last contact and lost reason
  • Usual format and location, up to 3 weekly time slots, online check-in day
  • Goal, target date or event, injuries and limitations, emergency contact
  • Height and sex for the body-fat formula; PAR-Q+ date and answers, medical clearance and waiver
  • Current program and review date, notes
  • Automatic: sessions left, current package, next expiry, last session, days since, client since, total paid, what they owe, purchases, renewals, referrals made, last and next assessment
  • Up to 200 clients and leads

5. Session Log

Every session, booked or done.

  • Date, time, client and status: Scheduled, Completed, Late cancel, No-show, Cancelled in time, Trainer cancelled, Complimentary or Check-in
  • Minutes, format and location (blank = the client's usual ones)
  • Sale # to choose a package, drop-in price, travel fee, payment received now and method
  • Group ID for semi-private sessions, session notes
  • Automatic: uses a session, from Sale #, package, sessions left after, session value, charge, balance and gym fee
  • Up to 3,000 sessions

6. Package Sales

One row per package, membership month or gift certificate.

  • Sale #, sale date, client and offer from the Package Menu
  • Sessions, bonus sessions, price, discount, validity start and days (blank = the offer's terms)
  • Freeze days and reason; gift certificate and who bought it
  • Up to 3 payments with dates and methods; refund and refund date
  • Automatic: type, total sessions, price, sales tax, total, per session, paid, card fees, balance, payment status
  • Starts, expires, used, left, days to expiry, value still owed, expired sessions and value
  • Status: Not started, Active, Running low, Expiring soon, Used up, Expired, Ended or Refunded; renewed, rollover to next month and suggested refund
  • Up to 800 package sales

7. Weekly Schedule

Your week at a glance.

  • 5 AM to 9 PM, Monday to Sunday, for any week you pick
  • Sessions from the Session Log, plus your active clients' usual slots not logged yet (↻)
  • Semi-private groups shown once
  • Sessions and hours per day; this week's sessions, hours, capacity and capacity used

8. Training Proposal

A printable proposal for a new client.

  • Your business details and credentials line
  • Client, goal, target date, recommended plan and valid-until date
  • Three options side by side, with the one you recommend highlighted: offer, format, sessions, validity, price, price per session and the saving vs. single sessions
  • What every plan includes, your policies, the contract-law reminder and the safety note
  • Signature lines and the chosen option

9. Client Statement

"How many sessions do I have left?"

  • Sessions left, next expiry, total paid and balance due
  • The client's packages: sessions, used, left, expiry, status and balance
  • Recent sessions with the package they came from and any charges
  • A renewal message when sessions are running low, and your policies

10. Invoice & Gift Certificate

A printable invoice that becomes a receipt.

  • Package sale: pick a Sale # — invoice, receipt once paid in full, or gift certificate for gift sales
  • Sessions in a period: every drop-in session and travel fee for a client between two dates
  • Your payment instructions in the footer; print or save as PDF

11. Package Menu

Your offers and what each one earns you.

  • About 30 offers pre-filled with illustrative late-2026 US prices: assessment, single sessions (30, 45, 60 min), intro pack, 5- to 30-session packs, partner and small-group packs, in-home sessions and packs, monthly 1x / 2x / 3x a week, online coaching (basic, standard, premium), online live sessions, hybrid plans, program design and nutrition add-ons, a New Year promo and gift packages
  • Type, format, sessions, minutes, validity days and start, monthly rollover, price, promo price and end date, usual location, taxable and offered
  • Automatic: price now, price per session, saving vs. single, gym fee per session, what you keep per session and per hour, number sold
  • Up to 60 offers

12. Rate & Package Calculator

Prices from your numbers, not a guess.

  • The rate you need: income goal, business costs, working weeks, paid sessions per week, gym fee model and card fees → minimum price per session and a verdict vs. your single price
  • Package ladder: 5 packages with your discounts → price rounded to $5, per session and what you keep
  • Online coaching minimum monthly price; semi-private price per person for 2, 3 and 4 people
  • Which gym deal costs less: flat rent, pay per session or a revenue split, with the break-even sessions
  • How many clients your goal takes: active clients and new clients a month, from your renewal rate

13. Fitness Assessments

One row per assessment.

  • Weight, measured body fat and method; neck, chest, waist, hips, arm, thigh and calf
  • Resting heart rate, blood pressure, 3-minute step test heart rate
  • Push-ups (with type), plank, wall sit, sit-and-reach
  • Three main lifts (load and reps) and posture / movement notes
  • Automatic: BMI, waist-to-hip ratio, body fat by the US Navy tape formula, body fat used, estimated 1RM per lift, change in weight, body fat and waist since the first assessment, assessment number
  • Up to 600 assessments

14. Progress Report

A printable report to share with your client.

  • First and latest value of 18 measures, with the change and the trend
  • Weight and waist trend chart
  • Attendance: sessions since the first assessment, last 30 days, late cancels and no-shows, sessions left
  • Coach's comment and the recommended next package with its price

15. Program Builder

A printable training program.

  • Client, program name, focus, weeks, days per week, start and review dates
  • 4 training days with up to 8 exercises each: sets, reps, % of 1RM, rest and notes / tempo
  • Loads calculated from the client's latest estimated 1RM for the main lifts

16. Exercise Library

The exercises behind the Program Builder.

  • 104 exercises with movement pattern, main muscles, equipment, level and a coaching cue
  • Link to one of your three main lifts for % 1RM loads
  • Add your own, up to 150

17. Credentials & Insurance

Never let a certification or policy lapse.

  • Certification, specializations, CPR/AED, liability insurance, business license and gym agreements
  • Organization, number, issued and expiry dates, renewal cost and notes
  • Continuing education credits required vs. done
  • Automatic: days left, CEUs still needed and status, with a warning 60 days before

18. Expenses

Every business cost, recorded once.

  • Date, vendor, category, description, amount, payment method and location
  • Categories such as gym rent and floor fees, equipment, certifications and CEUs, insurance, apps, marketing, phone, vehicle and fuel
  • Link gym rent to a location to compare what you owe each gym with what you paid
  • Card processing fees are calculated from each payment, not typed here
  • Up to 1,000 expenses

19. Mileage Log

Business driving with the IRS rate applied.

  • Date, purpose, from → to, miles and round trip
  • IRS standard mileage rate for the trip date, from an editable table in Settings
  • Deduction per trip; standard mileage or actual vehicle costs (chosen in Settings)
  • Up to 1,000 trips

20. Tax Set-Aside

How much to put aside, month by month.

  • Money collected − refunds − card fees − expenses − mileage = net, and the amount to set aside (25% by default)
  • Four quarterly estimated payments (Form 1040-ES periods) with due date, amount, paid and status: Paid, Partly paid, Due soon, Upcoming, Past due or Nothing due

Note: a planning estimate, not tax advice. Ask your tax professional.

21. Settings

Your business details and the rules behind every calculation.

  • Business name, trainer name, contact details, address, website and the credentials line printed on documents; your state
  • Report year and as-of date
  • Session policies: cancellation notice, late cancels and no-shows use a session, free late cancels per package, maximum freeze, default validity start, refund policy
  • Single session price and length, in-home travel fee, weekly capacity and unpaid hours
  • Alert thresholds: running low, expiring soon, renewal talk, inactive clients, reassessment, lead follow-up, credential warning
  • Sales tax rate, tax set-aside %, vehicle deduction method
  • Main lifts for assessments and the Program Builder
  • Printed text: policies, contract-law reminder, invoice footer, gift certificate note, liability / safety note
  • Locations & gym fees (per session, % of session or monthly rent; no-shows pay the fee or not) and payment fees by method
  • Editable lists: client status, lead sources, push-up types and more; IRS mileage rates

Specifications

EditionUS Edition (version 1.6.1)
Sheets21 tabs
SoftwareMicrosoft Excel 2019 or newer, Microsoft 365; Google Sheets
Operating systemWindows and Mac (Excel); any browser (Google Sheets)
CurrencyUS dollars ($)
Workbook languageAmerican English
Date formatMM/DD/YYYY
UnitsPounds, inches; miles
Reporting periodCalendar year (January – December); quarterly estimated taxes by Form 1040-ES periods
Training formatsIn-person, in-home, semi-private, small group, online live, online coaching, hybrid
Clients & leadsUp to 200
OffersUp to 60 (about 30 pre-filled)
Package salesUp to 800
SessionsUp to 3,000
AssessmentsUp to 600
ExercisesUp to 150 (104 pre-filled)
ExpensesUp to 1,000
Mileage tripsUp to 1,000
Proposal3 options side by side
Program Builder4 days × 8 exercises
ProtectionFormula cells locked in Excel, no password; warning mode in Google Sheets
MacrosNone
Add-onsNone
SubscriptionNo subscription

Who it's for

  • Independent personal trainers selling session packs and memberships
  • Trainers renting space or paying a fee at one or more gyms
  • In-home and mobile trainers who charge for travel
  • Online and hybrid coaches with monthly plans and weekly check-ins
  • Small studios running semi-private and small-group sessions
  • New trainers setting their prices for the first time

What's included

  • READY (.xlsx): the workbook for your business, with the Package Menu and exercise library ready to adjust
  • DEMO (.xlsx): the same workbook filled with a fictional trainer in Austin, Texas
  • Google Sheets Access (PDF): Make-a-copy links to the READY and DEMO Google Sheets versions
  • Quick Start Guide (PDF, 3 pages)
  • User Guide (PDF, 21 pages)

A closer look

Good to know before you buy

We'd rather you know exactly what you're getting.

  • It is a business tool, not a workout app, booking system or payment processor; it does not send reminders, messages or invoices — you print or save documents as PDF.
  • It is not medical, legal, tax or accounting advice. PAR-Q+, waivers and medical clearance follow your certification body's guidelines.
  • Prepaid training contracts, refunds and gift certificate expiry are regulated differently by each state — check yours.
  • It does not file or pay any taxes; the tax set-aside and estimated payments are planning estimates.
  • Sales tax on personal training applies in only a few states; you set the rate and which offers are taxable.
  • Pre-filled offers and prices are examples to set to your own.
  • Requires Excel 2019 or newer; Excel 2016 and earlier are not supported.
  • Your data stays in your own file or Google Drive copy.

Get the Personal Trainer Business Manager

One-time purchase. Instant digital download.

Etsy is our main store. The same product is also on Payhip and Gumroad.
€16.99on Etsy

Etsy shows the price in your currency at checkout.

Also available on Payhip · Gumroad

You might also like

Pro SeriesHome Bakery Business Manager spreadsheet
Excel & Sheets

Home Bakery Business Manager

Cost every recipe, price every cake, plan your baking days and print cottage food labels, in Excel or Google Sheets.

  • US Edition
€16.99
NewFreelancer Business Toolkit dashboard
Apps

Freelancer Business Toolkit

Invoices, quotes, expenses, projects, time and profit in one simple offline app.

  • US Edition
  • UK Edition
  • AU Edition
€7.99