A hardware stock count: the unit and the shelf location.
A hardware shop holds thousands of small items: screws by the box, wire by the metre, wrenches by the piece, each on a shelf or in a bin. This template adds the counting unit and the shelf location, so whoever counts knows where to start and in what unit, and does not count a box as a piece. It has sample rows, and the locations and quantities are illustrations only.
Sample rows: Hardware shops
Examples only; prices are blank for you to fill.
| Item | Unit | Shelf / bin | Expected | Counted | Difference |
|---|---|---|---|---|---|
| Wood screws 4 cm | box | A-01 | 40 | ||
| Iron nails 5 cm | kg | A-02 | 25 | ||
| Electrical wire 2.5 mm | roll | B-03 | 18 | ||
| Spanner 14 mm | piece | C-05 | 22 | ||
| Hammer 500 g | piece | C-06 | 14 | ||
| Metal cutting disc | piece | D-02 | 60 | ||
| White paint 4 L | tin | E-01 | 16 | ||
| Door hinge | pair | F-04 | 80 | ||
| Insulating tape | roll | B-07 | 45 |
Common questions
Why write the shelf location?
So the count becomes an orderly walk through the shop instead of random searching, and whoever checks a difference can return to the same spot. It also reveals an item kept in two places that gets counted twice or missed.
How do I count tiny high-count items?
Count sealed boxes as boxes, and for open ones weigh or count a sample, then scale up. Write the unit clearly in its column so the team does not mix a box with a piece.
What if I find an item that is not on the list?
Add a new line at the bottom with its unit and location, and set expected to zero. The positive difference will show that it entered the shop unrecorded.
More free tools
- Hardware & building suppliesA POS for hardware and building-supply shops: one item in several units (metre, carton, piece, kilo) with a barcode each, fractional quantities, receiving in parts.
- Stock count sheetA ready stock-count sheet in Arabic, Kurdish and English: code, item, expected, counted, and the difference with its dinar value computed for you. Excel and CSV, free.
- Purchase orderA ready purchase order for a supplier: item, unit, quantity, unit cost, totals computed, and a Received column for what actually arrived. Arabic, Kurdish, English. Free.