Cash flow template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXY
1
PLEASE MAKE A COPY FOR YOURSELF, The numbers are samples for illustration only
2
Cash Flow 12 months
Fill the yellow background cells only
3
Version 1Blue background indicates calculations
4
Red in the last row indicates you won't have enough money in the bank that month
5
6
Cash balance at start
5,000
Cash balance at end
7
Cash balance at end4,800
8
9
2016/012016/022016/032016/042016/052016/062016/072016/082016/092016/102016/112016/12TotalNotes
10
Cash in hand (start)
5,0003,7003,400-200-1,300-7001009005001,0502,3003,5504,800Cash in bank at start of this month
11
12
Income
13
Husband2,500002,5002,5002,5002,5002,5002,7502,7502,7502,75026,000
salary bump in september, no pay feb/march
14
Wife02,5002,5002,7002,7002,7002,7002,7002,7002,7002,7002,70029,300salary bump in march, no pay jan
15
Stocks0000000000000
16
Misc0000000000000
17
Misc 20000000000000
18
Misc 30000000000000
19
Misc 40000000000000
20
Total income2,5002,5002,5005,2005,2005,2005,2005,2005,4505,4505,4505,45055,300
21
Cash + Income7,5006,2005,9005,0003,9004,5005,3006,1005,9506,5007,7509,000
22
23
Expenses
24
Mortgage1,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,6001,60019,200
25
Living Expenses8008008008008008008008008008008008009,600
26
Nanny001,6001,6001,6001,6001,6001,60000009,600nanny ends aug
27
DayCare000000001,4001,4001,4001,4005,600day care starts sep
28
Vacations001,20000001,20000002,400
29
Car insurance00500000005000001,000march and september
30
Property taxes0001,900000000001,900feb and august
31
Doctor's/Pediatrician200000200000200000600estimates
32
Investments/stocks4004004004004004004004004004004004004,800
33
Credit card payments
80000000000000800
34
Car repair0000000000000
35
120000000000000
36
130000000000000
37
140000000000000
38
150000000000000
39
160000000000000
40
170000000000000
41
180000000000000
42
190000000000000
43
200000000000000
44
Total expenses3,8002,8006,1006,3004,6004,4004,4005,6004,9004,2004,2004,20055,500
45
Money in bank (end)
3,7003,400-200-1,300-7001009005001,0502,3003,5504,8004,800Cash in bank at end of this month
46
ALERTALERTALERT
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
Loading...
 
 
 
Cash flow
Version History