Reconciling M-Pesa school fees: seven checks a bursar should make every week
Most bursars do not lose money to theft. They lose hours, and sometimes shillings, to small mismatches: a payment credited to the wrong child, the same M-Pesa code entered twice, or a parent who paid but whose name is on no list. This article gives a simple weekly routine, and shows which parts a system can do for you and which parts still need a person.
What does reconciliation actually mean?
Reconciliation is a comparison between two lists. The first list is what the bank or M-Pesa says came in. The second is what your fee records say was received and from whom. When the two lists agree, you are reconciled. When they do not, the difference must be explained, not ignored.
A good routine is boring. It happens on the same day each week, it follows the same steps, and the result is written down and signed.
Which seven checks should I make each week?
| Check | What it catches | Where Opero helps |
|---|---|---|
| 1. Repeated M-Pesa codes | The same payment entered twice, so a family looks paid up | Opero records a payment once per reference. A repeat is reported as already recorded and nothing changes |
| 2. Missing or wrong admission number | Money that nobody can place | Bank import matches only an exact admission number. Unmatched lines are handed back with their narration, not guessed |
| 3. Money paid before the invoice | A payment that looks lost | It stays on the account as credit, so it is never lost, and can be allocated when the invoice is issued |
| 4. Wrong amounts and overpayments | A balance that does not make sense | Each payment shows against the invoices it was allocated to, and any excess stays as credit |
| 5. One payment for two children | A single code split unfairly | Record one payment per child, each with its own reference |
| 6. Reversed or refunded payments | A receipt that is no longer true | A reversal needs a reason. The payment row is kept, and the invoices go back to owing what they owed |
| 7. Total against the statement | A missing or extra line | Fee statements and the arrears list show each family's side. Add up the week's payments to compare with the statement |
How do I handle each check in practice?
Repeated codes. Sort your list by M-Pesa code. A code that appears twice is either a duplicate entry or two different parents quoting the same code. Check both before you delete anything.
Missing admission numbers. Parents often write the learner's name, a nickname or only the class. Keep a short "unplaced" list and call the parent the same day. Ask parents to write the admission number in the account field every time. A matching system can only be as exact as the number it is given. Opero deliberately does not match "42" to learner 0042, because forty families may have a 42 somewhere.
Payments before invoices. In many schools parents pay before the term is invoiced. This money must not vanish. In Opero it stays on the learner's account as credit, and it can be allocated to the invoice once that is issued.
Two children, one payment. Ask the parent how they want it split. Record one payment per child. Opero will not record the same reference twice, so give each part its own reference, for example the M-Pesa code followed by -A and -B.
Reversals. If a payment is wrong, do not delete the line. Reverse it and write why. A receipt that can be deleted is a receipt nobody can trust, and an auditor or Board member will ask you for the trail.
The weekly total. Add up the credits on the statement for the week. Then add up the payments recorded in your fee records for the same dates. If the difference is not zero, find the lines, one by one.
How does Opero bring in M-Pesa and bank payments?
There are two routes, and they work differently.
1. The parent pays from the portal. A parent opens the parent portal and taps pay. Safaricom prompts their phone. The payment is recorded only when Safaricom's own message reaches Opero with a receipt number, never because the parent's screen says it worked. A message that arrives twice cannot credit a family twice. This route is switched on school by school, once your school's own Daraja payment details are connected.
2. You import a bank statement. Download the statement as a CSV file from internet banking. Opero finds the date, narration and credit columns by name, and refuses the file if it cannot find all three. Each credit whose narration contains one of your school's exact admission numbers becomes a payment. Re-importing the same file records nothing twice. Anything that does not match comes back to you for placing by hand. A single import accepts up to 2,000 lines.
Opero reads the bank statement format, so check before you rely on it that your own export has those three columns. Payments that arrive at the counter or by cash are recorded by hand against the learner, with a reference.
What should I do on Monday morning?
- Export or download last week's statement.
- Import it, or record the payments by hand.
- Work through the unmatched list and place each line.
- Open the arrears list and look for families that paid but still show as owing.
- Compare your weekly total with the statement total and write the result down.
If the numbers do not agree, stop and find the difference before the next week's payments arrive.
What does Opero not do yet?
Honestly: Opero does not send SMS or WhatsApp receipts to parents yet. A parent sees their balance in the portal. Your school's own Opero invoice is settled by hand. Fee reconciliation is part of the Fees and M-Pesa add-on, which costs KSh 12,000, KSh 20,000 or KSh 30,000 per term by school size.
Frequently asked questions
What is school fee reconciliation? It is the weekly check that what the bank or M-Pesa received matches what your fee records show, learner by learner, with every difference explained.
How often should a school reconcile M-Pesa fees? Weekly is a good minimum, and daily at the start of term when most payments arrive. The routine matters more than the exact day.
What if a parent pays with the wrong admission number? Do not guess. Put the line on an unplaced list, confirm with the parent, then record it against the right learner. Opero hands back lines it cannot match with certainty rather than crediting the wrong child.
Can a payment be deleted in Opero? No. A payment can be reversed with a written reason, and the record stays. Invoices go back to owing what they owed.
Does Opero import M-Pesa statements directly? Today it imports bank statement files with date, narration and credit columns, and takes M-Pesa payments made from the parent portal once your school's payment details are connected. Ask us to check your own export first.
Next step: See Opero's price and Ask for a demo.
Sources: Opero's published price card at opero.co.ke/welcome, checked 16 November 2026. The matching rules above were checked against Opero's own code on 16 November 2026. Written by the Opero team.