Inventory Spreadsheet Template Excel | Stock Management Tracker for Small Business (EN/AR/FI)

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

• 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 and an "Order now" flag.

• جديد – ورقة الكمية الاقتصادية للطلب (EOQ) ونقطة إعادة الطلب: تحسب أرخص كمية طلب، وتقارن التكلفة مع حتى 3 شرائح خصم، وتعرض التوفير ونقطة إعادة الطلب وتنبيه «اطلب الآن».

This is not another simple stock list. It is a complete inventory system inside Excel, built for small shops, mini-markets, grocers and traders.

Every movement is 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.

FEATURES

• Live dashboard: stock value, low and out-of-stock items, monthly sales vs the previous 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 suggested reorder quantity.

• Item card: full movement history with running balance, plus sales and profit for any period.

• Expiry alerts by batch (FIFO), with the value at risk.

• Purchase-order suggestions grouped by supplier, a stocktake sheet with variances, and a 12-month report.

• 3 languages (English, Arabic, Finnish), switched with one dropdown.

• No macros: a plain .xlsx. Formulas and sheets are protected against accidental changes; white cells are for your input.

• Capacity: 5,000 movements, 500 items, 150 suppliers, 250 customers.

WHAT YOU GET (one download, three ready-made language editions)

• English: an empty copy for your own data and a demo copy with fictional sample data, plus a quick start guide.

• Arabic (right-to-left): empty copy, demo copy and quick start guide in Arabic.

• Finnish: empty copy, demo copy and quick start guide in Finnish.

Each demo copy has 30 items, 2 branches and 181 movements over 6 months so you can explore everything first.

REQUIREMENTS

• Microsoft Excel 365 or Excel 2021 or newer (Windows or Mac). Not fully functional in Excel 2019 or older, because it uses dynamic arrays.

• Google Sheets and Excel for the web are not officially supported.

Preview images show fictional demo data. This is a digital download; no physical item is shipped.

Support: sadeekkasem@gmail.com

Search keywords / كلمات البحث / Hakusanat:

inventory spreadsheet, inventory template excel, inventory tracker, stock management excel, small business inventory, excel template

برنامج مخازن اكسل، شيت مخازن جاهز، شيت مخازن وارد ومنصرف، جرد المخزون excel، جدول اكسل جاهز

varastokirjanpito excel pohja, varastonhallinta excel, inventaario excel pohja, excel taulukko