An Excel workbook (XLSX) for short-term rental hosts, B&B and guesthouse owners. Describe each property (beds, guests, bedrooms, bathrooms, laundry method, days between guest changes), list your linen with how it is counted and its replacement cost, type in what you own, and the workbook calculates the par level of every item (in use + clean ready + in the laundry + spare buffer), a shopping list with cost against your current stock, and a wear and replacement planner. A BLANK workbook and a DEMO workbook with fictional data are included in English, Italian, Spanish, French and German.

The problem it solves

Linen is bought by guesswork: too few sets and a same-day changeover goes wrong, too many and money sits in a cupboard. Nobody knows how much is really missing, or when towels will wear out.

Who it is for

Hosts, B&B and guesthouse owners and small property managers who run one or more rentals and want to know how many sheets and towels to own and when to replace them, in desktop Excel.

What you get

• Par level per item and per property: pieces in use + clean pieces ready + pieces in the laundry + a spare buffer you choose
• Count each item per bed, per guest, per bedroom, per bathroom or per property, with the number of pieces per unit
• Home or outsourced laundry: the sets away at once follow your turnaround days and the days between guest changes
• Shopping list per property and in total: pieces to buy against your current stock, with the cost of the list and pieces held above par
• Wear and replacement planner: washes left, months until replacement, an estimated date and the yearly replacement cost
• Dashboard with totals and a calculator that breaks down any one property item by item
• Complements the Check-in / Check-out & Inventory Kit, which counts objects, and the Welcome Basket & Guest Amenity Cost Tracker, which tracks consumables
• All files in English, Italian, Spanish, French and German; start from the BLANK workbook or learn first with the DEMO

How you use it

1. Download and unzip, open the folder of your language and try the DEMO workbook first.
2. Open the BLANK workbook in desktop Microsoft Excel and save a working copy. In Setup, check the laundry turnaround days for home and outsourced laundry, the spare buffer and how many clean sets you keep ready.
3. In Properties, add one row per rental: bedrooms, beds, guests to plan for, bathrooms, laundry method, days between guest changes and guest changes per year.
4. In Linen, list your items with how each is counted, pieces per unit, replacement cost and planned life in washes. In Stock, count what you own today.
5. Read the Dashboard and the Shopping List for what to buy, and the Wear Planner for what to replace and when.

Questions