Core Fields Every Inventory Should Track
The minimum viable inventory record for each figure needs eight fields: a unique ID number (for referencing in photos and correspondence), figure name and series, edition or variant name, purchase date, purchase price in local currency, purchase source (retailer name or marketplace), current estimated market value, and condition (Mint in Box, Near Mint, Good, Fair). These eight fields give you everything needed for insurance documentation and basic resale preparation.
Beyond the minimum, useful additional fields include: storage location (which shelf, box, or room the figure currently lives in), original packaging status (sealed/opened/no box), authentication status (verified authentic/unverified), acquisition notes (gift, trade, purchase — especially useful for tax purposes if you later sell), and a photo file reference linking to your photo documentation folder.
For collections with international purchases, add a currency column alongside the purchase price column. Currency fluctuations affect the reported cost basis of your collection, which matters for insurance underwriting and any tax reporting if you sell items at a profit. Keep the original purchase currency separate from a converted local-currency column rather than converting at time of purchase and losing the original figure.
Valuation: How to Estimate Current Market Value
Current market value for collectible figures is most accurately determined by checking completed sales on secondary marketplaces, not listed prices. Listed prices represent what sellers hope to get; completed sales represent what buyers actually paid. For common figures, three recent completed sales in similar condition gives a reliable average. For rare variants with infrequent sales, a single recent comparable sale is the best available data point.
Update valuation fields on a schedule rather than continuously — quarterly updates are sufficient for most collections and prevent the spreadsheet from becoming a part-time job. For figures with rapidly changing market values (recent releases, figures associated with trending cultural moments), monthly updates are more appropriate. Mark the date of each valuation update in a separate column so you can see how values have moved over time.
Insurance underwriting typically uses replacement value — the cost to replace an item with an equivalent one in current market conditions — rather than purchase price or sentimental value. If you paid $49.90 for a figure that now trades at $120 on secondary markets, the insurance-relevant value is $120, and your policy should reflect that. A spreadsheet that tracks both purchase price and current market value makes this distinction clear.
Photo Documentation Standards
Each figure in your inventory should have a minimum of four photos: front, back, left side, and any detail shot of a unique or notable feature (a special print, a limited edition stamp, an autograph). Photos should be taken against a neutral background (white or light gray) with consistent lighting — natural window light or a simple LED ring light — to accurately capture paint colors and surface finish.
File photos in a dedicated folder with naming conventions that match your spreadsheet IDs: '0042-duck-bubu-front.jpg', '0042-duck-bubu-back.jpg'. This makes it trivial to find all photos for a specific figure when you need them. Store photos in at least two locations — local device plus a cloud backup — because photo documentation is worthless if the drive fails.
For figures with original packaging, photograph the box from all four sides and the top plus the box bottom (which typically has production date codes and region identifiers). Box condition affects resale value significantly, and having pre-incident photos of box condition is essential for any insurance claim involving shipping damage or environmental damage.
Making Your Spreadsheet Insurance-Ready
Insurance adjusters need to establish the value of a claimed item before issue, not after. An inventory spreadsheet prepared in advance, with dated valuation entries and photo documentation, removes the burden of proof from you at claim time. Without documentation, insurers often settle at a value far below market — sometimes at original purchase price, which can be a fraction of current replacement cost for appreciated collectibles.
Export a PDF of your inventory annually and email it to yourself — this creates a timestamped record that establishes the collection contents and values at a specific date, which is harder to dispute than a spreadsheet file with a modified date. Include the total collection replacement value in the summary at the top of the spreadsheet so adjusters can see the aggregate number at a glance.
If your total collection replacement value exceeds the personal property sublimit on your standard homeowner's or renter's insurance policy (commonly $1,000–2,500 for collectibles as a category), you need a scheduled personal property rider or a specialized collectibles insurance policy. The spreadsheet you've built is the primary document required to apply for either — having it ready means the upgrade process takes an afternoon rather than weeks.