Track coaching revenue without a complex spreadsheet

To run a coaching business, three amounts are enough: what you have collected, what you are owed for sessions already delivered, and what is scheduled for the rest of the month. Add three ratios to make sense of them: average revenue per session, no-show rate and number of active clients.

Many coaches know whether they are busy, but not whether the business is improving. These six numbers, reviewed once a month, give you a reliable basis for decisions: follow up, open more slots, adjust a price or work on retention.

The most common mix-up is adding paid sessions, delivered-but-unpaid sessions and sessions that are merely booked, then calling the total “this month's revenue”. The figure looks good, but it matches nothing in your bank account.

Always keep three separate columns. Collected tells you what you can spend, owed tells you whom to follow up with, and scheduled tells you whether next month will be quiet or busy. Each one calls for a different action.

You do not need endless charts. These indicators cover the essentials, as long as they are calculated from your real sessions and real payments, not from estimates.

Step 1 — Reconcile payments: every delivered session should be marked paid, waived or owed.

Step 2 — Follow up on amounts owed, oldest first, with a short message and a payment link.

Step 3 — Compare the delivered amount with your monthly goal and identify the gap.

Step 4 — Check the no-show rate: if it is rising, review your reminders and cancellation policy.

Step 5 — List clients with no upcoming session and reach out to them personally.

Step 6 — Pick one action for next month: open slots, contact past clients, launch an offer or adjust a price.

Take a fictional month: 64 sessions scheduled, of which 58 delivered, 4 no-shows and 2 cancellations, at €45 a session. The delivered amount is 58 × €45 = €2,610. Of those 58 sessions, 52 are paid: €2,340 collected, and 6 sessions still owed, or €270.

The no-show rate is 4 ÷ (58 + 4), about 6.5%. Against a €3,000 goal, the gap is €390. The levers are immediately visible: collect the €270 owed, apply the cancellation policy to unannounced no-shows, and fill three open slots to close the rest. Without this reading, the coach would simply have felt it was “a good, busy month”.

A useful goal is ambitious but reachable. Two simple methods let you set one without guessing.

From your history: take your average collected revenue over the last three months and add about 10%. From your capacity, if you are just starting: multiply your available hours per week by 4.33, then by a conservative occupancy rate and your hourly rate. For example, 20 available hours × 4.33 × 30% occupancy × €50 ≈ €1,300 a month (illustrative numbers).

A spreadsheet works while you have few clients and plenty of discipline. Its limit is structural: every session and every payment has to be typed in again, and one missed entry silently skews every total.

A dedicated tool calculates revenue from the sessions themselves and their payment status. You no longer keep books alongside your work: the numbers come from what you already do, booking, delivering and getting paid.

In Grix, every session carries a payment status (paid, unpaid, waived, free, refunded) and, for offline payments, a method: cash, bank transfer, check or other. The dashboard uses this to show your monthly revenue against a goal you set, or one suggested from your history or capacity, along with a forecast and the amount owed. You also see sessions completed, upcoming and missed, the no-show rate, average revenue per session, and active, new and at-risk clients. The Pro plan adds advanced analytics such as trends.

Grix is not accounting software and does not issue invoices. Depending on your country and business status, you may have record-keeping and invoicing obligations: exporting your data as CSV makes working with your accountant easier, but it does not replace your accounting tools.