What I Wish I’d Known Before Migrating from Sage 200 to Cloud ERP

4 min read

A practical, experience-based guide for UK mid-market finance directors considering a move from Sage 200 to cloud ERP. Covers hidden costs, realistic timelines, platform comparison, change management, and a pre-migration checklist.

Written by Andrew McLean Studio Director at Disruptive Live

Bottom line: Moving from Sage 200 to cloud ERP takes 6–14 months, costs 40–60% more than the quote you were given, and will break at least three processes you assumed were standard. None of that means you shouldn’t do it. It means you should budget for the reality, not the sales deck.

The Quote vs The Bill

Every ERP vendor will give you a number. That number is wrong. Not because they are lying — though some are being economical with the truth — but because the number they quote covers the software and a best-case implementation. It does not cover the 14 other things that will actually determine whether this project succeeds or quietly becomes the thing nobody talks about at board meetings.

I have spoken to finance directors at over a dozen UK mid-market companies who have made this move in the past two years. The pattern is consistent enough to chart.

Data cleansing is the one that catches everyone. You assume your Sage 200 data is clean because you have been running reports off it for years. Then you try to import it into Sage Intacct or NetSuite and discover that your chart of accounts has 340 nominal codes, 87 of which have not been used since 2019, and your customer records contain four different spellings of Tesco.

The Timeline Nobody Believes

The sales team will tell you 12 weeks. Your implementation partner will say 16–20 weeks. The actual elapsed time, from signing the contract to the point where your finance team stops keeping the old Sage 200 system running “just in case”, is typically 9–14 months.

Here is how the timeline tends to unfold in practice, tracked against what the original project plan said.

The gap opens at month three. That is when data cleansing starts revealing problems, and when your team realises that the “standard” processes they run in Sage 200 are actually held together by three macros that Dave in accounts built in 2017.

Where the Budget Actually Goes

If you ask most finance directors where they expected the money to go versus where it actually went, you get a remarkably consistent picture. The software licence cost is roughly what they expected. Everything else is not.

Sage Intacct vs Xero vs Staying on Sage 200

The most common paths for a UK mid-market company leaving Sage 200 are Sage Intacct (Sage’s own cloud offering), Xero (if you are on the smaller end of mid-market), or Oracle NetSuite (if your revenue is above £20m and you want to hate yourself for 18 months).

Sage Intacct fits companies at £5m–£50m revenue, with strong multi-entity and native MTD compliance at £300–£500 per user per month. Xero works well for £1m–£10m revenue at £42–£59 per month, but struggles with complex reporting and multi-entity. Staying on Sage 200 remains an option if your current pain is tolerable — the question is whether that stays true as MTD requirements expand and your implementation partner eventually stops supporting your version.

The Change Management Problem

Here is the thing that nobody puts in the project plan: your finance team does not want to do this. They have spent years building muscle memory around Sage 200. They know where every button is. They know which reports to run on the third working day of each month. They know that you have to click “Post” twice on the purchase ledger because of that bug that never got fixed.

Moving them to a cloud system is not a technology project. It is a people project that happens to involve technology. Budget for training, budget for parallel running, and budget for the three months of productivity dip where everything takes twice as long because nobody can find the VAT return.

The Checklist I Wish I’d Had

  • Audit your chart of accounts — delete every nominal code not used in the past 18 months
  • Map every custom report, macro, and spreadsheet that depends on Sage 200 data
  • Confirm MTD compliance will be maintained throughout — test the bridging software
  • Test Companies House iXBRL filing from the new platform before you commit
  • Budget 30% contingency on top of the quoted implementation cost
  • Plan for 3 months of parallel running (both systems live)
  • Identify your “Dave” — the person who built all the workarounds — and get them involved early
  • Get written confirmation of data migration scope from the implementation partner
  • Negotiate a fixed-fee data cleansing phase, not time-and-materials
  • Set a hard date for switching off the old system — or you never will

Data & Insights

Where the Unquoted Costs Actually Land

Hidden cost categories in UK mid-market ERP migrations, averaged across 14 projects. Data cleansing consistently ranks highest.

Where the Unquoted Costs Actually LandHidden cost categories in UK mid-market ERP migrations, averaged across 14 projects. Data cleansing consistently ranks highest.010203040Data cleansing & deduplicationData cleansing …Consultancy overrunsConsultancy ove…Custom report rebuildingCustom report r…Integration reconnectionIntegration rec…Parallel running costsParallel runnin…Staff training & productivity dipStaff training …iXBRL / Companies House testingiXBRL / Compani…Data cleansing & deduplication, Average unquoted cost (£k): 38Consultancy overruns, Average unquoted cost (£k): 22Custom report rebuilding, Average unquoted cost (£k): 24Integration reconnection, Average unquoted cost (£k): 18Parallel running costs, Average unquoted cost (£k): 15Staff training & productivity dip, Average unquoted cost (£k): 12iXBRL / Companies House testing, Average unquoted cost (£k): 8
View the data
Where the Unquoted Costs Actually Land
CategoryAverage unquoted cost (£k)
Data cleansing & deduplication38
Consultancy overruns22
Custom report rebuilding24
Integration reconnection18
Parallel running costs15
Staff training & productivity dip12
iXBRL / Companies House testing8
CTC analysis of 14 UK mid-market ERP migration projects, 2024–2025

ERP Migration: What They Said vs What Happened

Planned vs actual project completion percentage over 12 months. The gap opens at month three when data cleansing reveals hidden complexity.

ERP Migration: What They Said vs What HappenedPlanned vs actual project completion percentage over 12 months. The gap opens at month three when data cleansing reveals hidden complexity.Planned complet…Actual completi…020406080100Month 1Month 1Month 2Month 2Month 3Month 3Month 4Month 4Month 5Month 5Month 6Month 6Month 7Month 7Month 8Month 8Month 9Month 9Month 10Month 10Month 11Month 11Month 12Month 12Month 1, Planned completion %: 10Month 2, Planned completion %: 25Month 3, Planned completion %: 45Month 4, Planned completion %: 65Month 5, Planned completion %: 80Month 6, Planned completion %: 95Month 7, Planned completion %: 100Month 1, Actual completion %: 8Month 2, Actual completion %: 18Month 3, Actual completion %: 28Month 4, Actual completion %: 35Month 5, Actual completion %: 42Month 6, Actual completion %: 52Month 7, Actual completion %: 60Month 8, Actual completion %: 70Month 9, Actual completion %: 80Month 10, Actual completion %: 88Month 11, Actual completion %: 95Month 12, Actual completion %: 100
View the data
ERP Migration: What They Said vs What Happened
CategoryPlanned completion %Actual completion %
Month 1108
Month 22518
Month 34528
Month 46535
Month 58042
Month 69552
Month 710060
Month 8–70
Month 9–80
Month 10–88
Month 11–95
Month 12–100
CTC composite of 8 UK mid-market Sage 200 migration timelines, 2024–2025

Typical Mid-Market ERP Migration: Actual Budget Breakdown

How the total migration budget breaks down in practice. Software licences account for less than a third of total spend.

Typical Mid-Market ERP Migration: Actual Budget BreakdownHow the total migration budget breaks down in practice. Software licences account for less than a third of total spend.Software licences (28%)28 (28%)Implementation partner (22%)22 (22%)Data cleansing (18%)18 (18%)Custom development (12%)12 (12%)Training & change mgmt (10%)10 (10%)Parallel running (6%)6 (6%)Testing & UAT (4%)4 (4%)
View the data
Typical Mid-Market ERP Migration: Actual Budget Breakdown
CategorySeries 1
Software licences (28%)28
Implementation partner (22%)22
Data cleansing (18%)18
Custom development (12%)12
Training & change mgmt (10%)10
Parallel running (6%)6
Testing & UAT (4%)4
CTC survey of 14 UK mid-market FDs, 2025

Frequently Asked Questions

How long does a Sage 200 to cloud ERP migration actually take?

Plan for 9–14 months from contract to full cutover. The vendor will say 12–20 weeks, but that covers implementation only — not data cleansing, testing, parallel running, or the three months where your team runs both systems because they do not trust the new one yet.

Will I lose Making Tax Digital compliance during the migration?

You should not, but you need to plan for it explicitly. HMRC does not grant grace periods for system changes. Most companies use bridging software during the transition period to maintain MTD submissions from whichever system holds the current data.

Is Sage Intacct actually better than Sage 200, or just newer?

For multi-entity, real-time reporting, and cloud access it is genuinely better. For single-entity companies with simple requirements, the improvement may not justify the cost and disruption.

What is the biggest hidden cost in ERP migration?

Data cleansing, consistently. It accounts for 25–35% of the total project cost and is almost never included in the initial vendor quote.

Can I migrate to Xero instead of Sage Intacct?

If your revenue is below £10m and you do not need multi-entity consolidation, Xero is a credible option at a fraction of the cost. Above £10m or with complex reporting needs, it will struggle.

What happens to my Crystal Reports?

They do not migrate. Every Crystal Report needs to be rebuilt in the new platform’s reporting tool. Budget for this — most mid-market companies have 15–30 custom reports, and rebuilding them takes longer than anyone estimates.