Restaurant cash flow forecast India
Build a 12-month cash flow forecast for your restaurant. Enter inflows by channel (dine-in, takeaway, aggregator, catering) and monthly outflows. Running closing balance auto-computed. Negative months flagged. Click any month to edit its detail. Print or export CSV. No signup.
| Month | Inflow | Outflow | Net | Closing bal |
|---|---|---|---|---|
| Jan 2026 | ₹6.3L | ₹5.9L | ₹43,400 | ₹1.4L |
| Feb 2026 | ₹6.0L | ₹5.5L | ₹54,000 | ₹2.0L |
| Mar 2026 | ₹6.0L | ₹5.5L | ₹54,000 | ₹2.5L |
| Apr 2026 | ₹5.3L | ₹5.3L | ₹400 | ₹2.5L |
| May 2026 | ₹5.3L | ₹5.2L | ₹6,400 | ₹2.6L |
| Jun 2026 | ₹6.3L | ₹5.6L | ₹74,400 | ₹3.3L |
| Jul 2026 | ₹6.3L | ₹5.6L | ₹68,400 | ₹4.0L |
| Aug 2026 | ₹6.3L | ₹5.6L | ₹74,400 | ₹4.8L |
| Sep 2026 | ₹6.3L | ₹5.6L | ₹74,400 | ₹5.5L |
| Oct 2026 | ₹6.3L | ₹5.6L | ₹68,400 | ₹6.2L |
| Nov 2026 | ₹6.3L | ₹5.6L | ₹74,400 | ₹6.9L |
| Dec 2026 | ₹6.6L | ₹5.7L | ₹94,800 | ₹7.9L |
Jan 2026 — detail
Cash Flow Forecast 2026
Opening balance: ₹1,00,000 | Printed: 22/5/2026
| Month | Total inflow (₹) | Total outflow (₹) | Net cashflow (₹) | Closing balance (₹) |
|---|---|---|---|---|
| Jan 2026 | 6,30,000 | 5,86,600 | 43,400 | 1,43,400 |
| Feb 2026 | 6,00,000 | 5,46,000 | 54,000 | 1,97,400 |
| Mar 2026 | 6,00,000 | 5,46,000 | 54,000 | 2,51,400 |
| Apr 2026 | 5,30,000 | 5,29,600 | 400 | 2,51,800 |
| May 2026 | 5,30,000 | 5,23,600 | 6,400 | 2,58,200 |
| Jun 2026 | 6,30,000 | 5,55,600 | 74,400 | 3,32,600 |
| Jul 2026 | 6,30,000 | 5,61,600 | 68,400 | 4,01,000 |
| Aug 2026 | 6,30,000 | 5,55,600 | 74,400 | 4,75,400 |
| Sep 2026 | 6,30,000 | 5,55,600 | 74,400 | 5,49,800 |
| Oct 2026 | 6,30,000 | 5,61,600 | 68,400 | 6,18,200 |
| Nov 2026 | 6,30,000 | 5,55,600 | 74,400 | 6,92,600 |
| Dec 2026 | 6,60,000 | 5,65,200 | 94,800 | 7,87,400 |
| TOTAL / CLOSING | 73,30,000 | 66,42,600 | 6,87,400 | 7,87,400 |
Why cash flow is a different problem from profitability for Indian restaurants
A restaurant can be profitable on paper — revenue exceeds costs — and still run out of cash. This happens because revenue arrives on a different schedule than costs are due. Rent must be paid on the 1st of the month. Staff salaries are due on the 5th. But a large catering order from the 28th of the previous month may not be fully collected yet, and aggregator settlements from the last two weeks are still pending.
Cash flow management is the discipline of tracking when money actually enters and leaves your bank account — not when revenue is earned or when costs are incurred. The cash flow forecast answers the question: on the last day of each month, how much cash will be in my account? If that number goes negative, you have a liquidity problem regardless of how profitable the business is.
Seasonal cash flow patterns in Indian restaurant businesses
- Peak months: October–December (festive season). Navratri, Dussehra, Diwali, Christmas, and New Year's drive the highest revenue months for most restaurant formats in India. Catering, events, and gifting orders spike. Cash inflows are strong, but food costs and casual labour costs also peak. Use the festive surplus to build a cash buffer for slower months.
- Slow months: May–June (summer) and January–February (post-festive). The post-Diwali and post-New Year slowdown hits most restaurants. Footfall drops, corporate orders decline, and catering opportunities are scarce. This is the period most likely to see negative cash flow. Plan in advance by either reducing discretionary spend (marketing, maintenance) or arranging a short-term working capital facility.
- Aggregator settlement lag. Swiggy and Zomato settle weekly, typically 7 days after the order date. ONDC settlement timing varies by partner. If 30–40% of your revenue is aggregator-sourced, a significant portion of your month-end revenue is still in transit. Model this in the forecast by entering aggregator revenue conservatively or adjusting for the lag.
- GST payment timing. GST collected from customers must be paid to the government by the 20th of the following month (monthly filers) or quarterly (quarterly filers under QRMP). This is a significant cash outflow that does not appear as a business cost but does affect your bank balance. Build GST payment into the forecast as a separate line under “Licence fees / taxes.”
- Annual lumpy outflows. FSSAI licence renewal, fire NOC, shop and establishment renewal, and annual insurance premiums create once-a-year outflows that can disrupt cash flow if not planned. Enter these in the specific months they are due so the forecast reflects the actual cash impact.
Where this fits
- P&L statement — the cash flow forecast works alongside the P&L; use actual monthly P&L to validate forecast assumptions
- Working capital calculator — estimate working capital requirements based on your cash conversion cycle
- Expense budget tracker — monthly actual vs budget variance feeds back into forecast assumptions
- Loan EMI calculator — calculate exact monthly EMI for any business loan and enter it in the forecast
- Aggregator payout reconciliation — reconcile actual Swiggy / Zomato payouts against expected to verify forecast accuracy
- P6 — Unit economics pillar — complete guide to P&L analysis, cash flow, and financial management for Indian restaurants