Free Travel Budget Planner: Trip Budget by Category, Daily Travel Budget, and a Vacation Savings Plan (PDF, Word, Excel)

What is on the page

Travelers, nights and total budget

The basics that turn the total into a cost per person and per night, and compare it with what you set aside.

Estimate and actual

Estimate each category before you book; fill in the actual cost as you pay. Excel shows the difference line by line.

Daily budget and running total

On the daily sheet, the amount you allow per day and the running total for the trip, so you can see by day three whether you are on track.

Exchange rate

For trips abroad, write spending in the local currency and enter the rate once; Excel converts the trip total.

Save per month

On the savings plan, the remaining cost divided by the months left, and the same amount per biweekly paycheck.

How to make a travel budget

Start with the big three: getting there, staying there and getting around. Check real prices for your dates rather than guessing, and include the costs that are easy to forget: checked bags and seat fees, airport parking, resort and cleaning fees, tourist taxes, travel insurance, tips, a data plan or eSIM, and someone to look after the pet. Food is usually the biggest surprise; a simple rule is to budget each meal at what that meal costs at home multiplied by two or three for eating out, less if your lodging has a kitchen. Add an emergency buffer of 5 to 10%. Write the total budget at the top, and Excel shows whether the estimate fits.

Tracking spending on the trip

The daily budget sheet is the one to take with you (or keep on your phone). Each evening, write the day's spending in five columns. The day total and the "vs budget" column tell you straight away whether today was over or under, and the running total shows the trip so far. One expensive day is fine if the next is quieter; three in a row means adjusting the plan. For trips abroad, record spending in the local currency and convert once at the end with the rate on the sheet. Card purchases abroad may carry a foreign transaction fee of up to about 3%; a card without one is worth having before you go. For receipts and business trips, use the trip expense tracker.

Saving for a vacation

Paying for a trip before you go is the difference between a holiday and a holiday plus six months of card interest. The savings plan works backwards: trip cost, minus what you already have, divided by the months until you leave. In the sample, a $7,200 trip with $600 saved and eleven months to go needs $600 a month, or about $277 per biweekly paycheck. Set up an automatic transfer on payday into a seperate savings account, and add windfalls like a tax refund. The deposit log keeps the running total and the amount still to go.

Ways to cut the cost

Travel outside school holidays if you can; flexible dates often save more than any other trick. Set fare alerts and book flights a couple of months ahead for domestic trips. Compare a rental with a kitchen against a hotel once you add up the meals. Price the whole trip, including fees and parking, before choosing between flying and driving. Pack light to avoid bag fees. And decide your souvenir and treats budget per person before you leave, especially with kids.

Editing the files

The Excel and ODS files total the budget, work out cost per person and per night, track daily spending with a running total and currency conversion, and calculate the monthly savings amount. Rename the categories in Excel or Word to fit your trip (a ski trip needs lift passes and rentals; a cruise needs gratuities and excursions). The PDFs are fillable.

Questions

What should a travel budget include?

Transport to and at the destination, lodging with fees and taxes, food, activities, travel insurance, documents and data, tips, souvenirs, pet or house sitting, and an emergency buffer.

How much should I budget per day for travel?

Add up lodging, food, local transport and activities for one typical day at your destination; the daily sheet then compares each day with that number.

How do I save for a vacation?

Divide the trip cost, less what you already have, by the months until you leave, and set up an automatic monthly or per-paycheck transfer. The savings plan calculates it.

Can I track spending in a foreign currency?

Yes. Record amounts in the local currency on the daily sheet and enter the exchange rate; Excel converts the trip total.

Does the PDF calculate totals?

No. The fillable PDF is for typing and printing. The Excel and ODS versions do all the calculations.