Running a sports coaching business without spreadsheets

What the spreadsheet is really doing for your sports coaching business, where it breaks, and which jobs to move off it first.

· 4 min read

A coach working on a spreadsheet on his laptop looking a little stressed

Most sports coaching businesses run on a spreadsheet at some point. It starts as a list of names for a Saturday session. A few months later it has a tab for each term, a column for who has paid, another for medical notes, and colour coding that only you understand.

There's nothing wrong with a spreadsheet. It's free, it's flexible and you already know how to use it. The trouble starts when it becomes the place where bookings, money and safeguarding details all meet, because it can't do any of those jobs on its own.

This post looks at what the spreadsheet is really doing for you, where it tends to break and what to move off it first.

What the spreadsheet is actually doing

Before you replace anything, be clear about the jobs the spreadsheet holds. For most coaches there are four:

  • the booking list: who is coming, to which session, on which dates
  • the money: who has paid, who owes you, and how much
  • the register: who turned up and, at a holiday camp, who went home with whom
  • the details: phone numbers, allergies, medical notes and who is allowed to collect

Each of those arrives from somewhere else first. A WhatsApp message. A bank transfer with a reference that doesn't match the child's name. A Google Form response. A conversation at the gate. The spreadsheet is where you copy it all, and the copying is where things go wrong.

Where it breaks

The problems are rarely dramatic. They're small, and they add up.

Payments drift out of step with bookings. A parent books by message and says they'll transfer the money. The transfer turns up three days later from their partner's account with "football" as the reference. Matching the two takes an evening at the end of every week, and a missed match means you either chase somebody who has paid or forget somebody who hasn't.

The sheet on your laptop isn't the sheet at the gate. The copy on your phone at 3pm is whatever you last synced or printed. If a parent texted at lunchtime to change who is collecting, the coach on the gate doesn't know.

Sensitive details travel too far. Medical notes and collection permissions end up in a file that gets emailed to assistant coaches, printed and left in kit bags. You're responsible for that information, and a spreadsheet gives you very little control over who sees it.

It only works while you run it. The colour coding and the "ask me" cells live in your head. The day you take on another coach or miss a session, the sheet stops making sense to anyone else.

What to move off first

You don't have to replace everything at once. Start with the job that costs you the most time.

1. Take payment when people book

Most of the admin comes from bookings and payments arriving separately. If nobody can book a place without paying for it, there's nothing to match up. This change usually saves the most time, and parents barely notice it, because paying by card when they book is what they do everywhere else.

We compare the options, from cash to booking systems, in how to take payments as a sports coach.

2. Write your cancellation policy down

Refunds are where informal arrangements get awkward. Decide in advance what somebody gets back if they cancel a week before, a day before or on the morning, and have them agree to it when they book. A cancellation then follows a rule instead of starting a negotiation. See how to write a cancellation policy for sports coaching.

3. Put the register on your phone

A register you update on the pitch, built from the bookings people actually made, is right on the day rather than right at the last sync. At a holiday camp the part that matters most is pick-up: who may collect each child, and a record of who did. We cover that in holiday club collection passwords.

4. Keep the details with the booking

Medical notes, emergency contacts and collection permissions belong with the booking they came in on, where the people running the session can see them and nobody else can. They don't belong in a file somebody forwarded.

Keep a spreadsheet for what it's good at

None of this means you never open a spreadsheet again. It's still the best tool for working out your prices, planning next term or looking back over the year. You just stop using it as the system that runs the day, which it was never built for.

Once a spreadsheet is filled from your bookings rather than typed by hand, it becomes useful again. You export the list you need when you need it, and it matches what actually happened.

How it works on Pitch Gurus

Pitch Gurus puts those four jobs in one place for sports coaches and holiday camps.

  • People book and pay by card in one step, and Stripe pays the money out to your bank.
  • Your cancellation policy sits on every booking, customers agree to it before they pay, and refunds follow it.
  • The register runs on your phone, with check-in, collection passwords and a record of who collected each child.
  • You can download the participant list as a spreadsheet whenever you need one, choosing which columns it has.

It also lists your sessions and camps where parents and athletes are already searching, so the system that replaces your spreadsheet brings in bookings too. See how selling works on Pitch Gurus.

Take bookings, payments and registers in one place, and get found by parents and athletes who are already looking.

30 days free. Card details at sign-up, nothing charged until day 31. When you get booked, you pay 2% plus Stripe's fee.