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.
- Set CAD as the base currency when you set up the Xero organization, and add USD on a plan that includes multi-currency.
- Raise each USD invoice and bill in USD. Xero applies its rate for the date, and you can edit it to the rate on your own records.
- Record each USD receipt, payment and conversion at the rate you actually received, so the realized gain or loss reflects your real rate.
- Reconcile the USD bank account regularly, so its CAD value follows each movement.
- At month end, review the unrealized gains and losses, then run the currency revaluation to update the CAD value of open USD balances.
- Read the Foreign Currency Gains and Losses report for the realized and unrealized split.
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.
- Every USD payment received carries the rate on the day it landed.
- Conversions from USD to CAD are recorded as transfers at the rate actually received.
- Bank charges deducted from incoming wires are posted as fees.
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.
| Item | Value | Note |
|---|---|---|
| USD 30,000 invoice, 14 August 2026 | CAD 41,625.00 | Raised at the reference rate of 1.3875. |
| Still open on 13 November 2026 | CAD 42,774.00 | At 1.4258, an unrealized gain of CAD 1,149.00 until the customer pays. |
| USD 45,000 bank balance, 15 October 2026 | CAD 63,931.50 | At the reference rate of 1.4207. |
| Same balance on 13 November 2026 | CAD 64,161.00 | At 1.4258, a movement of CAD 229.50 on cash still held in USD. |
Xero FX checklist for a Canadian company
| Stage | Question | What to check |
|---|---|---|
| Setup | Is CAD the base currency and USD added? | The organization settings and the currencies list. |
| Receipts | Did each USD receipt use the rate on its date? | The CAD amount on each payment against the bank statement. |
| Open items | What is still exposed? | Open USD invoices and bills by due date, plus USD cash. |
| Revaluation | Is 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
- Multi-Currency Exposure in QuickBooks Online Canada
- USD Payables for Canadian Importers Reporting in CAD
- USD/CAD Bank FX Margin: How to Check What You Pay
- Xero FX Integration: Live Currency Exposure
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