# Spare parts inventory Excel sheet (free)

> Free spare parts inventory sheet: part number search, bin location, receipts, issues per machine and work order, returns, reorder list and slow-moving parts.

Source: https://softwiro.com/blog/spare-parts-inventory-free-excel-online.html
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Spare parts inventory in Excel (free): balance, issues per machine, reorder

Find any part by number or model, see who took it and for which machine, and order before a machine stops.

13 November 2026 5 min read

## In short

- Each part has a card with its number, alternative number, compatible machine, bin, cost, minimum and maximum.
- Balance = opening + received - issued + returned; status shows reorder, out, excess or available.
- Every issue records who took the part, the machine and the work order, so each machine's consumption adds up by itself.
- The reorder list shows supplier, lead time and expected arrival; the search sheet finds a part by number or model.

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](https://softwiro.com/templates/spare-parts-inventory) 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

1. In الموردون (Suppliers) write each supplier and its lead time in days; in الآلات (Machines) write your machines and vehicles.
2. In القطع (Parts) write each part's card: number, alternative number, description, compatible machine, bin location, cost, minimum, maximum and supplier.
3. 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).
4. The parts sheet calculates balance = opening + received - issued + returned, its value at the card's cost, and a status.
5. Type a number or model in بحث (Search) and matching parts appear with balance and location.
6. 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](https://softwiro.com/contact). If your workshop repairs cars, see also the [car workshop jobs sheet](https://softwiro.com/templates/car-workshop-jobs), and for general shop stock the [general inventory sheet](https://softwiro.com/templates/general-inventory).

## Next step

[Open the sheet](https://softwiro.com/templates/spare-parts-inventory), 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.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: spare parts inventory (1/3)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-1.jpg)[![Cheat sheet: spare parts inventory (2/3)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-2.jpg)[![Cheat sheet: spare parts inventory (3/3)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/spare-parts-inventory/en-3.jpg)

0 downloads · 3 pages

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Questions this raises

### How do I find a part's location and balance quickly?

Type the part number, a piece of it, the alternative number or a model name in the search sheet. Matching parts appear with balance, bin location, status and supplier.

### When does a part show "reorder", "out" or "excess"?

"Out" when the balance is zero or less, "reorder" when it equals the minimum or is below it, and "excess" when it is above the maximum.

### How is consumption per machine calculated?

It adds the value issued to the machine and subtracts the value returned from it. Pick the machine's name from the list on every issue so it adds up.

### What makes a part slow-moving?

It has stock and nothing was issued for at least the number of days in Settings (30 in the sample), or it was never issued.

## Have a system to build?

Softwiro designs, builds, and operates production systems. Describe what you need and we will come back with a scope rather than a slogan.

Start a project

[All writing](https://softwiro.com/blog.html)
