Electronic inventory management

Work out which of the two you are actually doing

If the thing you are counting is consumable and gets reordered, you are keeping an electronic record of stock and the useful outputs are variance, value and a reorder point. If the thing you are counting is a device with a serial number and a holder, you are running an electronics inventory and the useful outputs are location, custody and disposal. Mixing them into one list gives you a list that answers neither well. A business can genuinely need both, and the honest answer is then two lists with one count calendar rather than one list with twice the columns. The cost of keeping them apart is a second sheet; the cost of merging them is that every report has to be filtered before it means anything.

For an electronics inventory, start from the control frameworks

Both of the widely used control catalogues open on the same requirement: an inventory of the assets on your network. The reason it comes first is blunt. Patching, access control, encryption and monitoring are all unenforceable on a device nobody recorded, so the inventory is not paperwork around security, it is the precondition for it. There is a second reason to start there even if no auditor is coming: the frameworks describe the fields you will wish you had captured. Asset owner, network address, whether the device is authorised, and a disposal record are all in the control language, and all four are the ones businesses add late and backfill painfully.

Record custody as a first-class field

For devices, who has it is more valuable than where it was last seen. Custody is the field that makes a leaver's checklist work, that makes a loan to a contractor recoverable, and that turns an annual reconciliation from an archaeology exercise into a list of six people to email. Custody also changes what happens when a device is damaged. A list that records who had it turns an argument into a conversation about replacement, and a list that does not turns every breakage into an unassignable cost that quietly lands in the same budget line every year.

For an electronic stock record, keep the entry and the arithmetic together

The advantage of the electronic version over paper is not storage, it is that the consequence appears immediately: counted against expected, the gap priced at your own cost, the reorder distance shown while the person is still at the shelf. A record that defers all of that to a monthly report has kept the worst property of paper.

Give every device a disposal route before you need one

Electronics leave the business as often as they arrive, and an asset that vanishes from the list without a recorded disposal is indistinguishable from one that was stolen. The federal personal property rules are a reasonable model to copy for a private business: identify it, see whether anything else in the business needs it, then dispose of it and record which. Disposal is also where data protection and inventory meet. A device leaving the business carries whatever was on it, so the disposal record should say what happened to the storage as well as to the hardware, and the inventory line is the only place that fact will ever be findable afterwards.

Reconcile the discovery scan against the walk, and keep the disagreement

Network discovery finds what is switched on and connected. A walk finds what is in a drawer, in a bag, or at somebody's kitchen table. Neither is the truth on its own, and the interesting number is the size of the gap between them. Overwrite one with the other and you have destroyed the only measurement the exercise produces.