Soap Pricing Calculator Spreadsheet, Oil Butter Lye Cost, Profit Margin Tool, Google Sheets Excel

Price every bar of soap so you actually get paid for your time.

Oils, butters, lye, essential oils, fragrance, additives, labels, your minutes of work, overhead and Etsy fees. This calculator adds it all up and tells you the minimum price that still hits your target margin. In the example data, a $7 guest soap trio LOSES money once 15 minutes of work at $20/hour is counted.

WHAT IT DOES
✓ Materials library already set up for soap: cost per gram of oil, butter and lye, per ml of essential oil, per label, worked out from pack prices
✓ Recipes: list what each bar uses (e.g. 40 g olive oil + 30 g coconut oil + 15 g shea + 14 g lye + 3 ml essential oil) and the material cost is totalled for you
✓ Adds your labor (minutes × hourly wage), overhead % and marketplace fees
✓ Gives the MINIMUM price for your target profit margin
✓ Suggests wholesale and retail prices for shops and markets
✓ Instant verdict on your current price: Healthy, Raise price or LOSING MONEY

Note: this is a pricing and cost tool, not a lye calculator. Work out your lye and water amounts with your usual lye calculator, then enter them here to cost them.

WHAT YOU GET
• Excel file (.xlsx)
• PDF with your Google Sheets "make a copy" link and a setup guide
• Example soaps already filled in (lavender oat bar, charcoal tea tree bar, guest soap trio), so clear the yellow cells when you're ready to add yours

WORKS WITH
Google Sheets (free) and Excel 2016+/Microsoft 365, on Mac, Windows, iPad and Chromebook.

Made by Ahmed (finance + automation). Questions? Message me and I'll reply within one business day.
Digital download, nothing shipped. Not affiliated with Etsy, Inc.