Stock snapshot
Stock by SKU and location on a date: warehouse, store, in transit.
What the template is for
Daily reconciliation of ERP, warehouse and platforms; stock-in-weeks calculation.
- What one row is
- one row = SKU × location × date
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Stock date | date | Date | yes | date YYYY-MM-DD, not in the future |
| SKU code | sku | Text | yes | a value from the reference book |
| Location code | loc | Text | yes | a value from the reference book |
| On hand, pcs | qty | Integer | yes | an integer not below 0 |
| Reserved, pcs | res | Integer | no | an integer not above on hand |
| In transit, pcs | transit | Integer | no | an integer not below 0 |
| Unit cost | cost | Number | yes | a number not below 0 |
Example rows
| Stock date | SKU code | Location code | On hand, pcs | Reserved, pcs | In transit, pcs | Unit cost |
|---|---|---|---|---|---|---|
| 2026-11-13 | A100-BLK-M | WH1 | 120 | 10 | 0 | 1,800 |
| 2026-11-13 | A100-BLK-M | ST07 | 6 | 0 | 24 | 1,800 |
The example data is illustrative: an exercise, replace it with your own.
Note
Row key: date, SKU and location together. Two snapshots for one date from the same source are a duplicate.
How to open the file
The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.
Calculations that use these fields
- Average stock for the year and turnover
- Days of inventory and excess stock
- Availability and lost revenue
- Stock age and price-reduction provision
- Inventory write-down: cost against net realizable value
- Opening stock: stock-to-sales and the monthly buying budget
- Stock record accuracy and the cost of mismatches
- Reorder point and safety stock
Documents that need this data
- Merchandise stock balance
- Stock turnover and dead stock
- Provision for inventory impairment: FSBU 5/2019, IAS 2, net realizable value
- ABC-XYZ and Pareto: calculation, thresholds, link to safety stock and the range
- Accessories line economics: bags, jewelry, hats and belts
- AI in fashion and analytics: where to apply it, where not, how to check the result, which data are needed and which errors occur. A memo and a checklist
- AI in fashion analytics and content: what can be computed, limits, risks
- Allocation and replenishment
- Management balance sheet
- Business continuity plan (BCP) and crisis measures
- Buyout, commission sale and consignment: operating cycle and cash
- Fashion tech: digital product passport, RFID, AR try-on, 3D design