Most trips go over budget for the same reason: the hotel price you saw was not the price you paid, and nobody counted the coffee, the subway rides and the airport train. A travel budget template fixes that. You plan each cost before you book, then log what you spend so you always know what is left.
I built a free travel budget template that works in Excel and Google Sheets. It does the math for you, sorts every expense into a category, and adds a buffer for surprises. Below you can download it, see how to use it, and look at a real filled-in example for a 4-night New York trip.
What is in the free travel budget template
The file has 4 tabs:
- How to Use: quick steps and a color key. Yellow cells with blue text are where you type. Everything else is a formula.
- Trip Budget: your trip details (name, destination, travelers, nights) and an estimated cost for 8 categories. The Actual column fills in by itself as you log spending, and the Difference column shows what is left.
- Daily Spending: a log with 100 rows for date, what you bought, category and amount. Each category comes from a dropdown, so nothing gets mistyped.
- Example – New York: a finished budget for 2 people and 4 nights, with every assumption shown so you can change it.
The template also works out your total cost per person and per day, which makes it easy to compare 2 destinations or split costs with friends.

The 8 budget categories (and what goes in each)
A good travel budget planner uses categories that match how you actually spend money on a trip. These are the ones in the template:
| Category | What to include |
|---|---|
| Getting there | Flights, train or bus tickets, gas, tolls, airport transfers, checked bags |
| Lodging | Nightly rate plus taxes, resort fees, parking, cleaning fees |
| Local transport | Subway, buses, rideshares, rental car, parking at attractions |
| Food and drinks | Meals, snacks, coffee, groceries, tips at restaurants |
| Activities and tickets | Museums, tours, theme parks, shows, park passes |
| Travel insurance | Trip insurance, rental car coverage you buy separately |
| Shopping and souvenirs | Gifts, clothes, anything you bring home |
| Fees and other | Luggage storage, phone data, ATM fees, laundry, small tips |
The template adds a 10% buffer on top of your subtotal. You can change it to 5% for a simple trip or 15% for a long one with lots of moving parts.
How to make a travel budget in 5 steps
- Start with the fixed costs. Flights and lodging are usually 50% to 70% of the total, so price them first. Check the full price with taxes and fees, not the headline rate. In Las Vegas, for example, resort fees often add $45 to $55 a night before tax.
- Set a daily food number. Pick an amount per person per day and multiply it by the number of days (nights plus 1). This is the line most people guess too low.
- List the paid activities. Write down the 3 to 5 things you will pay for and look up the real ticket prices. Leave free things off the list.
- Add the small stuff. Local transport, insurance, souvenirs and fees look small one by one, but together they can add 10% or more to a trip.
- Track as you go. Log each purchase on the Daily Spending tab, even if it is only a few dollars. Check the Difference column each night so you can cut back early instead of on the last day.

Example: a 4-night New York trip for 2
Here is the Example tab worked out. All numbers are estimates you can change in the yellow cells.
| Category | Estimate | How it was worked out |
|---|---|---|
| Getting there | $925 | $445 round-trip flight each, plus the $8.75 JFK AirTrain both ways for 2 |
| Lodging | $1,556 | $336 a night for 4 nights, plus 14.75% hotel tax and the $3.50 nightly fee |
| Local transport | $70 | Subway for each traveler, capped at $35 a week with OMNY |
| Food and drinks | $750 | $75 per person per day for 5 days |
| Activities and tickets | $463 | 4 paid attractions at $231.50 per person |
| Travel insurance | $90 | Basic plan for 2 |
| Shopping and souvenirs | $100 | |
| Fees and other | $50 | Tips, luggage storage, phone data |
| Subtotal | $4,004 | |
| 10% buffer | $400 | |
| Total | $4,405 |
About $2,202 per person, or $881 a day
The $445 flight is the US average domestic fare for the second quarter of 2026. Flying from a nearby city, or taking the train, can cut that line by half. See my New York trip cost guide for more ways to bring the total down.

How to use the travel budget template in Google Sheets
The same file works as a travel budget template in Google Sheets. All the formulas and the category dropdown carry over.
- Download the Excel file to your computer.
- Go to Google Drive and click New > File upload, then choose the file.
- Open it, then click File > Save as Google Sheets.
- Click Share if you want your travel partner to log spending too. You will both see the same totals.
On your phone, the Google Sheets app makes it easy to add an expense right after you pay.

Tips to stay on your travel budget
- Book refundable when prices are close. If the price drops later, you can rebook.
- Use one card for the trip. It makes checking your log against your statement much faster. A card with no foreign transaction fee helps if you leave the US.
- Eat your big meal at lunch. Many restaurants charge less at lunch for the same dishes.
- Buy passes only if the math works. Add up the ticket prices you would pay anyway before buying a city pass.
- Pick cheaper ways to get there. My guide to the cheapest way to travel in the US compares flights, trains, buses and driving.
Who this trip budget template works for
This trip budget template fits almost any trip: a weekend away, a family vacation, a road trip or a group trip with friends. For theme park trips, use it alongside my Disney World trip planner. For a train trip, my Amtrak tips post shows how to find the lowest fares to plug into the Getting there line.
If you prefer a vacation budget template with fewer lines, just leave the categories you do not need at $0. The totals still work.
FAQ
Is this travel budget template free?
Yes. The template is free to download and use for personal trips. No sign-up needed.
Is there a travel budget template for Excel?
Yes. The download is an Excel file (.xlsx). It works in Excel 2016 and later, Excel for Mac and Excel online.
Can I use the travel budget template in Google Sheets?
Yes. Upload the file to Google Drive and choose File > Save as Google Sheets. The formulas and dropdowns keep working.
How much should I budget per day for travel in the US?
It depends on the city. For a big city like New York, plan around $800 to $900 a day for 2 people with a mid-range hotel. Smaller cities and road trips can cost half that.
How much buffer should a travel budget have?
10% is a good starting point. Use more for long trips, international travel or trips with kids.
Is there a travel nurse budget template?
This template is made for vacations. Travel nurses on a 13-week contract can still use it by setting the nights to the contract length and using the categories for housing, travel and food, but they will also want to track their stipends and tax home costs with a tax professional.
Final thoughts
A travel budget is not about spending less on everything. It is about knowing where your money goes so you can spend it on the parts of the trip you care about. Download the free travel budget template, fill in your estimates, and take the guesswork out of your next trip.
Last updated: November 15, 2026
Sources:
- Bureau of Transportation Statistics, Q2 2026 average domestic airfare ($445)
- Port Authority of NY and NJ, AirTrain JFK fare ($8.75)
- MTA, OMNY 7-day fare cap ($35)
- NYC Department of Finance, hotel room occupancy tax
