Cash flow forecasting for small businesses in India: a 13-week method
A 13-week cash forecast is a weekly table that starts with the cash you hold today, adds the money you expect to receive, subtracts the money you must pay, and shows the balance at the end of each week for the next quarter. It matters more in India than a profit statement because several large payments fall on fixed dates: GST around the 20th, TDS around the 7th, PF and ESI around the 15th, salaries by the 7th and advance tax on four dates. A forecast shows which week will be tight before it arrives.
At a glance
- Use 13 weekly columns and roll it forward every week: drop the week just finished, enter the actual figures, and add a new week 13.
- Estimate receipts from receivables ageing and how each customer really pays, not from the invoice due dates.
- Monthly GSTR-3B is due on the 20th of the following month. Quarterly (QRMP) filers file on the 22nd or 24th, depending on the state.
- TDS is due by the 7th of the following month (30 April for March), PF and ESI within 15 days of month end, and monthly salaries before the seventh day of the next month.
- Advance tax instalments are 15% by 15 June, 45% by 15 September, 75% by 15 December and 100% by 15 March, cumulative.
Structure of the forecast
Each week has the same five blocks:
- Opening cash: the bank balance plus cash in hand at the start of the week. Week 1 is the actual figure, and every later week opens with the previous week's closing cash.
- Receipts: collections from customers, cash and UPI sales, and other inflows such as a loan drawdown or tax refund.
- Payments: suppliers, wages, rent, power, freight, statutory dues, loan instalments and owner drawings.
- Net cash flow: receipts minus payments.
- Closing cash: opening cash plus net cash flow.
Add one line below: a minimum cash buffer you are not willing to go under, for example two weeks of fixed costs. The forecast works only when the first week ties to the bank statement.
Estimating receipts
Take the receivables ageing as of today and apply a collection percentage to each bucket, using the last six months of actual behaviour. The invoice due date is a promise, while your history is the evidence. Then check the large accounts one by one, because a single ₹5,00,000 customer can change a week.
This is an illustration of the next four weeks:
| Ageing bucket | Outstanding | Share expected in 4 weeks | Expected receipt |
|---|---|---|---|
| Not yet due | ₹12,00,000 | 50% | ₹6,00,000 |
| 1 to 30 days overdue | ₹6,00,000 | 60% | ₹3,60,000 |
| 31 to 60 days overdue | ₹4,00,000 | 40% | ₹1,60,000 |
| Over 60 days overdue | ₹3,00,000 | 10% | ₹30,000 |
| Total | ₹25,00,000 | ₹11,50,000 |
Spread the ₹11,50,000 over the four weeks by customer habit, such as customers who pay on Fridays or after month-end. Add cash and UPI sales separately.
The Indian dates that move cash
| Payment | Usual due date | What the official source says |
|---|---|---|
| GST, monthly filer | 20th of the next month | GSTR-3B for monthly filers is due on the 20th |
| GST, QRMP filer | 22nd or 24th after the quarter; monthly tax by challan on the 25th | Date depends on the state; turnover up to ₹5 crore |
| TDS | 7th of the next month; 30 April for March | Rule 218, Income-tax Rules 2026 |
| Provident fund | Within 15 days of month end | EPF Scheme paragraph 38; the 5-day grace period was removed from February 2016 |
| ESI | Within 15 days of the last day of the month | ESIC contribution page |
| Salaries, monthly | Before the expiry of the seventh day of the next month | Code on Wages, 2019, section 17(1)(iv) |
| Advance tax | 15 June, 15 September, 15 December, 15 March | Section 408 of the Income-tax Act, 2025; threshold ₹10,000 under section 404 |
Late costs differ. Late GST attracts interest under section 50 of the CGST Act. Late TDS deposit attracts interest at 1.5% per month or part of a month under section 398(3)(a)(ii) of the Income-tax Act, 2025. Late PF attracts interest under section 7Q and damages under section 14B of the EPF Act. Taxpayers under the presumptive scheme (section 58) pay all advance tax in one instalment by 15 March (section 408(2)).
If a due date falls on a Sunday or holiday, do not assume an extension. Schedule payment for the working day before.
Worked example: four weeks
This is an illustration for a small distributor. Weeks run Monday to Sunday. Salaries are paid on Saturday 5 December. The GST due date, 20 December 2026, is a Sunday, so the forecast pays it on Friday 18 December. Estimated annual advance tax is ₹4,00,000, and ₹1,80,000 (45%) has been paid by 15 September, so the 15 December instalment is 75% less 45%, which is 30% of ₹4,00,000, or ₹1,20,000.
| Line (₹) | Week 1 (30 Nov to 6 Dec) | Week 2 (7 to 13 Dec) | Week 3 (14 to 20 Dec) | Week 4 (21 to 27 Dec) |
|---|---|---|---|---|
| Opening cash | 5,00,000 | 4,70,000 | 6,02,000 | 4,20,000 |
| Customer collections | 2,50,000 | 3,00,000 | 2,50,000 | 3,50,000 |
| Cash and UPI sales | 50,000 | 50,000 | 50,000 | 50,000 |
| Total receipts | 3,00,000 | 3,50,000 | 3,00,000 | 4,00,000 |
| Suppliers | 1,80,000 | 1,60,000 | 1,50,000 | 1,70,000 |
| Salaries | 1,10,000 | 0 | 0 | 0 |
| TDS deposit (7 Dec) | 0 | 18,000 | 0 | 0 |
| PF and ESI (15 Dec) | 0 | 0 | 32,000 | 0 |
| Advance tax (15 Dec) | 0 | 0 | 1,20,000 | 0 |
| GST, net cash (paid 18 Dec) | 0 | 0 | 1,40,000 | 0 |
| Rent, power, freight | 40,000 | 40,000 | 40,000 | 40,000 |
| Loan instalment | 0 | 0 | 0 | 55,000 |
| Total payments | 3,30,000 | 2,18,000 | 4,82,000 | 2,65,000 |
| Net cash flow | (30,000) | 1,32,000 | (1,82,000) | 1,35,000 |
| Closing cash | 4,70,000 | 6,02,000 | 4,20,000 | 5,55,000 |
Total receipts are ₹13,50,000 and total payments ₹12,95,000, so cash rises by ₹55,000, from ₹5,00,000 to ₹5,55,000. The pinch is week 3, when three statutory payments (PF and ESI, advance tax and GST) land together.
Scenarios
Run at least a base case and a downside. Change only the assumptions that are uncertain, usually collections and sales.
| Closing cash (₹) | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Base case | 4,70,000 | 6,02,000 | 4,20,000 | 5,55,000 |
| Downside: ₹1,50,000 of week 2 collections arrive in week 4 | 4,70,000 | 4,52,000 | 2,70,000 | 5,55,000 |
With a buffer of ₹3,00,000, the downside leaves cash ₹30,000 short at the end of week 3, even though week 4 recovers fully. The base case never touches the buffer. That gap is the figure to plan around.
Using the forecast: credit line or delayed payments
Size a working-capital line to the largest shortfall in a realistic downside, not to the average. Here the need is about ₹30,000 for one week against the buffer, so a large limit would be wasted. Compare the cost with the alternatives. For illustration, at an assumed 12% a year, ₹1,00,000 borrowed for 14 days costs ₹1,00,000 × 12% × 14 ÷ 365, or about ₹460. Use your bank's actual rate.
To delay payments, start with trade creditors who agree, and never with statutory dues, which carry interest or damages. Be careful with micro and small enterprise suppliers. Section 16 of the MSMED Act makes a buyer who misses the payment deadline (45 days from acceptance of goods or services) pay compound interest with monthly rests at three times the RBI bank rate. Section 43B(h) of the Income-tax Act, 1961 (reported as section 37(2)(g) of the 2025 Act) lets the buyer deduct such overdue amounts only when actually paid.
Common mistakes
- Forecasting receipts from due dates instead of actual payment behaviour.
- Treating GST as the amount collected rather than the net cash payable after input credit.
- Leaving out advance tax, loan instalments and owner drawings.
- Changing the forecast silently instead of recording the actuals and the variance each week.
- Using one scenario only, so the first late payment becomes an emergency.
- Delaying PF, TDS or GST to save a week of cash, then paying interest or damages.
Checklist
- Build 13 weekly columns starting from the actual bank balance.
- Fill receipts from receivables ageing and each large customer's habit.
- Mark GST, TDS, PF, ESI, salary and advance tax dates in the week they fall.
- Move any due date that lands on a Sunday or holiday to the working day before.
- Set a minimum cash buffer and highlight any week that breaches it.
- Run a base and a downside case.
- Each week, replace the finished week with actuals and add week 13.
- Review variances over ₹25,000 and update the collection percentages.
- Check each due date on the official portal before committing cash.
Sources
- GST portal FAQ on Form GSTR-3B : 20th for monthly filers; 22nd or 24th for quarterly filers.
- GSTN FAQ on the QRMP scheme : the ₹5 crore limit and the 25th payment date.
- CGST Rule 88B : interest on late tax at the rate notified under section 50.
- Income Tax Department FAQ on tax payments under the Income-tax Act, 2025 : TDS timelines, interest, advance tax threshold and presumptive instalment.
- Income Tax Department advance tax due dates : the four instalments and percentages.
- ESIC contribution page : payment within 15 days after the month and the 3.25% and 0.75% rates.
- EPFO FAQ : section 7Q interest and section 14B damages for late PF.
- Kerala High Court judgment quoting paragraph 38 of the EPF Scheme : the 15-day payment period.
- RSM India note on the EPFO circular of 8 January 2016 : removal of the 5-day grace period.
- Code on Wages, 2019 (Ministry of Labour and Employment) : section 17, time limit for paying wages.
- Notification S.O. 5322(E), 21 November 2025 (e-Gazette) : commencement of sections 1 to 41 of the Code on Wages.
- DC-MSME note on delayed payments under the MSMED Act : 45 days and compound interest at three times the bank rate.
This is general information, not tax or legal advice; confirm your own case with a chartered accountant.