Migrating Data from Your Old System to EduSuite OS

TL;DR: Export your data from your old system, clean it up in Excel, and import it into EduSuite OS using our structured templates. Most migrations complete within 1-2 days.

---

Migration Overview

What Can Be Migrated

---

Phase 1: Export from Your Old System

Common Systems & Export Methods

Tips for Clean Exports

1. Export all student data with parent contacts.
2. Export staff list with roles and departments.
3. Export fee ledger showing outstanding balances per student.
4. Export current year attendance if available.
5. Export latest exam marks if available.

---

Phase 2: Data Cleanup

This is the most important step. Clean data = smooth migration.

Checklist

• Remove duplicates — Check for students listed twice
• Standardize names — Consistent capitalization (e.g., "Rahul Sharma" not "RAHUL sharma")
• Fix phone numbers — Add country code, remove spaces and dashes
• Standardize dates — Convert all dates to YYYY-MM-DD format
• Verify class names — Must match what you'll create in EduSuite OS
• Remove graduated students — Only import currently enrolled students
• Fill missing data — Mark required fields (name, class, parent phone)

Common Data Quality Issues

---

Phase 3: Prepare EduSuite OS

Before importing, set up the structure:

1. Academic Year — Configure terms and sessions
2. Classes & Sections — Create all grades and sections
3. Fee Heads — Define fee components (tuition, transport, etc.)
4. Roles — Set up staff roles if using custom ones

---

Phase 4: Import Data

Import in this order for best results:

Step 1: Staff First

Import staff so you can assign class teachers during student import. → Staff Import Guide

Step 2: Students

Import all students with parent details. → Student Import Guide

Step 3: Fee Assignments

After students are imported, assign fee structures:

1. Go to Finance → Assign Fees.
2. Select classes and apply fee structures.
3. For individual concessions, import a concession file.

Step 4: Outstanding Balances (Optional)

If students have outstanding fees from your old system:

1. Download the Opening Balance Template from Finance → Import.
2. Fill in student-wise outstanding amounts.
3. Upload to set correct starting balances.

Step 5: Documents (Optional)

Upload student documents in bulk:

1. Organize files in folders named by admission number.
2. Zip the folder and upload via Students → Bulk Document Upload.

---

Phase 5: Verification

Quick Verification Checklist

• Student count matches old system
• Random sample of 20 students — all details correct
• Fee structures assigned correctly
• Staff can log in and see their classes
• Outstanding balances match old records
• Class-wise student distribution looks correct

Parallel Run (Recommended)

Run both systems for 1-2 weeks:

1. Take attendance in both systems.
2. Collect fees in both systems.
3. Compare data daily to catch discrepancies.
4. Once confident, sunset the old system.

---

Migration Timeline

---

Troubleshooting

Q: My old system doesn't have an export feature. A: Copy data manually into our Excel templates. For large schools, consider hiring a data entry service for 1-2 days.

Q: Student counts don't match after import. A: Check for skipped rows in the import report. Common cause: missing required fields in some rows.

Q: Fee balances are wrong after import. A: Use the Opening Balance Import to set correct starting balances. Don't try to recreate historical transactions.

---

Need hands-on migration assistance? Our migration team can handle the entire process for you — included free with Professional and Enterprise plans.