Table of Contents
- Why Cash Flow Forecasting Matters
- 3 Forecasting Methods (Pick One)
- Method 1: The Direct Method (Best for Small Business)
- Method 2: The Indirect Method (Best for Reporting)
- Method 3: The Rolling Forecast (Best for Growth)
- How to Build a 13-Week Cash Flow Forecast
- Step 1: List All Cash Inflows
- Step 2: List All Cash Outflows
- Step 3: Calculate Weekly Net Cash Flow
- Step 4: Identify Risk Weeks
- How to Improve Forecast Accuracy
- Cash Flow Forecasting Tools
- Forecasting Meets Automation
- Download the 13-Week Forecast Template
- FAQ
- How far out should I forecast?
- How often should I update the forecast?
- What if my forecast is always wrong?
Cash flow forecasting is the difference between reacting to problems and preventing them. A good forecast gives you weeks — sometimes months — of advance warning before a cash crunch hits.
This guide shows you how to build a cash flow forecast that's accurate enough to trust and simple enough to maintain.
Part of The Cash Flow Optimization Playbook.
Why Cash Flow Forecasting Matters
Profit is an accounting concept. Cash flow is a survival concept. You can be profitable and still run out of cash.
A cash flow forecast answers:
- Will we make payroll next month?
- Can we afford that equipment purchase?
- When should we draw on our line of credit?
- Are we building enough reserves?
3 Forecasting Methods (Pick One)
Method 1: The Direct Method (Best for Small Business)
List every expected cash inflow and outflow by date. Sum them. Most accurate for short-term (4–13 weeks).
Method 2: The Indirect Method (Best for Reporting)
Start with net income, adjust for non-cash items (depreciation, amortization), and account for changes in working capital. Best for lenders and investors.
Method 3: The Rolling Forecast (Best for Growth)
Update your forecast weekly, always looking 13 weeks ahead. Replaces the annual budget with a living document.
How to Build a 13-Week Cash Flow Forecast
Step 1: List All Cash Inflows
- Outstanding accounts receivable (by customer, by expected pay date)
- Confirmed new sales with payment terms
- Recurring revenue (subscriptions, retainers)
- Other income (refunds, asset sales, loans)
Step 2: List All Cash Outflows
- Payroll and payroll taxes
- Rent/mortgage
- Loan payments
- Vendor payments (by due date)
- Tax payments
- Insurance
- Utilities
- Variable expenses
Step 3: Calculate Weekly Net Cash Flow
Inflows minus outflows = net cash flow. Cumulative net cash flow = projected cash balance.
Step 4: Identify Risk Weeks
Highlight weeks where projected balance drops below your minimum threshold (typically 2–4 weeks of operating expenses).
How to Improve Forecast Accuracy
- Track actuals vs. forecast — Compare weekly. Identify patterns.
- Use probability weighting — Large deals: 50% probability until contract signed
- Build in buffers — Assume collections take 5 days longer than terms
- Update weekly — A forecast older than 2 weeks is a guess
- Scenario plan — Best case, expected case, worst case
Cash Flow Forecasting Tools
| Tool | Best For | Key Feature |
|---|---|---|
| Float | QuickBooks/Xero users | Real-time sync, scenario planning |
| Pulse | Simple forecasting | Visual cash flow calendar |
| Spreadsheet | Full control | Custom formulas, free |
| LivePlan | Business planning | Integrated forecasting + reporting |
Forecasting Meets Automation
AI-powered forecasting is changing the game. Learn more: How AI Is Changing the Game in Cash Flow Forecasting
Download the 13-Week Forecast Template
Our ready-to-use Excel template with formulas, charts, and scenario tabs.
FAQ
How far out should I forecast?
13 weeks is the sweet spot for operational decisions. 12 months for strategic planning.
How often should I update the forecast?
Weekly for active businesses. Monthly at minimum.
What if my forecast is always wrong?
Track variance (actual vs. forecast). If you're consistently off by the same amount, adjust your assumptions. Forecasting is a skill that improves with practice.