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.
