Plumbing Inventory Template
For plumbing companies stocking fittings, valves, pipe and water-heater parts across a warehouse and service trucks. Know what's on each truck before the next emergency call.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| PL-PEX-A-34-100 | PEX-A Tubing 3/4 in., 100 ft | Pipe | Warehouse / Rack 2 | coil | 6 | 2 | 64 | auto | auto | FlowRight Plumbing Supply |
| PL-VLV-BAL-12 | Ball Valve 1/2 in. Sweat | Valves | Truck 1 / Bin 3 | each | 8 | 4 | 9.25 | auto | auto | FlowRight Plumbing Supply |
| PL-FLP-UNIV | Universal Toilet Flapper | Repair Parts | Truck 3 / Drawer 1 | each | 12 | 5 | 4.4 | auto | auto | Pipeline Wholesale Co. |
ƒ = 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
- Use a min/max per truck for the 40 or so parts that cover most calls, and restock to max after each shift.
- List fittings by material and size (e.g. 3/4 in. copper 90) since PEX, copper and PVC versions are not interchangeable.
- Count water heater parts like anode rods and thermocouples monthly; they're slow movers but you need them same day.
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