Moving your school from Excel to a school ERP: a practical checklist

Most schools don’t move off spreadsheets because the software is hard. They put it off because the move itself feels hard: years of registers, fee sheets and staff files that have to go somewhere. It gets much easier once you know what to gather and in what order.

What to gather first

You don’t need everything on day one. You need the records that everything else hangs on.

• Students: name, class and section, admission number, date of birth, gender, and at least one guardian’s name and mobile number.
• Fee structures: every fee head (tuition, transport, annual charges), how much, for which classes, and when each instalment is due.
• What each family still owes: the balance carried over from before the switch, per student.
• Concessions: sibling discounts, staff wards, scholarships — who gets what.
• Staff: name, designation, date of joining, mobile number, and — if you’ll run payroll — salary break-up and bank details.

Everything else (library books, transport routes, past exam results) can follow once the school is running on the new system.

Clean it up before it goes in

An hour of tidying saves a week of corrections. Look for:

1. One row per student. No merged cells, no blank rows between sections, no totals in the middle of the list.
2. The same name for the same class. “7-A”, “VII A” and “Class 7 A” are three different classes to a computer. Pick one way.
3. Mobile numbers with ten digits. Remove spaces, leading zeros and “+91” so every number looks the same. Parents sign in and receive messages on this number, so it matters.
4. Dates in one format. Day, month, year — and check nobody typed 12/05 meaning 5 December.
5. Admission numbers that are unique. Two students with the same number will cause trouble in every report after.

Do it in this order

The order matters because later steps depend on earlier ones.

1. The academic session — April to March for most schools.
2. Classes and sections, named the way you tidied them above.
3. Fee structures and instalments.
4. Students, imported from your cleaned spreadsheet, straight into their sections.
5. Opening balances, so what families already owe carries over.
6. Staff, and then payroll settings if you use them.
7. A check: pick five families you know well and compare what the new system says they owe with your old sheet.

When to switch

The cleanest moment is the start of a session, when new fee structures begin anyway. But you don’t have to wait: switching mid-year works well as long as opening balances are right. What doesn’t work is running both side by side for months — one of them is always out of date.

Bring your staff along

The office staff who kept the spreadsheets know where the exceptions are: the family who pays quarterly, the teacher on a special allowance. Involve them in the clean-up and they’ll trust the new system from the start.

Then tell parents what is changing — how they’ll sign in, where they’ll see fees and attendance — before the first message arrives on their phone.

How we handle it at CampusMonkey

When a school joins CampusMonkey, our team does this set-up with them: we take the spreadsheets you already have, set up the session, classes and fee structures, bring in your students and check the balances with you before anyone else sees them. If you’d like to see how that would look for your school, book a demo.