When a detective asks for the serial number of the stolen laptop and the victim cannot provide it, the case difficulty multiplies immediately. Without a serial number, the property cannot be entered into NCIC. Without an NCIC entry, a pawnshop check cannot be run. Without a pawnshop check, the recovery probability drops to near zero within 72 hours.
The absence of pre-existing documentation is what makes burglary cases go cold. The victim is being asked to reconstruct the identity of items they owned but never formally catalogued — right now, at the moment they are least capable of accurate recall, standing in a house where the back door frame is still splintered.
The Case Number as the Anchor Field
Every item documented in this template connects to a single Case Number. This is the structural decision that makes the database useful to investigators rather than just victims.
When a detective requests the property list for Case 2024-BUR-04812, the filter returns every item documented under that case number: the Black Sony television, the Gray HP laptop, the Gold pendant with a broken clasp, the $240 in cash from the bedroom dresser, the Silver iPhone with a cracked screen photographed before theft and documented as Good condition. Each item has its own record, its own serial number field, its own location-within-the-property notation.
The LOCATION STOLEN FROM field is more useful than it initially appears. A burglary where all items were taken from the master bedroom suggests a different entry point and movement pattern than one where items from the kitchen, the garage, and multiple bedrooms were taken. Law enforcement can use room-of-origin to reconstruct the offender's path through the structure. That information only exists in the property documentation if it was captured field by field, item by item.
The Serial Number Problem and the Photograph Solution
Most victims do not have serial numbers documented before the theft. The Serial Number field in this template is for the exception — the person who photographed their equipment as part of a home inventory, or who kept purchase receipts with serial numbers in a file.
For the majority of cases, the Photo field carries more weight than the serial number field. A photograph of the item, taken at any point before the theft, gives investigators a specific description that the Category + Brand + Model + Color fields alone cannot fully convey. A WATCH flagged as GOLD does not look the same as a specific Seiko Solar Titanium with a scratched crystal at the 7 o'clock position. The photograph closes the identification gap.
The Condition field — Excellent, Good, Poor, Damage — is the pre-theft condition assessment. A television documented as Damage before it was stolen eliminates the victim's ability to claim full replacement value for a unit that was already compromised. It also gives investigators a more specific identifying description if the item surfaces at a secondary market.
Cash, Firearms, and the Multi-Item Reality
The CASH STOLEN boolean flag with a separate CASH currency field handles the category that has no serial number and no identifying photograph. The flag separates the cash claim from the property list while keeping both in the same case record.
The presence of HANDGUN, RIFLE, and SHOTGUN in the item category list reflects the documentation requirement for firearm theft. A stolen firearm that is not properly reported creates a secondary liability. The template captures the item category with space for brand, model, and serial number — which for most legally-owned firearms will be available from the original purchase documentation.
A burglary involving 14 items across three rooms generates 14 separate records in this database, all tied to the same case number. Each record is independent, serialized, photographed where possible, and valued individually. The total estimated loss is the sum of all VALUE fields across the case — not a single round-number figure that an adjuster will challenge on itemization.
The template is designed to be completed alongside the Police Contacts template — the officer's name, badge number, and contact information in one linked database, the property documentation per item in this one. Two structured databases, one incident.