Most schools in Pakistan run on Excel for years: one sheet for students, another for fee, a third for salaries, and a notebook for everything else. The fear of changing is always the same: "Who will type all of this again?" Nobody has to. Your Excel sheets already hold most of what the software needs. This guide shows how to clean them, what to bring in first, and how to check that every rupee of fee and every balance came across correctly.
Why moving feels hard (and why it isn't)
The hard part is not the software. It is that school data in Excel is usually spread over many files, written a little differently in each, with totals and notes mixed into the rows. Once the sheets are tidy, bringing them in takes hours, not weeks.
Step 1: Pick a starting date
Choose one date when the software takes over, ideally the 1st of a month or the start of a session. Everything before that date comes in as a balance (what each family owes, cash in hand, what you owe suppliers). Everything after it is entered in the software only.
Step 2: Clean your sheets
- One row per student (or staff member, or bill). No blank rows in between.
- One heading row at the top. No merged cells, no titles above the headings.
- Remove total rows and notes from inside the data.
- Dates written the same way everywhere, e.g. 15/04/2026.
- CNIC and B-Form numbers as 13 digits, with or without dashes, but the same throughout.
- Class names written one way: "Class 5" everywhere, not "5th" in one place and "Grade 5" in another.
- Amounts as plain numbers: 3500, not "Rs. 3,500/-".
Step 3: Bring things in the right order
Some lists depend on others. A student needs a class, a fee plan needs fee heads, a supplier bill needs the supplier and the item. This order avoids "not found" errors:
| Order | What | From your Excel |
|---|---|---|
| 1 | Classes & sections, subjects | Your class list |
| 2 | Fee heads and fee structure | Tuition, admission, exam, transport fee per class |
| 3 | Students | Admission register / student list |
| 4 | Previous balances | What each student owes on the starting date |
| 5 | Staff, salaries and advances | Staff list and salary sheet |
| 6 | Accounts opening balances | Cash in hand, bank balances |
| 7 | Suppliers, items and opening stock | Book / uniform shop records |
| 8 | Transport and library | Van list, routes, book register |
Older history (old receipts, expenses, supplier bills) is optional. Many schools bring in only the current session.
Step 4: Check before you stop using Excel
After each import, compare two or three numbers with your sheet. If they match, the rest will too.
- Number of students in each class and section
- Total dues on the starting date, the same as your Excel total
- Cash in hand and each bank balance
- Number of staff and the total monthly salary
- Trial balance: debits and credits equal
Common mistakes
- Two students with the same name and no admission number: give each an admission number first.
- The same family written with different father names (Muhammad / M. / Mohammad): fix the spelling so siblings are found.
- Old students who left still in the active list: mark them as left before importing.
- Balances that are really advance fee typed as dues, or the other way round.
- Bringing in history you will never look at. Start clean and keep the old files as an archive.
How Aurex Campus helps
Aurex Campus has an Excel import on each screen where schools usually have old data. Each import works the same way:
- A sample file to download, with the right headings and drop-down lists for classes, accounts, items and other choices
- Headings found even when yours are written a little differently
- Every row checked and shown before it is added, with the reason for any row that has a problem
- The same row twice in a file is caught, and lists such as classes, fee heads and vehicles skip what is already there
- Fee receipts, expenses, supplier bills and payments booked to the accounts exactly as if typed on the screen
- Most imports can be undone as a whole within 7 days, from Import history
You can bring in:
- Students and fees: students (new, and updating details), classes and sections, subjects, fee heads, fee structure, fee plans and concessions, previous balances, fee challans, fee receipts, inquiries
- Staff: new staff, salaries and details, salary components, departments, advances, staff attendance, salary payments
- Accounts: chart of accounts, opening balances, expenses, other payments and receipts, transfers between cash and bank
- Inventory and purchases: items, categories, units, stores, departments, opening stock, suppliers, supplier bills, supplier payments
- Transport and library: vehicles, routes and stops, students on transport, vehicle expenses, library books
- Exams and attendance: exam marks, the question bank, student attendance
Once the data is in, fee challans, payroll and school accounts all work from the same records, so there is nothing left to keep in Excel.
Plans start at Rs 4,000 a month for up to 200 students, with every feature and unlimited staff users.
Questions
Do I have to type my students again?
No. Download the sample student file, copy your columns into it, and upload it. Each row is checked before it is added.
What if some rows in my Excel have mistakes?
Rows with a problem are shown with the reason (for example a class that does not exist or a date in the wrong format). The other rows can be added, and you fix and upload the rest.
Can I bring in last year's fee receipts?
Yes, but most schools only need each student's balance on the starting date. Old receipts are useful if parents often ask for their history.
What if I import the wrong file?
Most imports (fee receipts, expenses, supplier bills and others) can be undone within 7 days from Import history, and the entries they made are reversed. New students and staff are checked for numbers already in use before they are added.
How long does the move take?
For a school of a few hundred students, cleaning the sheets usually takes the longest. The imports themselves take minutes each.
