When a trip crosses several countries, record each expense with the country printed on it and a Canadian dollar amount, then sum by country at the end. If you also drive, give fuel and tolls their own category so you can see how much of each country's bill was getting around rather than staying.
The example is a 12-day car trip that starts in Canada, then goes through the United States into Mexico, with all numbers invented and every amount in Canadian dollars.
What does a good expense row contain?
- Date and time if you cross a border that day.
- Country where you paid.
- Category: fuel, lodging, meals, tolls and parking, activities, other.
- Amount in Canadian dollars as shown on your card, or converted by you if you paid cash.
- Payment method: card, cash or app.
The payment method column matters for the cash rows, because those are the ones most likely to be recorded late.
How should you treat a border crossing day?
Record the time of the crossing in your notes. Anything before it belongs to the country you left; anything after belongs to the new one. This is more exact than a sleep rule and works well on a road trip where you might fill the tank in one country and eat dinner in another.
What does a finished breakdown look like?
| Country | Fuel ($) | Lodging ($) | Meals ($) | Other ($) | Total ($) |
|---|---|---|---|---|---|
| Canada | 140 | 0 | 90 | 20 | 250 |
| United States | 210 | 560 | 340 | 110 | 1,220 |
| Mexico | 85 | 320 | 180 | 65 | 650 |
The sums are 140 plus 90 plus 20 for 250, then 210 plus 560 plus 340 plus 110 for 1,220, and 85 plus 320 plus 180 plus 65 for 650. The whole trip comes to 2,120, and the United States leg is about 58 percent of it, because 1,220 divided by 2,120 is roughly 0.575.
Fuel across all three comes to 435 dollars, which divided by 12 days is 36.25 a day.
Do you divide the cost of shared items?
If two people share a motel room, record only your half. If one person pays for the fuel and the other for the hotel, settle up later, but record the full fuel cost in the sheet of the person who paid and note who owes what. Mixing the two ledgers makes the country totals meaningless.
What if your card statement is the only record?
Download the statement for the trip dates and add a Country column yourself. Merchant names often hint at the place, and a pending fuel charge posted two days later should keep the date you filled the tank. Any rows with no clear country can go into a temporary Unknown group; review that group first when you are back.
Can you compare the legs by distance?
If you noted your odometer at each border, divide each country's total by the kilometres driven there. A leg that cost 1,220 dollars over 600 kilometres is about 2.03 dollars per kilometre, while one costing 650 over 900 kilometres is about 0.72. Those ratios mix lodging with fuel, so treat them as a rough comparison rather than a pure cost of driving. Fuel alone divided by kilometres is the cleaner figure.
Odometer notes cost you ten seconds at each border and make the next trip's route planning much easier.
A tidy-up list for the week after you return
- Sort by date and eyeball for missing days.
- Total by country, then by category.
- Compare the fuel total with the distance you drove, if you tracked it.
- Move the final table into a separate tab you can reopen next year.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

