You already know how to make soap. This record book is for the other half of a soap business — keeping a clean record of every batch, tracing every bar back to the batch and the supplier lots behind it, staying on the right side of the labeling and claims rules, and the one that quietly decides whether it pays: knowing what a bar truly costs you, so you can price it for a profit instead of a guess. It turns the back-room chaos into a calm, repeatable system without getting in the way of the part you love.
One record book, the whole selling side of the bench. Log every batch with a cure-ready date, trace every bar to a supplier lot, keep your oils and packaging stocked, dose fragrance safely, and finally price your soap for a profit — with your labour and the cure counted, the two lines many makers leave out.
What’s inside:
- A batch record log (Excel) — one row per batch: the date, a unique lot code, the product and recipe, the base (oils) weight, the fragrance and its rate, the cure days, and the units made — and the workbook works out the cure-ready date, so nothing sells before it’s ready
- A recall-readiness lot log (Excel) — each finished batch tied to the supplier lots that went into it and the channels it sold through, so any bar traces both ways, from supplier lot to batch to where it sold
- An oils, lye & materials inventory + a packaging & label inventory (Excel) — track materials by supplier lot and packaging by a reorder point; it auto-flags low stock so a recall is traceable and a finished batch never strands
- A fragrance load calculator (Excel) — turn a target percentage into a fragrance weight for a batch and per unit, with a check that flags whether your rate is within the supplier’s stated maximum usage rate
- A cost-per-bar calculator (Excel) — your material cost per bar (the batch’s material cost divided by the bars it yields), then your true cost per bar (materials, packaging, labour, overhead), then a fair price
- A product type reference — every product from a cold-process bar to a whipped body butter, with the cut/cure time, the typical fragrance load, and roughly how long it keeps
- A Labeling, Claims & Good-Manufacturing guide + printable records — the soap-vs-cosmetic-vs-drug line, the label essentials, fragrance allergens, the batch-day GMP workflow, troubleshooting, and print-and-use batch / recall-lot / receiving sheets
The working part really works: the Excel workbook has eight tabs with live calculators — type your numbers and the cure-ready dates, the fragrance weights, the costs, and the prices compute for you.
Evergreen — use it any year: product types, cure times, the batch and fragrance math, the labeling line, and the pricing method are timeless, and the logs use a date column you fill in yourself.
Instant digital download. Nothing ships. The files are yours to use in your own soap & bath-and-body business.
Created with AI assistance under Ardent Workshop’s creative direction, then reviewed and edited before release. This is a record-keeping book and maker’s reference, not a recipe book, a lye calculator, or legal, regulatory, or safety certification. Always run your own recipe through a lye calculator, follow every material’s Safety Data Sheet and usage rate, and confirm the labeling, claims, and preservation rules for your country with your national regulator (in the US, the FDA’s cosmetics guidance), a cosmetic chemist, and your insurer. Cure times, fragrance rates, and shelf lives are typical starting points; confirm with your own testing and your scale. The costing and pricing examples are illustrative, not financial or tax advice. Not affiliated with or endorsed by any regulator, supplier, or marketplace.
