ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DOWNLOAD OR COPY THIS TEMPLATE TO CREATE YOUR OWN TRACKING SPREADSHEET.
2
Revenue sourceJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
3
Outschool130
4
5
6
7
8
9
10
11
Total Revenue13000000000000
12
Estimated Taxes Owed3900000000000
13
Earnings After Taxes9100000000000
14
15
YTD Revenue130
16
YTD Taxes Owed39
To change the estimated tax percentage from 30%, select cell B22 and edit the formula. Change ".3" to your preferred percentage amount.
17
YTD Earnings After Taxes91
18
19
20
21
22
23
Then, click the bottom righthand corner of the cell and drag across through cell M22 to copy the formula for all months.
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