Justin McLemore

Asset tracking

Screenshot of Google Sheet with columns like status, manufacturer, description, model, etc.

Use template

The spreadsheet contains placeholder text. This is not my real information.

It’ll help you determine how much personal property coverage you need for your belongings. You’ll also be grateful you made one if you ever have to file a claim with your insurance provider. Not only will it help you remember exactly what you have in your home should you lose multiple items in a break-in or a house fire, but it’ll also ensure you can get the full value of your items when filing a claim.

ColumnDescriptionExamples
StatusActive, Ordered, Lost
ManufacturerEntity that created the assetSony, Oral-B, KitchenAid
DescriptionAn easy way to identify an asset-
Model Number-
SerialUnique identifying number-
ClassificationBroad asset categoryElectronics, House, Travel
TypeSpecific asset categoryAppliance, Headphones, TV
QuantityNumber of the same asset-
Date PurchasedDate the asset was purchased2025-03-31
CurrencyIf bought in another countryEUR, USD, GBP
ValuePrice before discounts or savings150.00
CostPrice after discounts or savings100.00
VendorEntity that sold the assetCostco, Sony, Currys
Country PurchasedIf bought in another countryUnited States, United Kingdom
WarrantyWhether the asset comes with a warrantyTRUE
ReceiptLink to an electronic copy of the receipthttps://drive.google.com/file...
Buy me a croissant