tra jun 2012 - trailmark.org · trailmark homeowners association, inc. status of accounts month of...

8
TRAILMARK HOMEOWNERS ASSOCIATION, INC. STATUS OF ACCOUNTS MONTH OF Jun-12 BEGINNING DEPOSITS MONTHLY DISBURSEMENTS ENDING OPERA TING ACCOUNTS BALANCE INTEREST BALANCE Checking - PNC Bank $173,307.36 $31,279.66 ($24,741.91) $179,845.11 Escrow - PNC Bank $2,210.00 $0.00 $0.00 $2,210. 00 2 3 TOTAL OPERA TING $175,517.36 $31,279.66 $0.00 ($24 ,741.91) $182,055.11 RESTRICTED RESERVE ACCTS Reserve - First Bank #0625 $90,861.34 $14.44 $90 ,875.78 4 Reserve - First Bank #3013 $87,161.13 $13.85 $87,174.98 5 Reserve - First Bank #0162 $43,978.71 $3.34 ($11,034.02) $32,948.Q3 6 Reserve - First Bank #1737 $86,187.09 $13.69 $86,200.78 7 Reserve - First Bank #6659 $86,315.58 $13.72 $86,329.30 8 Reserve - First Bank #8835 $87,420.47 $13.89 $87,434.36 9 TOTAL RESERVES $481,924.32 $0.00 $72.93 ($11,034.02) $470,963.23 TOTALS $657,441.68 $31,279.66 $72.93 ($35,775.93) $653,018.34 NOTES:

Upload: phamtruc

Post on 17-Dec-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

TRAILMARK HOMEOWNERS ASSOCIATION, INC.

STATUS OF ACCOUNTS MONTH OF Jun-12 BEGINNING DEPOSITS MONTHLY DISBURSEMENTS ENDING

OPERA TING ACCOUNTS BALANCE INTEREST BALANCE Checking - PNC Bank $173,307.36 $31,279.66 ($24,741.91) $179,845.11 Escrow - PNC Bank $2,210.00 $0.00 $0.00 $2,210.00 2

3 TOTAL OPERA TING $175,517.36 $31 ,279.66 $0.00 ($24,741.91) $182,055.11

RESTRICTED RESERVE ACCTS Reserve - First Bank #0625 $90,861.34 $14.44 $90,875.78 4 Reserve - First Bank #3013 $87,161.13 $13.85 $87,174.98 5 Reserve - First Bank #0162 $43,978.71 $3.34 ($11,034.02) $32,948.Q3 6 Reserve - First Bank #1737 $86,187.09 $13.69 $86,200.78 7 Reserve - First Bank #6659 $86,315.58 $13.72 $86,329.30 8 Reserve - First Bank #8835 $87,420.47 $13.89 $87,434.36 9 TOTAL RESERVES $481,924.32 $0.00 $72.93 ($11,034.02) $470,963.23

TOTALS $657,441.68 $31,279.66 $72.93 ($35,775.93) $653,018.34

NOTES:

Balance Sheet Report Trailmark Homeowners Assn

Operating

Assets

Cash & Investments

1060 - Checking - PNC Bank 1070 - Escrow Holding - PNC Bank

Total Cash & Investments

Accounts Receivable 1400 - Accts. Rec. - Assessments

1415 - Accts. Rec. - Late Charges 1416 -Accts. Rec. - Processing Fee

1419 - Accts. Rec. - Atty Transition Fee 1420 - Accts. Rec. - Violation

1430 - Accts. Rec. - Returned Checks 1455 - Accts. Rec. - Legal

1456 - Accts. Rec. - Covenant Enforcement

1475 - Accts. Rec - Late Interest

Total Accounts Receivable

Current Assets 1600 - Allowance for Doubtful Account

1701 - Prepaid Expenses - Prey Mgt 1710 - Prepaid Taxes

1720 - Prepaid Insurance 1780 - Deposits

Total Current Assets

Total Assets

Printed by Jennifer Lowther on Wed Jul 04, 2012 03:31 pm

As of June 30, 2012

Balance Jun 30, 2012

179,845.11 2,210.00

182,055.11

5,547.68

1,763.41 850.00

150.00

1,325.41

132.44

4,802.51 46.00

895.98

15,513.43

(1 ,174.55)

195.00 931.00 725.88

50.00

727.33

198,295.87

Balance May 31,2012

173,307.36

2,210.00

175,517.36

7,678.92

2,471.42 1,120.00

225.00

1,507.01

0.00 7,266.83

46.00 1,456.20

21,771.38

(1 ,184.55)

195.00 931.00 725.88

50.00

717.33

198,006.07

Change

6,537.75

0.00

6,537.75

(2,131.24)

(708.01) (270.00)

(75.00)

(181.60)

132.44 (2,464.32)

0.00 (560.22)

(6,257.95)

10.00

0.00 0.00 0.00 0.00

10.00

289.80

Page 1 of 3

Balance Sheet Report Trailmark Homeowners Assn

Operating As of June 30, 2012

Balance Balance Jun 30, 2012 May 31,2012 Change

Liabilities Current Liabilities

2000 - Operating Accounts Payable 2,062.99 800.00 1,262.99

2175 - Deposit - Escrow Compliance 2,210.00 2,210.00 0.00

2200 - Prepaid Assessments 39,330.22 15,411 .64 23,918.58

2700 - Legal Suspense 0.00 150.00 (150.00) 2701 - Processing Suspense 380.00 1,020.00 (640.00)

2704 - Atty Transition Fee Suspense 0.00 75.00 (75.00)

Total Current Liabilities 43,983.21 19,666.64 24,316.57

Total Liabilities 43,983.21 19,666.64 24,316.57

Owners' Equity Owners' Equity

3000 - Working Capital Fund 32,094.00 31,646.00 448.00 3200 - Retained Earnings - Operating 75,591.55 75,591.55 0.00

Total Owners' Equity 107,685.55 107,237.55 448.00

Total Owners' Equity 107,685.55 107,237.55 448.00

Operating Income I (Loss) 46,627.11 71,101.88 (24,474.77)

Total Liabilities and Owner Equity 198,295.87 198,006.07 289.80

Printed by Jennifer Lowther on Wed Jul 04, 2012 03:31 pm Page 2 of 3

\ !

Income Statement Report Trailmark Homeowners Assn

Operating June 01, 2012 thru June 30, 2012

Current Period Year to Date (6 months) Annual Budget Actual Budget Variance Actual Budget Variance Budget Remaining

Income

Income

4000 - Assessments 0.00 0.00 0.00 153,600.00 153,600.00 0.00 307,200.00 153,600.00

4040 - Late Charges 285.13 0.00 285.13 5,656.81 0.00 5,656.81 0.00 (5,656.81)

4050 - Violations 0.00 0.00 0.00 700.00 0.00 700.00 0.00 (700.00)

4310 - Legal Collections-Billed to Owner 0.00 83.00 (83.00) 4,520.78 500.00 4,020.78 1,000.00 (3,520.78)

4311 - Covenant Enforcement-Billed to OWnE 0.00 0.00 0.00 196.00 0.00 196.00 0.00 (196.00)

4315 - Newsletter 0.00 83.00 (83.00) 300.00 500.00 (200.00) 1,000.00 700.00

4385 - Homeowner Reimb/Repair 35.00 0.00 35.00 35.00 0.00 35.00 0.00 (35.00)

Total Income 320.13 166.00 154.13 165,008.59 154,600.00 10,408.59 309,200.00 144,191.41

Total Operating Income 320.13 166.00 154.13 165,008.59 154,600.00 10,408.59 309,200.00 144,191.41

Expense

Administration

5000 - Master Insurance 0.00 0.00 0.00 0.00 0.00 0.00 1,760.00 1,760.00

5035 - Management Fee 2,500.00 2,500.00 0.00 15,000.00 15,000.00 0.00 30,000.00 15,000.00

5105 - Audit 0.00 0.00 0.00 300.00 2,200.00 (1 ,900.00) 2,200.00 1,900.00

5140 - Legal Collections 0.00 83.00 (83.00) 4,520.78 500.00 4,020.78 1,000.00 (3,520.78)

5141 - Covenant Enforcement 0.00 0.00 0.00 196.00 0.00 196.00 0.00 (196.00)

5142 - Legal - General 0.00 417.00 (417.00) 486.00 2,500.00 (2,014.00) 5,000.00 4,514.00

5385 - Taxes and Licenses 0.00 0.00 0.00 175.00 0.00 175.00 0.00 (175.00)

5420 - Income Taxes 0.00 0.00 0.00 0.00 275.00 (275.00) 275.00 275.00

5490 - Bad Debt 0.00 417.00 (417.00) 0.00 2,500.00 (2,500.00) 5,000.00 5,000.00

5494 - Bad Debt - Late Fees & Interest 0.00 333.00 (333.00) 0.00 2,000.00 (2,000.00) 4,000.00 4,000.00

5495 - Bad Debt - Collection Expense 0.00 67.00 (67.00) 0.00 400.00 (400.00) 800.00 800.00

5525 - Postage,Printing ,Copies 364.66 1,125.00 (760.34) 2,032.40 6,750.00 (4,717.60) 13,500.00 11,467.60

5595 - Newsletter 0.00 250.00 (250.00) 1,000.00 1,500.00 (500.00) 3,000.00 2,000.00

5700 - Community Activities 3,087.19 0.00 3,087.19 3,179.19 1,000.00 2,179.19 1,000.00 (2,179.19)

5703 - Design Review Committee 0.00 0.00 0.00 0.00 500.00 (500.00) 500.00 500.00

Printed by Jennifer Lowther on Wed Jul 04, 201203:30 pm Page 1 of 4

Income Statement Report Trailmark Homeowners Assn

Operating June 01, 2012 thru June 30, 2012

Current Period Year to Date (6 months) Annual Budget Actual Budget Variance Actual Budget Variance Budget Remaining

Expense

Administration

5704 - Social Committee 0.00 0.00 0.00 0.00 9,000.00 (9,000.00) 18,000.00 18,000.00

5705 - Finance Committee 0.00 0.00 0.00 0.00 500.00 (500.00) 500.00 500.00

5706 - Common Area Committee 0.00 0.00 0.00 0.00 1,500.00 (1 ,500.00) 1,500.00 1,500.00

5708 - Communication Committee 0.00 0.00 0.00 0.00 2,000.00 (2,000.00) 2,000.00 2,000.00

5710 - Safety Committee 0.00 0.00 0.00 0.00 500.00 (500.00) 500.00 500.00

5711 - Welcome Committee 0.00 0.00 0.00 0.00 1,000.00 (1,000.00) 1,000.00 1,000.00

5805 - Bank Charges 0.00 42.00 (42.00) 0.00 250.00 (250.00) 500.00 500.00

5900 - Miscellaneous 890.00 0.00 890.00 890.00 0.00 890.00 0.00 (890.00)

5950 - Contigency 0.00 240.00 (240.00) 0.00 1,435.00 (1,435.00) 2,869.00 2,869.00

Total Administration 6,841.85 5,474.00 1,367.85 27,779.37 51,310.00 (23,530.63) 94,904.00 67,124.63

Grounds

6200 - Landscape Contract 1,275.00 1,283.00 (8.00) 7,650.00 7,698.00 (48.00) 15,396.00 7,746.00

6210 - Snow Removal 0.00 0.00 0.00 3,803.01 6,000.00 (2,196.99) 12,000.00 8,196.99

6220 - Sprinkler Repairs 946.09 1,429.00 (482.91) 2,995.85 4,286.00 (1,290.15) 10,000.00 7,004.15

6250 - Exterminating 0.00 0.00 0.00 0.00 300.00 (300.00) 300.00 300.00

6270 - Fences 0.00 286.00 (286.00) 6,617.24 857.00 5,760.24 2,000.00 (4,617.24)

6378 - PlantsfTrees/Shrubs 336.00 286.00 50.00 1,126.49 857.00 269.49 2,000.00 873.51

6410 - Grounds Contracts Extra 0.00 1,445.00 (1,445.00) 187.26 5,778.00 (5,590.74) 13,000.00 12,812.74

6643 - Holiday Lighting 0.00 0.00 0.00 0.00 0.00 0.00 6,000.00 6,000.00

Total Grounds 2,557.09 4,729.00 (2,171.91) 22,379.85 25,776.00 (3,396.15) 60,696.00 38,316.15

Utilities

6700 - Gas & Electric 84.99 92.00 (7.01 ) 470.63 550.00 (79.37) 1,100.00 629.37

6710 - Water & Sewer 5,109.97 2,083.00 3,026.97 6,545.63 12,500.00 (5,954.37) 25,000.00 18,454.37

Printed by Jennifer Lowther on Wed Jul 04, 2012 03:30 pm Page 2 of4

Income Statement Report Trailmark Homeowners Assn

Operating June 01, 2012 thru June 30, 2012

------ Current Period ------ ---- Year to Date (6 months) Actual Budget Variance Actual Budget Variance

Expense

Utilities

6760 - Trash 10,201 .00 10,625.00 (424.00) 61,206.00 63,750.00 (2,544.00)

Total Utilities 15,395.96 12,800.00 2,595.96 68,222.26 76,800.00 (8,577.74)

Total Operating Expense 24,794.90 23,003.00 1,791.90 118,381.48 153,886.00 (35,504.52)

Total Operating Income I (Loss) (24,474.77) (22,837.00) (1,637.77) 46,627.11 714.00 45,913.11

Printed by Jennifer Lowther on Wed Jul 04, 2012 03:30 pm

Annual Budget

127,500.00

153,600.00

309,200.00

0.00

Budget Remaining

66,294.00

85,377.74

190,818.52

(46,627.11)

Page 3 of 4

Assets

Cash & Investments

1301 - Reserves-1st Bank #0625 1302 - Reserves-1 st Bank #3013 1303 - Reserves-1st Bank #0162

1304 - Reserves-1st Bank #1737

1305 - Reserves-1st Bank #6659 1306 - Reserves-1st Bank #8835

Total Cash & Investments

Total Assets

Owners' Equity

Owners' Equity

Balance Sheet Report Trailmark Homeowners Assn

Replacement As of June 30,2012

Balance Jun 30,2012

90,875.78 87,174.98 32,948.03

86,200.78

86,329.30 87,434.36

470,963.23

470,963.23

3300 - Retained Earnings - Replacemen 481,538.93

Total Owners' Equity

Total Owners' Equity

Replacement Income I (Loss)

Total Liabilities and Owner Equity

Printed by Jennifer Lowther on Wed Jul 04,201203:31 pm

481,538.93

481,538.93

(10,575.70)

470,963.23

Balance May 31,2012

90,861.34 87,161.13 43,978.71

86,187.09

86,315.58 87,420.47

481,924.32

481,924.32

481,538.93

481,538.93

481,538.93

385.39

481,924.32

Change

14.44

13.85 (11,030.68)

13.69 13.72

13.89

(10,961.09)

(10,961.09)

0.00

0.00

0.00

(10,961.09)

(10,961.09)

Page 3 of 3

Income Statement Report Trailmark Homeowners Assn

Replacement June 01, 2012 thru June 30, 2012

Current Period Year to Date (6 months) Annual Budget Actual Budget Variance Actual Budget Variance Budget Remaining

Income

Replacement Income

8700 - Taxable Interest 72.93 0.00 72.93 458.32 0.00 458.32 0.00 (458.32)

Total Replacement Income 72.93 0.00 72.93 458.32 0.00 458.32 0.00 (458.32)

Total Replacement Income 72.93 0.00 72.93 458.32 0.00 458.32 0.00 (458.32)

Expense

Replacement Expenses

9151 - Fencing Painting/Staining 11 ,034.02 0.00 11 ,034.02 11,034.02 0.00 11,034.02 0.00 (11,034.02)

Total Replacement Expenses 11,034.02 0.00 11,034.02 11,034.02 0.00 11,034.02 0.00 (11,034.02)

Total Replacement Expense 11,034.02 0.00 11,034.02 11 ,034.02 0.00 11,034.02 0.00 (11,034.02)

Total Replacement Income I (Loss) (10,961.09) 0.00 (10,961.09) (10,575.70) 0.00 (10,575.70) 0.00 10,575.70

Total Association Net Income I (Loss) (35,435.86) (22,837.00) (12,598.86) 36,051.41 714.00 35,337.41 0.00 (36,051.41 )

Printed by Jennifer Lowther on Wed Jul 04, 201203:30 pm Page 4 of 4