Vacation Budget Spreadsheet for Couples (Trip Planning)

Quick answer. A vacation budget spreadsheet for couples needs four things solo trackers miss: a contribution split, a per-person who-paid column, a pre-trip vs on-trip view, and a settle-up sheet for after the trip. Our Travel Budget Planner handles the planning, bookings, and pre-trip vs on-trip structure; adding a who-paid column for couples takes about a minute. The free Travel Budget template covers the same basics if you only need single-trip planning.

A couples vacation is two budgets pretending to be one. There is the trip you take together, and there is the quiet math of who paid for what and how it shakes out at the end. Most travel budget templates handle the first part and ignore the second - fine for a solo traveler, not fine for two people sharing a $4,500 week away.

Four phases, the columns each one needs, and a few choices that matter more on Day 5 than they look at setup.

Why a different structure than solo travelers

A solo trip budget is one column of numbers. A couples trip budget has the same numbers plus a small set of bookkeeping questions a single traveler never asks:

• Who pays for the booking now, and how does that figure into the split later?
• If we agreed on a 60/40 contribution based on income, where does the spreadsheet enforce that?
• We are 9 days in and one of us has fronted $1,200 more than the other. Who owes whom?

These are not relationship-defining problems, but they get heavier the longer you ignore them. Capturing who paid at the moment of each transaction is the cheapest way to keep them out of the actual vacation.

Couples save on lodging when they share a room - per-person costs drop roughly 25 to 30 percent versus solo travel since one hotel covers two people. Food and activities scale linearly. A useful couples budget thinks in both per-couple totals (lodging, transport between cities) and per-person amounts (meals, museum entries, the spa morning one of you wants and the other does not).

The four phases of a vacation budget

Most spreadsheets focus on one phase. The full picture is four:

1. Plan - estimate the total, set per-category targets, decide contributions.
2. Save - put money away over the months before the trip.
3. Track - log daily spending on the trip, by category and by who paid.
4. Settle - after the trip, run the math and even the score.

Each phase wants different columns. One flat table doing all four tends to be awkward at every stage. A workbook with separate tabs works better.

Phase 1: plan the total and the categories

Start with a target. For US couples, average vacation costs in 2025 ran around $4,536 for a one-week domestic trip for two and roughly $9,922 for an international trip (The Motley Fool). Where you land in that range depends mostly on lodging and flights, which together usually eat 55 to 65 percent of the budget. For context, the BLS Consumer Expenditure Survey put 2024 entertainment spending at about 4.6 percent of total household expenditures, roughly $3,600 a year for the average household (BLS).

A planning table with seven or eight categories handles most trips:

The buffer line is the one that goes missing on most first-attempt budgets. Trips with no buffer either run over or get awkward when one of you wants to say yes to an unplanned $90 walking food tour. The number does not have to be 10 percent. It has to exist.

Choosing a contribution model

Two common contribution models, neither of which is the “right” one:

• Equal contribution (50/50). Each person puts in half the total. Simple. Reasonable when incomes are similar or when “this trip is a joint thing we split evenly” is the explicit shared framing.
• Proportional to income. Each person contributes the share of total trip cost that matches their share of combined income. If one earns $90k and the other earns $60k, contributions split 60/40. Used when the income gap is meaningful.

Whichever model fits a particular couple, the spreadsheet enforces it with a single cell: “Partner A share = 0.5” (or 0.6, or whatever). Everything else flows from that one number. For a deeper look at how couples decide what is shared and what is individual at a longer horizon, Net Worth Tracking for Couples covers the separate-vs-combined question for general finances.

Phase 2: save toward the target

Once the target is set, divide by the months remaining and you have a per-couple monthly savings rate. For a $4,920 trip nine months away, that is about $547 a month combined, or $273 each on a 50/50 split.

A simple savings tab with three columns - month, planned deposit, actual deposit - shows the cumulative balance growing toward the target. Some couples find a shared savings account makes this concrete; others prefer to track in a spreadsheet and keep the cash in separate accounts. Both work. The Vacation Savings Calculator walks through the per-month math in more detail.

If the savings number looks uncomfortable, that is information worth acting on while the trip is still being shaped. Trimming a lodging line by $300 is easier in June than in September after the hotel is already booked.

Phase 3: track on the trip, by category and by who paid

This is where the couples version of the sheet earns its keep. The on-trip log needs six columns:

The “who paid” column is the small addition that solves the largest amount of bookkeeping pain. At any moment in the trip, a SUMIF on that column tells you how much each person has fronted. The difference is what would need to settle if the trip ended today.

For couples splitting evenly, that running difference is the only number that matters at settle-up. For a proportional split, multiply each person’s “should have paid” share by total trip cost so far, subtract what they paid, and the result is the same: who is ahead, who is behind, by how much.

Both our templates ship with the daily expense log as the place this fits naturally. The Travel Budget Planner gives you the full bookings tracker, payment status, and pre-trip workflow; the free Travel Budget covers the daily category log alone. Adding a “Who paid” column to either is a one-minute edit - insert column, set a data validation dropdown of “A” or “B”, done.

Phase 4: settle up after the trip

The settle-up math is one row. Total what each person paid. Subtract what each person was supposed to pay under the agreed split. The negative number owes the positive number that amount.

A worked example with a 50/50 split on a $4,800 trip:

One Venmo, done. Same logic for a 60/40 split: the “should pay” column changes, the math is identical.

For couples who track expenses split with friends on the same trip - say a double-date weekend - apps like Splitwise handle the multi-person case better than a spreadsheet does. Best Apps for Splitting Expenses with Friends compares those tools if a trip extends beyond two people.

Currency handling for international trips

International trips add a column or two and otherwise leave the structure alone. The on-trip log gains a currency column (whatever currency the transaction was in) and a converted-amount column.

For live conversion, =GOOGLEFINANCE("CURRENCY:EURUSD") pulls the current rate into the sheet. It needs internet, which is not guaranteed in a hill town in Tuscany, so a fallback fixed rate (the one you looked up the morning of departure) is worth having in a cell you can reference. Total accuracy is not the point. Knowing whether today cost $90 or $150 is the point.

International Travel: Managing Currency Exchange in Your Budget covers the conversion approaches in more detail, including how to handle multi-currency trips that touch three or more countries.

What to lock in vs what to leave flexible

Some line items are settled before the trip; others move with daily choices. Separating them keeps the on-trip view focused on numbers you can still affect.

Locked-in (pre-trip): flights, lodging (if pre-booked), insurance, pre-paid tours. Flexible (on-trip): food, local transport, activities not yet paid, souvenirs and small purchases.

Two tabs - “Pre-trip” and “On-trip” - work well here. For a 7-day couples trip, the flexible bucket is usually $1,200 to $1,800 of a $4,500 total. That is the lever for “we are running hot, want to skip the third nice dinner?” conversations.

The shared-joy fund

One pattern some couples use is splitting the buffer into a small “joy fund” earmarked for unplanned, mutually-agreed things on the trip - the food tour that came up in conversation, the boat ride that looked nicer than expected.

The framing matters more than the number. An emergency buffer feels like something to protect; a joy fund feels like something to spend, on purpose, on the right moment. One approach, not a prescription. The buffer line in the planning table covers the underlying need either way.

Get the template

The Travel Budget Planner adds a bookings tracker (flights, hotels, activities with payment status and cancellation dates), pre-trip expenses with a packing checklist, and a planned-vs-actual dashboard. The free Travel Budget has the daily log and budget categories. Either becomes couples-ready with one added “Who paid” column.

For couples planning multiple trips a year, an annual view that bundles all of them together starts to be useful. The Annual Travel Fund Budget piece walks through that case.

Related

• How to Budget a 2-Week Europe Trip (Country-by-Country Costs)
• How to Track Expenses While Traveling
• Net Worth Tracking for Couples: Separate vs. Combined