Pastry Management in Excel and Google Sheets, Recipe Costing, Cake Pricing, Orders and Advance Payments, Mobile, Spanish

How much does each cake really cost you? This template tells you, and it tells you how much to sell it for.

Spanish-language template for Mexican bakers who sell from home or in their shop. Works in Google Sheets (free, also on mobile) and Excel.

COST YOUR RECIPES
• Ingredients: Note down your ingredients as you buy them (1 kg of flour, 30 eggs, etc.). If the price of butter goes up, you change a price and all your recipes are recalculated.
• Recipes: each product with its ingredients and quantities; the cost comes out automatically.
• My products: actual cost per unit including ingredients + gas and electricity + packaging + YOUR time. Suggested price with your margin, rounded to 5 or 10 pesos. Notifies you when a price is no longer profitable.

YOUR ORDERS
• Orders with delivery date and time, advance payment, payment upon delivery, and balance due. "Overdue," "Upon Delivery," and "Balance Due" notifications.
• Customers: how much each one has bought from you, who owes you money, and their last order.
• Today: your upcoming deliveries in order and the shopping list that comes from the week's orders.

FOR YOUR CELL PHONE
• "Mobile" tab: Today's feature is a narrow screen with large font and a search bar. Open it in the Google Sheets app (free).

HOW MUCH DO YOU HAVE LEFT
• Monthly summary: sales, profit per recipe, and actual profit after ingredients, packaging, gas, electricity, advertising, and your salary.
• Which product makes you the most money per year?

YOU RECEIVE
• Blank template (.xlsx)
• Sample version with 12 recipes already costed and 2.5 months of orders
• Step-by-step PDF guide

HOW IT WORKS
1. Purchase and download the files.
2. Google Sheets: Upload it to your Drive and save it as a Google Sheet (the guide tells you how). Excel: Open it with a double-click.
3. Fill in your supplies and recipes once. After that, just record orders and purchases.

IMPORTANT
• Digital product: nothing physical is sent.
• The example recipes are for illustrative purposes; adjust quantities and prices to your own.
• It is a tool to organize your business, not accounting or tax advice.
• Use for your own business; reselling or sharing is not permitted.

—
ENGLISH: Spanish bakery business template for Mexico (Google Sheets & Excel): recipe costing with labor and overhead, suggested prices, custom cake orders with deposits and balances, client list, weekly shopping list from orders, and real monthly profit. Instant download.