Spreadsheets get an agency a long way. They're also why the month end takes so long, and why one person ends up holding the whole business in their head. Moving off them is less about the new system than about getting your information straight and choosing the right moment.
You don't need to stop the term to do it. You need a clear picture of what you have, a sensible date, and a short message to families.
Start by listing what your spreadsheets actually do
Before you tidy anything, write down every file and what it's used for. The job is usually split across more places than you'd expect. Look for:
- the timetable, and any second copy of it
- who pays what, and who owes what
- what each tutor is owed this month
- tutors' own calendars and message threads where lessons get changed
- notes that only exist in someone's inbox
Where the same thing lives in two places, decide which one is right. That single decision saves more time later than any amount of formatting.
Tidy the four things that matter
Families and students
Aim for one row per student, with the parent who pays alongside them. Put first names, last names, emails and phone numbers in separate columns. Brothers and sisters should share the same parent email so they end up in one family. Mark anyone who has left, so they aren't invited to anything by mistake.
Tutors
Names, contact details, subjects and what each tutor is paid. If you pay different rates for different subjects or levels, make that visible now rather than leaving it in your head.
Rates
Write down what each family pays and note every exception. Long-standing families on an older rate are the usual surprise. It's far easier to spot them now than after a wrong invoice has gone out.
Anything still in progress
This is the part people forget: unpaid invoices, credits you owe families, lessons paid for in advance, and tutor pay not yet settled. Make a separate list of these, because each one has to be either finished in the old way or carried across on purpose.
Don't tidy the past
Old lessons and old invoices rarely need cleaning up. Save a copy of the spreadsheets as they stand, keep it somewhere safe and read-only, and spend your effort on who you teach today. If someone asks about a lesson from two years ago, the answer will still be in that copy.
Pick a clean date
You don't have to wait for September. What matters is that each invoice and each pay run belongs clearly to one system, so the best date is the first day of a billing period. Half-term can work well too, because it gives the office a quieter week to settle in.
Try not to change anything else at the same moment. A new system, new prices and a new cancellation policy all at once makes it hard for families to tell what has changed and why. Move first, then make your other changes once things are calm.
Run both for a short while
Keep the spreadsheets going while you check the new system against them. Two checks matter most:
- The timetable. Compare a full week, lesson by lesson, including who teaches and at what time.
- The first invoices. Before anything goes out, compare the first run against what your spreadsheet says each family owes. Do the same for the first tutor pay run.
Once a full month has matched, stop updating the spreadsheets. Keeping them going any longer only brings back the problem you set out to solve.
Tell tutors first, then families
Tutors will get the questions from parents, so they should hear first and try the new system before families do. Show them the handful of things they'll do every week, such as logging a lesson.
For families, keep the message short and answer three questions:
- What's changing? A new place to see lessons, notes and invoices.
- What's staying the same? Their tutor, their lesson times and their fees.
- What do they need to do? Ideally, click one link.
It helps to invite a few families you know well first. They'll tell you if anything is confusing before everyone else sees it. Give everyone one named person to contact if they get stuck.
A short checklist
- Every file listed, with one agreed source for each job
- One row per student, with the paying parent
- Tutors and pay rates written down
- Family rates checked, exceptions noted
- Open invoices, credits and prepaid lessons listed
- A read-only copy of the old spreadsheets saved
- A start date on the first day of a billing period
- One week's timetable and the first invoices compared
- Tutors told before families