Total Items
0
Total Stock Value
$0
Total Stock In (Qty)
0
Total Stock Out (Qty)
0
Low Stock Items
0
Stock by Category
Stock In vs Stock Out
Top 5 Items by Stock Value
Stock Status
Inventory Summary
0 items| Item ID | Item Name | Category | Opening | Stock In | Stock Out | Current | Unit Cost | Stock Value | Reorder | Status |
|---|
Record Stock In Transaction
Stock In Transactions
0 records| Date | Ref No. | Item ID | Item Name | Quantity | Unit Cost | Total Cost | Supplier | Action |
|---|
Record Stock Out Transaction
Stock Out Transactions
0 records| Date | Ref No. | Item ID | Item Name | Quantity | Unit Price | Total Price | Customer | Action |
|---|
Inventory Sheet (Auto Calculations)
Current Stock = Opening + Stock In - Stock Out | Stock Value = Current x Unit Cost| Item ID | Item Name | Opening Stock | Total Stock In | Total Stock Out | Current Stock | Unit Cost | Stock Value | Reorder Level | Status |
|---|
Formula Reference
Current Stock = Opening Stock + SUMIFS(Stock In Qty by Item ID) - SUMIFS(Stock Out Qty by Item ID)
Stock Value = Current Stock × Unit Cost
Status = IF(Current Stock ≤ Reorder Level, "LOW STOCK", IF(Current Stock = 0, "OUT OF STOCK", "OK"))
Supplier Transactions
0 records| Supplier | Category | Total Transactions | Total Qty Supplied | Total Cost | Last Supply Date |
|---|