Inventory & Stock Control Manager — Excel Stock Tracker with Reorder Alerts

Know exactly what's on your shelves — and what to reorder — without counting every day.

The Inventory & Stock Control Manager is a downloadable Microsoft Excel workbook for small retailers, online sellers and anyone who keeps stock. Record what comes in and goes out, and the workbook keeps every count up to date.

What it does

• Live stock levels: current quantity for up to 300 products, updated from a simple in/out diary (2,000 lines).
• Reorder alerts: items at or below your reorder level are highlighted and listed automatically, with supplier, suggested quantity and estimated cost.
• Stock value: see how much money is tied up on your shelves at cost and at selling price.
• Days of stock left: based on your last 30 days of sales.
• Stock take sheet: compare a physical count with the system and see exactly which adjustments to make.
• Dashboard: key figures, top products by value, stock by category, and a 12-month sales and purchases chart.
• Built-in error checks: duplicate codes, missing prices, unknown products and negative stock are flagged in red.

Who it's for

Small shops, beauty and hair suppliers, hardware and household retailers, market vendors and online sellers in Jamaica, the Caribbean and beyond. Works in any currency.

What you receive

• Format: one ZIP download containing two Microsoft Excel workbooks (.xlsx): a BLANK file ready for your data and a SAMPLE file with example data.
• Delivery: instant download. After payment, your download link appears on the order confirmation page and is sent to your email.
• Requirements: Microsoft Excel 2010 or newer. No macros needed.
• Price: US$24 one-time purchase; no subscription.
• Shipping: None — this is a digital product.

Note: a record-keeping tool. Results depend on the data you enter. Not accounting or tax advice.