Excel vs a School Management System in Kenya: When to Switch

Walk into many Kenyan schools and the records look much the same: a shared Excel file on the secretary's laptop, attendance sent by WhatsApp in the morning, a fee ledger behind the bursar's desk, and report cards typed in Word at the end of term.

It works. Until it doesn't.

This is not an argument that spreadsheets are bad, or that every school needs a school management system tomorrow. They are flexible, familiar and free. The question is where they stop being the right tool, and how to tell whether your school has reached that point.

What a spreadsheet does well

Be fair to Excel. It is good at:

• Quick, one-off calculations
• A single person keeping a small list
• Prototyping a fee structure before you finalise it
• Cheap, immediate set-up

If your school has a few dozen learners and one person does all the record keeping, a well-kept spreadsheet may be enough.

Where it starts to break

The trouble starts when more people, more data and more deadlines come into play.

1. Many people, one file

When several people need to edit the same workbook, you get copies: students_final.xlsx, students_final_v2.xlsx, students_FINAL_use_this.xlsx. Nobody is sure which is current. One accidental save over the wrong file can erase a term of work.

2. No history

A spreadsheet rarely tells you who changed a number and when. If a parent disputes a fee balance, you cannot easily show how it was calculated.

3. Fee tracking by hand

Each M-Pesa payment has to be read from a message or statement and typed against the right learner. Mistakes creep in:

• A payment is received but not recorded.
• A payment is recorded against the wrong child.
• One transaction covers two siblings.
• A balance rolls over from a previous term and nobody remembers why.

The more learners you have, the more often this happens. We cover how to do it better in our guide to fee management and M-Pesa reconciliation.

4. Report cards that depend on copy and paste

Marks live in a teacher's gradebook, then in a class sheet, then in a report template. Each copy is a chance for error. Different teachers use different templates, and the headteacher spends the final days of term checking for mistakes.

CBC adds another layer: every mark must be placed into the right band, from EE1 to BE2. By hand, boundary cases (75 versus 74, 58 versus 57) are easy to get wrong. Our CBC grading guide sets out the ranges.

5. No single view for the headteacher

To answer "how much have we collected this term?" or "which class has the lowest attendance?", someone has to pull data from several files. The answer arrives late, if at all.

6. Weak access control

Anyone who can open the file can see everything: fee balances, staff details, learner information. For a school holding children's data, that is a risk.

An illustrative term

To make this concrete, here is a hypothetical example of how things can go wrong in a mid-sized school. It is not a real school or a statistic, just a realistic pattern.

• Week 1: the learner list is rebuilt because last term's file was overwritten.
• Midterm: the bursar follows up on arrears. Some parents say they paid, and she cannot find the payments quickly in the ledger.
• End of term: report cards are typed in different templates. Several errors are found after printing, and some are reprinted.
• Opening day: a parent asks for their balance. Two versions of the file exist, and the wrong one is opened.

None of this means the staff are careless. It means the tool is being asked to do more than it was designed for.

How to work out what it costs you

Do not take anyone's numbers on trust, including ours. Measure your own. For one term, record:

1. Hours spent on fee reconciliation and follow-up. Ask the bursar to estimate per week.
2. Hours spent consolidating attendance.
3. Hours spent producing report cards, including checking and reprinting.
4. Fee disputes and amounts written off because records could not settle them.
5. Time headteachers spend asking for summaries that a system could show instantly.

Multiply staff hours by their approximate hourly pay, add the written-off amounts, and compare the total with what a system would cost. If it is small, you may not need to switch yet. If it is large, you have your answer.

What changes with a school system

A proper school management system addresses the points above:

• One shared record instead of many copies.
• A history of changes, so you can see who changed what.
• Fees tied to learners, with receipts and balances by term.
• Marks entered once, with CBC bands applied automatically and report cards generated from them.
• A headteacher view of attendance, fees and results.
• Role-based access, so people see what they need.

It is not magic. You still need accurate data entry and clear policies. But it removes the copy-and-paste steps where most errors occur.

Questions to ask before switching

Not every system is right for every school. Before you commit, check:

• Is CBC built in? Does it apply the EE1 to BE2 bands and print a report card you would send home?
• How does M-Pesa work? Does it match payments to learners automatically, or does someone still log each one?
• Can you export your data at any time?
• Can your own staff use it? Ask your least technical teacher to try it.
• Who do you call for help?

Our full buyer's checklist has 15 questions to work through.

Making the move

Switching is easier when you prepare:

1. Clean your learner list and fee structures first.
2. Start at the beginning of a term.
3. Keep the old spreadsheets as an archive.
4. Train staff in short sessions, role by role.

DiraSchool

DiraSchool is a school management system built for Kenyan CBC schools. It brings learner records, attendance, CBC report cards, fees with M-Pesa Paybill reconciliation and a parent portal into one place. It is free to get started, with no credit card required. For pricing questions, contact our support team.

Create your school's account and try it with one class before deciding.

Summary

• Spreadsheets are fine for very small schools and quick calculations.
• They struggle with shared editing, history, fees, CBC report cards and access control.
• Measure what your current system costs in staff hours and lost income before you decide.
• If you switch, prepare your data and start at the beginning of a term.

Related: Next, read what a school management system is and how to choose the best one in Kenya.