Free Excel Inventory Management Template — Stock In/Out with Real-Time Tracking
Record stock receipts and shipments to automatically calculate current inventory levels, stock value, and reorder alerts. Built for retail, wholesale, and e-commerce.
Still manually counting stock to figure out how many units of Product A you have left? This template calculates current inventory automatically from your stock-in and stock-out records — no manual counting needed.
Key Features
📦 Stock In / Out Recording
- Select Stock In or Stock Out from a dropdown
- Enter product name, quantity, unit cost, and supplier/customer
- Date of receipt or shipment
- Notes field for PO numbers, order references, etc.
📊 Inventory Status Dashboard
| Metric | How It Works |
|---|---|
| Current Stock | Opening stock + Stock In - Stock Out |
| Stock Value | Current quantity x average unit cost |
| Reorder Alert | Red warning when stock falls below safety level |
| Turnover Rate | Units sold / average inventory |
The dashboard updates in real time as you add new stock movements.
🏷️ Product Master List
- Product code, name, unit of measure (EA, BOX, KG, etc.), standard cost
- Safety stock level per product
- Category classification
- Optional barcode field
How to Use
Step 1: Register Products
In the “Product Master” sheet, enter the items you want to track — code, name, unit, standard cost, and safety stock level.
Step 2: Enter Opening Stock
When first using the template, enter your current on-hand quantities in the “Opening Stock” sheet. After this, only record movements.
Step 3: Record Stock Movements
On the “Transactions” sheet, log every receipt and shipment. Enter the product code and the product name and cost auto-fill.
Step 4: Check Inventory Status
The “Inventory Status” sheet shows current stock levels and flags any items below their safety stock threshold.
Tips
Use Safety Stock Alerts to Time Reorders
Set safety stock levels for each product. When current stock drops below that level, the row turns red — check this sheet daily to never miss a reorder.
Handle Returns and Defects
Select “Return” as the transaction type to add returned goods back to inventory. Select “Scrap” to remove defective items from stock.
FAQ
What if I have more than 500 products?
Extend the rows in the Product Master sheet. For very large catalogs, consider dedicated inventory management software.
Does it support FIFO costing?
The default version uses average cost. FIFO requires additional formulas — see the advanced template notes.
Can I use a barcode scanner?
Yes. Place your cursor in the barcode cell and scan — USB barcode scanners input directly into Excel with no extra setup.