Vacation Budget Calculator & Group Trip Expense Split

Build a trip budget from entered payments, personal costs and refundable holds. Choose who pays and who shares each expense. The timeline shows how much the group and each traveler may have tied up before reimbursements and releases, while a separate ledger shows final expenses and suggested transfers.

Group travel

Plan vacation costs and cash timing

Split each expense among the travelers who share it, and see what each person may need upfront.

Trip setup

Day offset 0 is the first day of the trip. Enter a negative offset for payments before departure.

Vacation expense $1,065.00. Peak group exposure $1,315.00.

Trip budget and peak funding

Group trip expense
$1,065.00
Budget remaining
$135.00
Peak group merchant exposure
$1,315.00
Includes temporary merchant holds

Traveler 1 has the highest individual funding need at $1,000.00.

Cash or credit tied up by date

Expenses, holds and receipts follow their entered dates. The ledger shows the peak before receipts and the closing exposure for each date.

Group Traveler 1

$0.00 to $1,315.00 · USD

Group and selected traveler exposure by date in US dollars
30 d before3 d after

Traveler 1 peaks at $1,000.00 before receipts.

Suggested settlement

1 d after

  • Traveler 2 pays Traveler 1 $205.00
  • Traveler 3 pays Traveler 1 $250.00
Show traveler balances and dated ledger
Expense and temporary funding by traveler
TravelerExpense sharePaid merchantsNet settlement paidPeak exposure
Traveler 1$295.00$750.00-$455.00$1,000.00
Traveler 2$385.00$180.00$205.00$385.00
Traveler 3$385.00$135.00$250.00$385.00
Group and Traveler 1 exposure in USD by posted day
DayGroup before receiptsGroup day-endTraveler 1 before receiptsTraveler 1 day-end
30 d before$660.00$660.00$660.00$660.00
Trip day 1$1,000.00$1,000.00$1,000.00$1,000.00
Trip day 2$1,180.00$1,180.00$1,000.00$1,000.00
Trip day 3$1,315.00$1,315.00$1,000.00$1,000.00
1 d after$1,315.00$1,315.00$1,000.00$545.00
3 d after$1,315.00$1,065.00$545.00$295.00

A negative net settlement is an amount to receive. Transfers between travelers leave the group’s merchant exposure unchanged.

Download vacation budget CSV
Show selectable CSV

Expenses and holds

Edit trip items
Trip item 1
Shared by
Trip item 2
Shared by
Trip item 3
Shared by
Trip item 4
Trip item 5
Shared by

How to use this calculator

  1. Enter the group size, trip duration, budget and the day when you expect to settle. Use zero as the first day of the trip.
  2. Record each payment on its expected day, including advance bookings. Choose the paying traveler and those who share the expense.
  3. Enter temporary holds separately and use the expected release date from your booking or provider. Use an expense line for any separate fee.
  4. Review final costs, the suggested transfers and the highest amounts tied up. Choose a traveler in the chart to see their timeline, and export the details as CSV.

The Formula

The mathematical logic powering this calculation is:

Group expense is the sum of entered expenses. Remaining budget equals the target less that total. Each expense is split equally among its selected travelers. Allocate any indivisible cents to the first selected travelers in roster order. Each traveler’s net settlement equals their expense shares less what they paid merchants. Match positive balances to negative balances in roster order and schedule all suggested transfers on the entered settlement day.

The exposure timeline begins at zero. Add merchant expenses and any new holds on each posted date. For each traveler, add outgoing settlement transfers, then subtract holds released and incoming transfers. The peak is measured after that day's outgoing amounts and before receipts. Group merchant exposure tracks expenses and holds without counting transfers between travelers. Holds release in full on the entered date and never change final expense shares.

Day offset 0 is the first vacation day. Negative offsets are before the trip. Enter payments from 180 days before to 365 days after the start. The settlement day must be on or after the last trip day and the last expense payment. This daily plan accepts 1–8 travelers, 1–31 trip days and 1–24 expense or hold lines. Enter one USD amount per line. The release and transfer dates are user assumptions. Actual authorizations, charges and exchange rates depend on the provider and payment method.

Worked Example

If you input:

  • Group size and trip duration: 3 travelers for 4 days
  • Group budget (USD): 1,200.00
  • Trip expenses: $660 lodging, $180 activity for travelers 2 and 3, $90 transit, and $135 meals
  • Refundable hold: $250 placed on the first day and released on day offset 6
  • Settlement day offset: 4

Result:

Group expenses total $1,065.00, leaving $135.00 in the budget. The hold increases peak group merchant exposure to $1,315.00. Traveler 1 temporarily needs $1,000.00. Traveler 2 pays Traveler 1 $205.00 and Traveler 3 pays Traveler 1 $250.00.

Frequently Asked Questions

Can I include an activity for only some travelers?

Yes. Select just the participants who share that payment. For a personal cost, select only the traveler who incurs it. The paying traveler can differ from the sharing travelers.

Why is the peak larger than my vacation expense?

An advance payment or temporary hold can tie up cash or credit before repayment or release. Those movements determine peak exposure. The final expense stays the same when a hold releases in full.

How does the calculator handle shared cents that do not divide evenly?

Each selected traveler gets the same whole-cent base share. Extra cents are assigned in traveler order so the expense splits exactly.

How should I record a hotel with a card hold?

Enter the actual hotel charge as an expense and enter the amount you expect to be separately blocked as a refundable hold. If both overlap, use the placement and release dates you expect.

Can I model advance booking payments?

Enter a negative day offset, such as −30 for a payment before departure. The chart covers those dates and later refunds or reimbursements.

Can I compare trips in different currencies?

Convert each quote to a USD amount using your chosen rate and fees before entering it. The workbook uses a single currency and the amounts you provide.

Similar Calculators