What it does
Type what you buy the way you buy it and each recipe once, in cups, spoons, grams or each. Products adds ingredients, packaging, your time and overhead, then suggests a price that keeps your profit after the card fee; type your own price to see the profit, the margin and what an hour of your work earns.
Orders keeps every order with its pickup, products, extras and payments. Order Slip prints a confirmation, quote or receipt and writes a text for the customer. The Dashboard shows sales and profit by month, money still to collect, the next pickups and your best sellers.
Includes an Excel worked example and a blank workbook. Microsoft Excel desktop for Windows was used for checks; other spreadsheet apps are untested.
A real example
- Sugar cookies, box of 12: cost
- $18.35
- Suggested price
- $27.50
- Profit at $36.00
- $16.57
Linden Street Bakes is a made-up home bakery: 26 ingredients and packaging, 8 recipes, 9 products and 95 orders from January to October 2026. Its “Sugar cookies, box of 12” costs $18.35 to make with the baker’s time; the suggested price is $27.50, and at her price of $36.00 it earns $16.57 profit. October shows 12 orders, $689.00 in sales and $548.23 left after ingredients, packaging, card fees and other costs.
I run Forms and Sheets. If you have a question about this file, you can email me. Email Hamza
What is inside
| Section | What it does |
|---|---|
| Start Here | Seven setup steps and short notes |
| Dashboard | Sales and profit this month, money still to collect, the next pickups, a month table with a chart, best sellers |
| Orders | One row per order: pickup, up to three products, extras, discount, paid so far, balance due |
| Order Slip | Pick an order: a printed confirmation, quote or receipt, plus a text for the customer |
| Products | What you sell: cost, suggested price, your price, profit, margin and what an hour earns |
| Cost Card | One product on one printed page: where every dollar goes, the price and the recipe lines |
| Price List | A printed price list for your customers, filled in from Products |
| Recipes | Each recipe once: what it makes, your hands-on minutes, the batch cost |
| Recipe Lines | Every ingredient of every recipe in cups, spoons, grams, ounces or each |
| Ingredients | What you buy as you buy it, packaging too, with optional stock and a Buy flag |
| Expenses | Other costs: equipment, booth fees, permits, ads, gas |
| Settings | Your bakery’s details, hourly rate, margin, card fee, overhead, rounding, sales tax |
Questions
How does it work out a price?
Cost = the ingredients of the recipe share, a second recipe if you add one, packaging, your time at your hourly rate and overhead. The suggested price is cost / (1 - margin - card fee), rounded up to your step. Your own price always wins; the sheet tells you when it is under the suggested price.
Can my recipes use cups and spoons?
Yes: cups, tablespoons, teaspoons, grams, kilograms, ounces, pounds, milliliters, liters, fluid ounces, pints, quarts, gallons, each and dozen. For anything you buy by weight but measure in cups, add its weight of 1 cup on Ingredients.
What happens when an ingredient gets more expensive?
Type the new pack price once. Every recipe, product cost and suggested price updates.
I raised a price. Do my old orders change?
Not if you type the old price in Price before and the day it changed in Changed on: orders picked up before that day keep the old price.
Can I print for my customers?
Yes. Order Slip prints one order as a confirmation, a quote or a receipt and writes a text for the customer. Price List prints your prices.
How is profit counted?
Sales minus ingredients and packaging of what you sold, card fees and your other costs, by pickup month. Your own time is not taken off: it is what you keep.
Which software do I need?
Microsoft Excel desktop for Windows was used for all checks. No macros. Other spreadsheet apps are untested.
What files do I receive?
An Excel worked example with a made-up bakery and a blank Excel workbook.
