HBA - Cashflow Spreadsheet Example
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
IncomePendingClearedExpensesPendingClearedCashflow
2
3
Client 1 Invoice 302$300Web hosting-$90Beginning of Month$2,000.00
4
Client 2 Invoice 303$450Paper clips-$2
5
Client 5 Invoice 301$1,500Domain name renewal-$10Income Cleared$2,250.00
6
Client 1 Invoice 304$120Programmer-$600Expenses Cleared-$92.00
7
Client 3 Invoice 305$150Returned modem$60Current Balance$4,158.00
8
9
Income Pending$270.00
10
Expenses Pending-$550.00
11
Expected Balance$3,878.00
12
13
Expected Taxes
14
Federal (28%)$525.84
15
State (7%)$131.46
16
Local (2%)$37.56
17
Total Tax This Month$694.86
18
19
20
Profit$1,878.00
21
Total$270$2,250Total-$550-$92After Taxes (Take Home/Pay Yourself)$1,183.14
22
23
Put expected income that you haven't received yet under Pending.As you receive income, move the total to the "Cleared" column.Follow the same method for expenses, moving them to Cleared when paid.Copy this spreadsheet each month, deleting the income and expenses and updating "Beginning of Month" balance.
24
25
26
27
28
29
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
Loading...
 
 
 
Sheet1