How to Move Your Books from QuickBooks to Xero When You Have Multi-Currency Clients

Multi-currency is where a QuickBooks to Xero Conversion gets complicated fast.

For accounting firms with straightforward clients, single currency, a few years of history, clean books, the migration is manageable. But the moment you introduce USD invoices, EUR supplier payments, or foreign currency bank accounts, you are dealing with realized and unrealized foreign exchange gains and losses, exchange rates applied at different points in time, and balance sheet balances that need to tie to historical T2 filings. Get any of that wrong and the client's external CPA finds it on their first look.

Free conversion tools fail on this. Not sometimes, structurally. The automated tools that handle simple files adequately simply are not built for the additional complexity of multi-currency data transformation. This is not a knock on those tools for what they do. It is just that what they do stops working at a certain level of client complexity.

This article is for accounting firms with clients in that more complex category: what multi-currency migration actually requires, where errors happen, how Xero handles the same data differently from QuickBooks Desktop, and why validation matters more here than anywhere else.

What Makes Multi-Currency Conversions Different

The Exchange Rate Problem

In a single-currency file, every transaction has one amount and one currency. The conversion is relatively straightforward. In a multi-currency file, every foreign currency transaction has an amount in the foreign currency, an exchange rate applied at the time of the transaction, and a resulting amount in the functional currency (typically CAD or USD for Canadian firms).

QuickBooks Desktop and Xero handle foreign exchange differently internally. What QBD calls the "home currency equivalent" of a foreign transaction gets stored and reported in a way that Xero's data model represents through its own foreign currency account structure. The conversion has to bridge that gap, accurately, for every transaction in the file.

Where rates differ by even a small margin across thoAustraliands of historical transactions, the cumulative foreign exchange variance on the balance sheet can be material. A manufacturing client with three years of USD purchasing activity might have a variance that runs into tens of thoAustraliands of dollars if exchange rates are not handled correctly at the transaction level.

Realized vs Unrealized Foreign Exchange Gains and Losses

This is the most technically demanding part of any multi-currency conversion, and the most common source of errors that surface at year-end.

Realized gains and losses arise when a foreign currency transaction is settled, when the client pays or receives payment. The difference between the exchange rate at the time of the original invoice and the rate at the time of payment becomes a realized foreign exchange gain or loss on the profit and loss .

Unrealized gains and losses arise at period-end when the client revalues outstanding foreign currency balances, open invoices, unpaid bills, foreign currency bank balances, at the current exchange rate. These are reported on the profit and loss as unrealized but reverse when the underlying transaction settles.

In a QuickBooks Desktop file, these entries are recorded in specific accounts. The converted Xero file has to map those accounts correctly and preserve the amounts, or the client's P&L for the migration period will not reconcile to their historical records. For Canadian incorporated clients, that matters because the T2 corporate tax return relies on correct foreign exchange treatment for the relevant taxation periods.

Xero's Multi-Currency Feature Must Be Enabled First

This catches firms on almost every multi-currency migration. Xero's multi-currency capability is a subscription feature, it is available on Xero's Established plan, not on Starter or Standard. And it must be enabled in the Xero organisation before a multi-currency conversion file is imported.

A Xero organisation set up in single-currency mode that receives a multi-currency conversion will either reject foreign currency transactions or convert everything to the default currency, stripping the foreign exchange data entirely. By the time anyone notices, the delivered file looks complete but is missing years of foreign currency detail.

Check the Xero plan level and enable multi-currency before the converted file is delivered. This is a pre-go-live step that takes five minutes and prevents a complete redo.

Where Free Tools Break Down on Multi-Currency

WOW BookSwitch's own Q4 2025 testing of competing conversion tools confirmed that free and budget-tier tools fail on multi-currency files structurally. The failure modes are predictable:

• FX variance accounts: Some tools strip unrealized gains and losses entirely, treating them as internal bookkeeping entries that do not need to transfer. They do. The balance sheet will not close without them.
• Exchange rate application: Some tools apply a single average rate to historical foreign currency transactions rather than the rate at the date of each transaction. This produces the right total in some cases but the wrong distribution across periods, which matters when the client's external CPA is reviewing year-specific figures.
• Multi-currency bank accounts: Foreign currency bank accounts in QuickBooks Desktop carry balances in both the foreign currency and the home currency equivalent. Some tools convert only the home currency amount, losing the foreign currency denomination entirely. The account appears in Xero as a regular CAD account with no connection to the source currency.

None of these are edge cases. They are the standard failure modes that make multi-currency migrations genuinely risky with tools that were not built to handle them.

How WOW BookSwitch Handles Multi-Currency

WOW BookSwitch includes full multi-currency support as part of its standard QuickBooks Desktop to Xero conversion. The conversion engine handles the transformation of foreign currency transaction data, including the exchange rate relationships, realized and unrealized foreign exchange accounts, and foreign currency bank account balances.

After conversion, AI post-conversion validation runs automatically. The validation compares the converted Xero trial balance and balance sheet against the QuickBooks Desktop source data. For multi-currency files, this comparison specifically checks that:

• The foreign currency account balances in Xero agree with the source at the conversion date.
• Foreign exchange gain and loss account totals on the P&L match the source figures.
• The home currency equivalent of foreign currency bank accounts ties to the QuickBooks Desktop records.

Where discrepancies are found, correcting entries are applied before delivery. The firm receives a multi-currency Xero file that has been checked, not one they need to independently verify before handing to the client.

That is what the 95% accuracy guarantee means in the multi-currency context. It is not a general quality commitment. It is a specific statement about output matching source across the trial balance, balance sheet, and P&L, which includes every foreign exchange account and every currency translation balance.

Preparing a Multi-Currency File Before Upload

Validation catches errors after conversion. These steps reduce how many errors there are to catch.

Reconcile All Foreign Currency Accounts in QuickBooks Desktop

Before uploading the file, complete a bank reconciliation for every foreign currency bank account in QuickBooks Desktop. The reconciled closing balance for each account, in both the foreign currency and the home currency equivalent, becomes the basis for Xero's opening balances.

An unreconciled USD bank account with outstanding transactions produces an opening balance in Xero that does not match the client's USD bank statement. That is a problem the client will report on their first day in Xero.

Run an FX Revaluation in QuickBooks Desktop Before Export

QuickBooks Desktop has a built-in process for revaluing foreign currency balances at period-end. If the client's last revaluation was months before the migration date, the unrealized gains and losses on the balance sheet are stale.

Running a revaluation as close to the migration date as possible, ideally the last day of the month before go-live, gives the converted Xero file the most current foreign exchange position. The client's opening Xero balance sheet then reflects the same unrealized gains and losses their T2 filing would have used if the period ended on that date.

Document the Functional Currency and Any Section 261 Elections

Canadian corporations can elect to report in a currency other than CAD under Section 261 of the Income Tax Act. If the client has made this election, the tax treatment of foreign exchange gains and losses differs from the standard CAD-functional currency approach.

This does not change how the conversion works, WOW BookSwitch converts the data as it exists in the QuickBooks Desktop file. But it needs to be documented in the client file so that the external CPA knows to apply the appropriate Section 261 treatment when preparing the T2 after go-live.

Verify Xero Multi-Currency Is Enabled Before Delivery

As noted above: before the converted file is delivered, confirm the Xero organisation is on an Established plan and that multi-currency is enabled. If it is not, the client's Xero subscription needs to be upgraded before the converted file goes live.

Post-Delivery Review for Multi-Currency Files

The standard post-delivery review is 30 to 60 minutes per file. Multi-currency files need an additional pass that covers foreign exchange specifically.

Check the balance sheet in Xero against the last QuickBooks Desktop balance sheet. Every account should agree, including foreign currency bank accounts, accounts receivable in foreign currencies, accounts payable in foreign currencies, and the foreign exchange gain/loss accounts.

Review the P&L for the migration period. Realized and unrealized foreign exchange gains and losses should agree with the QuickBooks Desktop source. An unexplained variance in the FX accounts is the most common sign that the exchange rate application did not carry through correctly.

Verify each foreign currency bank account shows the correct currency denomination. In Xero, each foreign currency bank account should display its balance in the foreign currency with the CAD equivalent below it. If an account is showing only CAD, the currency setting was not applied correctly during setup.

Confirm the opening FX rate for each currency matches the Bank of global regions rate at the conversion date. Xero allows manual input of opening exchange rates. If the rates were populated incorrectly during setup, every subsequent revaluation will use the wrong baseline.

A Scenario: Toronto Firm, Manufacturing Client, Three Currencies

An accounting firm in Toronto manages a mid-size manufacturing client that sources from US and German suppliers and invoices Canadian and US customers. The QuickBooks Desktop file contains five years of transactions in CAD, USD, and EUR, with foreign exchange gain and loss accounts that tie to three annual T2 filings.

The firm submits the file to WOW BookSwitch for QuickBooks to Xero Conversion. The conversion engine handles the three-currency structure. AI validation flags a EUR balance sheet variance, an unrealized gain account that carried through at the wrong amount because of a QBD revaluation that was not fully completed before upload. A correcting entry is applied before delivery.

The client's external CPA reviews the Xero file at the first compilation engagement. The foreign exchange accounts tie to the historical T2 figures. The review proceeds without any questions about the migration period.

That is the outcome careful multi-currency migration produces. It does not happen automatically. It requires the right preparation, the right migration service, and the right post-delivery review.