How to split trip expenses with friends (and stay friends)
Every group trip has a moment, usually on the last evening, when someone says "so who paid for the taxi on Friday?" and the table goes quiet. Nobody remembers. Two people are fairly sure they paid for something nobody else recalls. The spreadsheet, if there is one, has a column called Misc with 140 in it.
None of this is a money problem. The amounts are small. It is a bookkeeping problem, and bookkeeping problems have boring solutions. Here is the one that has worked for me across a lot of weekends away.
Agree what counts before you leave
Shared costs are the things everyone would have paid for anyway: the apartment, the rental car, fuel, groceries, the dinner everybody sat down to. Personal costs are the things one person chose: the museum only two of you wanted, the extra night, the bottle of wine someone took home. Say out loud which is which. It takes two minutes and it prevents most of the arguments later, because the arguments are never really about the money. They are about whether it was fair to count it.
While you are at it, pick one currency. If the trip crosses a border, decide on the rate once and write everything down in the same currency. Fiddling with conversions per receipt is how spreadsheets die.
One person writes things down, right away
Not at the end of the evening. Right away, while the receipt is still on the table. The entry is small: how much, what for, who paid. If the trip has a shared list, whoever paid types it in. If it does not, pick a bookkeeper and let them be insufferable about it.
The reason to do it at once is not discipline for its own sake. It is that memory of small payments decays in hours. The 14.50 for ice cream on Saturday afternoon is gone from everyone's head by Saturday night, and it is gone from the trip's accounts for good.
Equal by default, with exceptions
Split every shared cost equally among the people who took part in it. Not among everyone on the trip, among the people who were there. The friend who stayed in for the boat trip does not pay for the boat.
Then handle the exceptions, and only the real ones. Someone had a starter while the rest had three courses: give them a fixed share and split the rest equally. A couple took the big bedroom and offered to pay more: fine, a fixed amount for them too. Resist the urge to work out who had the second glass of wine. Rounding in each other's favour is part of what makes a trip pleasant, and the amounts are smaller than the time you would spend on them.
The payer is not always a sharer
A quiet trap: one person books the kayaks for the kids and stays on the beach. They paid, they did not take part, and they should end up being owed the whole amount. Most people get this right by hand. Some tools do not, so if you use one, check that case with a small example before you trust it with the real trip.
Settle once, at the end
Do not pay each other back as you go. Paying back after every dinner means a dozen tiny transfers and, worse, a dozen chances to forget one. Let the balances run for the whole trip, then settle once.
At the end, each person has a balance: what they paid minus their share of everything they took part in. People with a positive balance are owed money; people with a negative one owe it. Settle by matching the biggest creditor with the biggest debtor and working inwards. Four people almost always need three transfers or fewer, however many dinners there were. The method is described in more detail here.
A worked example
Four friends, a long weekend. Here is a condensed version of what the list looks like.
| What | Who was there | Paid by | Amount |
|---|---|---|---|
| Apartment, 3 nights | Ana, Ben, Chloé, Dan | Ana | 310.00 |
| Friday dinner | Ana, Ben, Chloé, Dan | Chloé | 96.00 |
| Boat trip | Ana, Chloé, Dan | Chloé | 86.40 |
| Groceries | Ana, Ben, Chloé, Dan | Dan | 48.00 |
| Sunday lunch | Ana, Ben, Chloé, Dan | Dan | 72.00 |
Each person's share is the sum of their parts: a quarter of the apartment, dinner, groceries and lunch, plus a third of the boat for the three who went. Ana paid 310 against a share of about 160, so she is owed roughly 150. Ben paid nothing against a share of about 131, so he owes that. Chloé and Dan are close to even. Two or three transfers and the weekend is squared.
If working that out by hand sounds tedious, it is, a little. That is the part worth handing to software.
The habits matter more than the tool
Any method works if the group does three things: agrees what is shared, writes payments down at once, and settles once at the end. A notebook works. A spreadsheet works, until someone's column stops adding up. An app like xplit works too, and does the dividing and the matching for you, which is pleasant when the trip is long and the dinners were many.
Whatever you use, the goal is the same. The last evening should be about where to go next year, not about the taxi on Friday.