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.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/nNHE4BkmJUY

✨ 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 food cost %, expenses, mileage and net profit by month, top 10 meals, top 10 clients, results by plan type and meal category, and 4 charts
• Sample data from a busy meal prep business so you can see how it works

★ PERFECT FOR ★
✓ Meal prep businesses and meal delivery services
✓ Personal chefs and private chefs
✓ Home bakers and cottage food cooks moving into meal prep
✓ Anyone starting a meal prep business

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 4 files included: an Excel version + a Google Sheets edition, each as a Sample and a Blank copy
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download the files right after purchase.
2. On Setup, Ingredients and Recipe Builder, add your settings, ingredient prices and recipes.
3. Add clients, plan the weekly menu and log orders.
4. The shopping list, prep sheet, route, dashboard and profit report update themselves.

Works in any currency ($, £, €, C$, A$ and more): just change the currency symbol.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Allergen flags are a planning aid only. Always check product labels and talk to clients about cross-contact.
• This is a business planning tool, not tax, legal, financial or medical advice.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.