Sample Freelance Tracking Spreadsheet
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLM
1
InvoicedPaidPublicationDoneEarnedWord CountTitleNotesOther To-DosDoneNotes
2
October 2MON
3
Client 1xWork food article draftDue 10-3Inbox Zerox
4
Client 1xWork culture article draftDue 10-5
Pitch Client 3 on how to make freelance spreadsheets
5
Client 2x
Work A/B testing article draft
Due 10-5Invoice Client 3x
6
xClient 31400.001345
The Art of Tracking Freelance Income
Send invoice reminder to Client 2
7
2 p.m.: interview Nicole
555-123-4567
8
6 p.m.: Book Club
9
10
11
12
October 3TUES
13
Client 11200.00622Food: Why Do We Eat It?Invoice Client 1
14
Client 1Work culture article draftDue 10-5
Pay business credit card bill
15
Client 2
Work A/B testing article draft
Due 10-5
Contact three potential sources for spreadsheet piece
16
Ask Mom what she wants for her birthday
17
18
19
20
21
22
October 4WED
23
As you can see, I put clients in this column
And the work I need to complete for that client in this column
24
Notes, like article due dates, go here
25
For finished pieces,
150.00I add the dollar amounts
26
I put both administrative to-dos
27
And life to-dos
28
In this column
29
And check 'em off when they get done
30
And add notes!
31
32
October 5THURS
33
Don't forget to mark when you invoice for a finished piece
And if you need to remind someone about an invoice
34
And when you get paid
35
36
37
38
39
40
41
42
October 6FRI
43
If you want to highlight finished pieces
The Art of Creating Freelance Spreadsheets
44
So they stand out from drafts
Work Nicole interview draftDue 10-13
45
xx
And you can better track whether they've been invoiced/paid
The Art of Knowing When You've Gotten Paid
46
Then do it!
47
48
49
50
51
52
October 7SAT
53
Sometimes you'll do freelance work on the weekends
Weekend life stuff goes here too!
54
So that goes here
55
56
57
58
59
60
61
62
October 8SUN
63
If you have clients that pay by month instead of by piece,
64
You can prorate their monthly paycheck by week
65
(In this example, Client 2 pays $4,000/month)
66
So when you add up all of the money you've earned as a freelancer this week
67
You get the right number.
68
69
70
71
PRORATED CLIENT 2
1000.00
72
73
74
This Week21750.001967
I put formulas in each of these cells to add up my total weekly earnings.
75
You can repeat this for every week in the month
76
And then add up your monthly earnings at the end!
77
You can also customize this spreadsheet so it works for you.
78
Have fun!
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu