● Money & small business
How to split group trip expenses fairly: a 6-person ski weekend, settled in 5 payments
After a group trip, somebody always ends up with a spreadsheet, or a group chat full of "I'll Venmo you later". Two questions decide whether it's fair and whether it's painless: who was each cost for, and how few payments can settle it. Here's one example weekend from the sample file of our trip expense splitter.
The trip
Six friends (Alex, Jordan, Sam, Riley, Casey and Morgan) spend a long weekend in a ski cabin. Twelve shared payments, $4,201.92 in total:
| Payment | Amount | Paid by | For |
|---|---|---|---|
| Cabin, 3 nights | $1,740.00 | Alex | everyone |
| Cleaning fee | $150.00 | Alex | everyone |
| Groceries | $312.67 | Sam | everyone |
| Dinner out | $284.30 | Jordan | everyone |
| Brunch | $156.80 | Morgan | everyone |
| Lift tickets | $945.00 | Casey | the 5 skiers |
| Ski rentals | $210.00 | Riley | Alex, Riley, Casey |
| Wine + beer | $118.50 | Alex | everyone but Sam |
| Gas, car 1 | $96.40 | Jordan | Alex, Jordan, Sam |
| Gas, car 2 | $88.25 | Riley | Riley, Casey, Morgan |
| Snowshoe rental | $60.00 | Morgan | Sam, Morgan |
| Parking | $40.00 | Jordan | Jordan, Riley |
Don't split everything evenly
$4,201.92 ÷ 6 is $700.32 each. That's the easy answer, and it's wrong for Morgan, who didn't ski: no lift ticket, no ski rental, and a snowshoe rental shared with Sam instead. Split each payment only between the people it was for, and Morgan's share is $523.75, about $177 less. Riley, who skied, rented skis and drove, has the largest share at $772.75.
| Person | Their share | Paid for the group | Balance |
|---|---|---|---|
| Alex | $755.46 | $2,008.50 | gets back $1,253.04 |
| Casey | $752.75 | $945.00 | gets back $192.26 |
| Jordan | $705.46 | $420.70 | owes $284.76 |
| Morgan | $523.75 | $216.80 | owes $306.95 |
| Sam | $691.76 | $312.67 | owes $379.09 |
| Riley | $772.75 | $298.25 | owes $474.50 |
A balance is what someone paid for the group minus their share of everything. The balances always add up to zero: every dollar someone is owed, someone else owes.
41 pay-backs, or 5 payments
If every payment were paid back on its own (each person sends the payer their part of each bill), this weekend would take 41 separate transfers. Nobody does that, which is why trips never quite get settled.
Working from the balances instead: the person who owes the most pays the person owed the most, as much as one of them needs, and repeat.
- Riley pays Alex $474.50
- Sam pays Alex $379.09
- Morgan pays Alex $306.95
- Jordan pays Casey $192.26
- Jordan pays Alex $92.50
Five payments, $1,445.30 moving in total, and everyone is square. This method never needs more than one payment fewer than the number of people (here, at most five for six people). It isn't guaranteed to be the absolute minimum in every possible case, but it's short and anyone can follow why each payment happens.
Doing it for your own trip
- Write down every shared payment as it happens: amount, who paid, and who it was for. The "who it was for" is what makes it fair.
- For uneven splits (a couple sharing one room, someone who only came for one night), use shares: 2 for the couple and 1 for everyone else, for example.
- At the end, work from balances, not bills, and settle with the short list.
The free split expenses calculator does the equal-between-the-people-involved version in your browser. Every figure above is from the sample file of our trip expense splitter, where every split, balance and payment was recomputed independently and the payments were checked to bring every balance to $0.