31/08/2026
📊 Food & Pastry Costing + Business Analysis Template
Akala mo malaki ang benta, pero bakit parang walang naiipon? 😭
Baka hindi lang sa sales ang problema—baka sa costing at expenses pa lang, kinakain na ang profit mo.
Mga ka-baker, even small costs like ½ tsp vanilla, a pinch of salt, packaging, utilities, labor, and other operating expenses can add up and affect your actual profit. Kaya mas okay na alam mo talaga kung saan napupunta ang bawat piso. 🤎
I created this Food & Pastry Costing Template to make costing and business monitoring easier, especially for home-based bakers, pastry businesses, cafés, and food sellers. 🧁☕️
🧁 WHAT'S INSIDE:
⚙️ Settings Tab
Choose your preferred theme color and currency based on where your business is located.
🛒 Ingredients Pricelist
Encode your ingredients once. When supplier prices change, simply update the price here—no need to redo your recipes.
📋 Recipe Builder
Create your recipes in one place without repeatedly encoding ingredient prices for every recipe.
📊 Cost Summary
Enter your yield and selling price per batch/piece, and automatically see your cost per batch and cost per piece.
💰 Pricing Calculator
Choose from 4 different pricing options and see your:
Food cost %
Profit margin
Profit amount
Ingredient cost contribution
📸 Photo Database (optional)
Add product photos so you can easily identify your products inside the Pricing Calculator.
👵🏼 Senior & PWD Discount Calculator
For Philippine-based businesses.
---
📈 AND IT COMES WITH A MONTHLY BUSINESS ANALYSIS REPORT!
Not just costing your recipes—you can also monitor your overall business health.
The Monthly Business Analysis includes:
💸 Operating Expenses
🏷️ Fixed Assets & Depreciation
📈 Break-Even Analysis
📦 Inventory Value
🧁 Product Performance
💰 Sales Performance
📊 Expense Summary
📉 COGS vs. Gross Profit
🎯 Target Profit & Break-Even by Product
And the best part? You can export/download the report as a PDF so you can have a clean, printable monthly report and understand your business numbers at a glance.
No need to be an accountant. You just need to know your numbers. 🤎
✨ One spreadsheet to help you understand your COST → PRICE → PROFIT → BUSINESS HEALTH.
Only ₱199 | One-time payment
📩 PM us if you're interested!
📌 Preview copy available so you can explore the template before getting your own.