How to Handle Multi Currency Transactions in QuickBooks

Many Calgary businesses transact in multiple currencies — purchasing from US suppliers, invoicing international clients, or receiving payments through platforms that settle in USD. QuickBooks Online has multi-currency features, but they require careful setup and ongoing management to keep your books accurate.

Enabling Multi-Currency

In QBO, multi-currency is a one-way switch — once enabled, it cannot be turned off. Before enabling it, ensure you actually need it. If you only have occasional foreign transactions, it may be simpler to record them manually in CAD using the exchange rate at the time of the transaction. If you regularly transact in other currencies, enabling multi-currency is the right move.

How It Works

Once enabled, you can assign currencies to customers, vendors, and bank accounts. QBO automatically uses the exchange rate for the transaction date. When you receive payment on a USD invoice, QBO calculates the exchange gain or loss based on the rate difference between the invoice date and the payment date.

Exchange Gains and Losses

Currency fluctuations create gains or losses that affect your bottom line. If you invoice a US client for $1,000 USD when the rate is 1.35, your expected CAD revenue is $1,350. If they pay when the rate is 1.38, you receive $1,380 — a $30 exchange gain. The reverse creates a loss. QBO tracks these automatically in an Exchange Gain/Loss account.

Bank Account Reconciliation

If you have a USD bank account, set it up in QBO as a USD account. Reconcile it in USD against your USD bank statement. QBO will handle the CAD conversion for reporting purposes. Do not try to reconcile a USD bank account in CAD — the exchange rate differences will make reconciliation impossible.

Common Mistakes

• Entering USD transactions in a CAD account at the converted amount — this bypasses QBO's exchange tracking
• Not reconciling the exchange gain/loss account regularly
• Using incorrect exchange rates for year-end revaluation of foreign-currency balances

Castle Handles Multi-Currency Bookkeeping

Multi-currency bookkeeping adds complexity that requires careful attention. Castle Bookkeeping manages multi-currency setups, reconciliation, and exchange gain/loss tracking for Calgary businesses with international transactions. Contact us for a free consultation.