Rental Key Issue Register Excel Workbook

How this workbook can help

• Keep occupant, unit, access-item, issue, and return details in one structured register.
• See issued, returned, and outstanding quantities without calculating each balance manually.
• Monitor return-status totals, return rate, and review prompts from a summary sheet.
• Standardize common entries with editable choices for access items, responsibility, and return status.

What is in the file

How to get started

1. Set the workbook assumptions

Open the Assumptions sheet and confirm the as-of date, follow-up grace period, maximum issue quantity, allowed date range, and dropdown choices.

2. Enter each access-item issue

Use one Key Register row for each occupant and access item. Enter the property, unit, occupant, item type, quantity issued, issue date, responsibility, and return status. Add an identifier, notes, or expected return date when applicable.

3. Record returned items

When an item is received, enter the quantity returned and return date, then select the applicable return status. The workbook calculates the remaining quantity and days open.

4. Check flags and summary totals

Use the Review Flag column to find entries that may be missing required information, contain an invalid input, or need past-due follow-up. Check the Summary sheet for register totals and return-status counts.

What the Rental Key Issue Register Records

The main worksheet uses one row per access-item issue. Each entry can identify the property, unit, occupant, access-item type, identifier or notes, quantity issued, issue date, expected return date, quantity returned, return date, responsibility, and return status.

Prepared choices include Key, Fob, Garage Remote, Mailbox Key, and Pool Gate Key. Responsibility choices include Occupant, Property Manager, Property Owner, and Shared, while return statuses include Issued, Partially Returned, Returned, and Lost/Damaged.

How Calculations Support Daily Tracking

The workbook uses calculated fields for quantity outstanding, days open, and the Review Flag. Quantity outstanding subtracts a valid returned quantity from the issued quantity without producing a negative balance.

When an outstanding quantity remains, days open uses the editable as-of date and issue date. The Summary sheet totals issued, returned, and outstanding quantities, calculates the reported return rate, counts status entries, and displays a chart based on those status counts.

Worked Scenario for a Partial Fob Return

Consider the fictional Unit F-201 example. The input records two fobs issued on June 2, 2026, one fob returned on September 5, 2026, and a Partially Returned status. With an as-of date of September 10, 2026, the result is an outstanding quantity of one and 100 days open.

The interpretation is that one fob remains outstanding. The next decision is to confirm that the partial-return status is still current, contact the fictional occupant if follow-up is appropriate, or update the returned quantity and date if the remaining fob has been received.

Common Entry Errors and Solutions

If the Review Flag reports missing required fields, complete the property, unit, occupant, access item, quantity issued, issue date, responsibility, and return status. The solution is to correct the source entry rather than overwrite the calculated flag.

• For an input-type prompt, replace text in quantity or date fields with an allowed whole number or valid date.
• For a past-due prompt, check the expected return date against the as-of date and grace period, then update the record if circumstances have changed.
• If a dropdown choice is incorrect, select the intended access item, responsibility, or return status from the configured list.

Workbook Limits and Operating Boundaries

The Key Register contains 100 prepared entry rows, from row 5 through row 104. Adding capacity requires extending the formulas, validation ranges, filter range, and Summary references so the additional rows are included.

The workbook depends on accurate and timely entries. Its as-of date is editable rather than automatically tied to the current date, expected return dates are optional, and changing a list label on the Assumptions sheet does not update labels already stored in register records.

Workbook and blank spreadsheet comparison

Use the prepared workbook when its verified fields and calculations fit the task. Start with a blank spreadsheet when you need to design a different model and can build and test every field and formula yourself.

Keeping Register Entries Consistent

Use consistent list labels for access items, responsibility, and return status so the Summary counts remain meaningful. Before changing a choice on the Assumptions sheet, check whether existing records already use the old wording.

Enter return details as items are received, keep the as-of date current for the reporting period, and use the register filter to focus on a property, unit, occupant, item type, status, or review flag.

Frequently asked questions