Oct 21 Financial.xlsx

	A	B	C	D	E	F	G	H	I
1							Oct 21	YTD	Budget
2		Ordinary Income/Expense
3				Income
4					Annual Charges		1,425.00	91,685.00	93,000.00
5					Beach Concessions		0.00	2,321.50	2,300.00
6					Beach Gate Money		0.00	1,471.00	2,100.00
7					Building Permit		905.00	4,290.00	4,500.00
8					Citations		0.00	0.00	300.00
9					Community Building Rental		800.00	5,125.00	1,000.00
10					Initiation Fee		200.00	2,800.00	1,800.00
11					Late Charge		625.00	3,135.00	4,000.00
12					Legal Fees Collected		2,062.80	3,891.80	2,000.00
13					Membership Fees		200.00	33,200.00	32,500.00
14					Miscellaneous Income		0.00	3,010.26	4,000.00
15					Watercraft Stickers		60.00	30,830.00	31,200.00
16				Total Income			6,277.80	181,759.56	178,700.00
17
18				Expense
19					Administrative Expenses
20						Accounting Services	478.00	3,509.00	5,000.00
21						Attorney Services	721.90	15,224.90	7,500.00
22						Administrative	45.29	3,178.75	3,500.00
23						Bank Service Charge	0.00	203.09	350.00
24						Cell Phone	0.00	114.83	100.00
25						Dam Annual Fee	0.00	1,031.72	900.00
26						Dues and Subscriptions	0.00	2,258.38	400.00
27						Insurance expense	-174.00	7,855.00	9,800.00
28						Merchant Deposit Fees	34.80	1,466.39	1,500.00
29						Newsletter mailing/printing	0.00	1,088.38	1,500.00
30						Ohio Commercial Act. Tax	0.00	150.00	150.00
31						Reserve Fund Transfer	0.00	0.00	7,500.00
32						Smoke Signals	0.00	2,355.26	5,000.00
33						Taxes-Property	0.00	10,144.78	10,100.00
34						Telephone and Internet Expense	224.97	2,089.70	2,200.00
35						Web Page	0.00	243.39	500.00
36					Total Administrative Expenses		1,330.96	50,913.57	56,000.00
37
38					Operating Expenses
39						Beach	0.00	2,216.75	3,000.00
40						Cleaning	100.00	700.00	800.00
41						Cleaning Supplies	0.00	495.00	600.00
42						Electric	519.80	4,639.10	6,500.00
43						Gasoline Lake Patrol	0.00	750.00	700.00
44						Lake Patrol	0.00	1,539.25	4,000.00
45						Lake Stock	0.00	0.00	750.00
46						Landscaping	0.00	0.00	750.00
47						Lawncare	5,177.38	35,694.29	40,000.00
48						Outside Services	0.00	0.00	3,000.00
49						Propane	0.00	951.80	2,500.00
50						Property Management	0.00	12,673.60	8,000.00
51						Trash Service	182.25	1,843.70	2,000.00
52						Water	92.96	1,214.24	1,400.00
53					Total Operating Expenses		6,072.39	62,717.73	74,000.00
54
55					Payroll Expenses
56						Beach	0.00	14,860.47	15,000.00
57						Clerk	1,725.00	17,850.00	20,700.00
58						Lake Patrol	0.00	7,395.00	9,000.00
59						Employer Taxes	182.84	4,560.92	4,000.00
60					Total Payroll Expenses		1,907.84	44,666.39	48,700.00
61						Total Expense	9,311.19	158,297.69	178,700.00
62
63	Net Income/Loss						(3,033.39)	23,461.87	0.00
64					Bank Balances
65						Security checking		117,809.73
66						Spillway checking		76,835.87
67						Reserve Funds		106,223.87
68						Total SHPOA Funds		300,869.47
69			Other Income
70				Beach Improvement Fund			96.80
71				Community Events Donation			0.00
72				Community Improv. Donation			0.00
73				Fireworks Donation			0.00
74				Lake Stock Donation			0.00
75			Total Other Income				96.80
76
77			Other Expense
78				Community Events			0.00
79				Community Improv.			0.00
80				Dam, Spillway, & Boat Ramp			0.00
81				Fireworks			0.00
82				Lake Stock			0.00
83			Total Other Expense				0.00
84
85						Donated Funds
86						Community Events	5,508.16
87						Basketball Court Donation	3,292.04
88						Beach Improvement Fund	2,565.79
89						Community Improvements	9,715.37
90						Fireworks	2,676.02
91						Lake Stock	434.22
92						Total Donated Checking	24,191.60
93
94
95
96
97
98
99
100