Browse Business Software Categories

A
B
C
D
E
F
H
I
M
N
P
R
S
W
Close  

Accounting

ERP

QuickBooks to NetSuite Migration: What Moves, What Doesn't and How Long It Takes

Sherman Hsieh
Share This Post!
Published
QuickBooks to NetSuite Migration: What Moves, What Doesn’t and How Long It Takes

Last updated: October 7, 2026 · Independent guide · We do not sell rankings or coverage.

In a QuickBooks to NetSuite migration, you normally move your master data (customers, vendors, items and a redesigned chart of accounts), your open AR and AP as individual transactions, and a trial balance as of a period-end go-live date. Full transaction history usually stays in QuickBooks as a read-only archive, because Oracle’s own documentation advises against importing large volumes of historical transactions. Published partner figures put a small or mid-sized project at roughly 12 weeks to 6 months, and partner services alone at about $25,000 to $75,000 for a small business.

Before you start

  • NetSuite edition. Confirm whether you are buying standard NetSuite or NetSuite OneWorld (multiple subsidiaries). The opening balance procedure differs: in OneWorld you must create and save accounts first, then enter balances from the Opening Balances page (Oracle, no date shown).
  • Administrator access and permissions. You need the Enable Features permission (or the Administrator role), the Import CSV File permission and Edit level on Manage Accounting Periods (Enable Features, no date shown; Import Assistant, no date shown; Manage Accounting Periods, no date shown).
  • A test environment. A NetSuite sandbox is an isolated copy of your production account with the same settings and data (Oracle, no date shown). Ask your sales rep whether one is included in your quote, because the documentation does not say.
  • Your QuickBooks exports. In QuickBooks Online, go to Settings > Tools > Export data, which produces reports and lists as Excel files in one .zip (Intuit, updated August 3, 2026). In QuickBooks Desktop for Windows, open Reports > Reports Center, run each report and use the Excel dropdown (Intuit, updated August 3, 2026).

What moves and what does not

The table reflects Oracle’s data migration guidance and the record types its Import Assistant supports. Get your partner’s scope in writing.

QuickBooks data Usually migrated? How it lands in NetSuite
Chart of accounts Yes, after redesign Chart of Accounts Import, with departments, classes and locations replacing sub-accounts
Customers, vendors, items Yes, active records after cleanup Customers Only, Vendors and Items imports
Open AR invoices and open AP bills Yes, one record per open document Invoice Import and Vendor Bill Import
General ledger balances Yes, as of go-live Opening Balances page, which generates journal entries
Inventory on hand Yes, if you use inventory Inventory Adjustment Import
Closed transaction history Usually no, or summarized Optional monthly summary journals; detail stays in a QuickBooks archive
Bank feeds, payroll links, attachments No Set up again in NetSuite

Oracle’s Data Migrations Setup guidance says directly: “Don’t import lots of historical transactions – your storage may be limited” (Oracle, no date shown). For OneWorld, Oracle recommends journaling in the balances of all balance sheet accounts as of a period end instead of loading a complete history (Oracle, no date shown). EPIQ Infotech, a NetSuite partner, describes a middle ground of monthly summary journals for one to three prior years, and notes that bank feeds, payroll integrations and attachments are set up fresh (EPIQ Infotech, July 14, 2026).

Step 1: Decide who implements, and get the scope priced

You can buy implementation from Oracle NetSuite directly or from a partner. NetSuite sells preconfigured, fixed-fee SuiteSuccess packages, says its own team guides customers through them, and describes SuiteSuccess as a “customer lifecycle methodology” (NetSuite, SuiteSuccess, no date shown). Solution Providers “sell and deliver NetSuite, perform implementation and provide ongoing support.” Alliance Partners “work in concert with NetSuite sales team to provide consulting, integration and implementation services” (NetSuite, Become a Partner, no date shown). Our NetSuite implementation partners guide compares them.

Oracle does not publish license or SuiteSuccess prices. Some partners publish their own estimates:

Source Published figure Timeline stated
GURUS Solutions (NetSuite partner), May 21, 2026 Small business services $25,000 to $75,000; entry “Activation” tier $40,000 to $60,000 (200 to 250 hours) Activation tier 12 to 16 weeks
Epiq (NetSuite partner), no date shown $25,000 to $150,000+, fixed-price quote after scoping 3 to 6 months
Vendr (procurement platform), February 2026 Median annual NetSuite contract $74,817 across 1,513 purchases; data migration $10,000 to $100,000+ About 3 to 6 months for small deployments

Sources: GURUS Solutions, Epiq, Vendr. Vendr sells software negotiation services (Vendr, no date shown). See also our ERP implementation cost breakdown.

Ask the statement of work to name the data in scope: years of summary history, open orders, number of trial loads and who reconciles.

Step 2: Enable features and set up accounting periods

Turn on the features your chart of accounts design depends on before you import anything, at Setup > Company > Enable Features (Oracle, no date shown).

Next, create periods at Setup > Accounting > Manage G/L > Manage Accounting Periods and click Set Up Full Year. Oracle calls generating a full year the best practice and notes that every day must belong to an accounting period (Oracle, no date shown). If you load summary history, create prior fiscal years too; a period created before an existing locked period is saved as locked (Oracle, no date shown).

Step 3: Rebuild the chart of accounts

QuickBooks charts often use long lists of sub-accounts to report by location or product line. In NetSuite, those dimensions usually belong in departments, classes and locations, so the account list gets shorter. Load the result with the Chart of Accounts Import at Setup > Import/Export > Import CSV Records (Import Assistant, no date shown; Supported Record Types, no date shown). Keep a mapping file from each QuickBooks account to its NetSuite account and segments for balances, history and auditors.

Step 4: Import master data

Import customers, vendors and items using the same Import Assistant. Oracle limits each upload to 25,000 records and recommends starting with a test import of a couple of records, splitting large jobs and running imports off-peak (Select a File for Import, no date shown; Data Migrations Setup, no date shown). Give every record an external ID that matches the QuickBooks name or number. The Vendor Bill Import must reference each vendor by internal or external ID rather than by name (Oracle, no date shown).

Merge duplicate customers and deactivate dormant vendors before you load; Oracle advises scrubbing data before import (Oracle, no date shown).

Step 5: Pick the cutover date and load open AR and AP

Choose a month-end go-live, preferably a quarter-end or fiscal year-end outside your busiest season, so the opening trial balance matches a closed QuickBooks period. Close that month in QuickBooks, then export the open AR aging, open AP aging and trial balance as of that date.

Import each open customer invoice with the Invoice Import and each unpaid bill with the Vendor Bill Import. Oracle notes that vendor bills “are typically used to bring in open payables” (Oracle, no date shown). Importing each document, rather than one AR balance, lets your team apply payments against the original invoice numbers from day one. If you also import payments, load invoices first with unique IDs so payments can reference them (Oracle, no date shown).

Imported transactions post like ones entered by hand; a vendor bill with inventory items affects inventory (Oracle, no date shown). Map open invoice and bill lines to a temporary conversion clearing account rather than to revenue or expense, so the imports do not restate income.

Step 6: Enter the opening trial balance

Go to Setup > Accounting > Setup Tasks > Enter Opening Balances, select the posting period (and subsidiary in OneWorld), and enter a debit or credit for each account. NetSuite shows any difference in the Out of Balance By field and generates journal entries when you save (Oracle, no date shown).

Oracle warns that when you import open AP and AR, the amounts must not be duplicated in the account balances you import later (Oracle, no date shown). The illustration below shows one way to handle it.

Illustration (amounts invented) Accounts receivable Conversion clearing
Import 140 open invoices totaling $412,500 Debit $412,500 Credit $412,500
Opening balances: post the QuickBooks AR total of $412,500 to clearing, not to AR No entry Debit $412,500
Result after both steps $412,500 (ties to QuickBooks aging) $0

Apply the same pattern to AP and inventory. A clearing account left with a balance points to a missing or duplicated document. To change an opening balance after saving, find the journal through Transactions > Management > Search Transactions and edit it directly (Oracle, no date shown).

Step 7: Load inventory, reconcile and go live

Load quantities on hand with the Inventory Adjustment Import, which needs an adjustment account and a date (Oracle, no date shown). Point the adjustment account at the conversion clearing account and confirm the inventory value matches the QuickBooks balance sheet.

Compare the NetSuite trial balance and AR and AP agings with QuickBooks line by line, in at least two sandbox trial loads before production. List outstanding checks and deposits, because your first NetSuite bank reconciliation must clear them.

Keep QuickBooks available for audits. After you cancel a single QuickBooks Online subscription, you get read-only access for one year, then must resubscribe (Intuit, updated September 25, 2026). The IRS generally expects records for 3 years, 7 years for bad debt or worthless securities claims, and employment tax records for at least 4 years (IRS, last reviewed June 30, 2026).

Common mistakes and how to fix them

  • Duplicated AR or AP. AR shows double the aging total. Reverse the trial balance line and route it through clearing.
  • Mid-month cutover. Opening balances match no closed QuickBooks report. Move go-live to a month-end.
  • Payments that will not apply. Payments link to invoices only through internal or external ID, not transaction numbers (Oracle, no date shown).
  • Oversized journals. Import supports 10,000 lines, but Oracle reports poor performance above 1,000 (Oracle, no date shown). Split by month.
  • Old sub-accounts copied over. Departments and classes go unused. Fix this before balances post.

Limitations of the native tools

The Import Assistant handles small to medium data sets. Oracle recommends web services for large or ongoing migrations and for record types CSV import does not support (Oracle, no date shown). The documentation we reviewed describes no QuickBooks-specific connector, so each file needs mapping in Excel or a script. CSV import also cannot completely delete sublist data (Oracle, no date shown), so a bad load is often easier to reload in a fresh sandbox than to repair.

When companies add a third-party tool

Companies add tools for large files, transaction-level history or a lack of staff. Dancing Numbers sells QuickBooks Desktop conversion software and services that support NetSuite (Dancing Numbers, November 17, 2025). Integration platforms such as Celigo, Boomi and Jitterbit are also named by partners for migration work (GSI, October 18, 2024). None removes the need to redesign the chart and reconcile. If you are still weighing whether to move, our NetSuite cost and fit analysis sets out who it suits.

How we researched this

We read Oracle NetSuite’s help topics on opening balances, accounting periods and CSV import, Intuit’s help articles and IRS retention guidance. We reviewed the top-ranking guides from Zone & Co, GSI, EPIQ Infotech and Dancing Numbers, and used only published prices. We checked every source on October 7, 2026.

Frequently asked questions

Can I bring all my QuickBooks history into NetSuite?

You can, but Oracle advises against importing large volumes of historical transactions because account storage may be limited. A common approach is monthly summary journals for one to three prior years, with detail kept in a read-only QuickBooks archive.

How long does a QuickBooks to NetSuite migration take?

Published partner figures range from 12 to 16 weeks for an entry-level project (GURUS Solutions) to 3 to 6 months for a standard one (Epiq and Vendr).

What is the best date to cut over from QuickBooks?

A month-end, ideally a quarter-end or fiscal year-end outside your peak season. The opening trial balance then matches a closed QuickBooks period that auditors can tie out.

Should I use Oracle or a partner for implementation?

Both work. Oracle sells fixed-fee SuiteSuccess packages guided by its own team, and Solution Providers and Alliance Partners also implement. Compare the data migration scope in each statement of work, not only the price.

How much does a QuickBooks to NetSuite migration cost?

Oracle does not publish prices. Partners publish service ranges of about $25,000 to $75,000 for a small business, and Vendr reports a median annual NetSuite contract of $74,817 as of February 2026, before implementation.

Sources

Related guides

Sherman Hsieh

CEO & Editor-in-Chief, Business-Software.com
Independent analysis of enterprise software — ERP, CRM and more
Sherman Hsieh is the founder, CEO, and editor-in-chief of Business-Software.com. He leads the site's independent, buyer-focused coverage of ERP, CRM, and other business systems, including vendor-neutral comparisons, pricing analysis, and implementation guidance. Before founding Business-Software.com, Sherman was an executive at Siebel ...

Users Who Read This Article Also Read