On this page
  1. TL;DR
  2. One learner, one account number
  3. Match every day
  4. Keep one queue for the unclear ones
  5. Clear the oldest balance first
  6. Never edit a settled amount
  7. Bring banks into the same ledger
  8. How SchoolTrack does this

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

Keep reading

A school bursar and parent reviewing a written instalment plan together.

School fee arrears: collect more without the gate

School administrators reviewing a software trial together on a laptop.

How to choose a school management system in Kenya

A keypad phone showing an SMS reminder beside a smartphone showing a PDF in WhatsApp.

SMS or WhatsApp for Bills and Reminders: Which to Use When