A printable lock bank and turnover pool worksheet for tracking spare smart locks, custody, fit, faults, returns, and monthly stock reconciliation.

게시일: 10월 14, 2024

A Printable Lock Bank and Turnover Pool Record for the Site Log

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 stateWhat it meansMinimum evidence before the next state
Installed referenceThe unit is recorded against an installed doorDoor object ID, serial number, accepted installation record
Ready to issueThe unit is physically held for a planned or likely substitutionIdentity, condition, door-fit and documentation checks
QuarantinedThe unit has an unresolved condition or identity questionFault or exception record, custodian, evidence reference
Return pendingThe unit has been approved for a return or supplier reviewDisposition approval, return reference, custody transfer
In transitThe unit has left one controlled location but has not been receivedDispatch record, carrier reference, receiving owner
Retired from poolThe unit will not return to issue stockDisposition 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 IDSKU and variantSerial numberWorking stateHome locationCustodianDate receivedDoor classEvidence referenceLast event
LB-001EnterEnterEnterEnterEnterYYYY-MM-DDEnterEnterEnter
LB-002EnterEnterEnterEnterEnterYYYY-MM-DDEnterEnterEnter
LB-003EnterEnterEnterEnterEnterYYYY-MM-DDEnterEnterEnter

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.

CheckEvidence to retainRecord before issue
IdentityLabel photograph or controlled inventory recordSerial and SKU agree
Door geometrySite survey or door scheduleRequired measurements match the accepted door class
Swing and handingDoor schedule or site observationThe unit is not being treated as a left/right substitute without evidence
Strike and interfaceExisting-hardware recordThe lock body, cylinder, or accessory arrangement is accepted for that opening
Power arrangementInstallation or accepted site configuration recordThe intended power method is documented for the exact unit
Access configurationApproved configuration evidenceThe access method and handover responsibility are identified
Physical conditionIssue inspectionNo 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 recordEntry
Checkout ID and date/timeEnter
Requesting site, building, and door object IDEnter
Reason for issueEnter
Serial removed from issue stockEnter
Serial fitted to the doorEnter
Removed unit and its destinationEnter
Issue condition and missing-component checkEnter
Door-fit compatibility recordEnter
Credential-state reference, if applicableEnter
Issuing custodian and receiving technicianEnter
Acceptance date and receiving site signatureEnter

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.

FieldRequired entry
Quarantine record IDEnter
Unit object ID and serial numberEnter
Door object ID and removal date/timeEnter
Symptom in the technician’s wordsEnter
Measured or directly observed conditionEnter
Checks performed, in orderEnter each check and observation
What each check ruled outEnter the specific condition excluded
Parts fitted or removedEnter
Removed unit retention locationEnter
Photograph, reading, or diagnostic outputEnter reference
Proposed dispositionRepair, return review, refresh review, retire, or other
Approver and approval referenceEnter
Return or custody referenceEnter 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 fieldEntry
Door object IDEnter
Date/time fault reported through the agreed channelYYYY-MM-DD HH:MM
Date/time the door was operable againYYYY-MM-DD HH:MM
Symptom in the technician’s wordsEnter
Measured observationEnter
Checks and what each ruled outEnter
Parts fitted or unit swappedEnter
Old unit retained atEnter
Credential state before and after, where involvedEnter
Photo, reading, or supporting outputEnter reference
Technician and reviewerEnter

Keep the service vocabulary precise in the notes:

MeasureDefinition used by the buyer
Response timeInterval from reporting through the agreed channel to acknowledgement of the report
On-site attendance timeInterval from acknowledgement to someone being at the door
Resolution timeInterval from the report to the door being operable again
MTTRMean of the resolution intervals across a defined period and defined population
First-time fixA 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 fieldEntry
Door object ID and issued unit serialEnter
Previous configuration referenceEnter or mark not applicable
New configuration referenceEnter
Access method affectedEnter only methods used at the site
Credential or holder state beforeEnter
Credential or holder state afterEnter
Test method and resultEnter without recording confidential access data
Exceptions or deferred itemsEnter
Operator and independent reviewerEnter
Evidence and handover referenceEnter

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 lineOpening countReceiptsIssuesReturnsRetirementsClosing countVariance
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 IDSerial or stock groupExpected locationActual locationDifferenceCauseActionOwnerClosed by
VAR-001EnterEnterEnterEnterEnterEnterEnterEnter
VAR-002EnterEnterEnterEnterEnterEnterEnterEnter

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.

OptionDecision questionEvidence requiredEffect on stock recordAuthorisation
RepairDoes the evidence support returning this exact unit to service?Observed fault, ordered checks, exclusions, parts and test resultMove to repair review, then issue-ready only after reinspectionNamed technical approver
Return for reviewHas the supplier confirmed what evidence it will assess?Quarantine record, unit identity, retention location and requested evidenceMove to return pending with a referenceProcurement or service owner
RefreshDoes the door require a different installed configuration or unit class?Door schedule, fit check, access requirement and migration planSeparate the installed decision from the pool decisionFacility and security owners
RetireIs there an accepted basis for removing the unit from usable stock?Condition, attempted checks, disposition decision and retained evidenceRetire from issue count while preserving the historyAsset and technical owners
Retain in stockIs the unit still controlled, identifiable and supported by evidence?Current condition, storage location and next review pointKeep in the current state with an ownerStock 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 cardEntry
Site, cupboard, and card numberEnter
Issue date/time and issuing custodianEnter
Unit object ID and serial numberEnter
Working state before issueEnter
Intended door object IDEnter
Fit-check evidence referenceEnter
Accessories and documents includedEnter
Serial of removed unitEnter
Removed-unit destination and custodianEnter
Configuration or credential-state referenceEnter
Receiving technician acceptanceEnter
Return date and returning custodianEnter
Exceptions or damaged packagingEnter

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 itemRecord ownerTriggerAcceptance evidence
Approved door and unit object scheduleFacility managerHandover or portfolio revisionSigned schedule version
Dated product-page evidence for the exact SKUProcurement or product ownerSKU entered into stockReference to the dated page
Spare lock inventory registerStock custodianEvery receipt and status changeCount and serial match
Door-fit compatibility checksSite or installation ownerBefore a unit becomes issue-readyDoor and serial reference
Turnover pool issue logIssuing custodianEach unit leaves stockCheckout signature
Quarantine and return recordTechnical ownerUnit removed with an exceptionRetained unit and evidence
Turnover close-outTechnicianDoor becomes operableReport and operable timestamps
Configuration release noteConfiguration ownerAccess state changesReviewer and test reference
Monthly stock reconciliationFacility managerEach review cycleSigned 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.

장바구니
쿠키를 허용하면 이 사이트에서의 이용 경험이 개선됩니다. 쿠키 정책
Chat on WhatsApp