Situation
Why a shared expenses spreadsheet dies after three weeks
A shared spreadsheet does not die from bad design but from an imbalance: whoever maintains it bears the whole cost of entry, while the benefit spreads across the group. Since expenses happen at the restaurant or the petrol station, and entry happens at a computer hours later, every row demands an act of memory that falls on one person alone. They tire, and the file stops.
One person pays the cost, the group gets the benefit
That is the whole problem, and it has nothing to do with the quality of the file. Whoever maintains the spreadsheet spends time chasing amounts, working out who paid what, fixing badly filled rows. Everyone else reads the result for free. No system survives that imbalance for long, however good the initial intentions.
The expense and the entry do not happen in the same place
The expense happens at the restaurant, the petrol station, the supermarket till. The entry happens at a computer, that evening or the following weekend. In between, you have to remember the amount, the reason and the payer. Every row therefore demands a small act of memory, and it is those accumulated efforts that cause abandonment, not the difficulty of the spreadsheet.
Two people editing create two truths
A file shared by email or messaging duplicates at the first simultaneous edit. From then on nobody knows which version is authoritative, and the most complete version is not necessarily the most recent. An online spreadsheet fixes that specific point, but not the previous two, which is why flatshares that move to a collaborative sheet abandon it almost as fast.
What it remains unbeatable at
A spreadsheet is still the right tool for a one-off account, between two or three people, over a short and known period: a single trip, a joint present, a project with an end date. The entry imbalance has no time to appear, and nobody needs to install anything. The problem is not the spreadsheet, it is the spreadsheet that lasts.
Key points
- In a shared expenses spreadsheet, the cost of entry falls on one person while the benefit spreads across the whole group.
- The gap between where an expense happens and where it is entered imposes an act of memory on every row recorded.
- A file shared as an attachment duplicates at the first simultaneous edit, and the most complete version is then not necessarily the most recent.
- An online collaborative spreadsheet removes the competing-versions problem but not the entry imbalance.
- A spreadsheet remains suitable for a one-off account between two or three people over a short, known period.
Frequently asked questions
Does an online spreadsheet fix the problem?
It fixes competing versions, not the fact that one person does the entry. That is why the gain is smaller than expected.
How long does a flatshare spreadsheet last on average?
There is no reliable figure on this, and be wary of anyone quoting one. The order of magnitude commonly reported is a few weeks.
When is it better than an app?
For a single account, between two or three people, over a few days. An app takes over as soon as the period lengthens or the group grows.
And day to day : how the app handles it