Travel and vehicles

Group trip expenses in different currencies: an Australian dollar split

A late joiner, a villa and yen bills: how to split group trip costs in Australian dollars by person-nights, with a worked example you can copy.

Editorial illustration for Group trip expenses in different currencies: an Australian dollar split

When people stay for different numbers of nights, split accommodation by person-nights, not by head count, and convert foreign bills to Australian dollars once at a recorded rate. Shared activities can then be divided equally among those who joined. This keeps the person who arrived two nights late from subsidising or being subsidised by everyone else.

Why head-count splits go wrong

Five friends rent a place in Japan. Four stay five nights. A fifth arrives for the last two nights because of work. Dividing the rent by five asks the late arriver to pay as much as people who stayed for the whole thing. Dividing by person-nights gives a fairer answer without much extra work.

Step one: convert the bills

Say you agree a rate of AUD 1.02 per 100 yen, written down on the day of booking. The villa costs ¥110,000, dinner ¥36,000 and train passes ¥54,000. Divide each yen amount by 100 first, then multiply by the rate.

  • Villa: 1,100 x 1.02 = AUD 1,122.00
  • Dinner: 360 x 1.02 = AUD 367.20
  • Train passes: 540 x 1.02 = AUD 550.80
  • Total: AUD 2,040.00

Writing the rate per 100 yen rather than per single yen avoids a row of zeros that is easy to misread. If your bank quotes a rate per single yen, multiply by 100 once, and note it.

Step two: share the villa by person-nights

Four people for five nights is 20 person-nights, plus the late joiner's two, making 22. The villa's AUD 1,122.00 divided by 22 is AUD 51.00 per person-night.

PersonNightsVilla shareDinner (1/5)Train passes (1/5)Total owed
Each of four full-stay friends5255.0073.44110.16438.60
Late joiner2102.0073.44110.16285.60

Check: 4 x 438.60 = 1,754.40 and adding 285.60 gives AUD 2,040.00, the same as the three bills combined.

How do I handle a deposit paid before the trip?

A deposit paid weeks ahead in yen was converted at a different rate from the final balance. Record it separately with its own rate and its own date, then add it to the villa row. Do not average the two rates, because the balance may be paid by someone else.

Late joiners are also the people most likely to be told 'do not worry about it, we will sort it later'. Resist that. A short message with their exact number, AUD 285.60, and the reason for it, two nights of the villa plus equal shares of dinner and passes, is kinder than a vague promise, and it stops a small awkwardness from turning into a big one.

What if someone leaves early or skips a meal?

  1. Add a column for each shared expense showing who took part.
  2. Divide that expense among those names only.
  3. For nightly costs, count person-nights.
  4. Add up each person's rows and subtract what they paid.
  5. Settle from the net figures.

Keeping a record

A sheet with a currency column and a rate column is enough for a trip. SpendixAI, built around India and INR, lets each expense carry its own currency with totals in a base currency, so it is mentioned only as an example of that design; it is not a bill-splitting tool.

The same person-night idea works for any cost that scales with presence: car hire shared by whoever rode in it, a prepaid transport card topped up for some travellers but not others, or a cooking class booked for part of the group. Whenever a cost is not truly shared by all, add a column and count heads or nights. A minute of setup at the start is much cheaper than a conversation about fairness at the end.

Before you settle

  • Rate and its date written for every foreign bill.
  • Person-nights counted and double-checked.
  • Total owed equals total spent.
  • Everyone has the same copy of the sheet.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports