1 / 14

Recipe costs and pricing for home bakers

Bakery Recipe Cost Spreadsheet

Know what every bake actually costs you, and what to charge for it: your ingredients, your own time, your packaging and gas, then the price that hits the margin you want.

SpreadsheetExcel + Google Sheets12 tabsInstant download

$15.99 one time, buy direct

Buy direct · $15.99

Instant download: the spreadsheet (.xlsx) and the free 10-page quick start PDF guide, right after you pay.

Buy on Etsy · $17.99

35% off on Etsy: code SAVE35

Pay once, no subscription
No macros, no add-ons, no login
Works in Excel, Google Sheets and LibreOffice Calc
Free 10-page quick start PDF guide included

What's in the Bakery Recipe Cost Spreadsheet

True cost per ingredient

What you paid per pack, turned into a cost per gram, ml or each.

Recipe builder

One row per ingredient in cups, spoons or grams, with the units converted for you.

Recipe pricing

Your true cost per unit, and what to charge to hit the margin you want.

Your time, priced in

Enter the minutes and your hourly rate and it lands in the cost, where it belongs.

Nine sales channels

Farmers market, Square in person, Square Online, Etsy, Instagram or DM, your own website, direct cash, wholesale and a blank row you can rename.

Orders with real fees

Log a sale and the channel fee comes off automatically, so you can see what you actually kept.

Fourteen checks

The Dashboard flags orders sold at a loss, recipes priced under your target margin, recipe lines with a unit problem and ingredients with a bad pack size.

Expenses, mileage + tax set-aside

Booth fees, packaging, permits and insurance, mileage at your own rate, twelve months of profit and a quarterly set-aside estimate.

How it works

Add your ingredients
Type what you paid per pack. It works out the cost per gram, ml or each.
Build your recipes
One row per ingredient, in cups, spoons or grams. The units convert for you.
See what to charge
Your true cost per unit, with your time and overhead in, and a suggested price.

Watch the how-to

The how-to video, start to finish.

Plus the free 10-page quick start PDF guide comes with your purchase.

Cups, done right

A cup of flour and a cup of sugar don't weigh the same, so grams-per-cup is set on each ingredient, not guessed. If a conversion isn't safe to make, the sheet says UNIT MISMATCH instead of quietly returning a wrong number.

Twelve linked tabs: enter something once and it flows everywhere
Every fee rate is yours to edit, with a date field so you know how old it is
A worked Example tab walks one cake from flour to final price
Room for 600 orders, 400 recipe lines, 60 ingredients, 40 recipes, 400 expenses and 200 mileage rows

What you get, how you get it and what you need

What you get

One .xlsx workbook with 12 linked tabs, with the nine sales channels and their fee rates already filled in
The free 10-page quick start PDF guide, with real screens
A one-time purchase, no subscription

How you get it

Buy direct: right after you pay, you land on your download page with the spreadsheet and the guide.
On Etsy: open Purchases in a web browser and click Download Files. The Etsy phone app can't download files.
Open it in Excel, or upload it to your Google Drive and open it with Google Sheets. The guide shows each step.

What you need

Microsoft Excel (Windows or Mac), Google Sheets or LibreOffice Calc (free)
No macros, no add-ons and no login

Good to know

The fee rates are published rates typed in by hand on the date shown in the sheet, not fetched live. Platforms change them, so check them against your own payout statement.
It's a costing and pricing tool. It isn't tax advice, and it isn't a food-safety or cottage food compliance tool: those rules vary by state, so check your own.
Each list stops counting at its limit. If you fill one, start a fresh copy of the file; Start Here explains.
The numbers in the photos and videos are sample data. In your copy the ingredient, recipe, order, expense and mileage lists start empty.
It's a digital download. Nothing is shipped.

Reviews

The Bakery Recipe Cost Spreadsheet doesn't have reviews yet.

Our Etsy shop has 150 reviews with a 4.8-star average.

Read all our reviews on Etsy →

Questions

Does it work in Google Sheets?

Yes. Upload it to your Google Drive and open it with Google Sheets. It also works in Microsoft Excel (Windows and Mac) and LibreOffice Calc.

Which sales channels are built in?

Nine: farmers market, Square in person, Square Online, Etsy, Instagram or DM, your own website, direct cash, wholesale, and a blank row you can rename. Every rate is yours to edit.

Does it count my time?

Yes. Enter the minutes and your hourly rate and it lands in the cost.

Can I measure in cups?

Yes. Grams-per-cup is set on each ingredient, and if a conversion isn't safe the sheet says UNIT MISMATCH instead of guessing.

How much can it hold?

600 orders, 400 recipe lines, 60 ingredients, 40 recipes, 400 expenses and 200 mileage rows.

Is it a cottage food or tax tool?

No. It's a costing and pricing tool. It isn't tax advice or a food-safety or cottage food compliance tool; those rules vary by state.

How do I get it after I buy?

Buy direct and you land on your download page right after you pay, with the spreadsheet and the free quick start PDF guide. On Etsy, open Purchases in a web browser and click Download Files.

Can I see it before I buy?

Yes. Watch the how-to video on this page to see it working.