Getting started
Bakery Bookkeeping Template: Track These 5 Numbers
A simple bookkeeping template for home bakers, with the exact columns to track and how to fill them in.
On this page
- What a bakery bookkeeping template needs to track
- How to fill in the template each week
- How to use your template to set prices
- The mistake that costs you money
- What to do when your numbers do not match
- How to track ingredient price changes
- How to record samples, discounts, and barter
- How to use your template for a monthly profit check
- Where to get a template
What to remember
- Track ingredients, labor, and overhead separately.
- Update your template every week, not once a year.
- Use the numbers to set prices, not guesswork.
- A template is only useful if you actually fill it in.
- Reconcile your template with your bank account once a month.
You do not need accounting software to start. A bakery bookkeeping template can be a notebook, a spreadsheet, or a tool that does the math for you. The key is to record every cost and every sale, so you can see what is left. If you are just starting, our getting started guide walks you through the first steps.
What a bakery bookkeeping template needs to track
Your template needs four columns at minimum: ingredients, labor, overhead, and sales. Ingredients are what you buy to bake. Labor is your time, even if you do not pay yourself yet. Overhead is everything else, like packaging, power, and your Brevl subscription, and keeping these columns separate shows you which cost is eating your margin.
You can also add a column for packaging and labels, and those costs add up fast. If you sell at a market, include your table fee, because every dollar you spend to sell is part of your overhead. Your sales column should record the date, item, quantity, and amount received. That detail helps you spot your best sellers.
List your ingredients
Write down every ingredient you buy for a batch, with the price you paid.
Add your time
Decide an hourly rate for yourself and multiply by the hours you bake.
Add overhead
Include packaging, labels, power, and any monthly tools like Brevl at $20 a month.
Record every sale
Write down what you sold, the date, and how much you received.
Subtract costs from sales
This gives you your profit. If it is negative, you are losing money.
How to fill in the template each week
Set aside 15 minutes every Sunday to go through your receipts and your orders. Fill in the numbers while they are fresh. This habit keeps your bookkeeping from piling up. If you track weekly, you can catch a price increase before it eats your margin.
Start with sales, then match ingredients, then add labor and overhead. Keep your receipts in one envelope or folder, and enter them all at once at the end of the week. If you miss a week, do not skip it, and add the missing week before the next one. If you use Brevl, your sales are recorded automatically when you take an order.
How to use your template to set prices
Once you know your cost per item, you can set a price that leaves a margin. Add up ingredients, labor, and overhead for one batch, then divide by the number of items. For example, a batch uses $10 in ingredients, $15 in labor, and $5 in overhead, which includes the box, label, and power. Total cost is $30.
If you make 12 items, each costs $2.50. To make a 40 percent margin, price each at about $4.17. That price gives $50.04 in sales. Subtract the $30 total cost, and your profit is $20.04.
Your margin is profit divided by sales, which is 40 percent. If you forget labor, you would price too low and lose money. Always include packaging in overhead, because a box and a label can add 50 cents to each item. Always round up to the nearest quarter to make change easier.
The mistake that costs you money
The biggest mistake is mixing your personal money with your bakery money. Use a separate bank account or a separate cash box. When you buy flour with your grocery money, you lose track of what the bakery actually spent. That makes your profit look higher than it is.
Another mistake is not paying yourself, because if you work for free, you cannot grow. Pay yourself something, even if it is small at first, so your business can stand on its own. A third mistake is ignoring small purchases. A small bag of sprinkles still counts.
What to do when your numbers do not match
Sometimes your bank account does not match your template. Check for missing receipts or a sale you forgot to record. Look at your payment app for the exact amount. Fix the template, not the bank.
If you cannot find the difference, make a note and move on. Do not let one mistake stop you from keeping records. Reconcile your accounts once a month. That means comparing your template to your bank statement.
It takes 20 minutes. It catches errors before they become big problems. If the difference is small, still note it. A pattern of small differences can hide a bigger issue.
How to track ingredient price changes
Ingredient prices change often, and flour, butter, and eggs can cost more one month than the next. Your template should have a column for the date you bought each item. When you buy the same ingredient again, write the new price so your recipe cost updates.
If you do not track price changes, you might price a cake using last year’s flour cost. That means you lose money on every sale. Review your ingredient prices once a month and update the template with the latest receipts. This takes 10 minutes and keeps your costs honest.
How to record samples, discounts, and barter
Not every item you bake brings in cash. You might give a sample to a customer or trade a box of cookies for a logo design, but those still have a cost. Record samples as a marketing expense in your overhead. Record barter at the value of the item you gave away.
If you trade a cake for a service, write down the value in sales and the same value in overhead. That keeps your profit number true. Discounts also matter, so if you sell an item at a discount, record the amount you actually received. Do not record the full price, because your sales column should show what actually came in.
How to use your template for a monthly profit check
A weekly template shows you the small picture, while a monthly profit check shows you the big picture. At the end of each month, add up all sales and all costs. Subtract costs from sales to get your profit. Then divide profit by sales to get your margin.
If your margin is lower than last month, look for the reason. Did flour go up, did you give more samples, or did you forget to record a price increase? Write down one change you will make next month, such as raising a price or buying a cheaper box. This monthly review takes 30 minutes and turns your template into a decision tool.
Try the free bake pricing calculator
Free, no signup.
Where to get a template
You can make your own in a notebook or a spreadsheet, or you can use a tool that does the math for you. Brevl has recipe costing and inventory built in, so your bookkeeping updates as you bake. A simple spreadsheet with tabs for ingredients, labor, overhead, and sales works well, so start with one tab and add more as you grow. If you want to start selling online, see how to start a home bakery for extra income.
- Home Bakery Bookkeeping: 3 Numbers to Track Every Week
- Micro Bakery Business Plan Template: 7 Numbers to Fill In
- How to Start a Home Bakery for Extra Income: 6 Steps
Common questions
Do I need a spreadsheet for bakery bookkeeping?
No, you can use a notebook. A spreadsheet helps with math, but the important part is writing down every cost and sale. Pick the method you will actually use each week. A template is just a structure, not a specific tool.
What if I forget to record a sale?
Go back and add it as soon as you remember. Use your bank deposit or your payment app history to find the amount. Do not skip it, because missing sales make your profit look lower than it is. Accuracy matters more than perfection.
How often should I update my template?
Weekly is best. If you wait until the end of the month, you will forget small purchases. A weekly habit takes 15 minutes. It also helps you spot problems early, like a recipe that costs more than you thought.
Can Brevl replace my bookkeeping template?
Brevl tracks your recipe costs, ingredient inventory, and sales. It shows your profit after ingredients, labor, and overhead. You still need to record your sales and expenses, but the math is done for you. It is $20 a month with a 14 day free trial.
What is the most important number to track?
Your profit after all costs. That means ingredients, your time, and overhead. If you only track sales, you might feel busy but lose money. Profit is the number that tells you if your bakery is working.
General information, not legal or tax advice.