Inventory is the quiet part of running a property that causes loud problems when it goes wrong. Run out of clean linen, toiletries or minibar stock at the wrong moment and a guest notices immediately. Overstock and you tie up cash and create waste. Many small hotels, guesthouses, lodges, B&Bs and villas in Kenya manage all this in a spreadsheet, or in someone’s head, and both eventually fail. Here is how to manage inventory properly, without the spreadsheet mess.
What counts as hotel inventory
For a property, inventory is the operational stock you use to run rooms and service guests:
- Housekeeping consumables and cleaning supplies
- Guest amenities and toiletries
- Linen and towels
- Minibar and in-room restock
- Maintenance parts and general supplies
This is different from food and drink sold in a bar or restaurant, which is a separate kind of stock with its own handling. The point here is the everyday operational supplies that keep rooms ready.
Why spreadsheets fail
A spreadsheet feels like control, but it quietly breaks down.
- It goes out of date the moment stock moves. Someone uses supplies and forgets to update the sheet, so the numbers drift from reality.
- Only one person really understands it. When they are off, nobody can use it.
- It does not warn you. A spreadsheet will not tell you that you are about to run out of toiletries before a full house.
- It hides wastage and leakage. Without a proper record of every movement, losses go unnoticed.
The result is the worst of both worlds: effort spent maintaining a sheet that you still cannot trust.
What good inventory management looks like
Managing inventory well does not mean more admin. It means a simple, reliable record that reflects reality.
1. Know what you hold
Keep a clear list of your items and how much of each you have, in one place everyone can see. No hunting through tabs or asking around.
2. Record every movement
Every time stock comes in or goes out, it should be recorded, so the count stays accurate. A proper system logs these movements as a running history, so the numbers are always trustworthy and you can see where things went.
3. Track across stores
If you keep supplies in more than one place, a main store and floor cupboards, for example, you want to track stock across them and move it between them cleanly, without losing sight of the total.
4. Do regular stock takes
A periodic count, checked against your records, catches discrepancies early and keeps everyone honest. With a system, a stock take is a quick structured task, not a spreadsheet rebuild.
5. Reorder on time
The goal of all this is simple: never run out, never overspend. When you can see real stock levels at a glance, you reorder at the right moment and stop tying up cash in things you do not need.
Moving off spreadsheets
The way to escape the spreadsheet is to keep inventory in the same system that runs the rest of your property. InzuHub includes inventory tracking, with items, stores, suppliers, stock takes and a running history of every movement, so your counts stay accurate without manual upkeep. Because it lives alongside your bookings and operations, your team works in one place instead of juggling a separate sheet. See it on our features page, and read how it fits the wider operation in our guide on how to run a small hotel or B&B in Kenya.
Summary
- Hotel inventory is the operational stock that keeps rooms ready: consumables, amenities, linen, minibar and parts.
- Spreadsheets drift out of date, depend on one person, and hide wastage.
- Good management means knowing what you hold, recording every movement, tracking across stores, doing stock takes and reordering on time.
- Keeping inventory in your property system, as InzuHub does, removes the spreadsheet and keeps counts accurate.
Frequently asked questions
What is hotel inventory? The operational supplies a property uses to run rooms and serve guests, such as cleaning supplies, amenities, linen, minibar stock and maintenance parts.
Why are spreadsheets a problem for inventory? They go out of date as soon as stock moves, depend on one person, do not warn you before you run out, and hide wastage.
How do I stop running out of supplies? Keep an accurate, live record of stock levels so you reorder on time. A system that logs every movement, like InzuHub, keeps counts trustworthy.
Is bar and restaurant stock the same as hotel inventory? No. Food and drink sold in a bar or restaurant is separate stock with its own handling. This article covers operational supplies for running rooms.
Ready to ditch the inventory spreadsheet? InzuHub tracks your items, stores and stock movements alongside the rest of your property, in one system. Start your free trial or explore the features.