Getting started
Bakery Spreadsheet Template: Free Download and 4 Columns
A free, simple spreadsheet template to cost your bakes and see what you actually earn.
On this page
What to remember
- Track all three costs: ingredients, your time, and overhead.
- A simple template stops you from missing hidden costs.
- Use the cost per item to set a profitable price.
A bakery spreadsheet template is your first step to knowing if your home bakery makes money. It moves you from guessing to seeing the real numbers. Start with our free example and fill in your own costs.
What a bakery spreadsheet template tracks
A good template tracks three types of costs. Ingredients are the flour, sugar, and eggs. Labor is your time to bake and decorate. Overhead includes boxes, labels, and kitchen power.
Most home bakers start by tracking only ingredients. That is a mistake that costs you money. Your time and overhead are real costs. A template helps you see them all.
How to build your own template
List every ingredient
Write down every item in your recipe. Note the package size you buy and its cost. For example, a 5lb bag of flour costs $4.
Cost the whole batch
Calculate how much of each package you use in one batch. If a batch uses 1lb of flour from a $4 5lb bag, your flour cost is $0.80. Add up all ingredients for the total batch cost.
Add your labor
Decide on a fair hourly wage for your work. Track how long one batch takes from start to clean up. Multiply your hours by your wage to get the labor cost.
Include overhead
Overhead is everything else. Add the cost of boxes, labels, and a share of your kitchen power. A simple method is to add 10-15% of your ingredient cost.
Find your cost per item
Add your ingredient, labor, and overhead costs. This is your total batch cost. Divide this by the number of items you get from one batch, like 12 cupcakes.
Set your price
Your cost per item is your break-even point. To make a profit, add a margin on top. A common margin is 50-100% of your cost per item.
A worked example: vanilla cupcakes
Let us cost a batch of 12 vanilla cupcakes. We will use real numbers you might see.
First, ingredients. A batch uses 1.5 lbs of flour from a $4 5lb bag, costing $1.20. It uses 1 lb of sugar from a $3 4lb bag, costing $0.75. Butter, eggs, vanilla, and leavening total $3.55. The total ingredient cost is $5.50.
Labor is 2 hours at $15 per hour, which is $30. This includes mixing, baking, cooling, and decorating.
Overhead includes specific costs. Cupcake liners cost $0.15. A bakery box costs $0.85. A share of kitchen electricity and gas for baking is $0.50. Labels add $0.10. The total overhead is $1.60.
Add all three costs. Ingredients $5.50, labor $30, overhead $1.60. The total batch cost is $37.10.
Divide $37.10 by 12 cupcakes. Your true cost per cupcake is $3.09. To make a 60% profit margin, multiply the cost by 1.6. This gives a price of $4.94 per cupcake, or about $59.30 for the dozen.
How to set up your spreadsheet columns
A simple template needs only four core columns. The first column lists each cost category. The second column shows the cost for one batch.
The third column shows the number of items in that batch. The fourth column calculates the cost per item. This last column is your most important number.
You can add more columns for notes or price comparisons. The goal is clarity. You should see at a glance where your biggest costs are.
Common mistakes that cost you money
The biggest mistake is using a price you found online without doing your own math. Your costs are unique. Your neighbor’s butter price may be different.
Another mistake is forgetting to update prices. When egg costs double, your spreadsheet should show it. Review your template every few months.
A third error is underestimating overhead. It is more than just boxes. It includes cleaning supplies, website fees, and a portion of your rent. The same guide from Penn State Extension notes overhead is often 10-25% of total costs.
A simple template helps you avoid these errors. Learn more about setting up your business in our getting started guide.
How to handle variable batch sizes
Your spreadsheet must adapt when you double a recipe for a large order. The best method is to cost one standard batch first.
Then use formulas to scale the costs. If you double the recipe, double your ingredient costs. Your labor may not double. You might add only 50% more time.
Overhead costs like boxes will scale with the number of items. A template with formulas does this math for you. It prevents errors when you are rushed.
When to move beyond a spreadsheet
A spreadsheet works well when you have a few recipes. As you grow, tracking every order and ingredient becomes slow. You might forget to update a cost.
That is when many bakers look for a tool that does the math for them. A tool can link recipes to orders and update costs automatically.
Try the free bake pricing calculator
Free, no signup.
Your next steps
Start with our free template example. Fill it in with your next bake. See if your current prices cover all your costs. The goal is to know your numbers, not just hope.
Once you have your costing down, track your inventory to stop waste. Read our guide on a Bakery Inventory List Template. Then, learn how to take orders and get paid online.
Browse more getting started guides.
Keep reading: Bakery Bookkeeping Template: Track These 5 Numbers.
Common questions
Do I need special software to use a spreadsheet template?
No. You can use Google Sheets, Excel, or Numbers on your phone or computer. Any program that lets you add and multiply numbers will work. The template is just columns and rows.
How do I know what to charge for my time?
Start with a wage you would be happy to earn for skilled work. A common starting point is $15 to $20 per hour. Your time is a real business cost, the same as flour.
What if my spreadsheet shows I am losing money on a recipe?
First, double-check your math and ingredient prices. If the loss is real, you have options. Simplify the recipe, find cheaper ingredients, or raise your price. Do not keep selling at a loss.
How often should I update my cost spreadsheet?
Update your ingredient prices whenever you buy supplies. Review your labor and overhead costs every three to six months. A quick update takes minutes and keeps your prices accurate.
Should I include delivery costs in my spreadsheet?
Yes. Delivery is an overhead cost. If you deliver, add the cost of gas, vehicle wear, or delivery fees to your overhead section. Charge for it separately or build it into your price.
How do I cost a recipe that makes multiple items, like a cake and cupcakes?
Cost the entire batch first. Then decide how to split the cost. You might allocate costs by weight or by the time each item type takes. Your spreadsheet should track each product line separately.
Sources
General business information, not financial or tax advice. Consult a professional for your specific situation.