Spreadsheets and QuickBooks are good tools, and most businesses rightly start with them. The trouble arrives gradually. These are tests you can run in a week, each with a clear result.
- Ask three people for the on-hand quantity of one busy SKU. If the answers differ, stock is tracked in more than one place.
- Count the manual journal entries at your last month-end close. A long list usually means data was re-keyed between systems.
- Find the one spreadsheet everything depends on. If only one person understands its formulas, the business has a single point of failure.
- Look at a lookup formula that broke after someone inserted a column. If that has happened, silent errors are possible.
- Try to open the shared file while a colleague has it locked. If people wait, or make copies, you now have several versions.
- Trace a customer's price from quote to invoice. If it is retyped along the way, mismatches are likely.
- Find an approval that happened by email last month. Can you show who approved it, when, and against what limit?
- Time how long a new hire takes to learn the workarounds. Weeks of that is a hidden training cost.
- Ask what happens when you win a new type of customer or product. If the answer is a new tab and more hours, growth is adding work faster than revenue.
- Check which costing method and location tracking your QuickBooks edition supports. These differ by edition, and many operations need more than the plan you are on.
How to read the results
One or two failures are normal. Several in the same area, such as stock or pricing, show where the tools are limiting the business. That does not automatically mean custom software. A packaged system or one targeted fix may be enough.
Three cheap fixes that often come first
- Order entry from email: intake, matching and review before posting, so orders are not retyped.
- Handheld counts: scan locations and items, and reconcile differences the same day.
- Approval routing: limits, delegation and a log, in place of email chains.