Inventory Spreadsheet Excel Template, Stock Management Tracker, Small Business Inventory Dashboard, Reorder & Expiry Alerts, Barcode

NEW in this version: an EOQ & reorder-point planner that finds the cheapest order quantity, including supplier price breaks.

A complete inventory system in Excel, not just another stock list. It's built for small shops, mini-markets, grocers and traders.

Each stock movement goes on one row: purchase, sale, return, adjustment or transfer between warehouses. Pick the item from a dropdown or type its barcode. The workbook fills in the item name, unit, price, running balance, cost of goods and gross profit, and every report and the dashboard update instantly.

✔ Arabic version included (right-to-left), plus Finnish and English editions.

WHO IT'S FOR
• Small retail shops, mini-markets and grocers
• Traders and wholesalers with up to 4 warehouses or branches
• Anyone who wants stock value, profit and reorder lists in one Excel file

FEATURES
• NEW – EOQ & Reorder sheet: pick an item and see the economic order quantity (EOQ), rounded up to your box/pallet size and minimum order quantity. Compare the total annual cost (purchase + ordering + holding) at the EOQ and at up to 3 quantity price breaks, and get the cheapest order quantity, the saving, orders per year, the reorder point (daily demand × lead time + safety stock) and an "Order now" flag. Annual demand is calculated from your own sales history.
• Live dashboard: stock value, low-stock and out-of-stock items, this month's sales vs last month, gross profit, 4 charts, best sellers, dead stock and items to reorder
• Stock per item and per warehouse/branch (up to 4), with weighted-average cost, stock value, status and a suggested reorder quantity
• Item card: full movement history with running balance, plus sales and profit for any period
• Expiry alerts by batch (FIFO), showing the value at risk
• Purchase-order suggestions grouped by supplier
• Stocktake sheet with variances
• 12-month report
• 3 languages (English, Arabic, Finnish), switched with one dropdown
• Plain .xlsx with no macros. Formulas and sheets are protected against accidental changes, and the white cells are for your input
• Capacity: 5,000 movements, 500 items, 150 suppliers, 250 customers

WHAT'S INCLUDED
• English: empty copy + demo copy + quick start guide
• Arabic (RTL): empty copy + demo copy + quick start guide
• Finnish: empty copy + demo copy + quick start guide
• Each demo copy has 30 items, 2 branches and 181 movements over 6 months, so you can try every feature before entering your own data

HOW TO USE
1. Download and unzip the files.
2. Open the demo copy in your language and look around the dashboard and reports.
3. In the empty copy, add your items, suppliers and warehouses.
4. Record each purchase, sale, return, adjustment or transfer as one row (use the dropdown or a barcode).
5. Check the dashboard, reorder suggestions and expiry alerts as often as you like.

FILE FORMAT & REQUIREMENTS
• Excel workbook (.xlsx) + quick start guides
• Requires Microsoft Excel 365, or Excel 2021 or newer (Windows or Mac)
• Not fully functional in Excel 2019 or older (it uses dynamic arrays)
• Google Sheets and Excel for the web are not officially supported

PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• Preview images show fictional demo data.
• Because this is a digital product, returns and exchanges are not accepted. Please check the Excel version requirement before you buy, and message me if you need help.