Spreadsheets

A client package and session tracker for fitness trainers

A client package and session tracker for fitness trainers: sessions used and remaining, payment status, renewal flags and monthly income and expenses.

Editorial illustration for A client package and session tracker for fitness trainers

A personal trainer sells packages, not single hours, so the sheet has to track three things for every client: what they paid for, how many sessions they have used, and when the package runs out. A Clients tab and a Sessions tab, joined by COUNTIF, do this with very little typing. Add a renewal flag and a monthly income and expense roll-up and you have a working system.

What does the Clients tab hold?

ColumnHeadingNotes
AClientFirst name or a short code
BPackageFor example, 12 sessions
CStart dateReal date
DSessions in package12
EValidity in daysYour own policy
FPriceAgreed amount
GPaidReceived so far
HPayment status=IF(G2>=F2, "Paid", "Pending")
ISessions used=COUNTIF(Sessions!$B$2:$B$2000, A2)
JSessions left=D2-I2
KExpiry date=C2+E2
LRenewal flagSee below

How do you log sessions?

On the Sessions tab, add a row each time a session is done: the date in column A and the client name in column B, spelled exactly as in the Clients tab. A drop-down on column B pulled from the Clients list removes spelling errors. The Sessions used column counts these rows by itself.

How do you flag who needs to renew?

In L2 put:

=IF(OR(J2<=2, K2-TODAY()<=7), "Renew soon", "")

It lights up when two or fewer sessions remain or the package expires within a week. To catch lapsed packages with sessions still unused, add a second condition: =IF(K2<TODAY(), "Expired", IF(OR(J2<=2, K2-TODAY()<=7), "Renew soon", "")). Conditional formatting on the column makes these visible at a glance.

What does a worked example look like?

Say a client buys a 12-session package for ₹9,600 (hypothetical), valid for 90 days. The price per session is 9,600 divided by 12, which is ₹800. After 10 sessions, she has used 10 and has 2 left, so the flag shows Renew soon. The value of sessions delivered is 10 x 800 = ₹8,000, even if the whole ₹9,600 was paid in advance.

That difference is worth watching. Cash received is not the same as work done, and a trainer who spends the advance can find it hard to deliver the last sessions when the client turns up.

How do you see monthly income and expenses?

Add a Payments tab: date, client, amount. On a Monthly tab, with the first of each month in column A:

  • Income received: =SUMIFS(Payments!$C$2:$C$1000, Payments!$A$2:$A$1000, ">="&A2, Payments!$A$2:$A$1000, "<"&EDATE(A2,1))
  • Sessions delivered: =COUNTIFS(Sessions!$A$2:$A$2000, ">="&A2, Sessions!$A$2:$A$2000, "<"&EDATE(A2,1))
  • Expenses: a similar SUMIFS on an Expenses tab for gym rent, equipment, certification and travel
  • Surplus: income minus expenses

What to do when a client pauses

Illness, travel or exams happen. Decide your policy in advance: freeze the clock, extend the expiry, or let it run. If you extend, update column E for that client and add a note. A policy written once saves arguments later.

Keep it simple on busy days

  • Log each session straight after it ends, even on your phone.
  • Check the Renew soon column every Monday and message those clients.
  • Keep a separate tab for one-off sessions and trial classes so they do not distort package numbers.

How do you report to yourself each quarter?

Once every three months, count how many clients renewed against how many packages ended. Divide renewed packages by ended packages for a renewal rate of your own. Add the average sessions used per package and the typical gap between sessions. If many clients leave with sessions unused, the package may be too large for how people actually train, and a smaller first package could suit them better.

Your expenses, such as hall rent, equipment and online tools, are on your statements. SpendixAI can import those and categorise them, so the Expenses tab in this sheet can be filled from a report instead of typed.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports