Shared expenses spreadsheet or app? Where the sheet breaks

October 7, 2026 · 6 min read · Dimesum Engineering

A shared expenses spreadsheet is right on day one and drifts at four moments you can name in advance: an edit, a second currency, a payment nobody confirmed, and a cent that will not divide. Here is each one worked through, and the short list of groups that should keep the sheet.

A shared expenses spreadsheet is five columns and one formula, and on day one it is right. It goes wrong later, at four moments you can name in advance: an edit, a second currency, a payment nobody confirmed, and a cent that will not divide. Dimesum is the app we built for groups that hit those moments, and this essay is also an honest account of when the sheet is still the better call.

We have nothing against spreadsheets. We publish a shared expense tracker template ourselves, and our own market research in August 2026 found that when a group gives up on a splitting app, the place it most often goes is back to a sheet. The real question is which of the four moments your group will meet, and how soon.

On the first day, the sheet is right

Four flatmates, one month of groceries. Each row holds the date, what it was, who paid, the amount and who shared it. One sum per person gives what they paid, another gives what they owe, and the difference is their balance.

That is a correct ledger, and for a month with no surprises it needs nothing else. The method underneath is the same one any app uses; the split expenses calculator method walks through it in four steps. The trouble starts when the month has a surprise in it.

The first edit erases the number it replaced

Sofia typed the ramen night as ¥6,000. It was ¥8,000. Lucas fixes the cell, and each of the four shares moves from ¥1,500 to ¥2,000.

Nothing on the sheet says it changed. Google Sheets keeps a version history of edits, but it records that a cell changed, with no reason attached, and nobody opens it in the middle of a disagreement about a dinner. The new figure looks exactly as settled as the old one did.

An app built for this keeps the original and records the correction as its own entry, so both figures sit on the bill where everyone already looks. We wrote up why an edit must restate its split and the append-only ledger that makes it possible.

A second currency turns one rate cell into a moving target

On a trip to Tokyo, Aiko pays ¥12,000 for dinner. The sheet converts with a rate cell set to 160 yen to the euro, so the row reads €75.00.

A week later Jonas updates the rate cell to 165 for a new bill. The dinner row now reads €72.73. Nobody touched the dinner, and its value moved by €2.27 anyway.

If the rate cell uses the GOOGLEFINANCE function, every converted row can move whenever the sheet recalculates. Dimesum keeps the balance in yen, per currency, and a group may choose to read it folded at a rate it agrees. The multi-currency money bugs post covers the failure in detail, and keeping track of who owes who on a trip covers the trip itself.

A paid column is a claim anyone can tick

Noah sends Sofia €45 and ticks the box marked paid. Her bank shows nothing yet. Or it shows €40, because Noah rounded down in his head.

The sheet cannot tell a claim from a confirmation, because the person receiving the money never had to agree to anything. In Dimesum a recorded payment is a claim the payee confirms, and one payment that clears debts in several groups is one record confirmed once. Settling up group expenses explains the confirm step, and paying one rent from four accounts shows what a €50 short payment does to a month.

€100 split three ways comes to €99.99 in a sheet

Divide €100 by three and each share is €33.333, repeating. The sheet shows €33.33 three times, which a person adds up to €99.99, while the formula keeps the hidden third and totals €100.00. Two people reading the same sheet can now disagree by a cent and both be right.

Wrap each share in the ROUND function and the displayed shares do add to €99.99. The missing cent has to belong to someone, and the sheet has no rule for who. Excel also stores numbers in binary floating point, and Microsoft's page on floating-point arithmetic explains why a long column of decimals can end a fraction off.

Dimesum keeps every amount in whole cents and gives the leftover cent a fixed home, so the shares always add back to the bill. Why shared balances never add up covers rounding with the other three causes, and why the app total differs from your spreadsheet takes the side-by-side case.

Where a shared expenses spreadsheet breaks, and what Dimesum does at the same moment
Moment	What the spreadsheet does	What Dimesum does
A bill is corrected	Overwrites the cell; the old value lives in a separate version log	Restates the split; the original stays on the bill
A second currency appears	One rate cell revalues every converted row	Keeps a balance per currency; folds at an agreed rate only if the group chooses
Someone pays	Anyone can tick paid	The payee confirms the payment
€100 splits three ways	Shows €33.33 three times and totals €100.00	Stores whole cents; the leftover cent goes to a fixed place
A new person joins	Needs the link and edit rights	Takes a seat from a link or a QR code

When the sheet is still the right call

Keep the spreadsheet if your group matches most of this list. It is a short list on purpose.

Two people, or three who see each other daily.
One currency, with no trips abroad planned.
Bills that almost never get corrected after the fact.
One person who enjoys keeping it, and everyone else content to trust them.

A couple who split rent at a fixed ratio often fit that list for years, though the apps for couples to split expenses show what a saved ratio and a repeating rent take off your hands. If your group fails two or more of these, an app will save you the arguments a sheet cannot see coming. The ranking of shared-expense tracker apps compares ten of them on five tests.

The last point on that list is the real one. A sheet works because one person keeps it honest, and tracking shared expenses is about what that job costs the person doing it.

Keep the sheet until the first moment it cannot see

Look at your next month and count the four moments: an edit, a second currency, a payment someone needs to confirm, a bill that will not divide. If two of them are coming, move before they arrive rather than after the argument. Open Dimesum and enter last month's rows to see whether the totals match your sheet.

Common questions

Is a spreadsheet good enough for shared expenses?

Yes, for two people in one currency who rarely correct a bill. A shared expenses spreadsheet starts to drift at four moments: a correction overwrites the old figure, one rate cell revalues every converted row, anyone can tick a payment as paid, and €100 split three ways shows €33.33 three times.

How do I calculate shared expenses in a spreadsheet?

Record each bill with who paid, the amount and who shared it. For each person, add up what they paid, subtract the sum of their shares, and the result is their balance; a positive number means they are owed. Our shared expense tracker template sets this up in five columns.

Why doesn't my spreadsheet total match my splitting app?

Usually it is rounding or an exchange rate. A sheet can display €33.33 three times for a €100 bill while keeping the hidden third, and a changed rate cell revalues old rows. An app that stores whole cents puts the odd cent somewhere fixed, so the two totals can differ by a cent or two.

Can I move my spreadsheet history into an app?

Yes, and you do not have to start from zero. Dimesum can take a whole history in with an AI assistant through its API, so months of rows come across as bills. Compare the balances with the sheet afterwards, and expect a cent of difference wherever the sheet rounded a share.