How to use Items with the most stock loss

The Items with the most stock loss section shows which inventory items lost the most stock during the selected period. It shows both quantity lost and estimated KSh cost value, so you can see the biggest risks.

What it shows

• Item name.
• SKU or item code.
• Unit.
• Loss quantity.
• Loss value.
• Number of related movements.

How to read it

• Loss quantity shows how many units were removed or lost during the selected period.
• Loss value estimates the cost value of that stock loss.
• Movements show how many stock movement records contributed to the loss.
• An item with a high loss value needs attention even if the quantity is not very high.

What to check when loss is high

• Open the inventory item.
• Review the stock movement history.
• Look for damage, stock removed, invoice deduction, sale deduction, or manual adjustment entries.
• Check whether the stock loss came from real sales or non-sale removals.
• Check whether staff forgot to record some sales correctly.
• Check whether the cost price is correct.

Possible causes

• Stock was sold through inventory-linked sales.
• Stock was deducted when invoice payments were added to Sales.
• Stock was manually removed.
• Stock was damaged or expired.
• Opening stock was wrong and later corrected.
• Duplicate adjustments were entered.

Example

• If Avocado shows a large loss quantity and high loss value, the business owner should check whether those avocados were sold, damaged, expired, or incorrectly adjusted.