Sep 21 Financial.xlsx

	A	B	C	D	E	F	G	H	I
1							Sep 21	YTD	Budget
2		Ordinary Income/Expense
3				Income
4					Annual Charges		500.00	90,260.00	93,000.00
5					Beach Concessions		286.00	2,321.50	2,300.00
6					Beach Gate Money		29.00	1,471.00	2,100.00
7					Building Permit		0.00	3,385.00	4,500.00
8					Citations		0.00	0.00	300.00
9					Community Building Rental		300.00	4,325.00	1,000.00
10					Initiation Fee		100.00	2,600.00	1,800.00
11					Late Charge		70.00	2,510.00	4,000.00
12					Legal Fees Collected		0.00	1,829.00	2,000.00
13					Membership Fees		150.00	33,000.00	32,500.00
14					Miscellaneous Income		0.00	3,010.26	4,000.00
15					Watercraft Stickers		505.00	30,770.00	31,200.00
16				Total Income			1,940.00	175,481.76	178,700.00
17
18				Expense
19					Administrative Expenses
20						Accounting Services	981.00	3,031.00	5,000.00
21						Attorney Services	2,388.50	14,503.00	7,500.00
22						Administrative	698.46	3,133.46	3,500.00
23						Bank Service Charge	4.94	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	0.00	8,029.00	9,800.00
28						Merchant Deposit Fees	24.13	1,431.59	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	2,355.26	2,355.26	5,000.00
33						Taxes-Property	0.00	10,144.78	10,100.00
34						Telephone and Internet Expense	224.97	1,864.73	2,200.00
35						Web Page	0.00	243.39	500.00
36					Total Administrative Expenses		6,677.26	49,582.61	56,000.00
37
38					Operating Expenses
39						Beach	100.00	2,216.75	3,000.00
40						Cleaning	100.00	600.00	800.00
41						Cleaning Supplies	0.00	495.00	600.00
42						Electric	400.55	4,119.30	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	6,021.25	30,516.91	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	181.29	1,661.45	2,000.00
52						Water	262.22	1,121.28	1,400.00
53					Total Operating Expenses		7,065.31	56,645.34	74,000.00
54
55					Payroll Expenses
56						Beach	916.44	14,860.47	15,000.00
57						Clerk	2,325.00	16,125.00	20,700.00
58						Lake Patrol	1,815.00	7,395.00	9,000.00
59						Employer Taxes	459.73	4,378.08	4,000.00
60					Total Payroll Expenses		5,516.17	42,758.55	48,700.00
61						Total Expense	19,258.74	148,986.50	178,700.00
62
63	Net Income/Loss						(17,318.74)	26,495.26	0.00
64					Bank Balances
65						Security checking		119,230.01
66						Spillway checking		76,835.87
67						Reserve Funds		106,217.25
68						Total SHPOA Funds		302,283.13
69			Other Income
70				Beach Improvement Fund			25.00
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				25.00
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,468.99
89						Community Improvements	9,715.37
90						Fireworks	2,676.02
91						Lake Stock	434.22
92						Total Donated Checking	24,094.80
93
94
95
96
97
98
99
100