Guides › Travel Budget Spreadsheet: Plan, Track and Split Trip Costs

Travel Budget Spreadsheet: Plan, Track and Split Trip Costs

A good travel budget does three jobs: it tells you whether you can afford the trip before you book, it keeps spending under control while you are away, and it settles who owes what at the end of a group trip. One spreadsheet with three tabs handles all of that. This guide builds it step by step, including currency conversion and a fair-split formula.

Tab 1: The plan

Start with the estimate. Create a table with columns: Category, Item, Estimated cost, Booked?, Actual cost, Paid by. Fill in rows for:

• Transport: flights or trains, airport transfers, baggage fees, car hire and fuel.
• Lodging: each booking, including cleaning fees and local tourist taxes.
• Daily spending: one row calculated as daily amount × people × days.
• Activities: tickets and tours you plan to book in advance.
• Before you go: insurance, visa or entry authorisation fees, vaccinations, gear.
• Buffer: a percentage of the subtotal, for example =SUM(C2:C20)*10%.

The "Booked?" column turns the plan into a checklist. As you book, enter the actual cost; the difference between estimated and actual shows early whether the trip is running over. For a fast first estimate before you build anything, use the travel budget calculator.

Estimating daily spending honestly

Daily spending is where travel budgets usually break. Build the figure from real, current prices: look up menus near your accommodation, the local transport operator's fares, and entry prices on the official sites of attractions. Write down the source next to the number. Avoid relying on cost-of-travel figures from old articles, which may be years out of date and are often based on someone else's travel style.

It also helps to plan different daily rates for different kinds of days. A travel day, a city sightseeing day and a beach day cost very different amounts. A small table of day types (with a rate for each) and a row per day of the trip, each tagged with a type, gives a far more accurate total than one flat average.

Tab 2: The expense log

During the trip, log every expense with: Date, Description, Category, Amount (local currency), Currency, Rate, Amount (home currency), Paid by, Split between. The home-currency amount is =D2*F2 where F2 is the exchange rate. You can type the rate once a day from your card statement or bank app, or in Google Sheets use =GOOGLEFINANCE("CURRENCY:EURUSD") to fetch an approximate current rate. That function gives a market rate, not your card's rate, so treat it as an estimate.

A daily summary row, =SUMIFS(G:G, A:A, date), compared with your planned daily amount, shows immediately whether you are on track. Five minutes each evening is enough.

Tab 3: Splitting costs fairly

For group trips, the expense log already records who paid and who the expense was for. The split tab lists each traveller with two numbers:

• Paid: the total they paid, =SUMIF(Log!H:H, A2, Log!G:G).
• Share: the total of their portion of each expense. If "Split between" is "All", each person's share is the amount divided by the number of travellers. For uneven splits, add one column per traveller in the log with their share of each expense, and sum those.
• Balance: Paid − Share. Positive means the group owes them; negative means they owe.

At the end, the people with negative balances pay those with positive ones. With three or four people it usually takes just two or three transfers.

Saving for the trip

Once the plan tab has a total, divide what is still unpaid by the months before departure. That is your monthly trip saving. Set up an automatic transfer to a separate savings bucket. If you already use sinking funds, the trip is simply one more fund with a target and a due date.

Money tips that apply almost everywhere

• Check your card's foreign transaction fee before you go. Some cards charge a percentage on every purchase abroad; others do not.
• Decline conversion at the terminal. When a card machine or ATM offers to charge you in your home currency, the conversion rate offered is often worse than your card's. Compare before you accept.
• Know ATM fees. Both your bank and the local ATM operator may charge. Fewer, larger withdrawals reduce fixed fees.
• Keep a backup card in a different place from your main one.

Fee levels vary by bank and country, so check your own bank's published fee schedule rather than relying on general figures.

After the trip

Compare the planned and actual columns category by category. Most people find one or two categories consistently off, often food or local transport. Record what you learned in a notes cell: "Daily food in a big city: plan more than I thought". Your next trip budget will be much more accurate, and it takes only a minute.

Honeymoon and wedding travel

For a honeymoon, keep the trip plan inside your wedding planning file so the total wedding budget stays visible. The wedding budget calculator and our wedding budget guide show how to reserve a share for travel.

Checklist: the spreadsheet in 20 minutes

1. Create three tabs: Plan, Log, Split.
2. In Plan, list every cost category with estimated and actual columns and a buffer row.
3. In Log, add columns for local amount, currency, rate, home amount, paid by and split between.
4. Add dropdowns for categories and traveller names.
5. In Split, add paid, share and balance formulas for each traveller.
6. Share the file with fellow travellers so everyone can log expenses from their phone.

Using a shared file from day one avoids the most common group-trip problem: one person paying for everything and reconstructing who owes what from memory at the end. It also means everyone sees the daily total, which keeps the group naturally closer to the plan.

FAQ

What should a travel budget spreadsheet include?

Transport, lodging, daily spending, activities, pre-trip costs like insurance and visas, and a buffer, with estimated and actual columns.

How do I convert currencies in Google Sheets?

Multiply the local amount by an exchange rate. GOOGLEFINANCE("CURRENCY:EURUSD") fetches an approximate market rate; your card rate may differ.

How do we split trip costs fairly?

Log who paid and who each expense was for. Each person's balance is what they paid minus their share; people with negative balances pay those with positive ones.

How much should I budget per day?

Build it from current local prices for food, transport and attractions rather than generic averages, and plan different rates for different types of days.

Should I include a buffer?

Yes. Around 10% is a common rule of thumb; use more for long or complex trips.

For general education and planning only. Not financial, tax or legal advice. Check important decisions with a qualified professional.