A 13-Week Cash Flow Forecast for Small Businesses: See a Cash Crunch Before It Hits
A 13-week cash flow forecast lists expected receipts and payments week by week, including salaries by the 7th, TDS by the 7th, PF and ESI by the 15th and GST by the 20th. Update it weekly with actuals and keep a cash buffer, so shortfalls are visible weeks ahead.
Profit and cash are different. A business can show a healthy profit and still be unable to pay salaries on the 5th, because a large customer pays late and GST is due on the 20th. A 13-week cash forecast shows the gap early enough to act.
Why 13 weeks
Thirteen weeks is a quarter: long enough to see a problem coming, short enough to forecast with real information such as orders, invoices and known payments.
The structure
For each week, list:
Opening cash (bank balances plus cash in hand)
Receipts:
- ✓collections from customers, by customer or by ageing bucket;
- ✓other receipts: loans, asset sales, refunds.
Payments:
- ✓suppliers;
- ✓salaries and wages (by the 7th under the Code on Wages);
- ✓statutory payments: TDS by the 7th, PF and ESI by the 15th, GST by the 20th, advance tax on 15 December and 15 March;
- ✓rent, utilities, loan EMIs, interest;
- ✓planned capital spending.
Closing cash = opening + receipts − payments. Compare with a minimum cash buffer.
A worked example
A Vadodara electrical goods distributor builds a 13-week forecast in October 2026.
| Week | Receipts | Payments | Closing cash | Note |
|---|---|---|---|---|
| 13 Oct | ₹38 lakh | ₹31 lakh | ₹22 lakh | |
| 20 Oct | ₹30 lakh | ₹42 lakh | ₹10 lakh | GST plus festive stock |
| 27 Oct | ₹26 lakh | ₹29 lakh | ₹7 lakh | Diwali bonuses |
| 3 Nov | ₹20 lakh | ₹34 lakh | −₹7 lakh | Salaries and supplier bunching |
The shortfall in early November is visible a month ahead. The distributor agrees early payment discounts with two large dealers, moves one supplier payment by a week with consent, and arranges a short-term rise in its cash credit limit.
Keeping it useful
- Update weekly, replacing forecasts with actuals.
- Forecast collections realistically, based on how each customer actually pays, not invoice due dates.
- Do not forget statutory dates. They do not move.
- Keep a buffer, such as two weeks of fixed costs.
- Act early: chase collections, delay non-essential spending, talk to the bank.
Frequently asked questions
Can I do this in a spreadsheet?
Yes. Accounting software with receivables and payables data makes it faster and more accurate.
Should I include GST in receipts?
Yes. Cash received includes GST, and the GST is paid out later. Both must be in the forecast.
How does this differ from a budget?
A budget is about profit over the year. The cash forecast is about bank balances week by week.
Sources
This is a practical guide, not professional advice.
Written by
Founder, Airwix Technologies (Sleet)
Vatsal Sutariya is the founder of Airwix Technologies in Ahmedabad, the company that builds Sleet: SleetHR for HR and payroll, and Sleet Accounting for GST billing and books. He writes about GST, invoicing, business tax and choosing software for Indian businesses, and checks each rule against the official notification before it is published.
LinkedIn profile →