ABCEFGHIJKLMNOPQRSTUVWXYZ
1
Inc/Exp.
Frequency
MonthlyYearlytotalComments
2
(protected)amount
*see row 67*
(protected)(protected)(protected)(protected)
3
Income
work with these 3 unprotected yellow columns
$52,000
4
Wages$2,000 bw$4,333 $52,000
5
Second wagessm$0 $0
6
Other wages/bonus/Social Security
y$0
7
Investment incomeq$0 $0
8
othery$0
9
10
Expenses Est. subtotalpercentComments
11
12
Taxes $00%
13
Federalbw$0 $0
14
Soc. Security or State Ret.bw$0 $0
15
Medicarebw$0 $0
16
Statebw$0 $0
17
Employer Benefits (From your Paycheck Stub)
 $00%
18
Health/Dental Benefitm$0 $0
19
Health Care Spending planbw$0 $0
20
Day Care flex planbw$0 $0
21
ST + LT Disability Planbw$0 $0
22
Group Term life insurancebw$0 $0
23
24
Housing expenses $9242%
25
Rent/mortgage principal, interest & PMI
m$0 $0
26
Utilities$77 m$77 $924
27
Taxes & Homeowners insurancey$0
28
Improvements / Maintenancey$0
29
30
Vehicle Expenses$00%
31
Automobile Paymentsbw$0 $0
32
Auto Insurancey$0
33
Auto Maintenancey$0
34
Gas, Oil, Cleaning, Garagingy$0
35
36
Basic Expenses $00%
37
Groceriesy$0
38
Clothing + Cleaningy$0
39
Personal Insurancey$0
40
Personal Expensesy$0
41
othery$0
42
Baby/Family/Pet expensesy$0
43
44
Job/Studies Related $00%
45
Memberships. Subscriptions, Classes
m$0 $0
46
Lunch, w$0 $0
47
Books, Appliances, Toolsm$0 $0
48
49
Leisure/entertainment/personal
$00%
50
Loan/Credit Card Paymentsw$0 $0
51
Vacation, travely$0
52
Big expenses(PC, Pool, Satellite dish)
y$0
53
Holidays, Birthdays, Anniversariesy$0
54
Dining, Entertainmenty$0
55
Residual medical/dental/prescription
y$0
56
otherw$0 $0
57
58
Charitable donationsy$0 0%
59
60
Savings and Investments$00%
61
 IRA, Roth IRA, Taxablew$0 $0
62
Stock Purchase Plany$0
63
Retirement / 401(k) plany$0
64
65
unaccounted for $982 w$4,256 $51,076 $51,07698%
66
67
m = monthly, w = weekly, y = yearly
sm = semi-monthly (24 times/yr)
bw = bi-weekly ( 26 time per year)
68
69
Columns F,G,H & I are protected so that they cannot be changed casually
70
To unprotect them, just go under Tools on the menu bar and then Protection, and then Unprotect Sheet
71
There is no password protection
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