The method below produces a spreadsheet you can use to find possessions, plan a move, or assemble records for an insurer. Photos help document what was present; a model's description cannot establish purchase details, ownership, or coverage. Keep those facts tied to their own sources.
Choose what your inventory needs to do
Decide why you are making the list before photographing everything. The same kettle needs different supporting details when you are looking for its warranty, packing it for a move, or documenting a loss.
| Purpose | Details to prioritize | Useful completion check |
|---|---|---|
| Find and organize belongings | Current room, cupboard or box, description, quantity, and a clear photo | Another household member can locate the item from its row. |
| Move or put items in storage | Permanent item ID, packing-box ID, destination, and dated condition photos | You can match packed items to their destination without counting the unpacked photos as new possessions. |
| Keep purchase and warranty records | Verified model and serial, purchase date, seller, and order or receipt reference | The recorded model and document both match the physical item. |
| Prepare insurance documentation | Description, quantity, identifying details, records of how you obtained it, and documents supporting the amounts | You can provide the documents your insurer requests and identify facts still missing. |
For insurance use, ask your insurer about its preferred format and documentation requirements early. The US National Association of Insurance Commissioners (NAIC) describes an inventory organized by room or category, with photographs and an export. That is a useful starting structure; requirements elsewhere and for individual policies can differ.
Set aside an initial session of about 35 minutes for one shelf or cupboard, including photography, checking, and saving. Allow more time if counting or finding documents takes longer. A whole-home inventory can take several sessions; the starter estimate does not measure that work.
Write down what the list includes. For a belongings inventory, include furniture as well as small objects, and identify possessions kept in a garage or off-site storage. Keep landlord-supplied items and fixed installations distinguishable from your own belongings. An insurance inventory's scope depends on the policy; ask about those categories rather than treating every visible object as personal property.
Set up the files and spreadsheet
You need a phone or camera, a spreadsheet, and an AI tool that accepts images if you want help drafting descriptions. Use an inventory app instead if it lets you retain item IDs, attach evidence, and export your records. Check those functions with one item before committing your household to the app.
Download the home inventory workbook for an empty inventory, photo log, and field evidence table. Its separate synthetic example reproduces the nine-item shelf illustration used in this guide. The starter ZIP also contains CSV versions, prompts, and a room checklist.
Keep original photos and documents alongside the spreadsheet. A workable folder structure is:
Home-inventory/
inventory.xlsx
photos/originals/
photos/upload-copies/
evidence/
exports/Use room and area codes such as KITCHEN-CUPBOARD-A. For individual items, assign IDs such as HI-0001 that remain unchanged when an object moves. Room-based IDs also work, but preserve the original ID after a move and update the location column. Otherwise you may list the same object twice.
Keep the first pass small
Open the workbook's Inventory sheet and begin on row 5. Columns A through G hold item ID, room, area, description, quantity, count-check status, and photo IDs. Put any unfinished task in Next action, column W. You can hide columns H through V during this first pass. Add identifying details, ownership, and amounts when you need them; empty optional columns do not make the initial room list unusable.
| Field | What to enter | What to avoid |
|---|---|---|
| Description and quantity | A recognizable description and the number physically checked | A precise count copied from AI without checking a stack or an obstructed view |
| Photo IDs | References to overview, detail, or label photographs | A thumbnail with no retained original |
| Brand, model, serial | Characters checked on the actual item, with label-photo references | A brand inferred from color or product shape |
| Owner and how you obtained it | Who owns it and whether it was bought, given, inherited, or borrowed | Assuming every object in your home belongs to you |
| Purchase date and cost | A date and amount supported by a receipt, order, or clearly labeled recollection | A current shop price entered as the original purchase price |
| Replacement estimate | A separately labeled estimate, currency, date, and comparison source | A photograph-based valuation or a promised insurance payout |
| Review date and next action | When you checked the row and the particular fact still needed | A blanket "verified" label that hides an unknown serial or missing receipt |
Use Photo log to connect photo IDs to filenames. Use Field evidence when you add facts from labels, documents, or recollections. Each row in that sheet identifies the item, the particular fact, and where it came from. A physically counted quantity, a model read from a label, and a purchase date remembered by the owner have different sources. "Label checked" confirms label text; it does not confirm the purchase price. Unknown amounts remain blank, with an explanation in Next action or Field evidence. Zero means an actual amount of zero.
Photograph the room without losing the details
Start with an overview that shows where the possessions are. Then photograph each shelf, drawer, or cupboard separately. Open containers that you intend to inventory and can safely handle. A closed box can be recorded as a box, with its contents still uncounted.
- Assign the area code before capture. Put it in your photo log and write it in the AI prompt.
- Take an overview, followed by closer views where small objects overlap. Keep objects in place until you have recorded their locations.
- For an item that needs identification, photograph the whole object, the label's position on it, and the readable label. Keep those views together under its item ID.
- Check the photos on your phone. Retake blurred labels, glare, or a view that cuts off the item you are trying to identify.
- Record the filename, area, capture date, and role of each image in the photo log. Preserve the originals.
An example naming scheme is KITCHEN-CUPBOARD-A-001-overview.jpg, followed by HI-0001-context.jpg and HI-0001-label.jpg after the kettle receives its item ID. The filenames are suggested organization, not evidence of when the photos were taken. Record the capture date separately.
Remove mail, visible access codes, screens, and other unnecessary private details from the scene. When a receipt contains an address or payment details, retain the original privately and use a redacted copy if you need AI to read it. Check the service's current upload, retention, and data-use settings before sending home photos. Use manual entry or a local tool you trust when cloud upload is unsuitable. The AI data-protection guide covers that decision in more detail.
Decide what counts as one item
Choose the counting unit before merging rows. A lamp with its fitted shade can be one inventory item. A drill kit can be one set if you record its included parts. If you list a drill, battery, and charger separately, label their relationship and avoid counting their combined purchase cost again as an additional kit.
For everyday grouped items, write descriptions such as "dinner plates, quantity 8, physically counted." Separate a valuable or individually identifiable item from that group. Do not count a folded pile, a stack of books, or a container's contents from its exterior. Spread out the objects, count them manually, or leave a specific follow-up action.
The Insurance Information Institute's inventory guide supports grouping clothing by category while recording especially valuable items separately. Apply that distinction to your list without forcing every sock or spoon into its own row. A grouped row still needs a checked quantity.
Ask AI for a draft you can check
Use a tool with image input. Start a conversation for one area, attach its overview and necessary detail views, and state which photo ID belongs to each image. Treat several angles as views of the same area. Ask the tool to flag possible duplicates instead of deciding their identity for you.
If the tool cannot open an image, check the file types its upload interface accepts. Export a copy from your photo app in a supported format, retain the original, and inspect the copy before uploading it. If labels become unreadable, take a closer label photo. Begin with one image you can inspect easily before sending a whole room's photographs.
Image analysis can misread small text and return approximate counts, as OpenAI's vision documentation explains. It also describes the possibility of incorrect image descriptions. Supply the area and photo IDs in the message so the returned table can use your references; check quantities and label text yourself.
Paste this prompt with your images:
Help draft a home inventory for one area.
Area: [room and area code]
Image mapping: [photo ID and role for each attached image]
List clearly visible possessions in a table:
Draft row ID | Observed description | Provisional quantity |
Photo IDs | Position in the area | Uncertainty or manual check
Use neutral descriptions. Leave illegible text unknown.
Do not infer brands, models, serials, purchase details, prices,
ownership, working condition, or contents inside closed containers.
Several images may show the same object. Identify candidate duplicate
views and explain the visible match. Do not add their counts together.
If the match or count is unclear, keep it unresolved for my review.
List obstructed areas, uncertain counts, and labels needing another photo.
Report the number of rows separately from provisional item quantity.Check the draft on screen before requesting a file. Delete descriptions unsupported by the photo. If the table is cut off, ask for only the remaining rows using their draft IDs. Do not append a regenerated full table to the first one, which would repeat the rows you already have.
Work through a smaller area when the result contains many missed objects or uncertain counts. For a cupboard full of indistinguishable containers, manual counting may take less work than correcting repeated AI guesses. You can still use AI to turn your checked notes into consistent descriptions.
Keep this table as a draft until you have checked the objects and duplicate views. The transfer instructions below use the workbook's first seven columns, so you do not need to ask AI to fill every optional field.
Give corrections the model can apply
When the physical check changes a row, provide the corrected fact and its ID. "Check again" gives the tool no new evidence. A useful correction says which two draft rows show the same kettle, which photo belongs to it, or what the label actually reads.
Revise only these rows in the approved draft:
[draft row ID]: [correction and the evidence I checked]
Preserve all other rows and photo references. Return a change table
with row ID, old value, new value, and reason, then the revised rows.
Do not fill other missing facts from these corrections.Check the physical items and reconcile duplicate views
Stand in front of the area with the draft open. Point to each item and find its row. Check both directions: every row should have a matching object, and each possession in scope should have a row. A correct-looking total can hide one omitted object and one duplicate.
Use permanent item IDs only after deciding which draft observations refer to the same physical item. Keep the photo log so the multiple views remain attached to that one record.
| Situation | How to resolve it | Result in the master list |
|---|---|---|
| One kettle appears in a wide photo and a close-up | Check its position and the physical object. Confirm both photos show it. | One item, quantity 1, with both photo IDs |
| Two identical cables are on different shelves | Check that both are present. Record their locations or give each its own ID. | Two physical items; appearance alone is insufficient to merge them |
| A lamp moves between two photography sessions | Match the actual lamp and dated views. Record its location change. | One permanent ID with updated location and retained older evidence |
| A label close-up has no visible object around it | Return to the item and capture the label in context. | Keep the label unassigned until the relationship is established |
| A box and its unpacked contents have separate rows | Check the container's role and the item list inside it. | The box may have its own row, but "contents" must not duplicate separately listed objects |
Do not merge solely by description. Two rows called "black charging cable" could refer to two cables; two rows called "blue kettle" and "electric kettle" could refer to one object. The decision needs the physical check, context, or an identifying label.
Keep a coverage checklist for the rooms and storage spaces you still need to visit. Include wardrobes, drawers, garage shelves, loft or attic storage where accessible, and belongings stored elsewhere. Mark each area as photographed, count checked, or still pending. An image with nine detected objects says nothing about unphotographed cupboards.
Move checked rows into the workbook
After resolving duplicates, give the approved items their permanent IDs and tell the tool which quantities you physically counted. Use this export prompt:
Convert only these approved rows to CSV:
[paste the checked rows, permanent item IDs, and photo IDs]
Use this exact header and column order:
Item ID,Room,Area,Description,Quantity,Count check,Photo IDs
Copy only the facts I supplied. Do not add items or fill missing facts.
Quantity must be a number, or blank if the count is unresolved.
For Count check, use Physically counted only where I said I counted it;
otherwise use Image checked only or Unresolved as appropriate.
Put multiple photo IDs in one cell, separated by semicolons.
Quote CSV fields that contain commas or quotation marks.
Return the CSV without commentary inside it.Import the returned CSV into a temporary sheet. Set item IDs and photo references to text, and quantities to numbers. Check one description containing a comma, if present, and compare the IDs and row count with the approved table. If you prefer, copy the displayed table instead and check the pasted columns.
Copy the seven value columns, without the header, into columns A through G at the first empty row of Inventory. Add unresolved tasks in column W. Check that you have not pasted over existing items or added a second copy of a row. The generated CSV supplies these seven columns only; the download's full inventory.csv contains all optional fields. When adding serials later, keep their cells as text and compare them with the original label.
Worked example: the nine-item synthetic shelf
The August 31, 2026 demonstration used an AI-generated shelf image. Its list contains nine loose objects across four shelves; the shelving unit and room fixtures are excluded. The clear spacing makes it easy to follow the example. It does not show how accurately AI would identify possessions in a crowded home.
The original ChatGPT screenshots show nine rows, each with quantity 1. The two cables have separate rows, and the folded textile has a manual-count note. The saved example uses IDs SHELF-A-001 through SHELF-A-009.
| Example item ID | Reviewed description | Shelf from top | Quantity | Fact still missing |
|---|---|---|---|---|
| SHELF-A-001 | Blue electric kettle | 1 | 1 | Brand, model, serial, and purchase or gift record |
| SHELF-A-002 | Yellow cordless drill with black battery | 1 | 1 | Model and any separately recorded kit components |
| SHELF-A-003 | Red flashlight | 2 | 1 | Model and purchase or gift record |
| SHELF-A-004 | White table lamp with beige shade | 2 | 1 | Maker or model; lamp and fitted shade count as one here |
| SHELF-A-005 | Green lidded storage box | 3 | 1 | Contents are not shown |
| SHELF-A-006 | Black cable | 3 | 1 | Connector type and device match |
| SHELF-A-007 | Metal-colored bottle | 4 | 1 | Material and maker |
| SHELF-A-008 | Black cable | 4 | 1 | Connector type and device match |
| SHELF-A-009 | Folded gray textile | 4 | 1 | Physical textile count and material |
The example total is nine. In a real room, unfold a textile pile before establishing its quantity. A model's "high confidence" label cannot replace that check. The downloadable example keeps the quantities and missing facts shown here; it contains no real household or purchase data.
Follow one item from its row to its photo
In the starter ZIP, SHELF-A-WIDE-01 refers to example/synthetic-shelf.webp. For the kettle, these are the entries supported by that illustration:
| Workbook field | Entry for this example | How to check it |
|---|---|---|
| Item ID and description | SHELF-A-001; blue electric kettle | Find the blue kettle on the top shelf of the supplied image. |
| Quantity and count check | 1; Image checked only | This is an illustrated object, so it has no physical count. |
| Photo IDs | SHELF-A-WIDE-01 | A photo-log entry pairs this ID with the image path given above. |
| Brand, model, serial, owner, and amounts | Blank | The supplied image does not establish these facts. |
The workbook's real-inventory and photo-log sheets are blank. If you want to practice this link, use a separate copy and enter the example photo ID and path in Photo log. For your own kettle, add a label reference after checking its label and a receipt reference if you have one. Keep those sources attached to the existing item ID. In Field evidence, a label record can support the model or serial while a receipt record supports the purchase details.
View the original AI screenshots and saved example
Add labels, receipts, and amounts without inventing facts
Check model and serial text against the item before copying it into the inventory. Characters such as 0 and O can be difficult to distinguish. Record an unresolved character explicitly and retake the photo; do not choose whichever spelling resembles a known product. Keep the label's context and close-up linked to the same item.
For purchases, attach the receipt or order record, then identify its relevant line. An order containing several products is not a single item's price. Record discounts or a bundle allocation only when you can explain the amount. If a drill kit has one combined purchase price, keep that amount on the kit record and reference it from the component rows.
Use the evidence table to record a source ID such as DOC-0001, the item ID, the field it supports, and the source file or order reference. The receipt-to-spreadsheet workflow has more detail on checking a transcription against its original.
When you have no receipt
Keep the item in the inventory. Look for order history, a warranty registration, an old photograph, a gift record, or a dated message that supports a particular fact. Write what each source shows. A bank statement can record a payment to a retailer without identifying which product was bought.
If you remember buying the object in a particular year, enter that as an owner recollection with approximate precision. Do not manufacture a day and month to satisfy a date column. Leave the typed purchase-date cell blank and record "owner recalls purchase in 2021" in Field evidence when only the year is known. For a gift or inherited possession, record when you received it in that sheet and leave Purchase date blank unless you separately know the original purchase date.
Separate purchase cost from replacement estimates
Keep the original paid amount separate from a current replacement estimate. For an estimate, record the exact comparable product or quote, the access date, currency, and whether the price includes tax or delivery. Note a meaningful difference in capacity, material, or included accessories. Do not substitute the first visually similar product for a verified model.
The template's amount columns are row totals. For a set or grouped row, enter the amount for everything represented by that row. If an estimate is priced per piece, calculate the group amount from the checked quantity and record the unit price in Field evidence. Do not multiply a completed row total by quantity again. Keep each amount's currency in its adjacent column.
A subtotal is useful only when its quantities, counting units, currencies, and price basis agree. Do not sum a kit price with its separately listed components, combine different currencies, or include unknown amounts as zero. Keep estimates separate from historical costs in any totals you produce.
For jewelry, art, or collectibles, retain identifying details and any existing appraisal. Ask the insurer which documentation and valuation it accepts. Photographing an object does not authenticate it, and a retail comparison may be unsuitable for an unusual or irreplaceable item.
Adjust the method for these household situations
Clothing, books, and kitchenware
Use groups where individual identity adds little to your purpose. Count the group physically, describe its contents, and link a photo showing them. Separate a collectible book, costly coat, or distinctive kitchen appliance when it needs its own documentation. If you later create a separate row for an item, remove it from the grouped quantity.
Electronics, tools, and appliances
Record model and serial from accessible labels. Include a charger, remote, battery, or attachment in the description when it belongs to a set; use separate rows for separately tracked accessories. Note working condition only from a relevant check, with its date. A device appearing intact in a photograph does not establish that it works.
Renters, roommates, and borrowed items
Fill in the owner field before including items in an owner's list. A shared living room may contain your television, a roommate's console, and furniture supplied by the landlord. Keep ownership uncertainty visible and ask the people involved to check their entries. If you are preparing a rental condition record, photograph pre-existing damage and landlord-supplied fixtures separately from your possessions. Ask the insurer about ownership and coverage questions.
Moving house or using storage
Put the current room or storage site in Room, and the packing-box ID and intended destination in Area. Keep the same item ID before and after packing, with Item status set to Packed or In storage. A photo of a closed moving box documents the box; use the checked packing list to identify its contents. On arrival, compare the list and condition photographs, update the location, and change the status to Active. Include off-site belongings with their actual storage location, and check any relevant insurance terms separately.
Gifts, secondhand purchases, and inherited belongings
Record acquisition method and whatever documentation exists. Keep a seller's description separate from an identity you have confirmed. For inherited furniture, family history may describe who passed it to you while leaving its maker and original price unknown. Preserve that history as attributed information. Avoid turning a family recollection into an appraisal.
A large home or a household with limited time
Use a room checklist and finish areas in batches. Record important individual possessions first, then check grouped everyday items and storage spaces. Give each unfinished area a next action such as "open two bedroom drawers" or "count books on lower shelf." This keeps the remaining work visible when you return to it and prevents an overview photo from making a room appear finished.
Rebuilding a list after a loss
Keep a pre-loss inventory unchanged and create a separate working list for damaged or missing items. Distinguish older photos, new damage photos, documents, and recollections. If the objects are no longer available, AI can help organize supplied descriptions, but it cannot determine what an unseen cupboard contained.
The NAIC's claims guidance discusses rebuilding an inventory from memory and older household photographs when records were destroyed. Label those sources honestly and ask the insurer what supporting information it needs. Do not enter a current online product listing as evidence that you owned that product.
Use Image checked only for a count you can support from an older photo, and Unresolved for an uncertain recollection. Record the source and its date in Field evidence. Reserve Physically counted for objects you could actually count.
Fix the problems that make an inventory unreliable
| Problem you can see | Likely cause | Repair |
|---|---|---|
| An object is missing from the draft | Overlap, small size, poor contrast, or an unphotographed area | Check the area physically; add a clearer view and an item row. |
| Several photos inflate the quantity | The tool counted each view independently | Map confirmed duplicate views to one permanent item ID. |
| A precise model appears with no readable label | The description filled an evidence gap | Remove the model and photograph the label. |
| The number of rows matches, but contents differ | One omission cancels one duplicate | Match each row to an object and each object to a row. |
| A serial loses its first zero | The spreadsheet imported it as a number | Reimport that column as text and check the original label. |
| Item links stop working after a folder move | Only the spreadsheet was moved, or links used an old path | Keep a complete evidence folder and test the exported copy's references. |
| A price total looks complete despite missing costs | Blank amounts were treated as zero | Report the missing amounts and total only the known comparable values. |
Save a usable copy and keep it current
Save the workbook and original evidence together. Export the inventory, photo log, and evidence table to CSV when you want records that are independent of the spreadsheet app. A PDF can provide a readable snapshot, but keep the editable source. CSV exports do not contain attached photographs, formatting, or spreadsheet formulas, so include the referenced files as well.
Keep a secure copy away from the property and restrict access to the people who need it. If you use encrypted storage, make sure you can recover access without the only phone or computer kept at home. A backup that depends on a lost device's credentials can be difficult to retrieve when you need it.
Test the copy with a practical retrieval check:
- Open the inventory from the backup location or a second device you control.
- Select an item with a label photo and a supporting document. Find both from its IDs or paths.
- Check its quantity, serial text, and latest review date against the saved source.
- Confirm that the photo log and evidence table were included, along with unfinished-area notes.
Update the record after a purchase, gift, move, sale, or disposal. Keep disposed items marked as disposed with a date so older photos remain understandable. A replacement object gets a new ID even if it has the same model as the old one. For a location change, update the existing item; do not create a second active row. Set a periodic review for rooms that change, and keep the checklist of unfinished areas alongside the inventory.
Before calling an area complete, every included physical item should map to a row, every quantity should be checked or explicitly unresolved, and each supporting file should be retrievable. The last step is to open the saved copy and follow one item all the way back to its photos and documents.
