Inventory management in Excel

Most warehouses start in Excel, and for a while that is the right call. A spreadsheet is free, everyone can read one, and for a single person managing a few hundred items it does the job. The problems do not appear gradually; they appear the moment a second person touches the stock, or the moment stock sits in more than one place. Knowing which of those points you have reached is more useful than a general argument about software.

Where Excel genuinely works

Excel is fine when one person maintains the file, the stock lives in one place, and nobody needs to know the figure while away from a desk. Under those conditions a spreadsheet is faster to change than any application, costs nothing, and can be reshaped for whatever question comes up. If that describes your situation, there is no reason to switch, and the rest of this page is not urgent.

The four points where it breaks

A second person starts booking

A spreadsheet has one copy and one editor at a time. When two colleagues work on the same file, one of them overwrites the other, and neither notices until a figure looks wrong days later. Shared cloud versions reduce the collision but not the underlying problem: there is no record of who changed what, so a wrong number cannot be traced back to a cause.

Stock sits in more than one place

A spreadsheet holds a quantity per product. As soon as the same product sits on two racks, that quantity stops answering the question a picker actually has, which is where. People start adding location columns, then a second sheet per location, and the file drifts out of sync with itself because nothing forces the two views to agree.

The figure is needed on the floor

Registration that happens at a desk always happens later than the movement it describes. Notes are collected during the day and typed in afterwards, so the file is wrong for most of the working hours, which is exactly when people rely on it. That gap is what causes goods to be promised to a customer after they have already left the building.

Nobody can reconstruct what happened

When a count comes up short, a spreadsheet gives you a number and nothing else. There is no history of receipts, shipments and relocations to work back through, so the difference gets written off and the underlying cause repeats. This is the point at which most businesses stop trusting their own figures, which is more expensive than the discrepancy itself.

What the gap actually costs

The cost of an inaccurate stock figure is rarely the stock. It is the picker who walks to an empty shelf and then walks the warehouse looking, the order that ships a day late because a shortage was discovered during picking, the purchase of something that was already in the building, and the annual stocktake that closes the operation for a day. None of these appear as a line in your accounts, which is why the problem tends to be tolerated long past the point where fixing it pays for itself.

Moving without a migration project

The switch does not require exporting your spreadsheet or preparing a product list. Create your storage locations first, individually or as a series such as A1 through A10. Then register what is physically on the shelves as inbound movements: the app creates each product the first time it sees a Product ID, so your product list builds itself as you walk the racks. From that point on, book every receipt, shipment and relocation as it happens. Most warehouses are productive within a day, because there is nothing to install and no data to convert first.

You can keep Excel

Moving your stock registration out of Excel does not mean giving up spreadsheets. The Premium plan exports your inventory and transaction history, so anything you built in Excel for analysis, reporting or reordering can keep running on exported data. What changes is where the registration happens: on the floor, at the moment of the movement, by whoever performed it.

Start now