Home Inventory Spreadsheet: Proof for Any Claim

The power went out just after nine, and for a few seconds the only light in the lounge was the storm.

It is Ren here, and I want to start with that feeling, the one where you sit in the dark and your mind does a quick, useless inventory of the room you can no longer see.

The television. The laptop charging on the bench. The good speaker. The tools in the garage you keep meaning to lock away.

If a tree had come through the roof that night, could you have listed it all, with what each thing cost to replace, from memory?

Almost nobody can, and that gap is exactly what a home inventory spreadsheet is built to close.

"An ounce of prevention is worth a pound of cure." — Benjamin Franklin

🔦 Why your memory is the worst inventory you own

Your memory is the least reliable record of what you own, and a claim is the worst possible time to find that out.

After a fire, a flood or a break in, the insurer does not ask how you feel. They ask for a list: what was taken or destroyed, when you bought it, and what it costs to replace today.

People sit down to write that list and freeze. The mind keeps the furniture you look at every day and quietly drops everything else.

Then the small things start adding up in your head, far too late.

• The cordless drill and the half kit of bits in the garage.
• The winter coats, the boots, the spare doona in the cupboard.
• The kitchen drawer of gadgets you replaced one by one over years.
• The kids' bikes, the scooter, the camping gear in the shed.

Please do not be hard on yourself if this is you. The whole point of writing it down once is that you never have to hold it all in your head at all.

What a home inventory spreadsheet should include

A home inventory spreadsheet should include one row per item and a small set of columns that an assessor actually uses.

Keep it boring and consistent. The value is in completeness, not in clever formatting.

The columns that matter are the ones that turn a memory into evidence. A room and an item name on their own are easy to wave away. A serial number, a purchase date and a photo reference are not.

Why replacement cost is the column that pays

Replacement cost is the single column that decides whether a claim leaves you whole or out of pocket.

Most contents policies, unless you choose otherwise, settle on actual cash value. That means the depreciated price, what the item is worth now after years of use, not what a new one costs.

Here is the part almost nobody writes down until it bites. Picture a television you bought for $1,950 about six years ago.

On an actual cash value basis it might be valued at $400, because it is old. A replacement cost policy pays what an equivalent new set costs today, which could be $1,500 or more.

That one item carries an $1,100 gap between the two ways of valuing it. Now repeat that across the fridge, the laptop, the washing machine and the lounge, and the gap becomes the difference between replacing your life and partly replacing it.

A spreadsheet does not change your policy, but it makes the choice visible. When the replacement cost column is sitting there in front of you, totalling itself up, you can see whether your sum insured is high enough and whether you are paying for the right kind of cover.

How much is actually sitting in your home

The amount of value in an ordinary home is almost always higher than the owner's gut estimate.

I tested this on myself. I sat down and tallied a fairly ordinary three bedroom place from memory, room by room, before I checked a single receipt.

It landed near $62,400, and that was the conservative pass. The number I would have blurted out if an insurer had asked me cold was closer to $35,000.

That gap, between the guess and the count, is underinsurance in one sentence. It is also why the tallying itself is worth as much as the finished list. You cannot insure to a number you have never actually added up.

Where high value items need their own line

Some belongings are not covered the way the rest of your contents are, and a home inventory spreadsheet is where you catch that before a claim does.

Most policies set a single item limit on contents, and a separate, lower sub limit on categories like jewellery, watches, bikes and collectables. Anything above that cap is only paid up to the limit unless you have listed it specifically.

So the engagement ring valued at $6,000, the road bike at $4,500, the camera kit, the good instrument: these often need to be named on the policy as specified items, each with its own agreed value.

In the sheet, give them a flag column or a tab of their own. When an item is worth more than the typical sub limit, mark it, note the valuation, and check whether your policy actually lists it.

Photograph the valuation certificate for those pieces too, not only the item. If you ever need to prove an agreed value, the document carries as much weight as the object, and that one habit turns a nasty claim time surprise into a line you sorted months ago.

🛠️ How to build a home inventory spreadsheet in one sitting

You can build a usable home inventory spreadsheet in an afternoon by walking the house once with your phone in hand.

1. Set up the columns first. Make room, item, replacement cost, serial or model, purchase date and photo reference your headings before you start filling rows.
2. Walk the house room by room. Start at the front door and move through each space in order, so you cover the whole home without doubling back.
3. Photograph as you go. Take a wide shot of each room and a close shot of serial plates on anything electronic, then note the filename in the photo column.
4. Enter replacement cost, not what you paid. For each item write what a new equivalent costs today, checking a current price for the big ones.
5. Total it and store a copy off site. Sum the replacement column, then keep a copy in the cloud or email it to yourself so it survives the very event you are insuring against.

Keep the inventory beside the budget that pays the premium

The Ultimate Budget System gives you one tidy place to track what you own, what you owe and what the cover costs, with 28 connected tools, a bill calendar and twelve auto-populated months. One time $37, lifetime use, no subscription. Trusted by over 76,000 customers.

Get the Ultimate Budget System →

🧹 Mistakes that quietly sink a contents claim

• Listing what you paid, not what it replaces. Fix it: put today's new price in the replacement column, and update it when prices jump.
• Keeping the only copy on the home computer. Fix it: store a copy in the cloud or your inbox so it outlives a fire or theft.
• Photographing rooms but never the serial plates. Fix it: capture model and serial numbers on electronics, the detail an assessor leans on.
• Doing it once and never touching it again. Fix it: add new big purchases the day they arrive, while the receipt is in your hand.

An inventory values what you own at full replacement, which is a different job from tracking your overall wealth. If you also want the bigger picture of assets against debts, the net worth spreadsheet takes the same items and values them as part of what you are worth, rather than what they cost to replace.

🎯 Your action steps this week

• Open a blank sheet and add the six columns before you do anything else.
• Walk one room tonight, the lounge or the kitchen, and fill every row.
• Photograph the serial plates on your three most expensive electronics.
• Check your policy to see whether it pays replacement cost or actual cash value.
• Fold the running costs into a home purchase spreadsheet or your budget so the premium has a home of its own.

💬 Common situations

If you have just moved into a new place

Moving is the easiest time to build a home inventory spreadsheet, because everything you own passes through your hands in boxes. As you unpack each room, list the items straight into the sheet and note replacement costs while the recent prices are fresh. You finish the unpacking and the inventory in the same week, instead of promising to do it one day.

If your contents are spread across a house, a garage and a shed

Outbuildings are where inventories fall apart, so give the garage and the shed their own rooms in the sheet. Tools, bikes, camping gear and garden equipment add up fast and are common theft targets. Walk them with the same camera and the same columns, because a claim assessor treats a stolen mower no differently from a stolen laptop if you can prove it was there.

If you rent rather than own your home

Renters need a contents inventory just as much as owners, because the building cover your landlord holds does not touch your belongings. Your clothes, electronics, furniture and kitchen gear are all yours to replace if something goes wrong. A simple spreadsheet of what you own, with replacement costs, tells you how much contents cover to take out and proves the claim if you ever need it.

The lights came back on that night before anything happened, and the room filled back in around me, every familiar thing exactly where it had been.

The list just means I never have to find it in the dark again.

To your financial freedom,
Ren

This article is for general information only and is not financial advice. It does not take into account your personal situation, needs or objectives. Please consider speaking with a qualified financial adviser before making financial decisions.