How to migrate from Sage Accounting to Odoo

Bring your Sage Business Cloud Accounting customers, products, stock, invoices and ledger into a new Odoo 20 instance. Sage is only read, never changed.

Updated . 6 min read

You can move your books out of Sage Business Cloud Accounting yourself, from your dashboard, in a few minutes. We create a new Odoo 20 instance for you as a free trial, copy your Sage data into it section by section, and then check every total against Sage and show you the result.

Nothing in Sage is changed. We ask Sage for read access only, so we can read your data but cannot create, edit or delete anything there. You keep working in Sage the whole time, and you decide later whether to go live on Odoo.

Before you start

  • A Sage Business Cloud Accounting login for the business you want to move.
  • You need to be the person who can approve access for that login. Sage shows an "Authorise Application" screen during the migration, and whoever is signed in to Sage at that moment is the one who approves it.
  • An account here. The migrated instance is a free trial, like any new instance, so you do not need to pay anything to try this.
  • Nothing to install, and no export file to prepare. We read Sage through Sage's own API while the migration runs.

Step 1: Start a new project

In your dashboard, click New Project and choose Migrate from another system.

The Start a new project dialog, with the Migrate from another system card

Step 2: Choose Sage Accounting

Pick Sage Accounting as the system you are moving from. The wizard has five steps, and the sidebar keeps track of where you are; you can go back at any point before you start the migration.

Step 1 of the wizard: choosing Sage Accounting as the system to migrate from

Step 3: Choose what to bring over

There are thirteen kinds of data, and they all start selected. Leave them as they are unless you have a reason not to.

Step 2 of the wizard: the thirteen kinds of Sage data, with full history pills

Six of them are your master data, the things the rest of your books refer to:

  • Company & Chart of Accounts
  • Taxes
  • Customers & Suppliers
  • Products & Services
  • Opening Stock & Reordering Rules
  • Opening Balances

The other seven are marked full history, which means they also bring your past records rather than only what is needed to start working:

  • Sales Invoices & Credit Notes
  • Purchase Bills & Credit Notes
  • Customer & Supplier Payments
  • Bank Transfers, Other Payments & Receipts
  • Journal Entries
  • Opening Balances & Other Ledger Postings
  • Attachments

Clear every full-history item and you get a clean Odoo that is ready to trade: your customers, suppliers, products, stock and tax rates, with one opening balance per account so the books still add up. Keep them and you get the documents behind those balances as well. That is also why, in a migration that brings history, the Opening Balances section finishes with nothing to show: the history itself produced the balances, so there is no opening entry left to post.

Step 4: Connect Sage and approve read access

Click Connect Sage. A new tab opens on Sage's own site, where you sign in to Sage if you are not already. We never see your Sage password.

Step 3 of the wizard: the Connect Sage button

Sage then asks you to approve the connection. The screen names the app requesting read access, and the business it will read.

Sage's Authorise Application screen, granting read access

Two things are worth knowing about this screen:

  • Read access means read access. It lets us list and read your records. It does not let us post, edit or delete anything in Sage, and we do not.
  • Sage grants access at the login level, not per business. As Sage's own wording says, if that login is given more businesses later, the approval covers those too. If that is not what you want, use a Sage login that only has the business you are migrating. Whatever you approve, we only ever read the one business you pick in the next step, and you can withdraw the connection in Sage at any time.

Approve, and the tab closes by itself. Back in the wizard, choose the business to migrate if your login has more than one.

Step 5: Name the new instance and start

Give the new instance a name, which becomes its web address, and set the email and password you will sign in to Odoo with. The last step shows a summary; click Start the migration and you can leave the page. Nothing has been created in Odoo, and nothing has been read from Sage, until you click it.

How long it takes

A few minutes in all. Creating the Odoo instance takes a couple of minutes, and copying a small business's books usually takes less than that again. A larger business takes longer, and the progress page tells you what is happening either way: one line per kind of data, with how many records were created, skipped or failed. You can close the page and come back to it; the migration keeps running.

The finished migration, with every section ticked and its record counts

The verification checks are the part to read

When the data is in, we count it again, on both sides. The verification table compares your old system with the new Odoo: how many ledger accounts, tax rates, customers, suppliers, products and documents there are, what the stock quantities add up to, and what each account's balance is. The last of those is the one accountants care about: your trial balance in Odoo has to match the one in Sage.

Verification: 32 of 32 checks match, with the comparison table

"Verification · 32/32 checks match" means every one of those comparisons agreed. If a check does not match, it is listed with both numbers and the accounts involved, so you can see exactly what differs rather than discovering it in three months. We never post an adjustment to make a total agree.

A few differences are normal and not errors. Odoo gives your invoices its own numbers, and keeps the Sage number in the document's reference field. Sage's accounts are created alongside the ones a new Odoo starts with, so you may see a slightly longer chart of accounts than in Sage.

If something goes wrong

A migration that fails can be retried from where it stopped, and it tells you why it failed in plain words. If you would rather start over, Cancel and remove deletes the half-finished instance and everything in it.

In every one of those cases your Sage account is untouched, because we only ever read from it. Your Sage login details are stored encrypted while the migration runs and are erased when it finishes, and the connection to Sage is withdrawn at the same time.

If you are stuck, or a check does not match and you cannot see why, contact us with the name of the instance and we will look at the run with you.

What this does not cover yet

We would rather tell you the limits than have you find them:

  • Sage Accounting migrations are proven on UK businesses trading in pounds. If your Sage business is in another country or works in several currencies, talk to us before you rely on the result.
  • Settlement discounts on payments and combined tax rates are not migrated, so a business that uses them will see a difference in the verification table.
  • The migration creates a new Odoo 20 instance. It does not merge your Sage data into an Odoo you already use.

Migrating from ERPNext works the same way, from the same place in your dashboard.

Rather not run the server yourself?

Get managed Odoo hosting with backups, SSL, monitoring and updates handled for you. Free for 10 days.