Most small businesses run on a spreadsheet long after they meant to. Orders, stock, quality checks, invoices: one Google Sheet, a few tabs, and a person who knows which column not to touch.
That's not a mistake. A spreadsheet is free, everyone can open it, and it'll bend to whatever you need this week. The question is when it stops being the cheap option.
In a three-week slice of Upwork job posts we read this autumn, the same request kept coming back in different words. One business wanted a simple menu on top of their Google Sheet so staff would stop copying product codes by hand. Another wanted an order tracker with quality control. Four separate posts asked for the same thing: take invoices from PDFs and get them into QuickBooks without retyping. None of these people asked for an app. They asked for the spreadsheet to stop eating their week.
Signs the spreadsheet is costing you money
You don't need all of these. Two or three usually mean it's time to price the alternative.
- The same data gets typed twice. From the sheet into the invoicing tool, from an email into the sheet, from one tab into another. Every copy is a chance for a typo, and somebody is paid to make it.
- One person is the system. They built the formulas, they know why row 400 is yellow, and when they're on holiday nobody dares to change anything.
- Everyone sees everything. A contractor who needs one column can read the whole sheet, prices and margins included, because sharing works on the file, not on the row.
- Nobody knows who changed what. The version history exists, but finding out why a number moved last Tuesday takes an afternoon.
- It's used on a phone in a warehouse or on a site. Tiny cells, accidental edits, a formula overwritten by a thumb.
- Things that should happen automatically don't. A customer waits for a status update that someone has to remember to send.
When to keep the spreadsheet
If a handful of people use it, the data changes a few times a day, and nothing above sounds familiar, keep it. Spend the money on sales.
There are also cheaper steps before custom code. Protect the ranges people shouldn't edit. Put a Google Form in front of the sheet so data comes in one way. A no-code tool like Airtable or AppSheet can cover a lot, and it's the right choice while you're still working out how the process should run. We said the same about picking the tool for the stage you're in when building a product.
Custom code starts to pay off when the process has settled, the workarounds take more time than the work, and the monthly cost or the limits of the no-code tool begin to pinch.
What a first internal tool includes
An internal tool is a small web app that only your team uses. It doesn't need a marketing site, payments or a polished design. It just has to hold your data properly and let the right people do the right things with it, and that's a much smaller job.
- The core. Your data laid out properly (orders, products, customers, whatever the tabs hold today), screens to add, find and update records, the import of what's in the sheet now, and an export back to a spreadsheet for the day someone wants one.
- Accounts and roles. Everyone logs in as themselves, and each role sees only what it needs: staff their part of the work, a manager the totals.
- An admin panel. Where you add people, change lists like product types or statuses, and fix a record without asking a developer.
It'll run in a browser on a laptop or a phone, so there's nothing to install.
What it costs
These are the hours behind our estimate calculator, at our rate of $40 an hour. The calculator shows a range of 15% either way, because estimates are estimates.
| What you get | Hours | Range |
|---|---|---|
| Core internal tool only | 70 | $2,400 to $3,200 |
| Core plus accounts and roles | 105 | $3,600 to $4,800 |
| Core, accounts and an admin panel | 155 | $5,300 to $7,100 |
| The same plus email notifications | 170 | $5,800 to $7,800 |
| The same plus search and filters | 205 | $7,000 to $9,400 |
The third row is what the calculator suggests by default once you pick "Internal tool" in it. Add search and filters once there are thousands of records and scrolling stops working.
