Maintenance Spare Parts Inventory Spreadsheet
For facility and plant maintenance teams storing bearings, belts, motors, filters and lubricants for equipment upkeep. Tie each critical spare to its storeroom bin so downtime is short.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| MS-BRG-6205-2RS | Deep Groove Ball Bearing 6205-2RS | Bearings | Storeroom A / Bin 14 | each | 12 | 4 | 6.8 | auto | auto | Industrial Motion Supply |
| MS-BLT-B48 | V-Belt B48 (Conveyor 3) | Belts | Storeroom A / Hook 6 | each | 3 | 2 | 14.25 | auto | auto | Industrial Motion Supply |
| MS-LUB-EP2-14 | EP2 Grease Cartridge, 14 oz | Lubricants | Lube Cabinet | each | 20 | 8 | 5.9 | auto | auto | Plantworks MRO Supply |
ƒ = 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
- Mark critical spares for equipment with no backup and keep at least one on hand even if they rarely move.
- Include the machine or asset ID each part fits in the item name so techs can find it fast.
- Review parts that haven't moved in two years; some belong to equipment you've already retired.
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