2012 Budget
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
|
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
Starting Bank Acct Balance$500.00
2
3
Paycheck$1,319.20This is the net amount of the paycheck received on this date. The amount is pulled from the 'Paychecks 2012' sheet.
4
5
1/1/2012$1,819.20This is the paycheck + whatever was left over from the last period. Just change the date to whatever your first paycheck of 2012 was dated. The rest of the sheet will adjust.
6
7
Rent/Mortgage$800.00These are all pulled from the 'Bills' worksheet using a Vlookup function. The Groceries and Misc Expenses fields should be deleted at the beginning of each period. The water and electric should also be changed to what the amount actually is. Right now they're just historical averages based on the data on the Bills sheet.
8
Home Insurance$100.00
9
Car Payment 1$230.00
10
Car Payment 2$0.00
11
Cell Phone$80.00Once a Bill is payed, the amount should be made permanent by using the Copy-PasteValue function.
12
Water$56.81
13
Spotify$9.99
14
Groceries$150.00
15
Misc Expenses$150.00
16
Additional ExpensesThese are miscellaneous expenses that come up. You can add more rows as needed.
17
Additional Expenses
18
Additional Expenses
19
Additional Expenses
20
Additional Expenses
21
22
23
Bills$1,576.80This is the total amount of bills and expenses for the period.
24
25
Leftover$242.40This is what you should have left over after bills and expenses.
26
27
28
Paycheck$989.40
29
30
1/15/2012$1,231.80
31
32
Xbox Live$9.99
33
Misc Subscription$1.99
34
Electric$110.22
35
Groceries$150.00
36
Misc Expenses$150.00
37
Internet/Cable$114.99
38
Netflix$8.64
39
Car Insurance$149.00
40
Additional Expenses
41
Additional Expenses
42
Additional Expenses
43
Additional Expenses
44
Additional Expenses
45
46
47
48
Bills$694.83
49
50
Leftover$536.98
51
52
53
Paycheck$1,319.20
54
55
1/29/2012$1,856.18
56
57
Rent/Mortgage$800.00
58
Home Insurance$100.00
59
Car Payment 1$230.00
60
Car Payment 2$0.00
61
Cell Phone$80.00
62
Water$56.81
63
Spotify$9.99
64
Groceries$150.00
65
Misc Expenses$150.00
66
Additional Expenses
67
Additional Expenses
68
Additional Expenses
69
Additional Expenses
70
Additional Expenses
71
72
73
Bills$1,576.80
74
75
Leftover$279.38
76
77
78
Paycheck$989.40
79
80
2/12/2012$1,268.78
81
82
Xbox Live$9.99
83
Misc Subscription$1.99
84
Electric$110.22
85
Groceries$150.00
86
Misc Expenses$150.00
87
Internet/Cable$114.99
88
Netflix$8.64
89
Car Insurance$149.00
90
Additional Expenses
91
Additional Expenses
92
Additional Expenses
93
Additional Expenses
94
Additional Expenses
95
96
97
98
Bills$694.83
99
100
Leftover$573.95
Loading...
 
 
 
Budget
Paychecks 2012
Bills