How to Settle Up with Friends Without Losing Track

Why informal IOUs fail

"I'll get the next one" is the most optimistic sentence in the English language. It assumes both parties are tracking the same mental ledger and will remember this conversation the next time the bill comes. Neither assumption is reliable after more than about two transactions.

The problem compounds across friends. A weekend trip involves six people, maybe thirty separate expenses, and a different person fronting the cost each time. By Sunday afternoon nobody can reconstruct who owes what without a spreadsheet that nobody made.

The settlement problem

Even when people log expenses carefully, they often make settlement harder than it needs to be. Everyone pays everyone else back, resulting in a cascade of small transfers. In a group of five, that could mean twenty separate payments.

The smarter approach is to calculate the minimum number of transfers needed to make everyone even. Usually, this means two or three payments in a group of five -- not twenty. The math isn't complicated, but doing it manually after a three-day trip is.

Minimising the number of payments

Here's the principle: figure out who is net positive (owed money overall) and who is net negative (owes money overall). Then route payments from net-negatives to net-positives until everyone is zero.

In a larger group the algorithm is the same, just applied iteratively. Good expense apps calculate this automatically.

How to make it a habit

• --Log expenses as they happen, not at the end of the trip. Memory is unreliable after two glasses of wine.
• --Appoint a record-keeper for group trips -- one person whose job is to make sure every expense gets logged.
• --Set a settlement deadline -- ideally within 48 hours of returning home, before the inertia sets in.
• --Don't let balances carry over between separate events. Clean slate every time.