Here’s the thing nobody tells you about running a small bakery: the baking is the easy part. The hard part is the eight other places your numbers live - the flour invoice taped to the fridge, the recipe card with a price scribbled in pencil, the customer text asking whether the lemon bars have almonds, the mental math on whether last weekend’s market actually made money once you backed out the packaging.
So you end up running the bakery the same way most home bakers and micro-bakery owners do, without an Excel bakery business manager pulling it together. One sheet for ingredient costs, another for recipes, a notebook for orders, a quick search every time someone asks about allergens. Things work, mostly. But pricing is a guess, low stock comes as a surprise, and the question “how much did this batch actually cost me?” takes longer to answer than the batch took to bake.
The Bakery Business Manager is an Excel bakery business manager built to collapse all of that into one workbook. Seventeen connected sheets covering inventory, purchases, recipes, products, sales, invoices, and reporting - with the relationships between them already wired up. Both an Excel version and a Google Sheets version are included in the download, along with an example file and a step-by-step instructions PDF.
The two Inventory sheets - one for ingredients, one for packaging - hold what you stock, the average cost per unit, the current quantity, and the allergens that travel with each ingredient. Status flags (Available, Low Inventory, Unavailable) update automatically from a threshold you set on the Settings sheet, which is the only knob you need to turn to make the low-stock warnings yours. The allergen columns are why Price List can print a customer-facing sheet with allergens already filled in - you tag once at the ingredient, and it carries through.
Purchases - Ingredients and Purchases - Packaging are where new buys get logged with a date and quantity. That entry does three things at once: it raises inventory, recalculates the average cost per unit, and feeds the cost into every recipe that uses the ingredient. Unit conversions are handled by an internal density table per ingredient, so buying flour by the pound and using it by the cup needs no manual math, and imperial and metric can coexist in the same workbook. Recipes and Recipe - Ingredients turn those costs into a true cost per recipe and per serving, including labor and fixed costs you define, so the margin you see on Products is the actual margin, not the optimistic one.
The Product - Sales sheet logs orders with customer information, fulfillment and payment status, shipping, handling, discounts, and platform or transaction fees - the line items most bakery sheets quietly leave out. Logging a sale draws inventory down through Recipe Production, populates a printable Invoice, and lifts the totals on the Dashboard, which shows revenue, cost, and profit broken out as bar, pie, and line charts. A Product Recall Report is there for the day you need to know exactly which orders contained a flagged lot, and the Quick Links panel, drop-down lists, and conditional formatting on production status (Complete, In Progress, Pending) exist so the workbook stays usable on a phone screen during a market morning.
What vanishes is the duplicate entry and the guessing. An Excel bakery business manager that knows the relationship between an ingredient purchase and a slice of cake means a price change at the supplier reaches the margin column on its own, and the question of whether a recipe is still profitable has an answer instead of a feeling. The workbook is fully editable, supports any currency, uses no add-ins or macros, and is built for home bakeries, counter-service bakeries, pastry shops, and food truck operators who’d rather spend the evening proofing dough than reconciling spreadsheets.
