FNOL through settlement. Recovery $ vs deductible. Lessons learned. Insurance claim log for Airbnb / STR hosts tracking claims against your underlying property insurance (separate from Airbnb AirCover — see OPS-002 for that). Excel + Google Sheets. Storm damages your roof. Or a guest causes $8K of damage that AirCover denies. Or a pipe bursts when nobody’s there for 48 hours. The claim process drags on for 90+ days, the adjuster low-balls the estimate, and by month 4 you’ve forgotten what was approved when. Then the next claim hits, and you’re rebuilding the file from scratch. This workbook tracks insurance-claim lifecycles cleanly. FNOL through settlement. Recovery $ vs deductible. Per-claim photos + adjuster notes + correspondence log. Lessons-learned column for preventive cadence updates. WHAT’S INCLUDED 📋 Property Roster + each property’s policy info (carrier, policy #, deductible, limits) 📋 Per-Claim Lifecycle Log (FNOL → Investigating → Approved → Denied → Settled) · Date of loss, incident type (storm / fire / theft / plumbing / liability / other) · Adjuster name + contact + inspection date · Claim # + estimate + settlement amount · Net recovery (settlement − deductible) 📋 Days-to-Settlement KPI — rolling average; >60 days = pressure carrier 📋 Recovery Rate — total settled $ ÷ total claimed $; <60% = evidence is weak 📋 Per-Property Claim History — surfaces “hot” properties (2+ claims in 3 years) 📋 Lessons-Learned Column — preventive maintenance updates
Related
- Insurance Policy Tracker
- The Damage Claim Log
- Maintenance Log + Vendor CRM
- Depreciation Tracker (Full MACRS)
- Per-Diem Meal Deduction Tracker
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.