Home Inventory Spreadsheet for Insurance: Document Every Room in a Weekend

The reason to build a home inventory is unpleasant enough that most people never get to it: at some point, someone may ask you to list everything you owned, from memory, shortly after losing it.

People are bad at this, and not because they are careless. Try it now — name every item in your kitchen. You will get the stand mixer and the coffee machine and miss the twenty-two things underneath them that together cost more than either. That gap is not a memory failure. It is what an undocumented claim looks like, and it is the difference between a settlement based on what you can prove and one based on what you can recall while your house is on fire.

The fix takes a weekend and produces two useful things: a document that speeds up a claim, and a total value that tells you — often for the first time — whether the coverage you are paying for is anywhere near the value of what is in the building.

The Seven Columns That Do the Work

An inventory is not a list of belongings. A list is what you have in your head already. What makes it insurable is the columns.

The last two are where inventories quietly succeed or fail, because they answer different questions and most policies pay on only one of them.

Current value — actual cash value, in policy language — is purchase price minus depreciation. Replacement cost is today’s shelf price for an equivalent item, ignoring age. The Insurance Information Institute’s worked example is a tree falling on an eight-year-old washing machine: a replacement cost policy buys you a new machine, an actual cash value policy pays a fraction of one because the old machine had eight years on it.

So an inventory with only one value column can only ever check half your policy. Record both. It is one extra estimate per row and it is the entire basis of the coverage check at the end of this article.

Two more columns earn their place: a photo reference (a filename or folder name, so the row points at an image) and receipt location (a drawer, an email folder, a cloud folder). Neither is the evidence itself. Both tell you where the evidence is, which is what you need when someone asks.

Working Room by Room

The mistake is starting with a whole house. Start with one contained area — a single closet, the small-appliance cupboard, the garage shelving. Triple-I recommends exactly this in its guide to creating a home inventory, and the reason is momentum: the first area is the only one that feels impossible.

A working method, roughly 30–45 minutes per room:

1. Photograph the room wide, from two corners. Context shots prove the room existed as described.
2. Open everything and photograph again — drawers pulled out, cupboards open, wardrobe doors back. Closed storage is where undocumented value lives.
3. Close-up anything with a serial number: electronics, appliances, tools, bikes, instruments.
4. Then sit down and type the rows. Do not type while standing in the room; you will document six items thoroughly and abandon the rest.

Renting rather than owning changes very little about the method and quite a lot about the coverage side, because a renters policy has no building to derive a contents limit from — you pick the number off a menu instead. What to document in an apartment, and the questions to ask before renewal.

Group small identical things. Forty-one kitchen items does not mean forty-one rows for forty-one forks — it means “cutlery set, 8-place, stainless” as one row with one value. Precision matters on the expensive and the identifiable. Everything else needs a fair number and a photograph.

Three areas are consistently under-documented, and all three are expensive:

• The garage. Tools, bikes, lawn equipment, the ladder, the compressor. Bought one at a time over fifteen years, and collectively often the highest-value room in the house.
• Closets. Coats, boots, luggage, handbags. Nobody thinks of a wardrobe as an asset until they are asked to replace it in one go.
• The home office. Multiple screens, a chair that cost more than it looks like it cost, a printer, a docking station, backup drives.

A Worked House: 214 Items, and What the Totals Said

Here is a full three-bedroom household, documented over two weekends. Values are illustrative — the point is the shape of the result, not the specific numbers.

Three things fall out of that table that no one in the household could have told you the week before.

The garage is the second most valuable room in the house. $19,100 to replace, ahead of the living room, ahead of the kitchen. It is also the room with the fewest receipts and the most items bought individually over a decade. Ask this household to list their possessions from memory and the garage would have come out at maybe $4,000.

Current value is less than half of replacement cost. $41,900 against $96,300. That single ratio is the most important thing an inventory produces, because it is the gap between what an actual cash value settlement pays and what re-buying your life actually costs. On these numbers, an ACV policy leaves a $54,400 hole in a total loss. The full comparison, and how to tell which one your policy uses.

Purchase price is the least useful column of the three. $84,600 is a number about the past. It is worth recording because it is the only figure you know for certain and it anchors your depreciation estimates — but never quote it as your coverage requirement. It is below replacement cost and above current value, which makes it wrong in both directions.

The Coverage Gap: What the Totals Are Actually For

Now pull up your policy declarations page and find the personal property limit — usually Coverage C on a homeowners policy.

This household’s limit was $75,000, set as 50% of a $150,000 dwelling coverage figure. Nobody chose it. It was a default, calculated from the structure of the building, and it had never been checked against a single thing inside the building.

Against a documented replacement cost of $96,300:

$96,300 − $75,000 = $21,300 underinsured.

That is the number the whole weekend exists to produce. Not a feeling that you “should probably have more coverage” — a figure, from your own rows, that you can take to your agent. How to work the required number out from your own inventory, and what the percentage-of-dwelling default gets wrong.

Then check the sub-limits, which is the second thing the declarations page will tell you. Policies routinely cap specific categories far below the headline personal property limit — jewellery and watches, firearms, cash, silverware, business property in the home. A ring appraised at $8,000 inside a policy with a $1,500 theft sub-limit on jewellery is not covered for $8,000 no matter what your inventory says, and the fix is a scheduled endorsement, arranged before the loss. The NAIC’s consumer guide to homeowners and renters policies is the clearest neutral explanation of how those limits sit inside a policy.

Where the Inventory Lives

An inventory stored only on the laptop in the house it documents does not survive the event it was made for.

Three copies, in this order of usefulness:

1. Cloud storage — the spreadsheet plus the photo folder. This is the one that will actually be there.
2. Somewhere off-site and physical — a copy at a relative’s house, or a safe deposit box, which is what Triple-I suggests for the inventory and any appraisals.
3. Emailed to yourself. Crude, effective, and dated by the mail server, which is itself a small piece of evidence about when the record was made.

The date matters more than people expect. A record created before a loss is evidence. A list assembled afterwards is a claim. Keep the original and update it rather than rewriting from scratch, so the history stays intact.

Storing the file inside the building it documents is one of a short list of failure modes that turn a carefully-built inventory into a useless one — along with a single value column, skipping closed storage, and never updating it. The seven mistakes, and a ten-minute audit to check yours.

While You Are In Every Room Anyway

An inventory weekend puts you in every cupboard in the house, which is the cheapest possible moment to do three related jobs. This is why the preparedness side and the inventory side belong in one file rather than three.

The document index. Birth certificates, passports, deeds, titles, wills, policies, immunisation records. Not what they say — where they are, plus where the digital backup is, plus what expires when. Every household believes it knows this and roughly a third of the entries turn out to be wrong.

The emergency kit. Water, food, first aid, light, power, tools. The kit-specific problem is not buying it, it is that half of it expires: water, batteries, medication, food. A checklist with an expiration date per line and a status that flips to LOW or NEEDED on its own is what turns a kit bought once into a kit that still works in year three. Ready.gov’s supply list is the standard starting set, including the separate vehicle kit most people skip.

The maintenance schedule. HVAC filters, smoke detectors, CO detectors, gutters, water heater, dryer vent. Partly a cost question and partly an insurance one — a claim denied for lack of maintenance is a real category of denial, and a dated log of what was done and when is the cheapest defence against it.

Start With One Closet

Do not open a blank sheet and try to describe a house. Pick a single closet, photograph it, log what is in it, and put values in both value columns even if the estimates feel rough. Half an hour.

Then do the garage — because it is the room the numbers always surprise people on, and because once the garage total appears, the rest of the house feels like arithmetic rather than an ordeal.

The finished totals are worth having even if nothing ever happens. Most households discover they are underinsured by a number large enough to justify a phone call, and the call takes ten minutes.

Featured on ReadySheetGo

Emergency Preparedness & Household Inventory Tracker — $14.99

Eight tabs, built exactly as above. The Home Inventory logs every item by room with description and model, serial number, purchase date, purchase price, estimated current value, replacement cost, a photo reference and where the receipt lives — totalling by room and for the whole house as you type. The Insurance Summary holds your policy details and runs the coverage gap analysis, setting your documented home value against the personal property coverage you actually bought. The Emergency Kit tab arrives with 33 supply items pre-loaded, tracking quantity needed against quantity on hand with an automatic READY / LOW / NEEDED status and expiration dates for the things that go stale, plus a vehicle kit section. Important Documents is pre-populated with 26 critical records, each with a physical location, a digital backup location and an expiry date. Emergency Contacts, a Family Emergency Plan with meeting points and utility shut-offs, and a Maintenance Schedule with 24 recurring tasks and automatic overdue alerts complete it. The Dashboard returns total items, total purchase value, current value, replacement cost, kit readiness percentage, maintenance status and your insurance coverage gap.

Conditional formatting throughout — green ready, amber due soon, red overdue or missing. Works in Excel and Google Sheets, no macros and no add-ons.

Get the Emergency Preparedness & Household Inventory Tracker →

This is general information, not insurance advice — coverage terms, limits and sub-limits vary by policy and by state, so confirm yours against your own declarations page or with your agent.

Sources: III — How to create a home inventory · III — How is the settlement amount determined? · NAIC — Understanding your homeowners or renters policy · Ready.gov — Build a kit