When someone asks, “How much for a birthday cake?”, do you know where your price comes from? Or are you checking ingredient receipts, thinking about what other bakers charge, and hoping you have remembered everything? Before you send your next quote, take a look at a more consistent way to bring the numbers and the order details together.

Meet the BakeOrderly Home Bakery Order Kit: a practical spreadsheet toolkit for home bakers taking cake, cupcake and cookie orders. It gives you a place to work through your costs, prepare a quote and keep track of what happens next. The examples in this walkthrough are fictional.

Start with the ingredients you actually buy. Enter the pack price, pack size and unit. Then build your recipe using grams, kilograms, millilitres, litres or individual items. Weight and volume stay separate, so the workbook does not assume that a gram and a millilitre are interchangeable.

Enter the recipe’s baked yield and the proportion you expect to be unsellable. The workbook works out the ingredient cost per sellable unit. Then, in Cost Builder, choose the quantity for this order. Add its packaging, your planned working time, your chosen labour rate and an allocation for overheads. You supply the figures and check the assumptions.

Margin and markup are shown separately. A margin is the allowance above the included costs as a share of the selling price. Markup compares that allowance with the cost. They are different percentages, and neither is a promise about your final net profit. You still decide what to charge.

Here is a fictional worked example from the kit. The quote for twelve vanilla cupcakes is forty-four pounds. The cost snapshot is twenty-five pounds and seventy-nine pence. A fifteen-pound payment has been recorded, leaving twenty-nine pounds outstanding. These are sample figures, not a price recommendation. Other fees and taxes may apply to a real business, and your own recipes, time and costs will be different.

Prepare the Quote sheet with the order details and the price you have chosen. Review it, then export a PDF using Excel. When the customer agrees, record the acceptance date. Copy the row on Snapshot Copy and use Paste Special, Values, in Accepted Orders. This is a manual step. It keeps the agreed price as a fixed value, rather than a live link to changing ingredient costs.

Update payments received and the order status manually. The tracker calculates the remaining balance and shows the collection or delivery details you have entered. It does not connect to a bank, take payments, send messages or book a calendar for you.

The core brings together a clean workbook, a clearly labelled fictional example and setup guides. Begin with one recipe and one practice order. Compare the output with your own calculation before using it for a customer.

The files are in X L S X format and have been tested in desktop Microsoft Excel. A desktop or laptop is recommended. Compatibility with Google Sheets and other spreadsheet apps has not been verified. This is an organisation tool, not accounting, legal or food-safety advice, and there is no promise of sales or earnings.

Explore the demonstration and review the proposed contents on the page. BakeOrderly is being prepared for release. The confirmed price, purchase terms and delivery details will be available before sales open. For now, try the clearly labelled illustrative preview and see whether the workflow fits the way you bake and take orders.