ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
6
Freelance Budget Template | How to use this template
7
8
Download as a Microsoft Excel doc to your computer, or go to File in the menu, and click on Make a Copy to add the document to your Google Drive.

Invoicing tab:
Fill in all your job or project information as you're commissioned, then complete the row when you invoice your clients and get paid.

Budgeting & Cash Flow tab:
1. Fill in 6 months' worth of historical income and expense data. It doesn't matter if you're only starting freelancing now – the main thing is understanding the patterns of your expenditure.

2. Use previous months to fill in your forecast months. What expenses will definitely come up every month? Is there a pattern in your variable expenses (like a haircut every 4 months) that you can replicate?

3. At the end of the first actual month using this template, input your Cash Balance (your bank balance) at the bottom of the table (cell H40).

4. In all the months afterwards, the Cash Balance will be automatically generated by a formula in the cell based on the income and expense data you input. If this doesn't match your actual bank balance at the end of the month (which can happen if you forgot to document one of your expenses, or documented it wrong), replace it with the actual value of your bank balance.

5. Once you've finalised an actual month that you previously forecast, adjust the colouring to match 'Actual' and create a new forecast column by copying and pasting. That way you'll always have 6 months' worth of actual income and expenditure data to look back on, and 6 months' worth of forecast months to look forward to.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
If you're looking for a safe and easy way to save for your freelance emergency fund or stash your tax money away in a fund that earns interest:
29
30
Visit franc.app
31
Download the app
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