ABCDEFGHIJ
1
Budget Spreadsheet How To
2
3
4
Welcome to my simple budgeting spreadsheet! This sheet is designed as a simple tool to organize your finances, and to be used in conjunction with other tools. It's not meant to replace other budgeting tools, but to provide a simple start to budgeting. These Instructions will teach you how it works, how to best use it, and how to make a copy!
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
This is the Budget summary section, it's formatted to help you see three things:
28
29
1- Expenses breakdown chart- this is a visual summary of where you spend your money. Does it all go to paying bills? Do you spend all your money on takeout? Look at where your money is going and decide if that’s what your priority should be.
30
31
32
2- Expenses VS income- this is another way of visualizing your budget. The bar graph showing expenses vs income allows you to see just how much of your money you are using every month on pre-allocated expenses. Are you left without any pocket money because its all going to bills? Do you have a bunch of money left over each month because you aren’t putting any away in savings? Use this as another tool to see where and how you can save.
33
34
35
36
3- Flexible Spending and Savings- This is the key to this particular spreadsheet. Here you will see ho much money you can spend on a daily basis and not go over budget. As long as you don’t go over that daily spendable amount you should have enough to pay off everything else you need to and save the way you’ve decided to save. Because some payments are due in the beginning of the month vs the end of the month your spending may change dependent on your payment period. Because of this your daily spendable is also divided by Beginning of the month vs End of the month- allowing you to adjust your spending dynamically.
37
38
39
40
41
42
The income section is made to allow you to input your income. Select from monthly, bi-monthly, and weekly income. There is an extra income section to add any regular income that isn’t accounted for. This section also allows you to select what percent of your paycheck will be put into savings.
43
44
45
46
47
48
49
50
51
52
53
54
55
56
The credit card section is meant to help you see how long it will take to pay or cards, what your interest is, and how much you’re spending overall on credit card payments monthly.
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