The STR Ledger.
Supply Inventory + Par-Level Restock Calculator cover

OPS-005 · Operations

Supply Inventory + Par-Level Restock Calculator.

Never run out of TP between guests. Per-property consumables tracker with par-level auto-restock for Airbnb / STR hosts. Eliminates the 10pm cleaner emergency. Excel + Google Sheets.

Never run out of TP between guests. Per-property consumables tracker with par-level auto-restock for Airbnb / STR hosts. Eliminates the 10pm cleaner emergency. Excel + Google Sheets. Your cleaner texts at 10pm Saturday: “I’m at the property, no laundry detergent.” Or: “We’re out of paper towels and the next guest checks in at 3pm tomorrow.” Or: “There’s no soap in either bathroom.” These calls happen because nobody’s tracking the consumables. Maybe you do a mental count when you visit, but mental counts forget batteries, dish soap, and the third spare lightbulb. This workbook ends those calls. 80+ pre-loaded items per property. Par level for each (your minimum on-hand). Current count. Anything below par auto-flags on a single restock list, sorted by supplier so you can knock out the order in one batch. WHAT’S INCLUDED 📋 Per-Property Inventory (80+ pre-loaded items) · Paper goods (TP, paper towels, napkins) · Bath consumables (hand soap, body wash, shampoo, conditioner, toothpaste) · Cleaning chemicals (all-purpose, glass, bath, dish soap, dishwasher pods) · Laundry (detergent, dryer sheets, fabric softener, stain spray) · Kitchen pantry (salt, pepper, sugar, coffee, tea, cooking oil, foil) · Lightbulbs + batteries (every common size) · Linens (sheets, towels, pillowcases — counts not consumables but tracked here) 📋 Par-Level Auto-Flag · Below par = appears on Restock List · Lead-time-aware: warns BEFORE running out (current count ≤ par × lead time / use rate) 📋 Restock List Output · Single sortable list, only items below par · Group by supplier (Amazon, Costco, Target, Sam’s Club) · One-click ordering workflow 📋 Bulk-vs-Individual Compare · For each item: $ delta between buying individually vs. in bulk · Saves $200-800/year per property 📋 Cleaner Workflow Tab · Tablet-friendly view your cleaner can update during turnover · Quick-count column (no math, no formulas needed by cleaner)

Get the workbook

Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.

Built by The STR Ledger. Excel templates and PDFs for short-term rental finance.

Visit The STR Ledger