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.
