What a useful equipment inventory keeps separate
A clinical engineering documentation exercise. Separate device identity, service status and the evidence for a change.

An equipment inventory has to answer several questions that can look similar in a spreadsheet. Which physical unit is this? Where is it now? What status does the service record for it? Which document supports that status? Combining all of those answers in one free-text note makes the record difficult to maintain.
Give identity a durable field
Use a distinct record for a unit where the local process tracks it individually. Keep the inventory identifier, model and serial information in their expected fields. Keep the current location in a separate field. That allows a move to change a location without changing the identity of the unit.
Keep status and evidence together
In an illustrative inventory, two identical units sit on the same shelf and one has been set aside pending assessment. A typed status, date and link to the service record make it clear which unit has that status. A short comment can give context. Follow the institution’s rules for approving and recording a change.
The WHO equipment inventory and maintenance references support the lifecycle view. Choose fields and approvals that fit the responsible service’s process.