Skip to content

Lotion Batch Calculator: Percent Formula to Grams

A lotion batch calculator in Excel: turn a percent formula into grams for any batch size, check it adds to 100%, and see jars filled and the cost of each jar.

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 · 5 min read

Lotion formulas are written in percent by weight so they work at any size. To make a batch, multiply the batch weight by each ingredient's percent: in a 4,000 g batch, water at 70% is 2,800 g and a preservative at 1% is 40 g. The percents have to add to exactly 100. Then divide the batch by what one jar takes, less what stays in the pot, to find how many jars you'll fill. Below is a worked formula at three sizes, how to size a batch for an order, and an Excel file that does it and checks the total.

The short version

  • Grams of each ingredient = batch weight × its percent.
  • Everything by weight, water included.
  • The percents must add to 100. If they don't, something is missing or doubled.
  • Batch for an order = jars × fill weight ÷ (1 − your loss).
  • Small percents need a scale that reads to 0.1 g or better.
  • TaroStack scales the formula to the batch and records which lots went in. More below.

A formula, as percent and as grams

A made-up skincare maker's lotion. The percents are an example for the arithmetic, not a tested formula.

Ingredient Phase Share In 4,000 g Cost
Distilled water Water 70% 2,800 g $0.84
Glycerin Water 4% 160 g $1.06
Coconut oil, fractionated Oil 10% 400 g $5.28
Shea butter Oil 6% 240 g $2.54
Emulsifying wax Oil 5% 200 g $3.08
Stearic acid Oil 3% 120 g $1.06
Preservative Cool-down 1% 40 g $2.12
Fragrance Cool-down 1% 40 g $3.53
Total 100% 4,000 g $19.50

At 232 g a jar, 4,000 g fills 17 jars on paper, and the ingredients come to $1.15 a jar.

Three batch sizes

Batch Water Oils and wax Preservative Fragrance Jars at 232 g Ingredients
1,000 g 700 g 240 g 10 g 10 g 4 $4.88
4,000 g 2,800 g 960 g 40 g 40 g 17 $19.50
8,000 g 5,600 g 1,920 g 80 g 80 g 34 $39.00

The oils and wax column adds the four oil-phase rows. Glycerin makes up the rest.

Size the batch for the order, with the loss in

Seventeen jars at 232 g is 3,944 g. That leaves 56 g of a 4,000 g batch, which is 1.4%. If more than that stays on the pot, the stick blender and the piping bag, the seventeenth jar comes up short. So work the other way:

Step Sum Result
Jars wanted × fill 34 × 232 g 7,888 g
Loss allowed 3%
Batch to make 7,888 ÷ 0.97 8,132 g

Weigh the pot before and after a batch or two to find your own loss. Three percent is this maker's figure.

Things the percent hides

Thing Why it matters
The scale 1% of a 500 g test batch is 5 g. A scale that reads in whole grams is too coarse for that
Water lost to heating A water phase held hot loses weight. Weigh it after heating and top it up
Preservative rate The supplier states the range for their product. Use theirs, not this example's
Fragrance limit The fragrance's supplier gives a maximum for leave-on products
A change to one percent Something else has to change to keep the total at 100. Usually the water

What to write down for each batch is in lotion making log sheet and cosmetic batch record template. How long the finished lotion keeps is in lotion shelf life.

Get the calculator

Download the lotion batch calculator. Type the batch size and your formula's percents. It shows the grams of each, says whether the percents add to 100, and works out the jars and the cost a jar. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. To add jars, labels and your time, use the batch cost calculator.

Where this stops working

The calculator gives the same answer for every batch. Real batches aren't the same: this one used the new drum of shea, that one was made with the last of the old preservative, and a customer's jar has a batch code that leads to a line in a notebook, if it leads anywhere.

How TaroStack does it

TaroStack makes the formula the recipe and each batch a record.

The formula scales to the batch. A recipe holds its ingredients and its batch size, with versions kept when the formula changes. Record a 4,000 g batch or an 8,000 g one and the amounts follow.

Recording the batch notes the lots. Which shea, which preservative, which fragrance: the lots used go onto the batch record automatically, and the jars get a lot code of their own.

"What could I make right now" says how many jars the ingredients and the empty jars on hand can make.

Your checks go on the batch. pH, temperatures and initials are fields of your own on the batch-record form.

Dates on every lot. Ingredients and finished jars carry their dates, and the soonest to expire is used first.

The job Calculator and notebook In TaroStack
Grams for this batch Type the size The recipe, scaled to the batch
Which lots went in Written down, sometimes On the batch record
A jar's batch code Leads to a notebook Leads to the batch and its lots
Preservative near its date Read the drum An alert

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 convert a lotion formula from percent to grams?

Multiply the batch weight by each percent. For a 1,000 g batch, 5% is 50 g.

How do I scale a lotion recipe?

Keep the percents and change the batch weight. Every ingredient changes by the same proportion.

Why are lotion formulas written by weight?

Oils, butters and water have different densities, so a millilitre of each weighs a different amount. Weight is the same for all of them.

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.