ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

Home Inventory Spreadsheet

Updated on December 30, 2010

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.

Inventory Sheet Sample
Inventory Sheet Sample

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


    0 of 8192 characters used
    Post Comment

    • Csjun89 profile image

      Csjun89 7 years ago

      It should work the same way! (but it depends on the kind of open office you have too)

    • agvulpes profile image

      Peter 7 years ago from Australia

      I am using Open Office. Will it work the same way?