A home inventory is a sheet with one row per item, grouped by room: what it is, the brand, the year you bought it, roughly what it is worth as you remember it, and a reference to its photo. Make it room by room, with one wide photo of each room and one close photo of anything valuable. It helps with repairs and warranties today, and with any insurance conversation later.
Which columns does the inventory need?
- A: Room. B: Item. C: Brand and model.
- D: Purchase year. E: Serial number, where there is one.
- F: Approximate value in rupees, as you recall it.
- G: Photo reference, which is a file name or folder.
- H: Notes: where the bill is, warranty end, condition.
What does a filled example look like?
The items and values are made up for the example.
| Room | Item | Purchase year | Approx. value | Photo |
|---|---|---|---|---|
| Kitchen | Mixer grinder | 2023 | ₹4,000 | kitchen-mixer.jpg |
| Kitchen | Microwave | 2022 | ₹9,000 | kitchen-microwave.jpg |
| Living room | Television | 2024 | ₹32,000 | living-tv.jpg |
| Living room | Sofa | 2021 | ₹25,000 | living-sofa.jpg |
| Bedroom | Air conditioner | 2023 | ₹38,000 | bedroom-ac.jpg |
| Bedroom | Wardrobe | 2020 | ₹15,000 | bedroom-wardrobe.jpg |
How do you total it by room?
With rooms in column A and values in column F, a SUMIF adds up one room at a time. It works in Excel and in Google Sheets.
- Kitchen: =SUMIF($A$2:$A$200, "Kitchen", $F$2:$F$200), which gives ₹4,000 + ₹9,000 = ₹13,000.
- Living room: =SUMIF($A$2:$A$200, "Living room", $F$2:$F$200), which gives ₹32,000 + ₹25,000 = ₹57,000.
- Bedroom: =SUMIF($A$2:$A$200, "Bedroom", $F$2:$F$200), which gives ₹38,000 + ₹15,000 = ₹53,000.
- Whole home: =SUM($F$2:$F$200), which gives ₹13,000 + ₹57,000 + ₹53,000 = ₹1,23,000.
The spelling of the room name must match exactly, so pick a name and stick to it.
How should you take the photos?
- One wide photo per room from the door, with all the furniture in view.
- One close photo per valuable item, showing the brand label.
- One photo of each serial number label.
- Open cupboards and drawers and photograph what is inside, for items you cannot see otherwise.
- Name the file with the room and the item so it matches the sheet.
What does the approximate value mean?
It is only your own recollection of what the item cost or what you think it is worth now, and it is not a valuation. Mark the column heading as your estimate. If you ever speak to an insurer, they decide what documents and values they need, so ask them, and use your sheet as a starting list, not as proof.
How often should you update it?
Once a year is enough, with a quick update whenever you buy or give away something significant. Do it with your warranty review, so both lists agree. If a purchase also appears in your spending record, SpendixAI keeps the receipt with that transaction, which makes the bill easy to find when you update the inventory.
Do you have to list everything?
No. Start with what would be costly or painful to replace: electronics, appliances, furniture, kitchen equipment, musical instruments, good clothes and any collection. Group small items into one row, such as kitchen utensils and steel set, with a single photo. A list you finish beats a perfect list you abandon after the first room, and you can return to the other rooms when you have time.
Getting started this weekend
- Pick one room and finish it before the next.
- Photograph first, then fill in the rows.
- Add the bill location for anything with a warranty.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


