Counting daily spend per country compares destinations on a holiday: total what you spent in each place and divide by the nights you stayed. A stopover of two nights and a base of eight nights then sit side by side on one scale.
The worked example is a 15-day holiday through Bali, Vietnam and Japan, with all amounts in Australian dollars and all figures invented.
Why daily averages beat raw totals
A raw total punishes the country you stayed in longest. If you spent 1,600 dollars in eight nights in one place and 700 in two nights in another, the first looks twice as costly. Per night it is 200 against 350, and the short stopover was the expensive one. That reversal is exactly what a trip summary should show you.
How do you set it up?
- List each night and the country you slept in, in a small Nights table.
- Keep one Expenses list with Date, Country, Category and Amount in Australian dollars.
- Use SUMIFS to total each country from the Expenses list.
- Divide each total by the matching nights figure.
For example, with country names in column A of the summary and the nights in column B, the per-night cell is =C2/B2, where C2 holds =SUMIFS($D$2:$D$400,$B$2:$B$400,A2) pointing at the Expenses list. Both Excel and Google Sheets read it the same way.
What do the numbers look like?
| Country | Nights | Total spent ($) | Per night ($) |
|---|---|---|---|
| Bali | 6 | 1,320 | 220 |
| Vietnam | 5 | 950 | 190 |
| Japan | 4 | 1,480 | 370 |
| Trip | 15 | 3,750 | 250 |
1,320 plus 950 plus 1,480 equals 3,750, and 3,750 divided by 15 is 250. Japan stands out at 370 a night, but Bali's 220 includes a one-off 400 dollar villa upgrade; without it the figure is 920 over 6 nights, about 153 a night.
How do you deal with flights and baggage?
Put international and internal flights in a group called Between countries. They are real trip costs but they say nothing about what a destination costs to live in for a day. Show them below the country table as one line and also as part of the trip total, so you get both the on-the-ground figure and the all-in figure.
Which cash habit saves arguments with yourself?
- Count cash in the currency of the country you are in, then convert only when you record it.
- Record each withdrawal, not each coffee, if you are short of time, and tag the withdrawal with the country.
- Keep leftover local notes in an envelope and write the amount on it, so they are not counted twice when you pass through the next airport.
What if you only have receipts, not a list?
Lay the receipts out in date order, one pile per country, and total each pile. It is slower than a sheet, but it works. Photograph each pile as you finish it, so the evidence survives even if the paper does not. Then type a single row per receipt later, writing the country, category and amount in Australian dollars. Receipts that show only local currency can wait until you find the amount on your card statement. Do not convert them using a rate you guessed on the beach.
After you land
Check the grand total against your credit card statement for the trip dates. A gap of a few dollars is usually timing or rounding; a gap of a hundred dollars means a charge you forgot to record or recorded twice. Fix it while the trip is fresh, then keep the sheet as the model for the next one.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


