Clients, payments and check-ins in one spreadsheet
A free spreadsheet template for personal trainers: clients with renewal alerts, payments split by currency, and check-ins with adherence worked out for you.
This personal trainer spreadsheet template has three sheets: clients, payments and check-ins. It is free, it opens in Excel and Google Sheets, and you download it without handing over your email. The link is at the end, and before it you will see what each sheet is for and how to keep it in order six months from now.
Why these three sheets
The training already has its own: the mesocycle template, with the days, sets and RIR for each week. This one is for the other side, the part that gets messy first when you go from five clients to fifteen: who renews this month, who owes you a fee, and who has spent two weeks training half of what was planned.
If none of that is written down, you find out late. The renewal slips by until the client stops paying, the missing payment turns up when you close the month, and the slump comes to light when they message you to cancel.
Clients: one row per person
Name, start date, service, fee, currency, billing period, next renewal and status. When a renewal is seven days away or less, the date turns orange, and the top of the sheet shows how many active clients you have.
Do not delete the ones who leave. Set their status to Left and note the reason. A year from now, that list will tell you how long a client stays on average and which months you lose the most people, which you would never know from memory.
Payments: one row per payment
Most payment sheets have one row per client and one column per month. That works in March, but by September you have nine columns, half the sheet off the screen and no easy way to add up what is outstanding. In the template, each payment is a row with its date, amount and status, and the sheet grows downwards without getting in the way.
Currency has its own column. If one client pays in pounds and the rest in dollars, adding it all into one figure gives you a number that means nothing. The summary on the right adds up what has been collected and what is pending for each currency, and missing payments are highlighted in orange.
Check-ins: adherence, worked out for you
Each check-in is a row: date, weight, waist, sessions done, sessions planned, energy and sleep from 1 to 5, and notes. Adherence is calculated for you (done divided by planned) and turns orange when it drops below 75%.
The example has a client who goes from three sessions out of four to two, then to one, with a sore shoulder and a work trip along the way. Each week on its own has an explanation, but three in a row like that usually means a client on the way out, and the sheet shows it before they tell you. We go into it in nobody quits on the day they quit.
The 75% is a starting point. If a different threshold works for your clients, change it in that column's conditional formatting.
How to keep it tidy
- Write the name the same way on every sheet. If one sheet says Emma W. and another says Emma, Excel counts two clients. That is why the client column on Payments and Check-ins has a dropdown with the names from the Clients sheet.
- Add rows downwards. That way you can filter by client or by month without rebuilding anything.
- Stick to one unit. Pounds or kilos, inches or centimetres, whichever you prefer. If you mix them, the comparisons stop meaning anything.
What a spreadsheet will not do
You fill this template in yourself. Your client never sees it, so their sessions, their weight and how they slept reach you by text and you type them in. With five clients you barely notice. With twenty, Monday's check-ins take a whole morning of copying. We cover that in the spreadsheet holds until things go well. Until then, keeping everything in one sheet saves you a lot of headaches.
Download the template
Four sheets: Clients, Payments, Check-ins and one with instructions. It comes with sample data so you can see how each formula works; delete it and type in your own. It works in Excel and Google Sheets.
Download the personal trainer template (Excel, 29 KB)
In SynerTrain, your client logs their workouts, weight and measurements from the app, and you see each client's check-ins and payments in the same dashboard, with nothing to copy.