SPREADSHEET VS APP FOR SHARED EXPENSES

A spreadsheet is a genuinely good answer to this problem, and we'd rather tell you when to use one than pretend otherwise. Here's where it works, the formula that does the job, and the three specific places it falls over.

THE FORMULA THAT ACTUALLY WORKS

Build one sheet with four columns: date, description, payer, amount. One row per expense, no merged cells, no per-person columns. Then, in a small summary block:

Total          =SUM(D:D)
Even share     =SUM(D:D)/<number of people>
Alex paid      =SUMIF(C:C,"Alex",D:D)
Alex balance   =SUMIF(C:C,"Alex",D:D) - $B$2   (B2 = even share)

A positive balance means the group owes that person. Negative means they owe. The balances must sum to zero — if they don't, you've got a typo or a stray row.

WHERE IT BREAKS: THE SETTLE-UP STEP

Balances are the easy half. Turning six balances into the shortest list of payments — repeatedly matching the biggest debtor to the biggest creditor — is an algorithm, not a formula, and building it in a spreadsheet is genuinely awkward. Most people give up and have everyone pay the one person who is owed the most, which works only when exactly one person is owed anything.

If you're keeping the spreadsheet, paste your balances into the settle-up calculator for that last step. It's free and needs no account.

WHERE IT BREAKS: PHONES AND PARTICIPATION

Nobody opens a spreadsheet on their phone in a taxi. So one person becomes the scribe, everything routes through them, entries get made from memory a day late, and the accuracy you built the spreadsheet for evaporates. The tool has to be fast enough to use at the moment of payment or it isn't used.

WHERE IT BREAKS: UNEVEN SPLITS

The formula above assumes everyone shares every expense equally. The moment two people skip the boat tour, you need a participation column per expense, and the sheet doubles in complexity. It's doable. It's also the point where most people stop maintaining it.

THE HONEST SUMMARY

• • Two people, few expenses: spreadsheet, easily.
• • Four-plus people, mobile, uneven attendance: an app will hold up better.
• • Weird custom rules: spreadsheet, because you control the logic.
• • You want the group to participate: whatever they'll actually open.

QUESTIONS

Is a spreadsheet good enough for splitting expenses?

For two or three people and a handful of expenses, yes. Past that, the settle-up step gets hard: netting balances down to the fewest payments is fiddly to build in a spreadsheet and easy to get subtly wrong.

What formula splits expenses in a spreadsheet?

For each person: SUMIF(payer_column, person, amount_column) minus their share of the total. A positive result means the group owes them; negative means they owe. Matching those balances into payments is the part a spreadsheet won't do for you.

Why do shared expense spreadsheets break down?

Three reasons: people won't open a spreadsheet on a phone at a bar, uneven attendance needs per-expense splitting that a flat grid handles badly, and one accidental edit to a formula silently changes everyone's number.