Meal Prep Business Spreadsheet, Excel and Google Sheets, Personal Chef Tracker, Recipe Cost Calculator, Weekly Menu, Client Orders

Meal Prep Business Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Run your meal prep or personal chef business from one file: recipe costing, weekly menus, client subscriptions with allergy checks, an automatic shopping list, prep sheet, delivery route, invoices and profit per meal. Perfect for meal prep businesses and meal delivery services. ✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled with example data so you can see how it works) and a BLANK version (ready for your own numbers). ★ WHAT'S INCLUDED ★ • 15 tabs with a clickable Start Here page • Dashboard: 16 KPI tiles (sales, net profit, meals sold, average price per meal, planned and actual food cost %, active clients, weekly recurring sales, meals this week, this week's grocery bill, allergy alerts, clients short of their plan, unpaid invoices, best seller, packaging to order and miles), a month by month table, this week's prep, allergy alerts, unpaid invoices and 5 charts • Ingredients (200 rows): pack size, unit, price and usable yield give you the cost per unit, with 2 allergen flags per ingredient, on hand amounts and a "price checked" date, plus a Packaging table (20 items) with cost each, stock and Order now / Low flags • Recipe Builder (400 ingredient lines): line cost, share of the batch and allergens for every recipe, plus a Recipe Card + Batch Scaler that scales any recipe to the number of portions you need • Menu Costing (60 recipes): batch food cost, food cost per meal, packaging per meal, a suggested price at your target food cost %, profit per meal, margin, a price check, allergens rolled up from the ingredients, meals sold and profit this year • Weekly Menu planner (60 weeks, up to 8 dishes a week) with a menu card for the week you pick: calories, protein, price, allergens, portions ordered and profit per meal • Clients (100 rows): plan, meals per week, price, weekly fee, delivery day, stop, window, zone, diet, 2 allergy flags, dislikes and status, with a plan check (Full / Short / Over), sales, profit, lifetime sales, unpaid invoices and weekly value • Orders (2,500 rows): meals per client, recipe and week with the price, food cost, packaging, profit and an automatic ALLERGY CHECK that flags a recipe containing the client's allergen • Shopping List: built for the week from every order x recipe, grouped by store, with on hand, a buffer, packs to buy and estimated cost (up to 120 items), store totals and packaging to reorder • Prep Sheet: portions and batches per recipe, containers, allergens and a packing list by client with diet, allergies and notes • Delivery Route: stops in delivery-day and stop order with addresses, windows, meals and allergy notes, plus a mileage log (300 rows) • Invoices (400 rows): bill a client for a week or a month; meals and weekly fees add up from Orders, with Paid / Overdue / Due soon status • Expenses (600 rows) with a by-category summary • Profit Report: sales, planned vs actual foo