Shrinkage Report
Compare book and physical stock at cost for the same count date. Use one currency and the same sales period.
Editable training example. Shortages and surpluses are shown separately; a surplus in one department does not conceal another department’s shortage.
| القسم / Department | الدفتري بالتكلفة / Book cost | الفعلي بالتكلفة / Physical cost | مبيعات الفترة / Period sales | Action |
|---|---|---|---|---|
Calculated results
- Book cost
- 50,000
- Physical cost
- 49,000
- Gross shortage
- 1,000
- Gross surplus
- 0
- Net variance (book − physical)
- 1,000
- Shortage / period sales
- 0.5%
- Shortage / book stock
- 2%
Shortage = sum of positive (book − physical) differences. Surplus = sum of positive (physical − book) differences. Total rates use total values, not average department rates.
Recount and reconcile receipts, transfers and returns before approving adjustments. Differences do not establish theft or any specific cause.
Follow-up action
Inputs are temporary in this page. Download before leaving. No automatic connection to company systems.