Most independent grocery and convenience stores keep their “real” inventory in an Excel file nobody else dares to touch. That’s not a flaw — it’s a starting point. Here’s how to structure that file so it actually works for you (stock value, margins, reorder alerts), the counting method that keeps it reliable, and three signs it’s time to move on.
300 products, no email, no sign-up. Stock value, per-product margin and “to order” alerts calculated automatically. The template is in French.
Stock value at cost (cost × quantity), per-product margin ((selling price − cost) ÷ selling price) and a reorder alert when stock drops below your threshold — highlighted automatically.
One product per row, one master file. That’s the rule.
UPC code, description, department, main supplier, cost, selling price, quantity, reorder point. No merged cells, no tab per month, no “inventory-final-v2” copies: one single file, which the template structures for you in advance.
Instead of the big annual count that ties up everyone, count a different section each week — dairy, bakery, frozen… The full round happens on a rolling basis, stock stays reliable all year, and discrepancies (shrink, receiving errors) show up in weeks, not months.
The “margin” column is only as good as the “cost” column. If supplier price lists aren’t carried over into the file, your displayed margin is fiction. It’s the weak link of every Excel inventory — and the reason supplier price updates are the first thing to automate, even before inventory.
More than one person needs to touch it. As soon as the file is shared, versions drift apart and “the real number” becomes a matter of opinion again. Costs change faster than the file. Every supplier list that isn’t carried over skews the margin on dozens of products. The file doesn’t talk to the point-of-sale system. Sales don’t deduct anything: everything that leaves the store has to be recounted by hand.
At that point, the answer isn’t a bigger Excel file — nor necessarily a new POS system. An in-between system can read your sales and your supplier lists and keep inventory up to date in what you already have. That’s the approach from the grocery store case ($56,000/year recovered), applied to stock instead of prices.
Tell me how your inventory is kept today — I’ll tell you what to connect first, what it costs and what it pays back. Free, no obligation, and no pitch for a new POS system.