A Printable Lock Bank and Turnover Pool Record for the Site Log
This lock bank and turnover pool worksheet is a printable control record for facility managers managing smart-lock units after award but before, during, and after a door turnover. It links each physical unit to its door, variant, custodian, condition, issue history, and evidence. The blank quantities are intentional: your operating data and risk criteria set the pool, while this sheet records decisions and exceptions without inventing a planning assumption.
Direct answer. Condensed to the essential point, lock bank and turnover pool worksheet turns a request into a decision record. lock bank and turnover pool worksheet and lock-bank-and-turnover-pool are the two parts of lock bank and turnover pool worksheet most often skipped. A lock bank and turnover pool worksheet is the operating-life view. It starts after the invoice. lock bank and turnover pool worksheet is the first interval of lock bank and turnover pool worksheet to measure.
lock bank and turnover pool worksheet is defined in this article by lock bank and turnover pool worksheet. It is used as a working definition of lock bank and turnover pool worksheet only. Any regulatory reading belongs to the authority and the product in the destination market.
Print one controlled master per site and one issue card per checkout. Treat a unit as ready for issue only after identity, door-fit, condition, and documentation checks are complete. A box, delivery note, or purchase record alone does not show that a unit is serviceable.
Use the same object identifiers throughout handover, replacement, and monthly review. Add event records rather than overwriting the original installation entry, so an auditor can reconstruct which unit was present, which unit left stock, and who approved each status change.
Control boundary: what the stock record covers
Classify every physical unit once, then move it between states only when the corresponding evidence is attached. A serial number marked as quarantined cannot also count as ready to issue, even when its packaging remains intact.
| Working state | What it means | Minimum evidence before the next state |
|---|---|---|
| Installed reference | The unit is recorded against an installed door | Door object ID, serial number, accepted installation record |
| Ready to issue | The unit is physically held for a planned or likely substitution | Identity, condition, door-fit and documentation checks |
| Quarantined | The unit has an unresolved condition or identity question | Fault or exception record, custodian, evidence reference |
| Return pending | The unit has been approved for a return or supplier review | Disposition approval, return reference, custody transfer |
| In transit | The unit has left one controlled location but has not been received | Dispatch record, carrier reference, receiving owner |
| Retired from pool | The unit will not return to issue stock | Disposition decision, retained evidence |
The master register is an inventory, not a service-level forecast. It should expose discrepancies between what the team believes it holds, what the site can physically locate, and what the records show. Keep “not checked” separate from “passed,” and record an unknown condition as an exception rather than entering a zero. What can be supplied is listed in the smart door locks.
For model and variant fields, use the unit label or the accepted catalogue entry. Any procurement decision that depends on dimensions, power arrangements, accessories, communication method, or credential capability must be tied to the exact SKU.
CONFIRM-PER-SUPPLIER: Confirm the exact SKU, variant, included components, dated product-page references, and any approved substitution before a unit is marked ready to issue.
Spare lock inventory register and unit identity
The spare lock inventory register uses one row per physical unit, not one row per product type. Give the unit a stable object identifier that remains with it through installation, issue, quarantine, return, and retirement. A room number is useful in the door schedule, but it cannot identify stock.
| Object ID | SKU and variant | Serial number | Working state | Home location | Custodian | Date received | Door class | Evidence reference | Last event |
|---|---|---|---|---|---|---|---|---|---|
| LB-001 | Enter | Enter | Enter | Enter | Enter | YYYY-MM-DD | Enter | Enter | Enter |
| LB-002 | Enter | Enter | Enter | Enter | Enter | YYYY-MM-DD | Enter | Enter | Enter |
| LB-003 | Enter | Enter | Enter | Enter | Enter | YYYY-MM-DD | Enter | Enter | Enter |
Apply these field rules when completing the register:
- Object ID: Use a site-controlled sequence that cannot be confused with a door, work order, or purchase order.
- SKU and variant: Record what the physical label identifies. Do not infer the variant from the outer carton alone.
- Serial number: Transcribe the full identifier and compare it with the physical unit before issue.
- Working state: Use one of the states defined in the control-boundary table.
- Home location: Name the cabinet, cage, store, or accountable holder rather than writing “stock.”
- Custodian: Record the team responsible for physical control, not merely the person who entered the row.
- Door class: Identify the intended door class or application group without implying that every unit in that class is interchangeable.
- Evidence reference: Point to the dated product page, delivery record, inspection, or approved disposition.
- Last event: Give the date and event reference that explains the current row.
During unit serial number reconciliation, match the number on the physical label, the issue card, the installed-door record, and the monthly count. Matching product descriptions do not resolve a serial mismatch. Keep rejected or superseded labels with the relevant event record so that the history remains readable.
Do not erase a unit row when the unit leaves stock. Change its state, location, and last event; the checkout record then explains the movement. This preserves a continuous chain for every serial in the pool.
Door fit compatibility check before a unit enters issue stock
A correct SKU is only the starting point for substitution. The replacement must also fit the door and work within the accepted operating arrangement. Record the door-fit compatibility check separately for each unit and door because a stock class is not proof of physical suitability.
Use the Office Smart Lock Site Survey to connect stock decisions with measured site records. Where a lock is being added to an existing opening, the Smart Lock Retrofit Site Survey provides the appropriate place to retain door geometry and installation constraints.
| Check | Evidence to retain | Record before issue |
|---|---|---|
| Identity | Label photograph or controlled inventory record | Serial and SKU agree |
| Door geometry | Site survey or door schedule | Required measurements match the accepted door class |
| Swing and handing | Door schedule or site observation | The unit is not being treated as a left/right substitute without evidence |
| Strike and interface | Existing-hardware record | The lock body, cylinder, or accessory arrangement is accepted for that opening |
| Power arrangement | Installation or accepted site configuration record | The intended power method is documented for the exact unit |
| Access configuration | Approved configuration evidence | The access method and handover responsibility are identified |
| Physical condition | Issue inspection | No unresolved damage, contamination, or missing component is concealed |
Do not approve a unit because it looks similar to the installed model. Record the actual check, the observation, and the evidence location. When a measurement or accessory is uncertain, leave the fit decision open and assign the next action.
CONFIRM-PER-SUPPLIER: Confirm dimensions, included components, compatible accessories, and any substitution limits on the dated product page for the specific SKU before relying on them for a procurement or installation decision.
Lock custody log and turnover pool issue log
The lock custody log records physical accountability; the turnover pool issue log records why a particular unit left stock. Keep both entries together so a completed checkout cannot be mistaken for a general stock reduction.
| Checkout record | Entry |
|---|---|
| Checkout ID and date/time | Enter |
| Requesting site, building, and door object ID | Enter |
| Reason for issue | Enter |
| Serial removed from issue stock | Enter |
| Serial fitted to the door | Enter |
| Removed unit and its destination | Enter |
| Issue condition and missing-component check | Enter |
| Door-fit compatibility record | Enter |
| Credential-state reference, if applicable | Enter |
| Issuing custodian and receiving technician | Enter |
| Acceptance date and receiving site signature | Enter |
Use the turnover pool issue log to capture the old and new serial numbers on the same line. If a technician mistakenly removes the wrong unit, both identities must remain visible for correction. Do not hide that event by overwriting the issue entry.
The issuing custodian should confirm that the unit leaving stock is physically present, correctly identified, and accompanied by the required records. The receiving technician should confirm that the unit fitted at the door matches the serial entered on the card. Any difference should stop the handover and become an exception.
For units carrying access credentials, record only the credential-state reference required for operational verification. The record must show whether the issued unit inherited, required, or changed an access state. Do not use a successful unlock at one door as proof that every intended user or method has been migrated.
Quarantine and return record for removed or suspect units
A unit removed from a door enters the quarantine and return record, even if the cause is still unknown. The purpose is to preserve the unit, the observations, and the sequence of checks without prematurely assigning blame or disposition.
| Field | Required entry |
|---|---|
| Quarantine record ID | Enter |
| Unit object ID and serial number | Enter |
| Door object ID and removal date/time | Enter |
| Symptom in the technician’s words | Enter |
| Measured or directly observed condition | Enter |
| Checks performed, in order | Enter each check and observation |
| What each check ruled out | Enter the specific condition excluded |
| Parts fitted or removed | Enter |
| Removed unit retention location | Enter |
| Photograph, reading, or diagnostic output | Enter reference |
| Proposed disposition | Repair, return review, refresh review, retire, or other |
| Approver and approval reference | Enter |
| Return or custody reference | Enter if applicable |
The distinction between an action and evidence is important. “Checked the lock” does not explain a decision. “Recorded the physical door state and free handle movement, then checked the indication shown at the door” records what was observed and allows a reviewer to understand the next step. Where a check cannot exclude a condition, state that limitation rather than presenting the result as a conclusion.
Ask the supplier what observations and records it requires before a return can be considered for review. Do not assume that a fault label, a photograph, or an internal code will be accepted. Record the exact response received and keep it with the quarantined unit.
If the unit failed before entering normal service, leave the DOA field unresolved until the purchase or service agreement defines the boundary between “failed on arrival” and “failed in use.” Record the physical facts first; the contractual category follows the agreed definition.
CONFIRM-PEHYSICAL-UNIT: Retain the removed unit, its label, fitted parts, and supporting evidence under the custody arrangement stated by the responsible team.
Turnover close-out after the replacement door is operable
A door is not closed simply because a technician has replaced a component. The turnover close-out should show the original report, the observations, the tests, the parts or unit used, and the final operable state. This is the record from which the facility team calculates its own operating measures.
| Close-out field | Entry |
|---|---|
| Door object ID | Enter |
| Date/time fault reported through the agreed channel | YYYY-MM-DD HH:MM |
| Date/time the door was operable again | YYYY-MM-DD HH:MM |
| Symptom in the technician’s words | Enter |
| Measured observation | Enter |
| Checks and what each ruled out | Enter |
| Parts fitted or unit swapped | Enter |
| Old unit retained at | Enter |
| Credential state before and after, where involved | Enter |
| Photo, reading, or supporting output | Enter reference |
| Technician and reviewer | Enter |
Keep the service vocabulary precise in the notes:
| Measure | Definition used by the buyer |
|---|---|
| Response time | Interval from reporting through the agreed channel to acknowledgement of the report |
| On-site attendance time | Interval from acknowledgement to someone being at the door |
| Resolution time | Interval from the report to the door being operable again |
| MTTR | Mean of the resolution intervals across a defined period and defined population |
| First-time fix | A visit that ends with the door operable and no repeat visit for the same symptom under the buyer’s defined rule |
These definitions do not supply a target or explain why an event took a particular amount of time. The site plan sets its own assumptions; this worksheet provides the underlying timestamps. MTTR also does not reveal the longest unresolved cases or failures that were never reported, so retain the individual records rather than relying on the mean alone.
Control flow from installed base to reconciled stock
Use the following flow to separate physical control decisions from administrative status changes. Every forward movement should point to a dated record; every rejection should point to the failed check.
flowchart TD
A[Approved installed base] --> B[Build object schedule]
B --> C[Classify every physical unit]
C --> D[Complete issue gate]
D --> E{Issue gate passed}
E -->|Yes| F[Issue controlled unit]
E -->|No| G[Quarantine and review]
F --> H[Verify door operable]
G --> I[Record disposition evidence]
H --> J[Reconcile serial and status]
I --> J
J --> K[Archive signed record]
A failed fit check returns the unit to review, not automatically to issue stock. A configuration problem may leave a physically sound unit quarantined. An unresolved identity mismatch keeps it out of both installed and available counts. This prevents the common error of using one spreadsheet status to represent two different decisions: physical condition and permission to issue.
Configuration and credential-state release note
Physical fit and logical release are separate gates. The configuration release note confirms who changed the accepted access state, what changed, which test was used, and which evidence supports handover. It should not contain the personal information of individual occupants unless the site’s approved procedure requires that record elsewhere.
| Release field | Entry |
|---|---|
| Door object ID and issued unit serial | Enter |
| Previous configuration reference | Enter or mark not applicable |
| New configuration reference | Enter |
| Access method affected | Enter only methods used at the site |
| Credential or holder state before | Enter |
| Credential or holder state after | Enter |
| Test method and result | Enter without recording confidential access data |
| Exceptions or deferred items | Enter |
| Operator and independent reviewer | Enter |
| Evidence and handover reference | Enter |
A successful mechanical operation does not prove that the intended access method works. Test each state identified in the accepted handover requirement and retain the result against the door and unit. If a person or method is intentionally excluded, record the responsible approval rather than an unexplained absence.
CONFIRM-WITH-LOCAL-SITE-POLICY: Confirm which access, privacy, emergency-egress, employment, and record-retention rules apply to each site before deciding what identifiers and evidence the log may retain.
Monthly stock reconciliation and unit serial number reconciliation
Complete the monthly stock reconciliation by starting with the previous signed closing balance, adding received units, subtracting issued units, and accounting for returns, quarantine transfers, retirements, and unresolved discrepancies. The arithmetic should close only after every serial has a disposition.
Use this movement table without preset figures:
| Reconciliation line | Opening count | Receipts | Issues | Returns | Retirements | Closing count | Variance |
|---|---|---|---|---|---|---|---|
| Exact SKU and variant A | |||||||
| Exact SKU and variant B | |||||||
| Exact SKU and variant C | |||||||
| Unidentified or mixed stock | |||||||
| Total physical units located |
A blank is not a zero. If a cabinet cannot be counted, enter it as unresolved and identify the access or custody constraint. During unit serial number reconciliation, separate three results: physically located and matched, physically located but unmatched, and recorded but not located.
| Variance ID | Serial or stock group | Expected location | Actual location | Difference | Cause | Action | Owner | Closed by |
|---|---|---|---|---|---|---|---|---|
| VAR-001 | Enter | Enter | Enter | Enter | Enter | Enter | Enter | Enter |
| VAR-002 | Enter | Enter | Enter | Enter | Enter | Enter | Enter | Enter |
The approval on a reconciliation sheet means the reviewer accepted the stated count and exceptions. It does not mean that every unit is fit for issue. Issue readiness remains controlled by the identity, fit, condition, and documentation checks.
Use the lock bank and turnover pool worksheet totals to identify movement patterns, but do not treat a large issue count as proof of poor condition or an unusually quiet month as proof of reliability. The counts are operational facts; their interpretation depends on the doors, usage, reporting, and units included in the period.
Decision comparison: repair, return, refresh, or retire
The disposition decision should follow the evidence, not the convenience of moving a serial into another pool category. Use this comparison at the time of quarantine and again if the proposed action changes.
| Option | Decision question | Evidence required | Effect on stock record | Authorisation |
|---|---|---|---|---|
| Repair | Does the evidence support returning this exact unit to service? | Observed fault, ordered checks, exclusions, parts and test result | Move to repair review, then issue-ready only after reinspection | Named technical approver |
| Return for review | Has the supplier confirmed what evidence it will assess? | Quarantine record, unit identity, retention location and requested evidence | Move to return pending with a reference | Procurement or service owner |
| Refresh | Does the door require a different installed configuration or unit class? | Door schedule, fit check, access requirement and migration plan | Separate the installed decision from the pool decision | Facility and security owners |
| Retire | Is there an accepted basis for removing the unit from usable stock? | Condition, attempted checks, disposition decision and retained evidence | Retire from issue count while preserving the history | Asset and technical owners |
| Retain in stock | Is the unit still controlled, identifiable and supported by evidence? | Current condition, storage location and next review point | Keep in the current state with an owner | Stock custodian |
Do not use price, anticipated service life, or an unsupported supplier promise to select an option. Use the evidence named by the responsible team and the applicable agreement. If evidence is missing, the decision remains open.
Printable quick issue card for the site cupboard
Print the quick issue card separately from the master register. It supports the custodian at the point of checkout, but it does not replace the master row or the event history.
| Quick issue card | Entry |
|---|---|
| Site, cupboard, and card number | Enter |
| Issue date/time and issuing custodian | Enter |
| Unit object ID and serial number | Enter |
| Working state before issue | Enter |
| Intended door object ID | Enter |
| Fit-check evidence reference | Enter |
| Accessories and documents included | Enter |
| Serial of removed unit | Enter |
| Removed-unit destination and custodian | Enter |
| Configuration or credential-state reference | Enter |
| Receiving technician acceptance | Enter |
| Return date and returning custodian | Enter |
| Exceptions or damaged packaging | Enter |
Write “none” where there are genuinely no exceptions, rather than leaving the field ambiguous. If the card cannot identify the unit or intended door, the issue does not proceed. After the turnover, file the signed card against both serial numbers and the door object ID.
Site handover evidence pack and audit questions
The site handover evidence pack is an index, not a second copy of every system. It points the reviewer to the controlled record and confirms who accepted it.
| Evidence item | Record owner | Trigger | Acceptance evidence |
|---|---|---|---|
| Approved door and unit object schedule | Facility manager | Handover or portfolio revision | Signed schedule version |
| Dated product-page evidence for the exact SKU | Procurement or product owner | SKU entered into stock | Reference to the dated page |
| Spare lock inventory register | Stock custodian | Every receipt and status change | Count and serial match |
| Door-fit compatibility checks | Site or installation owner | Before a unit becomes issue-ready | Door and serial reference |
| Turnover pool issue log | Issuing custodian | Each unit leaves stock | Checkout signature |
| Quarantine and return record | Technical owner | Unit removed with an exception | Retained unit and evidence |
| Turnover close-out | Technician | Door becomes operable | Report and operable timestamps |
| Configuration release note | Configuration owner | Access state changes | Reviewer and test reference |
| Monthly stock reconciliation | Facility manager | Each review cycle | Signed movement and variance sheet |
Audit the file with direct questions: Can the reviewer locate every listed serial? Which event explains its current state? What evidence allowed the unit to enter issue stock? What did each diagnostic check rule out? Where is the removed unit? Do the timestamps support the measure being calculated? Is every exception assigned to a named owner?
A blank signature, unexplained status change, or missing old-unit location is a finding to resolve—not a reason to infer that the lock was compliant or noncompliant. The worksheet records the evidence available for the decision.
Related records and supplier close-out
Use the Lock Bank and Turnover Pool When the Estate Has More Than One Site when this worksheet must be coordinated across separately controlled estates. The Lock Bank and Turnover Pool: The Measurements Worth Keeping is the companion record for defining operating measures from the underlying events. For field decisions that avoid an unnecessary second visit, consult Working Lock Bank and Turnover Pool Without a Second Site Visit. Before adding products to the pool, use Lock Bank and Turnover Pool Evidence to Request Before You Buy to structure the evidence request.
The practical counterpart to this point is smart lock spare parts cost. That is the same question lock bank and turnover pool worksheet has to answer here.For a purchase or service plan, ask Smart Lock Factory to identify the exact SKU and dated product-page evidence required for the proposed stock, and to clarify any accessory, substitution, or return-evidence conditions. Retain the completed lock bank and turnover pool worksheet as the controlled record of what your facility team physically holds, issues, quarantines, reconciles, and signs back into service.
CONFIRM-PER-SUPPLIER: Confirm the exact SKU, dated product-page references, included components, approved substitution conditions, and required return evidence for each unit before it enters the controlled pool.
When the file is ready, request a quote against the written requirement.

