←
BACK_TO_BLOG

Signs Your Business Has Outgrown Spreadsheets

Share
X_/_TwitterLinkedInCopy_Link
TL;DR
  • A business has outgrown spreadsheets when the sheet runs a daily workflow and nothing protects it. The file still opens fine, so the warning signs show up as people problems first.
  • Copy and paste between sheets, and formulas changed without review, are where spreadsheet errors creep in. JPMorgan's own 2013 review of its 2012 trading losses found both in the bank's risk and pricing spreadsheets.
  • Audits from 1997 onwards found errors in 91% of the 54 business spreadsheets they checked. Assume yours has some, and check the cells that feed prices, pay and invoices first.
  • Replace one workflow at a time, starting with the one that scores worst. A spreadsheet stays useful for analysis and one-off planning long after it stops being the system.
A loaded pallet of boxes, crates and a coiled cable resting on a thin blue grid sheet that has bent and started to tear, with a stapler beside it.

The clearest sign a business has outgrown spreadsheets shows up on an ordinary Friday afternoon: a customer wants a revised quote, and the one person who knows which tab feeds the price is on leave. A business has outgrown spreadsheets when a sheet has become the system a daily workflow runs on, and nothing around it behaves like a system. One person understands it, data moves between files by hand, mistakes surface after the numbers were used, and nobody can say who changed what.

Below are five signs, each with a short scene. The scenes are made up but typical of the businesses we talk to. There is a self-score at the end, and a section on when you should keep the spreadsheet.

Sign 1: Only One Person Understands the Sheet

The quote sheet has eleven tabs. Rahul built it four years ago, and when a price looks wrong, everyone forwards it to Rahul. When Rahul is on leave, quotes wait.

This sign is easy to ignore, because from the outside it looks like Rahul being good at his job. But the rules of your business, such as which customers get which discount and how freight is added, now live in one person's head and a few hundred formulas only he can read.

Large organisations fall into the same trap. In JPMorgan's 2013 task force report on its 2012 trading losses, one finding about a risk model was that the business "relied on the model creator" to operate it, with data "uploaded manually without sufficient quality control."

The test: if the person who built the sheet left tomorrow, could someone else change a price rule by Monday?

Sign 2: Someone Copies and Pastes Between Sheets Every Week

Every Monday, Priya opens the job sheet, filters last week's finished jobs, copies the totals and pastes them into the invoicing sheet. Then she does the same for the payroll sheet. It takes her the morning.

Each paste is a chance to grab the wrong rows, paste over a formula or miss the job that was finished late on Saturday. Nobody notices until a customer queries an invoice.

A hand cutting a column of cells out of one blue paper grid with scissors, beside a second grid where the strip has been pasted in sideways, one cell gone bright green, next to a glue pot and brush

The JPMorgan report describes the same routine. The model behind the bank's risk numbers "operated through a series of Excel spreadsheets, which had to be completed manually, by a process of copying and pasting data from one spreadsheet to another." The review also found a formula that divided by a sum where it should have divided by an average, which "likely had the effect of muting volatility by a factor of two."

If the same number is typed or pasted into two places, you have two versions of it, and sooner or later they disagree.

Sign 3: You Find Errors After the Numbers Were Used

A quote goes out with last year's steel price. Months earlier someone typed a number over the formula that pulled the current rate, and the cell still looks like every other cell.

Spreadsheet errors are normal, which is the problem. Raymond Panko of the University of Hawaii collected field audits of real company spreadsheets in Spreadsheet Errors: What We Know. What We Think We Can Do (EuSpRIG, July 2000). In the audits from 1997 onwards, 91% of 54 spreadsheets had errors. In three large spreadsheets audited closely, 1.1%, 2.2% and 2.5% of cells held original errors, about what general research on human error would predict, according to Panko.

At a 1% rate, a pricing sheet with 3,000 cells of formulas and inputs would hold around 30 wrong ones. A careful person still makes errors at about that rate. Software built for the workflow stops most of them at entry, with a price field that only takes a rate from the price list and a total nobody can type over.

Sign 4: The Sheet Changes What You Type

A storekeeper enters part number MAR3 and the cell shows 3-Mar. A customer's phone number loses its leading zero. A long product code turns into scientific notation.

This is autocorrect. A study in PLOS Computational Biology (Abeysooriya and colleagues, 30 July 2021) scanned published research and found gene name errors in 30.9% (3,436 of 11,117) of articles with supplementary Excel gene lists. Names like SEPT8 and MARCH3 had been turned into dates. These were trained scientists, and the errors were published alongside their papers.

If your stock codes, SKUs or customer IDs look anything like dates or long numbers, some of them have already been changed.

How many of these sound like your week?

  • ONE OWNER??
  • COPY AND PASTE??
  • LATE ERRORS??
  • CHANGED ENTRIES??
  • NO CHANGE LOG??

We replace the workflow that hurts most with software built around how your team already works, and we'll scope it in one call.

SCOPE_MY_WORKFLOW→

Sign 5: Nobody Can Say Who Changed What

The margin on a big job comes out far lower than anyone expected. Somebody changed the labour rate cell. Nobody remembers changing it, and the file has been saved as "Jobs FINAL v3 (2)" on three laptops.

Version history in shared sheets helps you find the change after the damage. It doesn't ask anyone to check a formula before it goes live. At JPMorgan, a staff member adjusted formulas in the spreadsheets he used to answer an audit point, and the task force found the changes were "not subject to an appropriate vetting process" and "inadvertently introduced two calculation errors."

When you replace spreadsheets with software built for the workflow, every change is logged against a name, and only the person allowed to change the labour rate can change it.

When a Spreadsheet Is Still the Right Tool

None of this means you should throw the spreadsheet away. A spreadsheet is the cheapest place to work out how something should work, because you can change your mind in seconds.

I work this way too. On a property portfolio product I worked on this year, we worked the ledger out in a spreadsheet first, then rebuilt it in the product. The next day we turned that ledger into the backend spec: a primary category, then a subcategory, then the detail, filters by transaction type, and an "Others" category that can't be used without a note explaining it.

That is the healthy order. The sheet is where you discover the rules. Software is where you enforce them, once they stop changing every week. If you're at that point, writing the rules down is the next step, and our guide to how to write a PRD shows how.

Honestly, a sheet built to think with only turns into a problem once someone uses it to run payroll.

When to Stop Using Spreadsheets: Score Each Workflow

Take one workflow at a time, such as quoting, job tracking, stock or invoicing, and answer yes or no:

1. Would this workflow stall if one particular person were away for a week? 2. Does someone copy or retype numbers from this sheet into another file? 3. Have you found a mistake in it after a quote, invoice or payslip went out? 4. Has the sheet ever changed a code, date or number you typed? 5. If a key number changed, would it be hard to find out who changed it, and when?

0 or 1: keep the sheet. Lock the formula cells, keep one master copy and check it cell by cell once a quarter, the one error check Panko found had been shown to work.

2 or 3: this workflow is close. Fix the copy and paste first, because it feeds the other problems.

4 or 5: the spreadsheet is running this part of the business. Replace this one workflow, and leave the rest alone for now. A clickable prototype of the new screens is a cheap way to check your team can actually use them before anything gets built.

Which of your workflows scored highest?

FAQs

// QUESTIONS //
Q.

What should replace a spreadsheet in a small business?

Off-the-shelf software fits standard jobs like accounting and payroll. Custom software fits the parts of your business that work differently from everyone else's, such as how you quote or cost each job.

Q.

Is Google Sheets better than Excel for a growing team?

Google Sheets is better for sharing, because everyone works in one live file instead of emailed copies. The same PLOS study found it turns gene names into dates just as Excel does, so it fixes the copies problem and leaves the rest.

Q.

Should I move old spreadsheet data into the new system?

Move the records you still act on, such as open jobs, current stock and active customers, and clean them in the spreadsheet before the import. Keep closed history in the old file, locked, until nobody asks for it.

Q.

Can I keep using spreadsheets alongside new software?

Yes. Export data from the new system into a spreadsheet for analysis and planning, and keep the system as the single place where records are entered.

2-WEEK SPRINTS
//
$2,500 FLAT
//
LIVE IN 90 DAYS
//
THE CODE IS YOURS
//
ZERO LOCK-IN
//
2-WEEK SPRINTS
//
$2,500 FLAT
//
LIVE IN 90 DAYS
//
THE CODE IS YOURS
//
ZERO LOCK-IN
//
2-WEEK SPRINTS
//
$2,500 FLAT
//
LIVE IN 90 DAYS
//
THE CODE IS YOURS
//
ZERO LOCK-IN
//
2-WEEK SPRINTS
//
$2,500 FLAT
//
LIVE IN 90 DAYS
//
THE CODE IS YOURS
//
ZERO LOCK-IN
//

Keep the sheet. Replace [the workflow.]

START_PROJECT
→