Electrical Contractor Inventory Tracking: Shop, Trucks and Jobs

Start with one item record

A breaker, cable reel, fitting, or tool should not become a different item every time it moves. Give the item one name or stock code, then store separate quantities for each location.

This prevents the common spreadsheet problem where Truck 03 and the main shop hold separate versions of the same part and nobody knows which total is current.

• Item name and stock code
• Unit of measure
• Minimum stock level
• Quantity at each location

Use locations that match the real work

Create only the locations your team uses: shops, trucks or vans, and active jobs. A location should have a clear owner or purpose. Retire finished job locations instead of deleting their history.

For a transfer, record the item, source, destination, quantity, time, and person. The system should reduce the source and increase the destination in one action.

Correct mistakes without erasing the original

When a technician enters the wrong quantity or destination, deleting the movement hides what happened. A linked reversal protects the audit trail: it records the correction, restores the quantity, and points back to the original movement.

This approach makes weekly checks easier because the current stock and the reason for a change remain visible.

Run a short weekly stock check

Review low-stock items, large movements, overdue job stock, and corrections. Export the records when your reporting or backup process needs a separate copy.

• Count a small rotating group of important parts
• Investigate negative or unusually high quantities
• Return or reassign stock from finished jobs
• Confirm minimum stock levels still match purchasing needs