The seven mistakes

  1. Multiple files: one for purchases, one for sales, one for stock, never reconciled.
  2. Manual stock edits: someone types the new quantity without a document.
  3. Broken formulas: a row is inserted and the SUM range misses it.
  4. No returns record: returned goods are put back on the shelf but not in the file.
  5. Weak form printing: the invoice is a separate Word document typed again.
  6. No backup: the file lives on one PC and is overwritten by a newer version.
  7. Hidden version conflicts: two people edit copies and email them back and forth.

What each mistake costs

MistakeTypical cost
Multiple filesHours of month-end reconciliation
Manual stock editsUnexplained shrinkage and stockouts
Broken formulasWrong reorder decisions
No returns recordStock overstated, receivables wrong
Weak printingDouble entry and customer delays
No backupLoss of years of history
Version conflictsDuplicate 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.

QB
小企业简单进销存软件 editorial teamA content team focused on invoicing, inventory and stock control for small businesses. We test and review common business software.