For US controllers and project leads who want every record, balance and tax total to arrive in NetSuite and tie out.
Last reviewed: 21 November 2026. Product details reflect this review date. Availability and behavior can vary by account, role and release.
For a NetSuite data migration US finance teams can sign off, load master records first. Then load open transactions and use a clearing account to reconcile them to opening balances. Check year to date 1099 payments, W-9 data, sales tax exemptions, vendor bank details and fixed asset tax books before launch.
Key takeaways
Data migration is the work of moving the records your business still needs from your current system into NetSuite, in a form your team can use from day one. For most US companies that means four groups of data.
| Data group | Examples | How it usually arrives |
|---|---|---|
| Setup and master data | Chart of accounts, departments, classes, locations, customers, vendors, items, employees | CSV imports with External IDs |
| Open transactions | Unpaid invoices, unpaid bills, open sales and purchase orders | One record per open item |
| Balances | Trial balance at cutover, inventory quantities and costs, fixed asset values | Journal entry import, inventory adjustment, asset import |
| History | Prior year detail for reporting or audit | Summary journals, or kept in an archive you can search |
You rarely need every old transaction. Agree with your auditor and tax adviser what history must be reachable, and where it will live.
NetSuite builds each record on the ones before it. A vendor bill needs its vendor and any referenced accounts or items to exist first.
Our post on NetSuite external ID design covers how to choose those keys so reloads stay safe.
Assign an owner to each tax and payment check before cutover.
In this example, use a temporary equity account called a clearing account. It offsets the opening invoices, bills and inventory adjustments. Have your controller test the posting accounts and tax handling in a sandbox before running the load.
The opening trial balance journal then posts every remaining account and offsets clearing. When the loads are right, clearing ends at zero.
A hypothetical Texas distributor goes live on 1 July 2026. It loads 186 open invoices worth $640,000, 92 open bills worth $318,500 and inventory worth $905,000.
Clearing now holds a credit of $1,226,500. The opening trial balance journal posts all other accounts and debits clearing $1,226,500 in place of the receivables, payables and inventory lines. Total debits and credits in clearing are $1,545,000 each, leaving a zero balance.
Then run the sign off tests, with a named owner for each.
Plan at least two mock loads in a sandbox before the real one. Our post on NetSuite mock migration defects shows how to log and close what they find. CuriousRubik's NetSuite data migration team can map your records, run the mock loads and prepare the reconciliation pack for sign off. See how we work with NetSuite customers in the United States.
A January launch simplifies reporting if you record every payment for the new calendar year in NetSuite. If the project needs a later launch, keep the original payment dates and agree who will combine the two systems’ totals. Check the combined figures against your payment records before filing.
Work backward from the reports you need for month end. For example, monthly summary journals can support comparisons when the underlying detail is available in a searchable archive. Agree on retention with your tax adviser and auditor, then test whether your team can retrieve a sample old transaction and its supporting documents.
If you use balance only migration entries, carry the full unpaid amount, including any unpaid tax. Keep the original invoice available for the tax breakdown. Ask your controller and tax adviser to approve the posting approach. Then test customer statements and sales tax reports to catch omitted receivables or duplicate tax.
The controller signs off balances and aging, the AP lead signs off vendors and 1099 data, and the tax lead signs off sales tax setup. Each signs against a named test with the numbers attached. A single sign off from the project team is weaker evidence if questions come up at year end.
How to load unpaid invoices and bills so collections and payments continue on day one.
The vendor fields, account mapping and checks behind a clean 1099 filing.
How to bring assets and their depreciation history across and reconcile them.