Free Travel Budget Template Google Sheets, Excel & PDF
Free Travel Budget Template (Google Sheets, Excel & PDF)
A travel budget template lets you set a total for your trip, split it across flights, lodging, food, transport and activities, then log what you actually spend each day. This free template has 9 tabs in Google Sheets (downloadable as Excel) plus a printable PDF, so you can plan the trip before you book and see whether you are on track while you travel.
Get the Free Travel Budget Template
- Google Sheets / Excel version: Open the travel budget spreadsheet
- Printable PDF: Download the travel expenses template PDF
To use the spreadsheet, open the link and choose File > Make a copy so your numbers stay private. For Excel, choose File > Download > Microsoft Excel (.xlsx) and check that the formulas look right in your version.
What Is Inside the Template?
The spreadsheet has nine tabs plus a "Start Here" guide:
| Tab | Use it to |
|---|---|
| Start Here | See what each tab does and how they connect |
| 1 Trip Budget | Set your total and split it by category |
| 2 Pre-Trip Costs | Track flights, lodging, insurance and other costs paid before you leave |
| 3 Expense Log | Record every purchase on the day you make it |
| 4 Daily Summary | Compare each day's spending with your daily allowance |
| 5 Cash & Fees | Track cash withdrawals, card fees and exchange costs |
| 6 Split Costs | Divide shared costs for group trips |
| 7 Pre-Trip Checklist | Make sure bookings and documents are covered |
| 8 Currency Rates | Convert foreign spending back to dollars |
| 9 Business Expense Report | Turn business-trip receipts into a report for reimbursement |
[CONFIRM against the live sheet before publishing: the tab names above come from the sheet's tab bar; the "Use it to" descriptions are inferred from the names. Edit any that differ.]
How to Build a Travel Budget, Step by Step
- Pick a total you can afford. Start from what you can save before departure, not from the trip you want. If the trip costs more, shorten it or change the destination before you book.
- Fill in fixed costs first (tab 2). Flights, lodging, travel insurance, visas and tour bookings are usually known in advance.
- Split what is left across daily categories (tab 1). Food, local transport, activities, shopping and a buffer.
- Add a buffer of 10%. Unplanned costs, such as a missed connection or a pharmacy visit, are the normal part of travel, not exceptions. A 10% buffer is a rule of thumb, not a standard; adjust it for riskier trips.
- Divide the daily categories by trip days. That gives a daily allowance you can check against every evening.
- Log expenses daily (tab 3). A purchase logged the same day is remembered; one logged a week later is guessed.
- Review the Daily Summary (tab 4). If you are over on day two, adjust day three, not day ten.
- Settle up and review. For group trips, use the Split Costs tab before anyone leaves. Afterwards, note which category surprised you and use it for the next trip.
How Much Should You Budget for Each Category?
There is no single correct split, because a beach resort week and a road trip spend money very differently. A starting point to adjust:
| Category | Typical role in the budget |
|---|---|
| Transport to the destination | Often the largest single fixed cost |
| Lodging | Fixed cost; usually the biggest per-night expense |
| Food and drink | Daily category; the most flexible one |
| Local transport | Daily or fixed (rental car, transit pass) |
| Activities | Fixed (tickets booked ahead) plus a flexible amount |
| Fees and extras | Baggage fees, resort fees, card fees, tips |
| Buffer | About 10% of the total |
Fill the percentages from your own quotes, not from an average. Real prices from your own searches beat any generic split.
Travel Budget for a Group Trip
Group trips go wrong when one person pays and nobody keeps the record. Agree the rules before you go:
- Decide what is shared (lodging, groceries, a rental car) and what is personal (souvenirs, extra drinks).
- Decide whether to split equally or by usage. Equal splits are simpler; usage-based splits are fairer when stays or meals differ.
- Record each shared payment, who paid and who owes whom in the Split Costs tab, then settle once at the end instead of passing small amounts all week.
Business Travel Expenses and Mileage
If you travel for work, the Business Expense Report tab gives you a place to turn receipts into a reimbursement report. Keep the receipt photo, date, amount and business purpose together for every line. Employers and the IRS ask for the same basics.
Mileage. For driving your own car for business, the IRS standard mileage rate for 2026 is 72.5 cents per mile. The medical and moving rate is 20.5 cents per mile, and the charitable rate is 14 cents per mile. Log the date, start and end points, miles driven and purpose for each trip. The rate changes each year, so check the current IRS figure before you claim.
Per diem. The federal government (GSA) sets daily lodging and meals allowances for government travel. For travel on or after October 1, 2026, the standard continental-US rates are $113 for lodging and $68 for meals and incidentals, with higher rates in many cities. Some employers use these as a guide, but a private employer can set its own policy.
Check your employer's expense policy for what is reimbursable. This page is educational and is not tax advice.
Travel Budget Mistakes to Avoid
- Budgeting only the booking price. Baggage, resort fees, airport transfers, tips and card or exchange fees come on top.
- Forgetting the pre-trip costs. Insurance, vaccinations, visas and passport renewals sit outside the "daily spending" mindset.
- Skipping the buffer. Without one, any surprise becomes credit card debt.
- Not tracking cash. Cash withdrawals disappear fastest. Log them the same day.
- Putting the whole trip on a card you cannot pay off. Pay for the trip from savings where possible. If you use a card, plan how you will clear the balance before interest starts.
Frequently Asked Questions
Is this travel budget template free? Yes. You can make your own copy of the Google Sheet or download the PDF at no cost. Copy the sheet to your own Google account so your numbers stay private.
Can I use the travel budget spreadsheet in Excel? Yes. In Google Sheets, choose File > Download > Microsoft Excel (.xlsx), then check the formulas and formatting in your version of Excel.
Does the PDF calculate automatically? No. The PDF is for printing and writing by hand. Use the Google Sheet if you want automatic totals.
What is the best way to budget for a vacation? Set a total from what you can afford, subtract fixed costs, split the remainder into a daily allowance, add a buffer, and log your spending each day.
How do I split expenses on a group trip? Decide in advance what is shared and what is personal, record who paid for each shared cost, and settle once at the end using the Split Costs tab.
What is the IRS mileage rate for 2026? 72.5 cents per mile for business use of a car. Medical and moving use is 20.5 cents, and charitable use is 14 cents per mile.
Is this financial or tax advice? No. These are educational templates for organising your own plans.
Key Takeaways
- Set the total first, then fill fixed costs, then split the rest into a daily allowance.
- Add a buffer, log every expense the day it happens, and review the Daily Summary each evening.
- For group trips, agree what is shared and settle once; for business trips, keep receipts and purpose with every line.
- The 2026 IRS business mileage rate is 72.5 cents per mile; check the current rate before claiming.
Keep Learning
- How to Budget for Christmas
- How to Create a Budget
- Weekly Budget Worksheet
- Best Apps to Manage Your Money
This article is for educational purposes and isn't individualized financial, legal or tax advice. Consult a qualified professional for decisions specific to your situation.
Written by Montu Das, Editor & Founder of Smart Money Guide. Verify his MetLife Bangladesh advisor profile.
