Forecasting template
Cash Flow Forecast Template
See when cash gets tight before it happens. Each month's closing balance becomes the next month's opening balance automatically.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | Jan | Feb | Mar | |
| 2 | Opening balance | 100,000 | =B5 | =C5 |
| 3 | Cash in | 80,000 | 80,000 | 80,000 |
| 4 | Cash out | 72,000 | 72,000 | 72,000 |
| 5 | Closing balance | =B2+B3-B4 | =C2+C3-C4 | =D2+D3-D4 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =B2+B3-B4
Closing cash is opening cash plus money in minus money out.
C2 =B5
Next month starts where this month ended.
Make it yours by asking
Try a request like this in Tabstra:
"Build a 12-month cash flow forecast with opening balance, cash in, cash out and closing balance"
Questions
Related templates
Sales Forecast
A 12-month revenue forecast driven by one starting value and one growth assumption.
Startup Financial Model
Revenue drivers, costs, burn rate and runway for an early-stage company.
Business Budget
Monthly revenue, costs and profit for a small business, with totals that update automatically.