Free Key Sign-Out Sheet Template

A key sign-out sheet records who took a key set, who issued it, when it is due back, and who received it on return. Each checkout and its return share one row. Blank return fields show which checkouts have no recorded return and need checking.

Above the log: office or site, reporting period and timezone. Use YYYY-MM-DD dates and 24-hour times in one agreed local timezone.

Completed example

Fictional example, reviewed at 16:00 on 2026-09-25. All times use the same office-local timezone.

• KR-101 came back before its deadline, and the full set was received.
• KR-102 is still out at the review time. Its return fields are blank because no return has been recorded, not because the row is finished. It isn't due until 17:00.
• KR-103 came back late, at 13:20 against a 12:00 deadline. It has been returned, so it isn't overdue now. The note records the lateness.

How to use the sheet

1. Check the key-set ID on the tag and the expected contents before anything leaves storage.
2. Record the named borrower, who issued the set, the time out and the agreed return deadline.
3. On return, check the key count first. Then record the return time and who received it.
4. Next time the set goes out, use a new row. Don't reuse or overwrite an old one.

Handling exceptions

• Onward handover. If the borrower passes the set to someone else, record it on a separate handover record or a linked entry. Don't record a return to storage that didn't happen.
• Overdue keys. Contact the recorded holder and arrange the return or an authorised extension.
• Deadline changes. Keep the original deadline readable. Add the new deadline, who approved it and when.
• Missing key on return. Record the discrepancy in Notes instead of closing the row as a complete return. Then follow your organisation's process and contact your authorised property or security contact.
• Reported return not found. Write down that the borrower reports returning it, separately from confirmed receipt. Leave “Return received by” blank until someone actually has the set.
• Corrections. On paper, strike through the incorrect entry with a single line and add your initials and the correction date, leaving the original readable. In a spreadsheet, record the original value, correction, reason, editor and time in a correction note or log; use version history where available.

Don't write access codes, alarm codes or unnecessary personal details on the log. Keep completed logs where only the people who need them can see them.

Sign-out log, key inventory and handover record

• Sign-out log (this sheet): individual movements and returns — a key control log of who had what, and when.
• Key inventory or register: the key sets you hold and their details. See the key register spreadsheet template.
• Handover record: a transfer between two named people. See the key handover checklist.

To check the log and register against what's actually in storage, see how to audit physical keys.

When a spreadsheet is enough

If one office holds a small number of sets, keys mostly leave and come back through the same desk, and one person reviews the sheet every day, a paper or spreadsheet key log template works well. It's cheap, familiar and easy to start.

When shared software helps

A shared spreadsheet can give several people access to the same log, but the team still needs a consistent process for keeping holder details, deadlines and handovers current. Dedicated key-management software can make those steps part of the workflow. In KeyDocket, the whole team sees the same register and the recorded holder of each set. A handover only changes the holder once the recipient accepts it, and every checkout, handover and return is kept in the set's history. KeyDocket records what people log. It doesn't track where keys physically are, and it can't guarantee who is holding them.

Opening the files in Excel or Google Sheets

• Excel: open the .xlsx directly. The headers stay visible as you scroll, the date columns show YYYY-MM-DD HH:MM, and it prints landscape on one page width.
• Google Sheets: choose File → Import → Upload and select the .xlsx or a CSV. There is no native Google Sheets template; importing creates your own copy.
• CSV: plain text with the same columns, for importing anywhere. It has no formatting or column widths.

Frequently asked questions