Moving from QuickBooks to NetSuite
There is no one-click route from QuickBooks or Xero to NetSuite. Data goes in through NetSuite's CSV Import Assistant, with a limit of 25,000 records per file, or through web services for larger moves. Oracle advises against importing lots of historical transactions and recommends opening balances plus open items instead.
- Import tool
- CSV Import Assistant
- Limit
- 25,000 records per file
- History
- Keep it light
Ways to switch
CSV Import Assistant. NetSuite calls it the best way to move small and medium-sized data sets from other applications. Each file can hold up to 25,000 records.
Web services. For large migrations, NetSuite recommends its web services rather than CSV files.
Opening balances and open items. Import account balances and open invoices and bills, and keep the old system for history. Oracle warns that storage can be limited.
What moves over
History: Oracle advises against importing lots of historical transactions, because storage can be limited.
Open items: Make sure open receivables and payables are not duplicated in the account balances imported later.
Tools for the move
Common questions
How do I move my QuickBooks data to NetSuite?+
Export lists and balances to CSV and load them with NetSuite's CSV Import Assistant, up to 25,000 records per file, or use web services for large volumes.
Should I move all my QuickBooks history to NetSuite?+
Oracle advises against importing lots of historical transactions. Most moves bring opening balances and open items, and keep the old system for history.
More switching guides
Part of Accountio’s accounting technology coverage · Switching guides
