It was 9:15 on a Thursday night and the owner of a home goods company was still sitting at her kitchen table. She was eight days into closing the books for October, a job that should take a day, three at most. Four years earlier she built an inventory spreadsheet during her first month in business and it worked great. That same file now had twelve tabs, three people editing it, and a formula on the COGS tab nobody could explain. On Tuesday someone saved over another person’s changes and there was no version history to go back to. The inventory value she was about to report didn’t match what was sitting on her shelves.

Her sales manager kept commissions in a separate spreadsheet. Her warehouse lead collected paper timesheets every Friday and someone in accounting typed them in by hand. Each department had found its own way to get by. Put together, they had built something that looked like a system but didn’t work like one.

Her business had grown and the way she managed her data hadn’t grown with it.

Spreadsheets aren’t the problem, outgrowing them is

A spreadsheet is a great tool when you’re starting out. One person owns it, the data is simple, and mistakes are easy to catch. Most businesses start there and they should. The trouble starts when the business grows and the spreadsheet stays the same.

Let me be clear, I’m not anti-spreadsheet. I’ve been doing this work for 20 years and I still open one almost every day. Your business will always use them for quick analysis, one-off projects, and testing an idea before you commit to it. What they shouldn’t be is the foundation your whole business is built on, because a file someone can overwrite on a Tuesday was never meant to carry that much weight.

You can usually tell when you’ve hit that point. The same information is being entered in more than one place. Several people are working in the same file, and closing the month takes longer every time. Decisions wait on whoever owns the spreadsheet, and your numbers always describe last month instead of today. If any of those sound familiar, your team is spending more time maintaining the data than using it. The good news is that these are growth problems. You only run into them because the business is working.

Start with what you already own

Before shopping for anything new, the owner looked at the tools she was already paying for. Her online store ran on Shopify, which tracked every SKU she sold. With an integration connecting Shopify to QuickBooks, the cost of goods sold from each day’s sales could flow right into her books, giving her a real-time inventory value instead of a guess at the end of the month. Her sales platform even had a commission feature she had never turned on.

I see this all the time. Businesses already own most of what they need and just haven’t set it up. Starting with your current tools saves money and shows you what you’re actually missing.

Let your industry shape your shortlist

That still left timekeeping and a warehouse getting more complex every quarter. This is where she had to get specific, because the best system on paper isn’t the best system for every business.

A product business needs real-time inventory and COGS. A service firm needs time tracking tied to billing. A construction company needs job costing to see whether a project is profitable while the work is still underway. Start with how your industry makes money and the list narrows quickly, and you avoid paying for features built for someone else’s business.

Timekeeping turned out to be the easier fix. She moved the warehouse team to a time-tracking app that fed straight into payroll, and the Friday stack of paper turned into a report someone just had to approve. The warehouse was the bigger decision, and that’s where the demos came in.

Watch how the vendor shows up

The demos taught her the biggest lesson. One vendor said every requirement on her list was covered, then spent the whole meeting on a canned presentation that never touched her inventory. She asked who would handle moving her data over and the salesperson said implementation would take care of it. On a follow-up call she asked the implementation lead the same question and got a completely different answer.

How a vendor communicates during the sale is how they will communicate after you sign, or worse. Pay attention when their words don’t line up with their actions, like a promised follow-up that shows up a week late or a feature that’s “absolutely included” but never makes it onto the screen. Notice whether they’re asking about your business or just telling you about theirs. If you walk out feeling unheard, that won’t get better once there’s a contract.

A good partner will tell you how they plan to approach your implementation, what they’re responsible for, what your team is responsible for, and when each piece will happen. If those answers are vague before you sign, they’ll stay vague after.

Clarity comes before software

The owner did get off her spreadsheets and onto a setup that fits how her business runs. Looking back, the software was the easy part. The hard part was knowing what problem she was solving, what tools she already had, and what she needed from a partner before she ever sat through a demo.

Most businesses start shopping for a system when the pain gets loud enough. The ones that do it well start by figuring out where their processes, data, and tools stopped working together. That’s exactly what our Alignment Diagnostic is built to uncover, so when you sit down with a vendor, you’ll know what you need and whether they’re the right fit.

If you opened every spreadsheet your team uses today, how many would be doing a job your systems should already be handling?