12-Month Cash Flow Forecast Template
Project inflows and outflows month by month, with a running balance and a clear read on runway. Edit the assumptions and watch how many months of cash you have left update instantly.
Prefer the spreadsheet? 12-Month Cash Flow Forecast Template · Holt-Winters Forecasting Template · Rolling 13-Week Cash Flow · Driver Tree Rolling Forecast — free with an account, 3 free downloads.
See inside before you download: 12-Month Cash Flow Forecast Template · Holt-Winters Forecasting Template · Rolling 13-Week Cash Flow · Driver Tree Rolling Forecast
| Month | Net | Balance |
|---|
What's inside this template
How it works
Enter your opening balance and monthly in/out.
The running balance and runway compute across 12 months.
Flex the assumptions, then export or share.
Related templates
Common questions
How far ahead should a cash-flow forecast run?
Twelve months is the standard for planning and for lenders. Anything beyond that is scenario work rather than forecasting, because the assumptions dominate the arithmetic.
What's the difference between the best, base and worst scenarios?
They flex the assumptions that actually move cash — collection timing, sales volume and cost growth. The point isn't to predict which happens, it's to find the month where the worst case runs out of money.
Why is my forecast positive but I still can't pay bills?
Almost always timing. Revenue is booked when invoiced but cash arrives 30–90 days later, so a growing business can be profitable and still short. The running balance line is what to watch, not the monthly total.
See your runway in seconds
Enter your cash and flows, and watch the runway update as you plan.
Use this template free →