The Invoice Link Field Tells You Everything About What This System Is For
The Invoice link field in this template doesn't store a file. It stores a link to a record in the Documents library — a separate database of categorized files with their own subcategories, dates, and notes. That architectural decision — treating documents as first-class records rather than file attachments on an item — signals exactly what this system is built for: long-term asset accountability across a household where the invoice for a piece of electronics might also need to be referenced by an insurance claim, a warranty dispute, or a tax return.
Most home inventory setups treat documentation as an afterthought. You attach a receipt photo to an item and forget it. This template inverts that. The document exists independently. The item links to it. That means if you buy two items on the same invoice — say a laptop and a monitor in one order — both item records can reference the same invoice document. No duplication. The document record carries its own metadata: category (Invoice), subcategory (Receipt), date, files, images, OCR notes.
The SKU Field and What It Unlocks
Three identifier fields exist on the item record: Model number, Serial number, and SKU. The SKU is the one that gets skipped most often, and it's the one that matters most for resale research.
Serial numbers identify a specific physical unit — they matter for warranty registration, insurance claims, and theft recovery. Model numbers identify a product line. SKU identifies a specific variant: the color, the storage configuration, the regional release. When you're pricing a used item on eBay or Facebook Marketplace, you search by SKU because that's the string retailers index their stock against. You pull it off the box or the manufacturer's product page and record it once. Later, when you're trying to determine current market value of your stored Pokémon merchandise or your Neopets collectibles, you have the exact string that maps to current listings.
The Subcategory field options — Thorny devil, Dragonology, Neopets, Pokémon — reveal this particular household collects within niche categories that have active secondary markets. For those domains, SKU-level precision is the difference between a $12 listing and a $80 one for what appears to be the same item.
Lending Out a Router, Finding the Mess Three Months Later
You lent the spare Wi-Fi adapter to a neighbor in November. You remember this. You do not remember which neighbor, or whether it was the TP-Link AC750 or the AC1200. The item is listed as Electronics in the database, Status: Lending. The Lending contact field links to the Contacts library record — which has address, mobile, email, and a Lending quantity sub-field and Notes. The notes say "borrowed until internet is fixed, estimate two weeks." That was November.
The Contacts library is not a minimal address book. It carries category (Health professional, Real estate, Education, Personal), specialty fields down to Gynaecology and Genetics for medical contacts, role fields, title (Mr/Ms/Dr/Prof), full address with suite and level, mobile, phone, fax, and email. A warranty provider contact isn't just a name and phone number — it's a full record that can accumulate history. When the TV breaks and you need to invoke the extended warranty, you pull the Contacts record for the warranty provider and have their address, the relevant rep's contact link, and any notes from previous service interactions.
The Possession of multichoice field — Venus or Josh — is the shared-household layer. Two people, two sets of assets, one unified database. Filtering by Venus shows only her items. Filtering by Josh shows only his. Joint items get both names. The AUD currency on Purchase cost and Sell price places this system firmly in an Australian household managing assets with resale intent.
The Status list multichoice — For sale, Lending — runs across the full record set. One filtered view gives you everything currently listed for sale, with sell price and sell quantity visible. A household with active resale and lending activity across collectables, electronics, sporting goods, and media can run that view as a live consignment list.