Home Inventory Spreadsheet
From my previous hub, you should have a good working idea on
how to create spreadsheets for your home inventory, if not have already created
one. It should look something like the picture here, which was a possible end
product from the previous guide that you might have seen. If you look below you can see it has the columns automated for the numbering as well as some filled in areas here and there for an easy start.
Now, we’ll see how to make the spreadsheet into something more useful for you. We will turn the sample inventory sheet into a home inventory spreadsheet!
Firstly you would still need to make the sheet, at least for the numbering area so you know how many items you have in your home.
After that, instead of using the one in the template usually provided, you have to spend some thought deciding what labels you want to give for the items inside your home inventory.
Instead of say value of good, as you might put in a
warehouse inventory, you would probably want to put the cost of the good when
you purchased it. You might want to check your receipt before inputting this
into your inventory spreadsheet. Thus you also won’t need things like wholesale
price and retail prices. A serial number is still helpful in case you want to
replace the good in the future and you want an exact replacement. The inventory rate may help too.
Also, instead of the date the good enters your inventory, you might consider changing it to the date of purchase.
Remember to save your data from your inventory spreadsheet software every step of the way so as not to lose it during system or data failure scenarios.
In your data cells, you would also probably want to include the location of the item in your home, whether it is found in the kitchen, or in your living room or etcetera. If you have two of the same things in two different places such as TVs in two rooms, then it might be wise to separate them as two different items altogether. Try to group similar objects together in a recognizable category which would help organisation.
Keep in mind this is different from a sample inventory report as well as from retail inventory