Built by Richard Vaughn, CPCU, ARM, AIS — 35 years in commercial lines P&C, workers' comp TPA founder, and independent insurance consultant.

Post-Loss Contents Inventory

After a fire, flood, or theft, the carrier will ask for an itemized contents inventory. This workbook calculates depreciation and actual cash value the way adjusters do and tracks the recoverable depreciation you can claim after you replace each item.

Excel Coming soon

Who it is for

Homeowners and renters with an open contents claim, public adjusters, and anyone helping a family member through a loss.

What is inside

  • Item rows with description, quantity, age, replacement cost, useful life, depreciation percentage, actual cash value, and recoverable depreciation formulas
  • Useful-life reference table by category with editable values
  • Room and category subtotals
  • Replacement tracking columns for recoverable depreciation
  • Notes on how ACV settlements work and the deadline to claim recoverable depreciation
AI prompt pack: fill this template with ChatGPT or Claude

Paste the prompt below into ChatGPT or Claude together with your own documents (declarations pages, certificates, P&L, contracts). It is written to return results in this template's column order.

You are a property claims adjuster. I will paste my list of damaged items with approximate age and replacement cost. Using the useful-life table in my Post-Loss Contents Inventory, calculate depreciation and actual cash value for each item and total the recoverable depreciation. Flag any item where the age exceeds the useful life.

Check anything an AI tool returns against the source document before you rely on it. The prompt is a starting point, not a substitute for reading the policy.

Questions

How is depreciation calculated?

Age divided by useful life, applied to replacement cost, usually capped so an item never depreciates to zero. The workbook uses a useful-life table by category that you can edit, and shows the percentage for each item so you can challenge it.

What is recoverable depreciation?

On a replacement cost policy, the carrier pays actual cash value first and the withheld depreciation after you replace the item and submit proof. The tracking columns record what you replaced and when so you can claim it before the policy deadline.

Can the adjuster use their own useful-life figures?

Yes, and they often do. Having your own calculation itemized gives you a basis to negotiate instead of accepting a lump sum.

What if I cannot remember what I paid?

Use the current price of a comparable item as replacement cost and estimate the age. The inventory is a sworn statement in substance, so be honest and mark estimates as estimates.

Related templates

Home Inventory

A room-by-room inventory you can complete in an afternoon with your phone. Each sheet captures item, quantity, purchase date, cost, estimated replacement cost,...

Excel FreeFree

Proof of Loss

A sworn proof of loss is a formal statement of your claim, signed under oath. This free document explains what it is, why the policy deadline matters, how to...

Word FreeFree

Diminished Value Letter

After a repair, your car is worth less than an identical car that was never wrecked. This generator builds a demand letter to the at-fault driver's insurer and...

Free online generator Coming soon$9

Free insurance tools

Use the letter generators in your browser, or download the free home inventory and proof-of-loss guide.

Browse free tools