An asset-and-manual worksheet helps a team check that equipment identifiers and supplied documents can be connected. It is particularly useful when the asset schedule, supplier files, warranties and site labels were prepared by different parties. The worksheet organises discrepancies for confirmation; it does not verify the equipment’s design, installation or performance.

Copyable worksheet fields

Use one row for each asset or clearly defined equipment group:

  • Project asset ID; system; location; asset description.
  • Manufacturer, model and serial number as recorded in each source.
  • Asset-schedule reference and revision.
  • Manual title, document number, revision/date and file link.
  • Warranty reference and stated start-date basis, if supplied.
  • Source of each identifier; discrepancy description.
  • Responsible owner; requested confirmation; due date.
  • Reviewer decision, supporting reference and closure date.

Where information conflicts, retain both source values in the discrepancy note. Do not silently choose the value that looks more plausible. Preserve the original files so the responsible person can trace the issue without reconstructing the history.

Test a small sample first

Choose several assets that represent different suppliers or systems. Ask the future user to find the correct manual starting only from the project asset ID. Then reverse the exercise: start from a supplied manual and identify the asset or group it covers. That exposes unclear file names, missing cross-references and documents that apply to multiple models.

For a hypothetical example, asset AHU-03 may have model X120 in the schedule, while the manual cover lists X120/X150 and the warranty names a serial range. Record that relationship and ask the supplier or technical owner whether the supplied material applies to AHU-03. A family-model manual is not automatically wrong, but its applicability should not be assumed by a clerical reviewer.

Hand over a navigable record

Once the authorised owner confirms a match, record the confirmation reference and update the index. Keep open questions visible in the handover action list. If an asset is removed or replaced, retain the previous row history and link the change to the responsible source record.

Set expectations with the client for any fields that remain unverified. General Queensland handover guidance highlights the importance of supplied manuals and warranties, but the specific asset information depends on the project. The worksheet succeeds when a maintainer can navigate the records and understand their status, not simply when every cell has been filled.