Baking Spreadsheet: Six You Need, in Order

A baking spreadsheet earns its place when it saves you a decision. Six jobs come up in a home bakery, and each one has a natural moment to start. The list below follows that order. Rules last checked October 2026.

If you add only two, make them recipe cost and price. The picture shows the full order in one line.

1. Recipe cost: what one cake costs to make

Start here, because the price comes from this number. A recipe cost sheet adds up every ingredient line for a batch and divides by the number of cakes the batch makes. In the Batch Recipe Cost sample, ten ingredient lines add up to $11.76 for a batch of two cakes, so one cake costs $5.88 in ingredients.

The sample's columns are part, ingredient, pack cost, pack amount and amount used. Both amounts use the same unit, and the number of cakes the batch makes goes on the first row.

Split a recipe into parts if it has them. The sample shows the sponge, the filling and the frosting as separate costs, so you see which part drives the bill.

You need it before you price anything. A baker who guesses the ingredient cost guesses the price.

2. Price and margin: what to charge

Add labor and supplies to the ingredient cost, then pick the margin you want. The Cake Price and Margin sample uses $6.40 of ingredients, 45 minutes of labor at $18 an hour ($13.50), and a box, board and liner at $2.50. Total cost is $22.40.

At a 40 percent margin, the price is $22.40 divided by 0.60, which is $37.33. Profit is $14.93. A 40 percent markup on the same cost would give $31.36 and a profit of $8.96, which is only a 28.6 percent margin. That gap is why the word you choose matters.

The sample has no separate overhead line. If you want overhead counted, fold it into the hourly rate you type.

3. Label and start records: before the first sale

Labels come before the first sale, and so do your records. State agencies set what a cottage food label must carry, and the files only hold the details you type in. Records matter too. Michigan's agriculture department says you need to keep sales records and give them to an inspector on request, and Florida's statute says an operation must provide written documentation of its annual gross sales when the department asks.

A start records sheet holds the number you looked up, the date, your insurer, your kitchen address and the label statement you use. The Cottage Start Records file says plainly that it is not a legal form.

4. Order form: one row per order

One order is one row. A cake order row holds the date needed, size, flavour, filling, frosting, writing on the cake, servings and allergens. A bakery order row holds the customer, phone, delivery or pickup, address, order total, deposit and how they paid.

Balance is the order total minus the deposit. A $60 order with a $20 deposit leaves $40 to collect.

Add this sheet when you take your first order by message and lose a detail.

5. Orders due this week: what to bake first

Once you have more than a handful of orders, you need to see only the week in front of you. The Orders Due This Week sample marks each order as this week or another week from a week start date you type. Change the date and the marks move with it.

Add it when two orders land on the same Saturday.

6. Stock and buying: what to buy and when

Stock is the last sheet, because it only helps once you know what you use. Type the quantity you have and a low threshold. The Ingredient On Hand file then marks each item in stock, low or out, and a shop list shows only the low and out items with the quantity to buy.

Two more files cover the buying side. One turns last price times reorder quantity into a supplier order total. The other turns your orders and recipes into a list of what to buy this week.

How to choose a baking spreadsheet for your stage

Pick by the job that hurts today. The table gives the usual order.

The twelve home bakery files that cover these jobs are sold as one bundle or one at a time. Each file stands alone, so the pricing file does not read the recipe file. You type the recipe cost into it yourself.

A bakery runs on a few numbers that are written down.

Mistakes that break a baking spreadsheet

Five slips cause most of the trouble.

1. Guessing the ingredient cost, then pricing from the guess.
2. Mixing up markup and margin. A 40 percent markup is a 28.6 percent margin.
3. Mixing units, such as grams in one amount and ounces in the other. The recipe sheet wants both amounts in the same unit.
4. Typing over a formula cell. The files lock formula cells so you do not type over them by accident.
5. Skipping the record of an expense on the day it happens, which the IRS warns can make you forget it at tax time.

What the twelve files are

Does it work in your app? Each file's How to use tab is written in plain words about tabs and cells. Across the twelve, the only menu paths named are Excel's Review, Unprotect Sheet, which opens a protected sheet without a password, and the Name Box, which both apps have.

When a baking spreadsheet is the wrong choice

If you would rather not type at all, a spreadsheet is the wrong tool. These files do not take orders online or send reminders to customers. You also do not need to pay for one. The IRS says the law does not require any specific kind of records, so a blank workbook you build yourself is fine if you are comfortable with formulas. Free recipe cost templates exist online too, and a blank workbook costs nothing. The paid files save you the building and add checks, such as a flag when a price sits under cost, and they are worth it only if you would rather not build the formulas.

The IRS also notes that you may forget expenses when you prepare your tax return unless you record them when they occur. That is the strongest reason to keep any sheet at all.