Data migration
Data migration is the planned transfer of records from an old system or spreadsheets into a new system, including cleaning, mapping, loading and checking.
What it means
It usually covers masters such as customers, items and ledgers, plus opening balances and sometimes open orders and recent transactions. Teams decide what to bring, clean it, load it into a test setup, compare totals, then repeat for the final cutover. History older than a stated cut-off is often archived instead of moved.
Example
A 40-person engineering firm in Rajkot moves to a new system on 1 April. It loads 900 items, 650 parties and opening stock worth ₹58 lakh, and the totals match the old books to the rupee before staff start working.
Records and checks
- Record what was moved, when, by whom and the counts and totals loaded.
- Verify opening balances, stock quantity and open items against the old system.
- The accountant and the stores head sign the reconciliation before go-live.
Common mistakes
- Moving all old data, including dead records, and carrying every past mistake.
- Running the final load without a rehearsal.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →