Spare Parts Inventory: Why Stock Levels Never Add Up and How to Restore Order
Published
Spare parts accounting is less about software than about discipline. The program may hold perfect records, but if a technician takes a part off the shelf and installs it in a device without recording it in the system, the database becomes a work of fiction.
Let us look at why the “virtual” stock level starts to diverge from the real one and which habits reduce errors to zero.
Reason 1: writing off after the fact
The most common mistake is when a technician completes a repair, closes the order, and only records the write-off a day or two later. At that moment a negative balance appears in the database, even though the part is still sitting on the shelf.
How to fix it: A part must be written off at the moment it is installed. In WorkPan this is done in the order overview: every component is tied to a specific repair. When a technician needs a part, they request it, and the system reserves that item in the warehouse. The discipline is simple: until the part has been written off in the order record, it counts as being in stock.
Reason 2: repairs “out of pocket”
Sometimes a technician takes a part from the warehouse but forgets to add it to the list of services on the order. Or they use “their own” part, bought on the way to the shop, and never put it through inventory records. The customer pays for the service, and the warehouse empties out unnoticed.
How to fix it: Every part that ends up inside a device must have a documented origin. If the part comes from the warehouse, it is added to the components of the order. If a third-party part is used, it has to be received into the warehouse before installation. Only then is it possible to track what exactly was replaced and where that item came from.
Reason 3: returning an unused part
Parts are often ordered with a margin or for diagnostics. If a part turns out not to be needed, the technician often just puts it back on the shelf, forgetting to cancel the reservation or record the return in the system. As a result, the CRM lists the part as being in progress or written off, while it is physically in the warehouse.
How to fix it: Returning a part is just as much an operation as requesting one. If a part was not used, it has to be returned to the warehouse in the system. In WorkPan, inventory accounting is a closed system linked to the goods and services reference books. If you did not record a movement in the program, it did not happen in reality.
The workflow that keeps the warehouse accurate
To avoid running a stocktake every week, a few simple rules are enough:
- Every warehouse has an owner. The Warehouses reference book states exactly which warehouse belongs to which office. There are no ownerless parts.
- Write-offs go through the order. The Goods reference book and the Parts reference book have to stay in sync. A technician should never invent a part name when writing it off — they pick it from the reference book.
- Tie parts to stages. If a part is needed for a repair, the buyer must see the request. Once the part arrives, it lands in the Order overview and waits its turn.
Stock adds up when the CRM is the single version of the truth. If a part exists in the computer but not on the shelf, a movement was recorded incorrectly. The cause is not in the software but in the step where someone forgot to press the button.