How to Migrate from Sage to Xero: An Irish Business Guide

You can move from Sage to Xero in a few days, but the speed of the move is not the hard part. The hard part is arriving in Xero with opening balances that agree to your last filed VAT3 and your accounts, and with your Sage history still readable for Revenue. This guide covers the order of work, the two ways to move the data, the checks that matter, and the Irish record-keeping rules that don't go away when you change software.

TL;DR

Choose a clean cut-off date, ideally the start of a VAT period or financial year, and finish all Sage postings and reconciliations up to it first.
You have two routes: a manual import into Xero, or a conversion service from Xero's app store. The first suits small, simple files. The second suits several years of history, stock or multiple entities.
Check the result against Sage: trial balance, debtors and creditors ledgers, bank balances and VAT control account must all agree on the conversion date.
Revenue requires you to keep records for six years, and they must stay readable in electronic form, so archive Sage before you cancel it.
Move payroll and VAT in step with the ledger, not as an afterthought.

Decide whether to move, and when
Step 1: Tidy Sage before you move anything
Step 2: Choose how the data moves
Step 3: Set up Xero properly before you load data
Step 4: Check the migration against Sage
Step 5: Move payroll and VAT in step with the ledger
What Irish law says about your Sage data afterwards
Common mistakes we see
Our view: a migration is an accounting job, not an IT job
If you would rather have it done for you
How long does a Sage to Xero migration take?
Frequently asked questions
Sources

Decide whether to move, and when

Most Irish businesses we speak to leave Sage for the same few reasons: they want bank feeds that work without a desktop install, they want their accountant and their bookkeeper in the same file at the same time, or they have outgrown a single-user setup. If one of those is you, the move pays for itself in saved hours. If your only reason is a renewal price, check what else you will pay for: add-ons for payroll, payments or inventory are often where the monthly figure grows.

Timing matters more than most guides admit. The cleanest dates to switch are:

The first day of a VAT period. Irish VAT is usually filed bi-monthly, so a 1 January, 1 March, 1 May, 1 July, 1 September or 1 November start keeps each VAT3 inside one system. Our guide to the VAT3 return in Ireland explains what each return needs to contain.
The first day of your financial year. Your year-end accounts then come from a single system, and your accountant has one set of opening balances to prove.
Not mid-period, and not in the weeks before a filing deadline. You can do it, but you will be reconciling two systems against one return.

A realistic calendar for a small company is three to six weeks from decision to going live. A sole trader with a tidy file can be faster.

Step 1: Tidy Sage before you move anything

Whatever is wrong in Sage arrives in Xero, usually in a more confusing form. Spend a day on this before conversion.

Finish the bank reconciliations for every account up to the cut-off date, including credit cards and any PayPal, Stripe or loan accounts.
Clear unallocated items. Receipts and payments sitting on account, unmatched credit notes and old part-paid invoices are the usual source of debtor and creditor mismatches.
Post the accruals, prepayments and depreciation you would normally post, or agree with your accountant that they are done after the move.
Run the VAT return for the last period in Sage and file it. Make sure the VAT control account in the ledger agrees to the amount due to or from Revenue.
Review the chart of accounts. Merge duplicates, remove dead nominal codes and decide what you want your reports to look like. A migration is the cheapest moment you will ever get to redesign it.
Clean contacts. Delete duplicate customers and suppliers and fix missing VAT numbers.
Back up the file and store it somewhere other than the machine it lives on.

Write down the trial balance at the cut-off date, plus the aged debtors and aged creditors lists. You will need them in step 4.

Step 2: Choose how the data moves

There are two routes, and the right one depends on how much history you want in Xero.

	Manual import	Conversion service
What moves	Chart of accounts, contacts, opening balances, outstanding invoices and bills	Can include historical transactions, depending on the service and your agreement
Who does the work	You or your accountant	A specialist tool or provider
Best for	Small files, sole traders, new companies with one or two years of data	Several years of history, stock, multiple entities or heavy transaction volumes
Main risk	Keying errors, patchy history	Mapping decisions made without anyone who understands your business
Cost	Time	A fee for the conversion plus the time to review it

The manual route

Xero publishes its own guidance on converting from another accounting system, including the steps for importing data by hand. In practice, a manual move looks like this: set up the Xero organisation with the right conversion date, import the chart of accounts and contacts from CSV files exported from Sage, then enter opening balances as at the day before you start. Outstanding sales invoices and supplier bills are imported individually so that your ageing reports stay correct and customers can still be chased from Xero.

The trade-off is history. Your Xero file starts on the conversion date, and prior-year comparatives are limited to whatever summary you enter.

The conversion route

If you want full prior-period transactions in Xero, so that your profit and loss compares this year with last year without opening a second program, use a conversion tool. Xero lists these in its conversion apps directory, where providers describe which source systems they handle.

Before you pick one, ask four questions:

Which Sage product is yours (Sage 50, a cloud product, or something older), and is it supported?
How many months or years of transactions will move, and in what form: individual transactions or monthly journals?
What is the checking process, and will they give you the reconciliations?
What happens to attachments, inventory and fixed asset registers?

Monthly summary journals are cheaper and cleaner but give you less drill-down. Full transaction history is more useful for audit and for the year-on-year questions your accountant will ask.

Step 3: Set up Xero properly before you load data

A converted file is only as good as the organisation it lands in. Before the conversion or import:

Set the financial year end and the conversion date. Once balances are locked in, changing them is painful.
Enter your VAT settings: scheme, period, VAT number and the rates you use. If you use the cash basis or the Retail schemes, say so now.
Create or confirm the tax rates and accounts you need for reverse charge, zero-rated and exempt supplies.
Add users and decide who sees what. Your accountant should be invited from day one.
Connect the bank feeds, but do not accept feed transactions dated before your conversion date, or you will double-count items already in the opening balances.

If you are also changing your VAT position at the same time, for instance crossing a registration threshold, read our piece on VAT registration in Ireland first so the registration and the software switch don't collide.

Step 4: Check the migration against Sage

This is the step that separates a migration from a hopeful import. Do not sign off until each of these agrees at the conversion date.

Trial balance. Every nominal account in Xero equals the same account in Sage, or you can explain the difference through your mapping.
Aged debtors and creditors. The totals and the customer-by-customer or supplier-by-supplier balances match your saved reports.
Bank balances. Each Xero bank account shows the same balance as the bank statement and as Sage at the cut-off.
VAT control account. The balance agrees with what you owe or are owed, and the first Xero VAT return will pick up only post-conversion transactions.
Payroll liabilities. PAYE/PRSI and USC due to Revenue agree to your payroll records.
Fixed assets and loans. Cost, accumulated depreciation and outstanding balances agree to your register and lender statements.
Profit and loss for a prior period. If you converted history, a sample month or the full year should match the Sage report line for line.

Keep a one-page reconciliation sign-off with the date and the person who did it. It is useful at year-end and if anyone ever questions the figures.

Step 5: Move payroll and VAT in step with the ledger

The ledger is the visible part. Payroll and VAT are where mistakes are noticed by Revenue.

Payroll. Don't switch payroll software in the middle of a tax year unless you have to. Revenue's payroll reporting is submitted per pay run, so a mid-year change means making sure year-to-date pay, tax, PRSI and USC figures carry over exactly for each employee. If you are keen to move at the start of January, that is the natural break. Our payroll services are priced at €25 per month per employee or director, and we handle the year-to-date set-up when a client arrives from another system.

VAT. Run the last Sage VAT return, file it, then start the Xero VAT return from the first day after. Reconcile the VAT control account at the switch. If you are unsure about any of the mechanics, our VAT return services cover preparation and filing.

What Irish law says about your Sage data afterwards

This is the part that gets forgotten when the Sage subscription is cancelled. Under Irish rules, you must keep full and true records of transactions that affect your tax liability, including VAT, for a minimum of six years. Revenue's manual notes that failing to produce them on request can attract a penalty of €3,000 for each failure.

Changing software doesn't change that. Revenue's guidance on retaining tax records in electronic format is clear that records created or held electronically need to stay available in an intelligible electronic form. A pile of printouts isn't a safe substitute for an electronic original.

In practice, before you cancel Sage:

Export the full set of reports for every year still inside the retention window: trial balances, nominal ledgers, sales and purchase day books, VAT reports, bank reconciliations and payroll records.
Save them as PDF and as CSV or Excel so the data can be re-read and re-analysed.
Keep the Sage data file itself, with the version of the software noted, if you can still open it.
Store two copies in two places, with access for your accountant.
Diarise the date on which each year's records can be disposed of.

This is a general summary of Revenue's published guidance. If you have a specific question, such as how long to keep something unusual or how to deal with a company that is being wound up, ask your accountant.

Common mistakes we see

Switching mid-VAT-period and then filing a return from two systems.
Loading bank feed history on top of opening balances, so the same transactions are counted twice.
Copying a messy chart of accounts across because nobody had time to review it.
Cancelling Sage immediately and discovering a month later that a report was never exported.
Skipping the reconciliation sign-off, so errors surface at year-end when they are expensive to unpick.
Forgetting what the old system did quietly, such as recurring entries, bank rules, or invoice templates with your logo, terms and bank details.

Our view: a migration is an accounting job, not an IT job

We approach a move to Xero from the point of view of the compliance cycle, not the import tool. Bookkeeping, payroll, VAT and annual filings with Revenue and the CRO are connected, and a software change touches all of them at once. If the opening balances are right but the VAT set-up is wrong, the first return is wrong. If the ledger is right but payroll year-to-date figures are off, employees and Revenue see the error.

That is why our ACCA-qualified accountants work across the whole chain on a switch, and why we work in Xero, QuickBooks and Sage rather than insisting that one is right for everybody. Sometimes the honest advice is to wait until the next VAT period or tax year, and we would rather tell you that than rush a go-live that creates a clean-up bill.

Two rules guide how we do it. First, decide what you want from the reports before choosing how much history to convert. Second, treat the reconciliation sign-off as the deliverable, not the import. The software moving is just a means to getting numbers you and Revenue can both rely on.

— Stratancy

If you would rather have it done for you

If you have a Sage file, a deadline and no spare weeks, we can take on the whole move: clean-up, set-up in Xero, reconciliation, VAT and payroll switch-over, and the ongoing bookkeeping afterwards. Our packages for limited companies start at €159 per month for LTD Essential, and sole trader plans start at €129 per month for Sole Trader Essential, with the full list on our pricing page. Catch-up work for gaps in the books is from €35 per hour. If you want to talk it through first, start with our bookkeeping services.

How long does a Sage to Xero migration take?

The technical conversion can be quick, but treat that as one part of the project. Plan for the tidy-up in Sage, the Xero set-up, the conversion and the checks. For a small company that typically means a few weeks end to end, mostly driven by when your cut-off date falls and how clean the Sage file is.

Frequently asked questions

Can I move from Sage to Xero without losing my history?

Yes, if you use a conversion service that carries historical transactions, or if you keep the Sage reports and data alongside the new file. Xero's list of conversion apps shows providers that handle this. Either way, Revenue still expects you to retain your records for six years, so keep an electronic archive of the old data.

Do I need an accountant to convert Sage to Xero?

Not strictly, and a small, tidy file can be imported manually using Xero's own instructions. An accountant becomes worth it when you have VAT, payroll, stock or several years of history to carry across, because the checks are accounting judgements, not just data transfers.

Can I keep using Sage for payroll and Xero for the ledger?

Yes, it works, but you then need a reliable routine for posting payroll journals into Xero and reconciling the PAYE/PRSI liability. Many businesses find it simpler to move payroll when the ledger moves, or at the start of the tax year.

What is the best date to switch?

The first day of a VAT period or financial year is usually cleanest, because each return and set of accounts then comes from one system. Avoid switching in the middle of a period or just before a filing deadline.