Home Inventory Spreadsheet
Everyone ought to maintain a Home Inventory List to document their home assets for insurance purposes. You don't necessarily need special home inventory software, though. A simple inventory spreadsheet should suffice, so go ahead and download the free Home Inventory template below. If you need more sophisticated inventory management software for your home or small business, try searching the Microsoft Office template gallery or check out our sponsors.
Creating Your Home Inventory
The Inventory Spreadsheet includes some of the common locations and items that you might want to consider when creating your own inventory list. Some of the descriptions in the inventory list, like "Electronics", are just placeholders to remind you to include your electronics. For insurance purposes, it would be better to list each item separately so that you can include the price, serial #, and model # for each item.
Taking photos of your property for your home inventory will make working with your insurance company go a lot smoother. You might even want to do a walk-through video. Now-a-days, most digital cameras have video capture ability, so you could record a quick video clip of each room in your home, and store the video clips and digital photos on a flash drive with your inventory.
When you have completed your home inventory, you should store a paper copy and a digital copy in a secure location outside of your home and/or in a fireproof safe. A safety deposit box or even a locked drawer in your office would probably work for an off-site location.
Home Inventory Spreadsheetfor Excel, OpenOffice, and Google Sheets
(not for distribution or resale)
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
Download our simple inventory spreadsheet, made specifically for listing the contents of your home for insurance purposes.
Keep track of warranty information, purchase price, condition, serial numbers, and model numbers.
Add your comments, tips, and suggestions on the related blog post listed below.
Why Have a Home Inventory? - Detailed information about how to complete your home inventory using the inventory spreadsheet
More Inventory Resources
- Government Resources for Homeowners - Includes information about preparing for disasters
- Home Inventory Worksheet (pdf) - Use this printable PDF worksheet to give you ideas about what you may want to inventory.
- Search for inventory management software, inventory control, inventory system, and inventory spreadsheet on Google.
Inventory Management Software for Your Business
- Asset Tracking Template - Track office equipment, repair equipment, and other valuable assets.
- Software Inventory Tracking Template - Track hardware, software, licenses, expirations, etc.
By searching for an inventory spreadsheet using the form below, you will also find many other templates for inventory management, particularly one created for Microsoft Access.
Excel can be used as a database in the sense of storing and working with tables of information, but inventory control can quickly get too complicated for Excel. You may want to consider either going the Access route, or using other specialized inventory management software.