Home Bakery Business Spreadsheet — Cake Pricing Calculator, Recipe Costing, Orders & Cottage Food Labels | Excel + Google Sheets (US Edition)
Home bakery business spreadsheet for Excel and Google Sheets. Cost every recipe, price any cake with a cake pricing calculator, take orders with deposits, plan your baking days and print cottage food labels with allergens. US Edition.
Built for home bakers, cottage food businesses, custom cake makers and cookie decorators. Enter each ingredient price once and every recipe, product and quote updates. Know your real cost, charge the right price, and open the Action Board every morning to see exactly what to do next.
✅ PRICE ANY CAKE IN TWO MINUTES (Cake Builder)
- Up to 5 tiers: round, square or sheet, 4 in or 6 in tall
- Servings, cups of batter, frosting and filling for every tier (Servings & Pan Guide, 17 pans)
- Two prices side by side: by your real cost and margin, and by the serving, with tier surcharge and design fee. It recommends the higher of the two.
- Decoration level, fondant, toppers, boards and boxes, extra hours, delivery and setup
- By the dozen: decorated cookies, cupcakes and cake pops, with the price per dozen and per piece
✅ RECIPE COSTING: ONE CHAIN OF COSTS
- Ingredient price → recipe cost → product cost → order cost → dashboard
- Cups, spoons, fluid ounces, ounces, pounds and grams converted with grams per cup
- 65 ingredients and packaging items pre-filled with typical 2026 US prices, plus 19 base recipes and 25 products ready to adjust
- Real product cost: ingredients, decorations, packaging and your hands-on time × (hourly rate + overhead)
- Suggested price, margin, price per serving and a Price Health check for every product
✅ ORDERS, DEPOSITS AND PRINTABLE DOCUMENTS
- From Inquiry and Quoted to Booked, In Production, Ready and Completed
- Deposit to book, balance due date, rush, delivery (by the mile) and setup fees, sales tax
- Quote / order confirmation with allergens, your terms and a signature line
- Invoice that turns into a receipt once paid in full
- Customers with allergy notes, birthdays and anniversaries for repeat orders
✅ PRODUCTION PLAN AND SHOPPING LIST
- Pick your baking days: every order due, with bake-by dates and payment status
- What to make, servings and hands-on hours
- Batches of each recipe, exact and rounded up to ½
- Shopping list against your stock: packages to buy and estimated cost
- Recipe Card that scales any recipe, with grams and ounces
✅ COTTAGE FOOD LABELS AND ALLERGENS
- The 9 major US allergens follow every ingredient into recipes, products, orders, labels and the menu
- Label Maker: ingredients by weight, "Contains" line, net weight, baked and best-by dates, your state's home-kitchen statement and permit number
- 10 labels per sheet, 2 x 4 in (Avery 5163 / 8163 layout)
- Printable Menu & Allergen Chart for markets and customers
✅ STAY INSIDE YOUR STATE'S COTTAGE FOOD LAW
- Cottage food summary for the 50 states and DC: sales cap, online orders, in-state shipping, permit
- Your sales this year against the cap: OK, Getting close or Over the cap
- Renewals for your food safety card, permit and insurance
- Farmers markets and pop-ups: sell-through, profit and profit per hour
✅ ACTION BOARD AND DASHBOARD
- Orders due in the next 7 days, deposits and balances to collect, quotes waiting for a yes
- Stock to reorder, cake stands out, customer dates and your own task list
- Dashboard: revenue earned, cash received, net profit and dollars per hands-on hour
- Expenses, IRS mileage log and Tax Set-Aside with the four quarterly estimated payments (Form 1040-ES)
📦 WHAT'S INCLUDED (5 files, version 1.3.2)
- READY workbook (.xlsx): for your bakery, with the starter library of ingredients, recipes and products
- DEMO workbook (.xlsx): a fictional home bakery in Thanksgiving week, to see everything working
- Google Sheets Access (PDF): one-click "Make a copy" links to the READY and DEMO Google Sheets versions
- Quick Start (PDF, 3 pages)
- User Guide (PDF, 21 pages)
🇺🇸 US Edition: US dollars, cups / ounces / grams, 9 major US allergens, IRS mileage rates and US quarterly estimated taxes. UK / AU editions coming later.
💻 WORKS IN
- Microsoft Excel 2019 or newer, Microsoft 365 (Windows and Mac)
- Google Sheets (free Google account)
- No macros, no add-ons, no subscription. Your data stays in your own file.
- Not supported: Excel 2016 or earlier, Apple Numbers.
⚠️ GOOD TO KNOW
- This is a digital download. No physical item will be shipped.
- It is an organizational tool, not accounting, tax, legal or food-safety advice.
- Cottage food rules differ by state and change often. The state summary is a starting point: confirm the rules and the label wording with your state.
- Labels are built from your recipes; check them before printing. Nutrition facts are not calculated.
- Pre-filled prices, recipes and products are examples to adjust to what you pay and sell.
QUICK FACTS
- Works in: Excel 2019+ / Microsoft 365 (Win & Mac) · Google Sheets
- Files: 5 (READY + DEMO workbooks, Google Sheets Access, Quick Start, User Guide)
- Tabs: 23, with an Action Board and Dashboard
- Bakery tools: Cake Builder · recipe costing · Production Plan · Label Maker · Menu & Allergen Chart
- Cottage food: 50 states + DC summary · annual sales cap tracker
- Capacity: 500 orders · 300 customers · 60 recipes · 100 products · 150 ingredients
- Edition: US Edition
- Version: 1.3.2 · No macros · No subscription
BOMDOXI Pro Series: business spreadsheets built for one trade at a time. Simple tools. Smarter work.