Shopping

A home inventory with photos: a simple room-by-room list

A home inventory list with photos: room by room, with item, brand, purchase year, approximate value as you recall it and a photo reference, plus a SUMIF total.

Editorial illustration for A home inventory with photos: a simple room-by-room list

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.

RoomItemPurchase yearApprox. valuePhoto
KitchenMixer grinder2023₹4,000kitchen-mixer.jpg
KitchenMicrowave2022₹9,000kitchen-microwave.jpg
Living roomTelevision2024₹32,000living-tv.jpg
Living roomSofa2021₹25,000living-sofa.jpg
BedroomAir conditioner2023₹38,000bedroom-ac.jpg
BedroomWardrobe2020₹15,000bedroom-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?

  1. One wide photo per room from the door, with all the furniture in view.
  2. One close photo per valuable item, showing the brand label.
  3. One photo of each serial number label.
  4. Open cupboards and drawers and photograph what is inside, for items you cannot see otherwise.
  5. 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.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports