Recipe & Batch Log

About this spreadsheet

What you get

You made a batch of soap that came out perfect and cannot find what you did differently. There are three trays curing and you are not sure which one is ready. A friend asks what a candle costs and you only know the price of the wax. And on making day you find the shea butter jar empty.

This spreadsheet keeps everything you make in one place. Type each ingredient once with its pack size and price: it works out the cost per gram or per piece. Write your recipes in grams: it shows the % of each ingredient and what every line costs. Log each batch with the date and the recipe: it shows the ready-on date, the days left, Curing / Nearly ready / Ready, the batch cost and the cost per bar, jar or tin. Inventory subtracts what your batches used and warns you to reorder. Formula cells are locked, a full Example shows how it works, and it opens in Excel, Google Sheets and Numbers.

Who it is for

• Anyone who makes soap, candles, wax melts, balms or lip balm at home
• Makers who want recipes they can repeat exactly, batch after batch
• Anyone who gives or swaps what they make and wants to know the real cost per item

What's inside

• Start Here tab: 3 steps, colour key, how the numbers work
• Example tab: 20 ingredients, 6 recipes, 10 batches, costs and 3 charts
• Settings: currency, date format, g or oz, pcs, warnings, curing days for 11 product types, categories
• Recipes: 40 recipes + 300 ingredient lines with weight, % of weight, line cost and a check
• Batches (200 rows): ready on, days left, status, batch cost, cost per unit, rating + chart
• Costs per item (auto): cost per recipe, per gram and per unit, spent, average rating, optional margin + chart
• Inventory (80 rows): cost per unit, used in batches, on hand, value, status + chart
• Quick Start PDF: open it, tab by tab, tips, printable batch log and recipe card (filled + blank)

How to use it

1. Open in Excel or make your Google Sheets copy
2. Type your ingredients with pack prices, then one recipe
3. Log every batch and let the sheet work out ready dates and costs

Formats

• Excel workbook (.xlsx) with working formulas and charts
• Opens in Google Sheets (File → Import) and Numbers
• Printable PDF guide with blank log pages, A4 and US Letter

At a glance: 7 tabs · auto ready dates + costs · 6 charts · Excel + Google Sheets

Part of The DIY Natural Beauty Studio Bundle: https://naturalknows.com/the-diy-natural-beauty-studio-bundle/

Digital download · All sales final