To know how much each country cost, decide one rule for deciding which country a payment belongs to, apply it to every row, and add up the rows. The hard part is never the addition; it is the border day, the cash you withdrew in one place and spent in another, and the booking you paid before you left.
The example is a 14-day journey from a home base in Germany to Thailand, Cambodia and Vietnam, counted in euros, with invented amounts.
Which rule should decide the country?
Three rules are common. Where you slept works well for hotels and food. Where you paid works well for card spending. Where you used the service works best for tours and tickets. Pick one for the whole trip, write it at the top of your sheet, and do not mix them.
For this journey the rule is: the country where you spent the night owns that whole day.
How do you handle border days?
Say you left Thailand at noon and slept in Cambodia. Under the sleep rule, every payment that day, including the lunch in Thailand, goes to Cambodia. It is slightly unfair to Cambodia, but it is consistent, and over a whole trip the errors cancel out. The alternative, splitting each such day into two halves, adds effort without changing the story.
What happens to cash?
- Record the withdrawal itself as one row with the Country of the machine.
- Do not record spending from that cash again if you already counted the withdrawal.
- If you carry leftover cash into the next country, move a note of that amount into a Carry-over row so the total does not double count.
- Keep one small notebook line each evening: cash spent, where.
Choose either withdrawal-based tracking or spend-based tracking for cash. Doing both counts the same money twice.
What does the result look like?
| Country | Days | Hotels (€) | Food and local travel (€) | Total (€) |
|---|---|---|---|---|
| Thailand | 5 | 280 | 210 | 490 |
| Cambodia | 4 | 180 | 160 | 340 |
| Vietnam | 5 | 260 | 190 | 450 |
The three totals add up to 1,280 euros across 14 days, or about 91.43 euros per day. Cambodia comes in at 340 over 4 days, which is 85 a day, against 98 a day for Thailand and 90 for Vietnam. Per-day averages make the countries comparable even though you stayed different lengths.
Where do flights and pre-paid bookings go?
Create a row group called Before departure for the intercontinental flight and any hotel you paid for months earlier. Keep it out of the country totals unless you want a trip-wide cost. Show it as its own line under the table: flights, visas, insurance and so on. Anyone reading your summary then sees both the cost on the ground and the all-in cost.
Should you count the journey home?
It depends on the question. If you want to compare the three countries as places to spend time, leave the return flight out. If you want to know what the whole trip cost, include it, but under its own heading rather than inside any one country. A reader who sees a flight inside Vietnam will think Vietnam is expensive. Keep two summaries side by side: one for on-the-ground cost and one for everything.
Whichever you choose, write the choice at the top of the sheet so that you, or whoever you share the file with, can read the numbers correctly later.
Afterwards
- Fix any row with a blank country.
- Total each country and each category.
- Put the per-day figures next to your notes about where you stayed.
- Use those per-day figures as the first draft of the next trip's budget.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

