Aug 21 Financial.xlsx

	A	B	C	D	E	F	G	H	I
1							Aug 21	YTD	Budget
2		Ordinary Income/Expense
3				Income
4					Annual Charges		500.00	89,760.00	93,000.00
5					Beach Concessions		1,045.00	2,035.50	2,300.00
6					Beach Gate Money		309.00	1,442.00	2,100.00
7					Building Permit		1,090.00	3,385.00	4,500.00
8					Citations		0.00	0.00	300.00
9					Community Building Rental		200.00	4,025.00	1,000.00
10					Initiation Fee		400.00	2,500.00	1,800.00
11					Late Charge		75.00	2,440.00	4,000.00
12					Legal Fees Collected		0.00	1,829.00	2,000.00
13					Membership Fees		350.00	32,850.00	32,500.00
14					Miscellaneous Income		15.00	3,010.26	4,000.00
15					Watercraft Stickers		150.00	30,265.00	31,200.00
16				Total Income			4,134.00	173,541.76	178,700.00
17
18				Expense
19					Administrative Expenses
20						Accounting Services	494.00	2,050.00	5,000.00
21						Attorney Services	5,712.50	12,114.50	7,500.00
22						Administrative	277.30	2,435.00	3,500.00
23						Bank Service Charge	0.00	198.15	350.00
24						Cell Phone	38.29	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	2,261.00	8,029.00	9,800.00
28						Merchant Deposit Fees	23.04	1,407.46	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	0.00	5,000.00
33						Taxes-Property	0.00	10,144.78	10,100.00
34						Telephone and Internet Expense	224.97	1,639.76	2,200.00
35						Web Page	0.00	243.39	500.00
36					Total Administrative Expenses		9,031.10	42,905.35	56,000.00
37
38					Operating Expenses
39						Beach	0.00	2,116.75	3,000.00
40						Cleaning	100.00	500.00	800.00
41						Cleaning Supplies	151.03	495.00	600.00
42						Electric	469.28	3,718.75	6,500.00
43						Gasoline Lake Patrol	0.00	500.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,490.95	24,495.66	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.51	1,480.16	2,000.00
52						Water	322.67	859.06	1,400.00
53					Total Operating Expenses		7,715.44	49,330.03	74,000.00
54
55					Payroll Expenses
56						Beach	3,724.44	13,944.03	15,000.00
57						Clerk	1,725.00	13,800.00	20,700.00
58						Lake Patrol	2,025.00	5,580.00	9,000.00
59						Employer Taxes	758.29	3,918.35	4,000.00
60					Total Payroll Expenses		8,232.73	37,242.38	48,700.00
61						Total Expense	24,979.27	129,477.76	178,700.00
62
63	Net Income/Loss						(20,845.27)	44,064.00	0.00
64					Bank Balances
65						Security checking		134,547.47
66						Spillway checking		76,835.87
67						Reserve Funds		106,217.25
68						Total SHPOA Funds		317,600.59
69			Other Income
70				Beach Improvement Fund			2,443.99
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				0.00
76
77			Other Expense
78				Community Events			0.00
79				Community Improv.			0.00
80				Dam, Spillway, & Boat Ramp			0.00
81				Fireworks			600.00
82				Lake Stock			0.00
83			Total Other Expense				600.00
84
85						Donated Funds
86						Community Events	5,508.16
87						Basketball Court Donation	3,292.04
88						Beach Improvement Fund	2,443.99
89						Community Improvements	9,715.37
90						Fireworks	2,676.02
91						Lake Stock	434.22
92						Total Donated Checking	24,069.80
93
94
95
96
97
98
99
100