Sheet template · Finance
Cash Flow Forecast
Map expected cash movement by period with opening balances, inflows, outflows, and projected closing balances.
Small-business owners who want a simple forward-looking view of expected cash timing.
Sign in to start an independent editable workbook from this Sheets template.
Structured preview
Cash Flow Forecast at a glance
Preview only6 columns · 3 sample rows
| Period | Opening balance | Expected inflows | Expected outflows | Net cash flow | Projected closing balance |
|---|---|---|---|---|---|
| October 2026 | $18,000 | $9,500 | $7,200 | =C4-D4 | =B4+E4 |
| November 2026 | =F4 | $12,000 | $8,900 | =C5-D5 | =B5+E5 |
| December 2026 | =F5 | $14,800 | $11,100 | =C6-D6 | =B6+E6 |
Use this as a planning view, not accounting advice; replace assumptions with the cash timing your business expects.
What's included
- Period-by-period cash planning
- Opening and projected closing balances
- Inflow, outflow, and net cash flow formulas
- A readable three-period starting forecast
How to use it
- 1Choose periods that match how often you review cash.
- 2Replace sample inflows and outflows with expected timing, not just annual totals.
- 3Review the projected closing balance with the people responsible for your financial decisions.
Continue exploring