How to split group trip expenses without a spreadsheet

• Expenses
• Money
• Group travel

Every group trip starts with the same good intention: someone opens a shared spreadsheet, adds a column per person, and pins it in the group chat. It works beautifully for about two days.

Why the shared spreadsheet breaks down mid-trip

A spreadsheet is a fine ledger and a terrible field tool. The failure is rarely arithmetic — it's everything around the arithmetic.

• Entry happens too late. Nobody opens a spreadsheet on a phone while standing outside a restaurant. Receipts get "remembered later", and later is Tuesday, and by Tuesday the details are gone.
• Everyone edits the same cells. Two people add the same taxi. One person reformats the currency column. A row gets dragged into the wrong place and no one notices for four days.
• It doesn't know who owes whom. A running total tells you the trip cost $4,182. It does not tell you that Priya should send Marcus $63 and nobody else needs to move money at all.
• It quietly excludes people. The person who built the sheet becomes the accountant for the whole trip, which is a job nobody volunteered for.

The fix isn't a better spreadsheet. It's a smaller set of rules, applied consistently, plus somewhere to record a cost in under ten seconds.

The three splitting models

Almost every shared cost falls into one of three shapes. Agree on which shape you're using before you enter the amount, and the rest is mechanical.

Split equally

The default, and correct for genuinely shared costs: the rental car, the group dinner where everyone ate roughly the same, the museum tickets. Divide the total by the number of people who benefited — not by the number of people on the trip. A dinner four of six people attended is a four-way equal split.

Split by share

Use shares when people consume the same thing in different quantities. A house that sleeps six but has one king suite and two bunk rooms isn't an equal split; it's 2 shares to the couple, 1 share each to the four singles, total 8 shares. A $1,600 house becomes $400 to the couple and $200 per single. Shares are also the honest way to handle a friend who joins for four nights of a seven-night booking.

Split by exact amount

Use exact amounts when the receipt already itemizes who owes what: one person's bar tab, a single upgraded flight seat, one person's baggage fee bundled into a group booking. Don't reach for this first — it takes the longest to enter, and reaching for it constantly is usually a sign the group is trying to itemize its way out of a conversation about fairness.

A useful rule: if deciding which model applies takes longer than thirty seconds, split it equally and move on. Perfect precision on a $12 coffee costs more in group energy than it recovers in dollars.

Why settling pairwise creates far too many payments

Here's where most groups lose an evening. If you settle every debt exactly as it was incurred, a group of n people can end up with up to n × (n − 1) directed obligations — six people means as many as 30 separate transfers, most of them for small amounts flowing in circles.

Two steps collapse that.

1. Net each pair. If Ana owes Ben $30 and Ben owes Ana $10, that's one $20 payment, not two.
2. Simplify across the group. If Ana owes Ben $20 and Ben owes Cal $20, Ana can pay Cal directly and Ben is out of it entirely. Applied across everyone, this reduces the settlement to at most n − 1 payments — five transfers for a group of six, and often fewer.

The net position of every person is identical either way. The only thing that changes is how many times someone has to open a payments app.

Multiple currencies, and when to lock a rate

Multi-currency is where the group's trust in the numbers is usually won or lost.

• Record each expense in the currency it was actually paid in. Converting at entry time destroys the source of truth; you can always convert later, but you can never recover the original.
• Pick one reporting currency for the trip and convert only for display and final settlement.
• Lock the rate at a defined moment. The two defensible choices are the rate on the date of each expense or a single rate on the day you settle up. Per-expense dating is fairer over a long trip or a volatile pair. A single settlement-day rate is simpler and fine for a long weekend. What causes arguments is a live rate that changes between the time someone screenshots the balance and the time they pay it.
• Ignore card-issuer spreads. Chasing the exact 1.4% your bank took turns a five-minute settlement into a forensic audit. Note it and move on.

A workflow that actually survives the trip

1. Before you leave, agree the reporting currency, the default split (usually equal), and who is not part of which costs.
2. Log each cost within a minute of paying it, in the currency you paid. Photograph the receipt if the split is unusual.
3. Never settle mid-trip. Partial payments and outstanding debts in parallel are how ledgers get wrong.
4. On the last evening, freeze the rate, run the simplification, and send the short list of payments to the group chat.
5. Pay within 48 hours, while the trip still feels recent enough that nobody minds.

This is roughly the workflow Caravan automates: shared expenses logged from a phone with equal or exact-amount splits, balances converted across currencies at the rate for each expense's date, and a settlement view that applies step one for you — each pair's debts netted into a single direction, so nobody pays in both directions. Whether you use a tool for it or not, the rules above are the part that matters — see the FAQ for how the splitting and settlement pieces fit together, or pricing if you'd rather not run the ledger yourself.

The goal was never a beautiful spreadsheet. It's landing home with one number, one payment, and no lingering resentment about the airport parking.