If your company still relies on Excel inventory management, you know the routine: someone asks how many units of an item are in stock, you open the spreadsheet, and the number doesn't match what's actually on the shelf. Or the file is "locked for editing by another user" right when you need to log an incoming delivery.
Excel is a great tool, and it's no surprise it became the first inventory spreadsheet for so many small businesses. The issue isn't Excel itself. It's using it as a business system once your stock grows and several people need to work on it. Below we look at the typical problems, how to contain them while you're still on Excel, and when it's time to move on.
Why Excel inventory management works at first
In the early days, an inventory spreadsheet has everything you need: a list of items, a stock-level column, a few formulas for goods in and goods out. It costs next to nothing, everyone knows how to use it, and you can adapt it in minutes.
As long as one person handles stock and movements are few, that balance holds. Trouble starts when items, transactions and, above all, the number of people editing the same file go up.
Common problems with inventory in Excel
1. Stock levels that don't add up
This is the most common symptom. Spreadsheet stock levels drift for very ordinary reasons:
- a delivery entered twice, or not at all;
- a formula overwritten by a manually typed number;
- a row deleted by mistake without anyone noticing;
- an active filter hiding items and skewing totals;
- movements jotted down "for now" on a separate sheet and never carried over.
Each mistake is small. Over time they add up to wrong purchase orders, stockouts, dead stock and stocktakes that take days of corrections.
2. Locked files and duplicate versions
When two colleagues need to update stock at the same time, a spreadsheet on a shared drive gets locked: one person works, the other waits or opens a read-only copy. The usual outcome is parallel copies: inventory_final.xlsx, inventory_final_NEW.xlsx, inventory_october_mark.xlsx.
At that point, "which file is the right one?" no longer has a clear answer. And inventory without a single, up-to-date version stops being a control tool.
3. No control over who changes what
In a shared spreadsheet, anyone who can open the file can usually change everything: stock levels, prices, item records, suppliers. There's no simple way to say "warehouse staff log movements but don't touch prices" or "sales can see availability but not edit it".
When a number changes, it's hard to tell who changed it and why. Without that traceability, every discrepancy turns into an investigation.
4. Fragile data and ad-hoc backups
The inventory file often sits on someone's laptop or a network drive. If it gets corrupted, overwritten with an old version or the computer fails, recovery depends on backups that may not exist or may be out of date. We covered this in more detail when discussing the risks of keeping client data in shared spreadsheets.
How to limit the damage while you stay on Excel
If switching isn't an option today, a few good habits cut down on errors:
- Separate item master data from transactions: one sheet for items, one where every goods-in and goods-out is a single row, and stock levels calculated by formulas, never typed in.
- Protect formula cells and leave only input columns editable.
- Use data validation (drop-down lists for item codes and movement types) to avoid typos.
- Assign one owner for updates, or set clear time slots for who can edit.
- Keep regular, dated backups stored somewhere other than the original file.
These help, but they all rely on people being disciplined. Once inventory is shared across departments, the file remains the weak link. If several of these situations sound familiar, check out the warning signs that you've outgrown Excel as your ERP.
From spreadsheet to online inventory app with Nitor
The next step doesn't have to be a complex, expensive inventory system you need to learn from scratch. Your spreadsheet often already holds the right logic: the columns, the movement types, the way your business thinks. What's missing is a solid foundation to run it on.
That's what Nitor does: it turns the Excel file you use to run your business into an online business app, hosted and maintained by Nitor. Here's how it addresses the problems above.
Real-time collaboration, no locked files
With Nitor, several people work on the same data at the same time. The warehouse team logs a delivery while purchasing checks availability and accounts reviews a supplier. No more "file in use", no more parallel copies.
One up-to-date version of your stock
Your data lives in the cloud, in one place. Everyone sees the same current version at the same moment. "Which file is the right one?" stops being a question, because there is only one.
Users and role-based permissions
You can set up users and permissions: who logs movements, who can edit item records and prices, who has read-only access. Everyone works on their own part, and sensitive data is protected from accidental changes.
Secure data with backups
Your app is hosted and maintained by Nitor, with backups of your data. No more worrying about a broken laptop or a file overwritten by mistake.
Room to grow
As your inventory process evolves, you can add extensions and new features without starting over or rebuilding your spreadsheet.
When it's time to switch
There's no exact threshold, but some signs are clear:
- more than one person updates inventory every day;
- recorded stock and physical stock often disagree;
- you waste time figuring out which version of the file is current;
- you need different access levels for different roles;
- a failure or error in the file would halt operations.
If two or three of these apply, staying on Excel is probably already costing you more than it seems. To weigh your options, read our guide to Excel alternatives for small businesses.
In short
Excel inventory management is a fine starting point, but it shows its limits as items, transactions and people multiply: wrong stock levels, locked files, duplicate versions and no control over who edits what.
Good habits reduce the risk, but the structural fix is to move the logic you've already built into an online business app, with one version of the data, simultaneous access, permissions and backups. With Nitor, you start from your own spreadsheet and keep the way you work today.