Vendors want you to believe the spreadsheet is a trap and you’re losing money every day you don’t buy their software. Mostly nonsense. Excel handles a single shop with a few hundred SKUs better than most paid tools — it’s fast, free, and your staff already know it.
But it does break. The trick is knowing which failure is happening to you right now, because each one has a different fix at a different price.
The five signs you’ve outgrown it
- Stock counts disagree with reality. Your sheet says 24 units of Indomie Goreng; the shelf has 19; the stocktake says 22. When the gap becomes routine instead of a surprise, you’ve lost trust in your own numbers — and you start ordering blind.
- Two (or six) people edit the same file. Someone opens it on their phone to record a sale while the cashier updates the same row. Last-write-wins means whichever save lands last silently erases the other. Days later the count is wrong and nobody knows who did it.
- Your “real-time” view is a WhatsApp message. The owner asks “how many X left?” and a staff member walks to the shelf, counts, and replies. That’s not real-time, and it breaks the moment staff are busy.
- The loyalty program. You promise “10 free items after 10 purchases,” printed on a paper card the cashier eyeballs. Excel can’t track this without manual lookup per customer, and nobody wants to type a phone number into a cell at the counter.
- You’re rebuilding formulas weekly. Someone breaks a SUMIF, a row sorts wrong, and you debug spreadsheets instead of running the business. If you spend more time fixing the sheet than looking at it, that’s the real cost — and it’s invisible on your P&L.
What you actually gain at each stage
- Stage 1 (a few hundred SKUs, one person running the sheet): keep Excel. Seriously. Add data validation and a simple
SUMIFlow-stock column, and you’re fine for zero rupiah. - Stage 2 (multiple staff, daily sales + purchases): move to free-tier inventory software. You gain shared access, a central database instead of one fragile file, and automatic math. What you give up: you now depend on a vendor’s free plan, which usually limits users or SKUs.
- Stage 3 (multiple locations, stocktake pain, loyalty): pay. $20–60/month buys barcode scanning, per-location counts, expiry alerts, and loyalty with zero manual lookup. If you run a warung chain or a shop that does stocktakes monthly, this tier pays for itself in one avoided over-order.
The comparison, in numbers
| Excel | Free tier | Paid ($20–60/mo) | |
|---|---|---|---|
| Cost | Rp0 (you probably own it) | Rp0 | ~Rp360k–1.1M/mo |
| Multiple editors | Conflicts, lost saves | OK, but user/SKU caps | Full concurrency |
| Real-time stock view | No | Yes, usually delayed | Yes, live |
| Barcode / stocktake | Manual | Basic or none | Fast, built-in |
| Loyalty program | Manual lookup | Rarely | Yes |
| Offline use | Yes | Often limited | Varies — check before buying |
| Who should use it | Solo-run shops, <500 SKUs | Small teams, tight budget | 2+ locations, stocktakes, loyalty |
At today’s rate, $20 is roughly Rp360k and $60 is about Rp1.1 million per month. An Indonesian single shop paying Rp1M/month for inventory software is overpaying unless it’s running multiple locations.
Three questions to decide
- Do I trust my stock numbers right now? If you’d bet real money on today’s Excel count, keep the spreadsheet.
- Who touches the data? One person = Excel. More than one person editing daily = software, because the file conflict problem can’t be fixed with more discipline.
- What am I paying for, exactly? If it’s just “organization,” Excel already does that. Pay only for the thing you can name — barcode stocktake, loyalty, or multi-location sync.
The honest bottom line: Excel is fine longer than the vendors claim, and loyalty programs are the most common reason shops upgrade too early. When the sheet stops being the source of truth — when you trust the shelf more than the file — that’s the exact moment to pay. Not before.