Personal Trainer Client Tracking: A Spreadsheet Alternative

What a trainer’s tracking sheet needs

• Client name and package size.
• Sessions used and sessions left.
• Package purchase date and any expiration policy.
• A renewal flag when sessions left gets low.

Where spreadsheets break down

• Formulas get overwritten or dragged wrong when you add a client.
• Sessions logged late mean the number is already stale.
• There is no nudge when a client is down to one session.
• It is awkward to update on your phone between sessions.

A routine that works with any tool

1. Update the count at the end of every session, not at the end of the week.
2. Check for clients with two or fewer sessions left at the start of each week.
3. Bring up renewal at the session before the last, not after it.
4. Write your expiration and rescheduling rules down and share them with each client.

Use the tracker below to see the numbers for your whole client list in one view, then keep the habit of logging each session right away.