FEMA Natural Disaster Damage Tracker Spreadsheet | Auto-Calculating Claim Organizer (Digital Download)

Details

Get your recovery organized the way claims reviewers expect — a complete FEMA disaster damage tracker with auto-calculating totals, built for Excel and Google Sheets.

WHY THIS TRACKER BEATS SIMPLE INVENTORY LISTS
Most disaster spreadsheets are a single static list — you type items, do the math yourself, and hope it's enough. This workbook is a complete claim system:
1. FEMA Individual Assistance built in— every row logs the FEMA Claim Category (Temporary Housing, Repair, Replacement, Other Needs) plus Insurance Coverage Status, the two questions every adjustment review asks.
2. Room-by-room with automatic subtotals— 7 pre-grouped room blocks (Kitchen, Bedroom, Bathroom, Living Room, Garage, Exterior, Other). Each block totals itself; a grand TOTAL row sums the whole claim.
3. Vehicle damage section that does the math— Make, Model, Year, VIN (kept as text so all 17 characters survive), pre-disaster and post-disaster value, and an auto-calculated Estimated Loss column.
4. One-page Claim Summary dashboard— pulls live totals from every sheet: property totals, vehicle loss, ALE out-of-pocket, photos logged, plus a claim/policy info block. No data entry — it updates itself.
5. Temporary Housing & ALE tracker— lodging, meals, transportation, storage and more, with claimed / reimbursed / pending / denied totals and estimated out-of-pocket.
6. Photo Evidence Log— match every photo and video to its line item (the item dropdown pulls directly from your inventory), with date taken and description.
7. 100% formula-powered, no macros— live SUM/SUMIF formulas, dropdowns, and currency formatting that work in BOTH Microsoft Excel and Google Sheets.

WHAT'S INCLUDED — 6 READY-TO-USE SHEETS
1. Claim Summary Dashboard
2. Damage Inventory (7 room blocks + subtotals + grand total)
3. Vehicle Damage (VIN + pre/post values + auto loss)
4. Photo Evidence Log
5. Temporary Housing & ALE
6. Instructions & Tips (how-to, FEMA guidance, documentation checklist)
FEATURES• Drop-down menus for Room, Type of Damage, Coverage Status, FEMA Claim Category, and Reimbursement Status • Currency formatting on every cost column • 24+ pre-formatted item rows; add as many as you need • Works on Windows, Mac, and mobile via Google Sheets • No macros, no VBA, no spreadsheet skills required

HOW IT WORKS
Download the zip file, extract files, open in Excel or upload to Google Sheets. Fill in one row per damaged item, pick from the dropdowns, note your photo file names — every total recalculates instantly.

WHO IT'S FOR
Homeowners and renters filing FEMA Individual Assistance applications after hurricanes, floods, wildfires, tornadoes, or severe storms • Anyone documenting damage for homeowners, flood, renters, or auto insurance claims • Preppers building a household inventory before disaster strikes — ten minutes now saves hours during a claim

FAQ
Is this an official FEMA form?
-No — a personal organization tool built around the information FEMA and insurers typically request. You still apply through official channels (DisasterAssistance.gov, FEMA App, or phone).

Does it work in Google Sheets?
-Yes — all formulas and dropdowns carry over.

What software do I need?
-Excel 2016+ or Google Sheets. No macros.

Can I use it for insurance only?
-Absolutely — structured around claim documentation generally.

Will my VIN display correctly?
-Yes — stored as text, no scientific notation.

How does this compare to a single home-inventory list?
-It adds room subtotals, vehicle loss math, photo-evidence matching, ALE tracking, and a live summary dashboard — most store listings stop at a checklist.

PLEASE NOTE
This product is a personal organization template for informational purposes only. It is not legal, tax, or insurance advice, and it is not affiliated with, endorsed by, or a publication of FEMA or any government agency. Disaster-assistance programs, eligibility rules, and deadlines change; always confirm current requirements with FEMA (DisasterAssistance.gov) and your insurance provider. Use of this template does not guarantee approval of any claim.

DOWNLOAD & REFUNDS
Digital download — no physical item ships. Files are available instantly in your Etsy account after purchase. Because this is a digital product, sales are final under standard Etsy digital-item policy; if you have trouble opening the file, message me and I'll help within 24 hours.