The options available for getting your data into NetSuite include (from least to most complicated):
- Type your data into NetSuite
- Import a spreadsheet into NetSuite (csv import)
- 3rd party tools
- ODBC (extra module at additional cost)
- Web Services (write code to import your data)
Quickbooks information can be imported into NetSuite. You options from least difficult to most difficult are:
- Import opening balances only.
- Import summary journal entries to provide accurate historical information to whatever level or granularity you require.
- Import financial transactions from Quickbooks.
**We strongly recommend options 1 or 2. In general, it is better to choose a cut over date and view information prior to the cut over date in Quickbooks. Option three will require engagement of a consultant (various NetSuite partners provide migration services, too).
In general we recommend that grantees use one of two methods:
- CSV Import. There is no cost for this capability.
- Celigo SmartClient. There is a cost for this capability. http://celigo.com/products/netsuite/excel-smartclient/
Suggested Sequence
- Classifications: Department/Class/Location
- Chart of Accounts
- Employees
- Import Relationships(Entities)
- Import Activities and Communications
- Import ERP Transaction Data
Best Practices:
- Import Customer records first
- Import Contact records second
- Consider values associated with Global Subscription Status field - A marketing automation consideration
- Designate one address as the primary address when importing multiple addresses
Preparing for Data Import
- Review existing data and scrub data
- Determine import options
- Determine how to map from existing application into Netsuite
- Create a .csv template
- Run test imports
- Resolve errors
- Plan for data migration
- Import data prior to the "go-live" event
- Resolve any errors
- Review data validity