Personal Trainer Client Tracking Spreadsheet: Sessions, Packages and Payments

Running your own client base as a trainer or coach means doing three jobs at once — coach, scheduler, and bookkeeper — usually with only the first one formally set up. Sessions happen and get remembered instead of logged. A client's package runs out mid-session because nobody was counting down. A payment goes half-collected and gets lost the next time that client is back in for training.

None of that needs a booking platform or a monthly subscription to fix. It needs three logs — sessions, packages, and money — each with a handful of the right columns, and about twenty minutes a week to keep current. Here's how to set them up.

The session log: one row per session, not per client

Every session gets its own row, whether it happened, didn't happen, or got cancelled. Columns: Date, Client Name, Session Type, Duration, Status, Fee, and Notes.

Status is the column that does the most work, and it needs exactly three options: Completed, No-Show, and Cancelled. Highlight No-Show rows automatically so a pattern shows up visually rather than requiring you to scroll and count — a client who's shown up as a no-show twice this month is a conversation worth having about your cancellation policy, and that conversation is easier to start when the rows are sitting there in red rather than buried in a memory of "didn't they miss one recently?"

From the session log, a dashboard should tell you, without any manual counting: total sessions logged, completed sessions, your no-show rate as a live percentage, and total revenue from fees. That no-show rate in particular is worth watching month to month — a rate that's drifting up is usually a signal about your reminder system or your cancellation window, not a run of bad luck with clients.

Packages: where renewals get missed

Most trainers sell in packages rather than single sessions, and packages create a specific tracking problem single sessions don't: a client can run out of sessions without anyone noticing until they're already at zero. A package log fixes that. Columns: Client Name, Package Type, Purchase Date, Sessions Included, Sessions Used, Sessions Remaining, Package Price, Amount Paid, Balance Due, and Payment Status.

Sessions Remaining should be a formula — sessions included minus sessions used — never a number you update by hand, because a hand-updated countdown is exactly the kind of column that drifts out of sync the first busy week you have. Conditional formatting that highlights any package down to two sessions or fewer in amber turns the renewal conversation from something you remember to have into something the sheet reminds you of. See a client's row go amber and you have the conversation before their last session, while there's still time — not after, when the only option left is starting over from a cold ask.

If you're deciding what to price a new package at in the first place, run the numbers through the personal training package pricing calculator before you set a number — a package priced without checking your own cost per session against the discount you're offering can look generous to the client and thin for you.

Payments: catching the balance that's still owed

Package Price and Amount Paid belong in separate columns, with Balance Due calculated as the difference — never typed in, for the same reason Sessions Remaining shouldn't be. A Payment Status dropdown of Paid, Partial, and Unpaid lets you filter the whole log down to exactly the clients who owe you money, in one click, instead of scanning every row.

Highlight any row carrying a balance above zero. It's a small thing, but it's the difference between an unpaid balance you catch this week and one that's still sitting there three months later because the client came back for more sessions and the outstanding amount got mentally filed under "I'll deal with that eventually." A dashboard that totals packages sold, revenue collected, outstanding balance, and total sessions remaining across every client gives you the whole picture of where your money — collected and still owed — actually stands.

Income and expense categories built for a training business

A trainer's income doesn't come in one shape. Six categories cover most businesses, whether you're gym-based, studio-based, or fully online: 1:1 Training Sessions, Group Classes, Online Coaching, Nutrition Consults, Package Sales, and Other Income.

Expenses need a matching list built for the same business, not a generic small-business template:

Log each transaction with Date, Type (Income or Expense), Category, Description, and Amount. From that log, total income, total expenses, net profit, and profit margin should all update on their own — with both net profit and margin flagged the moment you're operating at a loss, so a slow month shows up while it's still a small problem rather than something you discover three months later staring at a bank balance.

Tying it together: revenue per client, not just in total

Once sessions, packages, and income are all logged with a client name attached, you can answer a question total revenue alone can't: which clients are actually worth the calendar space they take up. A client on a large package who never no-shows and renews without being asked is worth more to your business than the number in your revenue column alone suggests — and a client who books single sessions sporadically and cancels often may be costing you more in schedule friction than their fee reflects. That comparison only becomes visible once the logs are connected by client name, which is one more reason to keep names spelled identically across all three sheets, exactly the way property names need to match across a landlord's logs.

The weekly routine

Twenty minutes a week is enough once the three logs are set up:

1. Sessions (8 min): log every session from the week — completed, no-show, or cancelled. Do this the same day if you can; a week of sessions reconstructed from memory on Friday is where details and even whole sessions go missing.
2. Packages (5 min): update Sessions Used for anyone who trained this week. Check for any row that's gone amber and send a renewal message before their sessions run out.
3. Money (5 min): log any income and expenses from the week. Filter Payment Status for Partial or Unpaid and follow up on anyone still owing.
4. Numbers (2 min): glance at net profit and no-show rate. Either one moving the wrong way is worth five minutes of thought now, not a surprise at month-end.

This system tracks the business side of training — sessions, packages, payments, income and expenses. It isn't fitness, nutrition, medical, legal, or tax advice, and it doesn't replace your certification's scope-of-practice guidance or a qualified professional's input on anything specific to your situation or your clients' health.