Skip to content

Soap Inventory Spreadsheet: Oils, Lye, Curing Bars

A free soap inventory spreadsheet for a soap maker: oils and lye by the pound, scents by the ounce, bars on the curing rack with a ready date, and reorders.

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

A soap maker's inventory has a row most businesses don't: bars that exist but can't be sold yet. Cold process soap sits on a rack for four to six weeks before it's ready, and a sheet that lumps curing bars in with finished ones will promise a shop stock you don't have. So a soap inventory spreadsheet needs oils, butters and lye counted in pounds, scents in ounces, boxes and labels in eaches, and bars in two rows: curing, with the date they're ready, and ready to sell. The one below is filled in for a made-up soap maker and free to download.

The short version

  • Raw materials by weight, in the unit you buy and weigh in.
  • Lye on its own row, with a reorder amount that never lets you run out mid-week.
  • Bars in two rows: curing (with a ready date) and ready (with a best-by).
  • Every batch gets a number, written on the rack and on the sheet.
  • TaroStack takes the oils off stock when you record a batch and holds curing bars until they're ready. More below.

An example sheet

Salt Marsh Soap Co. is a made-up Charleston soap maker I use in these examples. Its sheet has eleven rows. The first six:

Item Unit On hand Reorder at Unit cost Value Status
Olive oil, pomace lb 70 35 $2.60 $182.00 OK
Coconut oil, 76 degree lb 50 35 $1.95 $97.50 OK
Shea butter, refined lb 18 10 $4.80 $86.40 OK
Sodium hydroxide (lye) lb 16 20 $2.25 $36.00 REORDER
Lavender essential oil oz 24 16 $2.90 $69.60 OK
Sweet orange essential oil oz 10 16 $1.10 $11.00 REORDER

Below those are kaolin clay, boxes, labels, and the two rows of lavender bars: 240 curing and 130 ready, at $1.92 a bar. Everything on the sheet comes to $1,456.90. Lye and sweet orange are under their reorder amounts.

The lye row is worth $36 and it can stop the whole shop. That's the argument for giving the cheapest row the most generous reorder amount. This maker uses about 7 lb a week and the chemical supplier ships in a week, so 20 lb is the wait plus nearly two weeks spare.

Bars on the rack

The curing row has a reorder amount of zero on purpose. You don't reorder curing bars. You make them. What that row needs is on the Lots sheet:

Made Item Batch Bars Ready or best by
Oct 27 Lavender bars, curing LAV-1027 240 Ready Dec 8
Sep 15 Lavender bars, ready LAV-0915 288 made, 130 left Best by Sep 15, 2028

Six weeks from October 27 is December 8. Until then those 240 bars aren't stock you can promise. The sheet counts down the days, and when the date arrives you move the count from the curing row to the ready row and give the batch its best-by date.

Batch numbers are what tie a bar back to its oils. A simple scheme is the scent and the day it was poured. More schemes are in how to create batch numbers for soap.

Scents fade first

Oils and butters keep for a year or more when they're sealed and cool. Citrus essential oils are the short-dated row: sweet orange bought in May carries a December date on this sheet, and the Lots tab flags it USE FIRST inside 30 days. Write the supplier's lot and date for every bottle and jug as it arrives. If a customer ever reacts to a bar, the lot of the fragrance is the first thing you'll want to know.

Get the spreadsheet

Download the soap inventory spreadsheet. Four sheets: the inventory with value and REORDER, lots and batches with days left, a count sheet that fills itself, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. What a bar costs to make is worked out in soap making cost calculator.

Where this stops working

Every batch means subtracting six or seven things from the sheet by hand: this much olive, this much coconut, this much lye. Skip it twice and the sheet is fiction. And the move from curing to ready depends on somebody opening the file on the right day.

How TaroStack does it

TaroStack does the subtracting, and it watches the rack.

A recipe for each soap. Your lavender bar is a recipe: pounds of each oil, lye, ounces of scent, a box and a label. Record a batch of 240 and every ingredient comes off stock, from the lot that's due first.

Curing bars are on hold. A new batch can be held, kept out of what's available to sell, until its ready date, then released. A shop's order can't take bars that are still on the rack.

The batch knows its lots. Which jug of olive oil, which bottle of lavender: it's on the batch record without anybody writing it down.

What it really cost. When coconut oil goes up, the next batch's bars cost more, and you see it.

The job Spreadsheet In TaroStack
Oils after a batch Subtract seven rows Come off with the batch
Bars still curing A separate row you move by hand On hold until released
Which scent lot is in a bar Notes On the batch record
When to buy lye Watch for red A reorder list

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.

Questions people also ask

How do I keep track of soap making supplies?

List each oil, butter, lye and scent with the weight on hand and a reorder amount, and subtract what every batch uses. Count the shelf once a month, by weight.

How do you track curing soap?

Give every batch a number and a ready date, write both on the rack, and keep curing bars in their own row until the date comes.

How much inventory should a soap business keep?

Enough raw material for the supplier's lead time and a week or two more, and enough ready bars for your next market and any standing orders. The wider plan is in soap business plan.

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.