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.
- Sort your customers and suppliers by currency, and correct any you bill or pay in USD that still show CAD.
- Revalue each foreign currency: open the Settings gear, select Currencies, and choose Revalue Currency from the Actions column for that currency.
- Run the Supplier Balance Detail report, select Customize, and under Rows/Columns choose Change columns and tick Unrealized Gain or Loss. Under Aging, set the aging method to Report date, then run the report. Do the same on the Customer Balance Detail report.
- Read the due date of each open bill and invoice, so you can see when each USD amount turns into cash. The balance detail reports group items by supplier or customer, so export the report to a spreadsheet if you want one list in due-date order.
- Open the Profit and Loss report or the Balance Sheet and select an account amount to see its Transaction Report. Intuit’s help says open transactions show their unrealized gain or loss in their rows.
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
- USD bills from suppliers whose currency was set to CAD by mistake, which show no exposure at all.
- USD bank balances, which change in CAD value every day.
- Part-paid bills, where only the balance due is still exposed.
- Purchase orders, which carry exposure before any bill exists.
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.
| Item | Value | Note |
|---|---|---|
| Bill entered 15 September 2026 | CAD 20,880.00 | USD 15,000 at the reference rate of 1.3920. |
| Valued 13 November 2026 | CAD 21,387.00 | USD 15,000 at 1.4258. |
| Unrealized loss while open | CAD 507.00 | The bill needs more Canadian dollars than were booked. |
| When the bill is paid | Realized at the payment rate | QuickBooks posts the difference between the booked rate and the payment rate as an exchange gain or loss. |
QuickBooks Online Canada FX review
| Stage | Question | What to check |
|---|---|---|
| Currencies | Is every foreign supplier and customer set to the right currency? | The currency on each contact you pay or bill in USD. |
| Open items | What is still unpaid in USD? | Open invoices and bills by currency and due date. |
| Rates | Do payments carry the rate actually paid? | The CAD amount on each foreign payment against the bank statement. |
| Revaluation | How 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
- Xero FX Gains and Losses on USD Invoices in Canada
- USD Payables for Canadian Importers Reporting in CAD
- USD/CAD Bank FX Margin: How to Check What You Pay
- QuickBooks Online FX Risk Management
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
- FX exposure basics
- SME FX policy template
- Unrealised FX gains and losses
- Realised vs unrealised FX
- Multi-currency invoice cashflow risk
- Xero FX exposure workflow
- QuickBooks Online FX exposure workflow
- Exporter month-end FX reporting
- Multi-entity FX consolidation software
- SARB BoP categories after the August 2026 change
- Sage One South Africa FX exposure workflow
- Rand exposure for SA importers and exporters
- IAS 21 and the margin basis: does your FX impact double-count?
- FX exposure from a spreadsheet
- AI tool to analyse FX exposure for a small business
- What to do when your FX broker drops your account
- Forward contract deposit and close-out cost for SMEs
- How to hedge one foreign-currency invoice
- What SME FX providers charge in 2026
- How to pay a USD supplier from a GBP account
- How to check an FX margin against the mid-market rate
- EUR supplier payments for a group with a GBP parent
- When to buy foreign currency for invoices
- FX payments with Xero and QuickBooks
- How a small business books an FX forward contract
- Alternatives to your bank for business FX payments
- Can a small business automate FX hedging?
- How invoice-by-invoice FX hedging works
- What agentic FX is, and what an AI FX agent should do
- Canada: USD payables for CAD-reporting importers
- Canada: FX exposure in QuickBooks Online Canada
- Canada: FX gains and losses in Xero
- Canada: checking a USD/CAD bank margin
- Canada: FX forward contracts for small businesses
- Canada: how to pay US suppliers in USD
- FX risk management software for SMEs
- FX hedging software for SMEs
- Hedge accounting software: IFRS 9 checklist for SMEs
- FX risk for e-commerce and DTC exporters