School Fees Management System for Kenyan Schools: Excel vs Software

Most Kenyan schools manage fees on an Excel sheet before they ever buy software, and for a small school that is a sensible place to start. The trouble is that nobody announces the day the sheet stops coping. It shows up as a parent arguing over a balance at the gate, a bursar spending the first week of term matching M-Pesa lines by hand, or a director who cannot get a straight answer on arrears. This guide covers how to run fees well in Excel, the signs it is time to move to a school fees management system, and what that system must do in a Kenyan school.

How to set up a fees sheet that holds up

If you are staying on a spreadsheet this year, build it properly. Most fee sheets break for the same few reasons, and all of them can be avoided.

Use the admission number as the key for everything. Names get misspelt and two learners can share one. The admission number should appear in every tab, and it should be the account number parents use on the paybill.
Keep three separate tabs. One for learners (admission number, name, grade, boarding or day, transport route), one for the fee structure (what each grade owes per term, plus optional items such as lunch, transport and clubs), and one for payments, with one row per payment rather than one row per learner.
Calculate balances, never type them. The balance should be a formula: what is owed from the structure, minus the sum of payments for that admission number. Once someone overwrites a balance by hand, the sheet can no longer be trusted.
Record the transaction code. Every M-Pesa payment has a unique code. Put it in the payments tab and you can settle most disputes in seconds, and spot a payment entered twice.
Lock the formulas and limit editing. Protect the structure and balance columns, and keep a single master copy rather than versions emailed between the bursar, the principal and the director.
Back it up somewhere other than the bursar’s laptop. A stolen or failed laptop should not take the school’s fee records with it.

Our Anademy Templates include a fee collection tracker built along these lines, for schools that are not ready for software yet.

Signs the spreadsheet has reached its limit

No enrolment number marks the switch. Watch for these instead:

Reconciliation eats the start of every term. Someone downloads the paybill statement and matches lines to learners one by one, and the wrong account numbers (a missing letter, a sibling’s number, a phone number instead of an admission number) take longer than the rest put together.
Balances depend on one person. If the bursar is away, nobody else can confidently tell a parent what they owe.
Parents do not get receipts or reminders on time. Receipts are written by hand or not at all, and reminders go out late, so collection drifts into the middle of term.
The fee structure has outgrown the sheet. Different amounts for boarders and day scholars, transport by route, sibling discounts, bursaries and instalment plans. Each exception is another column or another manual adjustment.
Reports take days. The board asks for collections by grade or a list of arrears above a certain amount, and someone builds it by hand.
You cannot tell who changed what. A balance moves and there is no record of who edited it or why.

Landlords have the same problem with rent; see rent collection via M-Pesa paybill.

If three or more of these sound familiar, the sheet is now costing the school more staff time than it saves.

What a school fees management system should actually do

Plenty of software claims to manage fees. For a Kenyan school, these are the things worth checking in a demo.

Match M-Pesa payments automatically

This is the main reason to switch. The system should connect to your existing paybill or till (through Safaricom’s Daraja API, with the school’s authorisation) and post each payment against the right learner using the account number. It also needs a sensible way to deal with the payments it cannot match, such as a review queue with suggested matches, rather than quietly dropping them.

Handle your real fee structure

Fees by grade and term, boarding and day rates, transport routes, optional items, sibling discounts, bursaries and sponsorships, and instalment plans for individual families. If the vendor’s answer to any of these is “you can do that in Excel”, it is not a fees system.

Keep bank, cheque and cash in the same ledger

Not every parent pays by M-Pesa. Bank deposits, cheques and cash need to go into the same ledger, so there is one balance per learner and not two.

Send receipts and reminders by SMS

Each parent should get a receipt as soon as a payment is posted, and balance reminders on dates the school chooses. This alone cuts many of the calls and queues at the bursar’s office.

Produce the reports people ask for

Daily collections for the director, arrears lists for the bursar, collections by grade for the board, and statements for individual families. Exports to Excel are useful for your auditor.

Control access and keep an audit trail

The bursar should see fees, a class teacher should not, and every change to a balance should record who made it and when. This protects the school, and it protects the bursar when a figure is questioned.

Let you take your data with you

Ask directly: can we export all learner, fee and payment records at any time, in a usable format? The school should own its data.

Do not forget data protection

Fee records contain parents’ names, phone numbers, payment histories and sometimes bursary or sponsorship details. Schools are among the organisations that must register with the Office of the Data Protection Commissioner whatever their size, so a fees system should restrict access, keep backups and give you a clear answer on where the data is stored. Our guide on how to register with the ODPC as a data controller explains the process.

Making the move without a bad term

Switch at the start of a term, not in the middle, so opening balances are clean.
Clean the learner list first. Check that every learner has one admission number and that leavers have been removed.
Agree the opening balances with the director before importing them, and keep the final spreadsheet as a read-only record.
Tell parents early exactly what to enter as the account number, on the fee structure, on the school WhatsApp group and in an SMS.
Run both for a few weeks if that makes the bursar comfortable, then retire the spreadsheet.

Where Anademy Fees fits

Anademy Fees is our fee management system for Kenyan schools. It matches M-Pesa paybill payments to learners by admission number, puts the ones it cannot match in a review queue, handles fee structures by grade, boarding status and transport route, and sends SMS receipts and reminders. It also works as one module of the wider Anademy line, so a school can start with fees and add report cards, a parent app or transport later on the same learner record. A demo takes 30 minutes, and you leave with a written quote.

Related guides

Want help with this?

Tell us about your business in a few lines. We reply within one working day.

Ananke Digital may reply to me about this. Privacy

Prefer WhatsApp? +254 790 939 404 · We reply within one working day.

School fees management in Kenya: from Excel sheet to system