A broken Excel spreadsheet doesn't send up a flare. It doesn't crash, and it usually doesn't throw an obvious error. It just sits there costing you time, accuracy, and trust, one open file at a time.

Most businesses never put a number on that cost, so it never lands on anyone's priority list. The file still works, technically, so it stays. Meanwhile someone's spending an extra hour every week double-checking a report, or a bad number made it into a customer quote and nobody caught it until the invoice went out wrong.

This post walks through where that cost actually shows up, in hours, in rework, in decisions made on numbers nobody double-checked, and in whoever ends up holding the risk. It also gives you a quick way to put a rough number on what your own spreadsheet is costing you, so you can decide whether it's worth fixing.

Quick Answer

A broken spreadsheet costs a business in five places: staff time, rework from errors, decisions made on bad numbers, trust in the reporting itself, and the risk that piles up when one person is the only one who understands the file. None of that shows up as its own line on a P&L, which is a big part of why it gets ignored longer than it should.

What "Broken" Actually Means Here

This isn't just about spreadsheets producing numbers that are obviously wrong. Most of the real cost comes from files that technically still work but are fragile underneath: slow to update, dependent on one person, full of formulas nobody remembers building, held together by copy and paste.

For the full list of warning signs, ProsperSpark's Spreadsheet Risk & Controls Kit covers that in detail, along with a checklist to run against your own file. This post picks up from there with a different question: once you've spotted the signs, what are they actually costing you?

Where the Cost of a Broken Spreadsheet Actually Shows Up

The cost of a broken spreadsheet rarely lives in one place. It's spread across time, errors, decisions, trust, and the people stuck maintaining it. Here's where it tends to show up.

1. Time cost

Time is the most visible cost, and usually the most underestimated. Someone re-enters data that already exists somewhere else. Someone reconciles two versions of the same report. Someone rebuilds the same broken formula every month instead of just fixing it.

None of that looks expensive in the moment. A few minutes here, twenty there. Add it up across a week, a quarter, and a full team, and it's often the biggest cost on this entire list.

2. Error and rework cost

A mistake that slips through costs you twice: once to produce the wrong output, and again to catch it, explain it, and fix it. A wrong number on a customer quote turns into a corrected invoice and an uncomfortable phone call. A wrong figure in a commission calculation turns into a payroll correction and a trust problem with whoever got shorted.

Some of these mistakes stay small and forgettable. Others don't. ProsperSpark has covered the $6 billion Excel error and TransAlta's $24 million copy-paste mistake, two extreme examples of what happens when an error like this goes uncaught inside a high-stakes process. Most businesses will never see a mistake at that scale, but it starts the same way every time: something small goes unchecked and compounds.

3. Decision cost

This one's harder to put a number on, and it's often the most expensive of the five. When leadership makes a pricing, staffing, or forecasting call based on a number nobody double-checked, the spreadsheet is rarely where the expense lands. It shows up in whatever decision got built on top of it.

A forecast that overstates demand leads to overstaffing or overordering. A margin report that understates cost leads to underpriced work. Decisions like these are hard to walk back once they're in motion, which is exactly why a bad input gets expensive fast.

4. Trust cost

Once a report has been wrong one time, people stop trusting it, even after it gets fixed. That's usually when shadow spreadsheets start showing up: someone quietly builds their own version to double-check the official one. Now you're maintaining two files with two sets of numbers instead of one.

People rarely go back to trusting a report fully once it's burned them, even after the problem is fixed. It's a lot cheaper to keep that trust intact than to earn it back.

5. People cost

A fragile spreadsheet usually depends on one person who actually understands how it works. That person becomes the bottleneck for every update, and the single point of failure the day they're out sick, on vacation, or gone for good. It's also just unfair to them. They end up carrying risk that should belong to a process, not a person.

The How to Prevent Spreadsheets from Causing Financial Errors post covers practical ways to cut down this kind of key-person dependency, like separating inputs from formulas and keeping a simple change log.

How Much Does This Actually Add Up To?

These are directional estimates based on patterns we see in real projects. Treat them as a starting point, not a guarantee for your business:

• • A weekly report that takes 2 to 3 hours to pull together by hand adds up to 100+ hours a year in staff time on that report alone.
  • A single pricing or quoting error that reaches a customer usually costs more in the correction, the awkward conversation, and the follow-up than it would have taken to catch it upfront.
  • When a spreadsheet depends on one person, the cost stays invisible until that person is out and nobody else can touch the file. At that point, the cost is whatever the business loses by being stuck.

The well-known public cases, the $6 billion JPMorgan “London Whale” error, TransAlta's $24 million copy-paste mistake, sit at the extreme end of this scale. Almost no small or mid-sized business will see a mistake that size. But strip away the zeros and it's the same story: an error nobody caught, sitting inside a process important enough that it mattered.

How to Estimate What Your Spreadsheet Is Actually Costing You

You don't need a formal audit to get a useful number here. This is something you can run in under an hour.

1. Track the time spent this month. Ask whoever owns the file how much time they spend updating, fixing, or reconciling it in a normal week, then multiply that by their hourly cost.

2. Count the errors from the last quarter. List out the mistakes you know about, even the small ones, and include what it took to catch and fix each one, not just the original slip.

3. Name the decisions that depend on it. Write down what actually gets decided from this file's output, pricing, staffing, forecasting, payroll, and ask what a wrong number there would cost you.

4. Identify the single point of failure. Ask who could pick up this file tomorrow if the current owner couldn't. If the honest answer is nobody, that's already a cost, whether or not anything has gone wrong yet.

5. Add it up and compare it to the fix. Once you've got a rough number for time, errors, and risk, weigh it against what it would actually take to add controls or automate the worst of it. More often than not, the math favors fixing it sooner.

Common Mistakes When Weighing This Cost

• • Only counting the dramatic failures. The $6 billion stories get the attention, but most of this cost comes from small, repeated friction, not one big blowup.
  • Ignoring time because it's not a line item. Staff hours lost to manual rework are a real cost, even though they never show up as their own expense.
  • Waiting for a failure to justify the fix. If you wait for something to break before you act, you're paying the hidden cost the entire time you wait.
  • Assuming a rebuild is the only fix. A handful of practical controls, separating inputs from formulas, adding a change log, often cuts the risk without touching the whole structure.
  • Not naming who actually owns the risk. When nobody's accountable for the file's accuracy, the cost of a mistake lands on whoever happens to be using it that day.

The Bottom Line

A spreadsheet that hasn't failed yet still isn't free. The cost just hides in places a report won't show you: time, rework, decisions, trust, and whoever's quietly carrying the risk.

If that exercise above turns up a number that's hard to ignore, our Excel & VBA Consulting team can help you stabilize or rebuild the file. If the issue runs bigger than one spreadsheet, a Business Operations Audit is a solid next step for looking at the whole process.