Travel Budget Template for Excel and Google Sheets: Estimate the Trip, Save for It and Track Daily Spending
Build a travel budget template in Excel or Google Sheets: line items by person, night and day, hotel taxes and a buffer, the monthly amount to save before you leave, a daily spending allowance and a currency column, with a family-of-four example.
A travel budget template estimates the full cost of a trip — flights, lodging with taxes and fees, car, gas and parking, food, activities, insurance and a buffer — then turns that total into a monthly savings target before you go and a daily spending allowance while you are away. It answers the three questions that matter: can we afford this trip, how much do we need to set aside each month, and are we on track once we are there?
This guide sits in Personal Finance & Budgeting. To fund the trip, add it as a goal in the savings goal tracker.
Sheet 1: Trip estimate
| Column | Content | Formula |
|---|---|---|
| A – Item | Flights, lodging, car… | — |
| B – Basis | Per person, Per night, Per day, Per person per day, Flat | dropdown |
| C – Unit cost | Your best quote | — |
| D – Estimate | Total for the line | =C2*SWITCH(B2,"Per person",$H$1,"Per night",$H$2,"Per day",$H$3,"Per person per day",$H$1*$H$3,1) |
| E – Actual | From the spending log | =SUMIFS(Log!D:D,Log!C:C,A2) |
| F – Difference | Actual − estimate | =E2-D2 |
H1 holds travelers, H2 nights and H3 days. SWITCH needs Excel 2019 or later; in older versions use nested IFs. Two lines people forget: lodging taxes and fees, which can add a meaningful percentage to the nightly rate, and a buffer line such as =10%*SUM(D2:D9).
Worked example: family of four, 6 nights / 7 days, June 2027
Prices are illustrative; plug in real quotes for your dates.
| Item | Calculation | Estimate |
|---|---|---|
| Flights | $320 × 4 travelers | $1,280.00 |
| Hotel | $210 × 6 nights | $1,260.00 |
| Hotel taxes & fees | 15% of room cost (assumed) | $189.00 |
| Rental car | $55 × 7 days | $385.00 |
| Gas & parking | Flat | $175.00 |
| Food | $45 × 4 × 7 days | $1,260.00 |
| Activities | Flat | $480.00 |
| Travel insurance | Flat | $120.00 |
| Subtotal | $5,149.00 | |
| Buffer (10%) | $514.90 | |
| Total | $5,663.90 | |
| Per traveler | $1,415.98 | |
| Per day (whole family) | $809.13 | |
Sheet 2: Save before you go
With the departure date in B1 and what you have already saved in B2:
- Months left:
=DATEDIF(TODAY(),B1,"m") - Monthly target:
=(Total-B2)/Months_left
From November 6, 2026 to a June 1, 2027 departure there are six full months. Starting from zero, the family needs $943.98 a month; with $1,200 already set aside, the target drops to $743.98. If that does not fit the budget — compare it with the “wants” share of your 50/30/20 budget — the levers are a cheaper week, fewer nights, or booking flights earlier.
Sheet 3: Daily allowance and spending log
Pre-paid items (flights, hotel, car, insurance) are fixed once booked. The part you control on the trip is food and activities. The daily allowance is =(Food+Activities)/Days: here ($1,260 + $480) ÷ 7 = $248.57 a day.
Log each purchase with date (A), description (B), item (C), amount in dollars (D), amount in local currency (E), currency (F) and the rate your card actually applied (G). For trips abroad, D becomes =IF(F2="USD",E2,E2*G2); using the rate on your statement captures card fees that a reference rate would miss.
On-trip check
| Day | Spent | Allowance to date | Spent to date | Status |
|---|---|---|---|---|
| 1 | $230.00 | $248.57 | $230.00 | Under |
| 2 | $275.00 | $497.14 | $505.00 | Over by $7.86 |
| 3 | $240.00 | $745.71 | $745.00 | On track |
The running comparison is =SUMIFS(Log!D:D,Log!A:A,"<="&A2)-$Allowance*Day. One expensive day is fine as long as the cumulative line comes back; the sheet shows that without anyone having to do mental math at the dinner table.
Tips that keep trips on budget
- Book the big three first — flights, lodging, car — and replace estimates with real prices immediately.
- Read the total, not the nightly rate: resort fees, parking and taxes change hotel comparisons.
- Agree on extras up front: souvenirs or a pricey excursion can have their own line so they don’t eat the food budget.
- Check cancellation terms and what your insurance actually covers before paying.
- Traveling with friends? Add a “Paid by” column and settle up with
=SUMIF(Log!H:H,Name,Log!D:D)-Total/Peoplefor each person.
Related guide: Net Worth Spreadsheet for Excel and Google Sheets.
FAQ
How big should the buffer be?
Around 10% is a common starting point for a familiar, short trip. Longer trips, travel with young children or destinations where prices are hard to predict often justify more.
Does this work in Google Sheets?
Yes — and it is handy because everyone on the trip can add expenses from their phones to the same sheet.
Can I use it for a wedding or a business trip?
Weddings have their own wedding budget spreadsheet. Business travel usually follows company expense policies; track those receipts in the business expense tracker.
Next step: enter travelers, nights and days, price the big three with real quotes, and set up an automatic monthly transfer for the savings target.
