Free Batch Manufacturing Record Template

A batch manufacturing record (BMR) is a document that captures every detail of a specific production run — the ingredients used, their lot numbers, the manufacturing steps followed, quality control results, and operator sign-off. It provides a complete, verifiable record of how a batch was made, from raw materials to finished product. BMRs are a core requirement of Good Manufacturing Practice (GMP) for cosmetics, food, and supplement manufacturers, and they're increasingly expected by retail buyers and distributors as part of product compliance documentation. Read more in our guide: What Is a Batch Manufacturing Record?

The template is structured to capture the fields that GMP guidelines require at the batch record level — batch identification, raw material traceability (with lot numbers), process documentation, QC results, and operator sign-off. It also aligns with the batch record requirements in FDA's MoCRA cosmetics guidance and 21 CFR Part 111 for dietary supplements. However, this is a template, not a compliance certification. Whether your documentation is formally GMP-compliant depends on how you implement it alongside your overall quality system. If you're pursuing formal GMP certification (e.g., for a large retailer or contract manufacturer), consult a regulatory consultant to confirm your full documentation meets their specific requirements.

Yes — the template works for cold process, hot process, and melt & pour soap making. The ingredient section captures your oils, lye, fragrance oils, colorants, and additives with lot numbers and quantities. The manufacturing steps section can be adapted to your specific process (lye mixing, trace, pour, cure start date). The QC section covers visual checks and any pH or curing notes. We've also written a detailed guide specifically for soap makers: How to Write a Batch Record for Soap.

A batch number is a unique identifier assigned to a specific production run (e.g., "2026-05-001"). A batch record is the complete document that describes everything about that run — who made it, what went into it, how it was made, and whether it passed QC. The batch number lives on the label; the batch record lives in your files. Together they form the traceability chain: if you ever need to recall a batch, the batch number on the product leads you to the batch record, which tells you exactly which raw material lot numbers were used and which customers received it.

Retention requirements vary by industry and jurisdiction. As a general guide: cosmetics — FDA MoCRA requires records be kept for 3 years from the date of manufacture; dietary supplements (21 CFR Part 111) — records must be kept for 1 year beyond the product's shelf life, or at least 2 years; food manufacturers (FSMA) — varies by rule, but most records must be kept for 2 years. Always check the specific regulations that apply to your product category and market. As a practical rule, keeping records for at least 3 years beyond the product's expiry date protects you against most traceability scenarios.

This spreadsheet is a solid starting point, but a few signals suggest it's time to look at dedicated software. If you're running more than 5–10 batches a week, manually completing batch records becomes a real bottleneck. If you have employees handling production, a spreadsheet relies on them filling it in correctly every time — with no guardrails. And if you're supplying retailers who want digital batch records, lot traceability reports, or recall readiness documentation, a spreadsheet creates a lot of manual extraction work. Stocksmith tracks batch records, lot numbers, and material traceability automatically as part of production logging — so the record is generated from the work rather than completed separately after it. Start a free 14-day trial to see how it works.