Free tool · Inventory records
Research peptide inventory log template
Keep receipt, product identity, lot, quantity, documentation status, location, and review details in one consistent row per material record. Follow the two-lot example below to see how separate records preserve the connection to their documents.
On this page
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.
One row, one product-lot record
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.
A peptide inventory log example: two lots, two records
A new shipment contains the same product you already have, but a different lot number. Create a separate row so each received quantity, document reference, and remaining balance stays connected to its own lot.
Fictional example, not a validated laboratory procedure
All materials, suppliers, identifiers, and counts below are made up. They do not describe current stock or an actual test report. Your organization's approved procedures remain the controlling source.
Start with separate receipt records
Imagine four vials of “Example research material, 10 mg, 3 mL vial” arrive under LOT-EXAMPLE-A. A later shipment contains two vials with the same description under LOT-EXAMPLE-B. The shortened table uses the existing CSV's exact field names.
| CSV field | First receipt | Second receipt |
|---|---|---|
record_id | EXAMPLE-001 | EXAMPLE-002 |
supplier_name | Example supplier | Example supplier |
product_name | Example research material | Example research material |
labeled_strength | 10 mg | 10 mg |
vial_format | 3 mL vial | 3 mL vial |
lot_batch_id | LOT-EXAMPLE-A | LOT-EXAMPLE-B |
quantity_received | 4 | 2 |
quantity_remaining | 4 | 2 |
documentation_status | Requested | Not requested |
Complete the other template fields from your real records. Keep labeled mass and vial capacity separate: 3 mL describes the container, not solution volume or concentration. See the mg-versus-mL product-record example.
Record a document mismatch without changing the physical lot
Suppose a report returned for the second receipt lists LOT-EXAMPLE-A. Keep the second row's lot_batch_id as LOT-EXAMPLE-B; do not edit it to match the report. Set documentation_status to “Clarification needed” and identify the unmatched report in notes. “Received” describes a document's arrival, not verification of its analytical claims.
Use the lot-mismatch clarification template and follow your organization's review procedures while the discrepancy remains unresolved.
Update the balance, preserve the receipt
If one vial from the first lot leaves available inventory under your established process, its quantity_remaining changes from four to three. Its quantity_received stays four. The second lot still has two remaining units and its own documentation status.
This CSV stores current values; it does not automatically maintain an audit trail, per-vial history, user permissions, or approval records. Where those controls are needed, use a separate change record or your institution's approved system.
Close a record without deleting its history
When the first lot reaches zero remaining units, retain its row, original received count, document references, and unresolved notes. Use an appropriate inactive status, such as “Depleted.” If you archive the row, retain its stable record ID and a recoverable copy; do not reuse EXAMPLE-001 for a new receipt.
Start with a clean inventory CSV, replace its example row, and keep sensitive personal or medical information out of the worksheet.
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.
Documentation statusFor example: not requested, requested, received, clarification needed.
Inventory statusFor example: expected, received, active, held, depleted, archived.
Location codeUse a stable internal code—not an improvised description that changes by row.
Date formatUse ISO format, YYYY-MM-DD, for reliable sorting.
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
Source and scope
The World Health Organization's Laboratory Quality Management System Handbook is a general quality-management reference for public-health and clinical laboratories. This CSV and its two-lot example are original, simplified operational material, not WHO forms. They do not establish equivalence to WHO, ISO, institutional, or regulatory requirements.
- WHO: Laboratory Quality Management System Handbook — background reference, not certification of this supplier or worksheet.
Last source review: September 23, 2026. Educational and operational recordkeeping use only.
Published by Bio Research LLC. Source and editorial responsibility notes · Report a correction.