Template
Cash flow forecasting for a small business: a 13-week template
Short answer
A 13-week cash flow forecast lists expected cash in and cash out by week, starting from today's bank balance. Include customer collections (by invoice due date, adjusted for how late each customer usually pays), salaries and statutory payments (TDS by the 7th, PF and ESI by the 15th, GST by the 20th), rent, loan EMIs and vendor payments. Update it every week; the weeks where the closing balance dips below a safe minimum tell you when to chase collections, delay spend or arrange funds.
13-week cash flow template
| Week 1 | Week 2 | Week 3 | |
|---|---|---|---|
| Opening balance | 20.0 | 16.5 | 11.0 |
| + Customer collections | 8.0 | 3.0 | 12.0 |
| − Salaries | — | — | — |
| − TDS / PF / ESI / GST | 2.5 (TDS by 7th) | 1.5 (PF, ESI by 15th) | 3.0 (GST by 20th) |
| − Vendors and rent | 6.0 | 4.0 | 5.0 |
| − Loan EMI | 3.0 | — | — |
| Closing balance | 16.5 | 11.0 | 15.0 |
One column per week; first three weeks shown as an example (₹ lakh).
Put salaries in the week you actually pay them (often the last or first week of the month). Set a minimum balance, for example one month's payroll, and flag any week below it.
How do I make the forecast reliable?
- Use each customer's real payment pattern, not the due date alone.
- Include annual and quarterly items: advance tax, insurance, bonuses, audit fees.
- Compare last week's forecast with what actually happened and correct the assumptions.
- Keep it to cash, not profit: depreciation and accruals don't belong here.
How flowwork.ai solves this
- FlowBooks shows what customers and vendors owe, and a cash flow statement from the books.
- Bank statements are imported and matched, so the opening balance is current.
- Payment reminders, customer statements and UPI QR on invoices help collections arrive sooner.
- Payroll and statutory dues from FlowPay sit in the same books.
See FlowBooks, monthly bank reconciliation and getting overdue invoices paid.
Frequently asked questions
What is a 13-week cash flow forecast?
A week-by-week plan of expected cash in and out for the next quarter, starting from today's bank balance, updated every week.
What should a small business include in a cash flow forecast?
Customer collections, salaries, TDS, PF, ESI and GST payments, rent, vendor payments, loan EMIs and any quarterly or annual payments.
Sources
- flowwork.ai: FlowBooks (checked 16 November 2026)
Spotted something out of date? Tell us and we'll correct it.