You run a workshop or a plant and want to know in seconds whether a part is in stock and on which shelf, how much has gone to each machine and who took it, and what to order before a machine stops. The free spare parts inventory sheet answers this from four logs you type: part cards, receipts, issues and returns.
The problem it solves
Spare parts differ from shop stock in two ways. A technician needs one specific part now, and when it is missing the machine stands still, which costs more than the part. And one part has several numbers (the maker's and an alternative) and fits particular machines. So time goes into searching, a part is bought that already sits on another shelf, and a small item runs out that should have been ordered a week earlier. Nobody knows what each machine costs per year.
How it works, step by step
- In الموردون (Suppliers) write each supplier and its lead time in days; in الآلات (Machines) write your machines and vehicles.
- In القطع (Parts) write each part's card: number, alternative number, description, compatible machine, bin location, cost, minimum, maximum and supplier.
- Log each delivery in الاستلام (Receipts), each part taken in الصرف (Issues) with who took it, the machine and the work order, and what came back in المرتجعات (Returns).
- The parts sheet calculates balance = opening + received - issued + returned, its value at the card's cost, and a status.
- Type a number or model in بحث (Search) and matching parts appear with balance and location.
- Open the reorder, slow-moving, machines and summary sheets when you need them.
What each sheet does
- الإعدادات (Settings): today's date, slow-mover days, first month for the summary and the category list.
- القطع (Parts): the card, balance, value, status, reorder quantity and last issue.
- الاستلام, الصرف, المرتجعات: the movement logs, showing each part's description and a red warning for an unknown number.
- الآلات (Machines): issue count, value issued and returned, net consumption and rank per machine.
- الموردون (Suppliers): lead time and value received from each.
- بحث, إعادة الطلب, الراكد: three ready lists that update themselves.
- الملخص (Summary): value, statuses and monthly movement, with four charts.
Walk-through on the sample numbers
The numbers below are sample data inside the sheet, not a real workshop. It has 19 parts, 32 issues, 10 receipts and 4 returns, and today's date is 13 November 2026:
- Bearing 6205-2RS: opening 12, received 20, issued 15, returned 1, so the balance is 18 worth 1,530 (18 x 85).
- Diesel filter FF-1142: 22 were received, the balance is 20 and the maximum is 18, so the status is "excess".
- Oil pressure sensor SW-LP22: 3 were issued on 2 October, so it is out. The list suggests 5 costing 1,900 from the electrical supplier, lead time 5 days.
- Top of the list: hydraulic filter HF-9008 has 2, equal to its minimum. The suggestion is 4 (6 - 2) costing 3,120 from the filter supplier, arriving 16 November if ordered today.
- Reorder list: 7 parts costing 15,490; total stock value 37,650.
- Slow-moving: water pump WP-HI15 was never issued (value 2,300) and the O-ring kit OR-KIT was last issued on 5 October, 39 days ago (value 1,240). Slow stock is 3,540, about 9.4% of stock value.
- Search: the word "هايس" (Hiace) lists 3 parts with their bins: B-02-03, F-01-01 and F-02-01.
- Machines: the loader uses the most, net 4,415 of 19,920, then the Hiace van at 2,920 and the press at 2,815. The van's figure already deducts a return worth 520.
- Movement: received 23,320, issued 21,005, returned 1,085.
Common mistakes
- Typing the part number differently: pick it from the drop-down; a red warning shows when it does not match.
- Leaving the machine blank on an issue: that value never reaches any machine's consumption.
- Entering a return as a negative issue: use the returns sheet instead.
- A minimum nobody revisits: set it against lead time; a supplier who takes 7 days needs a higher minimum than one who delivers tomorrow.
- Not updating today's date: slow-moving and expected arrival depend on it.
When to move to a system
The sheet suits a small workshop or plant with hundreds of parts and one storekeeper typing. When issues become daily from several technicians, or you need barcodes, part photos, and issues tied to a maintenance order and its cost to the customer, Softwiro can build you a program around your way of working. If your workshop repairs cars, see also the car workshop jobs sheet, and for general shop stock the general inventory sheet.
Next step
Open the sheet, clear the sample numbers, write the cards of the five parts that move most with their minimum, maximum and bin, and log this week's issues. By Friday the reorder list is ready.





