Moving school fees and results from Excel to one connected system.

Fees and results are where most schools feel the strain first. They involve every pupil, they repeat every term, and parents notice every mistake. The good news is that both can move out of spreadsheets in a planned way, without disrupting the term.

1. Clean the student list first

Everything else depends on it. Aim for one row per pupil, with a unique student ID, full name, class, and the name and phone number of a parent or guardian. Remove duplicates and pupils who have left.

Choose one student ID format, such as STU-0142, and use it everywhere: on receipts, report cards and payment references. Never reuse an ID when a pupil leaves.

2. Write down the fee structure

List the fees for each class and term, and every optional item: transport, feeding, uniforms, excursions. Write down the rules people carry in their heads, such as sibling discounts, scholarships, instalment plans and what happens to late payments. A system can only apply rules that someone has written down.

3. Decide how parents will pay, and what they quote

Matching payments is the biggest time cost for most bursars. Ask parents to quote the student ID in every transfer, and print it on every invoice. Some payment providers can issue a dedicated account number for each pupil or family, which makes matching automatic.

However careful you are, some payments will arrive without a reference. Plan who reviews those, and how quickly, rather than leaving them for the end of term.

4. Agree how results are computed

Before any software is involved, agree the grading scheme in writing: continuous assessment and exam weights, grade boundaries, whether positions are shown, and how comments are written. Then agree the timetable: when teachers enter scores, who checks them, and who approves the results before parents see them.

5. Run both side by side for one cycle

For the first collection period or the first set of results, keep the spreadsheet running alongside the new system and compare the totals. Differences are useful: they usually reveal a rule nobody had written down. Once the two agree, retire the spreadsheet.

6. Train by role

The bursar, teachers, the head teacher and the admin office each need different screens. Train each group on their own tasks, give them a one-page guide, and nominate one person who knows the system well enough to help colleagues.

Protecting pupils' data

Student records are personal data about children, and the Nigeria Data Protection Act 2023 gives children's data extra protection. Ask a data protection adviser what consent your school needs from parents or guardians. In practice:

• Give each staff member access only to what their role needs.
• Stop sharing student lists and results in WhatsApp groups or by email attachment.
• Keep a record of who changed fees, scores or student details.
• Back up regularly, and test that the backup can be restored.
• Decide how long records are kept after a pupil leaves.
• Check with a data protection professional whether your school needs to register with the Nigeria Data Protection Commission.

This is general guidance, not legal advice.

A short checklist

• One clean student list, with unique IDs
• The fee structure and its rules, written down
• A payment reference rule parents can follow
• The grading scheme and results timetable, agreed
• A plan for running both systems for one cycle
• Training for each role