|  In

QuickBooks to NetSuite Migration Checklist for Shopify

Checklist for migrating Shopify accounting data from QuickBooks to NetSuite

Short answer: Moving from QuickBooks to NetSuite while selling on Shopify is two projects at once: an accounting migration and a new integration. A clean migration follows five stages: decide what data moves (open balances and master data, not every old transaction), clean it in QuickBooks first, design NetSuite and the Shopify integration together, test with real months, and cut over at a period end so QuickBooks, NetSuite and Shopify never disagree about which system owns a transaction.

Seibert Consulting Group moves growing Shopify merchants and distributors off QuickBooks onto NetSuite. Use this checklist to plan your own migration.

Stage 1: Decide scope

  • [ ] Choose the go-live date, ideally the first day of a month or quarter
  • [ ] Decide how much history moves: opening balances only, summary monthly balances, or detailed transactions for the current year
  • [ ] List master data to migrate: chart of accounts, customers, vendors, items, employees
  • [ ] List open transactions: unpaid invoices, unpaid bills, open purchase orders, open sales orders
  • [ ] Decide where old detail lives after go-live (read-only QuickBooks access or an archive)

Stage 2: Clean data in QuickBooks

  • [ ] Merge duplicate customers and vendors
  • [ ] Inactivate customers, vendors and items with no recent activity
  • [ ] Fix item names and SKUs so they match Shopify products
  • [ ] Reconcile bank and credit card accounts through the cutover date
  • [ ] Clear old undeposited funds and unapplied payments
  • [ ] Review sales tax settings and liabilities

Stage 3: Design NetSuite with Shopify in mind

QuickBooks setups often hide ecommerce detail in a few summary accounts. NetSuite should be designed around how Shopify orders will post.

  • [ ] Map the QuickBooks chart of accounts to a NetSuite chart built for channels, departments or classes
  • [ ] Decide how Shopify orders post: sales orders, cash sales or invoices
  • [ ] Decide how Shopify Payments payouts, fees and refunds reconcile
  • [ ] Set up inventory locations to match warehouses, 3PLs and stores
  • [ ] Define item records, including kits and variants, to match Shopify
  • [ ] Plan customer matching between Shopify and NetSuite
  • [ ] Choose the integration approach. See Shopify NetSuite integration

Stage 4: Migrate and test

  • [ ] Import master data: accounts, customers, vendors, items
  • [ ] Import opening balances as of the cutover date
  • [ ] Import open invoices, bills and orders
  • [ ] Run the Shopify integration in a sandbox against test orders
  • [ ] Reconcile a full test month: trial balance, AR, AP, inventory and Shopify payouts
  • [ ] Train finance, operations and customer service on NetSuite

Stage 5: Cut over

  • [ ] Stop transactions in QuickBooks at the cutover date
  • [ ] Load final open balances and open transactions
  • [ ] Turn on the Shopify integration in production
  • [ ] Reconcile the first days of live orders and the first payout
  • [ ] Close the first month in NetSuite and compare to expectations
  • [ ] Keep QuickBooks read-only for reference

Common mistakes

  • Migrating every historical transaction without a reporting need. It adds cost and cleanup with little benefit.
  • Designing NetSuite like QuickBooks. A copy of an old chart of accounts wastes NetSuite’s reporting.
  • Leaving the integration until after the migration. Order posting, payouts and inventory rules shape the NetSuite design.
  • Cutting over mid-period. Split periods make the first close harder to reconcile.
  • Skipping item cleanup. Mismatched SKUs break inventory and order sync on day one.

Getting help with the migration

For how the SCG Team runs a QuickBooks to NetSuite migration, from scoping through cutover, see our QuickBooks to NetSuite migration services page.

Where Rosetta fits

Rosetta is the SCG Team’s AI-assisted migration platform for moving businesses from QuickBooks, Magento and SAP Business One to NetSuite and Shopify Plus. It builds field mappings from schema information and anonymized samples rather than sending raw customer data to an AI model, and the SCG Team reviews and reconciles every migration. See Rosetta.

Frequently asked questions

How much QuickBooks history should move to NetSuite?
Most businesses move opening balances, master data and open transactions, plus summary balances for comparison periods. Detailed history stays in QuickBooks unless reporting or audit needs it.

Can QuickBooks be migrated to NetSuite automatically?
Master data and balances can be mapped and imported with tools, but cleanup decisions, account design and reconciliation still need people who know your business.

When is the best time to switch from QuickBooks to NetSuite?
At the start of a month, quarter or fiscal year, after the prior period is reconciled in QuickBooks.

Should we set up the Shopify integration before or after migrating?
Design them together. Build and test the integration in a NetSuite sandbox during migration, then turn it on at cutover.