Comprehensive Bakery Order Tracker & Recipe Costing Spreadsheet, Home Baker Pricing Calculator (Google Sheets, Excel)

5 QUICK ANSWERS BEFORE YOU BUY

1. Will it work on my computer and my other devices?
Yes. The Google Sheets* version works in any web browser. With a free Google Drive* account, it also works on an iPad* or a phone. The Excel* file works in Microsoft* Excel* 2016 or newer, including Microsoft 365*, on Mac* and Windows*.

2. Can I set my own currency, units and profit goal?
Yes. On the Settings tab you set your currency symbol, hourly labor rate, overhead markup and the profit margin you want. You can price ingredients in grams, ounces, pounds, cups or your own pack sizes.

3. I'm not a spreadsheet person. Will I be OK?
Yes. If you can type an ingredient name and an amount, you can use this. Lightly shaded cells show you where to type. More than 1,800 formulas do the math in the background. Formula cells are a different color, so leave those alone.

4. What exactly do I get?
You get instant access after checkout. There is a Download Link PDF with the link to copy the Google Sheets* version. You also get the Excel* (.xlsx) file, which works offline, and a step-by-step guide with pictures.

5. Can I get help if I get stuck?
Yes. Message ProFormaGRID on Etsy* any time, and we will help you get your tracker running.

----------------------------------

This spreadsheet shows what each of your recipes really costs, and it tracks every order. It's made for home bakers, cottage food sellers who bake at home, and custom cake makers.

It has 7 linked tabs and more than 1,800 formulas. It adds up the ingredients, packaging, labor and overhead in each recipe, to the penny. You can scale a batch by changing one cell. It works in Google Sheets* or Excel*.

----------------------------------

WHAT'S INSIDE (7 TABS)

Start Here
A quick-start checklist and a plain guide to the colors.

Dashboard
Cards for Total Revenue, Completed vs Open Orders, Average Order Value and Net Profit Margin. A chart shows revenue and profit over time. Two donut charts show your order status and your cost mix of ingredients, packaging and labor.

Item Database
Every ingredient, box, ribbon, board and label, with its pack price and size. It works out the cost per gram, ounce, milliliter or piece for you.

Recipe Ingredients
Cost a recipe line by line. It warns you when units don't match, like grams typed in as ounces. It links to the Item Database, so when a supplier's price changes, your recipe costs change too.

Recipe Costing
This is the costing and scaling calculator. It adds up ingredients, packaging, your hands-on time and overhead. It suggests a price that meets your profit goal. A batch multiplier scales the whole recipe at once.

Order Tracker
Client details, event dates, delivery method and flavor notes. Totals, deposits paid and balance due add up for you. Each order's stage shows in its own color.

Settings
Your hourly wage, overhead percent, tax settings and target profit margin. Every tab uses them.

----------------------------------

WHO IT'S FOR

• Home bakers selling bread, cookies, cupcakes and pastries
• Wedding cake designers who need to track labor and materials closely
• Growing treat businesses ready to move off notebooks and sticky notes

----------------------------------

WHAT YOU GET (INSTANT DOWNLOAD)

• Google Sheets Download Link PDF. Click the link inside and a copy saves to your own Google Drive*.
• Excel* file (.xlsx)
• Instructions PDF with pictures. It shows how to resize cells without breaking formulas.
• 7 linked tabs with more than 1,800 formulas
• Nothing to install, and no macros or scripts
• Both files come blank, ready for your own menu.

----------------------------------

HOW TO START

1. After you buy, go to your Etsy* Purchases page to get the files. Etsy* also emails you the link.
2. Open the Excel* file on your computer. Or open the PDF and click the link to make your own Google Sheets* copy.
3. Follow the Instructions PDF and set your rates on the Settings tab. Then add your ingredients and recipes, and the Dashboard fills in as you go.

----------------------------------

NEED HELP?

Send ProFormaGRID a message here on Etsy*. We read every message and will help you sort it out. You can also download your files again any time from your Purchases page.

----------------------------------

THE FINE PRINT

This is a digital download, so nothing will be mailed to you. It is not made to order. It's for personal use only. Please don't resell, share, copy or rebuild this file, in whole or in part. Copyright ProFormaGRID. All rights reserved.

*Google Sheets and Google Drive are trademarks of Google LLC. Microsoft, Excel, Microsoft 365 and Windows are trademarks of Microsoft Corporation. Mac and iPad are trademarks of Apple Inc. Etsy is a trademark of Etsy, Inc. ProFormaGRID is an independent shop and is not connected to, endorsed by or sponsored by these companies.