Janitorial Supply Inventory Spreadsheet
For cleaning companies, building managers and custodial teams tracking chemicals, paper products, liners and tools across buildings. Lot and date tracking keeps concentrates fresh and accounted for.
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Neutral Floor Cleaner Concentrate (1:256), 1 gal | Chemicals | FC25-6610 | Janitor Closet B1 | gal | 8 | 4 | auto | 2027-10-31 | auto | 14.5 | auto | Brightway Janitorial Supply |
| Can Liner 40x46, 1.5 mil | Liners | CL25-2208 | Loading Dock | case of 100 | 6 | 3 | auto | auto | 34 | auto | Brightway Janitorial Supply | |
| Hardwound Paper Towel 8 in. x 800 ft | Paper | PT25-4019 | Janitor Closet 2F | case of 6 | 10 | 5 | auto | auto | 39 | auto | Midstate Paper Mills |
ƒ = 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
- Track concentrates by gallon and note the dilution ratio in the item name so usage per building is easy to estimate.
- Count paper towels, toilet tissue and liners weekly; these run out first and generate the most complaints.
- Label secondary spray bottles with the product name and date filled, as your safety program requires.
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 SpreadsheetPPE Inventory Template