Catch leaks, unmonitored loads, pricing changes — before next month’s bill. Utility usage + trend tracker for Airbnb / STR hosts. Per-property × per-utility 12-column matrix with YoY anomaly flags. Excel + Google Sheets. Your water bill triples in February. By the time you notice in March, the running toilet has cost you $1,200 and the floor below has water damage. Or your electric bill creeps up gradually for 12 months as the HVAC unit slowly fails — you only catch it when the AC dies in July. This workbook turns utility bills into early-warning signals. Per-property × per-utility 12-month matrix. $/night metric. YoY trend. Anomaly flag when a month’s bill jumps >25% vs prior year — catches leaks, unmonitored loads, and supplier rate hikes before they compound. WHAT’S INCLUDED 📋 Property Roster + utility provider per service 📋 12-Column Monthly Bill Matrix (electric, gas, water, internet, trash, propane) 📋 $/night per service (utility cost ÷ booked nights that month) 📋 YoY Trend per utility 📋 Anomaly Flag (>25% YoY jump = red) 📋 Leak / Load / Pricing-Change Detection (3 most common patterns)
Related
- Dynamic Pricing Calculator
- Insurance Policy Tracker
- Competitor Rate Tracker
- Cleaning Cost per Turnover Tracker
- Year-2 Operator Bundle
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.