Free Download

Free Bakery Costing Spreadsheet

Know Your Real Baking Costs — Free Excel Template

Download our FREE bakery costing spreadsheet to calculate accurate recipe costs, track ingredient prices, allocate overhead, and set profitable prices for your baked goods.

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

Trusted by 3,000+ makers
Free bakery costing spreadsheet for recipe costing and ingredient tracking
Excel Numbers Google Sheets

Stop guessing what your products actually cost to make

If you're still pricing your baked goods by feel — adding up ingredient costs in your head and hoping you're charging enough — you're not alone. But here's the thing: when you don't know your true costs, it's impossible to know if you're actually making money or just staying busy.

This free bakery costing spreadsheet helps you calculate exactly what each recipe costs to produce — including ingredients, packaging, labor, and overhead. Once you know your real numbers, you can set prices that cover your costs and leave room for profit.

  • Recipe cost calculator with ingredient breakdowns
  • Per-batch and per-unit cost tracking
  • Overhead allocation (utilities, packaging, labor)
  • Profit margin calculator
  • COGS calculation for accurate bookkeeping
  • Compatible with Excel, Numbers, and Google Sheets

Perfect for home bakers, cottage food businesses, and small bakery owners who want to take control of their pricing and profitability.

Recipe Cost Breakdown

Break down every ingredient cost per recipe. Know exactly how much flour, butter, eggs, and specialty items go into each batch — and what they cost you.

Overhead Allocation

Factor in the costs most bakers forget: packaging, utilities, labor, and other overhead. Get a true picture of what it takes to make each product.

Profit Margin Visibility

See your profit margins per product at a glance. Adjust your pricing with confidence, knowing you're covering costs and making sustainable profit. For a faster way to check specific cake prices, try our free cake pricing calculator.

Unlock the full potential of your bakery business with Craftybase.

Automate your costing, track inventory in real-time, and get accurate COGS calculations without the spreadsheet headaches.

Start a 14 day free trial →

*no credit card required

How to Use the Bakery Costing Spreadsheet

This bakery costing spreadsheet is designed to help you calculate the true cost of your recipes — from raw ingredients to finished products. It's perfect for bakers who need accurate pricing data without the complexity of full inventory software.

To get started, if you haven't already downloaded the spreadsheet, enter your email address above. You'll receive a link to download the file as a zip. Once unzipped, you can open it in Excel, Numbers, or upload it to Google Sheets.

Important note: Some columns are calculated automatically and should not be edited manually. These are typically highlighted or marked in the spreadsheet.

1

Ingredient Inventory & Costs

This section is where you record all the ingredients you use in your baking business — flour, sugar, butter, eggs, specialty flavorings, and more. For each ingredient, you'll track:

Ingredient Name
A clear identifier for each item (e.g., "All-Purpose Flour" or "Organic Butter").
Unit of Measure
How you buy and use the ingredient (pounds, ounces, cups, etc.). This should match how you purchase it for easier cost tracking.
Purchase Cost
What you paid for the ingredient per unit. Make sure to include any shipping or bulk discounts to get an accurate landed cost.
Supplier/Vendor
Where you purchase each ingredient. This helps when you need to reorder or compare prices across suppliers.

By keeping this list up to date, you'll have a master reference for all your ingredient costs. When prices change, update them here and your recipe costs will automatically reflect the new numbers.

2

Recipe Cost Calculator

This is the heart of the spreadsheet. For each recipe or product you make, you'll list out every ingredient and calculate the total cost per batch and per unit.

Recipe/Product Name
What you're making (e.g., "Chocolate Chip Cookies - Dozen").
Batch Size
How many units this recipe produces (e.g., 12 cookies, 24 cupcakes, 1 loaf).
Ingredient List
List each ingredient used in the recipe along with the quantity. The spreadsheet will pull the cost per unit from your ingredient inventory.
Cost Per Unit
Divides the total batch cost by the number of units produced, giving you the cost to make one cookie, one cupcake, or one loaf.

With this section filled out, you'll know exactly what your raw ingredient costs are for each product. But that's not the whole picture — you also need to account for overhead.

3

Overhead Allocation

Ingredients aren't your only costs. You also have packaging, utilities, labor, and other expenses that go into making each product. This section helps you allocate those costs fairly across your recipes.

Packaging Costs
Boxes, bags, labels, ribbons, stickers — any materials needed to present and protect your finished product.
Labor Costs
Estimate the time spent making each batch and the hourly rate. Even if you're not paying yourself yet, factor in the value of your time.
Utilities & Overhead
Oven usage, kitchen space, insurance, licensing, and other fixed costs. Allocate a flat rate per batch or calculate a percentage.
Total Overhead Per Batch
The spreadsheet adds up all overhead costs and divides by batch size to give you an overhead cost per unit.

When you add ingredient costs and overhead together, you get your total cost per unit — the true cost to produce one item. This is the number you need to know before setting prices.

4

Pricing & Profit Margin Calculator

Now that you know your costs, you can set prices that actually make sense for your business. This section helps you calculate profit margins and see what you're earning on each sale.

Retail Price
What you charge customers for each unit.
Total Cost Per Unit
Pulled from your recipe costing (ingredients + overhead).
Gross Profit Per Unit
Your retail price minus your total cost. How much you're making on each sale before general business expenses.
Profit Margin (%)
Calculated as (Gross Profit / Retail Price) x 100. Most bakeries aim for 40-60% margins.

By tracking margins for each product, you can identify which items are your profit drivers and which ones might need a price adjustment or recipe tweak to be more profitable.

5

COGS (Cost of Goods Sold) Tracking

If you're tracking your business finances for tax purposes or bookkeeping, you'll need to calculate your Cost of Goods Sold (COGS). This section helps you tally up the total cost of all products sold over a given period.

Units Sold
How many of each product you sold in the period (week, month, quarter).
Cost Per Unit
From your recipe costing section.
Total COGS
Automatically calculated by multiplying units sold by cost per unit for each product, then summing across all products.

Your COGS is a critical number for understanding profitability and is required for accurate tax reporting. With this spreadsheet, you can calculate it quickly without digging through receipts and invoices.

What is a Bakery Costing Template?

A bakery costing template is a structured spreadsheet that helps you calculate the true cost of producing your baked goods. It goes beyond just adding up ingredient costs — it includes packaging, labor, overhead, and other expenses that are easy to overlook but essential for accurate pricing.

Think of it as a Bill of Materials (BOM) for each recipe. For every product you make, the template breaks down every cost component: how much flour, butter, eggs, and other ingredients go into a batch, what the packaging costs, how much time it takes to make, and what share of your fixed overhead (like utilities and rent) should be allocated to that product.

The result is a per-unit cost that reflects what it actually costs you to make one cookie, one loaf of bread, or one custom cake. With that number in hand, you can set prices confidently, knowing you're covering costs and building in the profit margin you need to sustain and grow your business.

Why do you need to calculate your bakery costs?

The most important reason is simple: if you don't know what your products cost to make, you can't know if you're making money. It's easy to look at revenue and feel like business is good, but without understanding your costs, you might be selling at a loss without realizing it.

Calculating your bakery costs lets you set prices that cover all expenses — ingredients, packaging, labor, overhead — and still leave room for profit. This is especially important if you're competing in a market where customers compare prices across multiple bakeries. You need to know your margins so you can price competitively without sacrificing profitability.

Beyond pricing, accurate costing helps you make better business decisions. Should you switch to a cheaper supplier for flour? Is it worth investing in bulk ingredient purchases? Which products are your best sellers in terms of profit, not just volume? You can't answer these questions without solid cost data.

And if you're planning to scale — selling at farmers markets, supplying local cafes, or opening a storefront — you'll need reliable cost information to forecast expenses, manage cash flow, and ensure that growth doesn't erode your margins.

What should a bakery costing template include?

A good bakery costing template should cover all the major cost drivers in your business. At a minimum, it should include:

Ingredient Costs:
A master list of all ingredients with current prices and units of measure. This should be easy to update when prices change.
Recipe Breakdown:
For each product, a detailed list of ingredients used, quantities, and calculated costs per batch and per unit.
Packaging Costs:
Boxes, bags, labels, and any other materials needed to package your finished products.
Labor Costs:
Time spent making each batch and the hourly rate. Even if you're working for free right now, tracking this helps you understand the true cost and plan for future hiring.
Overhead Allocation:
Utilities, rent, insurance, licensing, equipment depreciation, and other fixed costs that should be spread across your products.
Pricing & Margins:
A way to see your retail price, total cost, gross profit, and profit margin percentage for each product at a glance.
COGS Tracking:
A section to calculate total cost of goods sold over a period, which is essential for bookkeeping and tax reporting.

The best templates automate calculations wherever possible, so when you update an ingredient cost or change a recipe, all related numbers adjust automatically. This saves time and reduces errors compared to doing the math manually.

Why spreadsheets may not be enough as you grow

A bakery costing spreadsheet is a great starting point, especially if you're just getting serious about tracking costs. But as your business grows — more products, more orders, more ingredient purchases — spreadsheets can get unwieldy fast.

You'll find yourself spending more time updating formulas, copying data between tabs, and hunting down the right numbers than actually baking. And because spreadsheets are manual, it's easy for data to get out of sync. Miss one ingredient price update, and your entire cost calculation is off.

There's also the issue of inventory tracking. A costing spreadsheet can tell you what a recipe should cost based on ingredient prices, but it can't tell you what you actually have on hand, what you need to reorder, or what your inventory is worth for tax purposes. For that, you need a system that tracks purchases, production, and sales in real time.

That's where bakery inventory software like Craftybase comes in. Instead of manually entering every ingredient use and updating costs by hand, Craftybase tracks your inventory automatically. When you log a purchase, it updates your ingredient costs. When you make a batch, it deducts ingredients from stock and calculates the cost based on your actual purchase prices (using FIFO, LIFO, or weighted average costing). When you make a sale, it tracks COGS and updates your finished goods inventory.

The result is accurate, real-time costing without the spreadsheet headaches. You get the same insights — cost per unit, profit margins, COGS — but without the manual data entry and formula debugging.

When to switch from a spreadsheet to bakery software

If any of these sound familiar, it might be time to move beyond spreadsheets:

  • You're spending more time updating your spreadsheet than baking.
  • You've lost track of ingredient costs because you forgot to update them after a price change.
  • You're not sure what your on-hand inventory is worth, or you're guessing at COGS for tax time.
  • You're selling across multiple channels (farmers markets, online, wholesale) and can't keep up with tracking costs for each.
  • You're ready to scale, but your spreadsheet can't handle the complexity.

Craftybase is built for small batch bakers who want the accuracy of a full costing system without the complexity or cost of enterprise software. It's designed to work the way you work — tracking recipes, ingredients, production, and sales in one tidy system. And because it's cloud-based, you can access your numbers from anywhere, whether you're in the kitchen, at a market, or meeting with your accountant.

Bakery Costing Spreadsheet FAQ

To calculate recipe cost, list every ingredient in the recipe and determine the cost per unit (e.g., per ounce or per cup). Multiply the quantity used by the unit cost for each ingredient, then sum all ingredient costs. Add packaging, labor, and a share of overhead (utilities, rent, etc.) to get the total cost per batch. Divide by the number of units produced to get cost per item.

Most bakeries aim for a gross profit margin of 40-60% on individual products. This means if a cookie costs you $1.00 to make (including all costs), you'd price it at $1.67-$2.50. Specialty or custom items can command higher margins, while commodity products (like basic bread) may be lower. Your target margin should cover all business expenses and leave room for profit.

Yes — even if you're not paying yourself a salary yet. Factor in the time spent baking, decorating, and packaging at a reasonable hourly rate (what you'd pay an employee to do the same work). This ensures your prices reflect the true cost and that your business model is sustainable when you eventually need to hire help or scale production.

In a spreadsheet, you'll need to manually update ingredient costs whenever prices change. Keep a record of purchase dates and prices so you can see trends. For more automated tracking, consider using bakery inventory software like Craftybase, which logs every purchase and uses the actual prices you paid (via FIFO, LIFO, or weighted average) to calculate recipe costs automatically.

COGS (Cost of Goods Sold) is the total cost of all products you sold during a period. It includes ingredients, packaging, and direct labor, but not general business expenses like marketing or rent. COGS is used to calculate gross profit (Revenue - COGS) and is required for accurate tax reporting. Tracking COGS helps you understand true profitability and ensures you're not underpaying or overpaying taxes.

Update ingredient costs whenever you make a new purchase, especially if prices have changed. Review recipe costs monthly or quarterly to catch any significant shifts. If you're adding new products or changing suppliers frequently, consider moving to automated inventory software to avoid constant manual updates and ensure your costs are always accurate.

Who Should Use This Bakery Costing Template?

This free bakery costing spreadsheet is designed for bakers at any stage who need to understand their true costs and set profitable prices.

Home bakers transitioning to selling

If you've been baking for friends and family and are now starting to sell at farmers markets, online, or through local orders, this template helps you move from hobby pricing to business pricing.

Cottage food businesses

Operating under cottage food laws means tight margins and strict regulations. This template helps you calculate costs accurately so you can price competitively while staying profitable.

Small bakery owners

Running a small storefront, booth, or online bakery with a handful of core products? This spreadsheet gives you the costing foundation you need without investing in complex software.

Bakers testing new recipes

Before you add a new product to your lineup, use this template to calculate whether it's worth making. See the costs and margins before you commit to production.

Wholesale bakers

Supplying cafes, restaurants, or grocery stores? Wholesale pricing is typically 50% of retail, so margins are tighter. This template helps you quote prices that cover expenses and leave room for profit.

Custom cake & specialty bakers

Pricing custom orders is tricky because every job is different. Cost out custom recipes, factor in design time and specialty ingredients, and quote prices confidently.

Bakers preparing for tax season

If your bookkeeper or accountant has asked for COGS data and you're not sure where to start, this template helps you calculate and document your cost of goods sold accurately.

Ready to outgrow the spreadsheet?

Streamline your end-to-end bakery process and gain real-time visibility into your costs and inventory with Craftybase.

Start a 14 day free trial →

No credit card required. Cancel anytime.