How to manage shared expenses without spreadsheets
A shared expenses spreadsheet works beautifully for about six weeks. Understanding exactly how it fails is the fastest way to work out what should replace it — or whether anything should.
Published
Why spreadsheets get used in the first place
They are free, universally available, and infinitely flexible. There is no adoption problem — everyone already knows roughly how one works, and nobody has to be persuaded to install anything.
For a fixed group, a fixed set of costs and a fixed rule, a spreadsheet is genuinely fine. The failures below all come from change: new people, new kinds of cost, or simply time passing.
Failure 1: it has exactly one editor
In theory everyone shares it. In practice one person maintains it, and everyone else sends amounts by message for that person to type in.
That creates two problems at once. The maintainer becomes a bottleneck — nothing is recorded while they are busy — and everyone else is one step removed from the record, so nobody else checks it. When the maintainer loses interest, the system stops entirely, usually without an announcement.
Failure 2: formulas break without saying so
This is the serious one, because the output still looks like a number.
- A fifth person joins and the division still says ÷ 4.
- A row is inserted just outside a SUM range, so it silently contributes nothing.
- Someone types “£120” as text into a numeric column and the total drops.
- A formula is copied down with a reference that should have been absolute.
- Someone sorts one column without the others and every row now describes a different expense.
None of these produce an error. They produce a confidently wrong balance, which is worse than no balance — people act on it, and the mistake is only discovered when somebody happens to check by hand.
Failure 3: no audit trail
When a figure is questioned three months later, a spreadsheet cannot say who entered it, when, or what it replaced. Some tools keep version history, but nobody reads a spreadsheet diff to resolve a disagreement about £30 — and the social cost of asking for one is higher than the amount in dispute.
A record that cannot explain itself does not settle arguments, which is most of what a shared record is for.
Failure 4: nobody updates it at the till
The right moment to record an expense is the moment it is paid — standing at a counter, holding a phone. That is the worst possible context for a spreadsheet.
So the entry is deferred, and deferred entries become forgotten entries. This is why the spreadsheet fills up in bursts, days late, from memory and bank statements — which is exactly the reconstruction work it was supposed to prevent.
What a replacement actually has to do
Read as requirements rather than features, the four failures give a short list:
| Requirement | Because |
|---|---|
| Every person can add an expense themselves, from their own phone | Removes the single-maintainer bottleneck, and puts recording at the moment of payment. |
| Balances are calculated, not hand-built | No formula to break when the group changes. |
| Each expense records who paid and who shared it | The two facts a spreadsheet column usually omits, and the two that determine the answer. |
| Changes are visible and reversible | So a disputed figure can be explained rather than argued about. |
| The data can leave | Nobody should be trapped. CSV export keeps the spreadsheet available for anything bespoke. |
When to keep the spreadsheet
Some cases genuinely favour it, and pretending otherwise would be useless:
- A split rule that is not equal, exact or percentage — weighted by nights stayed, or a sliding scale by income.
- Modelling and projections rather than recording. A wedding budget is a spreadsheet problem.
- Formal accounts with bespoke reporting requirements.
- Working offline.
The hybrid works well: record shared expenses in an app so everyone can contribute and the balances stay right, and export to CSV when you want to do something a spreadsheet is better at.
Moving off a spreadsheet mid-way
You do not need to import history, and trying to is usually what stops people from switching at all.
The two-line migration
- Total the existing spreadsheet one final time and settle those balances, or record the net position as a single opening expense per person so the starting point is honest.
- From that date, record new expenses in the new system only. Running both in parallel guarantees they disagree, and then neither is trusted.
Keep the old file. It is the archive of everything before the cut-over, and it costs nothing to keep.
Questions
Can Expenddy track who owes whom?
Tracking who owes whom is Expenddy's main function. Every expense updates a running balance for each member, and each group shows what you owe and what you are owed, broken down per person. Balances recalculate whenever an expense is added, edited or deleted.
Can I get my data out of Expenddy?
Expenddy exports to CSV. A group's full ledger can be exported from the group's settings, a friend ledger from that ledger's screen, and your personal records from the personal section. The file opens in any spreadsheet program.
Can I create expense groups?
Groups are how Expenddy organises shared costs. You create a group, give it a name and a type — General, Trip, Home, Couple, Other — and invite the people involved by email, phone number or an invite link. Each group has its own expenses, balances and settlement history.