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.
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
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.
$0.00 to $1,315.00 · USD
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
| Traveler | Expense share | Paid merchants | Net settlement paid | Peak 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 |
| Day | Group before receipts | Group day-end | Traveler 1 before receipts | Traveler 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 CSVShow selectable CSV
Expenses and holds
Edit trip items
How to use this calculator
- Enter the group size, trip duration, budget and the day when you expect to settle. Use zero as the first day of the trip.
- Record each payment on its expected day, including advance bookings. Choose the paying traveler and those who share the expense.
- Enter temporary holds separately and use the expected release date from your booking or provider. Use an expense line for any separate fee.
- 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
Rent Split Calculator for Roommates
Divide rent among two to five roommates by room preference and rent caps. Compare suggested room prices with equal shares and check who prefers another room.
RV Loan & Ownership vs Rental Calculator
Compare RV loan payments, ownership costs and renting. Explore resale equity, complete amortization, trip budgets and the usage needed to justify buying.
Fuel Cost Calculator
Calculate the fuel cost and consumption for any road trip or daily commute.
Savings Goal Timeline Calculator
Estimate how many months it may take to reach a savings goal with contributions and interest.
