Free Download

Free Recipe Costing Template

Calculate What Every Product Costs to Make — Free

Download our FREE recipe costing template to calculate material costs, COGS, profit margins, and wholesale pricing for any handmade product. Works for soap, candle, jewelry, bakery, cosmetics — any maker business.

Used by thousands of makers worldwide
Free recipe costing template for makers showing material costs, recipe pricing, COGS tracker, and profit margin worksheet
Excel Numbers Google Sheets

Join the Craftybase mailing list and we'll send you our recipe costing template template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.

Stop guessing what your products cost — know exactly what every recipe costs to make before you set a price

If you're pricing your handmade products by checking what competitors charge, copying what you vaguely remember paying for materials, or just adding a markup and hoping for the best — you're not alone. But here's the problem: without knowing your actual recipe costs, you have no idea whether you're making money or just staying busy. And the more products you make, the more expensive that blind spot gets.

This free recipe costing template helps you calculate the true cost of every product you make — from raw materials through to finished goods, including profit margins and wholesale pricing. It works for any type of maker business: soap, candle, jewelry, bakery, cosmetics, and more.

  • Material cost tracking with VLOOKUP-driven unit costs per ingredient
  • Recipe costing for up to 3 product sections with automatic cost breakdown
  • Profit margin calculator — retail and wholesale margin per recipe
  • Monthly COGS tracker across all your products
  • Pricing reference with margin targets by sales channel (retail, Etsy, wholesale)
  • Compatible with Excel, Numbers, and Google Sheets

Pre-filled with worked examples (lavender soap, soy candle, sterling silver ring) so you can see exactly how it works before entering your own recipes. 303 built-in formulas — no manual calculation needed.

Cost Any Recipe

Enter your materials once, then build as many recipes as you need. Unit costs pull through automatically — change a material price and every recipe that uses it updates instantly.

Know Your Margins

See your retail margin, wholesale margin, and recommended sell price side by side. Know immediately if a recipe is profitable at your target price point — before you commit to making a full batch.

Track COGS Monthly

The built-in COGS tracker lets you log total cost of goods sold by product each month. Essential for tax reporting, bookkeeping, and understanding whether your business is actually profitable.

Ready to know what your products actually cost to make?

Download the free recipe costing template and start calculating real costs — not estimates.

Download the free template ↑

Excel, Numbers & Google Sheets compatible

How to Use the Recipe Costing Template

This template walks you through the complete recipe costing workflow — from entering your raw materials through to monthly COGS tracking. It's designed for makers who want accurate cost data without building formulas from scratch.

To get started, enter your email address above to download the file. Once downloaded, open it in Excel, Numbers, or upload it to Google Sheets. Start with the Instructions tab for a full walkthrough of each section.

Important note: Cells with a light turquoise background contain formulas — do not overwrite them. Only enter data in white cells. The pre-filled examples show you how the template works; replace them with your own materials and recipes when ready.

1

Instructions Tab — Start Here

The Instructions tab (teal) gives you a full walkthrough of the template: how each tab connects, what the colour-coded cells mean, and quick-start steps for entering your own data. Read this before editing anything else — it explains how the VLOOKUP formulas pull material costs from your Materials list into every recipe automatically.

Color legend
Turquoise cells are formula-protected. White cells are data-entry fields. The legend on this tab explains what each colour means across all sheets.
Quick-start steps
Follow the numbered steps: enter materials first, then build your recipes. The instructions tell you exactly which fields to fill in and in what order.
2

Materials Tab — Enter Your Ingredients

The Materials tab (blue) is your master ingredient list. Every raw material you use across any recipe goes here. The template comes pre-filled with 12 example materials — replace these with your own. Once entered, your material costs automatically flow into the Recipe Costing tab via VLOOKUP, so you never have to enter a cost twice.

Material name
Give each ingredient a clear, consistent name (e.g. "Coconut Oil", "Soy Wax C3", "Fine Silver Wire 24ga"). This is how the VLOOKUP matches materials in your recipes — names must match exactly.
Unit and cost per unit
Enter how you measure the material (oz, g, ml, each, inch) and what you pay per unit including shipping. If you bought 1kg of shea butter for $12 delivered, your cost per gram is $0.012. Use the landed unit cost — not the sticker price.

Pro tip: Add every material you ever use, even if only a handful of recipes need it. A comprehensive materials list means new recipes cost themselves automatically without you having to add entries later.

3

Recipe Costing Tab — Build Your Recipes

The Recipe Costing tab (green) is where you build each product recipe. The template comes pre-filled with three complete worked examples: a lavender soap loaf, a soy candle, and a sterling silver ring — so you can see exactly how the formulas work before replacing them with your own products. Each recipe shows the full cost breakdown: material costs per ingredient, total batch cost, cost per unit, profit margin at your sell price, and wholesale margin.

Ingredient rows
For each ingredient in the recipe, enter the material name (must match your Materials tab exactly), the quantity used, and the unit. The unit cost pulls through automatically via VLOOKUP and calculates the ingredient cost for this recipe.
Batch size and yield
Enter how many units one batch makes (e.g. a soap loaf yields 10 bars). The template divides total batch cost by yield to give you cost per finished unit — which becomes your COGS per sale.
Profit and margin
Enter your sell price and the template automatically calculates your profit margin and whether your pricing covers costs. Change the sell price and the margin updates instantly — useful for testing different price points before committing.
Wholesale margin
Enter your wholesale price separately to see your wholesale margin. Wholesale is typically 50% of retail — the template shows whether your recipes can support that without losing money.

Pro tip: Don't forget packaging in your ingredient list. Boxes, labels, shrink wrap, tissue, and bags are real costs that most makers forget to include — which means they're effectively giving away their packaging for free.

4

COGS Tracker Tab — Track Monthly Cost of Goods

The COGS Tracker tab (orange) gives you a monthly overview of your Cost of Goods Sold across all products. Log how many units of each product you sold each month along with the cost per unit from your Recipe Costing tab, and the tracker calculates your total COGS for the period. The template comes pre-filled with three example products to show the format.

Monthly entries
Add a row for each product you sell, each month. Enter the product name, units sold, and cost per unit (from your Recipe Costing tab). Total COGS calculates automatically.
Year-end total
At tax time, your annual COGS is already calculated — no manual reconciliation. This is the number your accountant needs for Schedule C or equivalent tax filing.
5

Pricing Reference Tab — Set Prices Confidently

The Pricing Reference tab (gray) is a static guide to help you set prices that actually cover your costs. It includes the standard handmade pricing formula, recommended margin targets by sales channel (DTC, Etsy, wholesale, consignment), a sanity check table, and a note on when to consider moving to dedicated recipe costing software. Nothing to fill in — it's a reference card you can return to whenever you're pricing a new product.

Pricing formula
The standard formula: (materials + labour + overhead) × markup. The reference tab explains each component and common markup multiples for different types of handmade businesses.
Channel margin targets
Target margins differ by channel: DTC direct (60–70%), Etsy (50–60% after fees), wholesale (40–50%), consignment (35–45%). The reference helps you understand whether your current prices are viable across different sales channels.

What is a Recipe Costing Template?

A recipe costing template is a spreadsheet that helps makers calculate the true cost of producing each product — from raw materials through to cost per finished unit, profit margin, and recommended sell price. Unlike a simple shopping list, a recipe costing template connects your material costs directly to each recipe so that changes in material prices automatically update every product cost that depends on them.

For makers, "recipe" has a broader meaning than cooking. A soap recipe is a formulation of oils, lye, fragrance, and additives. A candle recipe is a combination of wax, fragrance load, and wick specification. A jewelry recipe is a bill of materials listing wire gauges, findings, and gemstones. In all cases, the logic is the same: list what goes in, enter how much of each material you use, and the template calculates your cost per finished unit.

The alternative — pricing by guessing or copying competitors — is how most makers end up undercharging. If you don't know your actual costs, you can't know whether your prices cover them. A recipe costing template makes cost visibility the default, not the exception. Learn more about how to price handmade items profitably.

Why do makers need recipe costing?

Most makers set prices by feel or market comparison — which means they have no idea whether those prices actually cover what it costs to produce the item. The result is a business that looks like it's selling well but isn't actually generating profit. Recipe costing changes that.

When you cost each recipe properly, you can:

Set prices that actually cover your costs.
Instead of guessing, you know your break-even and can set a price that builds in a real margin above it.
Identify which products are most profitable.
Some recipes that seem inexpensive to make turn out to have surprisingly tight margins once material costs are properly calculated. Recipe costing surfaces this before you commit to production.
Respond to material price increases.
When your supplier raises prices, you can immediately see which products are affected and by how much — and adjust your prices accordingly, rather than discovering the problem months later when you run your numbers for tax time.
Quote wholesale with confidence.
Wholesale buyers expect 50% of retail as a standard minimum. Without knowing your actual costs, you can't know whether that price covers your materials — and many makers discover too late that they've been accepting wholesale orders that lose money on every unit.

What should a recipe costing template include?

A good recipe costing template for makers should cover:

Materials list:
A master list of every ingredient or component you use, with unit of measure and cost per unit. This is the foundation — every recipe pulls costs from here, so keeping it accurate and current is essential.
Recipe sections:
For each product, a list of ingredients with quantities used. The template calculates ingredient cost (quantity × unit cost) and totals them to give a batch cost and cost per finished unit.
Yield tracking:
How many finished units does one batch produce? A loaf of soap might yield 10 bars; a litre of lotion might fill 20 bottles. Yield converts batch cost into per-unit COGS.
Margin calculator:
Enter your sell price and see the margin automatically. Ideally shows both retail and wholesale margins side by side so you can evaluate each price point.
COGS tracker:
A way to accumulate cost of goods sold across all products over time. Essential for bookkeeping and tax reporting. Without this, you're guessing your annual COGS from scratch every April.

Why spreadsheets may not be enough as your product range grows

A recipe costing template is a great starting point. But as you add more products, more materials, and more sales channels, the manual work compounds. Every purchase requires you to update material costs. Every production run requires you to log what you used. Every sale requires you to calculate COGS manually. The spreadsheet stays static; your business keeps moving.

The bigger problem is inventory. A recipe costing template tells you what a batch costs to make. It doesn't tell you how much of each material you have on hand, whether you can make 20 more units before ordering supplies, or what your on-hand inventory is worth right now. That requires live tracking — which spreadsheets can't do automatically.

That's where maker inventory software like Craftybase comes in. When you record a purchase, material costs and on-hand quantities update automatically. When you manufacture a batch, Craftybase deducts materials from inventory and records the manufacture cost. When you record a sale, it reduces finished goods inventory and calculates COGS in real time. Read about how Craftybase handles recipe costing for growing maker businesses.

When to move from a spreadsheet to recipe costing software

If any of these sound familiar, a dedicated system is probably overdue:

  • You have more than 10 products and can't remember which materials go into which recipes without checking the spreadsheet every time.
  • Material prices keep changing and you're not sure which recipes have been updated and which are using stale costs.
  • You're selling on multiple channels (Etsy, Shopify, markets) and can't keep track of what you have in stock or what you've already sold.
  • Tax season means hours of manual reconciliation — you're not confident your COGS numbers are right.
  • You've started wholesale and need to quote customers based on actual costs, not estimates.
  • You've run out of a key material mid-batch because you didn't know stock was low — the spreadsheet wasn't up to date.

Craftybase is built for small-batch makers who need recipe costing, inventory tracking, and COGS reporting in one system — without the cost and complexity of enterprise software. When you outgrow this spreadsheet, your recipe data migrates cleanly.

Recipe Costing Template FAQ

To calculate a recipe cost, list every material that goes into the product, enter the quantity used and the cost per unit for each, then sum all ingredient costs. Divide by the number of finished units the batch produces to get cost per unit. For example, if a soap batch uses $8.40 of oils, $1.20 of lye, and $2.00 of fragrance oil, total batch cost is $11.60. If the batch makes 10 bars, cost per bar is $1.16 — your COGS per unit sold. This template handles all the multiplication and summing automatically once you enter materials and quantities.

Yes — labour is a real cost and should be included in recipe costing if you want to understand true profitability. Estimate how long one batch takes (mixing, curing, cutting, packaging, labelling), multiply by a fair hourly rate for your time, and divide by batch yield to get labour cost per unit. Most makers who don't include labour discover they're effectively working for free or below minimum wage. For tax purposes, labour cost to yourself isn't always deductible the same way material costs are — check with your accountant — but it belongs in your pricing regardless.

Most successful handmade businesses aim for 50–70% gross profit margins on direct-to-consumer sales (retail and Etsy). This means if a product costs $5 to make in materials and labour, you'd price it at $10–$16 retail. For wholesale, margins are tighter — typically 40–50% — because you're selling at wholesale price (usually 50% of retail). Your target margin needs to cover not just recipe costs but also your business overhead: packaging, marketplace fees, shipping supplies, market booth fees, software subscriptions, and other operating costs. Recipe cost is the floor — margin above it funds your business.

When a material price changes, update the unit cost in your Materials tab. Because recipe costs pull from the Materials tab via VLOOKUP, every recipe that uses that material will automatically recalculate with the new cost. This is one of the key advantages of using a structured template rather than entering costs directly into each recipe — price updates propagate instantly across your entire product range. Review your material costs whenever you reorder supplies, especially for volatile commodities like oils, wax, precious metals, and fragrance oils.

COGS (Cost of Goods Sold) is the total material cost of products you actually sold during a period — not what you spent on supplies, but what you spent making the specific items that sold. It's a required figure for tax reporting (it reduces your taxable income), bookkeeping, and calculating your gross profit. COGS = beginning inventory + purchases − ending inventory, or more simply: units sold × cost per unit across all products. The COGS Tracker tab in this template makes it easy to accumulate this number monthly so you're not starting from scratch at tax time.

Yes — the template is designed to work for any type of maker business. The pre-filled examples cover three different product types (soap, candle, and jewelry) to demonstrate how the same recipe costing logic applies across different crafts. Replace these examples with your own products. Soap makers enter oils, lye, and additives. Candle makers enter wax, fragrance, and wick. Jewelry makers enter wire, findings, and gemstones. Bakers enter flour, butter, and decorating supplies. The underlying cost calculation — quantity used × unit cost, summed per recipe — works for anything you make from materials.

A general inventory spreadsheet tracks what stock you have on hand. A recipe costing template calculates what it costs to make each product. They solve different problems and are often used together. The recipe costing template tells you your cost per unit and margin — information you need to set prices. The inventory spreadsheet tells you how much stock you have and what it's worth — information you need to manage supply and report to the tax authority. Once a business grows beyond a handful of products, dedicated software like Craftybase handles both in one system, with live inventory updates as you manufacture and sell.

Who Should Use This Recipe Costing Template?

This free recipe costing template is built for makers at any stage who need to understand what their products actually cost to produce.

New makers setting prices for the first time

If you're just starting out and aren't sure how to price your products, this template gives you a structured way to calculate costs before you commit to a price. You'll know your break-even and can set a price with confidence, not guesswork.

Soap and skincare makers

Cold process and hot process soap recipes involve precise formulations with oils, lye, fragrance, and additives. This template handles multi-ingredient recipes with different units (oz, g, ml) and calculates cost per bar or unit sold.

Candle makers

Candle costing needs to track wax, fragrance load (typically 6–12% of wax weight), wicks, vessels, and labels — all with different units and prices. This template handles mixed-unit recipes and calculates cost per candle, including vessel cost which often exceeds the wax cost.

Jewelry makers

Jewelry recipes list wire gauges, beads, findings, clasps, and gemstones — many of which are tracked by different units (grams for silver, inches for wire, each for findings). The template supports mixed units and calculates cost per finished piece.

Bakers and cottage food businesses

Baked goods costing requires tracking flour types, dairy, eggs, and decorating supplies — often purchased in bulk quantities but used in small amounts per batch. The template converts bulk purchase prices into per-unit costs automatically.

Wholesale makers needing accurate quotes

If you're approaching boutiques, gift shops, or wholesale buyers, you need to know your costs precisely. Wholesale pricing typically runs at 50% of retail — without accurate recipe costing you can't know if that covers your materials, let alone leaves margin for profit.

Makers preparing for tax season

If you need accurate COGS numbers for tax filing and dread the annual scramble, this template gives you a structured way to track cost of goods sold monthly. At year end, the total is already calculated — no reconstruction from receipts needed.

Growing maker businesses evaluating software

If you're considering moving to dedicated maker software but aren't ready yet, this template gives you the cost visibility you need in the meantime. When you do move to Craftybase, your material and recipe data gives you a clean starting point.

Ready to outgrow the spreadsheet?

Craftybase tracks recipe costs, material inventory, and COGS automatically — so you always know what every product costs to make, what you have in stock, and what you made in profit. Built for small-batch makers who need real numbers without enterprise complexity.

Start a 14 day free trial →

No credit card required. Cancel anytime.