NetSuite · Migration

Leave the old ledger without losing the audit trail.

An ERP migration is a reconciliation project. Opening balances have to tie, open AR and AP have to match the sub-ledger, and history has to be available where auditors and finance will ask for it. We cut over at a period boundary with a parallel close behind us.

When this is the right engagement

  • QuickBooks or Sage is out of room
  • A legacy ERP is retiring or its vendor is
  • An acquisition brought a second ledger and the two must become one
  • A previous migration left balances that never tied
  • Auditors need history you cannot get to in the old system

What you get

  • A source review: chart of accounts, customers, vendors, items, open transactions, and what history moves
  • A mapping document for the chart of accounts and every master record, with ownership
  • Deduplication and matching rules for customers and items agreed before the first load
  • Controlled loads with reconciliation reports at each step
  • Opening balances and open AR and AP tied to the source at cutover
  • Rebuilt saved searches and reports that depended on the old structure
  • A cutover plan at a period boundary with a parallel close and rollback
  • Stabilization through the first live close

How it runs

  1. 01

    Discovery and data review

    What is in the source, what state it is in, what finance and audit need to keep.

  2. 02

    Mapping and governance

    Chart of accounts and master records, field by field, with rules agreed where they are cheap.

  3. 03

    Build and controlled load

    Master data first, then open transactions, with reconciliation after each load.

  4. 04

    Parallel close

    One period closed in both systems, differences explained.

  5. 05

    Cutover

    At a period boundary, with a go or no-go by a named person.

  6. 06

    Stabilization

    We stay through the first live close and fix what real use finds.

Questions we get

How much history moves?

Opening balances and open transactions always. Detailed history is a decision: usually a summary by period into NetSuite and a read-only archive of the old system for audit. We make the call with finance, not for them.

Work and news

Notes from NetSuite engagements.

Case studies from NetSuite engagements are being prepared for publication. The record above is public in the meantime.

Start with the stuck point

What should the ledger know that it doesn’t?

Bring the handoff, reconciliation, or report that keeps resurfacing. We will tell you whether it is a NetSuite problem, a data problem, or a systems problem, and what to do about it.