The seven mistakes
- Multiple files: one for purchases, one for sales, one for stock, never reconciled.
- Manual stock edits: someone types the new quantity without a document.
- Broken formulas: a row is inserted and the SUM range misses it.
- No returns record: returned goods are put back on the shelf but not in the file.
- Weak form printing: the invoice is a separate Word document typed again.
- No backup: the file lives on one PC and is overwritten by a newer version.
- Hidden version conflicts: two people edit copies and email them back and forth.
What each mistake costs
| Mistake | Typical cost |
|---|---|
| Multiple files | Hours of month-end reconciliation |
| Manual stock edits | Unexplained shrinkage and stockouts |
| Broken formulas | Wrong reorder decisions |
| No returns record | Stock overstated, receivables wrong |
| Weak printing | Double entry and customer delays |
| No backup | Loss of years of history |
| Version conflicts | Duplicate orders and pricing errors |
Cheap fixes before changing software
- Use one workbook with controlled sheets and a change log.
- Protect formula cells and allow input only in designated columns.
- Record returns as negative rows with a reference.
- Keep a daily copy with the date in the filename.
- Assign one owner for the file and a backup owner.
These fixes reduce risk but still depend on human discipline. When volume grows, a document-driven system removes the opportunity for many of these errors.
When to stop fixing Excel
Move to dedicated software when more than one person edits stock, when you print forms regularly, or when month-end takes more than a day. Import products, count opening stock and run one category in parallel before switching the rest.
Frequently asked questions
Is Excel ever the right choice?
Yes for planning, quotations and analysis, or a very small catalogue managed by one person. It is weaker as a multi-user transaction system.
What is the most dangerous mistake?
Manual stock edits without documents. Once stock can be typed over, no difference can be explained.
How do we migrate cleanly?
Clean product names and units, import, count opening stock physically, and run a parallel category before cut-over.
Can we keep Excel for reports?
Yes. Export from the inventory system to Excel for analysis while keeping transactions in the system.