The key log, upgraded: from spreadsheet to system of record

Almost every key log starts the same way: a clipboard by the front desk, or a shared spreadsheet with a column for “who has it.” It works right up until it matters — until a resident disputes an entry, a key goes missing, or someone asks what the log said before it was cleaned up.

The problem isn’t effort. It’s the medium. A key log you can edit is a key log no one can lean on. Here’s what changes when you move from a spreadsheet to a system of record.

The trouble with the spreadsheet key log

A spreadsheet is built to be changed. Rows get overwritten, sorted, and tidied; the one entry that mattered is gone, and there’s no way to show what it used to say. Access is easy to fake after the fact, and there’s no built-in link between a key and the person who currently holds it. It answers “what keys do we have?” and ignores the harder question: who has them right now, and who had them before?

What a system of record adds

A system of record treats each key as a physical object with a history, each code as a shared secret with a rotation story, and each handoff as an event worth keeping:

• One continuous history per key and per person, from first issue to final return.
• A real link between a credential and its current holder, not a stale cell.
• Codes and combinations tracked alongside keys — who knows them, when they rotated.
• Exports you can hand to an owner, examiner, or board without reconstructing anything.

Append-only: the history is the record

The core difference is that the record is append-only. You can’t change or delete an event; if something was logged wrong, you record a correction — a new, timestamped entry that references the original. The mistake stays visible, and so does the fix.

That feels heavier than a spreadsheet for about a day. Then it becomes the reason the record is worth keeping: nothing disappears, so nothing is in doubt. It’s also the part examiners and owners actually care about, because there’s no version of the log you could quietly rewrite.

The questions you can finally answer

With a real key log behind you, the hard questions get one-line answers:

• Who holds master key MK-03 right now?
• Who had the vault combination in March, and when did it last rotate?
• Did we retrieve every key when that employee left?
• Can I produce the access history for this unit for the last year?

A pegboard and a spreadsheet can hold your keys. Neither can prove who had them. KeyCustody turns your key log into a record you can stand behind — see it mapped to your keys.