Build a client tracking spreadsheet for personal training in Google Sheets: roster columns, session and package balances, payments, progress tracking and renewal flags, with formulas you can copy.
Free starter CSV downloads
Get every tab as a CSV by email, then import them into your own Google Sheet. The previews below are open to everyone and use fictional example data.
CSV files carry the layout and example rows only, not formatting, charts, checkboxes or a shared Google Form. Formula cells arrive as text: check each one, then delete the leading apostrophe to switch it on.
Clients
Use unique IDs and keep this roster coach-only.
| Client ID | Name | Status | Start date | Renewal date | Plan link | |
|---|---|---|---|---|---|---|
| EX001 | Example client | example@example.com | Active | 2026-10-01 | 2026-11-01 | Add restricted link |
Sessions
Balance equals purchased minus used sessions. Check cancellations under the agreed terms.
| Client ID | Purchased | Used | Balance |
|---|---|---|---|
| EX001 | 8 | 3 | 5 |
Balance formula (sessions):
=B2-C2Payments
Record only the payment reference needed, never card details.
| Client ID | Reference | Amount | Currency | Due date | Paid date | Status |
|---|---|---|---|---|---|---|
| EX001 | INV-001 | 100 | GBP | 2026-10-01 | 2026-10-01 | Paid |
Status formula (payments):
=IF(F2<>"","Paid",IF(E2<TODAY(),"Overdue","Open"))Renewals
A reminder supports a conversation; it does not authorise automatic billing.
| Client ID | Renewal date | Next action |
|---|---|---|
| EX001 | 2026-11-01 | Discuss renewal |
Next action formula (renewals):
=IF(B2<=TODAY()+7,"Review renewal","Scheduled")A client tracking spreadsheet answers three questions every day: who am I training, what do they owe or have left, and who needs attention. Personal trainers often keep this information across a diary, a banking app and message threads. A single Google Sheet puts it in one place.
This guide shows how to build a client tracking spreadsheet for personal trainers, whether you train clients in person, online or both. It covers the tabs, the columns, the formulas and a weekly routine.
This tracker covers the business side. If you want the client-facing files pre-built, GSheetsPro includes a client management dashboard and check-in sheets.
The Four Tabs You Need
Keep the tracker in one coach-only file with four tabs:
| Tab | Purpose | One row per |
|---|---|---|
| Roster | Every client and their current status | Client |
| Sessions | Every session delivered | Session |
| Payments | Every payment received | Payment |
| Progress | Key measurements over time | Measurement date |
Separate tabs keep each record simple. The Roster tab then uses formulas to summarise the others, so you never type the same data twice.
Use the same client name spelling in every tab. A small typo breaks every lookup. Data validation on the name columns (a dropdown from the Roster list) prevents this.
Tab 1: The Client Roster
The roster is your daily view. Add these columns:
| Column | Field | Notes |
|---|---|---|
| A | Client name | Dropdown source for other tabs |
| B | Status | Active, Paused, Ended |
| C | Service | In person, Online, Hybrid |
| D | Package | For example 10 sessions, Monthly online |
| E | Start date | |
| F | End or renewal date | |
| G | Sessions bought | For session packs |
| H | Sessions used | Formula |
| I | Sessions left | Formula |
| J | Last session or check-in | Formula |
| K | Total paid | Formula |
| L | Goal | Short text |
| M | Next action | Short text |
| N | Flag | Formula |
Freeze row 1 and column A so the headers and names stay visible when you scroll.
Tab 2: Sessions Log
Log each session as one row: Date, Client, Session type, Notes. For online clients, log each check-in review here too, with a type of "Check-in".
In the Roster, calculate sessions used, sessions left and the last contact date:
Sessions used (H2): =COUNTIFS(Sessions!B:B,A2,Sessions!C:C,"<>Check-in")
Sessions left (I2): =IF(G2="","",G2-H2)
Last contact (J2): =IFERROR(MAXIFS(Sessions!A:A,Sessions!B:B,A2),"")
Format J as a date. If MAXIFS returns 0 for a client with no sessions, the date shows as 30/12/1899. Wrap it to hide that:
=IF(COUNTIF(Sessions!B:B,A2)=0,"",MAXIFS(Sessions!A:A,Sessions!B:B,A2))
Tab 3: Payments
Log each payment as one row: Date, Client, Amount, Method, What it covers. Then total each client's payments in the Roster:
Total paid (K2): =SUMIFS(Payments!C:C,Payments!B:B,A2)
For a monthly revenue view, add a summary table on a separate tab. With the first day of the month in A2:
=SUMIFS(Payments!C:C,Payments!A:A,">="&A2,Payments!A:A,"<"&EDATE(A2,1))
This shows cash received per month. It is not accounting software, so keep your bookkeeping and tax records in the tools your accountant uses.
Tab 4: Progress
Log measurements as rows: Date, Client, Bodyweight, Waist, Key lift, Notes. One row per client per measurement date keeps the data easy to chart. For bodyweight, log a weekly average, not one reading. The free weekly average weight calculator works it out from up to seven weigh-ins.
To show a client's latest bodyweight in the Roster:
=IFERROR(INDEX(SORT(FILTER(Progress!A:C,Progress!B:B=A2),1,FALSE),1,3),"")
This filters the client's rows, sorts them newest first and returns the bodyweight from the top row.
For a quick trend in the Roster, a sparkline shows the last entries at a glance:
=IFERROR(SPARKLINE(FILTER(Progress!C:C,Progress!B:B=A2)),"")
Keep detailed progress, programmes and check-ins in each client's own file. The coach tracker only needs the summary.
Flags: Who Needs Attention Today
Combine the rules you care about into one Flag column (N2). This example flags low session balances, renewals due in 14 days and clients with no contact for 10 days:
=IF(B2<>"Active","",
IF(AND(I2<>"",I2<=2),"Low sessions",
IF(AND(F2<>"",F2-TODAY()<=14),"Renewal due",
IF(AND(J2<>"",TODAY()-J2>10),"No contact",""))))
Add conditional formatting to column N so any non-empty value turns amber. Then filter the Roster by the Flag column to get today's action list.
Adjust the thresholds to your business. A trainer who sees clients twice a week may use 5 days for "No contact". An online coach with weekly check-ins may use 8.
A Weekly Tracking Routine
- Daily: log sessions and payments as they happen. It takes seconds per entry.
- Weekly: filter the Flag column. Contact clients with low sessions or renewals due. Review anyone marked "No contact".
- Monthly: check the revenue summary, count active clients and note how many renewed or ended.
- When a client ends: set Status to Ended rather than deleting the row. Your history stays intact for retention analysis.
Example: A Hybrid Trainer's Roster
Consider a trainer with 12 in-person clients on 10-session packs and 8 online clients on monthly plans. Both groups sit in the same Roster:
- In-person clients have a value in Sessions bought, so Sessions left counts down as sessions are logged. The "Low sessions" flag prompts a renewal conversation before the pack runs out.
- Online clients leave Sessions bought blank, so the session columns stay empty. Their End or renewal date drives the "Renewal due" flag, and weekly check-in reviews logged as "Check-in" drive the "No contact" flag.
Filter by Service to review each group separately, or sort by Flag to see everyone who needs action first. One file covers both ways of working.
Privacy and Sharing
This tracker holds personal and payment data. Keep it coach-only. Share only a client's own file with that client, never the tracker. Hidden tabs and protected ranges do not stop someone with access from seeing the data.
If you store health information, such as injuries or medical conditions, check your obligations under UK GDPR. Collect only what you need, and keep it in a secure Google account with two-step verification turned on.
Pre-Built Client Files
This tracker covers the business side. For the client side, GSheetsPro includes a client management dashboard, training plans, meal plans, check-in sheets and a weekly progress tracker in Google Sheets, for £199 one-time. See the full system on the pricing page.
Related guides: how to manage coaching clients in Google Sheets, online coaching check-in template and 5 Google Sheets templates for fitness coaches.
Managing online coaching clients
Keep five linked views: a master roster, an onboarding checklist, a weekly check-in log, a progress view and a renewals log. Use one client ID across them.
Onboarding checklist
Record intake received, goals agreed, initial measurements recorded, programme sent, nutrition targets discussed and welcome message sent. Assign an owner and completion date to each task. Keep a client pending until the required steps are complete.
Weekly review and renewals
Review check-in date, adherence, sleep, stress and the client's own notes. Record the next action and who owns it. Sort renewals by date; use amber for dates within 14 days and red for dates within 7 days. These are example review windows, not evidence about retention.
Share a separate file with each client. Hidden or protected tabs are not a privacy boundary. Keep the master roster and coach-only notes private. Test access as a client before using real data.
Set-up sequence
Build the roster first, then add onboarding checkboxes, check-in fields and a progress chart. Finally add payment and renewal records. Test with fictional clients before onboarding anyone.
Track billing with the personal trainer invoice template. Confirm required invoice fields and tax treatment with your accountant.



