The spreadsheet says 12 in stock.
The shelf says otherwise. Again.
A spreadsheet is a snapshot someone typed at some point. Stock changes every time an order ships or a supplier delivers. A static sheet always falls behind a number that keeps moving, and that gap is not a one-off mistake.
Why the sheet is always a little bit wrong
A spreadsheet records whatever someone typed in, at the moment they typed it. Real stock changes all the time: an order ships, a return comes back, a supplier delivers, a sale happens on a marketplace the spreadsheet does not even see. The sheet is not wrong because someone made a mistake. It is wrong because it is a photo of a number that keeps moving.
This gets worse as a business grows. More orders means more moments where the real number changes. More sales channels means more places stock moves without the sheet knowing. More than one person editing the same file means two honest updates can overwrite each other, and nobody notices until a customer orders something that is not there.
The multi-channel trap
Selling the same product on a website, a marketplace and in person, with one shared spreadsheet trying to represent all three, almost guarantees the exact symptom above. An order confirmed for stock that already sold somewhere else. This is not a sign anyone is bad at their job. It is what happens when three places can reduce a number, and one slow, manual process is supposed to keep it accurate everywhere.
What actually fixes it
A better spreadsheet does not fix it, and neither does a stricter process for updating it by hand. The core problem stays: several sources changing one number without talking to each other. The real fix is one system every channel reads from and writes to directly. A sale on the website reduces the count immediately. A sale on a marketplace does the same. A person can still make a manual adjustment for a damaged item, a miscount, or a return that needs a judgment call. That adjustment happens in one place, and every other channel sees it instantly.
Whether this is actually worth fixing yet
For a very small, single-channel operation, a carefully maintained spreadsheet with clear rules can genuinely hold up for a while. Replacing it before it is actually failing is not worth the cost. The moment a second channel, a second person, or real order volume enters the picture, the math usually flips. The cost of wrong stock counts, refunds and apologies adds up faster than the cost of fixing the system underneath it.
What to do in the next hour
- 01
Check how many places stock actually gets updated from right now: the site, a marketplace, in-person sales.
- 02
Count how many people edit the same stock sheet, and whether two of them ever update it at the same time.
- 03
Pick five products and physically count them against what the sheet currently says.
- 04
Do not add a second spreadsheet to check the first one. That doubles the work without closing the actual gap.
When to call us
Call us if stock errors are costing real refunds or canceled orders. Also call if you sell on more than one channel, or the business has outgrown one person updating one sheet. Get a free plan →
FAQ
Do we need a full inventory system, or can this be fixed in Excel?
It depends on how many channels and people touch stock. One person, one channel, low volume: a well-built sheet with clear rules can genuinely work. More than one channel or person, or growing order volume: a spreadsheet cannot keep up, however carefully it is built, because nothing stops two updates happening at once.
What actually replaces the spreadsheet?
A single source of stock truth that every sales channel reads from and writes to automatically. Your store, marketplaces, and usually a simple internal tool for manual adjustments, so people still make corrections, just in one place.
Will this require retraining the whole team?
Usually less than expected. The team keeps selling and fulfilling the same way. The system removes the manual step of updating numbers by hand across several places, which people normally find tedious anyway.
What if we are not ready for a full system yet?
An audit first tells you honestly where the process actually breaks and what a fix would cost, with no obligation to build anything beyond that.