Email me

How do I know my business has outgrown its spreadsheets?

You’ve outgrown them when the business can’t run without one file and the one person who understands it. It usually shows up as a missed update that cost money, or work that stops when that person is out. Spreadsheets are still good for analysis, and I leave those alone. The day-to-day work moves into software, one piece at a time.

What are the signs we’ve outgrown Excel?

The clearest sign is that people ask which version is current. Others I see often: a formula broke and nobody noticed for a month, work stops when the person who built the file is on vacation, and new hires need weeks before they can be trusted in it.

Errors are more common than most owners assume. The researcher Raymond Panko gathered studies that inspected working spreadsheets and reported that they “found errors in 94% of the spreadsheets studied.” Those studies weren’t about small businesses in particular. I’d expect a file that has grown for years in a small office to be no different.

You can test yours by asking what you’d lose if the file were deleted tonight. If the answer is a day of rework, leave it alone. If the answer is your customer list, your open jobs or your deadlines, that file has become the company’s records. It was never designed for that. It has no reliable backup and no record of who changed what.

Should we buy software or have it built?

Buy software for anything every business does the same way, and have the rest built. Accounting, payroll and email have been worked on for decades, and a subscription costs far less than building your own.

The work that’s particular to you is different, such as how you price a job or how you decide what to do next. Off-the-shelf products are designed around a typical customer, and when your process differs you end up bending it to fit the product. That’s usually how the spreadsheet got started.

Having that piece built costs less than it did a few years ago. I use AI to write much of the code, so one engineer can now do what used to take a small team. For most of the 20 years I’ve built software, that kind of work was out of reach for a small business.

So the usual answer is both, connected so data is entered once. I go through how to weigh an industry package against your own software on a separate page.

Can the person who built the spreadsheet build what replaces it?

They shouldn’t have to, and it’s a lot to ask of them. The person who built the file is usually the one who knows the business best. Every rule the company follows is somewhere in those tabs, and most of those rules are written down nowhere else. That knowledge is the most valuable thing in the project.

Two things get in the way of them doing the rebuild. They already have a full-time job, and the spreadsheet got built in the gaps around it. Software the whole company depends on needs someone whose job it is. The file is also arranged the way its builder thinks, which is how the company came to depend on one person.

What replaces it has to be arranged around who does what and when. That takes someone from outside, watching the work change hands between people. So I sit with the builder first and have them walk me through every tab. They stay the authority on the rules while I write the software and keep it running.

How do you replace one without breaking the business?

I replace it in pieces, and the spreadsheet keeps working the whole time. I do it at your office in Parker County or west Fort Worth.

I begin by copying the data into a proper database and checking that nothing was lost or changed on the way. Then I build a screen for whichever task causes the most trouble today, and the team starts using it as soon as it works. They’ll find things wrong with it in the first week. That’s useful, because changes are cheap at that stage.

Then I move to the next task. For a while people compare the new screens with the spreadsheet, and I encourage that. Once they stop checking, I know that part can be retired from the spreadsheet.

This takes longer on the calendar than a single big launch, but the first piece is in use early and there’s no day when everything changes at once. If you decide to stop partway, you keep what’s been built and the spreadsheet still covers the rest.

What does this look like in a commercial development company?

In a commercial developer’s office, the spreadsheet is usually the project itself. Each building starts as a pro forma workbook holding the land, the hard and soft costs, the loan and the rents that have to pay it back. Once the loan closes, the budget tab becomes the draw schedule.

Every month someone assembles a draw request for the lender from that workbook, with the contractor’s pay application, the invoices and the lien waivers behind it. The lender often groups costs differently than the developer’s budget does, so the same numbers get rearranged by hand. A change order has to be carried into the budget, the next draw and the report that goes to investors. When one is missed, the lender finds the mismatch and the draw waits.

Usually one person holds all of this, in a separate workbook for each project. I’d leave the pro forma in Excel, since that’s analysis. I’d start with the budget and the monthly draw, so a cost is entered once and the lender’s package and the investor report both come from it.

NEXT STEP

I have room for three more companies.

$2,000 to $6,000 a month, month to month. It starts with an hour at your office, at no charge. Show me how the work gets done, and I’ll tell you what I’d do next.

Email me to pick a day. gw@garrettwinder.com

CALL ME WHEN