Evidence and Property Room Software: What Happens When an Auditor Asks You to Prove the Shelf Matches the Log

The shelf that does not match the log

A property custodian is three days into an audit. The list says item 2014-0912-03, one firearm, shelf 14 bin C. Shelf 14 bin C holds two items and neither is a firearm. Somewhere in the intervening decade the gun moved to the safe during a range inspection, went to the lab, came back, and was placed in a different bin by an officer covering the room while the custodian was on leave. There is a paper transfer for two of those movements. The third exists only in someone's memory, and that person retired.

Nothing was stolen. The evidence is in the building. That is not the point, because the record is the evidence, and a chain with a gap in it is the thing a defence attorney needs. Property custodians carry this personally in a way few public employees do: the audit findings have their name on them, and the items in question are firearms, narcotics and cash.

The room is full of things you are not allowed to throw away

Most property rooms are past capacity, and the reason is not intake volume. It is disposition. Getting rid of an item requires knowing the case status, the retention period under state statute for that offence class, whether an appeal is live, whether the owner can be found and notified, and in the case of narcotics and firearms, a court order authorising destruction. Each of those facts lives somewhere else: the records system, the court, the prosecutor's file, a letter in a drawer.

So the practical outcome in agency after agency is that nothing leaves. The room fills with items from cases closed fifteen years ago, and the custodian spends their time on the intake side because the disposition side requires research nobody has funded. Then the department leases a storage unit, which is a facilities decision made because of a data problem.

The mass purge is the highest return feature in this entire category. A system that can identify every item eligible for disposition today, group them by the disposition path they require, generate the notices and the court order requests in batches, and record the outcome, converts a research problem into a scheduled process. Agencies that get this working recover shelf space in months and stop paying rent on their own history.

Where Tracker Products SAFE, FileOnQ and Porter Lee BEAST stop

These are specialist products from companies that understand property rooms, and for many agencies they are the right answer. Their limits are worth naming precisely.

• Retention rules as configuration versus as code. Statutory retention varies by offence class, by state, and changes with legislation, and it interacts with appeal status and court orders. Products handle the common cases. The gap tends to appear in the combinations, and the workaround becomes a custodian's spreadsheet of exceptions.
• The physical room. Your location scheme reflects a building that grew: a main room, a bulk storage cage, a freezer for biological evidence, a vault for narcotics and currency, temporary lockers on two floors, and an off site container. Products model locations. Whether they model yours, including chain of custody through a temporary locker that an officer used at 3am without a custodian present, varies.
• Case awareness. Disposition depends on case status, and case status lives in the records system, the prosecutor's system and the court. Most property products know a case number as a string. Automatic disposition eligibility requires a live connection to what happened to the case.
• Audit method. Sampling audits, full shelf audits, high risk category audits and change of custodian inventories are different procedures with different evidentiary weight. Products support inventory counts. Producing a defensible audit report matching your accreditation standard is often assembled by hand afterwards.
• Evidentiary durability. This record has to be readable and provable years later, and the question of what happens if you leave the vendor deserves an answer before you sign rather than during a transition.

What a custom build has to include

Start with the item and its events. Every item is a chain of immutable events: received from this officer at this time, moved to this location by this person, released to the lab, returned, released to owner, destroyed with this witness. Append only, no editing of history, corrections recorded as new events with a reason. This design is not a preference. It is what makes the record survive a challenge, and it is the single most important decision in the build.

Then the location model, built to your actual building including temporary lockers, and a barcode scheme that works on the labels you can actually print and scan in a cold vault with gloves on. Barcodes on locations as well as items, so a move is two scans rather than a typed field.

Then the disposition engine. Retention rules by offence class and item type, driven by case status pulled from the records system, with holds for active appeals, court orders as tracked objects with their own status, owner notification with proof of service, and batch generation of everything that requires a signature. Firearms, narcotics and currency get their own paths, with the two person controls and count reconciliations your policy requires.

Then audits. Random sampling by risk category, full inventories, change of custodian counts, each producing a report in the format your accreditation body expects, with discrepancies tracked to resolution rather than noted.

Finally, integration back to the case, so the detective can see what property exists on their case and the prosecutor's discovery obligations can be met without a phone call to the property room.

What it costs and how long it takes

Our delivery experience here: a first release at $70,000 to $150,000 in 10 to 16 weeks covering intake, barcoded item and location handling, the chain of custody event model, transfers, court order tracking and audit sampling. A full platform at $180,000 to $400,000 over 6 to 12 months adds the statutory retention and mass purge engine, specialised firearms, narcotics and currency workflows with two person controls, lab submission and return tracking, owner notification and release scheduling, records system integration and the accreditation reporting set.

Cost drivers particular to property rooms: converting the legacy log, which is frequently a mix of a old database, paper cards and a spreadsheet, and where the honest question is whether historic items get converted with full history or as opening balances with their paper file referenced. Hardware, since scanners, label printers and any radio frequency identification you want for shelf reads are real procurement and real integration. The number of physical sites. Whether the records system will expose case status, because without it disposition eligibility stays manual. And a physical reconciliation, because a new system launched against an inaccurate inventory inherits the problem you were trying to fix.

When buying is the right call

Buy if you hold a modest inventory in one room with one custodian and your disposition backlog is manageable. The specialist products are mature, they will be cheaper than a build, and your effort belongs in the purge programme instead.

Buy if your agency is joining a county or regional property function, since a shared room needs a shared system and the agencies involved will not agree on a custom scope in a useful timeframe.

Build when your disposition logic depends on case status you can pull from your own records system, which turns a research problem into an automated one. Build when you operate several storage sites with different security levels and the movement between them is where your chain breaks. Build when your accreditation body wants audit evidence your current tool assembles by hand. Build when you have already been through a transition and lost history, and you have decided the record should be yours. And build when the room is physically full, because the mass purge engine is where the money is and it is the part off the shelf tools handle least well.

How to choose a developer

Ask whether history is editable in their design. The only acceptable answer is that chain of custody is append only, corrections are new events with a stated reason, and nothing about the past can be silently changed. If they describe an edit screen with an audit log, they have built an inventory system and it will not survive cross examination.

Ask them to walk through an officer placing an item in a temporary locker at 3am with no custodian on duty, and how custody transfers when the custodian empties it the next morning. The answer tells you whether they have been in a property room or read about one.

Ask how disposition eligibility is determined and where case status comes from. If the answer is that the custodian marks it, the purge backlog will still be manual and you have bought a nicer log.

Ask what hardware they have driven. Label printers, handheld scanners and radio frequency identification readers are physical devices in cold rooms with gloves involved, and the difference between a vendor who has done it and one who has not is measured in weeks of frustration.

Ask who owns the code and the data, in writing before kickoff, and ask specifically what an export of the full chain of custody looks like. At Digital Heroes it is yours from the first commit. Before you commission anything, run a sample audit: pull thirty items at random from your log and find them physically. The discrepancy rate you get back is the number that funds this project.