The Hidden Cost of Bad Inventory Management
Most service businesses do not think of inventory as a profit lever. It is just stuff on the shelf: parts, supplies and tools that you buy when you need them and hope you have when a job comes in. But poor inventory management quietly eats into your margins in several ways:
- Stockouts cost you jobs. When a customer needs a service and you do not have the part, you either lose the job or make an extra trip that eats the profit. For a locksmith, not having the right transponder key blank can mean turning away an automotive job.
- Overstocking ties up cash. Every dollar sitting in dead inventory is a dollar you cannot use for payroll, marketing or equipment. If you hold $20,000 of stock and $5,000 of it has not moved in a year, that $5,000 is sitting on a shelf instead of working for you.
- Shrinkage drains profit. Without good records, parts walk off trucks, get miscounted or get used on jobs without being recorded. You only see it when you finally count.
- Inaccurate costing hides your margins. If you do not know what you paid for a part, you cannot price your services correctly, and guessing at costs leads to underpricing.
Inventory Tracking Across Locations and Trucks
The biggest challenge for a service business is not tracking stock in one shop. It is tracking it across a shop, several trucks and sometimes a storage unit. Your technician needs to know what is on the truck before rolling to a job, not after arriving and finding the part is not there.
What multi-location tracking looks like in practice:
- Stock levels per location — Every shop and every van is its own location with its own quantities and reorder points, so you can see what is in the shop versus on each truck.
- Transfers between locations — When you move parts from the shop to a van, you record a transfer. In IntelliDrive OS a transfer goes through four steps (create, approve, ship, receive), shipping is refused if the source does not have every unit, and each step shows every product's stock before and after at both ends.
- Reorder points per location — Set a minimum for each product at each location, and the reorder list shows everything that has fallen below it.
- Purchase orders and supplier invoices — Create purchase orders in the system, or photograph a supplier invoice and let IntelliDrive OS read the lines and suggest the matching products for you to confirm. Saving the order adds the stock and records each unit's cost.
- Parts bought for a customer's job — Special orders can be logged with the carrier and tracking number, so you can see when the part is delivered and, if you choose, text the customer.
Read more about how this works on the inventory management page.
Understanding Inventory Costing: FIFO, LIFO and Average Cost
When you buy the same part at different prices over time, which cost do you use when you sell it? The answer matters more than most owners realize, because it affects your reported margins and your tax picture.
Three standard costing methods:
- FIFO (First In, First Out) — You sell the oldest stock first. If you bought a key blank for $15 in January and $18 in March, selling one in April costs $15. FIFO tends to show higher profit when prices are rising.
- LIFO (Last In, First Out) — You sell the newest stock first. Using the same example, the April sale costs $18. LIFO tends to show lower profit when prices are rising, and it is not accepted under international accounting standards (IFRS).
- Average Cost — You average your purchase prices. With $15 and $18 purchases, the average is $16.50. It is the simplest method and gives steady margins, which is why many small businesses use it.
Choose the method with your accountant and apply it consistently. IntelliDrive OS supports FIFO, LIFO and average costing, records the cost of each unit when stock comes in, and carries that cost with the stock when it moves between locations, so the sales report shows revenue, cost and margin by product, category or cashier.
Barcode Scanning: Speed Up Counts and Checkout
Manual counts are slow, error-prone and unpopular with technicians. Barcode scanning removes the worst parts:
- Faster stock counts — Scan items instead of typing part numbers, and the count line shows the difference from what the system expected.
- Fewer data entry errors — Scanning avoids transposition errors, such as typing 1234 instead of 1243, that quietly corrupt your inventory data.
- Faster checkout — Scan products onto a sale instead of searching a catalog, which matters when you carry hundreds of SKUs and a customer is waiting.
- Receiving accuracy — Check incoming shipments against what you ordered.
In IntelliDrive OS you can count by scanning with a barcode scanner, with your device's camera in browsers that can read barcodes, or by typing the quantities. Product search also matches barcodes, SKUs, FCC IDs and OEM and supplier part numbers. A dedicated handheld scanner may be faster at high volume, but it is not required to start.
Reorder Alerts: Never Run Out of Critical Parts
The most expensive inventory mistake is usually not buying too much. It is running out of a high-demand part at the worst possible time. Reorder alerts help by showing you what is low before it becomes a stockout.
How to set up effective reorder points:
- Identify your top 20 items. In most service businesses a small share of products generates most of the revenue. These are the items where a stockout costs you the most.
- Set minimums from usage. If you sell 10 of a key blank per week and your supplier takes 5 days to deliver, a reorder point of 15 gives you about a week and a half of buffer.
- Set reorder quantities with price breaks in mind. If buying 50 saves a meaningful amount versus 25 and you will use them within a month, the larger order makes sense.
- Review quarterly. Demand changes with the season, so adjust your reorder points as you go.
In IntelliDrive OS, products below their reorder point at a location appear in the reorder list, owners and admins get an in-app alert, and the reorder check can draft purchase orders grouped by supplier for you to review. The alerts are in-app only, with no emails or texts, so make checking the list a weekly habit.
Automotive Parts: Fields That Matter for Locksmiths
If you are an automotive locksmith, general-purpose inventory is not enough. You need records that understand key blanks, remotes, fobs and transponder chips:
- FCC ID — Every remote and fob has an FCC ID that determines programming compatibility, so your system should store it and search by it.
- OEM part number cross-reference — Keep manufacturer part numbers and your supplier's part number next to your own SKU so you can verify compatibility quickly.
- Chip, frequency, buttons and keyway — The details you check before you promise a customer a key.
- Vehicle compatibility — Link parts to makes, models and year ranges, so when a customer calls about a 2019 Honda Accord you can find every compatible blank and remote.
IntelliDrive OS product records have an automotive section for all of these, and product search finds an item by FCC ID, OEM part number, supplier part number or compatible make and model. When you read a supplier invoice, it suggests the matching product by SKU, FCC ID or OEM part number.
Putting It All Together: Your Inventory Management Checklist
Whether you are starting from scratch or leaving spreadsheets behind, here is the action plan:
- Audit your current inventory. Count everything. Mark items that have not sold in 90 days as slow-moving, and total the value of your stock.
- Choose a costing method. Average cost is a safe default for many small businesses. Ask your accountant if you are unsure.
- Set up locations. Create one for your shop, each truck and any storage unit, and assign every item to a location.
- Set reorder points for your top 20 items. These are the items where running out costs you the most.
- Start scanning. Add barcodes to products that do not have them, and use scanning for counts and checkout.
- Count weekly for the first month. Frequent counts help you catch data entry errors early. After the first month, move to monthly counts. Count a whole location before you complete the count: IntelliDrive OS treats a completed count as the complete truth for that location and sets products you did not count to zero, and it tells you how many that would be before you finish.
- Review your reports monthly. Look for slow-moving stock, adjust reorder points and watch for patterns in the gaps between your counts and your records.
