Stock control in Excel: where the spreadsheet breaks, and what to do

A spreadsheet is a fine start

Most shops begin with a sheet: one row per product, a quantity column, maybe a price. It is free, everyone already knows how to use it, and it bends to any business. If you run a one-person shop whose stock changes a few times a week, a spreadsheet may be all you ever need, and nothing on this page should talk you out of it.

Where it breaks

One file, many hands. The moment a second person edits the sheet, you have versions. The copy on the shop laptop says 14, the copy on the phone says 12, and the one in the email from Tuesday says 15. Shared online sheets fix the versions but not the next problem.

No history. A cell that is overwritten is gone. Nobody can tell whether 12 became 9 because three were sold, because one was broken and two were sold, or because someone typed it by mistake. When a number looks wrong, the sheet cannot say who changed it or when.

No shelf access. Editing a spreadsheet on a phone in a storeroom is misery: the wrong cell, the keyboard over the row, no barcode. So changes get written on paper and typed in later, or not at all. The sheet is only as current as the last evening someone sat down with it.

Formulas rot. The reorder column that worked in January breaks when someone inserts a row in March. No one notices until an order is missed.

Signs it is time to move

• More than one person touches the stock.
• You have asked "who changed this?" and got no answer.
• There are more than a hundred products, or products with barcodes.
• A count takes an evening and the sheet is still wrong a week later.
• You want an alert before something runs out, not after.

How to switch without losing anything

Do not retype. A good app imports the sheet you already have: you pick the file, confirm which column is the name, the quantity, the price, the barcode, and every row arrives with its opening stock. Keep the spreadsheet as a backup for a month, run both for a week to make sure the quantities agree, and then stop updating the sheet.

The one thing to insist on before you switch is the way back. An app should export your whole stock to an Excel file at any time, so you are never locked in and your accountant gets what they ask for.

What to look for in the app

• Import from Excel or CSV, and export back to Excel any time.
• A history entry for every change: who, when, how many, and why.
• Works on the phone in the storeroom, offline if needed, and on a computer at the desk.
• Barcode scanning with the camera, so a stock change is two taps.
• A stock count that keeps a record, not just an edit of the quantity column.

Doing it in Invenva

Invenva imports .xlsx and CSV files, matches columns to your fields, skips duplicates, and books every row with an opening movement so the history starts on day one. With Update existing items switched on, the same file updates the products you already have instead, in the web app now and in the iPhone and Android apps from their next update. Every later change is a movement with a person and a time. Importing a whole file and exporting to Excel and PDF come with the paid plans, and the exports carry your business name, not ours. If you want to see how a sheet feels once it has become a stock list, the live demo opens a sample inventory without an account.