A lotion making log sheet records one batch a row: the batch number, the size, the lot of every ingredient in the water phase, the oil phase and the cool-down phase, the temperature you heated to and the temperature you added the preservative at, the pH you measured against the range your preservative needs, the jars filled, and your initials. Lotion is water and oil held together, and it's the product a skincare maker is most likely to have trouble with. When a jar separates or grows something, this row is how you find out what that batch got. Here's the sheet, filled in, and the file.
The short version
- One row a batch, written while you make it.
- Three ingredient columns: water phase, oil phase, emulsifier and preservative, each with lot numbers.
- Two temperatures: heated to, and cool-down additions.
- pH, with the low and high of your preservative's range on the same row. The sheet says In range or ADJUST.
- TaroStack records the lots a batch used and holds your pH on the batch record. More below.
An example: two batches, one that needed adjusting
Hoʻola Botanicals is a made-up skincare maker in Kailua that I use in these examples. Its coconut lime lotion is made 4,000 grams at a time:
| Batch | Heated to | Cool-down adds at | pH | Range | pH check | Jars |
|---|---|---|---|---|---|---|
| LO-1104 | 165°F | 104°F | 5.4 | 4.8 to 5.8 | In range | 16 |
| LO-1111 | 165°F | 102°F | 6.1 | 4.8 to 5.8 | ADJUST | |
| LO-1111, second reading | 5.5 | 4.8 to 5.8 | In range | 17 |
And the lots, for LO-1104:
| Phase | Ingredients and lots |
|---|---|
| Water | Distilled water W-1101; glycerin GL-2291 |
| Oil | Coconut oil CO-0915; shea butter SB-0822 |
| Emulsifier and preservative | Emulsifying wax EW-3310; preservative PR-0907 |
Batch LO-1111 read 6.1, above the range. The maker added a little citric acid solution, stirred, read again and got 5.5. Both readings are on the sheet, on two rows, with a note. That's the right way to do it: the first reading isn't erased, and the second shows the batch was in range before it was filled.
Why these columns
The pH range comes from the preservative. A preservative works inside a pH range that its supplier publishes. Type that range on the row, not a number from memory. If you change preservative, the range changes with it.
Cool-down temperature matters for the same reason. Many preservatives and fragrance ingredients are damaged by heat, and their suppliers give a temperature to add them below. Writing 104°F on the row is proof you waited.
Lots are for the bad day. Shea butter SB-0822 was used in LO-1104, and a new lot, SB-1030, in LO-1111. If jars from one batch turn grainy and the other doesn't, the shea lot is the first thing to compare.
Jars filled is a check. The first batch filled 16 eight-ounce jars at 232 grams each, 3,712 grams of a 4,000 gram batch. The 288 grams that didn't make it are on the beaker, the stick blender and the funnel. If a batch of the same size fills 13, something was mis-weighed.
Batch numbers here are the product and the day: LO-1104 is lotion made November 4. Put the same code on every jar.
Get the sheet
Download the lotion making log sheet. The log, with a pH check that works itself out, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. A fuller, one-page-per-batch form is in cosmetic batch record template.
Where this stops working
Writing six lot numbers by hand, mid-batch, with wet gloves on, is the step that gets skipped. And the log lives apart from the shelf: it doesn't know the preservative is nearly out, or that the glycerin on hand expires next month.
How TaroStack does it
TaroStack writes the lots for you and keeps the readings with the batch.
A lotion is a recipe. Each ingredient by weight, with a jar, a lid and a label. Record a batch and each ingredient comes off stock from the lot that's due first. The batch record notes which lots were used, automatically.
Your checks are fields on the batch. Heated-to, cool-down temperature, pH and initials are fields of your own, and the batch-record form prints with them and a sign-off.
Hold it until it's right. A batch can be held, kept out of what's available to sell, until you release it.
Dates and reorders. Lots near their expiry are flagged, and the reorder list shows the preservative before it runs out.
One report if a jar comes back. From the batch to every lot in it, and to every customer who got a jar.
| The job | Log sheet | In TaroStack |
|---|---|---|
| Lot numbers for a batch | Six, by hand | Recorded with the batch |
| pH and temperatures | A row | Fields on the batch record |
| A batch not yet in range | A note | On hold until released |
| Who has jars from a batch | Order history, by hand | One report |
Recipes, batches, lots and holds 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.
