AQUARIUS CONDOMINIUM ASSOCIATION, INC.

AQUARIUS CONDOMINIUM ASSOCIATION, INC.

Period Ending December 31, 2015 FINANCIAL REPORTING PACKAGE

Prepared by: Atlantic | Pacific Management Accounting Department

Account

Description

10105 10106 10108 10109 10116 10117 10203 10204 10205 10206 10207 11000 11001 11005 11007 11008 11011 11012 11013 11500 11501 14010 14045 15276 15277 17350 19015

Cash - Oper./City Nat'l Bank Cash - Oper/BB&T Cash - Oper/Banco Popular Cash - Banco Popular MM Cash - City National S/A 2013 Cash - BB&T S/A 2015 Due (to) from Operating Due from Operating- Trump Due from Capital Improvement Due to/from Special Assessment Due to SA 2014 Assessments Receivable A/R Exchange Accts.Rec. - Spec/Assmnt 2013 Accts.Rec./Spec/Assmnt 2015 S/A to be billed Accts. Rec. Late Fees Accts. Rec. Attorney Fees Accts. Rec. Other Allowance for Doubtful Account Allownce for Dbtful Account SA Prepaid Insurance Prepaid Expenses Furniture & Fixtures Machinery & Equipment Accum Depreciation Utility Deposits

TOTAL ASSETS

CURRENT LIABILITIES:

20000 20001 20002 20005 20100 22000 22500 23000 23050

Accounts Payable A/P Exchange Ap Exchange SA A/P- insurance Assessments Rec'd in Advance Accrued Expenses Deferred Revenue SA Security Deposits Liability Refundable Key Deposits

Aquarius Condominium Assoc.

Balance Sheet As of 12/31/15

Operating

Reserves

ASSETS

Other

Page: 1

Totals

243,410.45 6,821.39 2,129.36

133,115.56

(37,511.57) 45,468.37

(287,307.09) 3,020.33

132,519.04 (447.69)

1,225.00 3,080.00

245.30 (20,086.91)

195,664.79

2,748.01

1,356,978.44

44,685.85

(38,620.78)

10,041.00

_______________ _______________

1,797,178.85

.00

=============== ===============

122,184.96 576,379.64 286,859.39

30,235.96 244,039.57 537,708.65

(72,061.68)

_______________ 1,725,346.49

===============

243,410.45 6,821.39 2,129.36

133,115.56 122,184.96 576,379.64 286,859.39 (37,511.57)

45,468.37 (287,307.09)

3,020.33 132,519.04

(447.69) 30,235.96 244,039.57 537,708.65

1,225.00 3,080.00

245.30 (20,086.91) (72,061.68) 195,664.79

2,748.01 1,356,978.44

44,685.85 (38,620.78)

10,041.00 _______________

3,522,525.34 ===============

LIABILITIES & FUND BALANCES

76,456.72 (11,475.47)

208,504.55 68,287.76

131,377.55

44,250.00 10,125.00

514.39 47,949.56

76,456.72 (11,475.47)

514.39 208,504.55

68,287.76 131,377.55

47,949.56 44,250.00 10,125.00

Account

Description

Subtotal Current Liab.

2015 Special Assessment

31000 31001 31002 31003 31004 31005 31006 31007 31008 31015

SA 2015 Billed SA 2015- West Pool Deck SA 2015- Balconies SA 2015- Gym Roof SA 2015- Mold Remediation SA 2015- A/C Retrofit SA 2015- Garage Entry Doors SA 2015- Lobby Reconstruction SA 2015- Loan Expense SA 2015 Spent-Valet Area Reco

Subtotal 2015 S/A

2013 Special Assessment

31020 31021 31022 31023 31024 31025 31026 31027 31028 31029 31030 31031 31032 31033 31034 31035 31036 31037 31038 31039 31040 31041 31042 31043

SA 2013 Billed SA 2013- Interest Income Sa 2013- Star Painting/Wtr stt SA 2013 CR- Balconies repair SA 2013 CR- Valet/ Fountain ar SA 2013 CR- Misc proj exp SA 2013 CR- West pool lights SA 2013 CR- W/ Pool Architect SA 2013 CR- W/ Pool Awning SA 2013 CR- W/ Pool Pavers SA 2013 CR-W/ Pool Restoration SA 2013 CR- W/ Pool CR SA 2013 CR- Engineering Fees SA 2013- Bank Charges SA 2013 BLD- Main Lobby Reno SA 2013 BLD- Gym Renovation SA 2013 BLD Replc AC cmmn area SA 2013 BLD Lobby Renovation SA 2013 BLD Cmmn Area Cap Imp SA 2013 BLD Common Area Upgrde SA 2013 Surety Bond dues SA 2013 Landscaping SA 2013- E/ Pool & Deck SA2013 Office mgmt Legal

Aquarius Condominium Assoc.

Balance Sheet As of 12/31/15

Operating

Reserves

Other

_______________ 527,526.11

_______________

_______________ .00

_______________

_______________ 48,463.95

_______________

Page: 2

Totals _______________

575,990.06 _______________

_______________ .00

_______________

_______________ .00

_______________

3,794,743.50 (303,488.93)

(17,023.55) (18,486.74) (21,878.30) (37,510.60) (17,743.76) (265,573.19)

(3,453.54) (2,423,471.52) _______________

686,113.37 _______________

3,794,743.50 (303,488.93)

(17,023.55) (18,486.74) (21,878.30) (37,510.60) (17,743.76) (265,573.19)

(3,453.54) (2,423,471.52) _______________

686,113.37 _______________

1,746,188.78 1,014.10

81,963.11 (52,009.01) (14,684.74) (15,587.18) (21,178.44)

(8,485.32) (7,106.00) (49,000.00) (95,650.00) (315,472.99) (13,225.00)

(8.01) (15,529.00) (39,297.77)

(3,368.60) (10,395.00)

(500.00) (34,756.97) (111,650.05) (18,319.99)

(9,990.50) (2,182.25)

1,746,188.78 1,014.10

81,963.11 (52,009.01) (14,684.74) (15,587.18) (21,178.44)

(8,485.32) (7,106.00) (49,000.00) (95,650.00) (315,472.99) (13,225.00)

(8.01) (15,529.00) (39,297.77)

(3,368.60) (10,395.00)

(500.00) (34,756.97) (111,650.05) (18,319.99)

(9,990.50) (2,182.25)

Account

Description

Subtotal 2013 S/A

FUND BALANCES:

39001 39005 39006

Prior Period Adjustments Oper.Fund Balance Fund Balance: Land/ Facilities

Excess Revenue Over Expenses

Subtotal Fund Balances

TOTAL LIABS & FUND BALANCES

Aquarius Condominium Assoc.

Balance Sheet As of 12/31/15

Operating

Reserves

Other

_______________ .00

_______________

_______________ .00

_______________

_______________ 990,769.17

_______________

Page: 3

Totals _______________

990,769.17 _______________

1,480.76 (61,934.12) 1,358,565.00

1,480.76 (61,934.12) 1,358,565.00

(28,458.90) _______________

1,269,652.74 _______________

.00 _______________

.00 _______________

.00 _______________

.00 _______________

(28,458.90) _______________

1,269,652.74 _______________

1,797,178.85

.00

1,725,346.49

=============== =============== ===============

3,522,525.34 ===============

Account

Description

Revenue 40000 Owner Assessment Fees

40001 Special Assessment 2013 40003 Special Assessment 2015 40015 Rental Income Tenant 40016 Work Orders 42150 Parking Space Rental 43000 Screening Fees 43200 MoveIn Administrative Fee 43600 Legal & Collection Fees 44000 Late Charge Fees 44100 NSF Fee Income 44500 Keys, Locks, Lock-Outs 44975 Laundry Room Income 45000 Misc. Income 46000 Interest Income 48010 Security Registration

Total Revenue

Actual

Month to Date

Budget

Variance

Aquarius Condominium Association Statement of Revenue and Expenses For the Twelve Months Ended December 31, 2015

Actual

Year to Date

Budget

Variance

Annual Budget

Variance Explanation

194,737.15 187,415.87

7,321.28

44,987.08

0.00 44,987.08

422,952.51

0.00 422,952.51

500.00

0.00

500.00

0.00

0.00

0.00

0.00

0.00

0.00

1,750.00

666.63

1,083.37

0.00

50.00

(50.00)

1,416.48

0.00

1,416.48

3,350.00

179.12

3,170.88

0.00

0.00

0.00

300.00

0.00

300.00

507.43

333.37

174.06

156.26

191.63

(35.37)

189.45

25.00

164.45

0.00

333.37

(333.37)

____________ ____________ ____________

670,846.36 189,194.99 481,651.37

____________ ____________ ____________

2,248,977.45

88,848.00 1,248,448.52

500.00 2,925.35

75.00 10,205.00

700.00 1,910.14 15,059.12

80.00 600.00 4,133.68 45,711.20 711.08 1,363.50 ____________ 3,670,248.04 ____________

2,248,990.00

0.00 0.00 0.00 0.00 0.00 8,000.00 600.00 0.00 2,149.00 0.00 0.00 4,000.00 2,300.00 300.00 4,000.00 ____________ 2,270,339.00 ____________

(12.55)

88,848.00 1,248,448.52

500.00 2,925.35

75.00 2,205.00

100.00 1,910.14 12,910.12

80.00 600.00 133.68 43,411.20 411.08 (2,636.50) ____________ 1,399,909.04 ____________

2,248,990.00

0.00 0.00 0.00 0.00 0.00 8,000.00 600.00 0.00 2,149.00 0.00 0.00 4,000.00 2,300.00 300.00 4,000.00 ______________ 2,270,339.00 ______________

Billing based on 269 closed units; MTD variance due to YTD correction of fees Special Assessment Billing Special Assessment Billing Income on work orders None collected this reporting period None collected this reporting period 5 Screening fees collected @ $150; and 5 @ $200 None collected this reporting period Legal and collections fees billed back to units 139 net fees charged @ $25 each None charged this reporting period Income on key FOBS Laundry/ Vending machine income Compass Group $86.26; Pet Fee $50; storage fee $20 Earnings on operating funds None collected this reporting period

Prepared By: Atlantic and Pacific Management Accounting Department

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download