ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1
2
Orange Cells contain information or instructionsYellow Cells you can editGray Cells are auto-calculated and you should leave alone.Tax Rate is an estimate only and may vary depending on your state & other factors. Update as necessary.For each week ending on the date to the left, your Freelance pre/post tax earnings are Accumulated.

If you have additional income coming in, you can list your post-tax weekly earnings under Day Job (change the name if you wish) and it will accumulate in the After Tax Take Home Column
3
4
Quarterly Taxes are estimated based on the date entered in the Freelance Ledger between the Quarterly dates listed below. These values are estimates only. For actual values, consult with a CPA
5
6
Tax Rate35%
7
Freelance Ledger
8
DateClientAmountWeek EndingWeekly Gross FreelancingWeekly Taxes FreelancingFreelancing Take homeDay Job 1 Take HomeDay Job 2 Take HomeDay Job 3 Take HomeAfter Tax Take HomeEstimated Taxes Due 2022Estimated Taxes Due 2023
9
3/27/2022
10
Use the Freelance Ledger to list Customer names and dates of payment. This will then be calculated for Weekly Freelancing values as well as Quarterly Taxes. You can delete the values there currently and replace with your own3/25/2022Acme Romance$50.004/3/2022$104.00$36.40$67.60$67.60Q11/1/20223/31/20221/1/20233/31/2023
11
3/26/2022Acme Fantasy$100.004/10/2022$1.00$0.35$0.65$0.65$53.20$0.00
12
3/27/2022Acme Sci Fi$0.004/17/2022$5.00$1.75$3.25$3.25Q24/1/20226/30/20224/1/20236/30/2023
13
3/28/2022Names Do not Matter$0.004/24/2022$0.00$0.00$0.00$0.00$38.85$0.00
14
3/29/2022$1.005/1/2022$0.00$0.00$0.00$0.00Q37/1/202210/31/20227/1/202310/31/2023
15
3/30/2022And can even be blank$0.005/8/2022$0.00$0.00$0.00$0.00$35.00$0.00
16
3/31/2022$1.005/15/2022$0.00$0.00$0.00$0.00Q411/1/202212/31/202211/1/202312/31/2023
17
4/1/2022you can also have$1.005/22/2022$0.00$0.00$0.00$0.00$0.00$17.50
18
4/1/2022duplicate dates$1.005/29/2022$3.00$1.05$1.95$1.95
19
4/1/2022and it still accumulates$100.006/5/2022$0.00$0.00$0.00$0.00
20
4/4/2022$1.006/12/2022$0.00$0.00$0.00$0.00
21
4/14/2022$5.006/19/2022$0.00$0.00$0.00$0.00
22
5/25/2022$3.006/26/2022$0.00$0.00$0.00$0.00
23
7/1/2022$100.007/3/2022$100.00$35.00$65.00$65.00
24
11/30/2023only good through 2023 Q2$50.007/10/2022$0.00$0.00$0.00$0.00
25
7/17/2022$0.00$0.00$0.00$0.00
26
7/24/2022$0.00$0.00$0.00$0.00
27
7/31/2022$0.00$0.00$0.00$0.00
28
8/7/2022$0.00$0.00$0.00$0.00
29
8/14/2022$0.00$0.00$0.00$0.00
30
8/21/2022$0.00$0.00$0.00$0.00
31
8/28/2022$0.00$0.00$0.00$0.00
32
9/4/2022$0.00$0.00$0.00$0.00
33
9/11/2022$0.00$0.00$0.00$0.00
34
9/18/2022$0.00$0.00$0.00$0.00
35
9/25/2022$0.00$0.00$0.00$0.00
36
10/2/2022$0.00$0.00$0.00$0.00
37
10/9/2022$0.00$0.00$0.00$0.00
38
10/16/2022$0.00$0.00$0.00$0.00
39
10/23/2022$0.00$0.00$0.00$0.00
40
10/30/2022$0.00$0.00$0.00$0.00
41
11/6/2022$0.00$0.00$0.00$0.00
42
11/13/2022$0.00$0.00$0.00$0.00
43
11/20/2022$0.00$0.00$0.00$0.00
44
11/27/2022$0.00$0.00$0.00$0.00
45
12/4/2022$0.00$0.00$0.00$0.00
46
12/11/2022$0.00$0.00$0.00$0.00
47
12/18/2022$0.00$0.00$0.00$0.00
48
12/25/2022$0.00$0.00$0.00$0.00
49
1/1/2023$0.00$0.00$0.00$0.00
50
1/8/2023$0.00$0.00$0.00$0.00
51
1/15/2023$0.00$0.00$0.00$0.00
52
1/22/2023$0.00$0.00$0.00$0.00
53
1/29/2023$0.00$0.00$0.00$0.00
54
2/5/2023$0.00$0.00$0.00$0.00
55
2/12/2023$0.00$0.00$0.00$0.00
56
2/19/2023$0.00$0.00$0.00$0.00
57
2/26/2023$0.00$0.00$0.00$0.00
58
3/5/2023$0.00$0.00$0.00$0.00
59
3/12/2023$0.00$0.00$0.00$0.00
60
3/19/2023$0.00$0.00$0.00$0.00
61
3/26/2023$0.00$0.00$0.00$0.00
62
4/2/2023$0.00$0.00$0.00$0.00
63
4/9/2023$0.00$0.00$0.00$0.00
64
4/16/2023$0.00$0.00$0.00$0.00
65
4/23/2023$0.00$0.00$0.00$0.00
66
4/30/2023$0.00$0.00$0.00$0.00
67
5/7/2023$0.00$0.00$0.00$0.00
68
5/14/2023$0.00$0.00$0.00$0.00
69
5/21/2023$0.00$0.00$0.00$0.00
70
5/28/2023$0.00$0.00$0.00$0.00
71
6/4/2023$0.00$0.00$0.00$0.00
72
6/11/2023$0.00$0.00$0.00$0.00
73
6/18/2023$0.00$0.00$0.00$0.00
74
6/25/2023$0.00$0.00$0.00$0.00
75
7/2/2023$0.00$0.00$0.00$0.00
76
7/9/2023$0.00$0.00$0.00$0.00
77
7/16/2023$0.00$0.00$0.00$0.00
78
7/23/2023$0.00$0.00$0.00$0.00
79
7/30/2023$0.00$0.00$0.00$0.00
80
8/6/2023$0.00$0.00$0.00$0.00
81
8/13/2023$0.00$0.00$0.00$0.00
82
8/20/2023$0.00$0.00$0.00$0.00
83
8/27/2023$0.00$0.00$0.00$0.00
84
9/3/2023$0.00$0.00$0.00$0.00
85
9/10/2023$0.00$0.00$0.00$0.00
86
9/17/2023$0.00$0.00$0.00$0.00
87
9/24/2023$0.00$0.00$0.00$0.00
88
10/1/2023$0.00$0.00$0.00$0.00
89
10/8/2023$0.00$0.00$0.00$0.00
90
10/15/2023$0.00$0.00$0.00$0.00
91
10/22/2023$0.00$0.00$0.00$0.00
92
10/29/2023$0.00$0.00$0.00$0.00
93
11/5/2023$0.00$0.00$0.00$0.00
94
11/12/2023$0.00$0.00$0.00$0.00
95
11/19/2023$0.00$0.00$0.00$0.00
96
11/26/2023$0.00$0.00$0.00$0.00
97
12/3/2023$50.00$17.50$32.50$32.50
98
12/10/2023$0.00$0.00$0.00$0.00
99
12/17/2023$0.00$0.00$0.00$0.00
100
12/24/2023$0.00$0.00$0.00$0.00