Membership

One membership: every in-depth guide, plus the Deal Workspace. Templates are sold separately and bought once — see below.

All-Access$9.99/mo

Every in-depth guide across Mortgage, Insurance, Investment, Salary, Rent and Budget, plus the Deal Workspace — our per-property case file for tracking a purchase from pre-approval to closing.

  • Every in-depth guide, across every category
  • Deal Workspace — per-property case file, multi-deal comparison, and buying-journey checklist
  • Unlimited saved calculations
  • The full article library, always free
CalculatorByState

Home Insurance Claim Log

$9.99

The record a claim is actually decided on. A claim header block, a contact log with a column for what was promised and whether you followed up, a damaged-items inventory that totals replacement cost against ACV so the recoverable depreciation is a number and not a surprise, an ALE log built around the increase over your normal spending rather than your gross spending, and a milestone tracker with target and actual dates.

Format: Excel (.xlsx)

Look inside

Preview only — scroll to read it. The file you download is fully editable.

Read-only preview of the Claim Log worksheet
Home Insurance Claim Log
A claim is won or lost on the record you keep while it is happening, not on the argument you make afterwards. Fill this in as you go: every call, every item, every receipt, every date. Blue cells are yours; the totals and the claimable-increase column calculate themselves. Pair it with The Home Insu…
Part 1 — Claim header
Date of loss2026-08-14The date the damage happened, which is often not the date you discovered it. Say so explicitly if they differ.
Cause of lossWind — shingles lost, water into upstairs bedroomWind, hail, water, fire, theft, falling tree. Describe what happened, not what you think the policy calls it.
Insurance carrierMidwest MutualThe company on the policy, which may not be the agency that sold it to you.
Policy numberHO-4471902From your declarations page.
Claim numberCL-2026-338714Issued on the first call. Put it in the subject line of every email from here on.
Adjuster nameD. Whitfield (independent)Ask whether they are a staff adjuster or an independent contractor — it changes who you escalate to.
Adjuster phone(512) 555-0184Ask for a direct line, not the main claims number.
Adjuster emaild.whitfield@claims.example.comGet this on the first call. Everything important goes in writing from here.
Deductible that applies to this claim2500Check whether a percentage wind/hail or hurricane deductible applies instead of the flat one on the front page — see the Home Insurance Coverage Audit worksheet.
Date you reported the claim2026-08-15Most policies require prompt notice. Record the date and keep the confirmation.
Part 2 — Contact log
One row per call, email, voicemail, or visit — including the ones where nothing was decided. "What they promised" is the column that matters: a promise with a date next to it is something you can hold someone to, and a claim that goes to a complaint or an appraisal demand is decided largely on this…
DateWho (name & role)MethodWhat was saidWhat they promisedFollow-up dateFollowed up? (Yes/No)
2026-08-15Claims intake — R. OrtizPhoneReported wind damage, gave date of loss and photos taken that dayClaim number issued; adjuster assigned within 48 hours2026-08-17Yes
2026-08-17D. Whitfield, field adjusterPhoneScheduled the inspectionSite visit Thursday 10am2026-08-20Yes
2026-08-20D. Whitfield, field adjusterIn personWalked roof, attic and bedroom; photographed everythingWritten line-item estimate in 7-10 days2026-08-30No
2026-08-22Ridgeline RoofingEmailSent their own line-item estimate for comparisonWill meet the adjuster on site if the numbers differ2026-09-02No
2026-08-26Claims intake — voicemailVoicemailAsked for status on the written estimate2026-08-28No
Contacts loggedƒx
Promises still awaiting follow-upƒxRows where something was promised and you have not marked the follow-up done. This is your to-do list.
Part 3 — Damaged items inventory
Replacement cost is what the item costs to buy today. Actual cash value (ACV) is that figure minus depreciation for age and wear. On a replacement-cost policy the insurer typically pays ACV first and releases the difference — the recoverable depreciation — only after you actually replace the item an…
RoomItem (make / model)Age (years)Original costReplacement cost todayACV estimatePhoto? (Yes/No)Receipt? (Yes/No)
Primary bedroomQueen mattress & box spring614001650990YesNo
Primary bedroomDresser (oak, 6-drawer)9800950430YesNo
Upstairs hallCarpet & pad, 320 sq ft7190024001080YesYes
Primary bedroomDrywall & ceiling repaint0031003100YesNo
RoofArchitectural shingles, 28 sq149800215008600YesYes
0000
0000
0000
0000
0000

Preview shows the first 60 rows. The full worksheet continues for 60 more — the complete worksheet is in the download.

This template is general information, not financial, legal, or tax advice.