Spreadsheet, Group Chat or App for Splitting Costs?

Shared expenses can be tracked on the back of a receipt. For three people on a one-night trip, that’s enough.

The problem is that at some point it stops working, and the reason it stops depends on what you were using.

Every tool fails the same two ways

The common ground first.

When expense tracking collapses, one of two things has happened: either the records have gaps, or nobody can finish the totalling.

Gaps appear when something didn’t get written down at the time. Pulling out a phone at the register feels like too much, so it waits, and by the next day the amount is gone. Totalling stalls when the arithmetic lands on one person and that person gets busy.

Choosing a tool means deciding which of those two your group is more likely to cause.

Spreadsheets depend on whoever does the totalling

Excel and Google Sheets are genuinely good at this.

You can add columns freely, so currencies and split methods are yours to design. Formulas automate the arithmetic, and sharing the file lets everyone see the same numbers. If your group has a designated bookkeeper who’s comfortable with spreadsheets, this works.

The weakness is that it stops when that person does.

Nobody except the person who wrote the formulas understands how the sheet is wired. Insert one column and a reference shifts, and the total is quietly wrong for the rest of the trip. On top of that, opening a spreadsheet on a phone mid-trip to add a row is, frankly, unpleasant. Tap the cell, wait for the keyboard, scroll sideways. That friction is exactly what produces “I’ll enter it later”.

For something like a long-running house share, where one person sits at a laptop once a month, spreadsheets are still a strong choice. For entering things as they happen on a trip, they aren’t.

Group chats let the record scroll away

Posting “got the taxi, $28” into a WhatsApp or Slack group is unbeatable for speed of entry.

It’s an app that’s already open, and you just type. Photos go in the same place. Whatever you write reaches everyone immediately, so there’s no separate sharing step.

The problem is that chat is chronological.

By day three, day one has scrolled out of view, and totalling means going back up and picking entries out by hand. Worse, the payment notes are interleaved with plans about where to meet and everyone’s photos. Reconstructing the numbers after the trip is heavier work than it sounds.

You can pin or re-post things into a saved note, but that just means someone still has to compile it afterwards.

What a dedicated app takes over

What a bill-splitting app actually does is separate entry from totalling.

Enter one expense and it’s stored as structured information: who paid, who shares it, how much. It doesn’t scroll away like chat, and there are no formulas to break. And the totalling is finished the moment you enter it. The job of compiling things later stops existing.

Multiple currencies follow the same logic. Mix expenses in different currencies and the conversion is handled at the point of recording. Doing that in a spreadsheet means looking up the rate for each date and typing it into a column yourself.

What you give up is flexibility. Splits the app doesn’t support, you can’t do. That said, equal, ratio and manual between them cover almost every real case.

In Evere, at the settlement stage, smart settlement collapses the transfers into the smallest set. That’s the calculation that gets less and less practical to do by hand as the group grows.

When to switch

The thresholds are group size and duration.

Three people for one day, it makes no difference what you use. You can add it up in your head. Past five people, or past three days, with more than one person fronting money, the number of entries goes over twenty. Somewhere around there, compiling it afterwards moves from “annoying” to “not going to happen”.

The other threshold is whether the group repeats. For a house share or a couple living together, where this recurs monthly, setting up a system pays for itself. For one trip a year, pushing through with whatever you already know can be faster.

Whether anyone in the group deals in cash matters too. If everyone is cashless the transfers finish immediately, but once physical cash is in the mix you need a moment where people are in the same room. Tracking expenses when cash, cards and mobile payments are mixed goes into that.

❓ FAQ

Q. Wouldn’t handing out a spreadsheet template solve it? The entry friction stays. A template reduces the totalling work, but filling cells on a phone mid-trip is just as unpleasant as before. The gaps-in-the-record problem runs deeper than the totalling-is-tedious problem, so it’s the right one to fix first.

Q. Some people in the group won’t install an app. Not everyone needs to. One person can record and share the result at settlement time. If you want to lower the barrier, having just the record-keeper start, and inviting the others once the benefit is visible, is more realistic than pushing everyone at once.

Q. What happens to old records if we switch tools mid-way? You don’t have to migrate anything. Close out a settlement at a natural boundary — the end of a trip, the end of a month — and start the new tool from there. Spending time moving old data across is slower than just letting that trip finish where it is.