Where Excel works well

For a new business with a few dozen products and one person maintaining the file, Excel is cheap and flexible. A product list, purchase log and customer balance can live in a few sheets, and formulas can answer simple questions.

The problem is not the tool but the responsibility it shifts to the user: formulas, permissions and backups are all manual. One deleted row or missed entry can make the whole file unreliable.

Five hard limits of Excel inventory

  • Stock is not real time: sales, purchases and returns sit in separate sheets; one missed row breaks the total.
  • Collaboration conflicts: files pass through chat apps and nobody knows which version is current.
  • Weak form printing: 2-part/3-part alignment is fragile, and a small paper change breaks the layout.
  • Manual reporting: a customer’s annual purchases or product margin needs a new pivot table.
  • Safety depends on discipline: accidental deletion, malware or a dead PC can erase years of records.

These problems are invisible at low volume. At dozens of invoices a day and hundreds of products, maintaining Excel costs more than the software it replaces.

Six signals it is time to switch

  1. More than one person edits the stock file.
  2. You cannot answer “how much stock do we have?” without checking several sheets.
  3. Month-end reconciliation takes more than a day.
  4. You print forms and regularly adjust alignment.
  5. You need customer statements or product margin reports.
  6. You have had at least one close call with a lost or overwritten file.

Three or more signals means the workaround cost is already significant.

A safe migration plan

  1. Export products, customers and opening balances from Excel into the import template.
  2. Clean duplicates and standardise units before importing.
  3. Enter opening stock from a physical count, not from the old sheet.
  4. Run one product category in parallel for a week.
  5. Compare stock and receivables between Excel and the new system daily.
  6. Freeze the Excel file read-only once the new system matches, and keep it as an archive.

Do not migrate in the middle of a stocktake or peak season. Choose a quiet week and back up both systems.

The practical verdict

Excel remains useful for planning, quotations and one-off analysis. It is not a reliable transaction system once multiple people, printed forms and customer credit are involved. The right move is not to abandon spreadsheets entirely, but to move the transactional core — invoices, stock movements and balances — into software that enforces a document trail, while continuing to use Excel for analysis through exports.