Skip to content

Soap Batch Calculator: Resize a Recipe to Fit the Mold

A soap batch calculator in Excel: resize a cold process recipe to the batter your molds take, with oils, lye, water and fragrance by weight and cost a bar.

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 19, 2026 · 6 min read

In a cold process soap recipe, the oils are the 100%. Lye, water and fragrance are each a share of the oil weight. To resize a recipe, keep every share the same and change the oil weight. To fit a mold, work backward from the batter it takes: oils = batter ÷ (1 + the lye share + the water share + the fragrance share). Molds that take 11,000 g of batter, with a recipe whose lye is 13.98% of the oils, water 27.96% and fragrance 3%, need 11,000 ÷ 1.4494 = 7,589 g of oils. One warning comes before everything else: the lye share belongs to one exact mix of oils.

The short version

  • Oils are the 100%. Each oil has its share of that.
  • Lye, water and fragrance are shares of the oil weight.
  • Resizing keeps every share and changes the oil weight.
  • Change an oil, or its share, and the lye must be worked out again with a lye calculator.
  • Weigh everything in grams, lye and water included.
  • TaroStack scales the recipe to the batch and records which lots went into each one. More below.

Why the lye can't be carried over

Each oil needs its own amount of lye to turn into soap. That figure is its saponification value. For a made-up soap maker's recipe, using SoapCalc's published values for sodium hydroxide:

Oil Share of the oils Lye for 1 g of this oil Lye for 100 g of oils
Olive oil 45% 0.135 g 6.075 g
Coconut oil, 76 degree 30% 0.183 g 5.49 g
Shea butter 15% 0.125 g 1.875 g
Castor oil 10% 0.128 g 1.28 g
All of the oils turned to soap 14.72 g
With 5% of the oils left over (superfat) × 0.95 13.98 g

Swap the coconut for more olive and the answer drops, because olive needs less. Too much lye makes a harsh bar that can burn skin. So the 13.98% in the example is for these four oils in these shares and nothing else. Run your own recipe through a lye calculator, and run it again whenever an oil changes.

The recipe, resized to 11,000 g of batter

Ingredient Share Amount Cost
Olive oil 45% of the oils 3,415.2 g $19.47
Coconut oil 30% 2,276.8 g $9.79
Shea butter 15% 1,138.4 g $12.07
Castor oil 10% 758.9 g $6.00
Oils together 100% 7,589.3 g
Sodium hydroxide (lye) 13.98% of the oils 1,061.0 g $5.30
Distilled water 27.96% 2,122.0 g $0.64
Fragrance oil 3% 227.7 g $10.04
Batter 11,000.0 g $63.30

The water here is twice the lye, a common choice. At 142 g of batter a bar, the batch pours 77 bars, and the ingredients come to $0.82 a bar. A 142 g pour cures to roughly a 4.5 oz bar as it loses water.

Three sizes

Batter Oils Lye Water Fragrance Bars Ingredients
2,750 g 1,897.3 g 265.2 g 530.5 g 56.9 g 19 $15.83
11,000 g 7,589.3 g 1,061.0 g 2,122.0 g 227.7 g 77 $63.30
22,000 g 15,178.7 g 2,122.0 g 4,244.0 g 455.4 g 154 $126.60

How much batter a mold takes

If you've used the mold, you know: weigh the batter that went in. If it's new, a common rule gives the oils.

Step Example: a loaf mold 10 × 3.5 in, poured 2.5 in deep
Length × width × pour depth 87.5 cubic inches
× 0.40 = ounces of oils (the common rule) 35 oz, or 992 g
× 1.4494 (1 + this recipe's three shares) = batter 1,438 g

Type 1,438 as the batter and the sheet gives the oils back as 992 g. Then make it, see how full the mold is, and correct the number for next time.

What changes in a bigger batch

Lye solution for a 22,000 g batch gets hotter and stays hot longer than a small one. Big batches reach trace differently, and a stick blender that suited one loaf struggles in a bucket. Scales matter too: weigh lye on a scale that reads to a gram or finer, and check it with a known weight. The steps are in how to make soap in bulk.

Get the calculator

Download the soap batch calculator. Type the batter your molds take, your oils and their shares, and the lye share from your lye calculator. It shows every weight, the bars and the ingredient cost a bar. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. The sheet doesn't work out lye. For the full cost of a bar with packaging and time, see the soap making cost calculator.

Where this stops working

Soap is sold four to six weeks after it's made. By then nobody remembers which pail of coconut oil went into the lavender loaf of March 3, and the calculator never knew. A bar that comes back with a complaint leads nowhere.

How TaroStack does it

TaroStack ties each bar back to its batch and the batch to its oils.

The recipe scales to the batch. It holds the oils, lye, water and fragrance by weight, and its batch size. Record a 77-bar batch or a 154-bar one and the amounts follow. A changed recipe is a new version, with the old one kept.

Recording the batch notes the lots. The oils, the lye and the fragrance used go onto the batch record automatically. The bars get a batch code of their own: see how to create batch numbers for soap.

On hold while it cures. A batch on hold is kept out of what you can sell until you release it.

Your own fields. Lye and oil temperatures, the cure-by date and initials go on the batch-record form.

Recipe truth. From your own batches, TaroStack shows whether the recipe gives the bars it claims.

The job Calculator and notebook In TaroStack
Weights for this batch Type the batter The recipe, scaled to the batch
Which oils went into this loaf Unknown by week four On the batch record
Still curing A date on the rack On hold
Bars the recipe really gives Counted, then forgotten Recipe truth

TaroStack doesn't work out lye: it records the recipe you give it. 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

How do I resize a soap recipe?

Keep each oil's share of the oils, and keep lye, water and fragrance as the same shares of the oil weight. Change the oil weight and multiply.

Do I need to recalculate lye when I resize?

Not if every oil keeps its share: the lye stays the same percent of the oils. Change an oil or its share and you do.

How much oil does my soap mold need?

A common rule is length × width × pour depth in inches × 0.40, which gives ounces of oils. Check it against your first batch.

Sources

  1. SoapCalc: oil list, saponification values for NaOH (olive 0.135, coconut 76 deg 0.183, shea butter 0.125, castor 0.128) · read November 19, 2026

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.