Getting started
Cottage Bakery Spreadsheet: 5 Columns That Show Profit
The five columns a cottage bakery spreadsheet needs, and the math that shows real profit.
On this page
What to remember
- Cost per recipe, not per month. Monthly totals hide which item lost money.
- Your hours are a real cost. Leave them out and the margin is a guess.
- Packaging and labels belong in the cost of every single item.
- Build one layout, then copy it for each recipe you sell.
You can build a cottage bakery spreadsheet in an afternoon with five columns and one recipe. The point is not to look like a real business. The point is to know, before you quote a price, whether that order pays you or costs you.
The five columns that do the work
Every recipe gets the same five columns: ingredient cost, packaging, labor, overhead, and price. Ingredient cost is what you actually paid for the amount the recipe uses, not the price of the whole bag. Packaging is the box, bag, sticker, and ribbon for one item. Labor is your hours times your rate. Overhead is a small flat amount for power and wear. Price is what you charge.
Keep one extra tab for pack prices. When flour goes up, you change one number and every recipe that uses flour updates. That single habit saves more time than any shortcut. If you want a longer list of cost lines, the bakery expenses spreadsheet breaks out six columns.
Pick an hourly rate you would pay someone else to do the same work. Write it at the top of the sheet, so you are not renegotiating with yourself every week.
Start with one recipe
Pick your best seller and build the sheet around it. You will copy the layout for everything else.
List every ingredient at pack price
Write what you paid for the whole bag or box, then how much of it the recipe uses.
Add packaging and labels
Box, bag, sticker, and ribbon for one item. These are per item, not per month.
Put a dollar value on your hours
Choose an hourly rate and log the hands on time for the batch.
Add overhead per batch
Oven power, parchment, and pan wear. A small flat amount per batch is enough.
Divide by what you sell
Total cost divided by the number of items gives your cost each. Then set the price.
A worked example with 24 cookies
Say a batch of 24 cookies uses $6.00 of ingredients and $1.20 of boxes and labels. Your hands on time is 1.5 hours, and you pay yourself $15 an hour, so labor is $22.50. Oven power, parchment, and pan wear add $1.50. The batch costs $31.20, which is $1.30 a cookie. At $2.50 each you take in $60.00, so the margin is $28.80, about 48 percent of the sale.
Change the price to $2.00 and the margin drops to $16.80. Still positive, but a much thinner cushion. Now drop the labor line and the same batch looks like it costs $8.70. Every price looks like profit, and that is how a busy month turns into a bad one.
Mistakes that quietly cost you money
The first is using old pack prices. A recipe costed in January can be wrong by spring, and you will not notice until a customer orders forty of them. Update pack prices when you shop and let the sheet do the rest.
The second is counting a sale as profit the day it is paid. Ingredients, packaging, and your time were spent before the money arrived. The third is mixing bakery money with household money, which hides the real number at the end of the month.
The fourth is quoting a custom order before you cost it. A decorated cake can take three times the hands on time of a plain one, and the sheet is the only thing that tells you that before you say yes. If you are still deciding whether to sell at all, how to start a cottage bakery from home covers the first costs.
Ten minutes a week keeps it honest
Set a time each week to update three things: new pack prices, hours you worked, and orders you delivered. Ten minutes is enough. If you wait until tax time, you will be rebuilding months of receipts from memory.
If a week goes by with no update, do not skip it twice. Two missed weeks is how a whole season of numbers disappears. When the sheet is running, cottage bakery bookkeeping shows the four records to keep alongside it.
Spreadsheet or a shop tool
A spreadsheet is free and you already know how to open one. A shop tool costs money and does the adding for you. Brevl is one flat $20 a month with no cut of your sales, and it keeps recipes with real costing, ingredient inventory, and a weekly planner in one place. It works on a computer and on a phone.
What to check before you commit
Before you build anything, check your state cottage food rules. Some states cap what you can earn, and some limit what you can sell. A spreadsheet will not tell you that. Your state will.
If you are still at the start, the getting started guide walks through the first steps. If you would rather begin from a ready layout, this bakery spreadsheet template gives you the columns to copy.
Try the free bake pricing calculator
Free, no signup.
- Bakery accounting spreadsheet free: track costs and margin
- Sales tax on bakery items: permit, rates, and filing
Common questions
Can I just use a notebook instead of a spreadsheet?
You can, and many bakers start there. The problem is the math. A spreadsheet adds the columns for you, so a change in the price of flour flows through every recipe at once. A notebook makes you redo that by hand, and small errors add up over a season.
Can I track this on my phone?
Yes, and you probably will. A simple sheet works fine on a phone if you keep the columns narrow and skip the fancy formatting. If you would rather not fight with it, Brevl runs on a phone and on a computer, so you can cost a recipe at the counter.
Should I include my hours in the cost?
Yes. If your time is not in the sheet, a busy week looks profitable when it is not. Pick an hourly rate you would pay someone else, log the hands on time for each batch, and let the sheet show whether the price covers it.
What counts as overhead for a home bakery?
Overhead is everything you use whether or not an order comes in. Oven power, pans, parchment, dish soap, and the wear on your mixer. A small flat amount per batch, added to ingredients and labor, keeps the number honest without a long list.
Do I need a different sheet for every product?
No. Build one layout and copy it for each recipe. Same columns, same order, so you can compare a cookie against a cake without translating anything. Recipes that share an ingredient can point at the same pack price. It also makes a new recipe a five minute job.
General information, not legal, tax, or accounting advice. Cottage food rules and sales tax rules differ by state, so check your own state and talk to a tax professional about your situation.