Coaching Software

Coaching Client Tracking: The Five Questions Your Roster Has to Answer (2026)

Sage.Coach September 16, 2026

Two men in plaid shirts talking across a white standing desk by a window, one gesturing mid-explanation over an open laptop, the other listening with hands folded, in a grey modern office.

Quick answer: Coaching client tracking is keeping one current answer, per client, to five questions: what they’re working toward, when you last met, what they committed to, how many sessions are left in their package, and when the next one is booked. A spreadsheet can hold those five columns. What it can’t do is keep them current without you, and at roster size that’s the whole job. Under about 15 clients, track it by hand. Above that, the tracking has to update itself from the sessions, or it goes stale the week you get busy.

I run a career coaching practice with 33+ active clients, and for two years I tracked them in a Google Sheet that I was proud of. It had every column below. It was also usually three days out of date, because it only knew what I’d typed into it, and I typed into it last.

Methodology note: every number in this post is from my own practice. I didn’t survey anyone.

The five things coaching client tracking has to answer

If you open a client’s row, page, or record, it should tell you these five things without a second click:

The goal, in one line. Not the intake form. The current version of what they’re working toward, which changes. In career coaching, “land a director role by March” turns into “decide whether to take the counteroffer” six weeks later, and it happens a lot. If the tracker still says the first one, it’s tracking a client who no longer exists.
Last session date, and what happened. The date alone tells you who’s gone quiet. The one-line summary tells you what to open with.
Open commitments. What they agreed to do before next session, and whether it’s done. This is the column that turns tracking into coaching. Everything else is admin.
Sessions used and remaining. My packages are a fixed number of sessions. A client with two left needs a renewal conversation, and I want to have it at session ten, not after session twelve when they ask “so is that it?”
Next session booked, or not. A client with no next session on the calendar is the single strongest early signal of a drift-off I’ve found in my practice. Not a cancelled session. No session.

The spreadsheet version, and exactly where mine broke

For anyone under 15 clients, here’s the sheet I’d build, because it’s the one I built:

One row per client, one column per question above, plus package price and start date.
A “days since last session” formula so the quiet ones sort to the top.
Conditional formatting on sessions remaining, so anything at two or below goes yellow.

That’s a real system, and it worked. Then the roster passed 15 and three things broke in the same month.

It went stale. The sheet only changed when I edited it, and the edit was always the last thing after a session. On a day with four sessions, the fourth client’s row got updated the next morning, or not. The ICF Code of Ethics asks coaches to maintain records in a way that protects confidentiality. Mine were whatever I’d remembered to type.

Commitments lived in two places. The one-line commitment in the sheet, and the full version in my session notes in Notion. When they disagreed, and they did, I didn’t know which one the client had actually said.

Nobody else could read it. When I brought on help, the sheet was mine. Every column had a private meaning. “Sessions remaining: 3*” meant something to me and nothing to anyone else. The how to manage coaching clients post goes into what a second person on the practice actually needs to see.

None of this was the spreadsheet’s fault. It was doing what spreadsheets do. It was waiting for me.

What “current” actually requires

The fix isn’t more columns. It’s changing who updates them.

In my practice, every one of the five questions has a natural source that isn’t me typing:

Goal comes from the roadmap I build with the client, which I already edit during sessions.
Last session and summary come from the session note, which I already write. The tracker should read the note’s date and first line, not ask me to copy them.
Open commitments come from the session note too. If the note has a “next steps” field, the tracker should show those as open until one of us closes them.
Sessions remaining should decrement when a session happens, not when I remember it did.
Next session is on the calendar already. The tracker should look there.

When I was running 33+ clients through Notion plus Cal.com plus the sheet, about 4 hours a week went to moving information between those three so they’d agree. That’s the cost of a tracker that waits for you. It isn’t the typing. It’s the reconciling.

This is the difference between a client tracker and a coaching CRM: a CRM stores what you tell it, a tracker in the sense I mean here updates from the work. The per-session layer on top of this is in coaching goal tracking software. This post is the roster underneath.

The three reports I actually run

Once the five questions are current on their own, three views pay for the whole system. I run them once a week, and with the data already current they take under ten minutes across the full roster.

Quiet clients. Everyone with no session in the last 14 days and no next session booked. Each one gets a message that day. In my practice this is where most drift-offs get caught, and most of them turn out to be scheduling, not disengagement.
Renewal window. Everyone with two or fewer sessions left. Each one gets the renewal conversation at their next session, with me having thought about it first.
Overdue commitments. Everyone whose last commitment is more than a week past its date. I don’t chase these by message. I open the next session with them, which is a different conversation than “did you do the thing.”

Three lists, once a week, from data I didn’t type. The spreadsheet could produce the first two if I kept it current. The third it never could, because commitments were in the notes.

When to switch, and when not to

Don’t switch at five clients. A sheet with the five columns and the “days since” formula is the right tool, and it costs nothing. Build it, and notice the week it goes stale.

Do switch when you can’t state, from memory, every client’s open commitment. For me that was somewhere around 15. Past that point the sheet stops being a record and becomes a to-do item called “update the sheet,” and to-do items called that don’t get done on a four-session day.

I built Sage after my own sheet lost the race. Sessions, notes, commitments, and package counts live in one client record, so the five questions are current because the session happened, not because I filed it. Coaches are unlimited on every tier, which fixed the “nobody else can read it” problem for free.

FAQ

What is coaching client tracking?
A current record, per client, of their goal, last session, open commitments, sessions remaining, and next booked session. The word that matters is current.

Can I track coaching clients in a spreadsheet?
Yes, and under about 15 clients you should. It breaks when updating it becomes a task you do after the real work, so it lags exactly when the roster is fullest.

What should a coaching client tracker show at a glance?
Who’s gone quiet, who has two or fewer sessions left, and who has an overdue commitment.

How is client tracking different from a coaching CRM?
A CRM stores what you enter. Client tracking, done properly, updates from the sessions: the note sets the last-session date, the commitment carries forward, the count decrements.

How often should I review my client roster?
Once a week, if the data is current on its own. For my 33+ clients it takes under ten minutes. Longer than that means the time is going into updating, not reviewing.