How to stop managing school fees on a spreadsheet
Almost every school starts fee tracking in Excel or Google Sheets, and for a small school with one class per grade, it genuinely works. The trouble isn’t the spreadsheet itself — it’s that fee tracking quietly outgrows whatever holds it, and by the time it breaks, a term’s worth of records are already tangled up in it.
Where it actually breaks down
One wrong formula affects everyone below it. A single misdragged cell reference, an overwritten total, or a sort applied to one column but not the next — these are invisible until a parent disputes a balance and nobody can explain how the number was calculated.
Corrections destroy history. When a payment was entered against the wrong learner, the usual fix is to type over it. The original entry is gone, and so is any way to explain the change later.
M-Pesa, bank and cash in one sheet gets messy. Matching a list of M-Pesa messages and bank slips against expected fees, for hundreds of learners, with bursaries and instalments in between, is slow and error-prone by hand.
One file, one laptop, one point of failure. A spreadsheet on one computer is one hard-drive failure or one accidental deletion away from losing a term’s financial records.
It can’t tell a parent anything on its own. Every reminder about a balance means someone looking up who owes what and typing messages one by one — so reminders go out late, or not at all.
What proper fee management software does differently
- One ledger per learner that keeps every invoice, payment and adjustment, with the balance always calculated the same way.
- Payments split across vote heads automatically, with a receipt for every payment.
- Corrections as entries, not overwrites: a payment is reversed, transferred or reallocated, so the history stays.
- Balance reports per class or per term on demand, instead of rebuilt by hand before every meeting.
- Fee reminders in a few clicks, each SMS with that learner’s own balance — see our fee reminder SMS templates.
- Records stored online in a proper database, not in one file on one laptop.
None of this means spreadsheets are a bad tool — they’re an excellent one for the job they’re built for. Multi-year, multi-class financial records for hundreds of families just isn’t that job.
ShuleTop gives every learner their own fee ledger, splits payments across vote heads, issues receipts, and sends fee reminders with each learner’s balance to a whole class at once. See school fees management →