Why P&L isn't enough
A restaurant doing ₹18 lakhs monthly revenue with 12% EBITDA looks healthy. But:
- ~₹6 lakhs of that revenue sits at aggregator settlement (T+7 to T+14).
- ~₹4 lakhs needs to be in the bank by the 1st for salaries + EMI.
- ~₹1.5 lakhs in statutory payments by the 7th-10th.
- ~₹3 lakhs for supplier payments scattered across the month.
If your bank balance at month end is ₹2L, you're already in the danger zone; one bad week and you delay salary. P&L profitable, cash flow precarious.
The 13 week rolling forecast structure
Build a spreadsheet with 13 columns (one per week). Rows split into:
Inflows (by channel)
- Dine in (cash + card); settles same day or T+1.
- UPI direct; settles same day.
- Zomato; typically T+7.
- Swiggy; typically T+7 to T+10.
- Banquet / events advance; irregular but high cash impact.
- Other (gift cards, catering); irregular.
Outflows (by date due)
- Salaries; 1st of month.
- Statutory (EPF, ESI, GST, TDS, P Tax); 7th-25th depending on instrument.
- EMI; fixed date.
- Rent; typically 1st-7th of month.
- Utilities; 5th-15th.
- Supplier payments; weekly or cycle based.
- Marketing + ads; typically prepaid.
- R&M, software, other; ad hoc.
The 4 ratios that flag stress early
- Cash runway (weeks); bank balance ÷ weekly burn. Below 4 weeks is code red; 6-8 weeks is healthy.
- Aggregator dependence; % of revenue settled T+7 or later. Above 60% means structural cash strain.
- Days payable outstanding; average supplier payment days. Going below 10 days means you're funding their float; 25-30 is the sweet spot.
- Cash conversion cycle; days inventory + days receivable − days payable. Below 0 (you collect before paying) is ideal; above 20 days is dangerous for restaurants.
Worked example: Pune casual dining
| Week | Inflows (₹) | Outflows (₹) | Net (₹) | Cumulative cash (₹) |
|---|---|---|---|---|
| W1 (1st-7th) | 3,80,000 | 5,60,000 | -1,80,000 | 5,40,000 → 3,60,000 |
| W2 | 4,20,000 | 1,40,000 | +2,80,000 | 6,40,000 |
| W3 | 4,50,000 | 2,30,000 | +2,20,000 | 8,60,000 |
| W4 | 4,40,000 | 1,80,000 | +2,60,000 | 11,20,000 |
Week 1 is always the cash trough; salary + rent + EMI hit before aggregator settlements arrive. If your bank balance entering week 1 is under ₹6 lakhs (~1.2× monthly fixed), you're going to struggle. 2× monthly fixed is the safety margin every restaurant should target.
Three levers to improve cash flow without raising prices
Lever 1; Push aggregators to T+7
Negotiate T+7 instead of T+14. For an outlet doing ₹6L monthly aggregator, T+14 → T+7 frees ₹1.5L in working capital permanently. Push at quarterly review meetings; senior account managers can approve.
Lever 2; Shift 10% to direct
WhatsApp ordering + UPI dynamic QR. Direct orders settle same day. Shifting 10% of revenue from aggregator to direct effectively gives you ₹50-80k of permanent cash relief.
Lever 3; Negotiate 30 day supplier credit by month 3
First two months pay COD to build supplier trust. Month 3 onwards, ask for 30 day credit. Even half your suppliers extending to 30 days gives you a permanent 15 day cash float on inventory. Worth ₹1-2L of working capital for a typical casual dining.
Forecast accuracy expectations
Weeks 1-4: should be 90%+ accurate (you know your bookings, your fixed costs, your aggregator settlement). Weeks 5-8: 75-85%. Weeks 9-13: 60-70% (mostly directional). Refresh the forecast every Monday; treat it as a living document, not a quarterly exercise.
Compute your operating break-even →