ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Last Updated: 11/24/2108
2
3
Accrual BasisMonth 1234
4
Revenue20002000400010000
5
Revenue Potential20002000
6
7
Revenue Total20002000600012000
8
9
Expenses1000100020005000
10
Expenses Potential0010001000
11
12
Expenses Projected1000100030006000
13
14
Profit1000100030006000
15
16
17
18
*Accural basis = when you send invoices or when you incur the costs / people send you invoices
19
*Once that month passes, make sure to update with the accruate numbers of what happened. Revenue potential would of course be 0 and you'd only have "Revenue". Potential is only for forecasting purposes
20
It's just as important to have future numbers as it is to know what happened in the past. You can later then get more complex and compare projections you made to what actually happend to see how good you are etc.
21
22
23
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