Home - Template 69
Home Inventory & Contents Cover Tracker
Know what you own, and whether your policy would actually pay for it.
Microsoft Excel◆Google Sheets◆.xlsx file
Most home inventories are a list of what you own. This one works out what your things would really cost to replace, puts that against the sum insured on your schedule, and tells you the gap in one number. It also finds the thing almost nobody knows about: most policies cap what they pay for any one item unless you list it separately, so it flags every item over your single article limit and gives you the list to send your insurer. It has 26 live charts and room for 300 items, and every limit and rate is yours to edit. It is a spreadsheet, not insurance advice, and it does not promise a claim will be paid.
What's inside · 16 tabs
- Contents Dashboard - the whole picture on one tab, with live charts
- Inventory - 300 rows, 18 columns, dropdowns and colour coded cover status
- Room by Room & Category Analysis - replacement cost, value today and the shortfall per room, and where your money actually is
- Sum Insured & Gap - the shortfall or surplus against your cover, in one number
- Averaging & Claim Model - what a claim of any size would really pay once averaging and the excess apply
- Single Article Limit & Specified Items - every item your policy would not pay in full, and the print ready list for your insurer
- Depreciation & ACV - new for old against indemnity, side by side
- Warranty & Documents - what is still in warranty, and how much of it you could prove
- Claim Pack - pick an event and a room, get the list, the totals and an estimated settlement
- Policy, Renewal Review, Value Trend & Settings - this year against last, when you bought what you own, and every limit yours to edit
In Motion
Are you actually covered?
Add an item or change your sum insured and the gap, the averaging model and the items over your limit all move with it.
Pairs Beautifully With
