Format
Excel
Price
Free
How to use this template
- 1Enter your current cash balance as the opening balance
- 2Forecast expected receipts (customer payments, loans, other income) week by week
- 3Enter planned payments (suppliers, rent, payroll, taxes) week by week
- 4The template calculates net cash flow and closing balance each week
- 5Use the optimistic and pessimistic scenario columns to model best and worst case
- 6Review weekly - update actuals and roll the forecast forward
BudgetsAccess free template
Cash Flow Forecast Template
13-week rolling cash flow forecast with optimistic and pessimistic scenarios. Spot cash shortfalls early.
What's included
- 13-week rolling cash flow forecast
- Optimistic and pessimistic scenario columns
- Opening and closing cash balance per week
- Receivables and payables tracking
- Cash shortfall alerts (cells turn red below threshold)
- Scenario planning input cells for major one-off events
- Summary chart showing cash position over time
Who uses this template
- Business owners planning cash requirements for the next quarter
- Finance teams presenting cash position to directors or investors
- Startups managing runway between funding rounds
- Seasonal businesses planning for low-revenue periods
Want to automate this entirely?
Note.now handles budgets automatically - no spreadsheet required. Real-time data, one-click reports, and bank-connected accuracy.
Try free for 7 daysFrequently asked questions
How do I update it as weeks pass?
Each Sunday, replace the forecast for the week just passed with actuals, and add a new week to the end of the 13-week window.
What should I enter as my opening balance?
Use your current bank account balance as of today, minus any outstanding checks or direct debits not yet cleared.