ABCDEFG
1
This cash flow forecast spreadsheet is brought to you by Tide
2
-To get started, go to File > Download > Microsoft Excel (.xlsx) and adjust the examples to fit your business.
-Alternatively, make a copy of this file (File > Make a Copy) and use it as a Google Sheet.
3
4
5
Cash Flow Forecast
6
Your company name
7
Date (day/month/year)
8
9
DateWeek 1 Week 2Week 3 Week 4 Week 5 Week 6
10
Opening Bank Balance£53.00£2,438.00£6,013.00-£1,992.00-£47.00£398.00
11
12
Cash In
13
Source 1£1,000.00£1,000.00£1,000.00£1,000.00£1,000.00£1,000.00
14
Source 2£2,000.00£200.00£0.00£0.00£2,000.00£0.00
15
Source 3£0.00£750.00£0.00£750.00£0.00£750.00
16
Source 4£600.00£1,800.00£700.00£500.00£600.00£600.00
17
Total Cash In£3,600.00£3,750.00£1,700.00£2,250.00£3,600.00£2,350.00
18
19
Cash Out
20
Other£60.00£20.00£3,500.00£150.00£0.00£10.00
21
Software Subscription£0.00£0.00£50.00£0.00£0.00£0.00
22
Staff£1,000.00£0.00£1,000.00£0.00£1,000.00£0.00
23
Product£0.00£0.00£5,000.00£0.00£2,000.00£0.00
24
Expense #1£75.00£75.00£75.00£75.00£75.00£75.00
25
Expense #2£50.00£50.00£50.00£50.00£50.00£50.00
26
Expense #3£30.00£30.00£30.00£30.00£30.00£30.00
27
Total Cash Out£1,215.00£175.00£9,705.00£305.00£3,155.00£85.00
28
29
Closing Bank Balance£2,438.00£6,013.00-£1,992.00-£47.00£398.00£2,663.00
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100