Personal trainer reviewing a client tracking spreadsheet on a laptop at a desk
Systems

Client Tracking Spreadsheet for Personal Trainers (Google Sheets Layout and Formulas)

7 min read

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.

Get the free CSVs by email

We email you a private download link. No payment. The previews below stay open to everyone.

  • Clients
  • Sessions
  • Payments
  • Renewals

One access email, even if you leave the box empty. The link works for 24 hours. Privacy policy

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.

Clients fictional example rows
Client IDNameEmailStatusStart dateRenewal datePlan link
EX001Example clientexample@example.comActive2026-10-012026-11-01Add restricted link

Sessions

Balance equals purchased minus used sessions. Check cancellations under the agreed terms.

Sessions fictional example rows
Client IDPurchasedUsedBalance
EX001835

Balance formula (sessions):

=B2-C2

Payments

Record only the payment reference needed, never card details.

Payments fictional example rows
Client IDReferenceAmountCurrencyDue datePaid dateStatus
EX001INV-001100GBP2026-10-012026-10-01Paid

Status formula (payments):

=IF(F2<>"","Paid",IF(E2<TODAY(),"Overdue","Open"))

Renewals

A reminder supports a conversation; it does not authorise automatic billing.

Renewals fictional example rows
Client IDRenewal dateNext action
EX0012026-11-01Discuss 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:

TabPurposeOne row per
RosterEvery client and their current statusClient
SessionsEvery session deliveredSession
PaymentsEvery payment receivedPayment
ProgressKey measurements over timeMeasurement 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:

ColumnFieldNotes
AClient nameDropdown source for other tabs
BStatusActive, Paused, Ended
CServiceIn person, Online, Hybrid
DPackageFor example 10 sessions, Monthly online
EStart date
FEnd or renewal date
GSessions boughtFor session packs
HSessions usedFormula
ISessions leftFormula
JLast session or check-inFormula
KTotal paidFormula
LGoalShort text
MNext actionShort text
NFlagFormula

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

  1. Daily: log sessions and payments as they happen. It takes seconds per entry.
  2. Weekly: filter the Flag column. Contact clients with low sessions or renewals due. Review anyone marked "No contact".
  3. Monthly: check the revenue summary, count active clients and note how many renewed or ended.
  4. 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.

Frequently asked questions

What should a personal trainer's client tracking spreadsheet include?

A roster with status, package, dates and next action, plus separate logs for sessions, payments and progress. Formulas on the roster summarise the logs.

Should I use one spreadsheet for all clients?

Use one coach-only tracker for the summary and a separate file per client for their programme, nutrition and check-ins. This keeps sharing permissions simple.

How do I track session packs in Google Sheets?

Enter the sessions bought on the roster, log each session in a Sessions tab, and use COUNTIFS to count sessions used. Subtract to show sessions left.

Can Google Sheets track client payments?

Yes, as a simple payments log and monthly total. Use proper accounting software or your accountant's tools for tax and bookkeeping.

Is a spreadsheet enough, or do I need software?

A spreadsheet works well for most solo trainers. Software is worth it if you need online booking, automated payments or a client app. See Google Sheets vs coaching apps for when each fits.

Run Your Coaching in Google Sheets

Use GSheetsPro templates for training plans, nutrition, client check-ins and progress tracking.

See GSheetsPro for £199