School Fees Reconciliation: M-Pesa, Banks & the Bursar's Ledger
M-Pesa, three bank accounts, cash at the office, and a thousand students — how bursars end the evening matching game: invoice per student, automatic payment matching, and arrears that report themselves.
Every Kenyan bursar knows the ritual: the M-Pesa statement on one screen, the bank statement printed, the fees register open, and an evening of detective work. "KIPCHOGE E — 15,000" — which of the three Kipchoges? The payment with no student name at all? The parent who paid for two siblings in one transaction? Fee reconciliation is not hard because the money is missing; it is hard because the money arrives without its paperwork.
The structure that ends the matching game
- One invoice per student per term — fees, transport, boarding, levies as line items, so a partial payment lands against something specific.
- A unique payment reference per student — admission number as the account reference on paybill payments. One instruction to parents, printed on every invoice, repeated every term.
- All channels into one ledger — M-Pesa, each bank account, and office cash posting into the same student accounts, not three parallel records.
- Same-day posting — payments matched daily, exceptions listed for the bursar; the evening ritual becomes a fifteen-minute exceptions review.
Handling the messy realities
| Reality | The undisciplined way | The disciplined way |
|---|---|---|
| Payment without a reference | Guess from the name; hope | Exceptions queue — matched by phone number history, confirmed with the parent, then posted |
| One payment, two siblings | Post to one child; argue in March | Family account linking siblings; split rules recorded once |
| Post-dated promises & bursaries | A notebook only the bursar can read | Documented payment plans and bursary awards on the student account |
| Cash at the office | Receipt book and a drawer | Receipted into the same ledger, banked intact daily — no netting expenses from fee cash |
| Refunds & transfers out | A negotiation each time | Credit balances visible; refund approvals through a workflow |
Never spend from the collection stream
Fee cash used directly for expenses — before banking — is the single practice that destroys school financial credibility. It makes reconciliation impossible, invites shortage disputes, and turns an honest office into a suspicious one. Bank everything intact; spend through the payment process.
Arrears: from ledger to collection
- Arrears by class, stream, and family — live, not compiled monthly by hand.
- Aging bands (current, 30, 60, 90+) so follow-up effort lands where recovery is likely.
- Consistent reminders — SMS at invoice, mid-term, and before exams — beat dramatic end-of-term confrontations.
- Payment plans recorded and tracked: a promise in the system is a commitment; a promise in the corridor is weather.
Fees are the revenue half of school money; the spending half — term procurement and store control — leaks just as quietly. The school ERP buyer's guide covers how both halves live in one system, with billing automation doing the matching.
End the evening matching game
Invoices per student, payments matched automatically across M-Pesa and banks, arrears reporting themselves — see it on one class of real data.
See fees reconciliation in AWRAFrequently asked questions
Parents refuse to use the admission number reference. What then?
Some always will — the goal is shrinking the exceptions queue, not eliminating it. Phone-number matching against payment history clears most unreferenced payments automatically, and the remainder is a short daily list instead of an evening ritual.
Can we handle bursaries, scholarships, and CDF payments?
Yes — third-party payers (bursary funds, sponsors, CDF) are payers on the student account like any other, with their commitments and disbursements tracked separately from parent payments. The student's balance reflects all sources honestly.
Should we stop accepting cash entirely?
Many schools push hard toward paybill-only, and it simplifies everything — but a hard ban can exclude some families. The workable middle: cash accepted at the office, receipted into the system immediately, banked intact daily. What matters is that cash follows the same ledger discipline, not the channel itself.
How do we start mid-year with messy existing balances?
Reconstruct opening balances per student from the last trusted point (usually the start of the year), verify with a statement sent to each family — disputes surface fast and get settled once — then run clean from a cut-over date. Do not migrate the mess; draw a line under it.
