{"product_id":"soap-maker-spreadsheet-batch-log-cure-board-and-true-cost-tracker-for-handmade-soap-business","title":"Soap Maker Spreadsheet | Batch Log, Cure Board and True Cost Tracker for Handmade Soap Business","description":"\u003cp\u003e\u003cstrong\u003eINSTANT DOWNLOAD — HOW IT WORKS:\u003c\/strong\u003e This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.\u003c\/p\u003e\u003cp\u003eYou 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?\u003c\/p\u003e\n\u003cp\u003eMost 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.\u003c\/p\u003e\n\u003cp\u003eTransparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.\u003c\/p\u003e\n\u003cp\u003eMORE THAN A FREE INVENTORY SHEET: a free inventory sheet tracks ingredients alone. This tracker covers the whole soap business by scope — 11 tabs for recipes, batches, cure tracking, inventory, pricing, sales by channel and restock signals — so the paperwork around every batch lives in one place. It is a log and costing tool for the maker's own recipes and numbers.\u003c\/p\u003e\n\u003cp\u003eTHE 11 TABS\u003cbr\u003e• 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 %\u003cbr\u003e• 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\u003cbr\u003e• Recipe Library — one row per ingredient in each recipe, with bars per batch and cure weeks set per recipe; batch ingredient costs total themselves\u003cbr\u003e• Batch Log — one row per batch you pour: recipe, pour date, bars made — the batch's total cost pulls in by itself\u003cbr\u003e• 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\u003cbr\u003e• 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\u003cbr\u003e• Cost \u0026amp; 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\u003cbr\u003e• Sales by Channel — every sale logged with its channel; fees come off, the net figures itself out, and each channel totals itself\u003cbr\u003e• Monthly Summary — log what the business spends; the monthly summary rolls sales income and expenses into profit and profit margin by month, by itself\u003cbr\u003e• 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\u003cbr\u003e• 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\u003c\/p\u003e\n\u003cp\u003eHOW THE CURE BOARD WORKS\u003cbr\u003eReady 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.\u003c\/p\u003e\n\u003cp\u003eHOW PRICING IS FIGURED — ONE METHOD, NO HIDDEN MATH\u003cbr\u003eTrue 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.\u003c\/p\u003e\n\u003cp\u003eTHE SAMPLE MONTH\u003cbr\u003eIt 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.\u003c\/p\u003e\n\u003cp\u003eONE HONEST NOTE\u003cbr\u003eThis 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.\u003c\/p\u003e\n\u003cp\u003eFINISHED 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.\u003c\/p\u003e\n\u003cp\u003eREQUIREMENTS: 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.\u003c\/p\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e","brand":"InkSheet Studio","offers":[{"title":"Default Title","offer_id":68083121094941,"sku":null,"price":2.69,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1015\/0618\/7549\/files\/01-hero_b50c8ccc-14c6-4992-8773-36baa426412d.jpg?v=1794696929","url":"https:\/\/inksheetstudio.com\/products\/soap-maker-spreadsheet-batch-log-cure-board-and-true-cost-tracker-for-handmade-soap-business","provider":"InkSheet Studio","version":"1.0","type":"link"}