QuickBooks Online Canada

How do I see my multi-currency exposure in QuickBooks Online Canada?

QuickBooks Online Canada records each foreign-currency invoice and bill in its own currency with an exchange rate, and keeps your home currency in CAD. To see exposure, list the open USD and other foreign-currency items by due date and value them at today’s rate against the rate each one was booked at.

Updated

For Canadian businesses on QuickBooks Online with multicurrency turned on, who want to see their open USD exposure.

The short answer

With multicurrency on, QuickBooks Online stores the currency, amount and exchange rate on every foreign transaction, and posts realized gains and losses when items are paid. Open items are where exposure sits. Revalue each currency under Settings, then Currencies, and add the Unrealized Gain or Loss column to the Supplier and Customer Balance Detail reports. Read the open invoices and bills with their due dates, and compare the CAD value at the booked rate with the CAD value at today’s rate. That gap is your unrealized FX position, and the due dates tell you when it turns into cash.

Five steps to see open USD exposure in QuickBooks Online Canada

The revaluation, report-column and Transaction Report steps follow two QuickBooks Online Canada help articles from Intuit, “Enter home currency adjustments for foreign balances” and “Frequently asked questions about home currency adjustments” (quickbooks.intuit.com, checked 22 November 2026). Intuit advises revaluing your foreign currencies immediately before you run reports, so the unrealized figures use a current rate.

How QuickBooks Online Canada records foreign currency

The home currency is set when multicurrency is turned on, and it cannot be changed afterwards; for a Canadian company it is CAD. Multicurrency cannot be turned off once it is on, so test it in a trial or test company first if you are unsure.

Each customer, supplier and bank account carries one currency. QuickBooks fills in an exchange rate for each transaction date, which you can overwrite with the rate you were actually given.

Where exposure hides

Illustrative USD 15,000 bill entered in September and valued in November 2026

Illustrative figures, not customer data. Reference rates are ECB euro reference rates read through Frankfurter. USD/CAD is the cross of EUR/CAD and EUR/USD on the same day, rounded to four decimal places. The Bank of Canada daily rate for the same day is a second check; the two differ slightly because the ECB rate is a snapshot taken at about 14:10 CET and the Bank of Canada rate is an average over the business day. The bill is illustrative, and QuickBooks may hold a slightly different rate for each date.

ItemValueNote
Bill entered 15 September 2026CAD 20,880.00USD 15,000 at the reference rate of 1.3920.
Valued 13 November 2026CAD 21,387.00USD 15,000 at 1.4258.
Unrealized loss while openCAD 507.00The bill needs more Canadian dollars than were booked.
When the bill is paidRealized at the payment rateQuickBooks posts the difference between the booked rate and the payment rate as an exchange gain or loss.

QuickBooks Online Canada FX review

StageQuestionWhat to check
CurrenciesIs every foreign supplier and customer set to the right currency?The currency on each contact you pay or bill in USD.
Open itemsWhat is still unpaid in USD?Open invoices and bills by currency and due date.
RatesDo payments carry the rate actually paid?The CAD amount on each foreign payment against the bank statement.
RevaluationHow is the month-end value posted?The unrealized gain or loss on open invoices and bills, kept apart from realized FX on payments and bank revaluations.

Common mistake

Paying a USD supplier from a CAD bank account in QuickBooks without entering the actual rate. The default rate then sets the realized FX, which no longer matches the bank statement.

Where Hedgr fits

Hedgr reads QuickBooks Online and shows open USD bills and invoices in CAD by due date, unrealized and realized FX side by side, and how much of each currency is outside your policy.

Hedgr Treasury

Hedgr Treasury books spot and forward FX and pays suppliers in their own currency, for businesses in Canada, the US, the UK and the EEA. Available to eligible businesses after onboarding.

Spot and forwards carry a 0.15% spread on the provider’s rate, and each quote shows that spread in money before you approve it. The provider’s rate carries its own margin, so compare the all-in rate on a real quote with a reference rate taken at the same moment.

Hedgr adds no fee to supplier payments. SWIFT payments can carry intermediary bank charges.

A licensed provider holds client funds and executes each trade you approve, so Hedgr never holds client money. New clients join through the waitlist, and Hedgr is onboarding businesses from the waitlist in order.

FX involves risk and rates can move against you.

Join the waitlist · What SME FX providers charge · Hedgr Treasury pricing

Common questions

How do I see my multi-currency exposure in QuickBooks Online Canada?

Revalue each foreign currency from Settings, then Currencies, then run the Supplier Balance Detail and Customer Balance Detail reports with the Unrealized Gain or Loss column added. Then read or export the open items by due date. The result shows what is still open in USD, its gain or loss at the current rate, and when each item falls due.

Which QuickBooks Online Canada reports show unrealized FX gains and losses?

Intuit lists the Profit and Loss report, the Balance Sheet, the Customer Balance Detail report, the Supplier Balance Detail report and the Statement of Cash Flows. On the two balance detail reports you add the Unrealized Gain or Loss column yourself through Customize.

Can I turn off multicurrency in QuickBooks Online Canada?

No. Once multicurrency is on it stays on, and the home currency is fixed. Intuit advises checking the setup before you turn it on.

Does a home currency adjustment post unrealized or realized FX?

It depends on the account type. Intuit’s help says QuickBooks shows the effect of a home currency adjustment on accounts receivable and accounts payable as an unrealized gain or loss, and the effect on accounts such as bank accounts as a realized foreign exchange gain or loss. Intuit’s help lists home currency adjustments on the Essentials, Plus and Advanced plans, with multicurrency turned on.

Can Hedgr read QuickBooks Online Canada?

Hedgr connects to QuickBooks Online through Intuit’s sign-in and reads invoices, bills and payments to show exposure in your home currency. It reads your books and never writes to them.

Related guides

Free tools

The Hedgr app is read-only: it reads your accounting data and never writes to your books. In Hedgr Treasury, a licensed provider holds client funds and executes each trade you approve. Hedgr gives no investment advice.

Guides

Accounting integrations

Pricing · All integrations · Home