How to Forecast Cash Flow

A cash flow forecast gives you early warning of potential shortfalls so you can act before a crisis hits. If you can see three months ahead that cash will dip below a comfortable level, you have time to accelerate collections, delay non-essential purchases, or arrange financing. Without a forecast, shortfalls arrive as emergencies.

Forecasting also supports better decision-making. Considering hiring a new employee? Your forecast shows whether cash flow supports the additional payroll burden. Thinking about a large equipment purchase? The forecast reveals the optimal timing and whether financing is needed.

Banks and investors expect cash flow forecasts. If you apply for a loan or line of credit, the lender wants to see that you understand your cash flow dynamics and can service the debt. A well-prepared forecast demonstrates financial sophistication and increases your credibility.

The 13-week (rolling quarter) cash flow forecast is the standard for small businesses. Start with your current cash balance. For each of the next 13 weeks, project expected cash inflows (customer payments, loan proceeds, other income) and expected cash outflows (payroll, rent, vendor payments, loan payments, taxes). The ending balance each week becomes the starting balance for the next.

For inflows, look at outstanding invoices and their expected payment dates based on historical collection patterns, not payment terms. If clients typically pay in 25 days despite Net 15 terms, use 25 days in your forecast. Add any expected new sales and their likely collection timeline.

For outflows, list all recurring expenses and their payment dates: payroll dates, rent due dates, loan payments, insurance premiums, and tax payments. Add any known one-time expenses like equipment purchases or annual renewals. The result is a week-by-week projection of your cash position.

The best predictor of future cash flow is past cash flow. Analyze at least 12 months of historical bank data to identify patterns: when do clients typically pay? Which months have higher revenue? When do large expenses cluster? Use these patterns as the baseline for your projections.

Calculate your average collection period (days sales outstanding) by dividing accounts receivable by average daily revenue. If your DSO is 35 days, project new revenue collections 35 days after invoicing. Track this metric monthly—a rising DSO signals deteriorating collections and a future cash flow problem.

Look for seasonal patterns. Many businesses have predictable peaks and valleys. Retail businesses may see 30–40% of annual revenue in Q4. Service businesses may slow down during holiday periods. Build these patterns into your forecast rather than assuming flat monthly revenue.

Create three versions of your forecast: optimistic, expected, and pessimistic. The expected scenario uses your best estimates. The optimistic scenario assumes faster collection and higher sales. The pessimistic scenario assumes delayed payments, lost clients, or unexpected expenses.

Stress test your forecast by asking "what if" questions. What if your largest client pays 30 days late? What if a new contract does not materialize? What if a major expense hits unexpectedly? If your pessimistic scenario shows a cash shortfall, you need a contingency plan—whether it is a line of credit, cutting expenses, or accelerating collections.

Update your forecast weekly by replacing projections with actual results and extending the forecast another week. This rolling approach keeps the forecast current and builds your forecasting accuracy over time as you learn from the differences between projections and reality.