Free Hotel Lost and Found Log Excel Template for 2026

How to use the template

1. Review the property settings

Start on Lists & Settings. Enter the property name, property code, workbook owner, default retention review days, aging alert days, high-value threshold, sensitive item review days, and shipping collection target. The workbook contains example assumptions, including a $250 high-value threshold and a 30-day aging alert. Replace them where needed based on your property’s approved procedures.

The same worksheet contains editable lists for found areas, item categories, yes-or-no choices, claim verification methods, statuses, return methods, and disposition methods. These lists supply the controlled entry choices used in the main log.

2. Create one record per item

Use the Lost & Found Log to enter a unique record ID, date and time found, found area, specific location, category, description, identifying details, estimated value, and whether the item is sensitive. Record who found the item, who received it, the date received, and its storage location.

Input cells are white or pale gold. Gray or light-blue cells contain calculations and should not be overwritten. The log is an Excel table with filters on all 37 columns, and the header remains visible while staff move through records.

3. Update claimant and custody activity

Add claimant information only when needed to identify, match, or return an item. Available fields cover the guest or claimant name, contact information, room, event, or site, match date, claim verification, number of contact attempts, and last contact date.

As work progresses, update the current status. Available statuses include Found, Secured, Contact Attempted, Claimed, Return Arranged, Returned, and Disposed. Returned records should include a return date; disposed records should include the disposition method, date, and authorization details.

4. Document returns, shipping, and final handling

For a return, record the method, carrier or courier, tracking or receipt number, shipping cost, amount collected, and date returned where applicable. The calculated Unreimbursed Shipping field shows the difference between shipping cost and the amount collected, with a minimum result of $0.00.

For final disposition, complete the disposition method, disposition date, authorized-by entry, external reference, and notes as appropriate. The External Reference field stores manual reference values only.

5. Review the Dashboard

Use the reporting date and dashboard settings to monitor open-item aging and follow-up. Review open items, records requiring attention, items past the aging threshold, high-value open items, returns this month, return rate, unreimbursed shipping, sensitive items still open, average days open, and total records logged.

The Dashboard also presents status, age-bucket, and category summaries with three charts. A reporting date defaults to the current date but can be replaced with a fixed date for a historical review.

What information should a hotel lost and found log capture?

A useful record should identify what was found, where and when it was found, and who transferred it into property custody. This template includes fields for record ID, date, time, area, specific location, category, description, brand, color or identifiers, estimated value, finder, receiver, receipt date, and storage location.

It also supports the later stages of handling. Staff can document claimant details, claim verification, contact attempts, return arrangements, shipping information, final disposition, authorization, external references, and notes. Keeping these entries in one row creates a complete item history that can be filtered by status, location, category, date, or other recorded values.

How does the workbook identify records needing attention?

Four calculated columns appear at the right side of the Lost & Found Log. Days Open measures elapsed days from the date found to the Dashboard reporting date, return date, or disposition date, depending on the record’s status. Unreimbursed Shipping compares shipping cost with the amount collected.

Data Quality Check identifies missing operational details, including a missing found date, found area, description, receiving employee, or storage location. It also checks whether Returned and Disposed statuses have their corresponding dates. Action Flag uses record conditions and Dashboard thresholds to indicate priorities such as a sensitive item, incomplete information, high estimated value, or aging review.

What does the hotel lost and found Dashboard show?

The Dashboard provides a consolidated view of the Lost & Found Log. Its primary measures include open items, items requiring attention, items past the aging threshold, and high-value open items. Additional measures cover returned items for the reporting month, return rate, unreimbursed shipping cost, sensitive items still open, average days open, and total records logged.

Status counts cover Found through Disposed. Open inventory is also grouped into 0–7, 8–14, 15–30, 31–60, and 61-plus day buckets. Item category counts provide another way to understand the types of property being recorded. These summaries support a regular management review without requiring staff to count rows manually.

How should hotels handle privacy and policy settings?

The workbook instructs users to enter only information needed to identify, store, match, return, or dispose of an item. It specifically advises against entering full payment card numbers, full government identification numbers, device passwords, medical details, or unnecessary personal information. Workbook access and physical-item storage should follow the property’s own privacy, records, and security practices.

Retention periods, value thresholds, contact procedures, release practices, and disposition methods vary by property and situation. The entries on Lists & Settings are editable operating assumptions, not legal requirements. Review them before use and maintain the workbook in line with approved hotel procedures.