Building an inventory record that survives an audit
The minimum fields worth capturing, and why the log matters more than the labelling.
Published 31 Aug 2026 · Updated 31 Aug 2026
An inventory system does not need to be sophisticated. It needs to be complete, current and legible to somebody who was not there when the entry was made.
The minimum useful record
Item description, supplier, item code, batch reference, quantity received, date received, storage location, and who logged it. A spreadsheet with those eight columns, kept current, outperforms an elaborate system nobody updates.
Record movements, not just arrivals
An entry that only records receipt tells you what you once had. Log withdrawals and transfers between locations too, otherwise the log and the shelf drift apart within weeks.
Separate the label from the record
Labels get abraded, frozen and peeled. The authoritative record should live in the log, with the label carrying only enough to point at it — typically the item code and batch reference.
Review on a schedule
A short monthly reconciliation between log and shelf catches errors while they are still explainable. An annual reconciliation mostly documents that a problem exists.
Record-keeping guidance only.