Skip to content

Soap Making Log: Batches, Lye Lots and Cure Dates

A soap making log for cold process soap: one row for each batch with its weights, lye lot, temperatures, cut and cure dates and bar weights. Free spreadsheet.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A soap making log has one row for each batch, and it's filled in over six weeks, not in one sitting. On the day you make it: the batch number, the recipe, the weights of oils, lye and water as weighed, the lot of the lye and the fragrance, and the temperature when you mixed. Two days later: when it was unmolded and how many bars it cut. Then the date it will be cured, and at the end the weight of a cured bar. The batch number goes on the curing rack and later on the label or the box. With that, a complaint about one bar leads back to one row, and the row says what went in. Below is a log for a made-up cold process soap maker, and the file.

The short version

  • One row for each batch, with a number that follows the bars.
  • Write the weights you weighed, not the recipe's.
  • Write the lye's lot. It's the ingredient that can hurt someone.
  • Cured on = day made + cure days. Nothing sells before it.
  • Weigh a bar at cutting and again when cured.
  • TaroStack notes which lots each batch used when you record it. More below.

An example log

Three batches from a made-up maker. The recipe is the one in soap batch calculator: olive, coconut, shea and castor, with 5% of the oils left over.

Made on Batch Recipe Oils Lye Water Bars Cure Cured on
Nov 2 S-1102 Lavender bar 1,897.3 g 265.2 g 530.5 g 19 28 days Nov 30
Nov 9 S-1109 Lavender bar, four times 7,589.3 g 1,061.0 g 2,122.0 g 77 28 days Dec 7
Nov 16 S-1116 Unscented bar 1,897.3 g 265.2 g 530.5 g 19 42 days Dec 28

And the columns that don't fit across a page:

Batch Lye lot Fragrance and lot Mixed at Unmolded Bar at cutting Bar cured
S-1102 NaOH 24-0871 Lavender, 56.9 g, LV-3302 105°F Nov 4 142 g 128 g
S-1109 NaOH 24-0871 Lavender, 227.7 g, LV-3302 108°F Nov 11 143 g
S-1116 NaOH 24-0902 None 102°F Nov 19 141 g

The temperatures and cure times are this maker's own.

What each column is for

The batch number. S-1102 is S for soap and the month and day. Write it on a card on the curing rack the day the bars are cut, and print it on the band or the box when they're wrapped. A number that stays in the notebook doesn't help when a customer writes in.

Weights as weighed. The recipe says 265.2 g of lye. If the scale read 267, write 267. Lye is the one ingredient where a few grams matter: too much and the bar is harsh. When someone says a bar stung, the first thing to look at is this cell.

The lye lot. Batches S-1102 and S-1109 used the same drum, 24-0871. S-1116 opened a new one. If S-1116 turns out soft or harsh and the other two don't, the new drum is the first suspect, and without the lot written down there's nothing to suspect.

Mixing temperature. It affects how fast the batter thickens and how the bar looks. Six months on, it's how you find out why one batch has a chalky top and the next doesn't.

Unmolded. S-1116 was soft at two days and stayed in the mold a third. That's worth a note: it's unscented, and this maker's fragrance speeds things up.

Cure. The sheet adds the cure days to the day made. This maker cures scented bars four weeks and the unscented bar six, and the status column reads "Curing" until the date passes. A rack card with the cured-on date stops bars leaving early in a busy week.

Two weights

S-1102
Batter poured 2,750 g
Bars cut 19
A bar at cutting 142 g
A bar after 28 days 128 g
Lost in the cure 14 g, about a tenth

Soap loses water as it cures. This maker's label says 4.5 oz, which is 127.6 g, so a cured bar at 128 g just makes it. Weigh several bars from each batch when the cure ends, and write down the lightest. If the mold or the cut changes, the label's weight may have to change with it.

The whole process, step by step, is in cold process soap production. What a batch costs is in soap making cost calculator.

Get the log

Download the soap making log. One sheet and a read-me: type the day made and the cure days, and the sheet works out the cured-on date and shows "Curing" or "Ready". It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The log says which lye went into S-1116. It doesn't say which shops got S-1116's bars, because that's on invoices that don't mention batches. And it doesn't take anything off the shelf: after three batches the oil on hand is whatever you remember, and the day the olive oil runs short is the day you were going to make eighty bars.

How TaroStack does it

TaroStack keeps the log as you record the work.

Each bar is a recipe by weight. Record a batch and its oils, lye and fragrance come off stock. The batch notes which lots it used, automatically.

Your own checks are fields on the batch record: mixing temperature, unmolded on, bar weight.

Each batch is a lot with your own code. Put it on hold while it cures, and it's kept out of what you can sell until you release it.

One report for a lot: which lye and oil lots went in, and which customers got the bars.

"What could I make right now" says how many batches the oils on hand allow, and which one runs out first.

The job Log sheet In TaroStack
Which lye lot went in Typed in a cell Noted when the batch is recorded
Bars not sold before they're cured A rack card On hold until released
Who got batch S-1116 Invoices One report
Olive oil left after three batches Memory Taken off with each batch

TaroStack doesn't work out your lye: the recipe is yours. Recipes, batches and lots are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What should a soap making log include?

The batch number, date, recipe, the weights of oils, lye and water as weighed, the lots of lye and fragrance, the mixing temperature, when it was unmolded and cut, the number of bars, the cure date, and a cured bar's weight.

Why keep a log for each soap batch?

So a problem with one bar leads back to one batch and what went into it, and so a batch that turned out well can be made the same way again.

How do I know when a batch is cured?

Add your cure time to the day it was made and write that date on the rack. In the example, scented bars made on November 2 with a 28-day cure are ready on November 30.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.