Pricing Workbook: your recipes, your spreadsheet, one price

The Pricing Workbook is an Excel/LibreOffice spreadsheet built around the same math as the free calculator, with room to keep every recipe you actually sell. It is not a subscription and it does not phone home: you download an xlsx file, open it in Excel, Google Sheets or LibreOffice, and it is yours.

Six connected sheets: a Start Here page explaining the layout, a Density sheet listing ounces-per-cup for common baking ingredients so cup measurements convert correctly, a Recipe sheet where you list ingredients with quantity and unit and get a cost per cake back through formulas you can see and edit, an Orders log to track what you have baked and charged, a Quote sheet formatted to send or print for a customer, and a Fixed Costs sheet to spread your monthly kitchen and delivery costs across your typical order volume.

Every cell that expects your input is shaded and editable; formula cells are locked from accidental typing but never from you, this is not a locked-down app, you can inspect and change any formula. Margin and markup are shown as two separate numbers on the Quote sheet, with a short note on why they are not the same thing.

$39 once. Delivered as a download after checkout. For a version that also outputs a per-order PDF quote and invoice, see the Order Quote Kit, or get both plus a sample recipe pack in the Starter Bundle.

The six sheets

• Setup: your hourly rate, target margin, monthly fixed costs and expected orders per month
• Ingredients: one master list with package price and package size, feeding every recipe
• Recipes: one block per product, with yield, and automatic cost per batch and per unit
• Packaging: per order and per unit materials kept separate from ingredients
• Pricing: the supported price for each product at your margin, side by side
• Orders: a log of what you actually sold, with effective hourly pay per order

Why one shared ingredient list

When butter moves from $4.49 to $5.29 a pound, a workbook with a shared list reprices every recipe that uses butter the moment you change one cell. That is the difference between a spreadsheet you update twice a year and one you actually keep current, and it is the main reason to move off a per cake calculator once you sell more than a handful of products.

What you get and what it costs

An xlsx file, $39 once, no subscription and no expiry, opening in Excel, LibreOffice Calc or Google Sheets. It is delivered with the recipes you entered at checkout already loaded, so the first sheet you open has your own numbers in it rather than a demo. If you also want a per order quote and invoice document, the Starter Bundle adds the Order Quote Kit for less than the two bought separately.

Step by step setup after download

Set aside 45 to 90 minutes for the first setup if you have 5 to 15 products. Do it when you have your package labels, recent receipts, and recipe cards in front of you, not from memory.

A useful order of work is ingredients first, recipes second, packaging third, fixed costs fourth, then pricing checks. If you reverse that order, you can still use the file, but you will usually revisit the same cells several times.

For each recipe, test one real batch against the spreadsheet within the next bake cycle. If the workbook says a batch yields 24 cookies but your tray count gives 21 saleable cookies after breakage and trimming, price from 21. The spreadsheet cannot know your waste unless you put it in the yield.

Equipment, workspace, and practical dimensions

The physical setup is small, but accuracy depends on the tools beside the keyboard. A 13 inch laptop screen is usable, but a 22 to 27 inch monitor makes recipe blocks and ingredient lists easier to check side by side. If you use a small screen, work at 90 to 100 percent zoom and freeze panes only if your spreadsheet app handles it cleanly.

Use a digital kitchen scale that reads at least to 1 gram or 0.1 ounce for ingredients that drive cost, such as butter, chocolate, nuts, cream cheese, and packaging sold by weight. For very low weight items, such as spices, salt, coloring, and leavening, measure the amount used in 10 batches, then divide by 10. This reduces rounding error.

Keep one folder for the working workbook, one folder for dated backups, and one folder for quotes or exported customer documents if you make them from the file. Short file names work better than long names when syncing between a laptop and a tablet.

Frequent mistakes and how to recover

The most common mistake is sorting only one column of an ingredient list. If ingredient names move but prices do not move with them, close the file without saving and reopen the last good copy. If you already saved it, compare against a backup and rebuild that section row by row.

The second common mistake is entering a package price as a unit price. For example, a bag, box, tub, or bottle price belongs with the full package quantity. If the cost result looks 10 times too high or 10 times too low, check package quantity first.

Another error is treating volume as weight without a density check. One cup of powdered sugar, one cup of cocoa, and one cup of chopped nuts do not weigh the same. If a recipe changes from cups to ounces, weigh the ingredient in your own kitchen at least once and write that number in your notes.

If a formula cell is accidentally typed over, do not continue entering orders. Copy the same formula from a clean neighboring row if the layout is identical, or restore that sheet from the untouched copy. If several formulas are affected, restoring the whole workbook is usually safer than guessing.

If your hourly pay result looks wrong, separate active labor from waiting time. Twenty minutes of mixing, 35 minutes of baking, and 60 minutes of cooling are not the same thing unless you are blocked from doing any other paid work during the cooling period.

Special cases that need extra checks

Custom cakes, wedding orders, allergy separated batches, seasonal boxes, and delivery heavy orders need more review than standard cookies or cupcakes. They often contain hidden time in messaging, design changes, shopping, cleaning, packing, and travel.

For a custom cake, price the base flavor first, then add fillings, supports, boards, boxes, toppers, and the decorating time that applies to that design. Do not average a simple buttercream cake with a sculpted cake unless you want the simple cake to subsidize the complex one.

For seasonal ingredients, keep the normal ingredient line and update it when the price changes. If strawberries, butter, or chocolate swing sharply for a holiday week, make the update before quoting, not after the order is accepted.

For dietary separation, track the extra pan liners, gloves, labels, cleaning time, and any ingredients bought only for that order. A small gluten free or nut free order can carry more setup time than a larger standard order.

For more file handling questions, including opening and saving behavior, use the FAQ before editing your only working copy.

Read next

• How ordering works: How ordering works on Home Bakery Pricing: enter your recipe and options, pay once, and your file is generated from those exact numbers immediately.
• Cookie pricing calculator: price by the dozen: Price a batch of cookies by ingredient, labor and packaging, then see cost per dozen and per cookie.
• Cottage food pricing guide: How cottage food rules affect pricing: sales caps, permit fees and labeling costs to plan for, plus where to check your own state's specific limits.