Clean before you move
- One row per student, one column per fact
- The same spelling for each university and program
- Dates as dates, amounts as numbers
- One list of payments with the student and the term on each line
Move in this order
- Universities, with their terms and programs
- Students, with their university and award
- Past payments, linked to each student
That order matters because each step refers to the one before.
Check a sample by hand
Pick ten students and compare their total paid in the old file and in the new system. Differences found now are cheap.
Run one term in parallel
Keep the spreadsheet for one term while students send requests in the new system. Stop the spreadsheet when the two agree.
How this looks in ScholarDesk
The import handles universities, students and payments in that order, lets you match your columns and lists every row with a problem before adding anything.