Who owes who after a group trip: how to settle up without a spreadsheet

The short answer

To work out who owes who after a group trip, do not try to settle each expense one by one. Add up what each person paid, add up what each person's share of every expense was, and subtract. Anyone with a positive number is owed money, anyone with a negative number owes it. Then match the biggest debtor with the biggest creditor until every number reaches zero. A four-person trip with six expenses collapses from seventeen possible transfers to three.

That is the whole method. The rest of this guide shows the math on a real-shaped example, covers the cases that trip people up (someone skipped an activity, two currencies, a payment that already happened), and explains how to get the same result in under a minute without opening a spreadsheet. If you want the full trip playbook from before you leave to the last payment, read how to split trip expenses with friends first; this post goes deep on the last step only.

Why "you owe me for dinner, I owe you for the taxi" never ends

The instinct after a trip is to settle expense by expense. Ana paid the hotel, so three people owe Ana. Ben paid the car, so three people owe Ben. Every expense creates a handful of small debts, and a group of four with six shared costs can produce seventeen separate "you owe me" lines. People pay a few, forget a few, and someone ends up chasing $23 three weeks later.

The fix is to stop thinking about expenses and start thinking about balances. Nobody cares which dinner they are paying for. They care about one number: how far ahead or behind they are versus their fair share.

Step 1: list every expense, who paid, and who it was for

Before any math, you need a complete list. Here is a four-person weekend, Ana, Ben, Chloe and Dan, with six shared costs:

The "shared by" column is the one people forget. Chloe did not kayak, so she should not pay for the kayak. Getting this column right is most of the fairness argument, and it is far easier to get right during the trip than from memory a week later.

If you want to see what a fully logged trip looks like before the settle-up, 11 days in Japan in 61 receipts walks through 63 expenses captured this way, down to the ¥7 bag fees.

Step 2: work out each person's share

For each expense, divide the amount by the number of people sharing it, and give each of them that share. Then total the shares per person.

Check: $355 + $355 + $305 + $355 = $1,370, the same as the total spent. If your shares do not add up to the total, an expense was split wrong.

Step 3: subtract to get the net balance

Net balance = what they paid minus their fair share.

Check again: the balances sum to zero (+381 - 51 - 125 - 205 = 0). They always should. If they do not, a "paid by" amount is wrong somewhere.

Notice that nobody needs to know who paid for which dinner any more. Four numbers describe the entire weekend.

Step 4: simplify the payments

Now match debtors to creditors. The rule that produces the fewest transfers is simple: take the person who owes the most and pay the person who is owed the most, for whichever of the two amounts is smaller. Repeat until everything is zero.

In this example there is only one creditor, so it is immediate:

Three payments instead of seventeen, and Ana, who fronted the hotel, is made whole in one evening.

With two or more creditors the same rule still works. Suppose the balances were Ana +$250, Ben +$100, Chloe -$200, Dan -$150. Biggest debtor Chloe pays biggest creditor Ana $200. Ana is now owed $50, Dan still owes $150. Dan pays Ana $50, then Ben $100. Three transfers for four people, which is the minimum for any group where everyone is involved (a group of n people never needs more than n minus 1 payments).

The cases that break the simple version

Someone left early or joined late. Handle it through the "shared by" column, not through discounts. The expenses they were present for are split among the people present. Their fair share is simply smaller.

Someone already paid someone back mid-trip. Treat the repayment as an expense paid by the payer, shared only by the receiver. If Chloe gave Ana $100 cash on Saturday, add a row "Repayment, $100, paid by Chloe, shared by Ana". Chloe's paid total rises by $100, Ana's fair share rises by $100, and the net balances adjust correctly. Never just cross it off in your head.

Two currencies. Convert every expense into one settlement currency at the rate on the day it was paid, then run the same four steps. Do not convert at the end-of-trip rate; if the currency moved 3 percent during the week, the person who paid in the foreign currency quietly eats or gains that difference. For the method on a longer international trip, the currency section in the trip expenses guide covers it.

Uneven splits. If the couple took the bigger room, or one person ordered the tasting menu, the share for that expense is not amount ÷ people. Use percentages or by-item amounts for that row and leave the rest equal. The guide to splitting group expenses fairly explains when each method is the fair one.

Rounding. Split $100 three ways and you get $33.33 each with a cent left over. Give it to the person who paid, and round every share to the cent before totalling. A spreadsheet that rounds at the end will show balances summing to $0.01 instead of zero, which is how a lot of "your numbers are wrong" arguments start.

Doing it without a spreadsheet

Everything above can be done in a spreadsheet, and our free expense-splitting template has the net-balance and settle-up tabs already built. The problem with a spreadsheet is not the math, it is the data entry: someone has to sit down after the trip, find every receipt, remember who was at every meal, and type it all in. That is the part that gets skipped. (If you have been doing it in Splitwise and the free plan's daily cap bit you mid-trip, the Splitwise alternative comparison covers the apps that do not cap entries.)

The alternative is to capture expenses as they happen and let the balances compute themselves. In HippoSplit, the group trip is a chat. When someone pays, they type a line like "kayak 150 split with Ana and Ben" and the expense is logged with the right people on it. Or they post a photo of the receipt straight into the chat, the way you would send a picture to friends, and HippoSplit reads it, logs the amount, currency and items, and applies the group's split. Photo-posting is the easiest way to keep the list complete as you spend, because nobody has to remember anything later. AI reads the receipt; the totals, shares and balances are calculated and verified by the app's own backend, so the numbers are not AI guesses.

By the last night, the balances screen already shows the Step 3 table: each person's paid amount, fair share and net balance. Below it, simplified payments shows the Step 4 list, who pays who and how much, in the fewest transfers. It handles the edge cases above automatically: 150+ currencies converted at live rates on the day of each expense, uneven splits per expense, and people who were not part of a given cost. When someone pays, you record the settlement in the group and the balances move to zero. The balances and simplified payments are on the free plan; Premium adds the spending reports and charts (where the money went by category and by person) if you want the post-trip breakdown too.

Friends who do not want another account can follow the group through a share link without signing up. They see every expense and the live balances, which is often enough to end the "are you sure I owe that much?" conversation before it starts.

Settling the actual money

The math tells you who pays who. Paying is a separate step, and a few habits make it painless:

• Settle within a week. The longer the gap, the more the numbers feel abstract and the more awkward the reminder. The group payment etiquette guide covers how to remind without nagging.
• Send the balances table to the group, not a list of demands. When everyone sees the same four numbers and that they sum to zero, the usual response is "ok, sending now" rather than a debate.
• Pay the simplified amounts, not the pairwise ones. If the list says Dan pays Ana $205, Dan does not also need to send Ben $55 for the car. Ana's payment covers it.
• Use whatever transfer method the group already uses. Bank transfer, Venmo, PayPal, Revolut, cash. The splitting tool's job is to produce the right numbers; the money moves however it usually does.
• Record the payment once it is made. Mark it settled in the group, or add the repayment row to the spreadsheet, so the balances go to zero and nobody pays twice.

Frequently asked questions

How do you calculate who owes who after a trip?

Add up what each person paid. Work out each person's fair share by splitting every expense among the people it was for and totalling those shares. Subtract share from paid to get each person's net balance. People with negative balances pay people with positive balances, largest to largest, until every balance is zero. The balances always sum to zero, which is your check that the inputs are right.

What is the fewest number of payments to settle a group?

For a group of n people it is never more than n minus 1, and it is often fewer. Match the biggest debtor with the biggest creditor for the smaller of the two amounts, then repeat. This is what "simplified debts" or "simplify payments" does in expense-splitting apps.

Does everyone have to pay the person who paid for the hotel?

Not necessarily. Simplification works on net balances, not on individual expenses. If Ben paid the car and Ana paid the hotel, Ben's car spending reduces what he owes Ana. He pays only the difference. In the example above Ben owed Ana just $51 despite a $160 hotel share, because his $220 car payment covered most of it.

How do you split trip costs when someone skipped an activity?

Split that expense only among the people who took part. Their share of everything else stays the same. In the example, Chloe skipped the $150 kayak tour, so it was split three ways at $50 and her fair share was $50 lower than everyone else's.

What about expenses in different currencies?

Convert each expense to one settlement currency at the exchange rate on the day it was paid, then run the normal calculation. Using one end-of-trip rate for everything shifts money between people whenever the rate moves during the trip. Apps with live rates do this conversion per expense automatically.

Can you settle up without everyone installing an app?

Yes. One person can keep the record and share the final balances table; the math does not require the others to do anything. Tools with a share link let the rest of the group view expenses and balances in a browser with no account, so they can check the numbers themselves. Our post on splitting expenses when friends won't install an app compares the options.

Do it while the trip is still fresh

Four steps: list, share, subtract, simplify. Run them the day you get home, while everyone still remembers who was at brunch. Or skip the spreadsheet entirely: start a HippoSplit group for the next trip, log expenses by typing a line or posting the receipt photo in the chat, and the who-owes-who list is waiting for you on the last night.