Download the template
Download the peptide inventory template (CSV). It opens in any spreadsheet app. The two example rows show a released batch and one still waiting for its lab report; replace them with your own.
The template tracks stock and paperwork only. It has no columns for use, amounts to take or schedules, and you should not add any. Your inventory records are business records and should read like them.
Track by batch, not by product
The most important choice in the template is that every row is a batch, not a product. Two batches of the same product have different lab reports, different received dates and often different costs. If you track by product, you cannot tell a buyer which batch they received, you cannot pull one batch off sale if its report fails, and your cost figures blur together.
What each column is for
| Column | Why it is there |
|---|---|
| SKU, Product, Amount per vial | What the batch is. Keep amount per vial as net content if your supplier states it. |
| Batch / lot | Must match the label on the vial and the lab report exactly. This is the column everything else hangs on. |
| Supplier, Date received, Vials received | Where it came from and when, so you can compare suppliers and trace a problem back. |
| Vials on hand | Update it every time you pack an order, not at the end of the week. |
| Reorder point | The count at which you reorder, based on how fast it sells and how long the supplier takes. |
| Status | Quarantine (no report yet), Released (report passed) or Hold (report failed or expired). Only Released batches are for sale. |
| Lab, Report test date, Report valid until | The paperwork buyers ask about. Sort by the valid-until date weekly. |
| Report link | The public page or PDF you send when asked. |
| Unit cost | What one vial of this batch cost you landed, for margin and cost per milligram. |
| Storage location, Notes | Where it is and anything unusual about it. |
Habits that keep a spreadsheet accurate
- One person owns the sheet. Shared editing without rules is how counts drift.
- Update on-hand counts at the moment of packing, and write the batch on the packing slip as you do.
- Count physically once a month and correct the sheet, noting why each correction was needed.
- Sort by report valid-until every week and retest or pull anything expiring. The COA expiry calculator gives the dates.
- Never change a batch to Released until its report is in hand and checked against the label.
Signs you have outgrown the spreadsheet
A spreadsheet is the right tool for a while. These are the signs it has become the wrong one:
- You have sold a vial the sheet said you had, and did not.
- Website stock and the sheet disagree, and you find out from a buyer.
- You cannot answer "which batch did I get?" without digging through packing slips.
- Someone other than you packs orders, and counts start to drift.
- A lab report expired while its batch was still on sale.
- You spend more time reconciling the sheet than using it.
Our Purity vs spreadsheets comparison sets out what a spreadsheet still does well and what changes when you move.
Doing it in Purity
Purity keeps the same structure the template uses, without the manual upkeep. Stock is tracked by batch, a batch cannot be sold until its lab report passes your release rule, and each order line records the batch that filled it. When website orders come in, stock updates everywhere at once, and products running low show how many days are left and how much to reorder. You can import your spreadsheet to start, so nothing is typed twice. Create an account or try the demo.
Common questions
- What should a peptide inventory spreadsheet track?
- For a seller: stock by batch, each batch's lab report and its valid-until date, whether the batch is released for sale, what it cost, and a reorder point. Nothing about use.
- Is a spreadsheet good enough to start?
- Yes, for one person with a handful of products. It stops being enough once more than one person packs orders, stock also lives on a website, or you have more batches than you can check by eye.
- How often should I count physical stock?
- Monthly at minimum, and whenever the sheet and a buyer disagree. Record every correction and the reason, so repeated errors point to the step that causes them.