Home Bakery Inventory and Batch Cost Tracker, Ingredient Cost Per Bake and Recipe Costing Spreadsheet, Excel and Google Sheets Template
Price:$7.21
Here's what's eligible:
- Your order doesn't match the item description or photos
- Your item arrived damaged
- Your item arrived after the estimated arrival window
- Your item didn't arrive or was lost in the mail
You can only make an offer when buying a single item
Highlights
Work out what each box of cookies, tray of brownies or cake costs you in ingredients and packaging, and keep count of what's in your cupboard.
WHAT IT IS
A home-bakery version of our inventory and materials-cost workbook. Enter what you pay for flour, sugar, butter and chocolate (by the gram), and for eggs, fruit and boxes (each), plus what goes into one batch. The sheet calculates the cost per gram or each, the ingredient and packaging cost per saleable item, and the stock you have left.
WHO IT'S FOR
• Home bakers selling cookies, brownies, cakes and bakes in batches
• Small cottage bakeries tracking ingredients and boxes
• Anyone who wants a clear cost per bake before setting prices
WHAT'S INCLUDED (7 tabs)
• Instructions: short step-by-step guide
• Materials: pack price ÷ pack size = cost per gram or each, for ingredients and packaging (up to 50)
• Finished Items: batch cost and cost per saleable item, by bake (up to 30 bakes/SKUs)
• Batch Recipe: the ingredients and packaging used per batch (up to 200 lines)
• Stock Movements: log purchases, usage, baking and sales (up to 500 rows)
• Stock Summary: current stock and estimated value for every ingredient and bake, plus a month-by-month count of stock movements for the year you choose
• Movement Types: the four movement choices behind the dropdowns
A full year of sample data (January to December 2026) is filled in: flour, sugar, butter, eggs, cocoa, chocolate chips, limes, treat boxes and cake boxes, four bakes (cookie box, brownie box, lime butter cake, shortbread box) and 129 stock movements. Look around, then replace it with your own.
HOW IT WORKS
1. Type only in the blue cells. Gray cells calculate for you.
2. Add your ingredients and packaging. Use grams for dry goods and butter, and "each" for eggs, fruit and boxes.
3. Add each bake and how many saleable items one batch makes.
4. List what one batch uses.
5. Log stock movements with positive quantities. The sheet applies the plus or minus sign from the movement type.
6. Check the Stock Summary for balances, estimated stock value and movements per month.
Costs shown are ingredients and packaging only (no labour, energy, overheads or fees), using one currency of your choice. The workbook doesn't track use-by dates, allergens or food-safety records. This is the same design as our general Inventory Tracker with Materials Cost, set up with baking units, labels and sample data.
COMPATIBILITY
• Microsoft Excel (.xlsx file)
• Google Sheets: upload the file to Google Drive, choose Open with > Google Sheets, then File > Save as Google Sheets
• Standard formulas only: no macros, no add-ins, no sign-up
INSTANT DIGITAL DOWNLOAD
This is a digital file. No physical item will be shipped. You can download it as soon as your purchase is complete.
Please note: this template was created with the help of AI tools and reviewed before release.
Instant Download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don’t accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Etsy Purchase Protection
Shop confidently on Etsy knowing if something goes wrong with an order, we've got your back for all eligible purchases —
see program terms
More from this shop
Visit shop-
Digital download
Maker Spreadsheet Bundle, 7 Workbooks: Inventory, Candle, Jewelry and Bakery Trackers, Bookkeeping and Repricing, Excel and Google Sheets
$15.40
-
Digital download
Catalogue Repricing Spreadsheet, Bulk Product Pricing and Profit Margin Calculator for Handmade Sellers, Excel and Google Sheets Template
$4.86
-
Digital download
Jewellery Inventory and Materials Cost Tracker, Jewelry Spreadsheet for Bead, Wire and Findings Cost Per Piece, Excel and Google Sheets
$7.21
-
Digital download
Print on Demand Order Ledger Spreadsheet, POD Income and Expense Tracker with Cash Per Order, Excel and Google Sheets Template
$7.21