Travel Planner and Budget Template for Google Sheets: Free to Copy
This free travel planner and budget template for Google Sheets separates three numbers that are easy to confuse: what you expect the trip to cost, what you've already paid, and what remains to pay. Copy the tables below into three tabs named Costs, Budget and Itinerary, then add the formulas. There's no email gate or paid download.
By the Amicly Team · Published October 26, 2026. This is a copy-and-paste build, not a hosted Google Sheets “Make a copy” link. All sample prices are invented to demonstrate the calculations.
How the template works
Use Costs as the detailed list of expenses, Budget as your category summary and Itinerary for the day-by-day plan. Keep every amount in one base currency. The formulas don't fetch exchange rates or bank transactions.
The sample represents two people taking a five-day, four-night trip with a total spending limit of 2,000 currency units. It demonstrates the math only; it isn't a quote or a claim that a particular destination costs this amount.
| Figure | What it means | Sample result |
|---|---|---|
| Budget ceiling | Maximum allocated, including the reserve | 2,000 |
| Forecast cost | Latest expected full cost, whether paid or unpaid | 1,500 |
| Paid so far | Money already paid toward those costs | 520 |
| Outstanding forecast | Expected payments still to make | 980 |
| Headroom | Budget ceiling minus forecast, including unspent reserve | 500 |
The crucial point: 1,500 forecast plus 520 paid is not the total trip cost. The paid amount is already part of the forecast. Adding the two would count it twice.
1. Build the Costs tab
Create a blank spreadsheet in Google Sheets and rename the first tab Costs. Copy the tab-separated block below and paste into cell A1. You should get headers across A:H and six example expenses in rows 2–7.
Category Item Quantity Unit cost Forecast Paid Outstanding Status Flights Return flights for two 2 180 360 Paid Stay Room nights 4 120 120 Deposit paid Food Daily food for both 5 60 0 Estimate Transport Local travel allowance 1 100 0 Estimate Activities Activity allowance per person 2 80 40 Part paid Other Miscellaneous costs 1 100 0 Estimate
Enter these formulas, then copy both cells down through row 7:
E2: =C2*D2 G2: =MAX(0,E2-F2)
Column E is the expected full cost. Column F is an input: change it when you actually pay. Column G calculates the expected amount still unpaid. If the final hotel price is different from your estimate, update the quantity or unit cost so the forecast stays current.
For the sample room booking, four nights at 120 gives a forecast of 480. A deposit of 120 leaves 360 outstanding. When you pay the balance, change Paid to 480. Don't add the full booking again as a new expense.
If everything pastes into one column
The separators in the block are tabs. Use Google Sheets' split-text-to-columns control with the matching separator if needed, or save the block as a .tsv file and import it. Google's import guide confirms TSV support and separator selection. Check that “Unit cost” lands in D1 before entering formulas.
Format the monetary columns as numbers or your chosen currency. Keep amounts numeric—enter 120, then use cell formatting, rather than typing a currency abbreviation into every value.
2. Create your category budget
Add a second tab named Budget. Paste this block into A1:
Category Allocated Forecast Paid Outstanding Headroom Flights 400 Stay 550 Food 350 Transport 120 Activities 200 Other 130 Reserve 250 Total
Enter the following formulas in row 2. Copy C2:F2 down through row 8 so each category, including Reserve, gets its own calculation:
C2: =SUMIF(Costs!$A$2:$A$1000,A2,Costs!$E$2:$E$1000) D2: =SUMIF(Costs!$A$2:$A$1000,A2,Costs!$F$2:$F$1000) E2: =SUMIF(Costs!$A$2:$A$1000,A2,Costs!$G$2:$G$1000) F2: =B2-C2
In row 9, enter the totals:
B9: =SUM(B2:B8) C9: =SUM(C2:C8) D9: =SUM(D2:D8) E9: =SUM(E2:E8) F9: =B9-C9
SUMIF adds values that match a category. The dollar signs keep the expense ranges fixed when you copy the formula. Category names must match between the two tabs: “Transport” and “Local transport” won't be treated as the same label.
The ranges end at row 1000. If you expand beyond that, extend every relevant range together. Whenever you add an expense row, copy the forecast and outstanding formulas into that new row too.
Keep the reserve inside the ceiling
The sample allocates 250 to Reserve but doesn't enter it as an expense. It is money you've set aside, not money you've spent. If an unexpected cost appears, add that real expense under its appropriate category or under Reserve, and let the forecast rise. Don't count both the reserve allocation and the new expense as costs.
In the sample, the total 500 of headroom consists of 250 reserved and another 250 not yet assigned to forecast expenses. If you want to keep the reserve intact, don't read all 500 as extra spending money.
3. Add the itinerary without duplicating the costs
Create a third tab called Itinerary and paste this structure into A1:
Day Date Time window Activity Area or address Transport Booking status Cost reference Backup 1 [date] Arrival Transfer and check-in [hotel area] [mode] [status] Costs row [number] [alternative] 2 [date] Morning One main activity [area] [mode] [status] Costs row [number] [indoor option] 2 [date] Afternoon Nearby flexible stop [area] [mode] Optional Included or no extra cost [rest] 3 [date] Morning Next priority [area] [mode] [status] Costs row [number] [alternative]
The cost-reference column points back to the detailed expense instead of adding another bill. A prepaid tour can appear in the daily plan and in Costs, but it should enter the budget calculation only once.
Give arrival and departure their own time windows. If you need a starting layout, our day-by-day itinerary templates cover several trip shapes. Use the multi-day Google Maps planning guide to check whether your daily stops belong together.
Check the calculations before replacing the example
With the sample unchanged, the expense forecasts should be 360, 480, 300, 100, 160 and 100. They sum to 1,500. The paid amounts are 360, 120 and 40, totaling 520. Outstanding should total 980.
Now try one small change: change the room's Paid amount from 120 to 480. The forecast should remain 1,500; Paid should become 880; Outstanding should fall to 620. If the forecast changes when you only change a payment, check that your forecast formula uses quantity and unit cost, not Paid.
Once those checks work, replace the sample rows with your own expenses. Retain a clean copy before every new trip so old payments don't accidentally appear in the next holiday.
Adapt the budget to your travel style
Couples and friends
The example covers the whole group. For an equal two-person split, the forecast per person is =C9/2 on the Budget tab. That is a rough share of the full trip, not a reimbursement calculation. If one person pays more deposits, add a separate “Paid by” record and reconcile reimbursements separately; a transfer between travelers isn't a new travel expense.
To work out who owes whom, use our group travel expense spreadsheet. It adds per-person shares and a separate repayment ledger, including a worked example for a meal that one traveler skips.
Multiple currencies
Convert each expense to the same base currency before adding it to this simple sheet. Keep the original amount and conversion note alongside it if useful. For an estimate, record the assumed rate and date; for a settled card payment, use the actual charged amount. Never sum 100 euros and 100 yen as if they were the same unit.
Road trips
Break transport into rental, fuel, tolls, parking and any separately charged extras. Use your actual quotes or clearly labeled estimates. A single “car cost” line is easy to underestimate when it includes only the rental headline price.
Questions and formula fixes
Why do I see a formula parse error?
Some spreadsheet locales use semicolons rather than commas between function arguments. Adjust the separators if your locale requires it. Also check that quotes are straight, the tab names match exactly, and you pasted the formula starting with an equals sign.
Why is one category showing zero?
Check spelling and extra spaces in the category labels, confirm that the amounts are numbers, and make sure the expense is inside rows 2–1000. The status text is for your reference; changing “Estimate” to “Paid” does not update the numeric Paid column.
Does “outstanding” include money already owed and future estimates?
Yes. This version shows the forecast payments still to make. It is not a due-date calendar or a bank balance. Add a due-date column if you need to know which bills are due before departure.
For payment dates, cancellation cutoffs and the person responsible for each reservation, copy our travel booking tracker template. It keeps deadlines separate from the budget totals.
What about refunds and overpayments?
The MAX formula keeps Outstanding from going negative, so it doesn't track refund receivables. Record any refund due separately and reconcile Paid after the refund arrives. Don't treat an expected refund as available cash.
Can I download this as Excel?
After you've built the sheet, you can export your own spreadsheet. There is no attached workbook on this page. If you import another workbook, Google's import guide lists supported formats, including .xlsx. Recheck formulas after converting formats.
Before you leave, combine this budget with the travel itinerary checklist. If you want to explore a dedicated planning tool as well, visit Amicly. This blog is published by the team behind Amicly.
Comments
Post a Comment