Use a short stock review for each requirement
Check the exact design, version and size physically where possible. Mark pieces that are available to the request and those already allocated elsewhere. Do not combine unrelated stock just because the team name is the same.
Inspect any piece you are relying on. A damaged or incomplete item should not silently cover a requirement for a usable item.
Use one consistent reservation method
For customer demand already covered by reserved stock, either include both that demand and its matching allocation, or remove both from this review. Stock reserved for buyers outside this review is unavailable to these rows.
Writing the method in a note helps when more than one person maintains the list. This is an accounting choice for your review, not a universal inventory rule.
Count incoming without counting it twice
Check confirmed quantities, outstanding allocation and expected timing. Move received and checked items out of incoming into sellable stock. A parcel is never both on the way and on the shelf for the same calculation.
If a discrepancy remains, resolve it before treating the gap as a quantity to buy. The tool does not audit your stock records or track parcels automatically.
Check the inputs.
- Exact match counted
- Damaged or unsuitable pieces separated
- Other commitments excluded
- Reservations treated consistently
- Incoming and received goods not duplicated