---
title: "How to migrate data from one ERP to another"
description: "ERP migration in order: master data, opening balances or full history, open documents, then reconciliation. Native import tools and their limits."
url: "https://flitstack.ai/answers/migrate-data-between-erp-systems"
---

# How do I migrate data from one ERP to another?

Short answer

Migrate in layers. Start with the chart of accounts and dimensions, then customers, vendors and items, then opening balances or full transaction history, then open documents such as unpaid invoices and open POs. Cut over at a period end and reconcile trial balances between the two systems. Most ERPs import through templates, like Business Central's configuration packages.

![](https://flitstack.ai/images/authors/aditya-kumar.webp)By [Aditya Kumar](https://flitstack.ai/about/aditya-kumar) Updated November 5, 2026

[Ask us about your migration ](https://flitstack.ai/contact) [Read the full guide →](https://flitstack.ai/migrations/erp)

## The layers, in order

1. **Configuration**: fiscal calendar, currencies, tax codes, dimensions, posting groups.
2. **Chart of accounts**: mapped account by account, including parent/child structure.
3. **Master data**: customers, vendors, items, price lists, warehouses.
4. **Balances or history**: either an opening trial balance at cutover, or posted transactions for N years.
5. **Open documents**: unpaid sales invoices and bills, open sales and purchase orders, on-hand inventory with costs.
6. **Reconciliation**: trial balance, AR and AP agings and inventory valuation compared between the old and new systems.

## What the native tools do / where they stop

| Destination      | Native import                                                                                                     | Where it stops                                                                                                                                                                                        |
| ---------------- | ----------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Business Central | Configuration packages (Excel); Cloud Migration from BC on-premises, GP, SL and custom SQL; QuickBooks extensions | Microsoft calls configuration packages “advanced functionality” and suggests a partner. The QuickBooks Online migration brings a beginning balance, not full history, and no sales or purchase orders |
| NetSuite         | CSV Import Assistant                                                                                              | 25,000 records or 50 MB per import job; transactions should stay under 5,000 lines (10,000 for journal entries)                                                                                       |
| Odoo             | CSV or XLSX import on any object                                                                                  | Relationships need External IDs; related records have to be imported first                                                                                                                            |

Every one of these imports data. None of them maps your chart of accounts to the new one or proves the balances match afterwards. That’s where ERP migrations take longest.

## Choosing how much history

Legal retention isn’t the same as migration scope. In the US, the IRS says to keep records for 3 years in most cases and longer in some. You can meet that from an archive of the old ERP. Bringing the history into the new ERP is a business choice: drill-down and comparisons with prior years, weighed against migration effort and messy legacy postings.

## Where FlitStack AI fits

FlitStack AI migrates ERP transactions at line level, with a before-and-after trial balance reconciliation report and a configurable cutoff for history. Most customers migrate 3–7 years. See [ERP migrations](https://flitstack.ai/migrations/erp) or [talk to us](https://flitstack.ai/contact).

![Aditya Kumar](https://flitstack.ai/images/authors/aditya-kumar.webp)

About the author

[Aditya Kumar](https://flitstack.ai/about/aditya-kumar)

Founder, FlitStack AI

Aditya Kumar is the founder of FlitStack AI and Jetstack AI, both built at Ambrstack. FlitStack AI migrates CRM and business data between platforms; Jetstack AI is the AI platform HubSpot partners and RevOps teams use to audit portals, build implementations and reuse their best setups across portals. He writes about CRM data, migrations, HubSpot architecture and automation from the work of building them.

[More from Aditya](https://flitstack.ai/about/aditya-kumar) [LinkedIn](https://www.linkedin.com/in/aditya-ambrstack/)

On this page

Questions, answered

## A few useful answers.

Opening balances or full history?

Opening balances are faster and cleaner; full history keeps drill-down in one system. A common middle path is detailed history for a few years plus balances before that, with the old ERP archived for audits.

When should we cut over?

At a month or year end, after the old period is closed. Mid-period cutovers make accruals and reconciliation much harder.

Do reports and approval workflows migrate?

No. Saved reports, financial statement layouts, custom forms and approval workflows are rebuilt in the destination ERP.

## Related

### [ERP migration](https://flitstack.ai/migrations/erp)

[Read →](https://flitstack.ai/migrations/erp)

### [Migrate to Business Central](https://flitstack.ai/migrations/erp/microsoft-dynamics-365-business-central)

[Read →](https://flitstack.ai/migrations/erp/microsoft-dynamics-365-business-central)

### [NetSuite to Business Central migration](https://flitstack.ai/migrations/erp/netsuite/to/microsoft-dynamics-365-business-central)

[Read →](https://flitstack.ai/migrations/erp/netsuite/to/microsoft-dynamics-365-business-central)

### [Migrate to Odoo ERP](https://flitstack.ai/migrations/erp/odoo-erp)

[Read →](https://flitstack.ai/migrations/erp/odoo-erp)

## Sources

1. [Microsoft Learn: Import business data with configuration packages (Business Central)](https://learn.microsoft.com/en-us/dynamics365/business-central/across-import-data-configuration-packages)
2. [Microsoft Learn: Migrate on-premises data to Business Central online](https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/migrate-data)
3. [Microsoft Learn: Migrate data from QuickBooks Online to Business Central](https://learn.microsoft.com/en-us/dynamics365/business-central/ui-extensions-quickbooks-online-data-migration)
4. [Oracle NetSuite Help: CSV Import Assistant limits](https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_N453326.html)
5. [Odoo Documentation: Export and import data](https://www.odoo.com/documentation/19.0/applications/essentials/export_import_data.html)
6. [IRS: How long should I keep records?](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records)

A closer look

## Tell us what you’re moving.

Share your source, destination and rough record counts. We scope the migration and the process work with you and send you a quote.

[Get a quote](https://flitstack.ai/contact)
