Personal Training System in Excel – Fill Your Diary, Keep Clients
See which clients are about to run out of sessions, who is on a plateau and what each coach really earns you – before a missed renewal or an unpaid package quietly drains your income. This is a complete personal training office in Excel: four connected workbooks that already work with sample data, so you see every alert and dashboard before you type your first client.
Built for personal trainers, coaches and small studios – on your own or with a team of coaches – from your first clients to a full timetable.
What you get:
- ✓ 4 connected workbooks: clients and memberships; programmes and progress; money and coaches; studio and schedule
- ✓ 231 ready pages: dashboards, calculators, printable forms, checklists and ready WhatsApp messages
- ✓ 15 languages as blank templates, plus filled copies with sample data in English and Spanish
- ✓ Standard xlsx files for Microsoft Excel and LibreOffice – no macros, no subscription
How it works: 1) open the workbook in your language, 2) type your clients, packages, coaches and prices in the yellow cells, 3) balances, renewals, progress, pay and cash forecasts update by themselves. One payment, instant download.
- Know every client's sessions left and days to expiry at a glance
- See renewals coming and the revenue at risk before it walks away
- Stop chasing: arrears ageing, freezes and no-shows tracked for you
- Find leads that convert: cost per source and trial conversion by coach
- Spot personal records and plateaus automatically from the workout log
- Build safer programmes with an injury-aware exercise library
- Plan deloads and see weekly volume per muscle group
- Show clients the date they will reach their goal at their current pace
- Know profit per package and lifetime value per client
- Pay coaches fairly: pay, utilisation and margin per coach
- Never run dry: a 12-week cash forecast with low-cash warnings
- Fill empty slots: live timetable, fill by hour and late-cancel policy
Do I need special software?
No. The files open in Microsoft Excel on Windows or Mac and in LibreOffice Calc, which is free.
Does it suit one coach and a studio with several coaches?
Yes. The coach columns work for one coach or many; the sample data shows a studio with five coaches.
Can I replace the sample data with my own?
Yes. Clear the sample rows and type or paste yours; lists, formulas, alerts, dashboards and calculators update by themselves.
Are the calculators medical or tax advice?
No. Calorie, heart rate and tax calculators are planning aids that use your own settings; they do not replace a doctor, dietitian or accountant.
Where do I start?
Open the workbook in your language, fill the yellow cells on the Start sheet, then follow the How to use it steps.
Are there macros or a subscription?
No macros and no add-ins: only formulas, so the files are safe to open. One payment, instant download.