A Simple 13-Week Cash Flow Forecast for Small Businesses
Published: 10/9/2026
Category: Finance
Profitable businesses still run out of cash. A 13-week cash flow forecast shows trouble weeks before it arrives. How to build one from your billing data in an hour and update it weekly.
Many small businesses that close are profitable on paper. They run out of cash because customer payments arrive later than supplier bills, rent and salaries. A 13-week cash flow forecast (about three months, week by week) shows the tight weeks in advance, so you can act while you still have choices.
The structure
For each of the next 13 weeks:
| Line | Source |
|---|
| Opening cash (bank + cash in hand) | Last week's closing |
| + Customer collections expected | Receivables by due date, plus expected cash/UPI sales |
| − Supplier payments due | Payables by due date |
| − Salaries, rent, EMIs, utilities | Fixed calendar |
| − Taxes (GST, TDS, advance tax) | Due dates |
| − Planned purchases or investments | Your plans |
| = Closing cash | Carry forward |
Build it in an hour
- Opening cash: today's bank and cash balances.
- Collections: export outstanding customer invoices with due dates; adjust for customers who usually pay late. Add expected daily sales based on recent weeks.
- Payments: export supplier bills due, then add salaries, rent, loan EMIs and tax dates.
- Look for negative weeks. These are your warning signs.
What to do when a week looks tight
- Collect faster: reminders, statements, small early-payment benefits
- Negotiate supplier timing: move a payment by a week, agreed in advance
- Delay non-essential spending
- Arrange working capital early, before it becomes urgent
Remember the MSME payment rule: delaying payments to registered micro and small suppliers beyond the allowed period has tax consequences.
Update it weekly
Every Monday, replace last week's forecast with actuals and add a new week at the end. Ten minutes a week keeps it useful.
Where BizFlow fits
BizFlow's receivables and payables reports list amounts by due date, the two hardest parts of a cash forecast, and payment reminders on WhatsApp help speed up collections. See payment reminder automation.
Frequently asked questions
Q: Why 13 weeks?
A: It covers about three months: far enough ahead to act, near enough to estimate reasonably.
Q: What if my business is mostly cash sales?
A: Use the average daily sales from recent weeks for collections, adjusted for seasons and festivals.
Home | Blog