Log every bill in the currency printed on the receipt, convert it into Canadian dollars with a rate and a date beside it, then divide the Canadian total among the group. If the rate moves during the trip, keep each day's rate with its own entries instead of overwriting earlier ones. That way the total can be rebuilt from the receipts at any time.
A cottage-and-ski weekend, five people
Say five friends rent a lodge across the border. Some bills are in US dollars, and the exchange rate shifts between the first and third day. This is the kind of weekend where one person fronts the big bill and everyone else sends their share later, so a clean record matters.
A worked example with dated rates
| Date | Expense | Original (USD) | Rate (CAD per USD) | Canadian dollars |
|---|---|---|---|---|
| Day 1 | Lodge | 900.00 | 1.35 | 1,215.00 |
| Day 1 | Fuel | 64.00 | 1.35 | 86.40 |
| Day 3 | Dinner | 180.00 | 1.37 | 246.60 |
| Total | - | 1,144.00 | - | 1,548.00 |
Each person's share is 1,548.00 divided by five, which is CAD 309.60. Notice the dinner on day 3 used 1.37 rather than 1.35. Had you forced 1.35 onto everything, the dinner would show CAD 243.00, understating it by CAD 3.60. Small, but over a longer trip it grows.
How should the rate be set?
- Use the rate your card statement implies when the charge has already posted: Canadian dollars charged divided by the US amount.
- Use a stated rate with its date when you are still planning or the charge is pending.
- Never change an old entry's rate because a newer one looks better.
- Keep the rate in its own column so anyone can check it.
Tips, parking and the odd cash purchase deserve a line too. Keep them in a small running list while you travel and add them as one 'sundries' row at the end of each day, in the currency you paid, so the ledger does not fill up with tiny entries that nobody will check.
What if one person fronts everything?
- Add up all the bills in Canadian dollars once the last card charge has posted.
- Divide by the number of people to get the equal share.
- Everyone else owes that share to the person who paid.
- If someone paid a few items themselves, deduct those from what they owe.
- Ask for transfers within a set number of days and write the date in the chat.
When should the group settle?
Settle after all the card charges have posted, not on the drive home. Waiting a few days costs nothing and avoids two rounds of corrections. Set a date when the trip starts and stick to it, so no one is waiting for months for a few hundred dollars.
Tracking tools in brief
A shared sheet is enough for most groups. If you want one place that handles each expense in its own currency and totals in a base currency, SpendixAI does so, but it is built around India and INR, so check what suits you rather than assuming it will.
A practical tip for the person fronting the bills: use one card for all the shared items and keep a separate one for your own purchases. At the end, that card's statement is the shared ledger in miniature, and every foreign charge on it has already been converted into Canadian dollars by the card, so you can cross-check your own conversions against it line by line. The differences are usually a few cents and are worth noting only when they are larger.
Checklist for the drive home
- Every bill has an original amount, currency, date and rate.
- The total in Canadian dollars is recomputed from the rows.
- Each share equals total divided by head count, adjusted for items paid by individuals.
- The settle-up date is agreed.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


