Nov 21 Financial.xlsx

	A	B	C	D	E	F	G	H	I
1							Nov 21	YTD	Budget
2		Ordinary Income/Expense
3				Income
4					Annual Charges		100.00	91,785.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		470.00	4,760.00	4,500.00
8					Citations		0.00	0.00	300.00
9					Community Building Rental		1,050.00	6,175.00	1,000.00
10					Initiation Fee		0.00	2,800.00	1,800.00
11					Late Charge		0.00	3,135.00	4,000.00
12					Legal Fees Collected		663.00	4,554.80	2,000.00
13					Membership Fees		0.00	33,200.00	32,500.00
14					Miscellaneous Income		0.00	3,010.26	4,000.00
15					Watercraft Stickers		0.00	30,830.00	31,200.00
16				Total Income			2,283.00	184,042.56	178,700.00
17
18				Expense
19					Administrative Expenses
20						Accounting Services	284.00	3,793.00	5,000.00
21						Attorney Services	1,100.00	16,324.90	7,500.00
22						Administrative	55.57	3,234.32	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	2,153.00	10,008.00	9,800.00
28						Merchant Deposit Fees	0.00	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	69.39	2,424.65	5,000.00
33						Taxes-Property	0.00	10,144.78	10,100.00
34						Telephone and Internet Expense	224.97	2,314.67	2,200.00
35						Web Page	0.00	243.39	500.00
36					Total Administrative Expenses		3,886.93	54,800.50	56,000.00
37
38					Operating Expenses
39						Beach	0.00	2,216.75	3,000.00
40						Cleaning	0.00	700.00	800.00
41						Cleaning Supplies	114.99	609.99	600.00
42						Electric	539.58	5,178.68	6,500.00
43						Gasoline Lake Patrol	0.00	750.00	700.00
44						Lake Patrol	72.06	1,611.31	4,000.00
45						Lake Stock	0.00	0.00	750.00
46						Landscaping	0.00	0.00	750.00
47						Lawncare	5,876.86	41,571.15	40,000.00
48						Outside Services	0.00	0.00	3,000.00
49						Propane	55.64	1,007.44	2,500.00
50						Property Management	145.09	12,818.69	8,000.00
51						Trash Service	185.48	2,029.18	2,000.00
52						Water	59.80	1,274.04	1,400.00
53					Total Operating Expenses		7,049.50	69,767.23	74,000.00
54
55					Payroll Expenses
56						Beach	0.00	14,860.47	15,000.00
57						Clerk	1,725.00	19,575.00	20,700.00
58						Lake Patrol	330.00	7,725.00	9,000.00
59						Employer Taxes	300.96	4,861.88	4,000.00
60					Total Payroll Expenses		2,355.96	47,022.35	48,700.00
61						Total Expense	13,292.39	171,590.08	178,700.00
62
63	Net Income/Loss						(11,009.39)	12,452.48	0.00
64					Bank Balances
65						Security checking		107,064.33
66						Spillway checking		76,835.87
67						Reserve Funds		106,223.87
68						Total SHPOA Funds		290,124.07
69			Other Income
70				Beach Improvement Fund			0.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				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