Somewhere in your company, a spreadsheet decides who gets paid
Spreadsheets don't fail loudly — they get load-bearing. The five signals that one has stopped being a tool and become infrastructure, and what to move first.
There is a file. It has a name like payments_master_v4_FINAL_updated.xlsx. One person maintains it, and when they are on holiday something in the business slows down or stops.
Nobody decided this. Nobody would have approved it. It happened the way these things always happen — someone built a useful sheet, it worked, and then it kept working for three more years while the business grew around it.
Spreadsheets don’t fail. They get load-bearing.
The problem is never that a spreadsheet is bad at what it does. Spreadsheets are extraordinary tools, and most alternatives are worse at the thing spreadsheets are best at: letting one person think about a problem with total freedom and no setup cost.
The problem is a slow change of role. A file starts as an analysis — a way to work something out. It becomes a record — the place the answer is kept. Then it becomes a process — the thing other people depend on to do their jobs. At no point does anyone announce the transition.
By the end, a document with no access control, no audit trail, no validation and no concurrency is deciding who gets paid.
The five signals
1 · Someone’s absence stops something
The clearest test there is. If a person being away means payments cannot be made, invoices cannot be raised, or nobody can say what a customer owes, the file is infrastructure and the person is a single point of failure.
This is usually the first signal anyone notices, and it usually gets noticed during a holiday rather than in a planning meeting.
2 · There are versions
_v4. _FINAL. _updated. _use this one.
Versions in a filename mean the file has no authoritative state. Two people have two copies, both have made changes, and reconciling them is a manual act of judgement performed by whoever notices first. If the file determines money movement, the versions are competing accounts of what is owed.
3 · Formulas have been replaced by pasted values
Open a column that should be calculated. Click a cell. If the formula bar shows a number instead of a formula, somebody pasted over it — usually to fix a display problem, usually in a hurry, usually without telling anyone.
That cell is now permanently wrong in a way that will never announce itself. Every total that depends on it is wrong too, quietly, forever.
4 · The reconciliation is against another spreadsheet
When the answer to “how do we know this is right?” is a second spreadsheet, the business has built a control out of the same material as the thing it is controlling. Both files share every weakness. Agreement between them is not evidence of correctness — it is evidence that the same person applied the same assumptions twice.
5 · Nobody can say who changed what
A number is wrong. When did it change? Who changed it? What was it before?
A spreadsheet cannot answer any of these. This is fine for analysis and unacceptable for a process that determines payments, because the moment there is a dispute — internal or with a supplier — the record of what was decided and when does not exist.
What to move first
Not everything. Attempting a general migration off spreadsheets is how these projects die: it is large, it has no obvious first win, and it competes with actual work.
Rank by cost-of-error multiplied by time-to-discovery.
An error in a forecast is embarrassing and correctable — high visibility, low cost. An error in a payment run moves real money to the wrong party and is typically discovered only when someone complains, which may be weeks later. That is the one to move.
For most businesses the ranking comes out something like:
- Anything determining outgoing payments — supplier runs, subcontractor payments, commission splits. Wrong money leaves the building and recovering it is materially harder than not sending it.
- Anything determining what customers owe — because errors here are found by customers, and each one costs credibility as well as cash.
- Anything feeding statutory filings — VAT especially, where errors have a deadline and a regulator attached.
- Everything else — which is often genuinely fine where it is.
That fourth category matters. The goal is not to eliminate spreadsheets; it is to stop them being the only place a decision is recorded.
The move that isn’t a migration
Before replacing anything, there is a cheaper intervention that solves a surprising share of the risk: stop the spreadsheet being the origin of the data.
Most load-bearing finance spreadsheets exist because information lives in several systems and none of them talk. Someone exports from the bank, exports from the accounting system, pastes both into a sheet, and reconciles by hand. The spreadsheet is not really the process — it is a symptom of a missing join between systems that each hold part of the picture.
If the join exists somewhere else, the sheet reverts to being an analysis, which is what it was always good at. That is the same structural gap behind three systems that disagree about the same month.
What you lose, honestly
Anyone who has run finance on spreadsheets knows what a system costs you, and it is worth saying plainly rather than pretending the trade is free.
You lose immediacy. In a spreadsheet, a new question takes ninety seconds. In a system, it may take a change request.
You lose flexibility. Spreadsheets accommodate exceptions effortlessly. Systems have opinions, and every exception argues with them.
You lose the feeling of understanding. A spreadsheet is visible all the way down. A system is a black box that emits answers.
Those are real. The reason to move anyway is not that systems are better tools — it is that the properties you need from infrastructure are different from the properties you need from a tool. You need to know who changed what. You need two people working at once. You need an error to be caught at entry rather than discovered by a supplier. A spreadsheet cannot give you those, however good it is.
Keep the spreadsheets for the questions. Move the decisions.
Where Fynex fits
The spreadsheet that decides who gets paid usually exists because the information needed to make that decision is scattered — an invoice in one system, a contract term in another, a bank balance in a third, and a person in the middle assembling them into a payment run by hand each month.
Fynex does that assembly. Obligations, terms, balances and what has actually been paid live in one place, so the payment run is derived rather than typed. Approvals are recorded as approvals rather than implied by a filename. Changes carry who made them and when.
The result is not that the spreadsheet is banned. It is that when someone is on holiday, nothing stops.