QuickBooks Online

NS90: Migrate:

QuickBooks Online to NetSuite

Outgrown QuickBooks Online? Bring every QBO company into one NetSuite.

NS90: Migrate connects to each QuickBooks Online company through the Intuit API, profiles it before scoping, and consolidates one or 40+ companies into NetSuite subsidiaries with trial balances that tie by period.

Plan my QuickBooks Online migration

See Support Data

Source

QuickBooks Online (Simple Start through Advanced)

EXTRACTION

Intuit Accounting API via MHI's registered app. No CSV exports

DATA DOMAINS

18 supported

DELIVERED

7 QBO migrations, from 1 to 40+ companies each

Depth

Options 3 and 4

WHY NOW

40+

QuickBooks Online companies profiled for one client in about 90 minutes

Each entity in QuickBooks Online is a separate QBO company, so growing groups end up running many companies side by side, with flat classes and locations and intercompany entries booked by hand. NetSuite OneWorld consolidates those companies into subsidiaries of one account. Our automated assessment tells you what you have before anyone writes a scope.

Source: MHI NS90 assessment, 37 companies, about 600K transactions

// Supported Data Domains

18 QuickBooks Online data domains, mapped field by field to NetSuite

Every domain has a proven field-level mapping from QuickBooks Online to NetSuite, with the legacy source object shown so your team can check coverage against its own data.

Master data

Transaction

Balances & files

Master data

Customers, vendors, items and the records every transaction depends on.

Customer

Contact

Customer · Vendor

Fixed asset

Item · Account

Vendor

Item

Item

Transaction

Sales, purchasing, banking and inventory transactions, with the reference numbers your team knows.

Invoice

Credit memo

CreditMemo

Customer deposit

Deposit

Vendor bill

Bill

Vendor payment

BillPayment

Inventory adjustment

Item quantities

Estimate / sales order

Estimate

Customer payment

Payment

Purchase order

PurchaseOrder

Vendor credit

VendorCredit

Journal entry

JournalEntry

Balances & files

Period balances for reconciliation, and the documents attached to your records.

Trial balance

TrialBalance report

File attachments

Attachable

Choose your depth

Bring as much QuickBooks Online history as your business needs

Trial balances are part of every option. Pick how much transaction detail lives in NetSuite and how much stays reportable in NetSuite Analytics Warehouse.

Option 1

Balances

Trial balances only

Monthly trial balances by account and segment loaded to NetSuite. Fastest path to a clean opening position.

Available

Option 2

Balances + drill-down

Trial balances in NetSuite, detail in NSAW

Trial balances in NetSuite with transaction-level drill-down to legacy detail in NetSuite Analytics Warehouse.

Available

Option 3

Open items + history

Masters and open transactions in NetSuite, history in NSAW

Customers, vendors, items and open AR/AP/orders in NetSuite. Every closed transaction stays reportable in NSAW.

Chosen on 5 QuickBooks Online projects

Option 4

Full history

Open and closed transactions in NetSuite

The years you choose of closed and open transactions in NetSuite, with automated trial-balance true-up by period.

Chosen on 2 QuickBooks Online projects

What we’ve learned on QuickBooks Online projects

The QuickBooks Online details that make or break a migration

These come from real NS90 QuickBooks Online projects. Each is already built into our standard QuickBooks Online mapping, so you don’t discover it at UAT.

Consent once per company, then automate

Each QBO company authorizes MHI's Intuit app once. Tokens are stored in a vault and refreshed automatically, so repeat and delta extracts need no client effort.

Assess before you scope

A read-only assessment counts accounts, customers, vendors and transactions per company. Scope and price then rest on real volumes, not guesses.

Inactive records matter

The API skips inactive accounts, customers and items unless asked. Historical transactions still point at them, so we extract them explicitly.

Keep payments applied

CSV exports lose the link between a payment and the invoices it paid. We extract through the API and generate stable line keys so applications, credits and deposits land correctly.

Data the API doesn't expose

Some fields, like legacy sales rep and certain custom fields, aren't in the API. We identify them during assessment and bring them in as side inputs.

Estimates, jobs and automated tax

QBO has no sales order, nests jobs as sub-customers, and calculates tax automatically. Our QBO-specific mapping handles each one.

Built for high volumes

Single domains above 900,000 rows are streamed in chunks, then merged from per-company landing tables into one harmonized set.

Balances straight from QBO

Trial balances come from the QBO trial balance report by period and accounting method, and are trued up automatically against loaded history.

Tokens that stay valid

Intuit refresh tokens can rotate. Our vault writes the new token back automatically, so connections don't silently expire mid-project.

Check the realm

Every connection is checked against the company's own profile, so data from one company can never land under another.

Accounts and lists first

Some QBO extractions need account and list data added before transactions will map. We extract every list before any transaction.

Mandatory NetSuite fields

NetSuite requirements such as customer IDs and inventory asset/COGS accounts are filled by rule during transformation, not by hand.

A golden QBO mapping

Every QBO project starts from our standard field-level mapping, so results are consistent from one client to the next.

Other systems alongside QBO

QBO is often one source among several (job-shop ERPs, construction or distribution systems). NS90 lands them together and reconciles them to one chart of accounts.

Scope only what you'll use

We migrate only the domains your team will use in NetSuite. Everything else stays reportable in NSAW, which keeps cost and timeline down.

How NS90: Migrate works

From QuickBooks Online to a reconciled NetSuite in six steps

Every step runs on NS90 Migrate, MHI’s cloud-native migration engine on NSIP and NSAW. It handles extraction, landing, harmonization, parallel loading and trial-balance validation as repeatable jobs, so each rehearsal and the final delta pull run the same way.