How to migrate from Sage to Xero
Xero points Sage users to Movemybooks, a conversion service that moves the chart of accounts, contacts, balances and up to two years of transactions. Smaller businesses can instead set up the chart of accounts and enter conversion balances. Pick a period end, convert, then check the trial balance.
Which route should you take for migrating from Sage to Xero?
This moves your bookkeeping from Sage to Xero. You choose a cut-off date, usually the end of a tax or financial period, and either use a conversion service to copy your accounts, customers, suppliers, balances and recent transactions, or set up Xero yourself with opening balances from your accountant.
- Recommended route: Conversion service (Movemybooks) at a period end
- Order: Pick the cut-off, tidy Sage, convert, then reconcile in Xero before you stop using Sage.
- 3 phases: Prepare, Convert and Set up and check.
- You're done when: Xero trial balance matches Sage at the cut-off date.
Then you connect your bank to Xero, check the figures match, and stop entering work in Sage.
Xero names it for Sage, and it moves contacts, balances and up to two years of transactions in one pass.
Other options and when to use them
- Chart of accounts template and conversion balances: A small business with few open items that wants a clean start.
- Accountant or bookkeeper conversion: Complex files with inventory, foreign currency or fixed assets.
Pick the cut-off, tidy Sage, convert, then reconcile in Xero before you stop using Sage.
- Cut-off date agreed with your accountantBalances and history are taken as at that date.
- Sage reconciled and tidiedErrors in Sage carry into Xero.
- Reports saved from SageTrial balance, aged receivables and payables for checking.
- Conversion run, or balances enteredCreates the Xero file.
- Bank feeds and users set upBank connections do not move.
- Trial balance checkedProves the conversion before Sage is closed.
Built-in and third-party tools treat these differently. Tick each one off once you have decided.
Download this checklist (Excel)How each tool handles it
Built-in methodXero: Movemybooks converts Sage 50 or Instant from a backup file, and Sage Business Cloud Accounting by authorised access. The DIY route uses a chart of accounts CSV template and account balances in guided setup.MovemybooksMoves chart of accounts and balances, customer and supplier details and balances, and transactions, with up to 2 years of history to Xero Standard or Premium.Tip: Check what the service cannot convert before you choose a cut-off.
Xero: Change to XeroHow each tool handles it
Built-in methodXero states there will be some information Movemybooks cannot convert, and links to its limitations.MovemybooksReviewers note inventory, foreign exchange and fixed assets may need special attention.Tip: Ask your accountant to review these areas after conversion.
Xero: Conversion methods for partnersHow each tool handles it
Built-in methodXero: enter conversion balances from your trial balance at the conversion date, with unpaid invoices and bills.Tip: Use your accountant's final trial balance for the cut-off date.
Xero Central: Enter conversion balancesHow each tool handles it
Built-in methodXero App Store lists conversion apps by region.Tip: Check the app supports your Sage edition and region.
Xero App Store: Conversion apps
- 1
Prepare
Before the cut-offShow the detailed steps (1) →Watch out: Errors in Sage carry into Xero.
Ways around it
- Reconcile and fix before converting.
- 2
Convert
After the cut-offShow the detailed steps (2) →Watch out: Some information cannot be converted.
Ways around it
- Review the service's limitations and plan manual entries.
- 3
Set up and check
Week after conversionShow the detailed steps (1) →Watch out: Bank feeds start fresh in Xero.
Ways around it
- Connect feeds from the cut-off date.
- Xero trial balance matches Sage at the cut-off date.
- Aged receivables and payables match.
- Bank feeds and users are set up.
- Sage is kept read-only for records.
What does each step of migrating from Sage to Xero involve?
Open a part when you reach it in the plan. Each step says where to go, what to do and what you should see.
About this migrationWhat it covers, limits at a glance
Xero offers two ways off Sage: a conversion service that reads a Sage 50 backup or connects to Sage Business Cloud, and a do-it-yourself route using Xero's chart of accounts template and conversion balances. The first brings history and contacts; the second gives a clean start with less detail.
Coming from MYOB or QuickBooks instead? See MYOB to Xero or QuickBooks to Xero.
1What do you need before you migrate from Sage to Xero?
| Need | Details | Where to get it |
|---|---|---|
| Sage backup or admin access | Sage 50 backup file, or Sage Business Cloud login to authorise. | Sage |
| Xero organisation | Standard or Premium plan for 2 years of history via Movemybooks. | Xero |
| Cut-off reports | Trial balance, aged receivables and payables. | Sage reports |
| Accountant sign-off | On the cut-off and balances. | Your accountant |
2Prepare Sage1 step
- 1
Reconcile and save reports
Where: Sage > Banking and ReportsReconcile every bank account to the cut-off date, then save the trial balance and aged reports as PDF.
You should see: Reports you can compare with Xero.
3Convert to Xero2 steps
- 1
With a conversion service
Where: Xero App Store > MovemybooksUpload the Sage 50 backup or authorise access to Sage Business Cloud. The service collects, converts and emails you when it is done.
You should see: Your Xero organisation has accounts, contacts and transactions. - 2
Or enter conversion balances
Where: Xero > Accounting > Advanced > Conversion balancesImport the chart of accounts, then enter balances from the trial balance and add unpaid invoices and bills.
You should see: The conversion balances match the trial balance.
4Set up and check1 step
- 1
Compare reports
Where: Xero > ReportingRun the trial balance and aged reports at the cut-off date and compare with Sage. Record results in the data validation report.
You should see: Figures match.
What can go wrong when migrating from Sage to Xero, and how do you avoid it?
The detail behind the plan: options compared, and what experienced engineers check first. Tap any item.
Compare all the ways to do this3 options
Conversion service
Low effortBest for: Most Sage users
- Contacts and history
- Fast
- Some items not converted
Conversion balances
Medium effortBest for: Small businesses wanting a clean start
- Full control
- Manual work
- No history
Accountant-led
Medium effortBest for: Inventory, foreign currency or assets
- Professional checks
- Coordination
Use the conversion service for most Sage files and have your accountant check the trial balance. Use conversion balances for a clean start.
Not everything convertsSaves time
Xero notes some information cannot be converted by Movemybooks.
Read the limitations before booking and plan manual entries.
History depends on your Xero planCost lever
Up to 2 years of transaction history converts to a Xero Standard or Premium plan.
Choose the plan before converting if you need history in Xero.
Balances must be right on day oneCompliance
Conversion balances set the starting point for every later report.
Use the accountant's final trial balance for the cut-off.
Keep Sage for recordsCompliance
Detailed history older than the converted period stays in Sage.
Keep a final Sage backup and reports for your record-keeping period.
Specialist areas need reviewReduces risk
Reviewers of Movemybooks point to inventory, foreign exchange and fixed assets as areas needing attention.
Have your accountant check these after conversion.
How do you check it worked after migrating from Sage to Xero, or roll back?
Full validation checklist4 checks
Run these before you declare the migration complete. Record the results in the data validation report.
| Check | How to check | What good looks like |
|---|---|---|
| Trial balance | Compare at the cut-off. | Matches. |
| Aged receivables | Compare totals and a sample of customers. | Matches. |
| Aged payables | Compare totals and a sample of suppliers. | Matches. |
| Bank | Reconcile the first month in Xero. | Balances agree with statements. |
Rollback planIf it goes wrong
Roll back if
- Converted figures cannot be reconciled
- Tax or payroll deadlines at risk
Point of no return
Sage keeps its data. Until you stop using it, you can keep working there while the Xero file is fixed.
- 1
Keep working in Sage
Where: SageContinue entries in Sage while fixing Xero.
You should see: Books stay current. - 2
Reconvert
Where: XeroFix issues and run the conversion again into a new organisation.
You should see: Clean data.
Agree the triggers and who decides before the go / no-go meeting. Use the rollback plan template.
Common problems and fixes4 errors
Trial balance does not matchCause: Wrong cut-off date or unreconciled items.
Fix: Compare by account and post adjustments with your accountant.
Contacts missing balancesCause: Open items not converted or entered.
Fix: Add unpaid invoices and bills as conversion balances.
Bank balance wrong in XeroCause: Feed started before the cut-off.
Fix: Delete duplicate statement lines before the cut-off.
Fixed assets missingCause: Not converted.
Fix: Register them in Xero fixed assets.
Questions about migrating from Sage to Xero
Which Sage products convert?
Xero lists Sage 50 or Instant and Sage Business Cloud Accounting for Movemybooks.
How much history moves?
Up to 2 years to Xero Standard or Premium.
Can I do it myself?
Yes, with the chart of accounts template and conversion balances.
When should I switch?
At a period end agreed with your accountant.
Official sources for migrating from Sage to Xero
5 official pages this guide is based on
Vendors change limits and features, so confirm details on the source before you rely on them. Last checked .