How to Budget With Both US and Canadian Dollar Accounts

Plenty of Canadians hold money in two currencies without thinking of themselves as having a “multi-currency” anything. A US dollar savings account at the same bank as your chequing account. A US credit card kept from a Florida condo. A paycheque or client invoices in US dollars. A few months a year spent south of the border.

All of it works fine until you try to budget. Then the questions arrive fast. Do you add a US$100 dinner to a CAD grocery total? At which rate? Why is last month’s total different today than it was last week?

This guide covers the handful of decisions that make two currencies manageable in one budget, whether you track things in a spreadsheet or an app.

Pick one home currency and report everything in it

You can’t add US dollars to Canadian dollars. Every total, from monthly spending and budget categories to net worth, needs one currency to be counted in.

Pick the currency most of your life runs in: the one your main income arrives in and most of your bills are paid in. For most people living in Canada that is CAD, even if they hold some USD. For a Canadian living in the US for work, it may be USD.

Everything else gets converted into that currency for reporting. The US dollar account stays a US dollar account; you just see its value in your home currency when it’s added to anything.

Convert each transaction at the rate on the day it happened

This is the decision that keeps a budget stable. Suppose you spend US$100 on dinner in Florida on March 12, when one US dollar is worth, for illustration, CA$1.40. That dinner cost you CA$140. It counts as CA$140 against your dining budget for March, and it keeps counting as CA$140 forever.

The tempting alternative is to convert everything at today’s rate. Don’t. If the rate moves to 1.35 in June, your March dining total would drop to CA$135 and a month you already closed would change under you. Rollover budgets would shift, reports would disagree with each other depending on when you ran them, and nothing you looked at last month would match what you look at now.

Converting at the transaction’s own date means the past stays put. It also matches reality: CA$140 of your money is what the dinner actually used up.

Convert balances at today’s rate

Balances are the opposite case. A US dollar account holding US$5,000 is worth whatever US$5,000 is worth today. At 1.40 that’s CA$7,000; at 1.35 it’s CA$6,750.

So your net worth moves when the exchange rate moves, even in a month where you didn’t touch the account. That isn’t a bookkeeping error. It is a real change in what your money is worth in the currency you live in, and it goes both ways. People who hold a large share of their savings in USD sometimes find this is the single biggest monthly swing in their net worth, bigger than anything they spent.

Keep the two rules separate: transactions at the rate on their date, balances at today’s rate. Mixing them up is where most multi-currency spreadsheets go wrong.

Which exchange rate to use

Use a published reference rate, consistently.

The Bank of Canada publishes a USD/CAD rate every business day. It’s free, it goes back years, and the CRA generally expects foreign amounts on a tax return to be converted at a Bank of Canada rate, so using it for your budget keeps your numbers in line with what you’ll use at tax time anyway. On weekends and holidays, use the most recent business day’s rate.

It won’t match what your bank charged you. Banks and card issuers add a margin to every conversion, often a couple of percent, and that margin is the real cost of converting. A reference rate isn’t trying to capture it; it’s trying to give every transaction a consistent, checkable value. If you want to know what conversion is costing you, compare what your bank gave you against the reference rate on the same day.

Converting money between your own accounts

Moving US$1,000 from your USD account into your CAD account is not spending, and it isn’t income. It’s a transfer between your own accounts, and it should be recorded as one so it doesn’t inflate your spending or your income for the month.

The one wrinkle is that the two sides won’t match once converted. If the reference rate says US$1,000 is CA$1,400 and your bank deposits CA$1,372, the missing CA$28 is the conversion cost. It’s small on any one transfer and adds up if you convert often. It’s worth noting separately, because it’s a real expense that no category otherwise captures.

Budgets: one currency, spending from both

Your budgets should be set in your home currency, and spending in either currency should count against them at its converted value.

That means your grocery budget is a single CA$600, not CA$600 plus a separate US$200. When you buy groceries in Arizona for US$85, that shows up as roughly CA$119 against the same grocery budget as a shop at home. You get one honest answer to “how much did we spend on groceries this month?” instead of two partial ones.

If you spend months at a time in the US, the category totals will naturally run higher in those months, partly because of the exchange rate. That is useful to see, and a good reason to budget those months with the conversion in mind rather than using the same CAD targets as a month at home.

Doing it in a spreadsheet

If you track by hand, add four columns to your transaction log: the original amount, its currency, the exchange rate for that date, and the converted amount in your home currency. Sum only the converted column. Look up the rate once per transaction date from the Bank of Canada’s published rates, and never go back and change it.

For balances, keep a small table of your accounts in their own currency and convert them at the latest rate whenever you update your net worth. The net worth tracker has Canadian account types if you want a starting point.

It works. The cost is the rate lookup on every foreign transaction, which is the step that tends to get skipped after a few weeks.

How WealthMode handles USD and CAD accounts

WealthMode supports US and Canadian dollars and follows the rules above.

• You choose a home currency when you set up your account. Every total in the app is shown in it. Choose carefully: it locks once you have transactions or a connected bank account.
• Each account has its own currency, set when the account is created. Accounts connected through bank sync pick up their currency from the bank.
• Rates come from the Bank of Canada’s daily USD/CAD rate. Each transaction is converted at the rate for its own date, and that value is stored, so past months never shift. The original amount stays visible under the converted one, and tapping it shows the rate used.
• Balances and net worth use the latest rate, and the net worth page shows which rate and date it used, so a currency swing is easy to tell apart from a spending change.
• Budgets and reports count spending from both currencies at its converted value, so each category has one total.
• CSV imports take the currency of the account you import into and convert each row at its own date’s rate.

Two limits worth knowing: only USD and CAD are supported for now, and the rate is the Bank of Canada reference rate, not the exact rate your bank charged. The Canada page covers the rest of what WealthMode does for Canadian users, including connecting Canadian banks.

Budgeting in USD and CAD: the short version

Report everything in one home currency. Convert each transaction at the rate on the day it happened and never change it; convert balances at today’s rate and expect your net worth to move with the exchange rate. Use a published reference rate like the Bank of Canada’s, treat conversions between your own accounts as transfers, and set budgets in your home currency so spending in either currency lands in the same category.

Those few rules are the difference between two currencies that add up and a budget that drifts every time the loonie moves.