Most travel budgets die on day three. You plan to track every coffee, then a train strikes, dinner runs long and the spreadsheet sits unopened until you’re home and guessing. A good travel budget template for Google Sheets fixes that by being fast to fill in, not by being clever. Below is the one we’d build: four tabs, a handful of formulas, and a daily spending number you can check from your phone in ten seconds. [ADD SHEET LINK HERE]
What goes in a travel budget and itinerary template?
Four tabs cover almost every trip: Trip, Budget, Itinerary and Expenses. Trip holds the basics (dates, home currency, exchange rate). Budget compares planned spending with actual spending by category. Itinerary lists what happens on each day. Expenses is a plain log where every purchase is one row.
That’s the whole system. Everything on the Budget tab is calculated from the Expenses log, so you only ever type a purchase once.
Open a new Google Sheet, rename the first tab “Trip”, and add three more. Tab names matter, because the formulas below refer to them by name.
Tab 1: Trip
This tab is small on purpose. It holds the numbers every other tab leans on.
| Row | Label | Example |
|---|---|---|
| A1 | Trip name | Autumn in Lisbon |
| A2 | Start date | 10/04/2027 |
| A3 | End date | 10/14/2027 |
| A4 | Days | `=B3-B2+1` |
| A5 | Home currency | USD |
| A6 | Local currency | EUR |
| A7 | Exchange rate (1 local = X home) | `=GOOGLEFINANCE(“CURRENCY:EURUSD”)` |
| A8 | Total budget (home currency) | 2,400 |
| A9 | Daily limit | `=B8/B4` |
Put the labels in column A and the values in column B. The formulas assume that.
The exchange rate cell is the one worth a minute. `GOOGLEFINANCE` pulls a live rate, and guides to the function say it can lag by up to about 20 minutes, which doesn’t matter for a budget. Swap EUR and USD for your own pair, then check the number once against a currency converter. If it comes out as the inverse of what you expected, flip the two codes. If you’d rather have a fixed rate for the whole trip, type one in by hand and stop worrying about it.
The daily limit in B9 is the number you’ll look at most. It’s your total budget divided by the number of days. On the example above (11 days, $2,400) that’s about $218 a day (the numbers in this post are made up to show the math, not a price guide).
Tab 2: Budget
Here’s where planned meets actual. List your categories down column A, then three columns across.
| Category | Planned | Actual | Difference |
|---|---|---|---|
| Flights | 750 | `=SUMIF(Expenses!C:C, A2, Expenses!F:F)` | `=B2-C2` |
| Lodging | 700 | same formula, A3 | `=B3-C3` |
| Food and drink | 450 | same formula, A4 | `=B4-C4` |
| Local transport | 150 | same formula, A5 | `=B5-C5` |
| Activities | 200 | same formula, A6 | `=B6-C6` |
| Shopping and gifts | 80 | same formula, A7 | `=B7-C7` |
| Buffer | 70 | same formula, A8 | `=B8-C8` |
| Total | `=SUM(B2:B8)` | `=SUM(C2:C8)` | `=B9-C9` |
`SUMIF` is doing the heavy lifting. It looks down the Category column of the Expenses tab, finds every row matching the name in column A, and adds up the home-currency amounts. Type a new expense and the Budget tab updates on its own.
Select the Difference column and add a rule under Format > Conditional formatting: red text when the value is below zero. A negative number means you’ve spent more than you planned in that category, and you’ll see it without reading anything.
How should you split the money? It depends on the trip, so treat this as a starting point and not a rule. Flights and lodging usually eat more than half of a total budget on a trip of a week or two. Food and activities share most of the rest. We’d always keep a buffer of around 5 percent, because something will cost more than you planned, and a line for it means the surprise doesn’t wreck your totals.
Tip: if you travel as a couple or a group, add a column called “Paid by” on the Expenses tab later. It makes splitting costs at the end a two-minute job instead of an argument.
Tab 3: Itinerary
An itinerary tab doesn’t need to be pretty. It needs to answer one question when you’re standing on a street corner: what’s next?
| Date | Day | Morning | Afternoon | Evening | Booked? | Notes |
|---|---|---|---|---|---|---|
| `=Trip!B2` | `=TEXT(A2,”dddd”)` | Dropdown | ||||
| `=A2+1` | `=TEXT(A3,”dddd”)` | Dropdown |
Fill the first date from the Trip tab, then add one to the row above for each following day. The Day column turns each date into a weekday name, which helps when you’re checking which museum closes on Mondays.
Make the Booked column a dropdown. Select the cells, open Data > Data validation, add a rule, and choose “Dropdown (from a range)” or a custom list with Yes, No and Free. Color each option if you like. Then you can scan the column and see at a glance what’s still unbooked.
Two habits make this tab work better than a notes app. First, put the address or the confirmation number in the Notes column, not in an email you’ll have to dig out later. Second, plan one unplanned afternoon in every four or five days. A tightly packed itinerary looks great in a spreadsheet and feels terrible by day six.
Note: Google Sheets works offline once you turn it on in the Google Drive settings, and the Sheets app on a phone can keep a file available without a signal. Switch it on before you leave, not at the airport.
Tab 4: Expenses
This is the tab you’ll actually use, so it has to be fast. One row per purchase, six columns.
| Column | Header | What goes in it |
|---|---|---|
| A | Date | Type it or use `=TODAY()` and paste as values |
| B | Description | Short: “ramen”, “metro card” |
| C | Category | Dropdown linked to the Budget tab’s category list |
| D | Amount (local) | What the receipt says |
| E | Currency | Local or home |
| F | Amount (home) | `=IF(E2=Trip!$B$5, D2, D2*Trip!$B$7)` |
Column F is the formula that makes the whole thing worth building. If you paid in your home currency, it keeps the number. If you paid in the local currency, it multiplies by the rate on the Trip tab. Drag it down about 200 rows in advance so you never have to copy it in the middle of a street.
Set up the Category column as a dropdown pointing at `Budget!A2:A8`. Pick “Dropdown (from a range)” in the data validation menu, and type the range in. Because the Expenses categories come from the Budget tab, a typo can’t create a category that doesn’t exist, which is the usual reason a budget total quietly drifts away from reality.
Put a frozen row at the top (View > Freeze > 1 row) so the headers stay put as the list grows.
How do you check your daily spending?
You need one more number, and it goes at the top of the Budget tab. Add a cell labeled “Spent so far” with `=C9`, then another labeled “Left per remaining day” with this formula:
`=(Trip!B8-C9)/MAX(1, Trip!B3-TODAY()+1)`
It takes what’s left of the total budget and divides it by the days still ahead, never less than one so the sheet doesn’t throw a divide-by-zero error on the last day. A big day on Tuesday just lowers the number for the rest of the week, which is more honest than pretending Wednesday starts fresh.
Check it once a day, in the evening, over a drink. Two minutes. If you wait until the trip is over, you’re not budgeting any more, you’re doing accounting.
Can you use this for a trip with more than one currency?
Yes, with one change. Add a small table on the Trip tab listing each currency and its rate, then replace the multiplication in column F with a lookup: `=D2*VLOOKUP(E2, Trip!$D$2:$E$6, 2, FALSE)`. The Currency dropdown on the Expenses tab can then point at the same list. It takes five extra minutes to set up and saves you re-entering rates at every border.
A fair warning: multi-country trips go over budget more often than single-city ones. Each border adds a transfer, a new transit card and a few days of not knowing what anything should cost. We’d raise the buffer to 8 or 10 percent for them.
Mistakes that break a travel budget
Most spreadsheets fail for boring reasons, and a few are worth designing against.
Forgetting the small stuff. Cash withdrawals, baggage fees, tips, SIM cards and the 3 dollar bottle of water at the airport don’t feel like spending, but they add up. Give them a home. A category called “Misc” works, and so does adding them to Food and drink, as long as they go somewhere.
Budgeting before you know the prices. The planned column is a guess on day zero. After the first two days, look at the real numbers and adjust it, so the sheet reflects the trip you’re actually on. Adjusting isn’t cheating. A plan you never revise stops being useful the moment it’s wrong.
Double-counting prepaid things. A hotel you paid for months ago still belongs on the sheet. Log it once, at the full price, under Lodging, and don’t add it again when you check out.
Tracking too much. If you stop logging after day four, the template is too heavy. Drop the columns you don’t need. Date, category and amount are enough.
Tip: log the expense in the moment, when you still have the receipt in your hand. Waiting until the evening means trying to remember what you paid for a pastry six hours ago.
What does the finished sheet look like?
Once you’ve filled in a few days, it’s worth adding one chart. Select the Category and Actual columns on the Budget tab, choose Insert > Chart, and pick a bar or pie chart. It turns a table into a picture, and a picture of where your money went is more persuasive than any row of figures. You could also add a second chart of daily spending over time to spot the days that blew the limit, usually the ones with a long dinner in them.
If you’re sharing the sheet with a partner, use the Share button and give them Editor access. Both of you can log expenses from your own phones, and the totals update for everyone.
And when the trip is over, keep the sheet. Duplicate the file for the next trip (File > Make a copy), clear the Expenses tab, and update the Trip tab. The category list and formulas are already set up, and the finished version is a record of what a week in a given place actually cost you, which is more useful for the next plan than any online average.
Tip: name each copy with the destination and year, like “Lisbon 2027 budget”, so the old ones stay easy to find and compare.










Leave a Reply