Properties: North Star Yacht Club Condominium Association, Inc. - 3420 Hancock Bridge Parkway North Fort Meyers, FL 33906 As of: 01/31/2021
Accounting Basis: Accrual
GL Account Map: North Star Yacht Club Condominium Association, Inc. Level of Detail: Detail View
Account Number Account Name Operating Reserve Total
ASSETS Cash
101 Operating Bank 1,511,282.77 1,511,282.77
105-2 Popular Comm Bk-Operating & ICS 10,020.47 10,020.47
106 Escrow Account 42,715.00 42,715.00
160 Reserve Account - IberiaBank M/M 281,080.48 281,080.48
175-1 Reserve Account - CIT 195.60 195.60
175-2 Popular Comm Bk- Reserve & ICS 175.71 175.71
Total Cash
111 A/R Maintenance 10,734.50 10,734.50
130 Prepaid Insurance 149,967.21 149,967.21
135 Prepaid Expenses 14,383.79 14,383.79
178 Due from Operating 181,441.25 181,441.25
TOTAL ASSETS
LIABILITIES & CAPITAL Liabilities
200 Accounts Payables 6,952.85 6,952.85
201 Accrued Expenses 65,741.36 65,741.36
210 Security Deposit 41,450.00 41,450.00
215 Prepaid Member Fees 27,413.30 27,413.30
220 Due to Reserves 181,441.25 181,441.25
239 Deferred Income 268,050.67 268,050.67
300 Deferred Reserve Revenue 460,645.63 460,645.63
375 Reserve Interest 175.54 175.54
Total Liabilities Capital
390 Fund Balance 1,151,807.52 1,151,807.52
391 Prior Year adjustment -18,481.19 -18,481.19
391-1 Reserve Interest Equity 2,746.94 2,746.94
Calculated Retained Earnings 14,052.91 0.00 14,052.91
Calculated Prior Years Retained Earnings
0.00 0.00 0.00
Total Capital
TOTAL LIABILITIES & CAPITAL
1,564,018.24 281,451.79 1,845,470.03
1,739,103.74 462,893.04 2,201,996.78
591,049.43 460,821.17 1,051,870.60
1,147,379.24 2,746.94 1,150,126.18
Properties: North Star Yacht Club Condominium Association, Inc. - 3420 Hancock Bridge Parkway North Fort Meyers, FL 33906 As of: Jan 2021
Additional Account Types: None Accounting Basis: Accrual
GL Account Map: North Star Yacht Club Condominium Association, Inc. Level of Detail: Detail View
Account Number Account Name MTD Actual MTD Budget MTD $ Var. YTD Actual YTD Budget YTD $ Var. Annual Budget
Income
411 Maintenance Assessment 134,025.33 134,027.17 -1.84 134,025.33 134,027.17 -1.84 1,608,326.00
412 Reserve Revenue 0.00 0.00 0.00 0.00 0.00 0.00 184,560.00
417 Owner Late Fees & Interest -315.88 0.00 -315.88 -315.88 0.00 -315.88 0.00
419-4 Cabana Electric Reimbursements 0.00 158.34 -158.34 0.00 158.34 -158.34 1,900.00 471 Application Fees 62.00 50.00 12.00 62.00 50.00 12.00 600.00 490 Other Income 40.00 25.00 15.00 40.00 25.00 15.00 300.00 491 Operating Interest 10.47 25.00 -14.53 10.47 25.00 -14.53 300.00 492 Reserve Interest 175.54 166.67 8.87 175.54 166.67 8.87 2,000.00
498 Prior Year Surplus / (Deficit) 0.00 67,277.42 -67,277.42 0.00 67,277.42 -67,277.42 807,329.00
Total Operating Income Expense
501 UTILITY EXPENSES
500 Electricity 5,711.36 7,000.00 1,288.64 5,711.36 7,000.00 1,288.64 84,000.00
504 Water / Sewer 8,863.69 9,458.34 594.65 8,863.69 9,458.34 594.65 113,500.00
508 Refuse/Recycling 1,300.20 1,116.67 -183.53 1,300.20 1,116.67 -183.53 13,400.00
510 Hotwire Phones - Office 227.41 648.50 421.09 227.41 648.50 421.09 7,782.00
510-1 Hotwire Phones - Fire 660.11 291.67 -368.44 660.11 291.67 -368.44 3,500.00
511 Verizon Cell Phone 0.00 83.34 83.34 0.00 83.34 83.34 1,000.00
520 Cable 15,473.64 15,775.00 301.36 15,473.64 15,775.00 301.36 189,300.00
Total UTILITY EXPENSES 601 BUILDING EXPENSES
600 Building Maintenance 0.00 3,833.34 3,833.34 0.00 3,833.34 3,833.34 46,000.00
601-3 Common A/C Service 515.07 708.34 193.27 515.07 708.34 193.27 8,500.00
603 Bldg Supplies/ Tools / Equipmt 1,171.82 708.34 -463.48 1,171.82 708.34 -463.48 8,500.00 604-5 Construction Repairs 0.00 37,916.67 37,916.67 0.00 37,916.67 37,916.67 455,000.00 133,997.46 201,729.60 -67,732.14 133,997.46 201,729.60 -67,732.14 2,605,315.00 32,236.41 34,373.52 2,137.11 32,236.41 34,373.52 2,137.11 412,482.00
Account Number Account Name MTD Actual MTD Budget MTD $ Var. YTD Actual YTD Budget YTD $ Var. Annual Budget
605-6 Janitorial Supplies 442.36 391.67 -50.69 442.36 391.67 -50.69 4,700.00
605-8 Gates & Doors 675.07 875.00 199.93 675.07 875.00 199.93 10,500.00
606 Light Bulbs, Balists, etc. 177.30 875.00 697.70 177.30 875.00 697.70 10,500.00
607 Vent Cleaning 0.00 458.34 458.34 0.00 458.34 458.34 5,500.00
608 Electrical Repairs 0.00 250.00 250.00 0.00 250.00 250.00 3,000.00
608-3 Blue Plumbing Treatment 0.00 750.00 750.00 0.00 750.00 750.00 9,000.00
608-4 Plumbing Services 0.00 625.00 625.00 0.00 625.00 625.00 7,500.00
608-5 Locksmith 0.00 16.67 16.67 0.00 16.67 16.67 200.00
610 Janitorial Contract 7,400.00 7,500.00 100.00 7,400.00 7,500.00 100.00 90,000.00
611-1 Co2 Sensors & Exhaust Garage Fans 0.00 833.34 833.34 0.00 833.34 833.34 10,000.00 612 Exterminator 429.90 333.34 -96.56 429.90 333.34 -96.56 4,000.00 619 Window Cleaning 0.00 1,166.67 1,166.67 0.00 1,166.67 1,166.67 14,000.00 630 A/C Contract 0.00 333.34 333.34 0.00 333.34 333.34 4,000.00 633 Diesel Fuel 2,009.44 125.00 -1,884.44 2,009.44 125.00 -1,884.44 1,500.00 634 Water Pumps 578.99 291.67 -287.32 578.99 291.67 -287.32 3,500.00 636-3 Fitness Equipment Maintenance 0.00 166.67 166.67 0.00 166.67 166.67 2,000.00 640 Elevator Maintenance 32,685.04 3,666.67 -29,018.37 32,685.04 3,666.67 -29,018.37 44,000.00 640-5 Contingency - Building 0.00 2,083.34 2,083.34 0.00 2,083.34 2,083.34 25,000.00 641 Elevator Permits 0.00 45.84 45.84 0.00 45.84 45.84 550.00 642-3 Fire Equipment/Inspections 79.95 0.00 -79.95 79.95 0.00 -79.95 0.00 643-2 Generator Maintenance 0.00 250.00 250.00 0.00 250.00 250.00 3,000.00 650 Emergency Systems/Fire Equip 0.00 666.67 666.67 0.00 666.67 666.67 8,000.00 650-4 Fire Pumps 0.00 250.00 250.00 0.00 250.00 250.00 3,000.00
660 Pool & Spa Maintenance Contract
875.00 1,000.00 125.00 875.00 1,000.00 125.00 12,000.00
662 Pool, Spa & Fountain Repairs
0.00 583.34 583.34 0.00 583.34 583.34 7,000.00
662-1 Pool Heat (Propane) 1,365.95 916.67 -449.28 1,365.95 916.67 -449.28 11,000.00
662-4 Heater Repairs 0.00 250.00 250.00 0.00 250.00 250.00 3,000.00
678 Building - Painting & Drywall
0.00 125.00 125.00 0.00 125.00 125.00 1,500.00
690-1 Steam Room Maintenance 0.00 458.34 458.34 0.00 458.34 458.34 5,500.00
Total BUILDING EXPENSES
Account Number Account Name MTD Actual MTD Budget MTD $ Var. YTD Actual YTD Budget YTD $ Var. Annual Budget 701 GROUNDS EXPENSES
700 Landscape - Contract 0.00 8,400.00 8,400.00 0.00 8,400.00 8,400.00 100,800.00
703 Sod & Plants 0.00 1,000.00 1,000.00 0.00 1,000.00 1,000.00 12,000.00
705-1 Ground Maintenance 0.00 100.00 100.00 0.00 100.00 100.00 1,200.00
706 Mulch 0.00 1,166.67 1,166.67 0.00 1,166.67 1,166.67 14,000.00
708 Irrigation Repair & Maintenance 0.00 333.34 333.34 0.00 333.34 333.34 4,000.00 710 Tree Maintenance 0.00 1,041.67 1,041.67 0.00 1,041.67 1,041.67 12,500.00 720-3 Tennis Courts 0.00 41.67 41.67 0.00 41.67 41.67 500.00 735 Security 0.00 15,175.00 15,175.00 0.00 15,175.00 15,175.00 182,100.00 735-1 Surveillance Cameras 0.00 150.00 150.00 0.00 150.00 150.00 1,800.00 Total GROUNDS EXPENSES 801 ADMINISTRATIVE EXPENSES 800 Management Fees 7,559.57 7,518.17 -41.40 7,559.57 7,518.17 -41.40 90,218.00 801-1 Administrative Assistant 2,647.54 3,475.00 827.46 2,647.54 3,475.00 827.46 41,700.00
801-2 Payroll - Maintenance Man 3,818.88 4,833.34 1,014.46 3,818.88 4,833.34 1,014.46 58,000.00
801-5 Health Care 0.00 416.67 416.67 0.00 416.67 416.67 5,000.00
801-6 Employer Liability 1,829.43 1,000.00 -829.43 1,829.43 1,000.00 -829.43 12,000.00
804 Postage & Fee for Stamps etc. 266.85 50.00 -216.85 266.85 50.00 -216.85 600.00 805 Office Expense 622.97 566.67 -56.30 622.97 566.67 -56.30 6,800.00 805-2 Copy Machine 219.53 216.67 -2.86 219.53 216.67 -2.86 2,600.00 812 Legal Expense 0.00 3,166.67 3,166.67 0.00 3,166.67 3,166.67 38,000.00 813 Accounting 3,125.00 750.00 -2,375.00 3,125.00 750.00 -2,375.00 9,000.00
814 Professional Fees - expert witness
0.00 3,750.00 3,750.00 0.00 3,750.00 3,750.00 45,000.00
814-1 Employee Screening 0.00 16.67 16.67 0.00 16.67 16.67 200.00
814-2 Engineering Fee 2,887.50 0.00 -2,887.50 2,887.50 0.00 -2,887.50 0.00
815 Corporate Annual Report 0.00 125.00 125.00 0.00 125.00 125.00 125.00
820 Division Fees 0.00 680.00 680.00 0.00 680.00 680.00 680.00
822 CC Interest Expense 94.43 0.00 -94.43 94.43 0.00 -94.43 0.00
825-0 Lic. Pool / Wading/ Hot
Tub 0.00 41.67 41.67 0.00 41.67 41.67 500.00
831 Insurance Finance Interest 0.00 166.67 166.67 0.00 166.67 166.67 2,000.00
Account Number Account Name MTD Actual MTD Budget MTD $ Var. YTD Actual YTD Budget YTD $ Var. Annual Budget 835 Insurance - Package 12,853.18 12,916.67 63.49 12,853.18 12,916.67 63.49 155,000.00 836 Insurance - Flood 2,796.83 2,750.00 -46.83 2,796.83 2,750.00 -46.83 33,000.00 839-1 Insurance - Appraisals/ Deduct. 0.00 166.67 166.67 0.00 166.67 166.67 2,000.00
846 Payroll Processing
Fee-Paychex 405.00 291.67 -113.33 405.00 291.67 -113.33 3,500.00 Total ADMINISTRATIVE EXPENSES 910 RESERVE EXPENSE 900 Reserve Expense 0.00 0.00 0.00 0.00 0.00 0.00 534,560.00 901 Reserve Interest 175.54 166.67 -8.87 175.54 166.67 -8.87 2,000.00
Total RESERVE EXPENSE Total Operating Expense
Total Operating Income 133,997.46 201,729.60 -67,732.14 133,997.46 201,729.60 -67,732.14 2,605,315.00
Total Operating Expense 119,944.55 173,301.02 53,356.47 119,944.55 173,301.02 53,356.47 2,605,315.00
NOI - Net Operating Income
Total Income 133,997.46 201,729.60 -67,732.14 133,997.46 201,729.60 -67,732.14 2,605,315.00 Total Expense 119,944.55 173,301.02 53,356.47 119,944.55 173,301.02 53,356.47 2,605,315.00 Net Income 39,126.71 42,898.21 3,771.50 39,126.71 42,898.21 3,771.50 505,923.00 175.54 166.67 -8.87 175.54 166.67 -8.87 536,560.00 119,944.55 173,301.02 53,356.47 119,944.55 173,301.02 53,356.47 2,605,315.00 14,052.91 28,428.58 -14,375.67 14,052.91 28,428.58 -14,375.67 0.00 14,052.91 28,428.58 -14,375.67 14,052.91 28,428.58 -14,375.67 0.00
