The STR Ledger.
Year-Over-Year P&L Comparison cover

FIN-005 · Finance

Year-Over-Year P&L Comparison.

Did 2026 actually go better than 2025 — or did it just feel that way? Year-over-year P&L comparison spreadsheet for Airbnb / STR hosts. Top-3 favorable + top-3 unfavorable movers per property.

Did 2026 actually go better than 2025 — or did it just feel that way? Year-over-year P&L comparison spreadsheet for Airbnb / STR hosts. Top-3 favorable + top-3 unfavorable movers per property. Excel + Google Sheets. Every January you tell yourself last year was “fine.” But — was revenue actually up? Did expenses creep? Was occupancy flat-but-rate-was-up, or did rate drop and occupancy compensate? Without a side-by-side, gut feel doesn’t survive the spreadsheet. This workbook is the year-end answer machine. Per-property YoY revenue, expenses, NOI, occupancy. $ delta and % delta per category. Top-3 favorable movers (the categories that improved most). Top-3 unfavorable (your action items for next year). WHAT’S INCLUDED 📋 Property Roster 📋 Prior Year tab — paste prior-year P&L (typically from TAX-002) 📋 Current Year tab — paste current-year P&L 📋 Per-Property YoY — revenue, expenses, NOI, occupancy: current vs prior, $ delta, % delta 📋 Top-3 Favorable Movers — the wins to repeat 📋 Top-3 Unfavorable Movers — next year’s optimization queue 📋 Portfolio Summary — aggregate YoY across all properties 📋 Partial-Year Flag — auto-detects properties with partial prior years (don’t draw bad conclusions)

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