Skip to content

Bakery Budget Example: Plan, Actual, Difference

A bakery budget example: a month planned line by line, what actually happened, the difference on each line, and what to do about it, with a template.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A budget is a profit and loss statement written before the month happens. Its use isn't the plan. It's the third column: budget, actual, and the difference, line by line, because that's where a bakery finds out what it didn't expect. In the made-up bakery below, November was budgeted to leave $3,840 and left $4,990. A good month. The differences say why, and they're not all good news: sales were $2,400 over, mostly three weddings that won't repeat, while ingredients ran $570 over because butter went up 9%, which will. Read without a budget, the month just looks fine. Read against one, it has two things to act on. Below are the example, how to set the numbers, how to read the differences, and a template.

The short version

  • Budget the same lines your profit and loss statement has.
  • Set each month from the same month last year, then adjust.
  • After the month: actual beside budget, and the difference.
  • A sales line over budget is good. A cost line over budget needs a reason.
  • Ask of each difference: one-off, or the new normal?
  • TaroStack shows which ingredient moved and what each product now costs. More below.

The example

Line Budget Actual Difference
Counter sales $20,000 $21,400 +$1,400
Wholesale $10,000 $9,800 −$200 One cafe closed for a week
Custom cakes and orders $4,000 $5,200 +$1,200 Three weddings
Sales $34,000 $36,400 +$2,400
Ingredients $7,800 $8,370 +$570 Butter up 9%
Packaging $1,700 $1,820 +$120
Cost of goods $9,500 $10,190 +$690
Bakers' wages $8,740 $8,740 $0
Counter wages $3,400 $3,640 +$240 Extra Saturday cover
Payroll taxes $1,210 $1,240 +$30
Labor $13,350 $13,620 +$270
Rent, utilities, fees, van, repairs, insurance, marketing, other $7,310 $7,600 +$290 Mixer belt, $160 over
Left for the month $3,840 $4,990 +$1,150

Reading the differences

Is the cost difference just the sales difference? Sales were 7% over budget. Ingredients were 7.3% over, about what 7% more baking would use, so most of the $570 is volume. That's the first check for any cost that moves with sales: compare percentages, not dollars. Had ingredients been 15% over on 7% more sales, something else was going on.

But the note says butter rose 9%. Both are true: some of the increase is volume and some is price, and the price part will be there next month whether or not the weddings are. A budget flags it. Finding which ingredient, and what it does to each product, takes more than a budget: see ingredient price increase.

One-off or the new normal? Sort every difference into one of the two.

Difference Kind Do
Custom orders +$1,200 One-off: three weddings Enjoy it. Don't raise next month's budget
Wholesale −$200 One-off: a cafe closed Nothing
Butter New normal Recost the butter-heavy products; raise the ingredients budget
Counter wages +$240 Depends If Saturdays are busier for good, it's the new rota
Repairs +$160 One-off, and a warning The mixer is ten years old

Labor didn't move with sales. Bakers' wages were on budget in a month with 7% more sales. That's the good side of fixed hours: the extra sales cost only ingredients. It works the other way in a slow month.

Setting the numbers

Start from last year, month by month. A bakery's December isn't its February. Take each month's actuals from last year as the base.

Sales first. For each channel: last year's figure, changed for what you know. A price rise. A new wholesale account. A market you've dropped.

Costs that follow sales. Ingredients, packaging and card fees move with sales. Budget them as a share: ingredients at 23% of sales, say, from your own history.

Costs that don't. Rent, insurance and salaried wages are what they are. Hourly wages follow the rota you plan to run.

Something for repairs. Ovens and mixers break on no schedule. A monthly figure that's too high in most months and too low in one is honest.

What's left. If the plan leaves less than you need, change the plan now: prices, hours, products. That's the point of writing it before the month.

Using it

On the first few days of each month: fill in last month's actuals, read the difference column, write one line beside anything over about 5% or $100, and decide whether next month's budget changes. It takes half an hour once the profit and loss statement is done. The statement itself is in bakery profit and loss statement template, the margin on each product in bakery profit margin, and the year's plan in bakery business plan.

This is general information, not accounting advice.

Get the template

Download the bakery budget example. A Budget sheet with a line for each item, budget, actual, the difference and its share of budget, and a Summary sheet that shows what the month was meant to leave and what it left. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

The budget says ingredients were $570 over. It's one number for forty ingredients and sixty products. Butter went up: which products is that in, by how much each, and is the croissant still worth selling to the cafe at $1.80? The budget can raise the question on the third of the month. It can't answer it.

How TaroStack does it

TaroStack isn't an accounting system and doesn't make budgets. It answers the question the difference column asks.

A price-creep report for each supplier. Butter at each purchase: the 9%, the week it happened.

Every recipe that uses butter is recosted, from what the last deliveries cost.

Margins by product on that cost, so the croissant's margin at the cafe's price is on the screen.

Actual against standard, batch by batch: whether more went into the bake than the recipe says.

Waste by reason: unsold, damaged, expired.

The difference The budget says TaroStack says
Ingredients +$570 Over Which ingredient, from which purchase
Is it price or usage Can't tell Price creep; actual against standard
Which products are hurt Can't tell Margin by product
Was more thrown away Can't tell Waste by reason

Every list exports to CSV for your accountant. Recipes, batches and costing are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you make a budget for a bakery?

List the lines of your profit and loss statement, set each month's sales from the same month last year adjusted for what you know, budget ingredients and packaging as a share of sales, and add fixed costs as they are.

What expenses does a bakery have?

Ingredients and packaging, wages and payroll taxes, rent, utilities, card fees, delivery, equipment repairs, insurance, marketing, and supplies and software.

What do I do when actual costs are over budget?

Check first whether sales were over by the same share. Then sort each difference into a one-off or a lasting change, and act on the lasting ones.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.