Who this is for: owners, general managers, and housekeeping staff at hotels, hotel groups, resorts, motels, hostels, and B&Bs who track cleaning supplies, equipment, and amenity stock.
This template tracks cleaning chemicals, tools, equipment, guest amenities, and PPE. It's not a linen tracker or a task checklist. A separate linen inventory template covers bedding and towels. Our hotel housekeeping checklist covers the room-cleaning process itself.
What's Included in This Template
- A core inventory tracker covering chemicals, tools, amenities, and PPE
- An equipment inventory for reusable tools like vacuums and scrubbers
- A supply issue register for tracking what leaves the store room
- A monthly summary rolling up stock by category
Key Template Sections
- Housekeeping Inventory Tracker: stock levels by item, category, and location.
- Equipment Inventory: condition and service tracking for reusable equipment.
- Supply Issue Register: what left the store room and who issued it.
- Monthly Inventory Summary: the rollup view across all categories.
Housekeeping Inventory Tracker
| Item Category | Item Name | SKU/Item Code | Unit | Storage Location | Opening Stock | Received | Issued | Damaged/Expired | Closing Stock | Minimum Stock | Reorder Required |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Cleaning Chemicals | Disinfectant | Bottle | Store Room | ☐ | |||||||
| Cleaning Chemicals | Glass Cleaner | Bottle | Store Room | ☐ | |||||||
| Cleaning Chemicals | Floor Cleaner | Bottle | Store Room | ☐ | |||||||
| Cleaning Chemicals | Toilet Cleaner | Bottle | Store Room | ☐ | |||||||
| Cleaning Tools | Mop | Each | Housekeeping Room | ☐ | |||||||
| Cleaning Tools | Broom | Each | Housekeeping Room | ☐ | |||||||
| Cleaning Tools | Microfiber Cloth | Each | Housekeeping Room | ☐ | |||||||
| Cleaning Tools | Cleaning Bucket | Each | Housekeeping Room | ☐ | |||||||
| Guest Amenities | Shampoo | Bottle | Amenity Store | ☐ | |||||||
| Guest Amenities | Conditioner | Bottle | Amenity Store | ☐ | |||||||
| Guest Amenities | Body Wash | Bottle | Amenity Store | ☐ | |||||||
| Guest Amenities | Soap | Bar | Amenity Store | ☐ | |||||||
| Guest Amenities | Toilet Paper | Roll | Store Room | ☐ | |||||||
| Guest Amenities | Facial Tissue | Box | Store Room | ☐ | |||||||
| PPE | Disposable Gloves | Box | Store Room | ☐ | |||||||
| PPE | Face Masks | Box | Store Room | ☐ |
Equipment Inventory
| Equipment | Asset ID | Quantity | Condition | Assigned To | Last Service Date | Next Service Due | Remarks |
|---|---|---|---|---|---|---|---|
| Vacuum Cleaner | |||||||
| Floor Scrubber | |||||||
| Steam Cleaner | |||||||
| Carpet Cleaner | |||||||
| Housekeeping Cart |
Supply Issue Register
| Date | Department/Staff | Item | Quantity Issued | Quantity Returned | Issued By | Received By |
|---|---|---|---|---|---|---|
Monthly Inventory Summary
| Category | Opening Stock | Received | Consumed | Damaged/Expired | Closing Stock | Variance |
|---|---|---|---|---|---|---|
| Cleaning Chemicals | ||||||
| Cleaning Tools | ||||||
| Guest Amenities | ||||||
| PPE |
How Do You Use This Template?
Separate consumables from equipment, since they get tracked differently.
- Count fast-moving items weekly, since chemicals and amenities deplete faster than equipment.
- Log every issue as it happens, not at the end of the shift.
- Track equipment condition separately from consumables, since a broken vacuum isn't a stock problem.
- Set minimum stock levels per category, so reordering isn't a guess.
- Review the monthly summary before placing a new order.
Common Mistakes to Avoid
- Tracking consumables and equipment in the same count, blurring two different problems.
- Skipping weekly counts for fast-moving items like toiletries and chemicals.
- Leaving the issue register blank and losing track of who took what.
- Storing chemicals without following label guidance or checking expiration dates.
- Reordering without checking the monthly variance first.
Frequently Asked Questions
1. How is this different from a linen inventory template?
This tracks chemicals, tools, amenities, and PPE. A separate linen inventory template covers bedding and towels.
2. How often should housekeeping inventory be counted?
Count fast-moving items like chemicals and amenities weekly. Equipment can be checked monthly instead.
3. Should equipment and consumables be tracked in the same table?
No. Equipment needs condition and service tracking. Consumables need stock counts and reorder points.
4. Does this replace a room-cleaning checklist?
No. This covers supply and equipment tracking. Our hotel housekeeping checklist covers the cleaning process itself.
5. What triggers a reorder?
When closing stock drops to or below the minimum stock level set for that item.
