A tyre and oil stock count: size or grade and the rack.
A tyre is known by its size and an oil by its viscosity grade, and mixing 205/55R16 with 205/60R16 sells a customer the wrong thing. This template gives you a spec column, which is the tyre size or the oil grade, and a rack column for the warehouse location. It has sample rows with no brands, and the quantities are illustrations only.
Sample rows: Tyres and lubricants
Examples only; prices are blank for you to fill.
| Item | Spec (size / grade) | Rack | Expected | Counted | Difference |
|---|---|---|---|---|---|
| Passenger car tyre | 205/55R16 | T-01 | 24 | ||
| Passenger car tyre | 195/65R15 | T-02 | 18 | ||
| SUV tyre | 265/65R17 | T-04 | 12 | ||
| Light truck tyre | 215/75R16C | T-06 | 10 | ||
| Synthetic engine oil, 4 L | 5W-30 | O-01 | 36 | ||
| Semi-synthetic engine oil, 4 L | 10W-40 | O-02 | 30 | ||
| Diesel engine oil, 5 L | 15W-40 | O-03 | 22 | ||
| Gear oil, 1 L | 80W-90 | O-05 | 40 | ||
| Coolant, 4 L | Ready mix | O-07 | 26 |
Common questions
How do I read a tyre size?
In 205/55R16 the first number is the width in mm, the second the sidewall height as a percentage of the width, and the last the rim diameter in inches. Copy the size exactly as printed on the sidewall, without shortening it.
How do I count open containers and drums?
Count sealed containers by the piece, and measure open ones in litres on a line of their own. Do not mix drum litres with 4-litre containers in one cell.
Does the count show tyre age?
No, this template does not record the manufacture date. If you want to follow it, add a column by hand and write the week-and-year code printed on the tyre.
More free tools
- Tyres and lubricantsFor a tyre and oil shop: a size per tyre as a variant with a barcode, oil by the drum and litre, fitting work orders, installments for tyre sets, and fleet credit.
- 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.