Draft Woodland Trace 2021 Budget with codes - Copy.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2		Woodland Trace HOA
3
4	Codes	2021 Budget	TOTALS	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
5
6		INCOME				412.50
7	4100	Association Assessments (198)	81675	0	0	81675	0	0	0	0	0	0	0	0	0
8		Late Fees	0	0	0	0	0	0	0	0	0	0	0	0	0
9		TOTAL INCOME	81675	0	0	81675	0	0	0	0	0	0	0	0	0
10
11		OPERATING EXPENSES
12	5040	Management Contract	8112	676	676	676	676	676	676	676	676	676	676	676	676
13	5010	Postage/Printing/Admin	1850	150	50	100	100	150	150	100	150	150	150	100	500
14	5031	Accounting Filings	400	0	400	0	0	0	0	0	0	0	0	0	0
15	5030	Legal Fees/Professional	4500	375	375	375	375	375	375	375	375	375	375	375	375
16	5060	Bad Debt	3000	0	0	3000	0	0	0	0	0	0	0	0	0
17		TOTAL OPERATING EXPENSES	17862	1201	1501	4151	1151	1201	1201	1151	1201	1201	1201	1151	1551
18
19		INSURANCE/TAXES
20	5050	Insurance	3936	328	328	328	328	328	328	328	328	328	328	328	328
21		TOTAL INSURANCE/ TAXES	3936	328	328	328	328	328	328	328	328	328	328	328	328
22
23		UTILITIES
24	5110	Electric	14650	1000	1000	1000	1550	1500	1500	1500	1500	1050	1050	1000	1000
25	5115	Gas	792	66	66	66	66	66	66	66	66	66	66	66	66
26	5120	Water/Sewer	3996	333	333	333	333	333	333	333	333	333	333	333	333
27	5140	Telephone	750	0	0	0	0	150	150	150	150	150	0	0	0
28		TOTAL UTILITIES	20188	1399	1399	1399	1949	2049	2049	2049	2049	1599	1449	1399	1399
29
30		Poolhouse/Clubhouse
31	5410	Pool Contract	10470	0	0	0	0	2094	2094	2094	2094	2094	0	0	0
32	5412	Pool Miscellaneous Repairs	3000	0	0	0	500	500	500	500	500	500	0	0	0
33		TOTAL Building	13470	0	0	0	500	2594	2594	2594	2594	2594	0	0	0
34
35		GROUNDS
36	5210	Landscape Contract	14350	0	1385	1385	1885	1385	1385	1385	1385	1385	1385	1385	0
37	5250	Fountain Maintenance	700	0	0	0	0	0	0	0	0	0	0	700	0
38	5232	Pond Maintenance	2050	0	0	0	1025	0	0	0	1025	0	0	0	0
39	5260	Snow Removal	3000	750	750	750	0	0	0	0	0	0	0	0	750
40	5219	Tree Maintenance	1450	0	0	0	550	0	500	400	0	0	0	0	0
41	5221	Common Area Maintenance	1500	0	0	100	200	200	200	200	200	200	200	0	0
42		TOTAL GROUNDS	23050	750	2135	2235	3660	1585	2085	1985	2610	1585	1585	2085	750
43
44		TOTAL EXPENSES	78506	3678	5363	8113	7588	7757	8257	8107	8782	7307	4563	4963	4028
45
46		NET INCOME	3169	-3678	-5363	73562	-7588	-7757	-8257	-8107	-8782	-7307	-4563	-4963	-4028
47
48	5510	RESERVE	3169	0	0	0	0	0	0	0	0	0	0	0	3169
49
50		CASH POSITION	0	-3678	-5363	73562	-7588	-7757	-8257	-8107	-8782	-7307	-4563	-4963	-7197
51		ANNUAL CASH FLOW		-3678	-9041	64521	56933	49176	40919	32812	24030	16723	12160	7197	0
52
53		Pool - Kabana -2020/2021
54		Landscape - Sims 2021/2022								Not Changed
55		Fountain - Hoosier Aquatic-2019/2020								Changed
56		Pond - Hoosier Aquatic-2019/2020
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