YTD 2023.xlsx

	A	B	C	D	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1					Jan	Feb	Mar	Apr	May	Jun	July	Aug	Sept	Oct	Nov	Dec	YTD Total	Proposed	Amt Remaining

2	Income
3		Operating Income
4			Annual Dues				$4,350.00	$33,050.00	$8,250.00	$2,750.00		$550.00	$2,750.00				$51,700.00	$ 51,700.00	$0.00
5			Bank Interest													$100.00	$100.00		$100.00
6			Capital Contributions														$0.00		$0.00
7			Clubhouse Rental			$700.00		$400.00				$400.00		$200.00			$1,700.00	$500.00	$1,200.00
8			Penalties and Lien Releases														$0.00		$0.00
9			Carryover from 2022		$13,026.40												$13,026.40
10			Transfer reserves				$5,000.00		-$5,000.00								$0.00
11				TOTAL	$13,026.40	$700.00	$9,350.00	$33,450.00	$3,250.00	$2,750.00	$0.00	$950.00	$2,750.00	$200.00	$0.00	$100.00	$66,526.40
12	Expenses
13		Business Expenses
14			Legal Fees												$375.00		$375.00	$600.00	$225.00
15			Office supplies and Postage						$43.86	$262.86							$306.72	$200.00	-$106.72
16			PO Box Rental Fee/Mailbox Install		$513.70												$513.70	$513.70	$0.00
17			Accounting/Website Licenses				$738.00			$198.48		$12.00	$212.37			$212.37	$1,373.22	$1,750.00	$376.78
18			Bank Fees					$ 2.10									$2.10		-$2.10
19		Improvements
20			Holiday decorations		56.22									$49.39		$313.44	$419.05	$500.00	$80.95
21			Clubhouse Blinds														$0.00	$250.00	$250.00
22			Clubhouse drainage improvements														$0.00	$2,000.00	$2,000.00
23			Sprinkler system repair/upgrade														$0.00	$0.00	$0.00
24			Pool furniture														$0.00	$2,624.00	$2,624.00
25		Insurance
26			Loss, Liability & Bonding									$3,207.00		$832.00			$4,039.00	$3,900.00	-$139.00
27		Maintenance and Grounds
28			Clubhouse Janitorial Service		$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$200.00	$162.60	$100.00	$300.00	$2,362.60	$2,400.00	$37.40
29			Trash Collection			$50.00		$50.00		$50.00		$50.00		$50.00		$72.00	$322.00	$192.00	-$130.00
30			Grounds Contract		$850.00			$1,700.00	$800.00	$1,600.00		$800.00	$1,600.00		$800.00	$1,790.00	$9,940.00	$10,200.00	$260.00
31			Mulch, Pinestraw, and Flowers		$3,400.00			$4,500.00	$465.02								$8,365.02	$8,500.00	$134.98
32			Landscape Trimming														$0.00	$3,000.00	$3,000.00
33			Pest Control & Termite Bond										$372.00				$372.00	$534.00	$162.00
34			Security Cameras		$130.00	$65.00	$65.00	$65.00	$65.00	$65.00	$65.00	$65.00	$65.00	$65.00	$90.00	$65.00	$870.00	$780.00	-$90.00
35			Unanticipated Repairs						$63.86	$744.86						$20.61	$829.33	$1,500.00	$670.67
36		Pool Expense
37				Pool Permit				$137.50									$137.50	$125.00	-$12.50
38				Pool Service Contract	$1,750.00			$925.00			$4,822.91	$1,025.00	$975.00	$975.00	$975.00	$975.00	$12,422.91	$10,500.00	-$1,922.91
39				Pool Supplies			$1,545.21										$1,545.21	$500.00	-$1,045.21
40		Utilities
41			Entrance Power Bill		$58.20	$50.40	$19.55	$19.86	$20.76	$20.91	$21.07	$21.23	$21.23	$21.23	$21.67	$20.77	$316.88	$288.00	-$28.88
42			Clubhouse Power Bill		$536.90	$599.17	$291.83	$94.87	$487.63	$499.06	$537.58	$506.98	$520.30	$524.84	$479.33	$533.63	$5,612.12	$5,772.00	$159.88
43			Streetlight Power Bill		$656.70	$656.70	$656.70	$656.70	$656.70	$656.70	$657.12	$657.26	$657.26	$657.26	$657.26	$658.78	$7,885.14	$8,203.00	$317.86
44			Phone, Internet & Cable		$171.10	$171.10	$171.10	$171.10	$171.10			$415.51	$210.54	$204.91		$419.92	$2,106.38	$2,054.00	-$52.38
45			Water		$22.19	$57.21	$22.24		$98.93	$185.72	$211.61		$253.17	$234.32	$230.98	$51.83	$1,368.20	$1,172.00	-$196.20
46				Monthly Expenses	$8,345.01	$1,849.58	$3,709.63	$8,522.13	$3,072.86	$4,483.59	$6,515.29	$6,959.98	$5,086.87	$3,776.55	$3,729.24	$5,433.35
47
48										YTD Expenses							$61,484.08
49			Reserve fund	$ 15,070.63
50										Balance in Checking							$5,042.32
51
52
53
54
55
56
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