All templates
Finance
Cashflow Forecast
See money in, money out and the balance week by week.
Cashflow3 rows
| # | AWeek | BOpening | CMoney in | DMoney out | ENet | FClosing |
|---|---|---|---|---|---|---|
| 1 | W1 | 4,200 | 3,100 | 2,480 | 620 | 4,820 |
| 2 | W2 | 4,820 | 1,900 | 3,050 | -1,150 | 3,670 |
| 3 | W3 | 3,670 | 5,400 | 2,900 | 2,500 | 6,170 |
What it tracks
- Money in
- Money out
- Closing balance
- Tight weeks
Included sheets
CashflowAssumptionsChart data
Key calculations
- Net
- =MoneyIn-MoneyOut
- Closing
- =Opening+Net