Xero Canada

How do I track FX gains and losses on USD invoices in Xero for a Canadian company?

Xero records each USD invoice, bill and bank balance at a rate in CAD, posts a realized gain or loss when an item is paid, and can revalue what is still open. To track FX, keep three figures apart: realized FX on paid items, unrealized FX on open items, and the movement on any USD bank account.

Updated

For Canadian companies on Xero with CAD as the base currency and USD invoices, bills or a USD bank account.

The short answer

Set CAD as the base currency and add USD as a currency on a Xero plan that includes multi-currency. Xero applies a rate to each foreign transaction, which you can edit to the rate you received. Paid items post realized FX; open items and USD bank balances move with the rate until they settle. Xero’s Foreign Currency Gains and Losses report shows the split, and its currency revaluation tool posts the month-end unrealized figure.

How to track FX gains and losses on USD invoices in Xero, step by step

Steps 4 and 5 follow Xero’s own multi-currency guidance (xero.com US page, checked 22 November 2026), which also says to review unrealized gains and losses before you close the period.

A Canadian exporter’s three FX figures

A Canadian business that sells to US customers often holds USD receivables and a USD bank account. Both rise in CAD value when the loonie weakens and fall when it strengthens.

The receivable becomes realized FX when the customer pays. The USD bank balance keeps moving until you convert it, so it carries its own figure each month.

Checks before month end

With those three in place, the realized and unrealized figures in Xero can be traced invoice by invoice.

Illustrative USD invoice and USD bank balance for a Canadian exporter

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 invoice and the balance are illustrative, and Xero may hold a slightly different rate for each date.

ItemValueNote
USD 30,000 invoice, 14 August 2026CAD 41,625.00Raised at the reference rate of 1.3875.
Still open on 13 November 2026CAD 42,774.00At 1.4258, an unrealized gain of CAD 1,149.00 until the customer pays.
USD 45,000 bank balance, 15 October 2026CAD 63,931.50At the reference rate of 1.4207.
Same balance on 13 November 2026CAD 64,161.00At 1.4258, a movement of CAD 229.50 on cash still held in USD.

Xero FX checklist for a Canadian company

StageQuestionWhat to check
SetupIs CAD the base currency and USD added?The organization settings and the currencies list.
ReceiptsDid each USD receipt use the rate on its date?The CAD amount on each payment against the bank statement.
Open itemsWhat is still exposed?Open USD invoices and bills by due date, plus USD cash.
RevaluationIs the unrealized figure posted at month end?The revaluation journal and the Foreign Currency Gains and Losses report.

Common mistake

Treating the gain on USD cash as income from trading. It is the rate moving on money you already hold, and it can reverse before you convert it.

Where Hedgr fits

Hedgr reads your Xero organization with CAD as the base currency and shows open USD exposure by due date, realized and unrealized FX, and the movement on USD cash.

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 track FX gains and losses on USD invoices in Xero for a Canadian company?

Xero posts the realized gain or loss when you record the payment at the rate you received. It posts the unrealized figure on invoices still open when you run the month-end currency revaluation. The Foreign Currency Gains and Losses report shows both figures.

When should I run a currency revaluation in Xero?

Run it at each month end. Xero recommends the currency revaluation at month end to update the home-currency value of open foreign currency balances. The unrealized figure in your reports then reflects the rate on that date.

Where does Xero get its exchange rates?

Xero supplies rates automatically from a market data provider and lets you edit the rate on any transaction. Use the rate you actually received for payments and conversions.

What is the difference between realized and unrealized FX in Xero?

Realized FX is posted when a foreign invoice or bill is paid. Unrealized FX is the movement on items and balances that are still open, posted by a revaluation at period end.

Can Hedgr read a Canadian Xero organization?

Hedgr connects to Xero through Xero’s own sign-in and reads invoices, bills, payments and bank balances in the organization’s base currency. It reads your books and never writes to them.

Related guides

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