Holiday Travel Budget Spreadsheet - Trip Cost Splitter & Group Expense Tracker, Excel & Sheets

Splitting gas, lodging and food on a holiday trip? Log each expense once, and the sheet shows who owes who and how much. Nobody else needs an app or an account, because it's one spreadsheet. $4 one-time.

Example: 3 people share a $90 gas bill and one person paid it. Each share is $30, so the payer is owed $60 and the settle-up list shows the other two paying $30 each.

Why you will like it

- Log each expense once, with who paid and a Y for each person who shares it.

- Each traveler's net balance is what they paid minus their fair share.

- A settle-up list shows who pays whom and how much.

- OVER/OK flags on the trip budget and on each trip.

What's included (1 .xlsx, 4 tabs)

- Start Here: how-to steps

- Split & Settle: names for up to 8 people; Paid, Share and Net balance for each (red if they owe, green if they are owed); a settle-up list of up to 7 payments (who pays whom, how much); and an expense log of 150 rows with date, trip, description, category dropdown, amount, Paid by dropdown, a Y column per person and a row check that flags CHECK

- Trip Budget: planned vs. actual for Transport (gas, flights), Lodging, Food, Gifts, Activities and Other, with difference, OVER/OK status and a total

- Trips: up to 20 trips with destination, start and end dates, nights, days to go, travelers, budget, actual, remaining and OVER/OK

- Yellow fictional EXAMPLE rows to delete when you start

How it works

- Type everyone's names on Split & Settle.

- Add your trips on Trips and planned amounts on Trip Budget.

- Log expenses as you go: who paid, and Y for each person sharing.

- At the end, follow the settle-up list to even out balances.

Compatibility

- Standard .xlsx for Microsoft Excel; open it in Google Sheets by uploading it to Google Drive.

- No macros, scripts or add-ons. One-time download, no subscription.

FAQ

- Only for holidays? No. Use it for any group trip: the Trips tab holds up to 20 trips.

- Does it send payment requests? No. It shows the amounts; you settle up however you like.

- Is it a subscription? No. You pay once.

- Questions? hirelinetemplates@mail.grokbot.com

You may also like

- Buying gifts too? Christmas Gift & Holiday Budget Tracker ($5): https://payhip.com/b/IjdQ6

- Card list, Secret Santa and hosting in one: Holiday Planner Bundle ($9): https://payhip.com/b/Mu7Oy

- Gifts now, budget for 2027 next: Holiday + 2027 Budget Pair ($10): https://payhip.com/b/vniJ9