ERPNext data migration checklist
ERPNext Data Migration Checklist: Customers, Suppliers, Items, Stock and Opening Balances
A practical ERPNext data migration checklist for UK businesses covering customers, suppliers, items, stock, warehouses, opening invoices, opening balances, VAT, testing and go-live.
Data migration is one of the most important parts of any ERPNext implementation. If customers, suppliers, items, stock and opening balances are wrong, users will not trust the system from day one. A successful migration is not just about uploading spreadsheets—it is about moving into a clean, controlled and reliable operating system.
ERPNext data migration succeeds when customers, suppliers, items, stock and opening balances are cleaned, mapped, tested and reconciled before go-live.
For most UK businesses, migrate company setup, Chart of Accounts, customers, suppliers, items, warehouses, opening stock, outstanding invoices, opening balances and open orders first. Start with clean master data and accurate opening data—not everything from the old system.
1. Why Data Migration Matters in ERPNext
ERPNext connects customers to sales and invoices, suppliers to purchasing and payables, and items to stock, valuation and reports. Duplicate customers make receivables messy. Inconsistent item codes make stock unreliable. Wrong opening balances destroy finance confidence. Data migration is the foundation of ERPNext adoption.
2. The Biggest ERPNext Migration Mistake
The biggest mistake is importing old data exactly as it is from Sage, QuickBooks, Xero, Odoo, spreadsheets or legacy ERP. Old data often contains duplicates, inactive records, bad item codes, wrong VAT numbers, incorrect stock and unreconciled balances. The right approach: Export → Clean → Map → Test → Import → Reconcile → Validate → Go Live.
3. ERPNext Migration Data Categories
| Category | Examples |
|---|---|
| Master data | Customers, suppliers, items, warehouses, Chart of Accounts, tax templates |
| Opening data | Opening balances, outstanding invoices, opening stock, open orders |
| Historical data | Old invoices, payments, stock movements, project history |
For many businesses, import clean master data and opening balances, then keep the old system as an archive.
4. Recommended ERPNext Data Migration Order
Import order: Company setup → Fiscal year → Chart of Accounts → Cost Centres → Tax templates → Warehouses → UOMs → Item Groups → Items → Price Lists → Customers and contacts → Suppliers → Opening stock → Outstanding invoices → Opening balances → Open orders → Users → Final reconciliation.
5. Pre-Migration Checklist
Business, finance and operational setup
- Company name, VAT number, fiscal year, base currency confirmed
- Chart of Accounts, VAT accounts, stock and bank accounts reviewed
- Warehouse structure, item code rules and stock valuation method agreed
- Data owners assigned for customers, suppliers, items, stock and finance
6. Customer Migration Checklist
Prepare customer name, group, territory, billing/shipping address, contact, email, VAT number, payment terms, credit limit, currency, price list and opening balance.
- Remove duplicates; standardise company names
- Confirm VAT numbers, addresses and payment terms
- Remove inactive customers unless needed
- Validate outstanding balances against Aged Debtors
7. Supplier Migration Checklist
Prepare supplier name, group, address, contact, VAT number, payment terms, currency, default accounts and opening balance. Review with purchasing and finance. Confirm outstanding supplier bills and disputes before import.
8. Contact and Address Migration Checklist
In ERPNext, Customers and Suppliers are separate from Contacts and Addresses. Prepare address type, postcode, linked party, primary contact and shipping flags. Avoid importing all addresses as billing only or linking contacts to the wrong party.
9. Item Migration Checklist
Prepare item code, name, group, stock UOM, barcode, stock/sales/purchase flags, default warehouse, valuation method, reorder levels, tax template and serial/batch requirements.
- Remove duplicate SKUs; standardise item codes
- Confirm stock vs non-stock, sales vs purchase items
- Use unique, stable codes—not MISC or supplier temp codes
10. Unit of Measure Checklist
Check whether UOMs exist in ERPNext, whether Each/EA/Unit/Nos are duplicated, whether purchase and sales UOMs differ and whether conversion factors are required. UOM mistakes affect stock, purchasing and valuation.
11. Warehouse Migration Checklist
Warehouses may include main stores, production, finished goods, returns, damaged goods, van stock, site stock and 3PL. Confirm physical structure, virtual warehouses, stock account links and opening stock by warehouse. Avoid too many or too few warehouses.
12. Price List and Item Price Checklist
Prepare item code, price list, rate, currency, UOM and validity dates. Review buying vs selling prices, VAT-inclusive vs exclusive rates and customer-specific pricing with sales and purchasing.
13. Stock Migration Checklist
Prepare item code, warehouse, quantity, valuation rate and batch/serial numbers. Complete a physical stock count, freeze movement during final count, separate damaged and returned stock, and reconcile stock value to accounts. Do not rely only on old system figures if warehouse staff do not trust them.
14. Serial and Batch Migration Checklist
For serialised items prepare serial number, warehouse and status. For batched items prepare batch number, quantity, expiry and valuation rate. Avoid importing quantity without serial numbers, duplicating serials or missing batch expiry dates.
15. Opening Sales Invoices Checklist
Prepare customer, invoice number, date, due date, outstanding amount, currency, VAT and payment terms. Compare total with Aged Debtors report; remove fully paid invoices; check disputes and credit notes. Opening Sales Invoices must match the approved debtor balance.
16. Opening Purchase Invoices Checklist
Prepare supplier, bill number, date, due date, outstanding amount, currency and VAT. Compare with Aged Creditors; remove fully paid bills; check disputes and duplicate invoices.
17. Opening Account Balances Checklist
Prepare balances for bank, cash, debtors, creditors, VAT, stock, fixed assets, loans, accruals, prepayments and retained earnings. Opening balances are normally for Balance Sheet accounts. Reconcile Trial Balance, Balance Sheet, aged debtors/creditors, bank, VAT and stock before go-live.
18. VAT and MTD Migration Checklist for UK Businesses
Review VAT registration, scheme, return periods, reverse charge, import VAT, last VAT return from old system and MTD submission route. Test VAT reports, tax templates and item tax templates. Ask the accountant to review the first VAT period before go-live.
Do not wait until the VAT deadline to test Making Tax Digital submission.
19. Open Sales Orders and Purchase Orders Checklist
For open orders prepare customer/supplier, order number, dates, item, quantities ordered/delivered/pending, rate and warehouse. Decide whether to complete in old system, cancel and recreate, import or start fresh. Do not migrate closed orders without a strong reason.
20. Data Import Testing Checklist
Use a test site—not live ERPNext first. For each dataset: prepare import template, import small sample, fix errors, import larger batch, review linked records and get user sign-off. Test customers, suppliers, items, stock, opening invoices and opening balances.
21. Reconciliation Checklist
Finance, stock and operational reconciliation
- Trial Balance, Balance Sheet, debtors, creditors, bank, VAT, retained earnings
- Stock quantity and value by item and warehouse; serial and batch quantities
- Open Sales/Purchase Orders, projects, work orders and delivery commitments
Reconciliation should be signed off by finance and operations.
22. Go-Live Cutover Checklist
Before, during and after cutover
- Before: go-live date agreed, final stock count planned, test migration signed off
- During: stop old system entries, export final data, import into ERPNext, reconcile
- After: test first live transactions, monitor user issues, keep old system read-only
23. Post-Go-Live Data Checks
In the first 30 days check new customer/supplier/item creation, stock transactions, negative stock, invoice numbering, payment allocation, VAT coding, duplicate records, permissions and report accuracy.
24. Common ERPNext Data Migration Mistakes
- Importing dirty data without cleaning duplicates
- Wrong import order—items before UOMs, invoices before customers
- No physical stock count; not reconciling stock value to accounts
- Summary balances when invoice-level tracking is needed
- Not testing on staging; not involving finance or warehouse sign-off
- Going live without support or freezing old system during cutover
25. ERPNext Data Migration Responsibility Matrix
| Data Area | Main Owner | Supporting Team |
|---|---|---|
| Customers | Sales / Finance | Implementation Partner |
| Suppliers | Purchasing / Finance | Implementation Partner |
| Items / Stock | Operations / Warehouse | Finance |
| Opening Balances / VAT | Finance / Accountant | Implementation Partner |
| Final Sign-Off | Business Owner | Project Team |
26. ERPNext Migration Checklist Summary
Master, finance and stock data
- Customers, suppliers, contacts, addresses, items, UOMs and warehouses cleaned
- Chart of Accounts, tax templates, opening invoices and balances prepared
- Physical stock count completed; valuation reconciled; serial/batch prepared
Testing and go-live
- Trial import completed; sales, purchase, stock and VAT flows tested
- Cutover executed; reports reconciled; users trained; support plan active
27. Why Work With Talpha Solutions?
Talpha Solutions helps UK businesses migrate from spreadsheets, Sage, QuickBooks, Xero, Odoo and legacy ERP to ERPNext. We help with data audit, customer/supplier/item/stock migration, opening balances, VAT/MTD planning, trial migration, reconciliation, go-live and post-go-live support. We clean, map, validate and reconcile data so the system is usable from day one.
Final Advice
Clean data first, then go live. If customers, suppliers, items, stock and opening balances are clean, users will trust ERPNext. If they are wrong, users will return to spreadsheets. Key success factors: clear import order, physical stock count, accurate opening invoices, reconciled balances, VAT/MTD planning, trial migration and finance and warehouse sign-off.
Call to Action
Planning an ERPNext migration? Book a free ERPNext data migration discovery call with Talpha Solutions. We will review your current customers, suppliers, items, stock, opening balances, VAT requirements and migration risks, then recommend a practical ERPNext migration plan.
FAQ
Frequentlyasked questions
Answers to common evaluation questions.
The first data to migrate should usually be master data such as customers, suppliers, contacts, addresses, items, warehouses, price lists and Chart of Accounts. Opening stock, opening invoices and opening balances should follow after master data is validated.
Yes. ERPNext supports spreadsheet-based data import. Customer and Supplier data should be cleaned, deduplicated and mapped before import.
Yes. ERPNext can import Items and opening stock. Items should be imported before stock. Warehouses, Units of Measure and Item Groups should also be created before stock migration.
For non-serialised items, opening stock is usually posted using Stock Reconciliation. For serialised or batched items, serial and batch data must be prepared carefully before opening stock is submitted.
Outstanding customer invoices can be migrated as opening Sales Invoices. The total should match the approved Aged Debtors report from the previous system.
Outstanding supplier bills can be migrated as opening Purchase Invoices. The total should match the approved Aged Creditors report from the previous system.
Not always. Many businesses migrate only opening balances, outstanding invoices and selected recent history, while keeping the old system as a read-only archive.
The biggest risk is importing dirty data. Duplicate customers, bad item codes, wrong stock quantities and unreconciled opening balances can damage user trust immediately after go-live.
Yes. UK businesses should review VAT accounts, tax templates, VAT balances, VAT return periods and the Making Tax Digital submission route before going live.
Finance should sign off opening balances, debtors, creditors and VAT. Warehouse or operations should sign off stock. Sales and purchasing should review customers, suppliers and open orders. Final sign-off should come from the business owner or project sponsor.