To see what each country cost you, give every expense a Country label at the moment you record it and total that label in dollars. A trip you log this way takes two minutes to summarise; a trip you try to reconstruct from card statements after you land at home takes an evening and still leaves gaps.
The example below is a 21-day trip through Ireland, Iceland and Norway, with every figure in US dollars and every number made up for illustration.
Which columns do you need before you leave?
- Date: the day you paid, not the day the card posted.
- Country: where you were standing when you paid.
- Category: lodging, food, transport, activities, shopping, other.
- Amount in $: what it cost you in your own currency.
- Note: one or two words, such as the merchant.
An extra country value called Transit is worth adding for the flight or ferry between two countries, because it belongs to neither stay.
How do you total each country with a formula?
Put the country names in a small summary block and use SUMIFS. If dollar amounts are in column D and countries in column B, rows 2 to 300:
- =SUMIFS($D$2:$D$300, $B$2:$B$300, "Iceland") gives one country.
- =SUMIFS($D$2:$D$300, $B$2:$B$300, "Iceland", $C$2:$C$300, "Lodging") gives one category inside one country.
- =SUM($D$2:$D$300) is the cross-check: the three country totals plus Transit must equal this.
This works the same way in Excel and Google Sheets. Spelling must match exactly, so pick "Iceland" once and never type "Icelnd" later.
What does the finished summary look like?
| Country | Nights | Total spent ($) | Per night ($) |
|---|---|---|---|
| Ireland | 7 | 1,260 | 180 |
| Iceland | 6 | 1,380 | 230 |
| Norway | 8 | 2,080 | 260 |
| All three | 21 | 4,720 | 224.76 on average |
1,260 plus 1,380 plus 2,080 is 4,720, and 4,720 divided by 21 nights is about 224.76. Per-night figures make a quiet country and an expensive one comparable, even when you stayed a different number of days.
How do you split a cost that covers two countries?
Say a regional travel pass cost $140 and covered seven days, three of them in one country and four in the next. Divide by days: 140 times 3 over 7 is $60 for the first country, and 140 times 4 over 7 is $80 for the second. The same trick works for a rental car or a phone plan. Write the rule in the Note column so you remember why the rows exist.
Why do some charges land in the wrong week?
Card statements often show a purchase days after you made it, under the date it was processed. If you trust the posting date, a Norway dinner can slide into the following country. Always record the date you paid. When you reconcile with the statement later, match by amount and merchant and leave your own date in place.
Can the same sheet answer other questions?
Yes. Because every row carries a date, a country and a category, you can also ask which category ate the most across the whole trip, or whether Ireland's food cost more than Norway's. Change the category in the SUMIFS line and the answer appears. Many people discover that lodging is not the largest line, and that small daily transport adds up faster than they expected. If you only ever look at the grand total, you miss that. Spend ten minutes with the table the week you return, while you can still remember why a day was unusually expensive.
Add a column for who paid if you travelled with friends, so the totals show your share and not the whole group's bill.
What to do on the plane home
- Sort your sheet by date and scan for rows with no country.
- Run the SUMIFS block for every country and compare the sum with the total of the column.
- Check any single row above $200 against a receipt or statement line.
- Copy the summary into the notes of your next trip, so the per-night figure becomes a starting budget.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

