A term’s fees are three lists, not one
The spreadsheet usually breaks in the same place: it holds one number per learner, and a term’s fees are not one number.
- The fee per grade, per term. A Grade 4 day scholar and a Grade 11 boarder are not on the same tariff, and neither are the same tariff as last year.
- The extras. Levies, exam fees, building fund, uniforms, transport, trips — some compulsory, some optional, most of them raised at a different time from the term’s fees.
- The credits. A payment against a learner, a discount, a bursary, a refund, a bounced cheque reversed. Every one of these changes the balance.
A ledger that carries one figure per learner can be made to look right. It cannot be made to be right, because it has nowhere to put the second and third lists.
The rule that keeps it true: receipt on the day
The single practice that separates a fee ledger that agrees with the bank from one that does not is this — money is receipted against the learner’s account on the day it arrives, by the person who received it, with a number.
Everything painful about fee reconciliation is a symptom of not doing that. Cash collected on a Thursday and posted on a Monday has been reconciled from memory twice: once against the diary of who came in, and once against the deposit slip. Both times it can be wrong, and neither time is anybody able to prove which learner paid.
Mobile money makes this sharper, not easier: a term’s fees arrive as a stream of individual transfers, some with a reference and some without, and a reference that does not name the learner is a payment you will be chasing for a fortnight.
The four things a term-end needs to answer
- What was billed — by grade, by class, by learner.
- What was received, receipted and posted against the right learner.
- What is still owed, by learner, by class and by grade — the arrears list, built before the term ends rather than after it.
- What each parent can be shown: a statement of their own child’s account, itemised, as at a date.
If any of those four takes an afternoon to produce, the school is running on the spreadsheet’s terms, not its own.
What the law allows on arrears
Both markets have a route, and both reward doing it in order.
In Zimbabwe, schools may pursue outstanding fees and levies from parents in default, including through registered debt collectors. The recognised sequence is a paper one: a letter of demand setting out the basis of the claim, then a reminder inviting the parent to attend the school to discuss it with the bursar — before it escalates. A written ledger of what is owed and when it fell due is what makes any of that possible; without it, the first letter cannot even be written properly.
In South Africa, public school fees are set by the School Governing Body, and the SGB is also where an exemption is decided. A parent whose annual fees would come to 10% or more of household income may qualify for a full exemption, and schools are required to tell parents how to apply rather than wait to be asked. A fee system that flags a family in arrears for a month or more and prompts the exemption conversation is doing the school a legal favour, not just a financial one.
What the school system does with it
The school system built for this holds the fee structure per grade and per term, the categories the school actually charges, and a ledger per learner — charges on one side, payments on the other, in date order. Payments are receipted as they arrive and posted against the right learner, so the balance a parent is told is the balance the office is holding.
Arrears by learner, by class and by grade come out as a report rather than an afternoon’s work, and a statement can be given to a parent as at any date.