# ERP Migration: A Finance Leader's Playbook (2026)

Woosung Chun

CFO

Woosung Chun is the CFO of DualEntry with experience in corporate finance, accounting, strategy, and acquisitions. He previously grew from scratch and led the M&A and Finance teams at Benitago, where he completed more than 12 acquisitions in 2 years. He graduated with a BS from NYU Stern. At DualEntry, Woosung writes about AI in accounting, revenue recognition, foreign currency accounting, hedge accounting, and ERP modernization for finance teams navigating complex, multi-entity environments.

Learn about our [editorial policies](/content/legal/editorial-guidelines/index.html).

Last updated

October 16, 2026

Reviewed by

Do San (Justin) Myung

Do San (Justin) Myung is Expert Accountant at DualEntry with 20+ years of hands-on experience managing general ledgers, financial close processes, and ERP implementations for mid-market and enterprise companies. As a former Consulting CFO and Controller, he has personally overseen month-end closes, SOX compliance programs, and multi-entity consolidations across technology, manufacturing, and services industries. Justin specializes in transforming manual accounting workflows into automated, AI-driven processes.

## TL;DR

**Migration succeeds or fails on the finance work, not the IT**: Opening balances that reconcile, the right depth of GL history, and a parallel close that ties out matter far more than the extract-map-cleanse-validate mechanics everyone focuses on.

**Know who owns what data**: IT and implementers usually own master data, transactional data, and open AR/AP. GL history and opening balances get handed to finance - and that's exactly where audit and close risk lives.

**Opening balances must tie to the dollar before you touch a transaction**: Load the legacy closing trial balance into the new GL as of the cutover date and reconcile it, then migrate open AR/AP so each sub-ledger ties to its control account.

**Migrate only the history you can justify**: Bring the 2–3 years of detail (plus opening balances) that auditors and lenders actually reference, and archive the rest. Full-history migration costs more upfront but preserves auditability and prior-period comparisons.

**Time cutover to a period-end and run a parallel close**: Align go-live with a period- or fiscal-year boundary and close one month in both systems side by side, so balances and comparatives stay clean and the CFO or controller can sign off.

**Legacy takes months; AI-native takes days**: Traditional consultant-led migrations run 6–12 months at $5K–$75K depending on history and systems, and data migration is chronically under-budgeted. An AI-native ERP compresses it to days - DualEntry migrates full transaction history in 24 hours.

## What is ERP migration?

_ERP migration moves data and processes from a legacy system to a new ERP. It covers people, workflows, and reporting, alongside the records. ERP data migration involves extracting, mapping, cleansing, and validating records._

### What data moves in an ERP migration

| Data type | Examples | Migration note |
| --- | --- | --- |
| Master data | Customers, vendors, items, chart of accounts | Cleanse & de-duplicate first |
| Transactional data | Invoices, payments, journal entries | Decide how much history to bring |
| Open items | Open AR/AP, unapplied cash | Must tie to sub-ledger balances |
| GL history / opening balances | Trial balance, prior-period actuals | Must reconcile to legacy TB |

IT teams and implementation partners usually own the first three rows in the table above: master data, transactional data, and open items like accounts receivable (AR) and accounts payable (AP). The one they hand to finance, GL history and opening balances, is where audit and close risk becomes an issue.

## Making the switch – step by step

Whatever your timeline or ERP migration strategy, these seven steps apply:

1. Scope the project and build the business case
2. Assemble the team and name an owner
3. Audit and map your data
4. Cleanse and de-duplicate records
5. Build and test in a sandbox
6. Cutover and run a parallel close
7. Validate data, train the team, and go live

A legacy, consultant-led ERP migration plan typically takes 6-12 months to work through these stages. An AI-native approach can compress the same stages into days.

## What to migrate, map, cleanse and validate

_ERP data migration follows four steps: map each legacy field to its new ERP equivalent, cleanse and de-duplicate master data, validate the results against source records, and load a test batch into a sandbox before touching production._

Data mapping means matching each source field (e.g. customer ID, GL account, item code) to its home in the new chart of accounts. Data cleansing catches any duplicate vendors, inactive customers, and inconsistent naming before they can be carried over. Data validation checks the cleansed file against source reports. A staged test load into a sandbox flags up mapping errors before they hit production.

Throughout the migration, proper governance is key. Assign an owner for each data type, get sign-off before loading production, and run a full reconciliation against the source before you move on.

## Why you shouldn’t skip opening balances, sub-ledgers or GL history

_To migrate opening balances to a new ERP, load your closing trial balance from the legacy system into the new general ledger as of the cutover date. Opening balances must reconcile to the legacy trial balance at cutover. Make sure this step is complete before touching a single transaction in your new system._

Transaction-level history preserves auditability and prior-period comparisons. Full-history migration costs more upfront than opening balances alone, and it's the approach DualEntry takes by default.

| Item | What to do | Tie-out |
| --- | --- | --- |
| Opening balances | Load trial balance into the new GL | = legacy TB to the dollar |
| Open AR | Migrate open invoices by customer | = AR sub-ledger total |
| Open AP | Migrate open bills by vendor | = AP sub-ledger total |
| GL history | Decide years; load transaction detail | Spot-check period totals |
| Bank/cash | Reconcile cash and in-transit items | = last bank reconciliation |

## Cutover and the parallel close: migrating without breaking your month-end

_Cutover should align with a period- or fiscal-year-end boundary. That keeps balances and comparatives clean on both sides of the switch. Most finance teams also run a parallel close, closing one period in the old and new systems side by side._

Your audit trail depends on prior-period numbers lining up cleanly across the cutover. Auditors and lenders need continuity between old and new systems. Some teams call this a parallel run rather than a parallel close; the idea is to keep the legacy ERP live until both closes reconcile, and the CFO or controller signs off.

### ERP cutover checklist

| Phase | Action | Owner |
| --- | --- | --- |
| Pre-cutover | Final data load and sandbox tie-out | Controller and implementer |
| Cutover | Freeze legacy system; set go-live at period-end | Project lead |
| Parallel close | Close month in both systems; reconcile | Accounting team |
| Sign-off | Go/no-go on variances; retire legacy system | CFO or controller |

## How long does ERP migration take, and what does it cost?

_Migrating off a legacy ERP the traditional way takes 6-12 months and costs anywhere from $5,000 to as much as $75,000, depending on how much transaction history there is and how many systems are involved._

### ERP migration cost and timeline

| Driver | Typical range | Note |
| --- | --- | --- |
| Data migration | $5K (≤2 yr) to $75K (8+ yr) | Frequently under-budgeted |
| Timeline (legacy) | 6-12 months | Consultant-led; billed hourly |
| Timeline (AI-native) | 24 hours to 6 weeks | Automated; sandbox first |
| History depth | Drives cost & effort | Migrate what audit needs and archive the rest |

## Big-bang vs. phased vs. parallel… which migration approach to choose?

_Whether it's an on-premise move or a SaaS ERP migration between two platforms, most mid-market finance teams should choose a parallel cutover timed to period-end._

### Migration methods compared

| Approach | Best for | Tradeoff |
| --- | --- | --- |
| Big bang | Small, simple data sets | Highest risk if something breaks |
| Phased | Multi-entity/multi-module | Longer; temporary dual-system state |
| Parallel | Finance-critical cutovers | Extra effort to run both for one close |

## Common ERP migration mistakes

Five shortfalls come up again and again:

- Treating migration as an IT project instead of a change-management one, with finance left out of cutover planning until it's too late to fix anything.
- Migrating opening balances only and losing transaction-level history.
- Skipping the parallel close, then finding out after go-live that balances don't tie.
- Cutting over mid-period instead of at a period- or year-end boundary.
- Under-budgeting the data migration itself – while migrating years of history that nobody needs.

## Closing thoughts

An ERP migration succeeds or fails on the finance work: opening balances that reconcile to the dollar, the right depth of history, and a parallel close that ties out before you retire the old system.

Moving the data over is the easy part. Preserving the audit trail and making that first close tie out is what ends up protecting the business – so it deserves a proper plan from day one.

## ERP Migration FAQs

### What is ERP migration?

ERP migration is the process of moving your data, processes, and reporting from a legacy system to a new ERP. The data migration – which involves extracting, mapping, cleansing, and validating records – is where it often goes wrong.

### How do you migrate opening balances to a new ERP?

Load the legacy trial balance into the new general ledger, reconcile it, then migrate open AR/AP so each sub-ledger ties to its control account before go-live.

### How long does an ERP migration take?

Legacy, consultant-led migrations typically take 6-12 months, but AI-native platforms can migrate data in as little as 24 hours and go live within a few weeks.

### How much does ERP data migration cost?

Typically $5,000–$12,000 for two years of data or less, rising to as much as $75,000 for eight-plus years across multiple systems. Data migration is one of the most commonly under-budgeted parts of an ERP project.

### What is an ERP cutover?

Cutover is the switch from the old system to the new one. Timing it to align with the end of a period or fiscal year, then running a parallel close will help to keep your balances and comparatives clean.

### Big bang or phased ERP migration?

Big-bang suits small, simple data sets. Phased suits multi-entity or multi-module rollouts. A parallel cutover best protects a finance-critical close.

### How much historical data should you migrate?

Migrate only the history that you need for reporting and audit purposes, and archive the rest. This way, you’ll have tighter control over costs.
