Stock Loss Calculator
MAX(Book − Actual, 0) × Unit cost
Analysis options
Set the threshold under company policy; it is not an industry benchmark.
Complete the numeric fields with non-negative values. Book quantity, labor hours or average inventory must be greater than zero.
Surplus is separate from shortage. The rate uses book quantity; for one item at the same unit cost it also equals the book-value rate. Review receiving, counts and waste before assigning a cause.
Draft and history stay in this browser only and may be lost when browser data is cleared. Keep an exported copy.
What does this measure?
Measure a single item’s shortage at purchase cost and show surplus separately. A shortage is not evidence of theft.
Prepare your inputs
Use matching item, units, count cutoff and unit cost. Record branch and period. Do not aggregate unlike items into a single quantity.
Worked example
Book 100, actual 95 and unit cost SAR 100 give SAR 500 shortage and 5% of book stock. Actual 105 gives SAR 500 surplus and zero shortage.
Act on the result
Recount and reconcile receipts, transfers, returns and waste before assigning a cause and corrective owner.
Limits and common mistakes
The denominator is book inventory, not sales. Book quantity must be positive. This single-item rate equals its cost-value rate.
Read the related practical guide
Prepared and reviewed by Abdelhamed Mohamed. Examples are educational; reconcile your inputs with company records before deciding. Editorial approach · Report a correction