Getting started
Bakery Accounting Spreadsheet Free: Track Costs and Margin
A free spreadsheet you can build in an afternoon to see what each bake really earns.
On this page
- What columns does a free bakery spreadsheet need?
- How to set up your free spreadsheet in one afternoon
- How to count labor and overhead
- How to find your cost per item
- How to set a price from your margin
- How to track sales from markets and online
- The mistake that hides your real profit
- When a free spreadsheet is not enough
- Keep it going every week
What to remember
- Track ingredients, labor, and overhead separately.
- A free spreadsheet works on your phone.
- Update it weekly, not yearly.
- Your margin is what is left after all three costs.
A bakery accounting spreadsheet free of cost is enough to start, but only if you track the right numbers. You do not need paid software to see your real profit. A simple layout on your phone or laptop can show you what each bake actually earns.
What columns does a free bakery spreadsheet need?
Start with four columns: date, item, money in, and money out. Then add three more for ingredients, labor, and overhead. That gives you a clear picture of each sale. You can add a column for where you sold it, like market or online.
The date column helps you see trends over time, and the item column tells you what sells best. Money in and money out show your cash flow, while ingredients, labor, and overhead break down your costs.
How to set up your free spreadsheet in one afternoon
Open a free spreadsheet app
Google Sheets or Excel both work on a phone. Pick one and create a new sheet.
Make a column for each cost
Ingredients, labor, overhead, and money in. Add a date column first.
Add a row for each bake
Write the date and what you sold. One row per item or per order.
Enter your numbers
Use receipts for ingredients and a timer for labor. Guess nothing.
Check your margin
Money in minus all three costs equals your profit. The spreadsheet does the math.
Start with one bake to test your setup, and enter the numbers for that batch to check the math. Then add more rows as you sell, which keeps the setup simple and accurate.
How to count labor and overhead
Decide on an hourly rate for yourself. Even $10 an hour is better than zero. Use a timer when you bake. Write the hours in your spreadsheet. If you spend 3 hours on a batch, that is 3 times your rate. This number is real, and it belongs in your costs.
Overhead is everything that is not ingredients or your time. Power for the oven, packaging, labels, delivery miles, and your phone bill if you use it for orders. Add a column for each. At the end of the month, total them. Divide by the number of items you sold to see overhead per item.
Keep a separate list of overhead costs, and at the end of the month add them all up. Divide that total by the number of items you sold to get overhead per item.
Suppose you sell 100 items in a month, and your Brevl overhead is $20, which is 20 cents per item. Your ingredients cost $50 for the month, which is 50 cents per item for that batch. You spend 3 hours baking at $10 an hour, which is $30, or 30 cents per item. Total cost per item is 20 plus 50 plus 30 cents, which is $1.00 for that batch. If you sell each item for $3, your margin is $2.00 per item after all costs. The spreadsheet subtracts all three costs from your revenue, so you see the true margin.
How to find your cost per item
To find your cost per item, add your ingredient receipts for the month and divide by the number of items sold. Do the same for labor and overhead, and then add all three numbers together to get the total.
That total is your cost per item, and your spreadsheet can calculate it with a simple formula. Use one cell for ingredients, one for labor, and one for overhead, then add them together in a new cell.
How to set a price from your margin
Your margin is what is left after all three costs, and if it is too low you have two choices. You can raise your price or cut your costs to improve the margin on every item you sell.
Use the spreadsheet to test different prices by changing the price cell and watching the margin change. Aim for a margin that pays you for your time, your risk, and your hard work.
How to track sales from markets and online
Add a column for where you sold each item, and use labels like market, online, or wholesale. At the end of the month, filter by that column to see the results for each channel.
Compare the total margin for each channel, because some channels may have higher overhead like delivery miles. The spreadsheet shows you which channel is worth your time, your money, and your hard work.
The mistake that hides your real profit
Many bakers forget to pay themselves, so they count ingredients and overhead but leave out labor. That makes the margin look bigger than it really is, but the spreadsheet fixes this when you add a labor column.
When a free spreadsheet is not enough
A free spreadsheet works until you have many orders, and then you need recipes with real costing, ingredient inventory, and a weekly planner. If you spend more time updating cells than baking, it is time to switch to a better tool.
Brevl does that for one flat $20 a month, with no cut of your sales, and a 14 day free trial. It works on your phone and computer, and you can take card payments through your own Stripe or Square account.
Try the free bake pricing calculator
Free, no signup.
Keep it going every week
Set a 15 minute slot each week to update your spreadsheet, and add every sale and every receipt. This habit turns a free spreadsheet into a real business tool that you can trust. For a deeper record keeping system, see Cottage Bakery Bookkeeping: 4 Records, One Afternoon.
If you want a ready made layout, our Bakery Spreadsheet Template: Free Download and 4 Columns gives you a starting point. For inventory, the Bakery Inventory List Template: 6 Columns That Stop Waste helps you track what you have.
To see if your numbers add up to a real business, read Is a Home Bakery Profitable: Real Costs and Margins. And for the full getting started path, visit the getting started hub.
Common questions
Can I use Google Sheets for free?
Yes, Google Sheets is free with a Google account. You can open it on your phone or computer. It saves automatically. You can share it with a family member who helps you. No paid software is needed for basic bakery accounting.
What if I sell at a market and online?
Use one spreadsheet for both. Add a column for where the sale came from. That way you see which channel makes more money. You can filter by market or online to compare.
How often should I update my spreadsheet?
Update it at least once a week. If you sell daily, do it every evening. Waiting until the end of the month makes it hard to remember small purchases. A weekly habit takes 15 minutes.
Is a free spreadsheet enough for taxes?
A free spreadsheet can organize your income and expenses. But tax rules vary by state and situation. Keep your receipts and talk to a tax professional. A spreadsheet is a record, not tax advice.
General information, not legal or tax advice.