lamp.
ResourcesPricingAbout
9 min readBy

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:

  1. 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.
  2. Receipts: collections from customers, cash and UPI sales, and other inflows such as a loan drawdown or tax refund.
  3. Payments: suppliers, wages, rent, power, freight, statutory dues, loan instalments and owner drawings.
  4. Net cash flow: receipts minus payments.
  5. 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 bucketOutstandingShare expected in 4 weeksExpected receipt
Not yet due₹12,00,00050%₹6,00,000
1 to 30 days overdue₹6,00,00060%₹3,60,000
31 to 60 days overdue₹4,00,00040%₹1,60,000
Over 60 days overdue₹3,00,00010%₹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

PaymentUsual due dateWhat the official source says
GST, monthly filer20th of the next monthGSTR-3B for monthly filers is due on the 20th
GST, QRMP filer22nd or 24th after the quarter; monthly tax by challan on the 25thDate depends on the state; turnover up to ₹5 crore
TDS7th of the next month; 30 April for MarchRule 218, Income-tax Rules 2026
Provident fundWithin 15 days of month endEPF Scheme paragraph 38; the 5-day grace period was removed from February 2016
ESIWithin 15 days of the last day of the monthESIC contribution page
Salaries, monthlyBefore the expiry of the seventh day of the next monthCode on Wages, 2019, section 17(1)(iv)
Advance tax15 June, 15 September, 15 December, 15 MarchSection 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 cash5,00,0004,70,0006,02,0004,20,000
Customer collections2,50,0003,00,0002,50,0003,50,000
Cash and UPI sales50,00050,00050,00050,000
Total receipts3,00,0003,50,0003,00,0004,00,000
Suppliers1,80,0001,60,0001,50,0001,70,000
Salaries1,10,000000
TDS deposit (7 Dec)018,00000
PF and ESI (15 Dec)0032,0000
Advance tax (15 Dec)001,20,0000
GST, net cash (paid 18 Dec)001,40,0000
Rent, power, freight40,00040,00040,00040,000
Loan instalment00055,000
Total payments3,30,0002,18,0004,82,0002,65,000
Net cash flow(30,000)1,32,000(1,82,000)1,35,000
Closing cash4,70,0006,02,0004,20,0005,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 1Week 2Week 3Week 4
Base case4,70,0006,02,0004,20,0005,55,000
Downside: ₹1,50,000 of week 2 collections arrive in week 44,70,0004,52,0002,70,0005,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

This is general information, not tax or legal advice; confirm your own case with a chartered accountant.

Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →