Excel is not the enemy. Plenty of businesses run well for years on a handful of spreadsheets, and that is entirely sensible — it is cheap, everyone knows it, and it bends to anything. The trouble only starts when the business crosses a threshold the spreadsheet does not.
Six signs you have crossed it
- 1There is more than one "latest" version. A file called `stock_final_v3_edited.xlsx` sits on three machines and nobody is sure which is right.
- 2You have to lock the file so someone else can type. Two people needing it at once start queueing, or worse, each keeps a copy and merges by hand.
- 3Nobody knows who changed that number. A cell gets edited, leaves no trace, and the argument has no evidence.
- 4Month end takes days to report. Because it means gathering five or six files, pasting them together and hunting discrepancies.
- 5The file disagrees with a physical count. Stock drift is the clearest sign: a spreadsheet cannot enforce that issuing goods deducts them.
- 6Permissions are impossible. You want sales staff to see stock levels but not cost prices. Excel cannot do that in any genuinely safe way.
One sign is fine. From three onwards, the hidden cost already exceeds the price of software.
How to price what Excel is costing you
The real cost of spreadsheet management sits in four places, and all four convert to money:
| Item | How to measure | Example: a 25-person business |
|---|---|---|
| Hours re-typing data | Hours/week × hourly pay | 8 hrs/week × 60,000đ ≈ 2M đ/month |
| Hours on period-end reports | Days/month × daily pay | 2 days/month ≈ 1.5M đ/month |
| Errors that need fixing | Incidents × cost each | 3 × 800,000đ ≈ 2.4M đ/month |
| Lost sales from wrong stock | Orders lost × gross margin each | 4 × 500,000đ = 2M đ/month |
That totals around eight million dong a month for a mid-sized business — more than the subscription of most management software on the market. Your numbers will differ, but work them out before deciding.
Dropping it does not mean dropping all of it
Moving to software does not mean deleting Excel from the company. Spreadsheets remain the best tool for three things: one-off calculations you then throw away, sketching models, and exporting data to play with. What has to go is using it as the system of record for operational data.
Migrating without losing your history
- 1Fix a cut-off date: everything before it is history, everything after goes into the new system.
- 2Clean the catalogue before loading: merge duplicate product names, standardise units, drop dead rows. This takes the most time and should not be skipped.
- 3Load opening balances: stock from a real count, receivables from a reconciliation with each customer.
- 4Run in parallel for 2–4 weeks: both sides record, reconcile weekly. Only switch Excel off once they agree consistently.
Step three is where corners get cut. Loading stock from the old file — which was already wrong — means the new system is wrong from day one, and users lose faith before they have learned it.
If your process really is unusual
Many businesses hesitate because the current spreadsheet fits their way of working exactly: tiered commission formulas, price lists by dealer level, cost allocation per construction site. That is a legitimate reason to consider custom software over a packaged product — but only for that unusual part. Stock and cash should still use the standard.
Want to talk specifics?
SealCore surveys at your premises and sends a fixed quote after the first session — including when the conclusion is that you do not need custom software.
