This is an inventory spreadsheet that is created to help you record any detail information regarding all of your family belongings in your house. By building and maintaining this list, you can easily get the detail of your item when you need it. For example, you can easily track which items that can be insured, or already insured or which item that was stolen if something bad happened to your house.
By having this list, you can easily manage your items when you are moving to other house or apartment. And if you plan to sell several of your items you will easily estimate the price based on the item depreciation value.
It may seem difficult at beginning to start recording all of your inventory, especially when you have a big house and all items spreading everywhere. But, it will be better to start making the list before you regret it later.
You can follow the flow in this spreadsheet to start recording your item. I created this sheet with assumption to record items room by room. It is easier for me to do that. And I don’t write one by one for item like MP3, CDs, and books. I just try to generalize them.
The inventory consist of three worksheets:
Item Pool Worksheet
This is a worksheet to put your item name and description, so you can just select from the dropdown list in your home inventory worksheet.
This is a worksheet to put your category of your item and depreciation year of your category.
And this is your inventory list worksheet where you can put all of your item here. You don’t have to allocate some rows in the worksheet if you want to spare some item in some rooms. Since this is just a raw inventory list. Just type your item sequentially. You can process this inventory list in other worksheet based on your needs later.
There will be some improvement in next version. Or you can modify the template based on your needs. You can download the file here.