Travel Budget Template: Free Layout and Daily Budget Calculator

The Travel Budget Template (Copy This Layout)

Paste this into Google Sheets or Excel. One row per category, five columns.

Two formulas do all the work. In the Difference column, enter =B2-C2 and copy it down, so a positive number means you came in under plan. In the Total row, use =SUM(B2:B12) for each column.

Fill Planned before you leave. Fill Actual as you spend. The comparison is the point of the whole sheet.

How to Calculate Your Daily Travel Budget

The daily number is what keeps you on track once you're moving. The formula:

Daily budget = (total budget − pre-paid costs − buffer) ÷ number of days

• Total budget is the most you will spend on the whole trip.
• Pre-paid costs are paid before you leave: flights, insurance, an eSIM, and any hotel you booked in advance.
• Buffer is money you don't plan to spend. A buffer of 10–15% of the total is a common rule of thumb, and more for destinations you don't know.

Here is a worked example for a 10-day trip.

Then split the daily number across categories. This is an illustration, not a rule, and real splits vary a lot by destination:

Decide up front where lodging belongs. In this example it's paid on the road, so it sits in the daily split. If you've already pre-paid it, move it to the pre-paid line and take it out of the split. Counting it in both places is the most common way to end up with a daily number that's too generous.

Add a Currency Column for Trips Abroad

If you spend in another currency, add three columns: the local amount, the exchange rate, and the home-currency amount. Plan in the local currency where prices are quoted, such as ¥, ฿, or €, then convert to your home currency in the third column.

Pick one rate for planning and write it at the top of the sheet. Exchange rates move every day, so refresh it just before you leave. And remember that some costs stay in your home currency while you're away: flights, insurance, subscriptions. Mixing the two in one column is how totals go wrong.

Planned vs. Actual: Track as You Go

A template tells you what a trip should cost. It can't tell you what it did cost, because the sheet is only as accurate as the entries you type in. Most travelers stop typing by day three, especially for small cash purchases.

SpendSnap closes that gap. You log each expense in the currency you paid, and it converts everything to one home-currency total using rates it refreshes once a day. Quick-add re-logs a repeat purchase in one tap. It works offline, and it needs no bank connection, so cash is tracked as easily as cards.

Two features map onto the template. You can run a dedicated trip budget next to your everyday budget at the same time, so planning numbers don't mix with your normal month. And you can choose when an expense counts, so a flight you paid for in spring lands on the trip you take in autumn. When you want the spreadsheet back, export your data to .csv and paste the totals into the Actual column. The app is the faster way to capture spending. The sheet is where you compare. If you're weighing a sheet against an app for the whole job, our expense tracker template guide covers that, and the travel budget app page shows how SpendSnap handles trips.

What a Day Costs in Popular Destinations

A template is only useful with realistic numbers. Our destination guides break down daily costs for Japan, Thailand, Bali, Vietnam, and Nicaragua. For the full method of setting a total budget, start with how to budget for a trip.

Common Mistakes in a Travel Budget

• No buffer. Every trip has a cost you didn't plan: a missed connection, a fee, a taxi at midnight.
• Counting lodging twice. Pre-paid lodging belongs in one place only.
• Forgetting small fees. ATM fees, entry fees, and tips don't appear on any booking.
• Mixing currencies in one column. Keep local and home-currency amounts apart.
• Never comparing to actuals. A plan you don't check against reality is a guess.

Frequently asked questions