Free 12-Month Cash Flow Forecast Template

Cash flow forecasting is the difference between startups that survive and startups that run out of money by surprise. This free 12-month cash flow forecast template helps you project every dollar coming in and going out on a monthly basis. The goal is simple: know exactly when you need more capital so you can act months in advance instead of scrambling. Use the cash flow forecast calculator alongside this template to model scenarios quickly.

Start with the Monthly Revenue Projections section by listing every revenue stream your business has. For SaaS companies, this means MRR broken down by plan tier and expected growth rate. For service businesses, estimate project revenue by month. The critical rule is to be conservative with revenue estimates and aggressive with expense estimates. Optimism about revenue is the number one reason cash flow forecasts fail to predict real outcomes.

Operating Expenses should be split into fixed costs that stay constant regardless of revenue, like rent and software subscriptions, and variable costs that scale with activity, like payment processing fees and cloud hosting. Map each expense to the month it will actually hit your bank account, not when it is invoiced. This timing distinction is what makes cash flow forecasting different from a simple P&L projection and why it matters for survival.

The Payroll Schedule is usually the largest expense category for startups. Include salaries, payroll taxes, health insurance, and any contractor payments. Map each cost to the actual pay date, and account for planned hires by the month they start. Use the burn rate calculator to see how each new hire changes your monthly burn and remaining runway. A single senior hire can cut your runway by months, so model it before making the offer.

Net Cash Flow is where everything comes together. Each month, subtract total outflows from total inflows to get your net cash position. The running balance shows you exactly when cash goes negative. For a detailed walkthrough of this calculation, see our cash flow forecast example that walks through a real startup scenario step by step with actual numbers and common pitfalls explained.

The Runway Calculation section automatically divides your current cash balance by your average monthly net burn to estimate how many months you have left. This number should drive every major decision: when to start fundraising, whether to approve a new hire, and how aggressively to invest in marketing. Our guide on cash flow forecasting for small businesses covers the tactical details of maintaining accuracy over time.

Adopt a rolling forecast approach rather than treating your twelve-month projection as a fixed document. Each month, replace the oldest month's projections with actual results, then add a new month to the end so you always have a full twelve-month forward view. This method keeps your forecast grounded in real performance data instead of increasingly stale assumptions. Compare each month's actuals against what you had projected to identify systematic biases in your estimates, such as consistently underestimating hosting costs or overestimating new customer revenue. The cash flow forecast calculator can help you quickly remodel scenarios as you incorporate fresh actuals into your rolling window.

Update this forecast every month by replacing projections with actuals and extending the forecast window forward. Track your forecast accuracy by comparing what you predicted three months ago against what actually happened. Over time, this feedback loop makes your projections dramatically more reliable. Most founders find that after three months of consistent updates, their forecasts land within ten percent of actual results.