Every Part of the Business Lived in a Different Spreadsheet, and No Two Agreed

About the business

I run a small wholesale and fulfillment business. Orders, inventory, a weekly schedule, a handful of vendors. For years, each of those lived in its own spreadsheet, kept by whoever owned that part of the business.

The problem: every sheet looked fine on its own

Open any single spreadsheet and it looked fine.

The trouble started when two of them needed to agree, which in a business like ours happens every time an order ships, a delivery lands, or someone decides a vendor isn't worth the hassle anymore.

An order total in one sheet didn't match what inventory said had shipped. A vendor was "active" in one document and, according to another, someone we'd stopped using months ago. Nobody was careless. The sheets drifted apart because more than one person was updating related facts in different places, and nothing forced them back together.

I didn't set out to "digitize the business." Honestly, I wasn't sure whether we'd outgrown spreadsheets or just organized them badly. I didn't want to pay to solve the wrong problem.

What we did: find the disagreement that costs money

Instead of replacing everything, we went looking for the one gap that was actually hurting us. The method was simple enough to do on a whiteboard:

1. List every number that's written down in more than one place. Order quantities, stock levels, vendor status, delivery dates.
2. For each one, note who updates each copy and when. This is where the drift shows up. Two people, two schedules, one number.
3. Ask which mismatch has cost real money or a client's trust. Not which one is annoying. Which one has a bill attached.

For us, the answer was orders and inventory. When those disagreed, we promised stock we didn't have, and a customer found out before we did. That was the one worth fixing first.

So we fixed that one, and left the rest alone.

A few sheets were genuinely fine: one owner, kept current, nothing else depending on them minute to minute. Forcing a system onto those would have added work without fixing anything.

The result: one source of truth where it mattered

Orders and inventory now reflect the same reality instead of two documents slowly pulling apart. I didn't overhaul the business to get there. I had to identify the one workflow that was actually broken and fix it first. Once that was working, the next one was an easier call.

My advice to any owner in the same spot: don't start by assuming you need to digitize everything. Start by finding the place where two numbers that should agree, don't. That's usually where the cost is hiding.

Where that gap turns up depends on the business. For some it's stock counts that are stale by lunch. For others it's a schedule that collapses after one breakdown, inspection records nobody can find, or temperature logs with hours-long gaps. If you run a staffing firm, this is the same question from that side.

Still not sure you've outgrown spreadsheets at all? Run through the five signs that told one owner it was time.