The Complete NetSuite Data Migration Checklist: From Legacy ERP to Go-Live

Data migration is the graveyard of ERP projects. The software is configured, the workflows are mapped, user training is complete, and then the migration fails. Records are duplicated, historical balances do not reconcile, custom fields are mapped to the wrong columns, and the go-live date slips by three months. We have seen it happen to companies well into a six-figure implementation only to stumble at the last mile.

At TechCloudPro, data migration is not an afterthought, it is a workstream that starts in week one of every implementation. This checklist distills the process we use across migrations from QuickBooks, Sage, SAP Business One, Microsoft Dynamics, and custom legacy systems into NetSuite.

Migration Phases

Every successful migration follows five phases. Skipping any of them creates risk that compounds as you approach go-live.

Phase 1: Discovery and Scoping (Weeks 1-2)

Before touching any data, answer these questions:

• What data exists in the legacy system? (Full entity list: customers, vendors, items, transactions, custom records)
• What data needs to migrate to NetSuite? Not everything should. Legacy data that no one has accessed in two years may not justify the migration effort.
• What is the cutover strategy? Big bang (migrate everything at once) or phased (master data first, then open transactions, then historical)?
• What are the data quality issues? Duplicate customers, inconsistent naming conventions, missing required fields, orphaned records?
• What are the regulatory retention requirements? Some industries require 7+ years of transaction history to be accessible.

Phase 2: Data Mapping (Weeks 2-4)

Map every field from the source system to the NetSuite target. This is the most tedious and most important step. For each entity type, document:

• Source field name, data type, and sample values
• NetSuite target field (standard or custom), data type, and validation rules
• Transformation logic (concatenation, splitting, lookup tables, default values)
• Required vs optional fields in NetSuite, a missing required field will reject the entire record

Pay special attention to these commonly problematic mappings:

• Chart of accounts: Legacy account numbers rarely map 1:1 to NetSuite account structures. Plan for account consolidation and renumbering.
• Item types: NetSuite distinguishes between inventory items, non-inventory items, service items, kits, assemblies, and more. Your legacy system may use a single "product" entity. Every item must be classified correctly.
• Addresses: NetSuite's address structure is specific (addressee, attention, address lines 1-3, city, state, zip, country). Legacy systems often store addresses as free-text blobs that need parsing.
• Multi-currency: If migrating to OneWorld, every transaction needs a currency and exchange rate. Ensure your historical transactions have this data, or define a default rate policy.

Phase 3: Data Cleansing (Weeks 3-6)

Clean data in the source system before migration, not during. Common cleansing tasks:

• Deduplication: Merge duplicate customer and vendor records. We typically find 5-15% duplication rates in legacy systems. Use fuzzy matching on name, email, phone, and address.
• Standardization: Normalize state names (CA vs California vs Calif.), phone formats, and address formatting. NetSuite's validation rules will reject non-standard entries.
• Completeness: Fill in required fields that are empty in the legacy system. NetSuite will not import a customer without a name or a vendor without a currency.
• Archival: Move inactive records, closed transactions, and obsolete items to an archive rather than migrating them. Less data = faster migration = fewer errors.

Phase 4: Migration Execution (Weeks 5-8)

Execute the migration in a specific order. NetSuite has dependency chains, you cannot import invoices without customers, or purchase orders without vendors and items.

1. Master data first: Chart of accounts → Currencies → Tax codes → Locations → Departments → Classes
2. Entity records: Customers → Vendors → Employees → Partners
3. Item records: Item categories → Items (with pricing, costs, preferred vendors)
4. Opening balances: GL journal entries establishing starting balances at cutover date
5. Open transactions: Open invoices, open purchase orders, open sales orders (only transactions that need to be fulfilled or collected post go-live)
6. Historical transactions: Optional, closed transactions for reporting purposes. Import as custom records or journal summaries if detailed transaction history is not needed.

Phase 5: Validation and Reconciliation (Weeks 7-10)

The most critical phase. Every migrated dataset must be validated:

• Record count validation: Source record count must match NetSuite record count for each entity type. Any discrepancy must be explained (skipped duplicates, filtered inactive records).
• Balance reconciliation: Trial balance in the legacy system must match the trial balance in NetSuite at the cutover date. Reconcile to the penny.
• Spot-check sampling: Randomly sample 50-100 records per entity type and verify all fields migrated correctly. Pay attention to special characters, long text fields, and multi-line addresses.
• Functional testing: Create a test invoice, receive a test payment, run a test purchase order through the full cycle. Ensure migrated master data works correctly in live transactions.

CSV Import Best Practices

NetSuite's CSV Import tool is the workhorse for most migrations. Key tips:

• Use NetSuite's CSV templates (Setup → Import/Export → Download CSV Templates) as your starting point. Do not invent your own column headers.
• Run every import in a sandbox environment first. Never import directly to production on the first attempt.
• Use External IDs from your legacy system as the key field. This enables re-importing (updating) records without creating duplicates.
• Break large imports into batches of 5,000-10,000 records. NetSuite's import tool can time out on very large files.
• Log every import, timestamp, file name, record count, success count, error count. You will need this audit trail.

Rollback Planning

Every migration plan must include a rollback plan. If the migration fails or produces unacceptable results, you need a path back to the legacy system:

• Take a full NetSuite sandbox snapshot before migration begins
• Keep the legacy system operational (read-only) for 30-90 days post go-live
• Define rollback triggers: what specific conditions would cause you to revert?
• Document the rollback procedure step by step, and test it at least once

Migration rule of thumb: If you are not running at least three full trial migrations in sandbox before the production cutover, you are not ready. The first trial will fail. The second will be messy. The third should be clean. If it is not, you are not ready for go-live.

TechCloudPro's NetSuite implementation team treats data migration as a first-class workstream, not an implementation afterthought. We have migrated data from the major legacy ERP systems into NetSuite and know where the pitfalls hide. Schedule a migration planning session and we will assess your source data, define the migration strategy, and build a realistic timeline that protects your go-live date.