STR Utility Usage Tracker – Monthly Bill Anomaly Detector (Excel/Sheets)

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)

═══════════════════════════════════════════
COMMON ANOMALY PATTERNS
═══════════════════════════════════════════

· **Water bill 2x normal** = leak (toilet, dishwasher, irrigation). Call plumber today.
· **Electric bill 1.5x normal in shoulder season** = HVAC running with windows open OR pool heater stuck on
· **Internet bill creeping up annually** = ISP rate hikes; shop alternatives every 24 months
· **Propane consumption spikes** = tank gauge wrong OR theft (yes, this happens)

═══════════════════════════════════════════
WHO THIS IS FOR
═══════════════════════════════════════════

· STR hosts running 1+ properties
· Multi-property operators tracking utility burden
· Hosts in seasonal markets where consumption varies
· Operators preparing for tax-season Schedule E Line 18 documentation

═══════════════════════════════════════════
FILE COMPATIBILITY
═══════════════════════════════════════════

✅ Excel 2016+ · ✅ Excel 365 · ✅ Google Sheets

═══════════════════════════════════════════
REFUNDS
═══════════════════════════════════════════

14-day refund, no questions. hello [!at] thestrledger.com.

═══════════════════════════════════════════

⚠ Digital product. Anomaly thresholds are guidance — adjust per your typical seasonal pattern.