← All articles

Five fee numbers a head teacher should look at every Monday

Opero demo video: every learner accounted for on the bus
For more information, watch the Opero demo (opens YouTube). No login is needed to watch it.

"How do we know who has paid?" is the question a head teacher asks most, and the answer is often "ask the bursar." That works until the board asks, a parent disputes a balance, or the bursar is away. This article gives you five numbers to read once a week, in order, and the one action each number points to. You can do this with a spreadsheet. We also show where Opero puts the same numbers.

VideoWatch Monday, Again: a 2-minute school story
Opero: fees by M-Pesa, attendance, report cards, the school bus and parents in one system, hosted in Kenya. KSh 250 per learner per term. Watch on YouTube.
A short cartoon, not a real school.

What are the five numbers?

NumberWhat it means in plain wordsWhat to do when it looks wrong
1. InvoicedEverything the school has billed for the term or yearCheck every class was billed. A missing class is missing income
2. CollectedMoney that has been recorded and applied to invoicesAsk which payments are not yet recorded. Ask for the date of the last entry
3. OutstandingWhat families still owe after payments and any bursariesAsk for the list of families, largest first
4. OverdueThe part of outstanding that is past its due dateThese are the calls to make this week
5. Older than 90 daysThe overdue part that has been owing three months or moreDecide each case with the board: plan, waiver or hold

Read them top to bottom. If number 1 is wrong, every other number is wrong. If number 2 is stale, you will chase families who have already paid, which is the quickest way to lose their trust.

Why does the order matter?

Because each number depends on the one above it. Collected only means something against invoiced. Overdue is only a slice of outstanding. And the age of the debt comes last because it is the next question, never the first. A head who starts with "who is the worst defaulter?" often starts chasing before checking that the records are complete.

What is the collection rate, and how do I use it?

The collection rate is collected divided by what families were actually expected to pay. Here is a worked example. These are example figures to show the arithmetic, not a real school.

  • Invoiced: KSh 12,000,000
  • Bursaries and discounts granted: KSh 600,000
  • Expected to be paid: 12,000,000 minus 600,000 = KSh 11,400,000
  • Collected so far: KSh 8,550,000
  • Collection rate: 8,550,000 divided by 11,400,000 = 75 percent
  • Outstanding: 11,400,000 minus 8,550,000 = KSh 2,850,000

Notice that the bursaries come off before the rate is worked out. A school that grants many bursaries is not a poor collector. Compare the rate with the same week last term, not with another school. Different schools bill and collect on different calendars.

What should I ask the bursar on Monday?

Three short questions are enough.

  1. When was the last payment entered, and are any payments waiting to be entered?
  2. How many families are overdue, and how many calls were made last week?
  3. Is any family over 90 days, and has a plan been written down for it?

If the bursar answers from a screen or a printed list rather than from memory, you have a system. If the answers come from memory, you have the "one person" risk, and you will meet it again the day she is away.

How do I get these numbers from a spreadsheet?

Keep one row per invoice with these columns: learner, class, amount invoiced, amount paid, due date. Then four totals do the work.

  • Invoiced: add up the amount invoiced column.
  • Collected: add up the amount paid column.
  • Outstanding: invoiced minus collected, minus any bursaries.
  • Overdue: add up the unpaid amount only for rows whose due date is before today.

For the age of the debt, make three more totals by how long past the due date each unpaid row is: under 30 days, 30 to 89 days, 90 days and more. It is a lot of work for one person each week, and it breaks the moment two people edit the file. That is why many schools stop looking at these numbers, which is the real cost.

Where does Opero show them?

With the Fees and M-Pesa add-on, the Finance page shows the same sequence in the same order, checked in Opero's own code on 17 November 2026.

  • Invoiced, Collected and Outstanding at the top, with the collection rate, and a separate figure for bursaries and discounts so that the numbers can be reconciled.
  • Overdue, counted only for invoices that are past their due date.
  • Who owes, a list of families in arrears, worst first. Overdue amounts come first, then the largest. Each row shows the learner, the class and the guardian's name and phone number so the bursar can call. The page shows the 50 most pressing and tells you how many there are in all.
  • How old is the debt, in four groups: not yet due or under 30 days, 30 to 59, 60 to 89, and 90 days and over.
  • Where the money came from, by channel, and a list of recent payments.
  • A selector for the academic year.

Learners who have left are included in the list, because a family that withdrew a child owing fees still owes them. Money the school has waived through a bursary is not counted as outstanding. A reversed bursary is counted again.

What does Opero not do here?

Be fair to your bursar: these numbers are only as good as what has been recorded. If cash payments at the office are not entered, they are missing from the screen. Opero does not send reminders to families. The list is for people to phone. SMS and WhatsApp alerts are not live yet. Opero also needs an internet connection, and the Finance page is for staff who hold the finance report right, which the head teacher, the bursar and the school administrator have out of the box.

M-Pesa payments reach the screen only where the school's M-Pesa details are connected and switched on, which is done school by school. Bank statement lines can be imported from a spreadsheet file and matched by admission number. For the weekly checks behind that, read seven weekly checks for M-Pesa and bank fee payments.

What does it cost?

The Fees and M-Pesa add-on is KSh 12,000, KSh 20,000 or KSh 30,000 per term by school size, on top of the base KSh 250 per learner per term. For a school of 600 learners, base plus Fees is KSh 170,000 a term. Setup is KSh 20,000, or KSh 0 for a school switching from an existing system.

Frequently asked questions

How often should a head teacher check fee numbers? Once a week is enough for most schools, at a fixed time, for example Monday morning. Check daily only in the two weeks after term opens.

What is a good collection rate? We will not give a single figure, because it depends on your fee dates and families. Compare against the same week in previous terms and track the trend.

Why does the arrears list include children who have left? Because the family still owes the money. Hiding withdrawn learners is one way a school loses fees without noticing.

Can Opero send reminders to families who owe? Not yet. Opero lists who owes and how to reach them, and the office makes the calls. Automatic SMS and WhatsApp alerts are not live.

Who can see the Finance page? Staff whose role includes the finance report right. Out of the box that is the head teacher, the bursar and the school administrator. A school can change this.

Next step: See Opero's price and Ask for a demo.

Sources: Opero's published price card at opero.co.ke/welcome and Opero's own product code, checked on 17 November 2026. The worked example uses made-up figures and no outside statistics. Written by the Opero team.

Five fee numbers a head teacher should look at every Monday | Opero