PPE Inventory Template
For safety managers in warehouses, plants and construction firms tracking gloves, masks, safety glasses, hearing protection and hi-vis gear. Track sizes, lots and expiry so crews always have what they need.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Lot # | Location | Unit | Qty | Min Qty | Statusƒ | Expiry | Days to Expiryƒ | Unit Cost | Valueƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| N95 Respirator, Size M | Respiratory | N95-25-0717 | Safety Cage | box of 20 | 14 | 8 | auto | 2027-07-31 | auto | 22.5 | auto | SafeHand Supply Co. |
| Safety Glasses, Clear Anti-Fog | Eye Protection | SG25-1204 | Tool Crib | box of 12 | 9 | 4 | auto | auto | 28 | auto | Workplace Safety Co. | |
| Hi-Vis Vest Class 2, XL | Hi-Vis | HV25-0091 | Gate Locker | each | 18 | 10 | auto | auto | 6.75 | auto | Workplace Safety Co. |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Lot #
- Location
- Unit
- Qty
- Min Qty
- Status — calculated automatically
- Expiry
- Days to Expiry — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
Tips for using this template
- Stock gloves and safety glasses by size and track usage per crew; one oversized pair often gets swapped for the wrong one.
- Check expiration dates on respirator cartridges and hard hats, which have service lives set by the manufacturer.
- Set minimums from headcount and shift pattern, then review after any new hires or new projects.
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 TemplateMedical Office Supply Inventory TemplateDental Office Inventory SpreadsheetVeterinary Clinic Inventory TemplateLab Chemical Inventory SpreadsheetFirst Aid Kit Inventory TemplateSpa Inventory TemplateTattoo Shop Inventory SpreadsheetJanitorial Supply Inventory Spreadsheet