Multi-Currency Bank Statement Import into QuickBooks Online

Yes, QuickBooks Online can take transactions from a foreign bank account, but two things have to be true first: multicurrency has to be switched on in Account and Settings, and the bank account in your chart of accounts has to be created in that foreign currency. QuickBooks Online will not read a PDF statement directly, so the working route for most foreign accounts is converting the statement PDF into a .qbo Web Connect file and uploading it to that foreign-currency account. Multicurrency is available on Essentials, Plus and Advanced, and Intuit says it cannot be switched back off once enabled.

Last updated July 2026.

What you need before you start

Line these up first. Doing them out of order is the biggest cause of a re-do on this job.

• QuickBooks Online on Essentials, Plus or Advanced. Multicurrency is not offered on Simple Start.
• A settled home currency, since you cannot change it after multicurrency is on.
• The full statement PDF, showing the opening balance, the closing balance and every line between.
• Confirmation of the currency the statement is denominated in, which is not obvious on statements from banks that report in two.

Does QuickBooks Online support multiple currencies?

Yes, on Essentials, Plus and Advanced, and it is off by default. You turn it on under Settings, then Account and settings, then Advanced, then Currency. Simple Start does not include it. Plan lineups shift, so confirm in your own settings rather than trusting a comparison chart.

The confirmation box you tick is not decorative. Intuit states that once multicurrency is on you cannot turn it off, and your home currency locks at the same moment. Intuit also notes it inactivates the cash flow planner, and that QuickBooks Bill Pay and QuickBooks Payments are not compatible with multicurrency.

How do I add a foreign currency bank account in QuickBooks Online?

In your chart of accounts, select New, choose Bank as the account type, pick the detail type, and set the Currency field to the statement's currency before saving. That field only appears once multicurrency is enabled, and every account holds exactly one currency.

One account, one currency, governs everything downstream. If your bank gives you one login covering a euro balance and a dollar balance, that is two QuickBooks accounts. Customers and vendors work the same way, and Intuit's guidance for changing an assigned currency is to create a new record. Set the currency before the first import, because there is no edit button afterward and the fix is a second account plus a re-import.

What exchange rate does QuickBooks use, and can I override it?

QuickBooks Online downloads market exchange rates automatically and applies them by transaction date. You can override the rate on a single transaction by typing your own figure in the Rate field, or set your own rate in the currencies list, which QuickBooks then applies to foreign-currency transactions entered that day.

Intuit has cited third-party rate providers and a periodic refresh through the day, so treat any named provider or interval as version-dependent. What is stable: automatic rates by default, manual override available, one stored rate per day per currency. Use the override when your bank printed its own converted figure, since it charged a spread the market rate does not reflect.

How does QuickBooks post exchange gains and losses?

QuickBooks Online separates realized from unrealized. Per Intuit's home currency adjustment documentation, adjustments against Accounts Receivable and Accounts Payable show as unrealized gain or loss, while adjustments against accounts such as bank and credit card accounts post as realized foreign exchange gain or loss.

Realized movement is cash: you invoiced a UK customer at one rate, the money landed weeks later at another, and the difference is real. Unrealized is the paper revaluation of a balance you still hold. Intuit's community guidance notes unrealized amounts sit outside the trial balance and get reviewed through the transaction detail report.

Does a .qbo Web Connect file carry a currency?

Yes. The .qbo format is a flavor of OFX, and the statement block carries a CURDEF tag holding a three-letter code such as USD, EUR or GBP. QuickBooks reads that tag on import, and a CURDEF that does not match the target account's currency is a common cause of rejected or misread imports.

This is where DIY conversion quietly fails. A tool that hard-codes USD into CURDEF imports a euro statement as though every figure were dollars, and nothing warns you, because the file contains no contradiction. Any converter you use for a foreign account has to write the real currency in. The comparison of QuickBooks bank import file formats covers QBO, QFX, OFX and CSV.

How do I import a foreign bank statement into QuickBooks Online?

Three routes exist. Foreign banks are far less likely to appear on Intuit's connectable institution list than US banks, which is why file conversion usually ends up doing the work.

For a euro or sterling account at a bank Intuit has never heard of, the third route is the normal method. Our guide to importing a bank statement into QuickBooks Online covers the upload side.

How to convert a foreign bank statement to a .qbo file

1. Turn on multicurrency under Settings, then Account and settings, then Advanced, then Currency. Confirm your home currency before you tick the box, because it locks.
2. Create the bank account with the foreign currency selected. Name it clearly, for example "Barclays GBP Current" rather than "Bank 2".
3. Download the full statement PDF, not a screen printout, so the opening and closing balances are on the page.
4. Upload it to the QBO converter and set the output currency to match the statement and the account. Scans and phone photos work too.
5. Split anything long. Uploads cap at 1,000 transaction lines and 350KB, so a busy twelve months usually becomes several files by date range.
6. Check the balance before importing. The converter totals every transaction it read and compares that against the closing balance printed on the statement, warning you if they disagree rather than handing you a file that is quietly short two transactions.
7. In QuickBooks Online, open Bank transactions, select the foreign-currency account, choose Upload from file, and pick your .qbo file.
8. Review in the For review tab, categorize, then reconcile against the closing balance.

Troubleshooting the failures that actually happen

Currency mismatch on import. Either QuickBooks rejects the file or, worse, accepts it and treats foreign amounts as home-currency amounts. Check the account's currency and the file's currency; both must agree. If the file is wrong, rebuild it, because you cannot fix it by editing the account. If it is refused with an error instead, the walkthrough of why QuickBooks will not import a .qbo file covers the usual causes.

Your converted figure disagrees with the bank's. The downloaded rate is a market rate; your bank applied its own rate with a margin, and on a wire it may have taken a fee too. Where the bank printed the converted amount, override the rate on that transaction so the books match the cash. If most of those foreign-currency lines are supplier payments, automating the payables side removes much of this entry work upstream, before it ever reaches the statement.

Duplicates where a feed and a file overlap. If the account is connected and you also upload history, the backfill collides with your file. Note the earliest date the feed pulled, then cut your files to end the day before. QuickBooks catches some duplicates on matching, but not all.

Frequently asked questions

Can I use multicurrency on QuickBooks Online Simple Start?

No. Multicurrency is available on Essentials, Plus and Advanced only, so a foreign-currency bank account cannot be tracked properly on Simple Start. You would need to upgrade to at least Essentials. Note also that once multicurrency is enabled, that company can no longer be downgraded to Simple Start.

Can I turn multicurrency off after enabling it?

No. Intuit states multicurrency cannot be switched off once on, because the file starts recording conversion data that has to keep being accounted for. Your home currency locks at the same time. If you enabled it by mistake on a company with no foreign activity, the only clean reset is a new company.

Will QuickBooks convert my foreign statement into US dollars for me?

It converts for reporting, not for the account itself. The foreign-currency account keeps its own currency, and QuickBooks applies an exchange rate to show home-currency values on your financial statements. Transactions stay recorded in the currency you imported them in, which is what lets you reconcile against the foreign bank's statement.

Can one .qbo file contain two currencies?

No. A .qbo file carries a single currency code in its statement block and targets one account, and QuickBooks accounts each hold one currency. Two currencies means two files and two accounts. If your bank sends a combined statement, convert it twice, once per currency, and import each file to its matching account.

Does QuickBooks Desktop handle foreign statements the same way?

The file format is stricter. QuickBooks Desktop Web Connect imports .qbo only, with no CSV or QFX path, so conversion is mandatory rather than optional. Desktop has its own multicurrency setup that must be enabled first. Behavior differs between Desktop editions and years, so verify against your version.

The pattern that keeps this clean is boring and it works: enable multicurrency first, build one account per currency, verify the currency written into the file before uploading, and reconcile against the printed closing balance. Firms running several clients with foreign accounts can standardize it, and the workflow built for accountants and bookkeepers suits that repeat volume.