Budget Spreadsheet — YOU MUST COPY TO USE

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1		To use this spreadsheet, please select "Make a Copy" from the "File" menu at top left. Otherwise you will not be able to edit. You must have a Gmail account (we're working on a solution for those without).
2		JAN	FEB	MARCH	APRIL	MAY	JUNE	JULY	AUGUST	SEPT	OCT	NOV	DEC	ANNUAL	MONTHS	AVG/MONTH

3	Groceries	200	170	190										560	3	186.6666667
4	Empty Calories	30	10	24										64	3	21.33333333
5	Restaurants/Bars	100	120	90										310	3	103.3333333
6															0
7	Work Coffees/Lunches	30	20	27										77	3	25.66666667
8	Domain	10												10	1	10
9	Business Travel	25	0	40											3	0
10	Professional expenses	5	0	30											3	0
11															0
12															0
13	MetroCards	50	45	60										155	3	51.66666667
14	LIRR/Jitney	70	90	90										250	3	83.33333333
15	European Travel	500	0	300										800	3	266.6666667
16	Amtrak	0	0	100										100	3	33.33333333
17	Misc Travel	13	0	150										163	3	54.33333333
18	Domestic Travel	300	0	200										500	3	166.6666667
19	Gas	30	44	50										124	3	41.33333333
20	Taxis	10	0	25										35	3	11.66666667
21															0
22	Shows/Concerts	50	0	75										125	3	41.66666667
23	Home	0	0	50										50	3	16.66666667
24	Activities	12	25	40											3	0
25	Museums	24	50	0										74	3	24.66666667
26	Misc Shopping	43	78	30											3	0
27	Media (iTunes)	3	10	5										18	3	6
28	Movies	0	30	0										30	3	10
29	Books	0	5	0										5	3	1.666666667
30															0
31	Dry Cleaning/Repairs	0	30	50										80	3	26.66666667
32	New Clothes	70	0	0										70	3	23.33333333
33	Laundry	5	20	5											3	0
34	Shoes (New/Repairs)	0	10	100										110	3	36.66666667
35															0
36	Gifts	100	50	30										180	3	60
37	Charity / Wellesley	40	40	40										120	3	40
38	Hair	0	150	50										200	3	66.66666667
39	Nails	0	25	0											3	0
40	Misc upkeep	0	30	45											3	0
41	Doctors/Dentist	30	0	30										60	3	20
42	Contacts / Glasses	250	0	0										250	3	83.33333333
43	CVS/DR	10	15	35										60	3	20
44														0	0
45	Fees	0	0	0										0	3	0
46	Apartment Buying	0	0	0											3	0
47	Misc	100	20	23										143	3	47.66666667
48	Cash Withdrawals	0	10	0										10	3	3.333333333
49															0
50	FOOD	330	300	304	0	0	0	0	0	0	0	0	0	934	12	77.83333333
51	ENTERTAINMENT	132	198	200	0	0	0	0	0	0				530	9	58.88888889
52	CLOTHES	75	60	155	0	0	0	0	0	0	0	0	0	290	12	24.16666667
53	TRANSPORTATION	973	179	975	0	0	0	0	0	0	0	0	0	2127	12	177.25
54	DISC TOTAL	2110	1097	1984	0	0	0	0	0	0	0	0	0	5191	12	432.5833333
55														0	0
56	Phone	105	105	105	105	105	105	105	105	105	105	105	105	1260	12	105
57	Internet (Auto 14)	65	65	65	65	65	65	65	65	65	65	65	65	780	12	65
58	Electric (Auto TBD)	34	31	45										110	3	36.66666667
59	Gas - Apartment (Auto 1)	28	25	30										83	3	27.66666667
60	Maintenance/Parking (Auto last day of month)	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	1000	12000	12	1000
61	Rent/Mortgage (Auto 16)	1500	1500	1500	1500	1500	1500	1500	1500	1500	1500	1500	1500	18000	12	1500
62	FIXED TOTAL	2732	2726	2745	2670	2670	2670	2670	2670	2670	2670	2670	2670	32233	12	2686.083333
63	TOTAL	4842	3823	4729	2670	2670	2670	2670	2670	2670	2670	2670	2670	37424	12	3118.666667
64
65	INCOME
66	Paycheck	6000	6000	6000											3	0
67	Work Bonuses	1000	0	0											3	0
68	Cash Gifts	100	0	50											3	0
69	Babysitting	50	0	0											3	0
70	Savings Interest	13.65	15.44												2	0
71	Other	0	0												2	0
72
73	MONEY BACK
74	Reimbursements	0	35												2	0
75	Venmo	30	10												2	0
76	Tax Refund	0	0												2	0
77	Misc	10	0												2	0
78	TOTAL INCOME	7203.65	6060.44	6050	0	0	0	0	0.00	0	0	0	0	0	12	0
79
80	ALL BALANCE	2361.65	2237.44	1321	-2670	-2670	-2670	-2670	-2,670.00	-2670	-2670	-2670	-2670	-18109.91	12	-1509.159167
81
82
83
84	SAVINGS																2016+2017
85	Next house	1000		3000										4000	2	2000	22084.7
86	Interest	10.27	11.97	12.39										34.63	3	11.54333333
87														4034.63	3	1344.876667
88	Next trip	1000		500										1500	2	750	7026.21
89	Interest	3.28	3.47	4.11										10.86	3	3.62
90														1510.86	3	503.62
91	Total Savings													9580.12	3	3193.373333
92
93
94
95
96
97
98
99
100