Start with what you can count
Put the spare keys you actually hold on a table. If three are accounted for and someone remembers buying four, record three in stock and one unresolved. A receipt for four copies tells you what was cut. It can’t tell you who took the fourth one.
Assign each copy a neutral identifier such as K07. Use the same identifier in the issue log and on its tag. Keep the list that matches tags to doors where only the people responsible for access can see it. An address and door name on the ring would give a finder both halves of the puzzle.
Follow one key through a shift change
Suppose K07 goes to a Saturday supervisor for two weekends. Enter their name, the date you issued it, who approved it and the date you expect it back. Have the recipient acknowledge the handoff. K08 can operate the same door and still have its own borrower and due date.
When K07 comes back, enter the return date and the initials of the person who accepted it. If the next supervisor is standing beside you, close the first entry and open another. Overwriting the old name removes the record of when the key changed hands.
A sheet for the key cabinet
Use a new line for each handoff. You can print the blank sheet below and keep it with the manager’s records. A long-term issue can show “on role change” in the due column. Keep the signed page after its last key comes back.
| Copy ID | Issued to / date | Approved by | Due | Returned / received by |
|---|
If a copy is overdue
Record what you know. “Due Tuesday, return unconfirmed” leaves room for the key to turn up. Marking it returned leaves a security decision hidden in an otherwise tidy ledger. Have the person who manages the premises review which openings the missing copy served, whether the ring identified the location and which other people might need replacement keys.
Keep the date you noticed the missing copy beside the name of the person handling it. When the key comes back or the affected lock changes, add the date and outcome to the same entry. The next manager can then see how the matter ended.