When a subscription is priced in another currency, each monthly charge converts at that month's rate, so the Canadian dollar cost changes even though the price does not. Record each charge at the amount your card actually billed. Do not apply one rate to the whole year.
The example uses an invented 20 US dollar monthly plan and made-up Canadian dollar rates. It describes method, not any bank policy.
Why does a fixed price change your cost?
The seller charges a fixed number of US dollars. Your bank turns it into Canadian dollars on the day the charge arrives. If the rate moves, your cost moves. Over a year the movement may be small, but it is a real difference and it is exactly what the statement records.
What do three months look like?
| Month | Charge (US$) | Rate (C$ per US$) | Billed (C$) |
|---|---|---|---|
| January | 20.00 | 1.34 | 26.80 |
| February | 20.00 | 1.36 | 27.20 |
| March | 20.00 | 1.33 | 26.60 |
| Quarter | 60.00 | - | 80.60 |
The billed figures are 20 times 1.34, 20 times 1.36 and 20 times 1.33, adding to 80.60. An average rate of about 1.343 would land on the same total here, but you could only work it out after the quarter ended, and each month's figure stays its own.
How should you record it?
- Create one row per charge, dated when the charge posted or, if your statement shows it, when it was authorised.
- Enter the US dollar price in the original amount column.
- Enter the Canadian dollars billed as the base amount.
- Let the rate be a calculated column: billed divided by original.
What about annual plans paid up front?
A yearly plan is a single payment at a single rate, even though you use it for twelve months. Record it once, on the day it was paid. If you want to see a monthly cost, add a separate view that divides by twelve, but keep the payment itself as it was. Mixing the two makes it look as though you paid every month.
When is the posting date a problem?
A charge made on the last day of a month may post on the first of the next. If you categorise spending by month, decide whether the transaction date or the posting date decides. Pick one policy and keep it, or a subscription will seem to be missing from one month and doubled in another.
What if the subscription price itself changes?
Sellers sometimes raise a price in the foreign currency, from 20 to 22 US dollars for example. Record the new charge with its new original amount, and add a note on the row that the price changed. Without the note, a rise from 26.80 to 29.92 Canadian dollars will look like a rate movement when part of it is a genuine price increase. Keeping the original currency amount on every row lets you tell the two apart at a glance.
How do you handle several subscriptions?
Give each one a row per charge and the same category, such as Software or Entertainment. Sort by merchant once a quarter and compare the original amounts. Charges that creep up, or a subscription you forgot, show up quickly in a sorted list. The exchange rate then becomes a side issue instead of the thing you are hunting for.
Quick checklist
- Does every foreign charge show the original amount?
- Is the billed amount copied from the statement?
- Is the rate derived rather than typed in?
- Are annual and monthly plans recorded differently?
Useful ideas start with a clearer picture of your own spending.
Explore your reports

