tra jun 2012 - trailmark.org · trailmark homeowners association, inc. status of accounts month of...
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