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.
