The Personal Trainer Business Management System is an all-in-one personal trainer business spreadsheet for personal trainers. Log every job or sale, chase unpaid invoices, run your stock take, plan the rota, keep on top of daily checks, certificates and risk assessments, and see your profit on a live dashboard. It costs £15 once, with no subscription and no app, so you keep your own data in a file you already know how to use.
Why PTs choose a spreadsheet over an app
- One-off £15, not a monthly fee
- Works offline in Excel you already own, or in Excel online with your team
- Your data stays in your file, not on someone else's platform
- Fully editable: add your own checks, stock items, hazards and categories
Built for personal trainers
- Daily, weekly and monthly checks: health screening (PAR-Q) done for every new client, equipment checked for wear and damage, training area cleared of hazards, equipment cleaned between clients, bookings and cancellations confirmed and more, each showing Up to date, Due soon or Overdue.
- Compliance register with renewal reminders: level 3 personal training qualification, CIMSPA membership, public liability and professional indemnity insurance, first aid certificate, DBS check (if training under-18s), plus park or outdoor fitness licence, data protection registration, music licence for group sessions and more.
- Risk assessment template: 7 pre-filled hazards with likelihood × severity scoring, Low/Medium/High ratings, controls and 12-month review dates.
- Stock take spreadsheet: pre-loaded with resistance bands, exercise mats, kettlebells, cones and markers and more, showing usage, stock value and reorder alerts.
- Staff rota template: weekly shifts, hours and wage cost.
- Operations tracker: service, sessions sold, revenue, costs and gross profit on every line, with "package renewal or review due" reminders.
- Key figures for your trade: sessions and services sold, average price per session, direct cost % of revenue, gross margin.
Money and admin, done for you
- Sales and VAT: net, tax and gross on every sale, at your own tax rate
- Invoice tracker: Paid, Open and Overdue status, with days overdue
- Debtors report: aged debt (1–30, 31–60, 61–90, 90+ days) and a "chase these first" list
- 12-week cash flow forecast with shortfall warnings
- Quarterly VAT summary: tax charged, tax reclaimable, net to pay
- Profit and loss: yearly and month by month, plus budget vs actual
- Pricing calculator for your target margin
- Expenses, staff hours, customers, suppliers, assets and maintenance logs
Dashboard
A one-page dashboard with income, costs, net profit, margin, unpaid and overdue invoices, industry key figures, reminders, cash position, a compliance score (checks up to date, certificates in date, high risks, items to reorder) and month-by-month charts.
Works for you, wherever you are
- 5 languages: English, Spanish, French, German and Portuguese
- 25 countries and currencies, for example £, €, $, ¥, kr and R$, with the symbol in the right place
- Excel 2016+, Microsoft 365, Excel for Mac and Excel online. No macros.
- Formulas protected against accidental changes, and you can unprotect with no password
What you get
- Personal Trainer Business Management System (.xlsx), 24 working sheets
- Example data to show how it works, easy to delete
- Start Here guide inside the workbook
Read the full guide: How to start a personal training business in the UK · How much personal trainers earn · The KPIs to track
Need a business plan too? Get the Personal Trainer Business Plan Template – £10 · Or get everything: Full Business Pack – £20 (save £5)









