Free download

Free Travel Budget Template

A spreadsheet that plans a trip's budget and tracks it as you go — for Excel, Google Sheets and Numbers.

Download the template (.xlsx)

Free, no sign-up. Opens in Excel, Google Sheets and Numbers.

Most travel budgets fall apart for the same two reasons: the plan was one number for the whole trip, so nobody can tell on day three whether they're on track, and half the spending happened in a currency the spreadsheet never converted. This template is built around both. You plan each category per person per day, log what you spend in whatever currency you paid, and the sheet tells you what's left.

What's in the template

Five sheets, each doing one job:

  • Budget — the plan. A daily amount per person for accommodation, food, transport, activities and the rest, plus whole-trip totals for flights, insurance and shopping. It multiplies by the days and the travellers, then shows what you've spent, what's left, and the share of the plan used for every category.
  • Expenses — the log. One row per thing you pay for: date, what, category, the amount and currency you paid, that day's rate, and the converted figure. There's a column for who paid and whether it was cash or card.
  • Split — who owes whom on a shared trip, from the "paid by" column.
  • Lists — the categories and the travellers' names, which feed the drop-downs.
  • How to use — the short version of this page.

It comes with an example — five days in Lisbon and Porto for two — so you can see how it behaves before you replace it with your own trip.

The Budget sheet, with the example trip: 5 days, 2 travellers
Category Per day, per person Planned Spent Left
Flights—420.00412.008.00
Accommodation40.00400.00368.0032.00
Food & drink35.00350.007.40342.60
Local transport8.0080.006.4073.60
Activities15.00150.000.00150.00
Total (all eight categories)1,610.00793.80816.20

How to use it

  1. On Budget, fill in the trip, your home currency, the first and last day, and how many of you are going. Everything in yellow is yours to change.
  2. Give each everyday category a daily amount per person, and put a total against flights, insurance and visas, and shopping.
  3. On Expenses, add a row every time you pay for something, and pick the category from the drop-down.
  4. When you pay in another currency, enter the amount you paid and the rate for that day. The home-currency column does the conversion.
  5. Check Budget once a day. A red "left" figure means that category has gone over.

To open it in Google Sheets, upload the file to Google Drive and choose Open with Google Sheets. Numbers and Excel open it directly.

Setting a daily budget that holds

The per-day column is where most budgets go wrong, because the number gets guessed. The trip budget calculator starts from real daily figures for eight destinations and works out the whole trip, which you can copy straight into the sheet. Or make the number real yourself, two ways. Look up what the place actually costs: our guides price the daily spend at three levels for Japan, Paris, Italy, Thailand and more. Or take your last trip: if you tracked it, the category totals divided by the days and the people give you a daily figure that already includes your own habits.

Then add a line for the things budgets forget: card fees abroad, tourist taxes paid at the hotel, the airport transfer. The hidden costs of travel lists the usual suspects.

Exchange rates: the column people get wrong

Use the rate for the day you paid, not the rate on the day you planned the trip, and not today's rate when you sit down to catch up. For card payments, the rate on your bank statement is the honest one, because it includes what your bank charged. For cash, divide what you got by what you handed over at the exchange counter — that's the rate you actually paid, and it's often a few percent worse than the one on the screen.

Where a spreadsheet gets painful

A spreadsheet works well at a desk. On the road it asks you to remember every coffee until you're back at a laptop, to look up a rate for each one, and to keep the paper receipts somewhere in between. If you've tracked a two-week trip this way, you know the evening where you sit down with a pile of receipts in a language you can't read. Keeping track of receipts while travelling covers the habits that make it easier, spreadsheet or not.

Spentrip does the same job from your phone. Photograph the receipt and it reads the merchant, the total and the line items, files them under the right category, and converts them at that day's rate, so the running total is always in your money. On a shared trip everyone logs their own spending and the report shows each person's total.

Common questions

Is the travel budget template really free?

Yes. Download it, change it, share it. There's no sign-up and nothing to unlock.

Does it work in Google Sheets?

Yes. Upload the file to Google Drive and open it with Google Sheets; the formulas and drop-down lists carry over. Numbers and Excel open it directly.

Can I use it for a group trip?

Yes. Put everyone's names on the Lists sheet, record who paid for each expense, and the Split sheet shows what each person paid against an equal share — a positive balance is owed money, a negative one owes it.

Which currency does it use?

Any. Set your home currency on the Budget sheet, then log each expense in the currency you paid with the exchange rate for that day. The sheet converts it, so every total is in your money.

Can I use it as a business trip expense report?

As a log, yes: the Expenses sheet has date, merchant, category, amount and currency. An employer usually wants the receipt behind each line as well, which a spreadsheet can't attach — Spentrip's PDF reports put the receipt image next to every expense.

Done with typing expenses into cells?

Spentrip does what this spreadsheet does from your phone: photograph a receipt in any of 50+ languages, and it lands in the right category, converted at the day's rate.

Get Spentrip