Use one operational record from receipt to closeout
The template is designed for a small research inventory that needs a consistent answer to five questions: What is the material? Which lot is it? How many units remain? Where is it recorded? Which documentation is connected to it?
It is an inventory worksheet, not a validated laboratory information management system, chain-of-custody form, storage protocol, or regulatory compliance record. If your institution has required forms or procedures, use those as the controlling source.
Create a new row when the product, labeled strength, vial format, supplier, or lot changes. Do not combine separate lots merely because the product name is the same.
The 16 template fields
| Field group | CSV columns | Purpose |
|---|---|---|
| Record control | record_id, received_date, last_checked_date | Give the row a stable identifier and preserve review dates. |
| Source | supplier_name, order_reference | Connect the physical receipt to its supplier and order record. |
| Product identity | product_name, labeled_strength, vial_format, lot_batch_id | Keep the exact variant and lot separate from similar records. |
| Quantity | quantity_received, quantity_remaining | Maintain the received and current unit counts. |
| Documentation | documentation_status, document_reference | Record whether a document was requested or received and how it is identified. |
| Location and state | storage_location, inventory_status | Use your own location code and controlled status vocabulary. |
| Context | notes | Preserve discrepancies, follow-up, or other relevant operational detail. |
The example row uses placeholders only. Delete it or replace every example value before using the file as an active record.
A simple four-stage workflow
- ReceiveCreate the record
Enter the received date, supplier, order reference, exact product identity, lot, and received quantity.
- VerifyMatch label and documentation
Confirm the product, strength, format, and lot; update documentation status and its report reference.
- MaintainAdjust quantity and location
Update remaining units, the internal location code, status, and last-checked date using your established procedures.
- ClosePreserve the final record
When the record is no longer active, set the appropriate status rather than deleting the row and losing its history.
Use a short controlled vocabulary
Consistent values make filtering and review more reliable. Define the values your organization actually uses and document them near the workbook.
Do not add medical, patient, diagnostic, dosing, administration, or other sensitive personal information to this operational log.
Open the CSV in the tool you already use
The file can be opened in Excel, Google Sheets, Numbers, or imported into a database. Save a clean master before customizing column names or controlled values.
Free CSV template
Research peptide inventory log
16 columns for source, product-lot identity, unit count, documentation, location, status, and notes.
For document-level review, use the separate 15-field documentation checklist.
Why the template keeps lot and inventory records visible
The World Health Organization's Laboratory Quality Management System materials identify purchasing, inventory, and documentation as core laboratory quality topics and provide inventory-log examples for their stated public-health and clinical-laboratory audience. This Bio Peptides Labs CSV is an original, simplified operational template; it is not a WHO form and does not claim equivalence to WHO, ISO, institutional, or regulatory requirements.
- WHO: Laboratory Quality Management System Handbook — general laboratory quality-management reference.
- WHO Laboratory Quality Management System Training Toolkit — purchasing, inventory, documentation, and inventory-log training resources.
Last source review: August 8, 2026. Educational and operational recordkeeping use only.