Carrying fee arrears into a new school system: pick a cut-off date and bring the balances across

The bursar's biggest fear in switching systems is simple: will we lose who owes what? A school can survive a late report card. It cannot survive losing its debtors list. This article shows how to carry arrears across in a way you can defend to a parent, the board and an auditor.
What is a cut-off date, and why do you need one?
The cut-off date is the day the old record stops and the new one starts. Everything up to that day is in the old records. Everything after is in the new system.
Without a cut-off date, a payment can be counted twice or not at all. A parent pays on the Friday, the old system is closed on the Monday, and nobody is sure which one holds the money. Pick a quiet day, such as the last day of the term or a day in the long holiday.
What exactly crosses over?
Only the net position on the cut-off date. That means what the family owes after every payment and every discount received up to that day. The old payment history does not cross over. Keep the old exports in a safe place for questions.
| Item | Crosses into Opero? |
|---|---|
| Net balance owed on the cut-off date | Yes, as an opening balance |
| A family that paid ahead (credit) | Yes, as a credit note, shown as a negative balance |
| Old invoices and receipts, line by line | No, keep the old exports |
| Learners who have left the school | Not matched, see below |
| A family with a zero balance | Leave the row out |
How does Opero bring the balances across?
This needs the Fees add-on and the right to adjust fees, which the head teacher and the bursar hold out of the box. The steps follow the screen called Bring fee balances across.
- Import the learners first. A balance is matched to a child by admission number. A number that matches nobody is reported, not guessed.
- Prepare a sheet with an admission number and a balance for each learner. A template can be downloaded. The headings are read flexibly, so "Adm No", "Bal B/F", "Arrears" and "Outstanding" all work. A name and a note column are optional.
- Upload an Excel or CSV file. Only the first sheet in the file is read.
- Type where the balances came from, up to 60 characters. Put the old system and the cut-off date. This text is printed on the family's statement.
- Check the file. Nothing is written yet. Opero shows the total it would bring across, a sample, and every row with an error.
- Compare that total with the total on your old report. If they differ, stop and find out why.
- Import, and confirm. Each balance becomes its own audited entry on the family's account.
What does the checker refuse?
It refuses the sheet if there is no column of balances or no column of admission numbers. It refuses a row when:
- the admission number is missing, or it appears twice in the sheet;
- no learner on the roll has that admission number;
- the balance is missing, is not an amount, or is zero.
A negative balance is allowed and means the family has paid ahead. The total in the preview nets those credits off.
What does the parent see?
A line on the statement that reads "Balance brought forward from" followed by your text, for example the old system and the date. Opero does not make a fake invoice. A parent can see what the figure is and where it came from.
Where do people go wrong?
- No cut-off date, so payments are counted twice or not at all.
- Learners who have left. Opero matches only learners still on the roll, so a leaver who owes fees is reported as not found. Keep a separate list for them and decide how the school will chase them.
- Importing the same file twice. We found nothing in the code that stops it. Import once, then write down the date and the total.
- Trusting the total without comparing it with the old report. That one check catches most mistakes.
A worked example with made-up figures
Three learners on a sheet. ADM 101 owes 12,500. ADM 102 has paid ahead and shows as minus 3,000. ADM 103 owes nothing, so the row is left out. The preview shows two valid rows and a net total of 9,500. The bursar compares it with the old report. If the old report shows 12,500 owed and 3,000 of credit, the net is 9,500 and the two agree. If it does not agree, nothing has been written yet, so the bursar can fix the sheet.
For the whole plan around this step, read the two-week plan for switching in the long holiday.
Frequently asked questions
Can Opero bring across old receipts as well as balances? No. It brings across the net balance only. Keep the old receipts and invoices as exports.
What if a parent disputes the balance brought forward? The statement shows where it came from, and the entry has a reason and the name of the person who imported it. Check it against the old records for the cut-off date.
Do we need to bring balances for past years separately? The import takes one balance per learner. If your old records split arrears by year, add them up, and use the note column to say what the figure includes.
Is moving our old records free? Setup is KSh 0 for a school switching from an existing system. The scope of moving your old records is agreed in writing before work starts.
Can a teacher run this import? No. It needs the right to adjust fees. That is held by the head teacher and the bursar by default.
Next step: See Opero's price and Ask for a demo.
Sources: Opero's own product code, checked on 18 November 2026 (balance import screen, checker and adjustment types), and Opero's published price card at opero.co.ke/welcome. The figures in the example are made up. No outside law or statistic is quoted. Written by the Opero team.