Selling and marketing
Cake Pricing Spreadsheet (2026): 6 Columns That Show Profit
Build one sheet that costs ingredients, labor, and overhead, then shows the margin on every cake you sell.
On this page
You do not need a finance background to keep a cake pricing spreadsheet. You need one row per cake, honest numbers, and the habit of updating it when flour or boxes change price. This guide is built for a phone, so you can fill it in at the kitchen counter.
What to remember
- One row per cake and size, never an average.
- Ingredients, labor, and overhead all go in before you set a price.
- Margin is price minus cost, divided by price.
- Update the sheet when a supplier price changes.
- A price with no margin is a hobby, not income.
Try the free cake pricing calculator
Free, no signup.
How to set up your cake pricing spreadsheet
Six columns cover almost every cake you sell. Add a seventh only when a cost shows up often enough to change your price. A cake pricing sheet with these columns takes about an hour to set up, and you only do it once.
Set up one row per cake and size
A 6 inch and an 8 inch are different products with different costs, so they never share a row.
Enter the ingredient cost for the portion used
What the batch actually used, not what the bag cost. One cake uses part of a bag of flour.
Add packaging
Box, board, liner, label, and ribbon. This is the column home bakers forget most often.
Add your minutes and your rate
Time the work once, write the minutes down, and reuse that number on every future cake.
Add the overhead share
Power, water, delivery miles, and the fee your card processor takes from each order.
Let the sheet work out the margin
Margin is price minus cost, divided by price. Run that math on every row.
Where each number comes from
Ingredient cost is the hardest column, because a cake uses part of a bag, not the whole bag. Divide the bag price by the number of cups or pounds in it, then multiply by what the recipe used. A free bakery costing spreadsheet from Stocksmith does this for recipe costs, cost per batch, cost per item, and profit margins.
Labor is the column most home bakers leave at zero, and it is usually the biggest one. Pick an hourly rate you would pay someone else to do the work, then multiply by the minutes. Cake Price and Margin asks for your minutes and your hourly rate for exactly this reason.
Overhead is everything that is not tied to one cake. Your oven, your fridge, the miles to a delivery, and the fee your card processor takes. Add those up for a month and divide by the number of cakes you sold. That is the share each cake carries. Cake costing and pricing covers the same three buckets in more detail.
Your hourly rate is a decision, not a discovery. Pick a number you would accept for a full day of baking, then hold it. If $15 an hour feels low, use $20 and see whether the cake still sells at your market.
A worked example: a $175 cake
Say a two layer cake uses $18 of ingredients, takes three hours at $15 an hour, and carries $7 of overhead for the box, board, and oven time. Ingredients plus labor plus overhead is $70. At $175, you keep $105, which is a 60 percent margin.
Run the same cake at $90 and you keep $20, a 22 percent margin. One cake that fails at that price costs more than the whole order earned. That is why the margin column matters more than the price column.
Notice that the ingredients are the smallest of the three costs. If you cut the box to save $2, you changed the margin by about one percent. If you cut an hour of decorating, you changed it by a lot more.
Mistakes that cost you money
Most pricing mistakes are not math mistakes. They are columns you left empty, or numbers you guessed once and never checked again. Each one below shows up as a smaller margin at the end of the month.
What to check before you commit to a price
Before you send a quote, check three things. Does the price cover ingredients, labor, and overhead with something left over. Does it match the size and finish the customer asked for. Can you repeat it next month at the same supplier prices.
Then check it against your own last ten orders. If the margin on those was thin, the problem is usually the price, not the customers. A cake pricing calculator can show you the number before you quote it out loud.
Write the quote down before you say it. A price you invent at the counter is usually lower than the one your sheet produced, and you cannot raise it after the cake is delivered.
Keep the sheet alive
A sheet you built in January is wrong by June. Flour, butter, eggs, and boxes all move. Write the date next to every price you enter, so you know how old it is.
Once a month, open the sheet and update the three biggest costs. Then look at your margin column. If any cake is under your target, raise the price or change how you make it. The selling guides walk through the rest of the order flow.
Keep the sheet where you can reach it on your phone. A spreadsheet you have to open on a laptop is a spreadsheet you stop updating.
- Cake pricing chart: cost, labor, and margin
- Cake pricing by size: cost per serving
- Bakery pricing spreadsheet: 6 columns
Common questions
Can I build a cake pricing spreadsheet in Google Sheets?
Yes. A free spreadsheet app on your phone is enough. Make one tab for costs, one row per cake, and a margin column that subtracts cost from price and divides by price. Keep it on your phone's home screen so you actually open it.
How do I work out the margin on each cake?
Take the price, subtract the full cost, then divide by the price. If a cake sells for $175 and costs $70, the margin is $105 divided by $175, which is 60 percent. Do that on every row so a thin cake cannot hide.
Should I pay myself in the spreadsheet?
Yes. Put your hours in at a rate you would accept for a full day of work. If the cake only sells when your labor is free, the price is wrong or the cake is too big. Raise the price or simplify the finish.
How often should I update the sheet?
Update the three biggest costs once a month, and any time a supplier changes a price. Write the date beside each number so you can see how old it is. A price built on six month old flour numbers is a guess, not a price.
What if my price is higher than other bakers nearby?
Check your own costs first, because you cannot see theirs. They may use a smaller cake, a simpler finish, or cheaper packaging. Compete on the cake you actually make, and let the sheet tell you the lowest price you can accept.
Sources
This is general information about pricing, not legal or tax advice.