The Hidden Cost of "It's Just a Spreadsheet"

When someone suggests replacing the order tracker with a proper tool, the first objection is usually the price. “We’d be paying per seat for something we already do for free.” And it’s true that nobody sends you an invoice for the spreadsheet.

But “free” is doing a lot of work in that sentence. The sheet costs you every week. You just pay in hours, mistakes and risk instead of in a line item, which makes it easy to ignore and hard to argue about. This post gives you a way to put a rough number on it.

The four costs nobody budgets for

Spreadsheet costs fall into four buckets. Most teams feel all four but only ever talk about the first.

1. Reconciliation time

This is the time spent making copies agree with each other. Sales has their version of the customer list, finance has theirs, and once a month someone sits down with both and a strong coffee to work out which is right.

It also includes the small stuff: checking whether a row was updated, chasing someone to confirm a figure, re-sorting a tab someone else filtered. Individually these take minutes. Across a team, they take days.

2. Errors and their clean-up

A formula gets dragged one row too far. Someone pastes values over a calculation. A date gets entered as text and silently drops out of a total. Spreadsheets don’t warn you about any of this; they just give you a confident, wrong answer.

The cost isn’t only fixing the error. It’s the refund you issued to the wrong customer, the shipment that went out late, or the board report you had to correct after it was sent.

3. Onboarding and handover

Every new person who touches the sheet needs to learn its unwritten rules. Which tabs are live. Which columns are calculated and must never be typed in. What yellow means. Say that takes a week of reduced productivity and a few hours of a colleague’s time to explain. Multiply by everyone who joins or changes role in a year.

4. Key-person risk

This is the one that doesn’t show up until it does. If one person built and maintains the sheet, your process has a single point of failure: one component that, if it breaks, takes everything with it. When they’re off sick during month-end, or hand in their notice, you find out how much of the process lived in their head.

You can’t put a precise figure on this one, but you can ask a blunt question: if this person left tomorrow, how many weeks would it take someone else to run this process confidently?

A back-of-envelope calculation

You don’t need a consultant for this. You need a notepad and honest answers. Here’s a worked example for a fictional six-person operations team running customer orders out of a shared workbook.

These numbers are illustrative. Yours will differ, but the shape usually holds: reconciliation is the biggest visible chunk, and the risk line is the one leadership cares about most once it’s written down.

A few notes on getting the inputs right:

• Loaded hourly cost means salary plus the overheads that come with an employee, such as benefits, equipment and office space. If you don’t know it, a common rough approach is salary divided by working hours, then multiplied by about 1.3.
• Ask, don’t guess. Have each person on the team estimate their own reconciliation time for one week. People underestimate this, so if anything your total will be conservative.
• Only count errors you noticed. The ones you didn’t notice are real too, but you can’t prove them, and a credible estimate beats a dramatic one.

What the number is for

Your total isn’t a precise figure. It’s a sense of scale. If the answer is $2,000 a year, the spreadsheet is probably fine and you should spend your energy elsewhere. If it’s $30,000, a tool costing $6,000 a year plus a few weeks of setup starts to look cheap.

The number also changes the conversation. “The tracker is annoying” invites a shrug. “The tracker costs us roughly $29,000 a year and depends on one person” invites a meeting. If you’re heading towards that meeting, Getting Buy-In: Pitching an Internal Tool to Leadership covers how to frame it.

Be careful not to compare your total against the licence fee alone. A new tool has its own costs: setup, data migration, training and ongoing admin. A fair comparison puts the spreadsheet’s annual cost next to the new tool’s annual cost including those. Buy, Configure, or Build? A Decision Framework for Internal Tooling goes through those trade-offs in detail.

The costs that compound

One more thing the calculation understates: these costs grow. Each new customer adds rows. Each new team member adds another person who might sort the wrong column. Each workaround someone invents to cope makes the sheet harder for the next person to understand.

A process that costs you $10,000 a year at 200 orders a month doesn’t stay at $10,000 when you hit 600. The spreadsheet doesn’t scale linearly. It scales like a cupboard you keep stuffing things into: fine for a long time, then suddenly the door won’t close.

Where to start this week

1. Pick your most painful sheet and fill in the table above for it. Rough numbers are fine; you can refine them later.
2. Run a one-week time log. Ask everyone who touches the sheet to note, in a single line each day, how many minutes they spent checking, fixing or reconciling it.
3. Answer the key-person question honestly. Write down who would be stuck if the sheet’s owner disappeared for a month, and for how long.
4. Share the total with one decision-maker. Not as a proposal yet, just as a fact: “I worked out roughly what this costs us. Thought you’d want to know.”