On this page
School fees reconciliation goes wrong in the same place every term. Money arrives on the paybill all day, and the record of who paid lives in M-Pesa messages, bank slips, a statement download and the bursar’s memory. By the time someone copies it into the fees register, a parent has typed the wrong account number, another has paid for two children in one go, and a third swears they paid last Tuesday.
A few rules make this a daily ten-minute job instead of a weekend.
One learner, one account number
Every payment needs a key that points to exactly one learner. The admission number is the best one, because it never changes and the school already uses it.
Tell parents to enter it as the account number on your paybill, and print it on every invoice, statement and fee reminder. A message such as “Pay to paybill 123456, account GA-1042” removes most of the guessing before it starts.
Avoid using the learner’s name or class as the account. Names repeat and get misspelt, and classes change every year.
Match every day
Reconciling once a month feels efficient but costs more. A parent asked about a payment from four weeks ago rarely has the message. A parent asked the same afternoon usually does.
Each day, take the payments that arrived and set each one against a learner:
| Payment shows | What to do |
|---|---|
| A valid admission number | Post the receipt to that learner |
| A number that does not exist | Hold it and call the payer |
| A name or phone number only | Hold it and look up the guardian |
| Two children in one payment | Split it with the parent’s confirmation |
The first row should be most of your payments. If it is not, the account number is not reaching parents clearly enough.
Keep one queue for the unclear ones
The worst habit in fee reconciliation is posting an unclear payment to the most likely learner. If the guess is wrong, two families now have wrong balances, and one of them will be chased for money they paid.
Keep a single list of payments that did not match, with the payer’s phone number, the amount, the reference and the date. Work through it daily. A payment leaves the list only when you know whose it is. A credit that is not fees, such as a donation or a refund from a supplier, should be set aside with a note, not left sitting in the queue.
Clear the oldest balance first
Decide once how a payment is spread, and apply it every time. The usual rule is oldest first: a payment clears last term’s arrears before this term’s fees. Within an invoice, spread it across vote heads in a fixed order, so tuition, boarding and transport each show what has been paid.
Anything above what is owed becomes credit on the learner’s account. Do not refund it in cash at the counter. Carry it to next term’s invoice, or move it to a sibling with the parent’s agreement, and record the move on both statements.
Never edit a settled amount
When a receipt turns out to be wrong, reverse it and post a new one. Do not edit the amount on the original. A reversal leaves a trail that an auditor or the board can follow. An edited figure leaves a question nobody can answer.
The same goes for invoices. Correct an invoice with a credit note or a debit note that carries a reason, not by changing the total.
Bring banks into the same ledger
Some parents pay by bank deposit or transfer. Import the bank statement into the same ledger instead of keeping a second register. Lines that name one admission number post themselves, and the rest join the same unmatched queue as M-Pesa.
Cash and cheques get a receipt at the counter, also in the same ledger. One ledger means one balance per learner, whatever the channel.
How SchoolTrack does this
SchoolTrack reads payments to your own paybill as they arrive, matches them by admission number and posts the receipt, with a confirmation SMS to the parent. Payments that do not match wait in one queue for the bursar. Each payment clears the oldest balance first across vote heads, and overpayments become credit. Bank statements import from CSV, Excel or MT940 into the same ledger.
See fees and payments for the whole workflow, or start a 30-day trial with your own fee structure.
Run your school on SchoolTrack: 30 days free, with your own learners and fees.
Start free trial