Home and property

A valuables schedule: jewellery, electronics and art with bills

A home valuables list for insurance with columns for purchase date, bill reference and photo, plus how to total and update it once a year.

Editorial illustration for A valuables schedule: jewellery, electronics and art with bills

A valuables schedule is a table listing each high-value item you own with its purchase date, the bill reference, the amount paid, a photo and where it is kept. Built once and updated yearly, it saves you from reconstructing a list from memory after a theft, a fire or a flood, and it is the first thing an insurer or adviser will ask for.

What columns should the schedule have?

ColumnWhat to put
ItemShort name, for example gold necklace, laptop
TypeJewellery, electronics, art or other
Purchase dateDate on the bill
SellerShop or seller name
Bill referenceBill or invoice number
Amount paidRupees, as on the bill
Photo fileThe file name of the item photo and the bill photo
IdentifierSerial number, IMEI, hallmark detail or certificate number
LocationWhere it is usually kept

How do you photograph each type?

  • Jewellery: photograph each piece on a plain surface, add a close-up of any hallmark, and photograph the bill and certificate if there is one.
  • Electronics: photograph the item, the serial number label on the back and the warranty card.
  • Art and decor: photograph the work, the back with any label or signature, and the invoice or certificate.
  • Anything inherited with no bill: photograph it and write a short note on how you came to own it.

Keep the photos in one cloud folder and name them the same way as the schedule rows. Name a photo with the item and the date, so a row in your sheet and a file in the folder can be matched at a glance.

What does a filled-in schedule look like?

Say your schedule has three rows. These numbers are only an illustration.

ItemTypePurchase dateAmount paid
Gold necklaceJewellery12 Nov 2023₹1,85,000
LaptopElectronics4 Jan 2025₹68,500
Framed paintingArt20 Aug 2022₹24,000

The total is 1,85,000 + 68,500 + 24,000 = ₹2,77,500. In a sheet with amounts in column F from row 2 to row 200, =SUM($F$2:$F$200) gives the total, and =SUMIFS($F$2:$F$200,$B$2:$B$200,"Electronics") gives the electronics total. The amount paid is what you paid, not necessarily what it costs to replace today. Ask your insurer how it values each type.

Where do the bills come from?

For items you bought recently, the bill is in your records already. If you keep your records in SpendixAI, attach the bill photo to the transaction when you import the statement, so the payment and the bill sit together, and you can look them up from the schedule's bill reference. For older items, look for emailed invoices and warranty cards. If a bill is missing, note that and photograph the item with any identifying marks.

What about items with no bill?

Gifts, inherited pieces and things bought years ago often have no bill. Do not leave them off. Give each a row, write Gift or Inherited in the bill reference column, and add a line about who gave it and when. A clear photo and a short story are weaker than a bill but far better than nothing. If an item is valuable, consider asking a jeweller or an expert for a written valuation, and keep that paper with the photo.

How often should you update it?

  • When you buy something valuable, add the row that day.
  • When you renew your home policy, check the schedule against the sum insured and the valuables clause.
  • Once a year, check that the photos are still in the folder and the locations are right.
  • When you sell or give away an item, mark it rather than deleting the row.

A closing checklist

  • Every item over a value you choose has a row.
  • Each row has a bill reference or a note explaining why not.
  • Photos named to match.
  • A total worked out and compared with the contents sum insured.
  • A copy stored away from home.
SPENDIXAI JOURNAL

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

Explore your reports