Skip to content
CoachesVault

Guide

How to track revenue as a private coach (a free spreadsheet, and a better option)

You can coach brilliantly and still have no idea whether the business is working. Tracking revenue is how you find out — here's the simplest version that works, and the version that works without you.

CoachesVault8 min read

Here's a question that stops a lot of coaches cold: what did you make last month? Not roughly — exactly. And which of your offerings brought it in? Most independent coaches can't answer without scrolling a payment app and doing arithmetic, which means they're running the business on feel. Feel is fine for coaching. It's a terrible way to run the money.

Tracking revenue doesn't require an accounting degree or expensive software. It requires four columns and the discipline to fill them — or, better, a setup where they fill themselves. Here's both: the spreadsheet to start with today, and the point where you should stop maintaining it by hand.

The four columns that matter

Forget elaborate bookkeeping for a moment. The minimum revenue tracker for a private coach is a single sheet, one row per payment, with four columns:

That's it. Fill that in every time money comes in and you can already answer the three questions that run a coaching business: what did I make, what sells, and who's behind. Add a fifth column for a rough category (or a note on which pack a payment bought) and you've got enough to hand a tax preparer at year-end.

The prepaid-pack trap

There's one wrinkle that trips up coaches specifically, and it's worth understanding before it bites you. When an athlete pays $500 for a 10-session pack, you got $500 today — but you owe ten sessions, delivered over the next two months. If your tracker only shows the $500 landing, your revenue looks lumpy and, worse, you lose track of how many sessions you still owe.

The fix is to track two things, not one: the payment when it arrives, and the sessions remainingas they draw down. A spreadsheet can do this with a second tab, but it's fiddly and easy to let slip — which is exactly the kind of counting that should be automatic. It's the same balance-tracking covered in how to manage coaching clients.

Where the spreadsheet stops working

A hand-kept sheet is the right first step and the wrong permanent home. It breaks in three predictable ways as you grow: you forget to log payments, so the numbers drift from reality; you can't easily see pack balances, so sessions leak; and it only tells you the past, never prompting you about the client who hasn't re-upped. The spreadsheet records history — it doesn't run the business.

A hand-kept spreadsheet
Revenue that tracks itself
How it's updated
You remember to type in every payment
Recorded automatically when the client pays at booking
Accuracy
As good as your discipline that week
Always matches what actually happened
Pack balances
A second tab you maintain by hand
Draw down on their own, always current
Who owes you
You work it out manually
Visible at a glance, per athlete
Month-end report
You rebuild it every month
Already there — nothing to assemble

The better option: make revenue a byproduct

The reason month-end feels like work is that you're reconstructing information that already existed at the moment each payment happened. If payment runs through your booking flow — the client books, the card is charged or the pack is drawn down — then every one of those four columns is captured at the source. The revenue report isn't something you build; it's something you open.

That's the whole idea behind automating a coaching business: the same event that gets you paid also records the revenue, updates the pack balance, and flags who's behind. You stop doing the bookkeeping because the bookkeeping is a side effect of getting paid properly. To fix the getting-paid half first, see how to accept payments as a private sports coach.

Know your numbers without the spreadsheet

CoachesVault records every payment, pack draw-down and outstanding balance as it happens — so revenue, attendance and who owes you are always one screen away. Set up and run for you.

See coaching revenue, tracked for you

Start manual, graduate to automatic

If you take one thing from this: start tracking today, even badly. The four-column sheet is infinitely better than the nothing most coaches run on, and you can build it in the next twenty minutes. But treat it as training wheels. The moment logging payments becomes its own chore — another line on the admin tax— that's the signal to let the numbers track themselves, so the report is always right and never your job.

Common questions

How should a private coach track revenue?
Start with a simple monthly spreadsheet: one row per payment with the date, athlete, what it was for (session, pack, membership), and the amount. That alone tells you what you made and who paid. As the roster grows, move to a system where payment happens through your booking flow, so revenue is recorded automatically and the report is always current rather than reconstructed at month-end.
What's the minimum I need to track as a coach?
Four columns: date, who paid, what for, and how much. That's enough to answer the questions that matter — what you earned this month, which offerings sell, and who still owes you. Everything else (tax categories, expenses) can be layered on, but a coach who tracks even these four is already ahead of most.
Why is tracking revenue in Venmo or a payment app not enough?
A payment-app history tells you money arrived, but not what it was for, whether a pack still has sessions left, or who hasn't paid at all. It captures transactions, not your business. To actually understand revenue you need each payment tied to an athlete and an offering — which a raw Venmo feed can't give you.
Should coaches track revenue on a cash or accrual basis?
For most independent coaches, simple cash-basis tracking — recording money when it actually arrives — is enough to run the business and is what a tax preparer will typically expect from a sole proprietor. The nuance with coaching is prepaid packs: money can arrive in one month for sessions delivered across several. Note the sale when paid, and track the remaining sessions separately so you always know what you still owe in coaching.

When coaches win, athletes win.

We’re building more than software. We’re building the future of coaching businesses and investing in the communities they serve.

Build with CoachesVault