QuickBooks

From QuickBooks to NetSuite.

How to move QuickBooks Online and Desktop data into NetSuite: field mapping, historical transactions, and avoiding the usual pitfalls.

Moving off QuickBooks, in the order it actually happens

QuickBooks is the most common source system we migrate from, across QuickBooks Online, Desktop, and Enterprise. The move is rarely triggered by one failure. It is triggered by accumulation: a close that takes days, a consolidation workbook only one person can run, reports that have to be rebuilt before they can be read. Everyone involved can usually list the symptoms without being asked. The reason it keeps getting deferred is that no quarter volunteers.

Once the decision is made, three questions matter more than the load itself. How much history comes across. How the chart of accounts, classes, and locations map into NetSuite's subsidiary, department, location, and class structure. And how you prove afterwards that the migrated ledger agrees with the one you left behind, at a level more convincing than a matching grand total.

Most of the detailed QuickBooks mapping guides are filed under Migration, because the same mechanics apply when the source is Xero. The reading path below pulls them back out in sequence.

The QuickBooks specifics that cause the most rework

  • Company Name vs Customer Name. QuickBooks has one field where NetSuite has two, and getting it wrong makes every downstream reference wrong with it.
  • Class and Location. Two QuickBooks dimensions, three NetSuite ones. That is a reporting decision, not a lookup table.
  • Chart of accounts. Numbering and hierarchy rarely transfer one to one, and flattening the wrong level is difficult to reverse later.
  • Payments and credits. The allocation between a payment and the invoice it settles is the first thing lost when transactions move as journal entries.
  • Historical depth. Bringing everything across is a decision with a cost attached, not a free default.

Start here

A QuickBooks to NetSuite migration tends to raise these five in this order.

  1. 1
    Outgrowing QuickBooks? When to Move to NetSuite

    Whether it is time to move at all, and what the workaround is costing while you wait.

  2. 2
    How to Scope a QuickBooks or Xero to NetSuite Migration Project

    Turning the decision into a scope that can be estimated and agreed.

  3. 3
    Mapping a QuickBooks or Xero Chart of Accounts into NetSuite

    The chart of accounts, which sets the shape of everything loaded after it.

  4. 4
    Moving to NetSuite? Get Your QuickBooks or Xero Data Mapping Right

    Field by field, including the ones with no obvious NetSuite counterpart.

  5. 5
    QuickBooks to NetSuite Reconciliation: Matching Totals Isn't Enough

    Proving the result, at record level rather than by totals alone.