Decide what history you actually need
The most important early decision is how much history to bring. Loading every transaction from the past decade is slow, expensive, and rarely useful. Most companies migrate opening balances as of a clean cutoff date, open transactions such as unpaid invoices and bills, master data such as customers, vendors, and items, and perhaps summarized prior-period results for comparison. Keep the old QuickBooks file in read-only form for audit reference.
Agree the cutoff with your accountants. A month-end or quarter-end cutover simplifies reconciliation because the balances at that date are final.
Rebuild the chart of accounts rather than copying it
QuickBooks charts tend to accumulate duplicates and accounts used for workarounds. Migration is the chance to redesign: group accounts logically, remove obsolete ones, and use NetSuite segments such as department, class, and location to carry analysis that used to be crammed into account names. A shorter chart with richer segments produces better reports with less effort.
- Map each old account to a new one and have your accountant sign the mapping.
- Move analytic detail, like product line or branch, into segments instead of separate accounts.
- Decide the numbering scheme before loading so it does not change later.
Customers, vendors, items and inventory
Clean master data before it moves. Merge duplicate customers, standardize addresses and payment terms, and remove vendors you have not used in years. Items deserve special attention: decide on item types, units of measure, and costing method. QuickBooks inventory is usually simpler than NetSuite's, so use the migration to define locations, reorder points, and how kits or assemblies will work.
Inventory quantities and values should be counted or reconciled at cutover. The opening inventory value must match the ledger balance, or the first month's cost of goods will not make sense.
Open balances, sales tax and payroll
Open receivables and payables are loaded as individual open items so aging reports work from day one. Review sales tax setup carefully, because QuickBooks tax codes may not map one-to-one to NetSuite's tax structure, particularly with provincial or state taxes. Payroll is typically handled by a dedicated payroll provider, with summarized journals posted to the ledger, so confirm the accounts and mapping before the first live payroll.
Implementation and integration services →Bank feeds, reconciliation and integrations
Plan how bank transactions will arrive and be reconciled, whether through bank feeds, imported statements, or a payments provider. Reconcile bank accounts in both systems at the cutover date so the opening cash balance is certain. If other tools, such as e-commerce platforms or expense apps, connect to QuickBooks today, list them early. Each will need a new connection to NetSuite.
NetSuite integration services →Decisions to settle before you start
- Cutover date. Choose a period end with the least activity and enough time to reconcile.
- History scope. Decide whether to load prior-year summaries or detailed transactions, and where the old data will be kept.
- Segments. Agree the analysis dimensions you want in reports before designing the chart.
- Responsibility. Name who validates each data set, since accountants and operations each own a piece.
A realistic first 90 days
- Days 1 to 30. Design the chart, segments, and item structure, and clean the source data in QuickBooks.
- Days 31 to 60. Run a trial load into a test account, reconcile balances, and train the finance team on daily tasks.
- Days 61 to 90. Do a second trial load, finalize the cutover plan, and go live at a period end with a defined fallback.
Mistakes that make migrations painful
- Copying the old chart. It carries over every workaround. Redesign it.
- Skipping the trial load. A first load into production almost always reveals data problems. Do at least one rehearsal.
- Forgetting attachments and notes. Decide which supporting documents must move and how they will be linked.
- No fallback plan. Keep QuickBooks available until the first close in NetSuite is complete and reconciled.
