Guide
How to stop using Excel for stock
A spreadsheet is the first stock system of almost every company, and for a while it works well. The trouble comes later, gradually, as the sheet grows and more people touch it. This guide explains how to tell whether you have got there and how to switch without stopping work, and also when it is better to leave things as they are.
First of all: when Excel is still fine
If you have few items, one person updates the sheet and no other system needs to read the stock, Excel does its job. Switching in that case would cost you effort for no real benefit. The rest of this guide is for when the signs below start turning up regularly.
The signs a spreadsheet is no longer enough
Any one of these happens to everybody now and then. If you recognise two or three of them and they come back every week, the sheet has reached its limit.
- There are several copies of the file and nobody knows which is the right one.
- Only one person can update the sheet, and when they are on holiday stock stands still.
- The online shop sells goods that are no longer on the shelves.
- The physical count never matches the sheet, and nobody knows why.
- Nobody knows who changed a figure, or when.
- Working out what to order from the supplier takes half a day of filters.
1. Import the sheet as it is
You do not have to rework the file to fit a template first. Item and stock tables go in as they are, with their own column names, and duplicates are cleaned up afterwards in the system, where they are much easier to spot.
2. Run both in parallel for a few weeks
For a short while, record every movement in both places, the sheet and the system, and compare the stock at the end of each week. Once the figures match for two or three weeks running, you can archive the sheet.
3. Do the count and start from it
On the day the sheet is archived, count the goods and load the real quantities into the system. From then on stock changes only through recorded movements (goods in, sales, returns) and nobody adjusts it by hand any more.
4. Give everyone their role
Whoever receives the goods records what comes in and whoever sells records what goes out, while the person placing orders sees what is missing. Each of them has what they need in front of them, and every change stays in the audit log, so you can always find out who altered a figure.
What you gain
The real benefit is how much less time you spend checking numbers.
- One stock figure, which everyone sees up to date.
- The online shop reads the same stock as the warehouse.
- Minimum stock that tells you by itself what to order.
- Questions in plain language: which items are below minimum stock.
- The data stays yours and you can export it to a table whenever you want, so going back to a spreadsheet is always an option.
How we do it
You explain how your warehouse runs today, upload the spreadsheet and the platform builds the system around it. If you prefer, we do the data migration for you: see Services. For what you get, see Inventory management and Stock and sales; for a shop, the guide How to keep track of shop stock.
- You work with prepaid credits, with no subscription and nothing to pay per user. See Pricing.
Frequently asked questions
Do we have to tidy our spreadsheet before importing it?
No. The sheet is imported as it is, with its own columns. Duplicates and different names for the same item are sorted out afterwards.
How long does the move take?
The first version of the system takes a few days. The parallel period goes on until the two stock figures have matched for a few weeks in a row.
Can we go back to a spreadsheet if it does not suit us?
Yes. Items, stock and movements can be exported to a table whenever you want, so the decision can always be reversed.
Upload your sheet and describe your warehouse
Sign up for free, no card involved. Upload the sheet, explain how you work today and judge the system before you spend anything.