Electrical Contractor Inventory Template
For electrical contractors keeping wire, breakers, boxes and fittings in a shop and on several service vans. Track stock by location so each van rolls out with what the day's jobs need.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| EL-WIR-12-2-250 | 12/2 NM-B Wire, 250 ft | Wire | Shop / Wire Rack | roll | 7 | 3 | 118 | auto | auto | Sparkline Electrical Supply |
| EL-BRK-20A-1P | 20A Single-Pole Breaker | Breakers | Van 2 | each | 10 | 4 | 7.6 | auto | auto | Sparkline Electrical Supply |
| EL-BOX-1G-NEW | 1-Gang New Work Box | Boxes | Shop / Bin 12 | each | 85 | 30 | 0.62 | auto | auto | Volt Depot Wholesale |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Give each van its own location code and restock to a fixed van list every Friday so techs aren't driving back to the supply house.
- Track wire by the foot on partial spools; estimate from weight using the spool's feet-per-pound when you can't measure.
- Charge out material to the job as it leaves the shop so on-hand stays accurate and jobs get billed for what they used.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template