THE SHORT ANSWER
Track enough information to prevent shortages and repeated emergency purchases.
For each supply, record a consistent item name, category, unit, current quantity, minimum quantity, reorder amount, storage location, normal vendor, last purchase date, and recent unit cost. Keep equipment and reusable tools on a separate tab because maintenance and replacement are different from restocking consumables.
A spreadsheet works when one person owns the count and updates it on a predictable schedule. It will not stay accurate if products leave storage without any routine for recording or recounting them.
THE ESSENTIAL COLUMNS
Build the inventory around a reorder decision.
Item ID, clear product name, category, and the unit you actually count.
Current quantity, minimum quantity, reorder status, and target quantity after purchase.
Main storage location and any vehicle or team kit where additional stock is kept.
Vendor, package size, last purchase date, recent unit cost, and preferred substitute if appropriate.
Primary use, dilution or handling reference, and where the current safety information is kept.
Person responsible for counting, ordering, receiving, and resolving differences.
SEPARATE THE STOCK
Use categories that match how the business purchases and stores supplies.
Products measured by bottle, gallon, container, or refill.
Gloves, liners, paper products, pads, sponges, filters, and other regularly replaced items.
Mops, buckets, brushes, dusters, extension tools, and caddies.
Vacuums, extractors, steamers, chargers, and other items that need serial, condition, or maintenance records.
Standard quantities assigned to a person, route, vehicle, or location.
SET THE REORDER POINT
Base the minimum on usage and delivery time.
The minimum quantity should cover normal usage until a replacement order can arrive, plus a small buffer for variation. A product used on every visit needs a different minimum from a specialty product used twice a month.
Review the minimum after busy periods, vendor delays, a service change, or repeated emergency purchases. Do not increase every minimum automatically; excess stock can expire, leak, take space, and hide unnecessary purchasing.
THE CONTROL ROUTINE
Use one short cycle every week.
- Count priority supplies.
Start with items that stop work when unavailable.
- Compare with the minimum.
Mark only items at or below their reorder point.
- Check open orders.
Avoid purchasing the same item twice because an earlier order is still in transit.
- Receive and update.
Confirm the delivered quantity, condition, cost, and storage location.
- Review unusual usage.
Investigate spills, product changes, new services, or counting errors without blaming workers.
WHEN A SPREADSHEET BREAKS
Upgrade when stock moves faster than the file can be trusted.
Consider a dedicated inventory system when several locations hold stock, multiple people issue and receive items, equipment assignments matter, purchase approvals are required, or the spreadsheet is consistently behind reality.
Before changing systems, clean the item names, units, categories, storage locations, and vendor records. Disorganized data does not become reliable simply because it moves into an app.