Stocktake template
Reference, product, warehouse, recorded stock, counted quantity, difference, unit cost and valuation.
Stocktake template
Stocktake by warehouse.
A free Excel worksheet to count inventory, calculate differences and document corrections. A blank printable PDF is available.
No registrationAn independent counting worksheet. It does not change SouqDzayer stock and is not an import file. Validate corrections in your workspace afterwards.
Use the template
Prepare the count
Record warehouse and date. Copy references and theoretical physical stock at that moment.
Count and compare
Enter actual quantities. The spreadsheet calculates differences and valuation when unit cost is entered.
Explain and approve
Record reasons, check movements and enter authorised corrections in your stock system.
| Field | Purpose |
|---|---|
| Reference and warehouse | Find the correct product and location |
| Recorded and counted stock | Compare quantities at the same time |
| Difference and reason | Justify a verified correction |