Personal Chef Client Tracker

You're cooking for a dozen households every week but still can't tell which ones are actually making you money.

Track recurring meal plan clients, household MRR, and contract profitability — all in one spreadsheet built specifically for independent personal chefs managing 8–20 weekly households.

---

You planned the menus. You sourced the ingredients. You cooked, packed, delivered, and cleaned up — and then did it all again next week. You're running what is, by every definition, a subscription business. But when someone asks "how's business going?" you pause, because honestly? You're not totally sure.

You know you're busy. You know the Hendersons keep adding requests. You know the Patels haven't re-upped their contract in a while. But busy and profitable are two very different things, and right now you're running on intuition instead of numbers.

That's the gap this spreadsheet closes.

---

**The Personal Chef Recurring Revenue OS** is a done-for-you Excel and Google Sheets management system built for independent chefs who run household meal plan contracts �� weekly, bi-weekly, or monthly. It gives you a real-time view of your MRR (monthly recurring revenue), which clients are churning, which are growing, and exactly where your next upsell opportunity is hiding.

No accounting degree required. No complex software subscription. Just open it, enter your clients, and start seeing your business clearly for the first time.

---

**Here's how it works — and why it changes everything:**

**Client Roster and Contract Dashboard**
Every household you serve lives on one clean dashboard. Name, service frequency (weekly, bi-weekly, monthly), contract value, start date, and current status — active, paused, or churned. At a glance, you always know who's on the books and what they're worth per month.

**Monthly Recurring Revenue (MRR) Calculator**
Stop estimating your monthly income. The MRR tracker automatically calculates your total contracted revenue based on each client's frequency and rate. You'll see your real revenue baseline — not what you hope to invoice, but what's actually locked in — updated every time a client changes.

**Per-Client Profitability Breakdown**
This is where most personal chefs have a reckoning. The spreadsheet lets you log your ingredient costs, prep time, and travel per household so you can see your actual margin by client. The Hendersons might be your highest-paying contract, but if they're also your most expensive to serve, your net might be lower than you think. Now you'll know — and you can price accordingly.

**Churn Tracker and Retention Alerts**
Losing a recurring client is the silent killer of a personal chef business. This tracker flags clients whose contracts are expiring soon, who've paused service, or whose renewal is overdue — so you can reach out before they quietly disappear. Proactive retention beats frantic replacement every time.

**Upsell Opportunity Log**
Not every client relationship is maxed out. This section helps you track which households are candidates for add-ons — holiday meal packages, pantry restocking, dietary upgrade tiers, or increased frequency. You'll stop leaving money on the table because you forgot to ask.

**Revenue Trend View (Monthly Snapshot)**
See how your MRR has grown or contracted month over month. Spot the months when clients churned and connect it to what was happening in your business. Build toward a revenue goal instead of just hoping the next month is better than the last.

**Ingredient Cost and COGS Tracker**
Log what you spend per client per service week so your gross margin is always visible. Over time, this data tells you whether your pricing is keeping up with food cost increases — which, as any chef knows, can shift dramatically season to season.

---

**What's included:**
- Client Roster and Contract Status Dashboard
- MRR Calculator with frequency-adjusted revenue
- Per-client profitability and margin tracker
- Churn tracker with renewal date alerts
- Upsell opportunity log by household
- Monthly revenue trend and growth snapshot
- Ingredient COGS log per client
- Pre-built formulas — no setup required
- Clean, professional layout ready to use on day one
- Compatible with both Microsoft Excel and Google Sheets

---

**Who this is for:**
This is built for the independent personal chef who has moved beyond one-off dinner parties and into the steadier, more sustainable world of recurring household contracts. If you're managing 8 or more meal plan clients and you're tracking them in a notebook, a basic spreadsheet you built yourself, or — honestly — just in your head, this system will immediately change how you see and run your business.

This is **not** for restaurant operators, catering companies, or food truck businesses. It is purpose-built for the recurring, household-service model of an independent personal chef.

---

**License:** This template is licensed for personal and single-business use only.

---

**How to get started:**
1. Purchase and download your file
2. Open in Excel or upload to Google Drive to use in Google Sheets
3. Enter your clients, contracts, and pricing
4. Let the formulas do the rest

Your business is already recurring. Your tracking system should be too.

→ Add to cart and know your numbers by tonight.

---

*Questions? Message @bizgrid_co — we respond fast.*

Perfect for: Independent personal chef managing 8-20 recurring household clients on weekly, bi-weekly, or monthly meal plan contracts

Why now: Post-pandemic demand for in-home chef services has exploded among dual-income households and wellness-focused clients, but most personal chefs still invoice ad hoc and have no visibility into true MRR, ingredient cost per household, or which subscription tier is most profitable — leaving serious money on the table as competitors formalize their offerings

✓ Instant digital download
✓ Works with Microsoft Excel (Mac & PC) and Google Sheets
✓ No technical skills required
✓ Formulas and calculations already built in

📋 LICENSE: Personal and single-business use only. This template may not be resold, redistributed, or used to create derivative products for sale.