Running a business on spreadsheets: when it breaks

Key takeaways

Running a business on spreadsheets is sensible at the start and risky at scale. Spreadsheets have no built-in checks, no audit trail and usually one person who understands them. The hidden cost is the hours of upkeep and the decisions made on figures that nobody has verified.

• Spreadsheets fail quietly: a wrong formula still shows a number.
• Warning sign: only 1 person understands the main spreadsheet.
• Warning sign: the same data is typed into 2 or more files.
• Move the highest-risk sheet first: usually money or customer data.

Why do small businesses rely on spreadsheets?

Small businesses rely on spreadsheets because they are already paid for, flexible and familiar. A spreadsheet can become a CRM, a job tracker, a stock list or a payroll calculator in an afternoon. That flexibility is the strength at ten customers and the weakness at five hundred.

• The hidden costs of doing everything in-house
• The cost of manual processes, and what to fix first

What are the risks?

The main risks are silent errors, lost versions and dependence on the author. A formula that excludes the last row still produces a total. Two people editing copies produce two truths. Personal data in a spreadsheet emailed around the team is hard to secure, and the Information Commissioner's Office expects small organisations to keep personal data accurate and protected.

• Formula and copy and paste errors nobody notices.
• Multiple versions with different figures.
• No record of who changed what.
• One author who cannot take leave.
• Personal data with no access control.

• The one-person department: risks and hidden costs

What does spreadsheet upkeep cost?

Upkeep costs the hours spent entering, reconciling and repairing. If a manager on £45,000, costing about £29.98 per worked hour, spends 4 hours a week maintaining spreadsheets, that is about £5,500 a year. That often exceeds the yearly price of the purpose-built software that would replace them.

• Time spent on manual reporting: what it costs

When should you move off spreadsheets?

Move when a spreadsheet is shared by several people, holds money or personal data, feeds decisions, or needs the same data entered elsewhere. Those are signs it has become a system and needs the controls of one.

• Build vs buy software: the small business view

When are spreadsheets still the right tool?

Spreadsheets remain the right tool for analysis, one-off modelling, small lists and anything used by one person. The aim is not to ban them but to stop using them as the system of record for things that matter.

How do spreadsheets become business-critical by accident?

It happens in stages. Someone builds a sheet to solve a problem this week. It works, so colleagues start using it. Columns are added, then tabs, then formulas linking to other files. Two years later the business quotes, schedules or pays people from it, and nobody ever decided that it should. No one tested it, backed it up properly or wrote down how it works.

What should you do before moving off them?

Reduce the risk first, because a migration takes months and the exposure exists today.

• Store the file in a shared, backed-up location with version history.
• Restrict who can edit, and lock formula cells.
• Have a second person learn how it works.
• Add simple checks, such as totals that must agree.
• Write a one-page note on what it does and where data comes from.

• The cost of undocumented processes

What does a move actually cost?

The subscription is the small part. Standard business software commonly costs £20 to £100 per user per month. The larger costs are cleaning the data, importing it, training people and running both systems side by side for a few weeks. Budget staff time for that, or buy help for it, and move one function at a time so that a problem affects one area and not the whole business.

What mistakes are made when replacing spreadsheets?

The common mistakes are importing years of messy data untouched, copying the old layout instead of using the new tool as designed, and giving the project to someone with no time for it. A fourth is building a complicated custom system when a standard product would have done the job.

What does this look like in practice?

A pattern we see with job scheduling: a colour-coded spreadsheet runs the whole operation, maintained by the person who built it. It works, and everyone is afraid to touch it. A week of that person's absence shows how much depends on a single file.

• See client work
• BPO Solutions for UK businesses

Spreadsheet risk checklist

Review your critical spreadsheets.

• List spreadsheets the business could not run without.
• Note who understands each one.
• Check which hold money or personal data.
• Count the hours of weekly upkeep.
• Add a second trained person and a backup now.
• Plan to move the riskiest one first.

• The hidden cost audit: score your business in an hour

Next step

Tell us which spreadsheet your business depends on most. We will help you assess the risk and the options in a 30-minute call.