Restaurant and Snack Management in Excel and Google Sheets, Dish Costing, Cash Register Reporting, Food Truck, Small Restaurant, Cell Phone, Spanish

How much does each panucho cost you, how much to prepare tomorrow, and how much will you actually have left? This template tells you.

Spanish template for Mexican eateries, small restaurants, snack bars, lunch counters, taco stands, and food trucks. Works in Google Sheets (free, also on mobile) and Excel.

ACTUAL COST OF EACH DISH
• Batch recipes: what it contains and how many servings it yields. The cost per serving includes gas and disposable items.
• Food cost in % and suggested price according to your goal.
• "Check" when the price of meat or dough went up and your price stayed the same.
• Price for apps (Didi, Uber, Rappi) that already pay the commission.

HOW MUCH TO PREPARE
• Your average sales for that same day of the week, plus a mattress. If you run out frequently, it suggests a little more.
• Shopping list with the kilos you need for that.

WHEN CLOSING
• Daily sales: what you prepared and what you sold per dish. You see what was left over and the losses in pesos.
• Cash register closing: cash, card, transfer and apps. It tells you if it balances, has extra or is missing.
• Expenses: market, gas, disposables, helpers, rent, place or permit.

LOCAL, BAZAAR, EVENTS OR FOOD TRUCK
• Sales and profit per day for each location: you know if the bazaar or event is worthwhile for you.

FOR YOUR CELL PHONE
• "Cell Phone" tab: Today's trends on a narrow screen, with large text, and a search engine for dishes and places. Open it in the Google Sheets app (free).

HOW MUCH DO YOU HAVE LEFT
• Monthly summary: sales, cost of food, spoilage, app commission, expenses, your salary, and actual profit.

YOU RECEIVE
• Blank template (.xlsx)
• Example version: a snack bar with 14 costed dishes, a physical location, a bazaar and events, and 2 and a half months of sales
• 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, recipes, and dishes once. Then, at closing time, only enter the day's sales and the closing amount.

IMPORTANT
• Digital product: nothing physical is sent.
• The recipes and prices in the example are for illustrative purposes.
• It's a tool for organizing your business. It's not a point-of-sale system, accounting software, or tax advisory service.
• Use for your own business; reselling or sharing is not permitted.

—
ENGLISH: Spanish restaurant, Mexican street food and food truck management template for Mexico (Google Sheets & Excel): recipe and plate costing, food cost %, suggested and delivery-app prices, daily prep forecast by weekday, shopping list, prepared vs sold and waste, cash count, expenses, profit per location or event, monthly real profit, mobile tab. Instant download.