Migrate from Sage 50 to Business Central: UK Guide
Moving from Sage 50 to Business Central? What data comes across, how to map accounts and dimensions, and how UK teams keep VAT, MTD and cut-over under control.
If you are adding companies, transactions or reporting needs, you may be weighing a move from Sage 50 to Business Central. It is a project worth planning properly.
This guide sets out what the move involves, what data comes across and how to keep VAT and cut-over under control.
Key PointMoving from Sage 50 is a project: decide the data, design the accounts, rehearse VAT, then cut over.
Why businesses move on from Sage 50
Reasons to look at the move include several companies or currencies, live reporting instead of exported spreadsheets, remote access for a hybrid finance team and approval workflows.
Business Central covers these as a cloud ERP. Treat the move as a proper project, not a same-day switch. The ICAEW technology resources offer independent guidance on choosing finance systems.
What data comes across
You will usually bring across the chart of accounts, customers, suppliers, items, open transactions and a trial balance at a cut-off date.
Business Central includes templates for accounts, customers, vendors and inventory items that you can apply when you import data from Excel, which suits a Sage 50 export.
Decide early how much history to move. One option is to bring opening balances and a set window of history, and keep the old Sage 50 data available read-only.
Pro TipAgree how much history to move before you export anything from Sage 50.
Mapping Sage 50 to Business Central
Concepts do not map one to one. Sage 50 nominal codes become a redesigned chart of accounts, and some of the coding you relied on fits better in dimensions.
Microsoft explains that, instead of setting up separate general ledger accounts for each department and project, you can use dimensions as the basis for analysis. Time spent on the account and dimension design pays back at every month-end.
Getting VAT and MTD right
GOV.UK says all VAT-registered businesses should now be signed up for Making Tax Digital for VAT. Microsoft's UK Making Tax Digital guide says Business Central can retrieve VAT obligations from HMRC and submit VAT returns.
Set up VAT posting groups to match your VAT position before the first return. Reconcile VAT at the cut-off, then run the VAT Return report in a sandbox and compare it with a known Sage 50 figure. HMRC does not accept test submissions, so only the figures can be rehearsed.
Watch OutCompare the VAT Return report in a sandbox with Sage 50 before your first live return.
Planning the cut-over
Agree a clean cut-off date and finish outstanding reconciliations in Sage 50. Then migrate the balances and run a short verification period before you switch fully.
Keep the retention rules in mind too. GOV.UK says a limited company must keep its company and accounting records for 6 years from the end of the last financial year they relate to.
Train the finance team on their new day-to-day tasks before go-live, not after it. Our data migration process guide and migration strategy guide go into the detail.
Your next step
Read our practical guide to Business Central migration for the step-by-step view. If your business already holds Business Central licences but has not gone live, our BC Fast-Start includes data migration in a twelve-week, £4,500 fixed-price route to go-live.