A short-term rental has two inventories, and it's easy to keep only one of them. The first is the list of what's in the unit: furniture, appliances, the kitchen kit. That one is for insurance and for checking after a guest leaves, and it changes rarely. The second is the stock that gets used up or worn out: linens, toilet paper, soap, coffee, trash bags, batteries. That's the one that causes a bad review at four in the afternoon, and it's the subject here. For each item the list needs what's on hand in the owner's closet, a par to reorder at, and what one costs. Below is a list for a made-up two-bedroom rental, how to set the pars from your bookings, and the file.
The short version
- Keep the furniture list and the supplies list apart. This is the supplies list.
- Count the owner's closet at every turnover, or every week.
- Linen par: sets for each bed, with at least one spare set clean while one is in the wash.
- Consumables par: what the next few turnovers use, before you can shop again.
- Write off stained and worn linen when it's pulled, so the count stays true.
- A cleaner needs the list more than the owner does.
- TaroStack keeps stock by unit and counts it on a phone. More below.
An example list
A two-bedroom rental with two queen beds, counted at a turnover.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Sheet set, queen | set | 6 | 6 | $38.00 | $228.00 | REORDER |
| Bath towel | each | 14 | 12 | $9.50 | $133.00 | OK |
| Hand towel | each | 10 | 8 | $4.25 | $42.50 | OK |
| Pillow protector | each | 8 | 8 | $6.00 | $48.00 | REORDER |
| Toilet paper | roll | 28 | 24 | $0.85 | $23.80 | OK |
| Paper towels | roll | 9 | 8 | $1.60 | $14.40 | OK |
Twelve rows in all, $566.00 at cost, with five to reorder: sheet sets, pillow protectors, shampoo refills, coffee pods and batteries. Nothing has run out. Each of the five is at its par, which is the point of a par: it flags the item while there's still enough for the next guest.
Setting pars
Linens. A par is a number of sets for each bed. This host keeps three sets a bed: one on the bed, one that can be in the wash, one clean in the closet. Two queen beds at three sets is six. At six on hand the sheet is flagged, because the next stain leaves a bed without a spare on a same-day turnover.
| Linen | For each guest or bed | Guests or beds | Sets kept | Par |
|---|---|---|---|---|
| Sheet sets | 1 a bed | 2 beds | 3 | 6 |
| Bath towels | 1 a guest | 4 guests | 3 | 12 |
The figures are this host's own. A rental with a washer and dryer on site and long gaps between guests can hold fewer. Back-to-back bookings and an off-site laundry need more.
Consumables. Work from what one stay uses and how many turnovers happen before you can restock.
| Coffee pods | |
|---|---|
| Pods set out for a stay | 12 |
| Turnovers before the next shopping trip | 4 |
| Par | 48 |
Twelve a stay is this host's choice. The sum is the same for toilet paper, soap refills and trash bags: what a stay uses, times the stays until you shop. With 40 pods on hand against a par of 48, there's enough for three stays and not four, so it goes on the list now.
The difference between a par and a reorder point is in par level vs reorder point, and a worked reorder sum in reorder point example.
Wear, stains and what walks off
Linen leaves the count three ways: it stains, it wears out, or a towel goes home in a suitcase. Pull it and write it off the day it's found, with the reason. After a year the write-offs tell you what a towel really costs you a stay, which belongs in the cleaning fee. A hotel's version of the same problem is in hotel inventory list.
Dates and safety items
A few things have dates or schedules:
| Item | What to record |
|---|---|
| Coffee, tea, anything edible | The best-by date on the box |
| Smoke and carbon monoxide alarm batteries | The day they were changed |
| Fire extinguisher | The date on its tag |
| First aid kit | What was used, and what's expired |
This host changes alarm batteries every September. That's its own schedule: follow the alarm maker's instructions and your local rules.
For the cleaner
If someone else turns the unit over, the list is theirs. Print the count sheet, tape it inside the owner's closet, and have it filled in at every clean. The cleaner sees the closet at every turnover. You may not. A count that takes three minutes at each turnover is what stops the four o'clock message.
More than one unit? Keep one list a unit and a column for the unit's name: the layout is in inventory list format.
Get the list
Download the short-term rental inventory list. Four sheets: inventory with value and REORDER, a sheet for dated items, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
One unit and one closet is a sheet of paper. Three units with two cleaners is three closets, a garage of bulk buys, and a spreadsheet that's updated when a cleaner remembers to text. The sheet says unit B has six sheet sets. Two of them have been at the laundry since Tuesday, and the garage ran out of toilet paper a week ago without anyone noticing, because each unit's closet still looked full.
How TaroStack does it
TaroStack keeps each closet and the bulk store as their own stock.
Stock is held by location: each unit's closet, and the garage.
Transfers move supplies from the garage to a unit, so the bulk count goes down when a closet is refilled. More than one site is on Business.
Counting works on a phone with no signal. A cleaner counts the closet at the turnover, and the count shows what each difference is worth.
A reorder list in days of cover, with each supplier's lead time.
Every adjustment carries a reason: stained, worn, missing.
| The job | Spreadsheet and texts | In TaroStack |
|---|---|---|
| What's in each closet | Whoever last texted | Stock by location |
| What to buy this week | A guess | The reorder list |
| What linen was written off | Unknown | Adjustments by reason |
| What a stay costs in supplies | Unknown | From what each unit used |
TaroStack doesn't manage bookings, guests or cleaning schedules. Stock, counts and reordering are on every plan, from $9.99 a month (50 items). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
