How to Write a Cosmetic Batch Sheet (With a Free Template) - The SkinScience Company

How to Write a Cosmetic Batch Sheet (With a Free Template)

How to Write a Cosmetic Batch Sheet (With a Free Template)

A batch sheet is the single most important document in your cosmetic manufacturing process. It is your manufacturing record, your quality control tool, and your legal protection — all in one. Yet most indie brand founders either don't have one, or are using a rough notes document that wouldn't survive a regulatory audit.

In this guide, we walk through exactly what a cosmetic batch sheet must contain, why it matters, and how the SSC Formula Builder generates print-ready batch sheets automatically every time you scale a formula.

What is a Cosmetic Batch Sheet?

A batch sheet (also called a Manufacturing Record or Batch Manufacturing Record) is a document that records every detail of a specific production run. It captures the formula, the exact weights of every ingredient, the equipment used, the manufacturing steps, the date of production, and the person who made it.

If something goes wrong — a customer has a reaction, a batch fails stability testing, or a regulator asks questions — your batch sheet is the document that proves you manufactured the product correctly, with the right ingredients, at the right percentages.

Important: Under Australian cosmetic regulations, you are required to maintain manufacturing records that allow you to trace every ingredient in every batch. This is not optional. If you cannot produce batch records, you cannot demonstrate compliance — and you cannot perform a product recall if one is ever required.

The 8 Essential Sections of a Cosmetic Batch Sheet

A compliant cosmetic batch sheet must contain the following eight sections at minimum.

Section What to Record Why It Matters
1. Batch Header Product name, batch number, date of manufacture, batch size (total grams), and the name of the person who made it. Allows you to trace any specific batch if a customer complaint arises.
2. Formula Version The version number of the formula used (e.g., v1.2). If you ever change your formula, the batch sheet must reflect which version was used for each batch. Prevents confusion if you reformulate a product and need to trace which batches used the old formula.
3. Ingredient List with Weights Every ingredient listed by INCI name, percentage (%), and exact gram weight for the batch size produced. The core of the batch record. Proves the formula was followed correctly.
4. Supplier & Lot Numbers The supplier name and lot/batch number from the Certificate of Analysis (CoA) for every ingredient used. Enables a full ingredient traceability audit. If a supplier recalls a raw material, you can identify which of your batches are affected.
5. Manufacturing Instructions Step-by-step instructions: which phase to prepare first, temperatures, mixing speeds, when to add heat-sensitive ingredients. Ensures consistency across batches, especially if someone else is making the product.
6. Equipment Used The specific equipment used (e.g., "500mL glass beaker, digital hotplate, immersion blender"). Relevant for scale-up and troubleshooting. A formula that works in a glass beaker may behave differently in a stainless steel vessel.
7. Quality Control Checks pH reading, viscosity observation, appearance, and colour at the time of manufacture. Pass/fail checkboxes. Provides a baseline to compare against future batches or stability test results.
8. Packaging & Labelling Record Container type, fill weight, label version used, and the number of units filled from the batch. Closes the loop between manufacturing and the finished product on the shelf.

A Simple Batch Sheet Template

Here is a simplified example of what a batch sheet looks like for a 100g facial serum batch.

Batch Manufacturing Record

Product Name: Hydrating Vitamin C Serum
Batch Number: HVC-2026-001
Date of Manufacture: 10 June 2026
Batch Size: 100g
Manufactured By: [Your Name]
Formula Version: v2.0

INCI Name % Weight (g) Supplier Lot No.
Aqua (Water) 72.5% 72.5g Distilled
Aloe Barbadensis Leaf Juice 10.0% 10.0g The Skin Science Company AV-2026-04
Glycerin 5.0% 5.0g The Skin Science Company GL-2026-02
Sodium Ascorbyl Phosphate 3.0% 3.0g The Skin Science Company SAP-2026-01
Niacinamide 5.0% 5.0g The Skin Science Company NIA-2026-03
Sodium Hyaluronate 0.5% 0.5g The Skin Science Company HA-2026-01
Allantoin 0.5% 0.5g The Skin Science Company ALL-2026-02
Benzyl Alcohol, Salicylic Acid, Glycerin, Sorbic Acid 1.0% 1.0g The Skin Science Company GEO-2026-01
Citric Acid 0.5% 0.5g The Skin Science Company CA-2026-01
TOTAL 98.0% 98.0g
pH adjustment (Citric Acid to target pH 5.5–6.0) ~2.0% ~2.0g

pH at Completion: 5.7 ✅
Appearance: Clear, slightly viscous, no particulates ✅
Units Filled: 10 × 10mL amber glass dropper bottles
Label Version: HVC-Label-v2

Why Batch Numbers Matter

Your batch number is the link between your manufacturing record and the finished product on the shelf. Every label you produce should include a batch number (even if it's printed on the base of the bottle rather than the front label). If you ever need to recall a product — or if a customer contacts you with a complaint — the batch number tells you exactly when it was made, which ingredients were used, and which lot numbers of raw materials were in that batch.

A simple numbering system like [Product Code]-[Year]-[Sequential Number] (e.g., HVC-2026-001) is sufficient for most indie brands.

How the SSC Formula Builder Generates Batch Sheets Automatically

Writing batch sheets manually is time-consuming and error-prone. If you scale your formula from a 100g test batch to a 500g production run, every single gram weight in the table changes. Recalculating manually introduces risk.

The SSC Formula Builder solves this completely. When you build your formula in the software and set your batch size, the system automatically calculates the exact gram weight for every ingredient. When you are ready to manufacture, you click Export Batch Sheet and receive a print-ready PDF that includes:

  • All ingredients with INCI names, percentages, and exact gram weights for your chosen batch size.
  • Phase-by-phase manufacturing instructions (Water Phase, Oil Phase, Cool-Down Phase).
  • A QC checklist with pH target, appearance, and sign-off fields.
  • Space for supplier lot numbers to be filled in at the time of manufacture.

You can change your batch size at any time — from 50g to 5kg — and the batch sheet recalculates instantly.

Generate Your First Batch Sheet in Minutes

Build your formula in the SSC Formula Builder and export a professional, print-ready batch sheet with one click. No spreadsheets required.

Try SSC Formula Builder Free

Frequently Asked Questions

How long do I need to keep my batch records?

In Australia, it is recommended to keep cosmetic batch records for at least the shelf life of the product plus one year. For most skincare products with a 24-month shelf life, this means keeping records for a minimum of three years. If you are exporting to the EU, their regulations require records to be kept for 10 years after the last batch of a product is placed on the market.

Do I need a batch sheet if I'm just selling at a market?

Yes. Australian cosmetic regulations apply regardless of where you sell. Even a sole trader selling at a weekend market is required to be able to trace their ingredients and demonstrate that their products are safe. A batch sheet is the primary document for this.

What's the difference between a batch sheet and a formula?

Your formula is the master recipe — it defines the ingredients and percentages. A batch sheet is a production record for a specific manufacturing run. You might have one formula but hundreds of batch sheets, each recording a different production run of that formula.

Can I use the SSC Formula Builder batch sheet for a contract manufacturer?

Yes. The PDF batch sheet exported from the SSC Formula Builder includes all the information a contract manufacturer needs: INCI names, percentages, gram weights for the requested batch size, and phase-by-phase instructions. It is designed to be handed directly to a manufacturer.

← Older Post Newer Post →

Leave a comment

Skin Science Formula Builder

RSS
How to Formulate a Serum from Scratch: A Step-by-Step Guide for Indie Brands - The SkinScience Company

How to Formulate a Serum from Scratch: A Step-by-Step Guide for Indie Brands

How to Formulate a Serum from Scratch: A Step-by-Step Guide for Indie Brands A serum is the most commercially valuable product category in skincare —...

Read more
How to Calculate COGS - The SkinScience Company

How to Calculate COGS

How to Calculate COGS for Your Skincare Brand (And Actually Make a Profit) One of the most common reasons indie skincare brands fail isn't bad...

Read more