finance9 min read

Restaurant cash flow forecasting template (India 2026)

13 week rolling cash flow forecasting template for Indian restaurants; inflows by channel, outflows by category, with the 4 ratios that flag stress early.

By Forkcast Editorial · HORECA research team

P&L profitability and cash flow are different problems. Restaurants close cash poor, not P&L poor. Aggregator settlement is T+7 to T+14. Salaries hit on the 1st. EMI on the 5th. The cash mismatch between these is real money, and most owners discover it on month 3 payroll. Here's the 13 week rolling template that flags stress before the bank account does.

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

  1. Cash runway (weeks); bank balance ÷ weekly burn. Below 4 weeks is code red; 6-8 weeks is healthy.
  2. Aggregator dependence; % of revenue settled T+7 or later. Above 60% means structural cash strain.
  3. Days payable outstanding; average supplier payment days. Going below 10 days means you're funding their float; 25-30 is the sweet spot.
  4. 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

WeekInflows (₹)Outflows (₹)Net (₹)Cumulative cash (₹)
W1 (1st-7th)3,80,0005,60,000-1,80,0005,40,000 → 3,60,000
W24,20,0001,40,000+2,80,0006,40,000
W34,50,0002,30,000+2,20,0008,60,000
W44,40,0001,80,000+2,60,00011,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.

Never delay salary to fund anything else. The reputation cost in the kitchen labour market is bigger than any short term cash benefit. If you have to delay something, delay yourself, then the landlord (negotiate), then suppliers (with notice). Salary is sacred.

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 →

More for you

We use minimal first-party cookies to keep the dashboard signed in and to measure aggregate usage. We do not sell or share your data. See our Privacy Policy and DPDP statement.
Restaurant cash flow forecasting template (India 2026) | Forkcast