Why your fees spreadsheet keeps breaking, and what to use instead
Every class business starts on a spreadsheet. Here is why it stops scaling, and the attendance-led approach that replaces it without retyping a thing.
A spreadsheet is the honest first tool of almost every class business. It is free, it is flexible, and on day one it does everything you need. The trouble is that it keeps doing almost everything you need — right up until the month it quietly costs you a whole evening and a parent’s goodwill.
If your fees spreadsheet keeps breaking, it is not because you built it badly. It is because a grid of cells is the wrong shape for the job.
Where spreadsheets crack
- Two registers that must agree, but can’t. Attendance is one sheet (or a notebook); payments are another. Every month you reconcile them by hand, and every gap between them is a potential dispute.
- No memory of why. A cell says a student owes $X. It does not say which classes that covers, or which were missed. So when a parent asks, you are reconstructing the answer from scratch.
- Formulas that rot. One inserted row, one dragged formula, one shared copy edited by two people, and the totals are subtly wrong — usually discovered at the worst possible moment.
- It does not scale with people. The moment a second teacher needs to mark attendance, a spreadsheet becomes a permissions-and-versions nightmare.
What actually replaces it
The fix is not a bigger spreadsheet. It is changing the unit you track from money owed to classes attended, and letting the money follow automatically.
In an attendance-led system:
- The only thing anyone records each day is who showed up.
- Each attended class counts toward that student’s cycle.
- When the cycle completes, the fee falls due — calculated, explained, and tied to the exact classes delivered.
Attendance and fees can never disagree, because the fee is derived from attendance. There is no second sheet to reconcile and no formula to rot.
You don’t have to retype anything
The biggest fear in leaving a spreadsheet is losing the work already in it. You shouldn’t have to rebuild a thing. A good migration starts from your existing tracker — your students, your classes, your history — and brings it across, so going live feels like an upgrade, not a fresh start.
That is precisely how we onboard centres onto ShowUp: we begin with the spreadsheet you already keep, set it up around your words and rhythm, and show you exactly what was understood before anything switches on. If month-end has turned into spreadsheet surgery, see how it works — or bring your spreadsheet across.
From S$19 a month · 60-day money-back promise