Vacation expense calculator
Holidays mix big up-front bookings with lots of small daily spending. This calculator keeps both in one place so the end of the holiday is not an audit.
Short answer
Track holiday spending by category — accommodation, food, activities, transport — assign each item to whoever paid, and split it across only the people who took part; the calculator nets it into one payment per person.
People
Expenses
Balances
- Alex$375.00
- Sarah$15.00
- Mike$165.00
- Emma$195.00
+ gets money back · − owes money
💸 Settle up
Only 3 payments needed.
- EmmaAlex$195.00
- MikeAlex$165.00
- SarahAlex$15.00
Who paid what
- Alex$600.00
- Sarah$180.00
- Mike$60.00
Saved on this device. No account needed.
How it works
- 1Log the big bookings first — villa, flights, car hire — with whoever actually paid.
- 2Add daily spending as you go; five seconds per expense.
- 3Give excursions their own participant list so non-participants are not charged.
- 4Settle the whole holiday on the last evening.
Vacations mix big shared bookings (a villa, a rental car) with smaller optional spending (a spa day, a scuba trip only two people did). Splitting everything evenly ignores the fact that not everyone joins every activity.
The way round this is to record who actually shares each cost, not just who's on the holiday. A couple who skip the excursion shouldn't be charged for it.
Keeping a running ledger through the week also means nobody's fronting hundreds by the final day — balances stay visible throughout.
Worked examples with real numbers
A week-long villa holiday for four
Four friends rent a villa for a week. Jon books the villa, Priya does the big food shop, and two of the four go on a paid excursion the others skip.
| What was paid | Amount |
|---|---|
| Villa (7 nights, all 4)Jon paid | 1,400.00 |
| Food shop (all 4)Priya paid | 320.00 |
| Boat excursion (Jon and Priya only)Jon paid | 180.00 |
| Total | 1,900.00 |
| Person | Paid | Fair share | Balance |
|---|---|---|---|
| Jon | 1,580.00 | 520.00 | +1,060.00 |
| Priya | 320.00 | 520.00 | −200.00 |
| Sam | 0.00 | 430.00 | −430.00 |
| Tara | 0.00 | 430.00 | −430.00 |
- SamJon430.00
- TaraJon430.00
- PriyaJon200.00
Sam and Tara only share the villa and food (430 each: 350 villa + 80 food), while Jon and Priya also split the 180 excursion between just the two of them, adding 90 each to their share.
Couples paying unequal amounts upfront
Two couples share a lakeside cabin. One couple pre-paid the cabin in full months earlier; the other covers meals during the week.
| What was paid | Amount |
|---|---|
| Cabin (4 people)Couple A paid | 600.00 |
| Meals all week (4 people)Couple B paid | 360.00 |
| Total | 960.00 |
| Person | Paid | Fair share | Balance |
|---|---|---|---|
| Couple A | 600.00 | 480.00 | +120.00 |
| Couple B | 360.00 | 480.00 | −120.00 |
- Couple BCouple A120.00
Total cost 960 split evenly between two couples is 480 each. Couple B just needs to send 120 to bring both to even.
Splitting a mixed-activity holiday
1. Shared-by-all costs
villa + groceries + shared transport
2. Per-person share of shared costs
shared total ÷ all travellers
3. Optional activity share
activity cost ÷ number who joined it
4. Person's total share
shared-cost share + sum of optional activities they joined
5. Balance
total paid by that person − total share
Mistakes that cause arguments
Charging everyone for optional extras
Spa visits, excursions and late add-ons should only be split among participants, not the whole group.
Forgetting pre-trip spending
Deposits paid weeks before departure are easy to forget — log them alongside on-holiday costs so the final settlement is accurate.
Averaging by day instead of by activity
A holiday with wildly different daily costs (a quiet day vs an excursion day) shouldn't be smoothed into a flat daily rate — split each cost on its own terms.
Practical tips
- Set up the group before you fly so costs get logged in real time, not reconstructed afterwards.
- Tag optional activities with just the participants, not the full group.
- Keep pre-paid deposits as separate entries so the in-trip float is easy to read.
- Do one final settlement rather than reimbursing after every purchase.
Questions
- How do couples share within a group?
- Either add each couple as one 'person', or add both names and split their shared items equally between them.
- What about children?
- Add them as people if they should carry a share, or leave them out and let the parents' shares absorb the cost.
- Can I split a deposit paid months earlier?
- Yes — enter it as an expense with the original payer; the date does not affect the maths.