The pitch for free migration tools is hard to argue with. Jet Convert has processed over 100,000 QuickBooks to Xero conversions. It costs nothing. Xero recommends it. For a lot of firms, it works exactly as advertised.
But there's a category of client file where free tools fail consistently and for reasons that have nothing to do with bad luck. Multi-currency files. And the failure isn't random. It follows the same pattern every time, in the same four places, for the same underlying reason: these tools were never built to handle what multi-currency files actually contain.
If you're managing a QuickBooks Desktop to Xero migration for a client with foreign currency exposure, here's what you need to understand before you start.
Why Multi-Currency Files Are Different
A single-currency QuickBooks Desktop file is, at its core, a list of transactions in one denomination. The conversion job is to move that list from one system to another with the right account mappings.
A multi-currency file is structurally different. Every foreign currency transaction carries two amounts: the original currency figure and the home currency equivalent at the exchange rate on the transaction date. On top of that, the file contains period-end revaluation entries that update outstanding balances to the current rate, realised gains and losses when foreign transactions settle, and unrealised gains and losses on balances still open at period end.
All of that needs to land in Xero correctly. Not approximately. Correctly. The trial balance, balance sheet, and profit and loss need to agree with the source QuickBooks Desktop file at the conversion date.
Free tools were optimised for the simple case. Multi-currency is not the simple case.
The Four Places Free Tools Break Down
1. Unrealised FX accounts get stripped
When a client holds an open USD invoice at year end and the exchange rate has moved since the invoice date, QuickBooks Desktop books the difference to an unrealised foreign exchange account. This sits on the profit and loss as an unrealised gain or loss until the invoice is paid.
Some free tools treat these entries as internal bookkeeping that doesn't need to transfer. So they drop them. The result: the converted Xero file is missing those FX account balances. The balance sheet is out by exactly that amount. The firm has to trace back to find it, which on a multi-year file with regular revaluations can take days.
2. Exchange rates get averaged instead of matched
Every foreign currency transaction should carry the exchange rate from the date it occurred. That's the correct rate for a historical transaction, and it's what reconciles the profit and loss year by year.
Some free tools simplify this by applying a single average rate across all transactions in the file. The totals come out roughly right, but the period-level figures don't match. Run a profit and loss comparison for a prior year between the QBD source and the converted Xero file, and the numbers drift. For a client with a pending CRA review or external financing, roughly right is not usable.
3. Foreign currency bank accounts lose their denomination
A USD bank account in QuickBooks Desktop carries two balances: the amount in USD and the CAD equivalent. Both matter. The USD balance is what reconciles against the bank statement. The CAD equivalent flows to the balance sheet.
Some tools migrate only the home currency amount. The account arrives in Xero as a CAD account. The client can't reconcile it against their USD bank statement. Every future revaluation runs incorrectly because Xero doesn't know the account holds USD. Fixing this after the fact means rebuilding the account from scratch.
4. Xero multi-currency isn't enabled before delivery
This one catches firms at the setup stage rather than in the conversion itself, but it's worth naming because it's common. Xero's multi-currency capability sits behind a plan requirement, the Established plan in most regions, and it has to be manually enabled in the organisation settings before a multi-currency converted file goes live.
A Xero organisation sitting in single-currency mode that receives a multi-currency conversion will either reject foreign currency transactions or silently convert everything to the default currency. By the time the firm notices, the converted file looks complete but is missing years of foreign exchange data. The fix is to start over with multi-currency enabled.
What Budget Tools Do Instead
Budget-tier tools like MMC Convert sit between free tools and professional services, priced around $289 per conversion. They handle more complex files than Jet Convert. But their approach to multi-currency is worth understanding before you commit to them.
MMC Convert handles foreign exchange variance through what they call a "Historical Adjustment" account. FX discrepancies that can't be resolved at the transaction level are absorbed into a single adjustment account, producing a balance sheet that closes. Their FAQ documents this as expected behaviour.
Which means the balance sheet balances, but the foreign exchange account detail doesn't agree with the source QuickBooks Desktop records. For a client who has been tracking USD receivables and GBP supplier accounts for five years, that's a material gap. The firm accepts a file where the numbers close but the history is wrong.
WOWzer's own Q4 2025 direct testing confirmed these limitations are structural across free and budget tools. They're not bugs scheduled for a patch. They reflect design decisions about what the tool was built to handle.
Why This Matters More Than It Used To
The QuickBooks to Xero migration deadline is real and fixed. QuickBooks Desktop 2024 reaches end of support in September 2027. For firms with multi-currency clients in their portfolio, this isn't a decision they can defer until the problem feels urgent.
Multi-currency files take longer to assess, scope, and validate. A migration that produces a balance sheet discrepancy three months after delivery has a very short path back to the firm that handled the conversion. The client's CPA is on the hook for the clean-up, and if the error spans prior tax years, the remediation goes well beyond fixing a Xero account.
Getting the foreign exchange data right the first time isn't a preference. It's a professional obligation.
A Real-World Scenario
Consider a mid-size Toronto accounting firm with 80 QBD client files. Of those, they flag 30 as having meaningful multi-currency exposure: USD-denominated receivables, EUR supplier accounts, or clients holding foreign currency bank accounts.
They run the 30 multi-currency files through a free tool. Twenty-three come back clean enough. Seven have problems: missing unrealised FX accounts, exchange rate averaging on prior-year transactions, or a USD bank account that arrived as CAD. Remediation on those seven files runs between two and five days each at a senior bookkeeper rate. The cost of the "free" conversion on those seven files, in staff time alone, exceeds what a professional migration service would have charged for all thirty.
This is the pattern firms report across the board. Free tools work on the files they were designed for. On multi-currency files, the risk is back-loaded.
What a Professional QBD Migration to Xero Actually Looks Like
A professional QuickBooks Desktop to Xero migration solution handles multi-currency differently because the design intent is different. The job isn't to move data. It's to deliver a Xero file that agrees with the QuickBooks Desktop source.
That means applying transaction-date exchange rates, not averages. Preserving unrealised and realised FX accounts with amounts that match the source. Migrating foreign currency bank accounts with both the foreign denomination and the home currency equivalent intact. Running post-conversion validation that compares the trial balance, balance sheet, and profit and loss between the QBD source and the converted Xero output. Applying correcting entries where discrepancies are found before delivery.
The 95% accuracy guarantee from a service like WOW BookSwitch means something specific in the multi-currency context. It's a statement about the converted output agreeing with the source across every account, including every foreign exchange account, before the file leaves the service.
What WOW BookSwitch Handles
WOW BookSwitch processes multi-currency QBD to Xero conversions at $399 USD per file. The base package covers the current fiscal year plus three prior years. Extended history is available at $100 USD per additional year. Turnaround is 1 to 3 business days. AI validation runs after every conversion, flagged discrepancies go to a trained accountant before delivery, and every file includes 6 months of free WOW Backup and Restore.
Honest scope: bank feeds, payroll history, attachments, and memorised transactions do not transfer in any QuickBooks to Xero conversion. GIFI code mapping is coming soon but not live yet.
Volume discount of 15% applies at 30 or more files, bringing the effective rate to approximately $339 per file.
What to Do Next
If you have multi-currency client files in your QBD portfolio, the first step is to flag them. Pull your client list, mark every file with foreign currency exposure, and treat those separately from your single-currency files when you're choosing a migration path.
Single-currency files can often go through a free tool without issue. Multi-currency files need a service with documented multi-currency support and a validation step that runs before delivery, not after.
The September 2027 deadline is fixed. The queue for professional migration services is filling up for Q4 2026 and Q1 2027. The earlier you scope your multi-currency files, the more options you have.
