September 12, 2026

Sage 50 Canada to QuickBooks Online: what Intuit’s Dataswitcher path leaves behind, and the five cases where a managed conversion pays

The short answer: Intuit’s own Canadian migration path for Sage 50 Canada into QuickBooks Online, run through the Dataswitcher tool, is a good fit for a clean single-currency file with no payroll history you need to keep. Intuit’s help article for it (updated in 2026) lists nine data types it does not transfer, and three of them, multicurrency, payroll records and projects, are exactly the ones a Canadian business is most likely to have. This post sets out what the article says the tool does and does not carry, which of the limitations you can work around before you upload, and the cases where a managed Sage 50 to QuickBooks conversion is the cheaper path once you count the rebuild.

What Intuit’s path does

Intuit’s article “Converting Sage 50 data to QuickBooks Online” describes a seven-step process: review the pre-migration checklist, prepare the Sage 50 file and a fresh QuickBooks Online company, give consent, choose how many years of data and any add-ons such as inventory, upload the Sage 50 backup via secure server to Dataswitcher, review the results with the post-migration checklist, then start using QuickBooks Online. Conversion takes on average up to 72 hours from upload. A migration report comparing balance sheet, profit and loss and ageing between source and destination is attached to a supplier record called Dataswitcher in the new file.

Three pre-migration rules from the same article are worth knowing before you start, because they are not optional: the QuickBooks Online company must be brand new (a file that has been used in any way has to be cancelled and restarted); every bank and credit card account should be reconciled to the latest statement first; and if you are on cash-basis accounting, Intuit advises migrating directly after a sales tax period has closed and been reconciled, because partial paid invoices make the post-conversion work “significant.” The file must also pass Sage 50’s Maintenance → Check Data Integrity; a file that fails can produce non-matching trial balances for several years after conversion.

What it leaves behind, in Intuit’s words

The article’s list of Sage 50 data that “cannot be transferred at this time” is: budgets, multicurrency, memorized transactions, invoice templates and other templates, sales orders, payroll records, projects, attachments, and non-posting entries such as estimates. The limitations section adds behaviour that is subtler than an omission:

Cash and cheque refunds from suppliers post as plain journals with no link to the customer or supplier.
Reversed journals are not posted, and next-year (forward) journals are not posted either; both must be added by hand.
Payments may be attached to “dummy” customers or suppliers to align receivables and payables history, and manual journals on the AR or AP control accounts land on suspense accounts.
Opening balances that Sage 50 let you post directly to an account may be sent to retained earnings in QuickBooks, so retained earnings has to be checked after the load.
Departments only. With the paid classes-and-locations option the migration is done as journals only, projects are not converted at all, and department balances on retained earnings may be wrong if old journals were purged in Sage 50.
Items carry codes, names, current stock and prices but not their income and asset accounts.
Chart of account numbers of seven digits or more fail the migration, and renamed system accounts (Retained Earnings, Accounts Receivable, Accounts Payable) must be renamed back before upload.
A fiscal year that does not start on the first of a month cannot be represented; Intuit’s example is a 5 January start, which QuickBooks Online will not accept.

The Canadian specifics

Two of the limitations bite harder in Canada than they would elsewhere. Sales tax. Sage 50 Canada tracks GST/HST in two accounts, and four in Québec where QST is separate; QuickBooks Online uses a single GST/HST Payable account, and Intuit’s post-migration checklist makes consolidating the Sage 50 tax accounts into it a required step, followed by reconciling any receivables and payables discrepancies it creates. The Canada Revenue Agency requires almost all registrants to file GST/HST returns electronically for periods ending in 2024 and later; monthly and quarterly returns are due one month after the period end, most annual returns three months after fiscal year-end. Intuit’s own advice is to file the return for the period you are leaving before you upload, and to set the province, CRA business number and filing frequency in QuickBooks Online before posting anything; the home province, it notes, cannot be corrected afterwards. Before cutover, also confirm your reporting period and method: our GST/HST switching guide covers the Quick Method, which QuickBooks Online does not calculate for you.

Payroll. Payroll records do not transfer. That does not stop a migration, but it fixes its timing: CRA’s deadline for T4 slips is the last day of February after the calendar year, and the slips are built from year-to-date figures that will live only in Sage 50 if you convert mid-year. A calendar-year cutover lets Sage 50 produce the T4s for the old year and QuickBooks Online payroll start clean on 1 January. A mid-year cutover means keeping Sage 50 readable until the T4s are filed, or loading year-to-date payroll totals by hand and agreeing them to Sage 50’s reports.

Where the free path is enough

A single-currency Sage 50 Canada file, outside Québec or with QST handled by your accountant, no payroll or payroll you are happy to leave in Sage 50 for T4 season, no projects, opening balances that came from a prior year-end rather than manual entries, account numbers under seven digits, and a fiscal year starting on the first of a month. If every one of those is true, Intuit’s path is a reasonable route, provided someone owns the post-migration checklist: fiscal start month, the five report comparisons, sales tax setup and consolidation, and marking every pre-conversion bank transaction as reconciled before online banking is connected.

Where a managed conversion is cheaper once you count the rebuild

USD and CAD in one file. Multicurrency is on the not-transferred list. Canadian books with US customers or suppliers are routine, and re-keying foreign-currency receivables, payables and revaluations is the largest manual job on this page.
Projects or jobs that customers still expect to see on invoices. Projects are not converted; only departments are. A contractor or agency loses the job history it reports on.
Québec. Four tax accounts collapsing into one payable account, with QST filed separately to Revenu Québec, is where the tax consolidation step generates the most discrepancies.
A file that fails Check Data Integrity or has years of purged journals. Intuit warns that both produce balance and trial-balance mismatches; a managed conversion reconciles those before the load rather than after.
More history than you want to pay the tool’s per-year tiers for, or transaction-level detail on receivables and payables that the dummy-customer workaround would obscure.

In each case the managed route carries the same lists and balances plus the currency, project and payment-application detail, reconciled to Sage 50’s trial balance, ageing and GST/HST reports at the cutover date, quoted fixed-price from a backup.

Before you decide

Run Maintenance → Check Data Integrity and note the result.
Print the trial balance, aged receivables, aged payables and the sales tax report at the intended cutover date.
Count currencies in use, active projects, open sales orders and the number of employees on payroll.
Check the longest account number and the fiscal start date.
Pick the cutover against the GST/HST period end and, if you run payroll, against the calendar year.

Send the five answers with a quote request and we will tell you which route fits and what the managed one costs.

Frequently asked questions

Does Intuit’s Sage 50 Canada to QuickBooks Online migration carry payroll?

No. Intuit’s help article lists payroll records among the data that cannot be transferred. Year-to-date payroll stays in Sage 50, which is why a calendar-year cutover is simpler: Sage 50 issues the T4s, due the last day of February, and the new payroll starts clean on 1 January.

What happens to GST/HST accounts in the migration?

Sage 50 Canada uses two sales tax accounts, or four in Québec, while QuickBooks Online uses one GST/HST Payable account. Intuit’s post-migration checklist requires consolidating the Sage 50 accounts into it, setting the province, CRA business number and filing frequency, and reconciling any receivables and payables discrepancies the consolidation creates.

Can Dataswitcher convert a multicurrency Sage 50 Canada file?

Not according to Intuit’s article, which lists multicurrency among the data types that cannot be transferred. A file with USD and CAD transactions either has its foreign-currency history re-entered by hand after the migration or goes through a managed conversion that rebuilds it and reconciles it to Sage 50’s reports.

How long does the Intuit migration take?

Intuit says up to 72 hours on average from upload to Dataswitcher, with a migration report attached to a Dataswitcher supplier record in the new file. The post-migration checklist, including tax consolidation and marking historical bank transactions as reconciled, is additional work done by you or your bookkeeper.

Weighing Xero as well? Read Sage 50 to Xero vs Sage 50 to QuickBooks for the side-by-side.