Spreadsheet or inventory software: when to switch
When a spreadsheet is enough to track inventory, the concrete signs it is time to move to software, and a checklist for choosing an inventory system.
6 min read
A spreadsheet can be enough for a small inventory if it stays accurate and manageable. Inventory software becomes worth testing when the work outgrows your current setup. Compare the actual processes, integrations and permissions available; a manually maintained file is not the same as a configured cloud spreadsheet.
What spreadsheets do well
Spreadsheets get a bad press, but for many small sellers they are the right tool for years.
- Almost free. You probably already have Excel, Google Sheets or LibreOffice.
- Completely flexible. Add a column when you need one; no vendor roadmap involved.
- Familiar. No training, no migration project.
- Your data stays yours, in a format anything can open.
- A good teacher. Tracking stock by hand forces you to learn your business: what sells, how long suppliers take, where margin leaks.
Where they fall short
This comparison concerns a manually maintained file without configured integrations. Excel and Google Sheets can support collaboration and version history; scripts and connectors can automate updates. Whether these are available and reliable depends on the setup. A version history is not the same as a structured ledger of receipts, sales and returns.
- Nothing updates itself. Every sale, return and delivery has to be typed in. Miss one and the number is wrong.
- Several people, several versions. Files emailed around, “stock_FINAL_v3.xlsx”, cells overwritten with no record of who or when.
- No movement history unless you build it. You can see 12 units left, but not why there were 20 yesterday.
- Fragile formulas. A row inserted in the wrong place breaks a SUM and nobody notices.
- No link to your sales channels. If you sell in a shop and online, someone copies numbers between them.
- Cost and margin per sale is hard work, especially when you buy the same item at different prices.
Side-by-side
| Spreadsheet | Inventory software | |
|---|---|---|
| Upfront cost | Close to zero | Subscription or licence |
| Setup | Immediate | Days to weeks (load items, configure) |
| Stock updates | Manual | Automatic with each sale and receipt |
| Multiple users | Cloud co-authoring available; emailed copies can diverge | Check roles, permissions and change log |
| Multiple channels | Manual copying | Synchronisation (depending on the product) |
| Movement history | Only if you build it | Built in |
| Flexibility | Unlimited | Limited to what the product offers |
Signals it is time to switch
If two or more of these sound familiar, it is worth evaluating software:
- You sell on more than one channel — a shop, your own web store, one or more marketplaces — and you have sold something online that was already gone from the shelf.
- More than one person updates stock, and you have lost changes or argued over which file is right.
- Counts regularly disagree with the records and you cannot explain why.
- Stockouts cost you sales, or you discover too late that cash is tied up in items that do not move.
- Reconciling takes real time. Four hours a week on the spreadsheet adds up to around 200 hours a year.
- You are not sure of your margin per sale, because purchase costs change and the sheet does not follow them.
- You have many variants (sizes, colours, bundles) and the sheet has grown into hundreds of rows nobody can review.
A quick calculation of the time cost
Say you or a colleague spend 4 hours a week maintaining the sheet and fixing discrepancies, and you value that time at €20 an hour. That is €80 a week, roughly €4,000 a year over 50 working weeks. If software halved that time, it would free up about €2,000 of time a year. Set that against the subscription and the setup effort. Plug in your own figures: the answer varies a lot from business to business.
To see what each product actually earns you before deciding, the free margin calculator can help with the numbers.
Before you switch: tidy up first
Software does not fix messy data; it imports it. Before migrating:
- Give every item and variant a single, consistent SKU.
- Do a full stocktake so you start from real quantities.
- Check the purchase cost of every item.
- Decide who will book deliveries and stock adjustments.
If you do not yet have a stock routine, start here: how to keep stock records in a small business.
Checklist for choosing inventory software
Ask for a trial or a demo and test each point with your own products, not the sample data.
| What to check | The concrete question |
|---|---|
| Multichannel sync | Does a web store sale reduce shop stock straight away? Which channels does it connect to today, not on the roadmap? |
| Purchases and receiving | Can I record purchase orders, part-deliveries and supplier issues? |
| Cost and margin per sale | Does it work out the cost of each sale and show margin per product and per order? |
| User roles | Can I give a staff member access without showing purchase costs or letting them delete items? Is every change logged? |
| Data export | Can I download all items, movements and sales in an open format (CSV, Excel) whenever I want? |
| EU hosting and GDPR | Where is the data stored? Do they offer a data processing agreement? |
| Variants | Does it handle sizes, colours and bundles without workarounds? |
| Total cost | What does the fee include? Are there charges per user, per channel or per order volume? |
Pay particular attention to export. If you ever want to change systems, you need to be able to take your history with you.
The bottom line
There is no single right answer. If you sell through one channel, work alone and the sheet takes little time, keep it and sharpen your stock routine. If you sell on several channels, share the work with others or keep chasing the same discrepancies, test whether the candidate software reduces your actual workload and discrepancies.