Has your school outgrown its spreadsheets? Seven signs, and what to try first

Many Kenyan schools run well on Excel. A spreadsheet costs no cash, the bursar knows it, and nothing needs to be learned. So the honest question is not "Is Excel bad?" It is "Is the spreadsheet still doing its job, or are we doing its job for it?" This article gives seven signs you can check in an afternoon, and what to try before you spend any money.
What are the seven signs?
Read each one and answer yes or no for your own school. Do not count how many you have. Look at which ones hurt.
| Sign | What it looks like in a real school | What to try first |
|---|---|---|
| 1. One person holds it all | Only the bursar understands the file. If she is away, fee questions wait | Write a one-page guide to the file. Keep a second person trained |
| 2. Two files, two answers | The bursar's balance and the class teacher's list do not match | Choose one master file. Everyone else reads from it |
| 3. Nobody knows who changed a figure | A balance moved and nobody can say when or why | Add a "changed by, date, reason" column and use it every time |
| 4. Fee questions fill the office | Parents call or walk in to ask what they owe | Print a statement for each family at the start of term |
| 5. Report cards arrive late | Marks are retyped from books into one file, and the last week is a rush | Fix a marks deadline and one template for all teachers |
| 6. Last term cannot be found | Old versions sit in email, flash disks and phones | One folder, one name rule, one backup, once a week |
| 7. Money is hard to trace | A payment is on the bank statement but not in the file, or twice in the file | Tick every bank line against a receipt number each week |
Signs 1 to 3 are about control. Signs 4 and 5 are about time. Signs 6 and 7 are about safety. A school with only sign 6 needs a better backup habit, not new software.
Which of these can a better spreadsheet fix?
Most of them, up to a point. A single master file, a "changed by, date, reason" column, a weekly backup and a second trained person solve signs 1, 3 and 6 for a small school. They cost nothing but discipline. If your school has under 100 learners and one bursar who is rarely away, these steps may be all you need for a long time. That is an honest answer, and we would rather you hear it from us.
For a bigger school the habits are harder to keep. Ten teachers typing marks into one file will break the rules on the busiest week of the term. That is the moment a spreadsheet stops being a tool and starts being a risk.
What does the bursar being away test show?
Try this once, quietly. Choose a day and ask the head teacher to find three things without the bursar: how much one named family owes, who paid yesterday, and the total collected this term. Time it.
- If all three take under ten minutes, your records are in good shape.
- If they take an hour, or cannot be answered, you have found the real cost of the spreadsheet. It is not the file. It is the dependence on one person.
The same test works for the registrar, the exams officer and the transport officer. Write down what each of them would need to hand over.
How many learners is too many for Excel?
There is no honest single number. What matters is how many people must change the same records. Count the people who type, not the learners.
What does moving to a system actually change?
Be clear about the trade. A school system gives you records that are linked, a trail of who changed what, roles so each person sees only what they need, and a parent portal so families can see their own child's balance and attendance. It also costs money every term and needs internet, which a spreadsheet on a desktop does not.
Here is what Opero does today, checked against its own code on 17 November 2026.
- Learners and guardians are one record. You import your learner list from a spreadsheet. The import checks first and shows errors by line, and a bad row does not stop the good rows.
- Opening balances come across too. Fee balances are loaded as at a date you choose and shown as a balance brought forward. No invoices are invented.
- Each payment is recorded once per reference, and a reversal needs a written reason of at least five characters. The original row stays.
- There is a trail of who did what. Sensitive actions such as adjusting a fee, voiding an invoice, approving payroll or exporting learner data are always recorded with the person's name.
- Roles control who sees what. A teacher marks registers and enters marks for the classes they are allocated. The bursar does not see medical records.
- Parents see their own children only, in the parent portal.
Opero does not yet send SMS or WhatsApp alerts to parents, it does not send email, and it needs an internet connection. A parent opens the portal to see a balance. If you need those things today, say so when you ask for a demo.
What would it cost to find out?
The base is KSh 250 per learner per term, the same for every school. For 300 learners that is KSh 75,000 a term. Fees with M-Pesa matching is an optional add-on at KSh 12,000, KSh 20,000 or KSh 30,000 per term by school size. Setup is KSh 20,000, or KSh 0 for a school switching from an existing system. Ask us in writing whether your spreadsheet counts as an existing system, because the scope of moving your records is agreed before work starts. Opero is not the lowest-cost option on cash, because a spreadsheet costs nothing in cash. The comparison to make is cost against the hours, the errors and the calls you have today.
If you want to see price for your own size first, read how per-learner pricing works. If you are leaning towards moving, the two-week switch plan shows what happens day by day.
When should we say "not yet"?
Say not yet if you have few learners, one steady bursar, no parent complaints about balances, and report cards that go out on time. Come back to this page when two of the seven signs start to hurt. Nobody should be pushed into software they do not need.
Frequently asked questions
Is Excel good enough for a small school? Yes, often. A small school with one careful bursar can run well on a spreadsheet if there is one master file, a change column and a weekly backup.
What is the first sign a school has outgrown Excel? Usually that only one person understands the file and the school slows down when she is away. That is a risk to the records, not just an inconvenience.
Can I bring my Excel lists into Opero? Yes. Learner lists and opening fee balances can be imported from a spreadsheet. The import is checked before anything is saved, and the scope is agreed in writing first.
Does Opero work without internet? No. Opero needs an internet connection. A spreadsheet on one computer does not, and that is a fair point in its favour.
Does Opero send SMS alerts to parents? Not yet. Parents see their balance, attendance and results by signing in to the parent portal.
Next step: See Opero's price and Ask for a demo.
Sources: Opero's published price card at opero.co.ke/welcome and Opero's own product code, both checked on 17 November 2026. No outside statistics are used. Written by the Opero team.