NDT Equipment Inventory Reconciliation and Count Sheet

Define the population and the count boundary

State what the exercise includes: owned instruments, individually controlled accessories, temporary rentals, equipment away for service or another defined population. Also state the locations and custody holders covered. A count of the main store cannot support a claim that every instrument assigned to remote crews was physically verified.

Choose a reference time and record how movements during the count will be handled. A busy shop may be unable to stop all transfers. It can still record movements and reconcile them against the count boundary. Without that rule, the same instrument can appear twice or not at all as it moves between crews and storage.

Clarify that the count verifies identity and presence according to its defined scope. It does not automatically verify calibration suitability, technical condition or the validity of previous inspection results. NIST's traceability guidance distinguishes measurement traceability from other forms of tracing an item's history. Inventory reconciliation is useful control, but it is not a substitute for measurement evidence. NIST traceability FAQ

Prepare a stable expected list

Create a dated working list from the current register. Include asset ID, manufacturer, model, serial and the expected holder or location if maintained in your separate records. Preserve this starting list before corrections. It is the reference for explaining what the count found and how the population changed.

If your system has no export, prepare the list manually and record its source and scope. NDT Connect currently has no equipment CSV export. Do not present a hand-prepared subset as an automatic complete extraction. A second person can check the preparation against the current records where the population or consequences warrant it.

Keep technical status visible, but do not let it determine whether an item gets counted. Out of Service equipment, retired items awaiting disposal and items in storage may still need reconciliation within the defined population. Excluding them without explanation can hide unresolved custody or disposal questions.

Count from the physical item to the record

Read the actual asset marking and serial rather than confirming only a familiar case or shelf label. Match the observed identity to the expected row. If the item is in a sealed or inaccessible location, document what was actually observed and what remains unverified instead of marking the whole item as physically checked.

Record the counter and count date. Use photographs or other evidence when appropriate and permitted, especially for uncertain identification. A checkmark without an observer or date may be difficult to interpret after the count stretches over several days or several people participate.

Look for physical items not on the list as well as listed items not found. This two-direction approach matters: a perfect completion rate against an incomplete expected list can still miss an entire unregistered population. Record unexpected items in a separate section with temporary references until ownership and identity are established.

Record the search coverage for an item not found. A statement that an instrument was absent from its expected shelf is narrower than a search of the store, service area and assigned crew records. Note which locations or holders were checked and which remain outside the investigation. This prevents a later colleague from repeating the same search and prevents management from interpreting a limited observation as a confirmed loss. Empty cases should also be identified as cases, not counted as the instruments normally stored inside them.

Reconcile equipment away from the count location

For equipment at a supplier, customer site or remote crew, identify the current holder and the evidence available. A recent shipment record establishes a movement, while a direct acknowledgment or permitted identity photograph may provide stronger evidence of current custody. State which type of confirmation was obtained.

Do not label remotely confirmed equipment physically counted by your local team. Use an accurate category such as holder-confirmed, shipment-supported or confirmation pending. These distinctions let management understand the strength and limits of the reconciliation without treating every off-site item as missing.

Check the dates of the supporting evidence. A dispatch manifest from three months ago may not establish today's holder if several transfers occurred afterward. Follow the sequence until the current custody position is reasonably supported under your process. Assign unresolved cases to a named owner rather than burying them in a general off-site category.

Classify discrepancies before making changes

Useful discrepancy categories include listed item not located, unlisted physical item, identity mismatch, duplicate register row, duplicate asset label, incorrect kit association and incomplete return or disposal record. Each category points toward different evidence and a different resolution. Avoid a single miscellaneous category that conceals the next step.

Describe the observation separately from the proposed correction. For example, “physical serial differs from register by one character” is the observation; “correct register after source review” is a possible action. Keeping them separate prevents the first guess from becoming an established fact in the final report.

Do not immediately delete a missing row or create a permanent record for every unidentified object. A missing item may be away under an unrecorded transfer, and an unidentified instrument may be a supplier loan. Establish identity and ownership before changing the controlled population. Preserve the count evidence throughout the investigation.

Investigate the actual chain of events

Use receiving, transfer, shipment, service and retirement records to explain discrepancies. Ask precise questions about the last confirmed identity and custody event. A broad request to everyone asking whether they have seen a gauge often produces several guesses about similar models without resolving the specific item.

For suspected duplicate records, compare serials and history before selecting a surviving record. For suspected duplicate labels, locate both physical items and preserve separate temporary references. The two situations look similar in a spreadsheet but have different consequences. Deleting a row cannot resolve two instruments carrying the same internal identifier.

If the investigation identifies a potential equipment-control concern beyond inventory, route it to the authorized technical or management owner. The count team should not decide whether previous examinations are affected. Its responsibility is to preserve factual identities, dates and relevant assignment references for the proper review.

A hypothetical annual count

A fictional shop begins with a list of thirty-two controlled items. Twenty-four are physically checked at the store, five are confirmed by remote holders, two are supported only by outstanding service shipments and one remains unlocated. The team reports those categories separately rather than claiming that thirty-one items were physically counted.

The store also contains an unlisted probe. Investigation shows that it is a rental accessory received with a temporary instrument, so the rental record and kit association are corrected. The probe is not added to owned inventory simply because it was found on an owned shelf.

The unlocated item is later found under an outdated kit name in a remote crew's records. The resolution connects its stable serial and asset ID, updates the custody reference and preserves the original discrepancy. This fictional example shows how a count can improve records without turning every correction into a purchase, disposal or calibration event.

Approve corrections according to their meaning

Separate a formatting correction from a population or disposition change. Correcting a transposed serial after evidence review differs from retiring equipment or deciding that an item belongs to another organization. The responsible authority and supporting record may therefore differ. Do not use one blanket approval to cover every kind of discrepancy.

Record the original value, corrected value, evidence reference, approver and effective date in your supporting change record where required. NDT Connect's current equipment fields do not provide an immutable audit history, so a detailed correction record may need to live outside the tracker. Use concise notes to connect the current summary to that record.

After updating the register, check related planning information. A merged duplicate may have a separate reminder; a returned rental may still appear on a dispatch list; a retired item may remain in a kit list. Resolve the relationships affected by the correction rather than declaring success after changing one row.

Close the count with an exception register

A count can have a completed fieldwork stage while some discrepancies remain open. Document that distinction. The closeout report should state the population, coverage, evidence categories, corrections completed and unresolved exceptions with owners. It should not conceal unfinished cases behind a single completion percentage.

Define what evidence will close each remaining exception. A missing item may need a confirmed custody or approved disposition record. An identity mismatch may need a manufacturer or supplier clarification. An incomplete return may need an accessory reconciliation. Specific closure conditions prevent the same issue from reappearing next cycle without progress.

Preserve the original expected list, count observations and final reconciliation together. Later changes to the live register should not alter the historical count receipt. A reviewer should be able to see what was known at the time and which subsequent events resolved the open questions.

Make the next count easier

Review where the discrepancies originated. If transfers were not recorded, simplify the handoff. If temporary rentals were mixed with owned equipment, clarify ownership labeling in the supporting records. If equipment repeatedly returns without its accessories, improve the shipment and receiving manifest rather than adding more inventory columns without an owner.

Choose subsequent checks according to actual needs. A rotating sample can help identify recurring problems between full reconciliations, but report its coverage accurately. A sample is not proof that every item is present or every record correct. Include recent movements and unresolved cases because they provide useful evidence about whether the process has improved.

The downloadable CSV is a separate count worksheet, with space for expected and observed identities, evidence and resolution. Remove the fictional row before use and adapt the fields to your population. Its purpose is a clear reconciliation trail; it is not a technical acceptance form, an automatic app export or a guarantee of compliance.

Choose a count method that makes observations trustworthy

Decide whether counters will see the expected list while counting or record observed identities independently before matching them. Each approach has practical tradeoffs. A prepopulated list can be efficient, but staff may confirm a familiar name without reading the marking. An independent observation can reduce that assumption, but it needs a careful reconciliation step so identifiers are not mistyped or omitted.

Use the method your organization can execute reliably and document its scope. The article does not prescribe a mandatory inventory technique. What matters is that the record distinguishes an actual observation from an expectation carried forward from the register. If a counter only checked that a case was present, record that limited observation rather than upgrading it to verification of the instrument inside.

For a count spread across shifts, define how completed areas and later movements are identified. An instrument transferred from a counted store to a crew being counted later can otherwise be counted twice. Record the movement and reconcile it against the common reference boundary. Do not solve the problem by quietly deleting whichever observation was entered last.

Give counters a clear route for unexpected items and uncertain markings. They should not need to choose between inventing a permanent record and ignoring the object. A temporary count reference, factual description and evidence location allow the investigation to continue without distorting the expected population. The permanent identity or ownership decision remains with the appropriate record owner.

Close a discrepancy with evidence matched to the question

For a listed item not located, identify the last confirmed custody event and the locations or holders actually checked. If a remote holder confirms possession, preserve the source and timing of that confirmation. The outcome may resolve custody while leaving a physical identity check pending. State both facts rather than treating every type of acknowledgment as the same level of verification.

For an unlisted item found in the store, establish ownership before adding it to the owned register. It may be a temporary loan, a supplier replacement awaiting receiving review or an instrument whose record uses an older alias. Match the source evidence and route any unresolved technical or commercial question to its proper owner.

For an incorrect kit association, reconcile both the sending and receiving lists and preserve the transfer event where it can be established. Updating only one list can leave the component counted as available in two places. If the movement date cannot be established, record that limitation rather than making the current correction appear to prove the entire historical sequence.

A fictional closeout includes three different resolutions: one item confirmed at a supplier, one rental accessory removed from owned inventory and one duplicate row merged after identity review. The report should describe those outcomes individually. None necessarily represents a newly acquired, calibrated or disposed instrument, even though each changes the administrative count.

Have the responsible owner approve the corrections that change the controlled population or disposition. Retain the observation, evidence and final explanation together. This makes the inventory a useful reconciliation record rather than a set of unexplained edits made to match the expected total.