Travel and vehicles

Cost per day across your past trips: spot your cheapest and priciest

Work out your average trip cost per day and per person per day for each past trip, then compare cheapest and priciest with a five-trip table.

Editorial illustration for Cost per day across your past trips: spot your cheapest and priciest

To compare the cost per day of your past trips, total each trip, divide by the number of days, then divide again by the number of people. Line the trips up in one table and sort by cost per person per day. The cheapest and priciest trips are usually obvious, and the interesting part is why. The five trips below are invented, so use your own history.

What do I need for each trip?

  • Total spend, from your records: everything tagged to the trip, including prepaid bookings.
  • Days: choose one rule, such as counting the day you leave and the day you return, and stay with it.
  • People: how many people the total covers. Decide in advance how to count small children and keep the same rule.
  • Optional: the split of the total into getting there, stay, food, local transport and shopping.

A five-trip table

TripDaysPeopleTotal (₹)Per day (₹)Per person per day (₹)
Goa weekend3228,5009,5004,750
Jaipur4462,00015,5003,875
Kerala621,02,00017,0008,500
Singapore532,10,00042,00014,000
Manali5488,00017,6004,400

Check a couple of rows: 28,500 divided by 3 is 9,500, and divided by 2 people is 4,750. 2,10,000 divided by 5 is 42,000, and divided by 3 is 14,000. Sorted by the last column, Jaipur is cheapest at ₹3,875 per person per day and Singapore is priciest at ₹14,000.

How do I calculate this in a sheet?

  • Per day in E2: =D2/B2.
  • Per person per day in F2: =D2/(B2*C2).
  • Sort the table on column F, smallest first, or use the Sort option on the Data menu.
  • To find the cheapest trip's name with a formula, =INDEX($A$2:$A$6,MATCH(MIN($F$2:$F$6),$F$2:$F$6,0)) returns it.

Why was one trip so much dearer?

The table tells you which trip was priciest, not why. For that, split each total into components. A trip abroad has a large fixed cost, such as flights, that a short trip spreads over few days. A trip with a hired car and a private stay will have larger shared costs than one with hostels and buses. Compare components as a share of the total and look for the one that changed most between a cheap trip and a dear one.

Can I fairly compare a short trip with a long one?

Not perfectly. A three-day trip carries its flights over three days, so its cost per day looks high. Compare short trips with other short trips and long ones with long ones. Or take out the fixed costs, such as flights and visas, and compare only the daily costs, which gives a fairer picture of how you live while travelling.

What about trips with children, or trips that were part work?

Decide how to count them before you build the table. If a child under a certain age travelled free, you can count them as a half person or leave them out, but do it the same way on every trip. For a trip that was partly work, remove the business part, such as a client dinner or a conference fee, or mark it, so the table shows what the holiday itself cost you.

What can I do with the result?

  1. Set a target cost per person per day for the next trip based on the trips you liked.
  2. Notice which components rose across trips and decide whether they were worth it.
  3. Use the comparison for planning, not as a score. A pricier trip is not a worse one.

If your spending is already tagged by trip in SpendixAI, a report you filter and group by category gives you the components, and the CSV download carries the figures into a table like the one above.

SPENDIXAI JOURNAL

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

Explore your reports