Soap Maker Spreadsheet | Batch Log, Cure Board and True Cost Tracker for Handmade Soap Business

You poured that lavender batch six weeks ago — or was it five? Can it sell at Saturday's market, or does it need another week on the rack? And the bar everybody buys: once the marketplace takes its fee, the packaging comes off and your hour at the soap pot is counted — does it actually earn what you think it earns?

Most soap spreadsheets stop at ingredient lists. This one runs the whole business around the cure: your recipes carry their costs with them, every batch you pour lands on a Cure Board that figures the first day it can sell, your true cost per bar includes packaging, your labor AND the selling fee, and your sales split themselves by channel — Etsy, market, wholesale, website — so you can see where the money really comes from. In the sample month inside, the Sea Salt Spa Bar sells all day long and is the one bar priced under target once the fee comes off. The sheet knows which of yours that is.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

THE 11 TABS

Start Here — plain-English quick start, plus the three settings that run the whole sheet: your target margin %, your labor rate, and your wholesale margin %

Dashboard — batches ready to sell, bars ready, batches and bars still curing, the next ready date, this month's profit, and the recipe margin board: every recipe's true margin after fees, flagged against your target

Recipe Library — one row per ingredient in each recipe, with bars per batch and cure weeks set per recipe; batch ingredient costs total themselves

Batch Log — one row per batch you pour: recipe, pour date, bars made — the batch's total cost pulls in by itself

Cure Board — the headline: you never type here. It reads your Batch Log and your cure weeks and shows every batch's ready date, days left, and a READY / AGING / NOT READY flag that updates itself every day

Ingredient Inventory — your price list and stock room in one: unit costs, on-hand counts, par levels, and an OK / ORDER SOON / OUT status with the exact amount to order

Cost & Pricing — recipes pull in by themselves. Add packaging per bar, labor minutes per batch and the selling fee %, and see your true cost per bar, a suggested retail price that protects your margin after the fee, the true margin on the price you actually charge, and a suggested wholesale price

Sales by Channel — every sale logged with its channel; fees come off, the net figures itself out, and each channel totals itself

Monthly Summary — log what the business spends; the monthly summary rolls sales income and expenses into profit and profit margin by month, by itself

Weekly Make List — the production plan: set each recipe's target shelf stock from what sold, and the list shows bars ready, bars still curing, and exactly which batches to pour this week — long-cure recipes flagged first

Restock Signals — every ingredient with the full production rounds your stock still covers: ORDER NOW, ORDER SOON, or the early PLAN AHEAD warning when fewer than two full rounds are left

HOW THE CURE BOARD WORKS

Ready Date = pour date + (cure weeks × 7 days), using the cure length you set for that recipe in the Recipe Library. The flag reads READY once the date arrives, AGING when the batch is within 14 days of ready, and NOT READY before that — all driven by today's date, so the board is correct every time you open it. Pour the batch, log it once, and you never count weeks on your fingers again.

HOW PRICING IS FIGURED — ONE METHOD, NO HIDDEN MATH

True Cost per Bar = (batch ingredient cost + packaging per bar × bars per batch + your labor for the batch) ÷ bars per batch. Suggested Retail = cost per bar ÷ (1 − target margin − selling fee %), so when your costs are covered at the suggested price, the margin you aimed for is the margin you keep — after the fee, not before it. Suggested Wholesale = cost per bar ÷ (1 − wholesale margin); wholesale orders carry no marketplace fee. Your Price is always yours to set — the sheet just shows you the true margin it really earns and flags anything below target. The tracker starts at a 60% target margin, $15/hour for your time and a 40% wholesale margin; change any of the three in one shaded cell on Start Here and every price, margin and flag follows it.

THE SAMPLE MONTH

It comes loaded with one fictional autumn (Willow Creek Soap Co., October 2026 — five recipes, eight batches on the cure racks: three ready to sell, three aging, two still curing, and two ingredients running low) so you can watch every formula work before you delete the samples and type your own. Formulas are pre-filled down the columns — 20 batch rows, 39 recipe lines, 29 stock items, ready to go.

ONE HONEST NOTE

This tracker records your recipes and your numbers — it does not calculate lye amounts and gives no recipe, safety or cosmetic advice. Your tested recipes stay yours; this is the business paperwork around them.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — nothing to install, and the Cure Board is right there on your phone at the market when a customer asks what's ready.

This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.