Travel Budget Planner Spreadsheet | Trip Budget, Vacation Expense Tracker, Split Costs & Savings | Multi-Currency | Excel & Google Sheets

Planning a trip? This spreadsheet keeps the whole budget in one place: what you plan to spend, what you've saved, what you actually spent on the road, in any currency, and who owes whom when you get home.

What's inside (7 tabs):

- Start Here: a 10-minute setup guide.

- Dashboard: days to go, trip budget, spent so far, budget left, spent per person, daily target, saved so far, still to save, save per week, biggest category, trip length and how much is left to settle up. It also has a budget-vs-spent chart, a split & settle summary, and a day-by-day spending chart against your daily target.

- Trip Budget: 12 travel categories (flights, accommodation, local transport, food, activities, insurance, visas, phone & data, tips, emergency buffer and more). See planned, per person, spent, left and % used for each, with over-budget alerts. A day-by-day table shows each day of the trip against your daily target.

- Expense Log: up to 200 expenses. Type the amount in the currency you paid. It converts to your home currency automatically, and a check column flags anything missing.

- Savings Plan: your savings goal and a countdown to departure. It shows what to set aside per week, per month and per paycheck, plus a deposit log and each traveler's progress.

- Split & Settle: for up to 6 travelers. See what each person paid, their fair share (shared costs plus their own personal purchases) and their balance. A who-pays-whom table turns the balances into simple payments. Nothing to type.

- Settings: trip name, dates, home currency, travelers and up to 10 currencies with your own exchange rates.

Made for:

- Friend trips, bachelor/bachelorette trips and family vacations where you share costs

- International trips with spending in euros, pounds, yen or pesos

- Couples saving up for a honeymoon or a big trip

- Solo travelers who want a daily spending target (enter just yourself as the traveler)

Details:

- Works in Microsoft Excel (desktop & web) and Google Sheets (upload to Google Drive, then Open with → Google Sheets)

- No macros, add-ons or sign-ups. It's just a spreadsheet, and it works offline

- Comes filled with clearly labeled example data (a made-up 8-day Lisbon & Porto trip for 3 friends) so you can see how it works. Delete the example rows and add your own

- Instant digital download (1 .xlsx file)

Please note: this is a digital file, so nothing will be mailed to you. Exchange rates are rates you type, not live rates. The included rates are examples only, so check a current rate before you go or use the rate on your card statement. Amounts display with $; if your home currency is different, change the number format. Apple Numbers and LibreOffice will open the file, but it is built for Excel and Google Sheets.