How to run a chess academy without living in spreadsheets

Most chess academies start the same way: a notebook, then a spreadsheet, then a WhatsApp group for each batch. It works — until it doesn't. Somewhere between thirty and sixty students, the admin starts eating into coaching time.

This guide walks through what to organise, in what order, so the academy keeps feeling personal as it grows.

1. Decide what a "student record" contains

Before choosing any tool, write down what you actually need to know about every student. For most academies that's:

• Who they are — name, age, and the parent or guardian you speak to.
• Where they fit — batch, level and coach.
• How they're doing — a monthly assessment and a line of feedback.
• What they owe — the current fee period and when it ends.
• How they play online — their Chess.com or Lichess username, if they have one.

If a detail doesn't change a decision you make, leave it out. Every extra column is something someone has to keep up to date.

2. Group students into batches, not just levels

Levels (beginner, intermediate, advanced, expert) describe a student's chess. Batches describe your timetable: Intermediate A, Tuesday and Thursday at 6 PM, Coach Akshaya. Keeping both lets you plan classes by batch while tracking progress by level — and lets a student move up a level without changing class times.

3. Treat fees as periods, not payments

Instead of tracking "paid / not paid", record each paid period: a start date, an end date and an amount. Everything else follows from the end date:

• More than a week left — nothing to do.
• A week or less — a reminder is due.
• Past the end date — the fee is overdue.

When a family pays, you record the next period. There's no status to remember to flip, and reminders can go out automatically on fixed days (for example two days before, on the due date, and a day after).

4. Give parents one place to look

Parents mostly want to know two things: is my child improving? and is anything due? When those answers live in one shared place — rather than in scattered messages — the "quick question" calls drop off, and your updates look as professional as your coaching.

5. Make progress visible every month

A short monthly routine is enough:

1. Rate a handful of skills (tactics, strategy, openings, endgames, calculation) on a 1–5 scale.
2. Write one or two sentences of feedback.
3. Name the next focus area.

Over a few months, those scores become a trend a parent can read at a glance — far more convincing than a rating number on its own.

Where software helps

You can run all of this in spreadsheets with enough discipline. Dedicated academy software earns its keep when it removes the repetitive parts: sending reminders, syncing chess ratings, assembling monthly reports, and giving families their own login so you're not the bottleneck for every update.