HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 16_08/02/2010 INCOME STATEMENT 1 �fi „��`� �,� � "� �� �i' `'F � �,7, �� ' r>
Fiscal Year to Date , j Pa9e: 2
rv_ _. 7/22/2010
Villaqe of Tequesta 9:11 am
YEAR; THROUGH SEPTEMBER YTD Amd. Bud. YTD Actual
Fund: 602 - VillaaeEmplovee Pension-Gen
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interestllnvestment Earnings 0.00 17,098.94
361.102 DividendlDistributions 0.00 13,494.92
Unrestricted Investment Earnin 0.00 30,593.86
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments 0.00 3,490.73
367.100 Unrealized gain/loss on invest 0.00 -23,004.87
Investment income 0.00 -19,514.14
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 164,500.00 118,011.04
368.002 Pension Fund Cont-Employee 91,700.00 73,207.84
Pension Contributions 256,200,00 191,218.88
General 256,200.00 202,298.60
Revenues 256,200.00 202,298.60
Expenditures
Dept: 000 General
Acct Class: 530 Operatinq ExqenditureslExpense
531.301 Legal Services 11,700.00 8,008.20
531.304 Recording Secy Service 8,600.00 6,413.48
531.309 Actuarial Services 6,376.00 6,376.00
536.310 Pension DistributionlBenefits 0.00 4,266.78
540.300 Travel & Per Diem 1,267.93 0.00
545.300 Insurance 876.07 876.07
549.300 Other Misc Chgs & Obligations 250.00 35.59
554.300 Books, Publ, Subs & Membership 800.00 600.00
554.600 Seminars & Training - Pensions 1,000.00 0.00
Operatinq ExpenditureslExpense 30,870.00 26,576.12
Acct Class: 531 Investment Expense
531.307 Investment Services 24,000.00 3,829.81
531.350 Custodial Services - Invest. 0.00 1,680.71
531.355 Investment Advisors 0.00 5,250.00
Investment Expense 24,000.00 10,760.52
Acct Class: 590 Other Financinq Sources & Uses
549.391 Bank Charges 200.00 20.00
590.600 Excess of additions over deduc 201,130.00 0.00
Other FinancinQ Sources & Uses 201,330.00 20.00
General 256,200.00 37,356.64
Dept: 165 Pension
Acct Class: 530 Operatinq Expenditures/Expense
536.300 Pension Distributions/Refunds 0.00 10,239.09
OperatinQ ExpenditureslExpense 0.00 10,239,09
Pension 0.00 10,239.09
Exoenditures 256,200.00 47,595.73
Net Effect for Fund VillaqeEmplovee Pension-Gen 0.00 154,702.87
* Skipped Unbudgeted $0 Balance Accounts
REVENUEIEXPENDITURE REPORT ` ��� � " �'�� �' �� '�°` � � �
� � > �`� ; �i. �
Fiscal Year to Date � �'������ � � ��� ��! � � 7122/2010
Village of Tequesta 9:08 am
For the Period: 101112009 to 9I30/2010 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Revenues
Dept: 000 General
Acct Ciass: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestment Eamings 0.00 0.00 17,098.94 0.00 0.00 -17,098.94 0.0
361.102 DividendlDistributions 0.00 0.00 13,494.92 0.00 0.00 -13,494.92 0.0
Unrestricted Investment Eamin 0.00 0.00 30,593.86 0.00 0.00 -30,593.86 0.0
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of investments 0.00 0.00 3,490.73 0.00 0.00 -3,490.73 0,0
367.100 Unrealized gainlloss on invest 0.00 0.00 -23,004.87 0.00 0.00 23,004.87 0.0
Investment income 0.00 0.00 -19,514.14 0.00 0.00 19,514.14 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 164,500.00 164,500.00 118,011.04 0.00 0.00 46,488.96 71.7
368.002 Pension Fund Cont-Employee 91,700.00 91,700.00 73,207.84 0.00 0.00 18,492.16 79.8
Pension Contributions 256,200.00 256,200.00 191,218.88 0.00 0.00 64,981,12 74.6
General 256,200.00 256,200.00 202,298.60 0.00 0.00 53,901.40 79.0
Revenues 256,200.00 256,200.00 202,298.60 0.00 0.00 53,901.40 79.0
Expenditures
Dept: 000 General
Acct Class: 530 Operating Expenditures/Expense
531.301 Legal Services 11,700.00 11,700.00 8,008.20 0.00 0.00 3,691.80 68.4
531.304 Recording Secy Service 8,600.00 8,600.00 6,413.48 0.00 0.00 2,186.52 74.6
531.309 Actuarial Services 5,500.00 6,376.00 6,376.00 0.00 0.00 0.00 100.0
536.310 Pension Distribution/Benefits 0.00 0.00 4,266.78 0.00 0.00 �,266.78 0.0
540.300 Travel & Per Diem 2,200.00 1,267.93 0.00 0.00 0.00 1,267.93 0.0
545.3001nsurance 820.00 876.07 876.07 0.00 0.00 0.00 100.0
549.300 Other Misc Chgs & Obligations 250.00 250.00 35,59 0.00 0.00 214.41 14.2
554.300 Books, Publ, Subs & Membership 800.00 800.00 600.00 0.00 0.00 200.00 75.0
554.600 Seminars & Training - Pensions 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0
Operating ExpenditureslExpense 30,870.00 30,870.00 26,576.12 0.00 0.00 4,293.88 86.1
Acct Class: 531 Investment Expense
531.307 Investment Services 19,000.00 24,000.00 3,829.81 0.00 0.00 20,170.19 16.0
531.350 Custodial Services - Invest. 0.00 0.00 1,680.71 0.00 0.00 -1,680.71 0.0
531.355 Investment Advisors 0.00 0.00 5,250.00 0.00 0.00 -5,250.00 0.0
Investment Expense 19,000.00 24,000.00 10,760.52 0.00 0.00 13,239.48 44.8
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges 200.00 200.00 20.00 0.00 0.00 180.00 10.0
590,600 Excess of additions over deduc 206,130.00 201,130.00 0.00 0.00 0.00 201,130.00 0.0
Other Financing Sources 8 Uses 206,330.00 201,330.00 20.00 0.00 0.00 201,310.00 0.0
General 256,200.00 256,200.00 37,356.64 0.00 0.00 218,843.36 14.6
Dept: 165 Pension
Acct Class: 530 Operating Expenditures/Expense
536.300 Pension Distributions/Refunds 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Operating Expenditures/Expense 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Pension 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Expenditures 256,200.00 256,200.00 47,595.73 0.00 0.00 208,604.27 18.6
Net Effect for VillageEmployee Pension-Gen 0.00 0.00 154,702.87 0.00 0.00 -154,702.87 0.0
Change in Fund Balance: 154,702.87
REVENUEIEXPENDITURE REPORT ��� ��, i 4 �'� , �� 1��'� ��� /'� � �� ��� '°�
Fiscal Year to Date l _ � � �d� � � � �
� r - ,
�_� .,�_�-�.e,.��..m�� �._. .Page:6
Village of Tequesta ` 7I22I2010
For the Period: 101112009 to 9130I2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Eamin
361.100 InteresUlnvestment Earnings
1013112009 GJ Oct 09 - Interest from Salem Trust 1,756.62 $1,756.62
10/31/2009 GJ Oct 09 Rvs Sep 09 Accrued Income Salem Trust -5,189.02
10/31/2009 GJ Oct 09 Rvs Sep 09 Accrued Income Salem Trust 5,125.16
10131/2009 RE Rvs#237916 - Rvs Sep 09 Accrued Income Salem Trust 5,189.02
10131/2009 RE Rvs#237916 - Rvs Sep 09 Accrued Income Salem Trust -5,125.16
10131I2009 GJ Oct 09 Rvs Sep 09 Acc Income Salem Trust -5,189.02
10/3112009 GJ Oct 09 Acc Income Salem Trust 5,125.16
10I31I2009 GJ Oct 09 Rvs Sep 09 Acc Income Salem Trust -78.69
1013112009 GJ Oct 09 - Acc Income InYI Salem Trust 78.71
11/30I2009 GJ Nov 09 Interest Salem Trust 2,378.49 $2,378.49
11I30/2009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust -5,125.16 $5,125.16
1113012009 GJ Nov 09 Acc Income Salem Trust 4,475.44 $4,475.44
11/30/2009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust -78.71 $78.71
11I30/2009 GJ Nov 09 Acc Income InPI fund - Salem Trust 172.35 $172.35
11130/2009 GJ Nov 09 - Interest Salem Trust 0.02 $.02
11/30/2009 RE Nov 09 Rvs Oct 09 Acc Income Salem Trust 78.71 $78.71
11I30I2009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust -78.71
12I3112009 GJ Dec 09 - Interest Salem 0.02
12131/2009 GJ Dec 09 Rvs Nov 09 Acc Income Salem Trust -172.35
12/31/2009 GJ Dec 09 - Acc Income Salem Trust 218.85
12/3112009 GJ Dec 09 Interest Salem 662.46 $662.46
12/3112009 GJ Dec 09 Acc Income Salem Trust 5,481.61
12I3112009 GJ Dec 09 Rvs Nov 09 Acc Income Salem Trust -4,475.44
01/31/2010 GJ Jan 10 - Interest Salem Trust 0.10 $0,10
01131I2010 GJ Jan 10 Rvs Dec 09 Acc Income Salem Trust -218.85
01131I2010 GJ Jan 10 Acc Income Salem Trust 172.69
01/31/2010 GJ Jan 10 - Interest Salem Trust 807.41
01/3112010 GJ Jan 10 Rvs Dec 09 Acc Income Salem Trust -5,481.61
01I3112010 GJ Jan 10 Acc Income Salem Trust 5,853.53
02I28/2010 GJ FEB 10 - RVS.JAN 10 ACCRUED INCOME SALEM TRUST $5,853.53 -5,853.53
02/2812010 GJ FEB 10 ACCRUED INCOME SALEM TRUS� $6,561.72 6,561.72
02128/2010 GJ FEB 10 - INTEREST FROM SALEM TRUST $1,408.26 1,408,26
02/28I2010 GJ FEB 10 - RVS. JAN 10 ACCRUED INCOME SALEM TRUST $172.69 -172.69
02/28/2010 GJ FEB 10 - ACCRUED INCOME - INT'L FUND SALEM TRUST $150.50 150.50
02128/2010 GJ FEB 10 - INTEREST FROM SALEM TRUST 0.02
0313112010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST $6,561.72 -6,561.72
03131I2010 GJ MAR 10-ACCRUED INCOME SALEM TRUST $6,973.58 6,973.58
0313112010 GJ MAR 10 - INTEREST FROM SALEM TRUSI $1,342.12 1,342.12
03/3112010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST $150.50 -150.50
0313112010 GJ MAR 10 - ACCRUED INCOME - INT'L FUNC SALEM TRUST $355.20 355.20
03131/2010 GJ MAR 10 -INTEREST FROM SALEM TRUST 0.05
04130/2010 GJ APR 10 RVS MAR 10 ACCRUED INCOME SALEM TRUST $6,973.58 -6,973.58
04/3012010 GJ APR 10 - ACCRUED INCOME - SALEM TRl $6,585.85 6,585.85
04/30/2010 GJ APR 10 - INTEREST FROM SALEM TRUST $2,310.21 2,310.21
04I30/2010 GJ APR 10 RVS MAR 10 ACCRUED INCOME SALEM TRUST $355.20 -355.20
04/3012010 GJ APR 10 ACCRUED INCOME - INT'L FUND SALEM TRUST $825.93 825.93
05131/2010 GJ MAY 10 - INTEREST FROM SALEM TRUSl $1,499.05 1,499.05
05131/2010 GJ MAY 10 RVS.APR ACCRUED INCOME SALEM TRUST $6,585.85 -6,585.85
05/31/2010 GJ MAY 10 ACCRUED INCOME SALEM TRU: $7,570.91 7,570.91
05I3112010 GJ MAY 10 RVS.APR 10 ACCRUED INCOME SALEM TRUST $825.93 -825.93
05/31/2010 GJ MAY 10 ACCRUED INCOME - INT'L FUND SALEM TRUST $543.47 543.47
06130/2010 GJ JUNE 10 RVS. MAY 10 ACCRUED INCOME SALEM TRUST $543.47 -543.47
06I30/2010 GJ JUNE 10 - ACCRUED INCOME - INT'L FUN SALEM TRUST $238.64 238.64
06130/2010 GJ JUNE 10 - INTEREST FROM SALEM TRUS $2,142.35 2,142.35
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 7
Viilage of Tequesta 712212010
For the Periotl: 101112009 to 9/30/2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Eamin
06/30/2010 GJ JUNE 10 RVS. MAY 10 ACCRUED INCOME SALEM TRUST $7,570.91 -7,570.91
06130/2010 GJ JUNE 10 -ACCRUED INCOME SALEM TRl $7,820.83 7,820.83
InteresUlnvestment Earnings 0.00 0.00 17,098.94 0.00 0.00 -17,098.94 0.0
361.102 Dividend/Distributions
10/3112009 GJ Oct 09 - Dividends from Salem Trust 821.93 $821.93
1113012009 GJ Nov 09 - Dividends Salem Trust 1,264.30 $1,264.30
1213112009 GJ Dec 09 - Dividends Salem Trust 285.89
12/31/2009 GJ Dec 09 - Dividend Salem Trust 1,380.12 $1,380.12
01/31/2010 GJ Jan 10 - Dividends Salem Trust 94.35 $94.34
01/31/2010 GJ Jan 10 - Dividends Salem Trust 1,179.41 $1,179.41
02/2812010 GJ FEB 10 - DIVIDENDS FROM SALEM TRUS� $962.54 962.54
03/31/2010 GJ MAR 10 - DIVIDENDS FROM SALEM TRUS $1,414.94 1,414.94
03131/2010 GJ MAR 10-DIVIDENDS FROM SALEM TRUSl 78.96
0413012010 GJ APR 10 - DIVIDENDS FROM SALEM TRUS $1,191.86 1,191.86
0413012010 GJ APR 10 - DIVIDENDS FROM SALEM TRUS $410.02 410.02
05/31I2010 GJ MAY 10 - DIVIDENDS FROM SALEM TRUS $1,082.67 1,082.67
05/31/2010 GJ MAY 10 - DIVIDENDS FROM SALEM TRUS $1,307.25 1,307.25
0613012010 GJ JUNE 10 - DIVIDENDS FROM SALEM TRU; $585.06 585.06
0613012010 GJ JUNE 10 - DIVIDENDS FROM SALEM TRU1 $1,435.62 1,435.62
Dividend/Distributions 0.00 0.00 13,494.92 0.00 0.00 -13,494.92 0.0
Unrestricted Investment Earnin 0.00 0.00 30,593.86 0.00 0.00 -30,593.86 0.0
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments
10/3112009 GJ Oct 09 - Sale of Invest - Loss Salem Trust 13,292.16
1013112009 GJ Oct 09 - Sale of Invest - Loss Salem Trust -13,323.31
11I3012009 GJ Nov 09 - Sale of invest Satem Trust 191,370.25
11/3012009 GJ Nov 09 - Sale of invest Salem Trust -189,067.47
12/3112009 GJ Dec 09 - Sale of Invest - Loss Salem Trust 15,716.29
12131I2009 GJ Dec 09 - Sale of Invest - Loss Saiem Trust -15,784.56
1213112009 GJ Dec 09 - Sale of Invest Salem Trust -69,220.67
12I3112009 GJ Dec 09 - Sale of Invest Salem Trust 69,322.22
01131/2010 GJ Jan 10 - Sale of Invest Salem Trust 25,756.59
01I3112010 GJ Jan 10 - Sale of Invest Salem Trust -26,072.38
0212812010 GJ FEB 10 - SALE OF INVESTMENT - LOSS SALEM TRUST 175,737.52
02128/2010 GJ FEB 10 - SALE OF INVESTMENT - LOSS SALEM TRUST -175,847.88
0212812010 GJ FEB 10 - SALE OF INVESTMENTS SALEM TRUST 43,524.24
0212812010 GJ FEB 10 - SALE OF INVESTMENTS SALEM TRUST -43,403.65
0313112010 GJ MAR 10 - SALE ON INVESTMENT - LOSS SALEM TRUST 85,053.88
0313112010 GJ MAR 10 - SALE ON INVESTMENT - LOSS SALEM TRUST -85,069.32
0413012010 GJ APR 10 - SALE OF INVESTMENT - GAIN SALEM TRUST 103,070.50
04130/2010 GJ APR 10 - SALE OF INVESTMENT - GAIN SALEM TRUST -103,057.95
05/31/2010 GJ MAY 10 - SALE OF INVEST - GAIN SALEM TRUST $2,852.83 421,003.32
05I3112010 GJ MAY 10 - SALE OF INVEST - GAIN SALEM TRUST $2,852.83 -418,150.49
05/31I2010 GJ MAY 10 - SALE OF INVEST - LOSS SALEM TRUST $1,457.45 13,277.24
05I31I2010 GJ MAY 10 - SALE OF INVEST - LOSS SALEM TRUST $1,457.45 -14,734.69
06/30/2010 GJ JUNE 10 -SALE OF INVESTMENT- SALEM $0.48 20,042.15
06130/2010 GJ JUNE 10 -SALE OF INVESTMENT- SALEM $0.48 -20,041.67
06/30/2010 GJ JUNE10 - SALE OF INVESTMENT -SALEM $98.41 256,504,45
0613012010 GJ JUNE10 - SALE OF INVESTMENT -SALEM $98.41 -256,406.04
GainlLoss-Sale of Investments 0.00 0.00 3,490.73 0.00 0.00 -3,490.73 0.0
367.100 Unrealized gainlloss on invest
1013112009 GJ Oct 09 - Unrealized loss Salem Trust -14,210.50
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 8
Village of Tequesta 7/22I2010
For the Period: 101112009 to 9130/2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Revenues
Dept: 000 General
Acct Class: 367 Investment income
10/3112009 GJ Oct 09 - Unrealized loss Salem Trust -3,542.07
10I31I2009 GJ Oct 09 Unrealized loss Salem Trust -3,542.07
10131/2009 RE Rvs#237957 - Oct 09 - Unrealized loss Salem Trust 3,542.07
1113012009 GJ Nov 09 Unrealized gain Salem Trust 36,576.68
1113012009 GJ Nov 09 Unrealized gain InYI Fund - Salem Trust 5,233.08 $5,233.08
1213112009 GJ Dec 09 - Unrealized Gain Salem Trust 2,546.11
12/3112009 GJ Dec 09 Unrealized Gain Salem Trust 4,909.69 $4,909.69
01131I2010 GJ Jan 10 - Unrealized loss Salem Trust -5,186.22 ($5,186.22)
01I31I2010 GJ Jan 10 - Unrealized loss Salem Trust -23,976.87
02/28/2010 GJ FEB 10 - SALE OF INVESTMENT SALEM T 1,239,106.35
02/28/2010 GJ FEB 10 - SALE OF INVESTMENT SALEM T -1,212,142.60
02/2812010 GJ FEB 10 - UNREALIZED LOSS SALEM TRUST $112.84 -128,153.75
02/28/2010 GJ FEB 10 - UNREALIZED LOSS SALEM TRUST $112.84 128,040.91
03/3112010 GJ MAR 10 - SALE OF INVESTMENT-SALEM UNREALIZED GAIN $38,158.98 1,298,279.30
0313112010 GJ MAR 10 - SALE OF INVESTMENT- SALEM UNREALIZED GAIN $38,158.98 -1,260,120.32
03/3112010 GJ MAR 10 - UNREALIZED GAIN SALEM TRUST $7,234.20 -129,028.95
0313112010 GJ MAR 10 - UNREALIZED GAIN SALEM TRUST $7,234.20 136,263.15
04/30/2010 GJ APR 10 - SALE OF INVESTMENT - UNREA GAIN - SALEM TRUST 1,338,885.46
04/30/2010 GJ APR 10 - SALE OF INVESTMENT - UNREA GAIN - SALEM TRUST -1,325,475.37
0413012010 GJ APR 10 - UNREALIZED LOSS SALEM TRU $1,568.72 -134,847.82
04130/2010 GJ APR 10 - UNREALIZED LOSS SALEM TRU $1,568.72 136,416.54
04/30/2010 RE JE #248099 - UNREAL LOSS SALEM TRU� $1,568.72 134,847.82
04/30/2010 RE JE #248099 - UNREAL LOSS SALEM TRU: $1,568.72 -136,416.54
04I30/2010 GJ APR 10 - UNREALIZED LOSS SALEM TRU $1,568.72 -136,416.54
04/30/2010 GJ APR 10 - UNREALIZED LOSS SALEM TRU $1,568.72 134,847.82
0513112010 GJ MAY 10 - UNREALIZED LOSS SALEM TRUST $56,919.19 -56,919.19
05I31I2010 GJ MAY 10 - UNREALIZED LOSS INT'L FUND - SALEM TRUST $15,749.12 -15,749.12
06130/2010 GJ JUNE 10 - UNREALIZED LOSS INT'L FUNC SALEM TRUST $3,171.83 -3,171.83
0613012010 GJ JUNE 10 - UNREALIZED LOSS - SALEM TF $33,600.09 -33,600.09
Unrealized gain/loss on invest 0.00 0.00 -23,004.87 0.00 0.00 23,004.87 0.0
Investment income 0.00 0.00 -19,514.14 0.00 0.00 19,514.14 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Emp�oyer
10/15/2009 GJ VOT PENSION DEPOSIT 10/15/09 4,161.39
10/29/2009 GJ VOT PENSION DEPOSIT 10/29/09 5,904.60
11/12/2009 GJ VOT PENSION DEPOSIT 11I12109 5,906.66
1112512009 GJ VOT PENSION DEPOSIT PID 11125/09 5,904.11
12110I2009 GJ VOT PENSION DEPOSIT 12/10/09 5,907.20
12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/231( 5,906.42
0110712010 GJ VOT PENSION DEPOSIT 01/07/10 5,874.12
0112112010 GJ VOT PENSION DEPOSIT-PD 01121110 5,576.08
02/04I2010 GJ VOT PENSION DEPOSIT PAYDATE 02/041' 5,575.39
0211812010 GJ VOT PENSION DEPOSIT P/D 02118/10 5,582.29
03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04110 5,582.09
0311812010 GJ VOT PENSION DEPOSIT PID 03/18110 5,694.72
0410112010 GJ VOT PENSION DEPOSIT P/D 04/1I10 5,665.07
0411512010 GJ VOT PENSION DEPOSIT 04/15/10 5,666.62
04/2912010 GJ VOT PENSION DEPOSIT 04I15I10 5,604.35
0511312010 GJ VOT PENSION DEPOSIT 05113/10 5,576.96
05/27I2010 GJ VOT PENSION DEPOSIT P/D 05/27/10 5,582.98
06I10I2010 GJ VOT PENSION DEPOSIT-P/D O6/10I10 5,582.97
0612412010 GJ VOT PENSION DEPOSIT 06124110 5,582.97
07/08/2010 GJ VOT PENSION CONTRIBUTION 07/08/10 5,582.96
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 9
Viilage of Tequesta 712212010
For the Period: 1011I2009 to 913012010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
0712212010 GJ VOT PENSION DEPOSIT 07/22I10 5,591.09
Pension Fund Cont-Employer 164,500.00 164,500,00 118,011.04 0.00 0.00 46,488.96 71.7
368.002 Pension Fund Cont-Employee
10/15/2009 GJ VOT PENSION DEPOSIT 10115/09 2,581.51
1012912009 GJ VOT PENSION DEPOSIT 10129/09 3,662.91
1111212009 GJ VOT PENSION DEPOSIT 11112I09 3,664.18
11I2512009 GJ VOT PENSION DEPOSIT PID 11I25/09 3,662.60
12I1012009 GJ VOT PENSION DEPOSIT 12110I09 3,664.52
12123/2009 GJ VOT PENSION DEPOSIT PAYDATE 1212311 3,664.03
01I07/2010 GJ VOT PENSION DEPOSIT 01/07110 3,644.00
0112112010 GJ VOT PENSION DEPOSIT-PD 01I21110 3,459.10
0210412010 GJ VOT PENSION DEPOSIT PAYDATE 02/041' 3,458.68
02118/2010 GJ VOT PENSION DEPOSIT PID 02/18I10 3,462.96
03/04/2010 GJ VOT PENSION DEPOSIT PID 03104I10 3,462.83
03I1812010 GJ VOT PENSION DEPOSIT PID 03118/10 3,532.71
04101/2010 GJ VOT PENSION DEPOSIT P/D 04I1I10 3,514.31
04115/2010 GJ VOT PENSION DEPOSIT 04115/10 3,515.27
04129/2010 GJ VOT PENSION DEPOSIT 04115/10 3,476.64
05/1312010 GJ VOT PENSION DEPOSIT 05I13110 3,459.66
05/27I2010 GJ VOT PENSION DEPOSIT PID 05127110 3,463.38
06/10/2010 GJ VOT PENSION DEPOSIT-PID 06I10110 3,463.38
06/2412010 GJ VOT PENSION DEPOSIT 06/24110 3,463.38
07/08/2010 GJ VOT PENSION CONTRIBUTION 07108I10 3,463.37
07/22/2010 GJ VOT PENSION DEPOSIT 07122110 3,468.42
Pension Fund Cont-Employee 91,700.00 91,700.00 73,207.84 0.00 0.00 18,492.16 79.8
Pension Contributions 256,200.00 256,200.00 191,218.88 0.00 0.00 64,981.12 74.6
General 256,200.00 256,200.00 202,298.60 0.00 0.00 53,901.40 79.0
Revenues 256,200.00 256,200.00 202,298.60 0.00 0.00 53,901.40 79.0
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services
11/02/2009 FA CK#1226 Perry & Jensen - Legal services fy10. Inv#63369 115.75 $115.75
1110212009 GJ CK#1226 Perry and Jensen - Legal services fy10 Inv#63369 115.75 $115.75
11/0212009 RE Rvs#234634 - CK#1226 Perry & Jensen Legal services fy10. Inv#63369 -115.75 $115.75
12/0712009 RE Rvs#237361 - CK#1232 Perry 8 Jensen Legal Services - Inv#63414 -2,770.05 $2,770.05
12I0712009 GJ CK#1232 Perry & Jensen Legal Services - Inv�#63414 2,770.05 $2,770.05
1211512009 GJ CK#1234 - Perry & Jensen Legal Services Inv#63413 1,659.05 $1,659.05
01I2012010 GJ Record Perry & Jensen legal servises Inv.#63465 -$257.75 257.75
01/2612010 GJ Record Perry & Jensen Legal Services for period ended 1,030.92 1115110
02/24I2010 GJ Ck #1246 Perry & Jensen Legal services Inv #63566 -$2,679.30 1,648.38
03119/2010 GJ Perry & Jensen - Legal services for the period ended 3/15/10 470.41 inv#63618 -$470.41
04119/2010 GJ Rec. Perry & Jensen legal services for period ended 1,129.65 4115110 Inv#63657 $1,129.65
0512612010 GJ Perry & Jensen - Legal services for period ending 5115/10 Inv#63731 1,696.29 $1,696,29
Legal Services 11,700.00 11,700.00 8,008.20 0.00 0.00 3,691.80 68.4
531.304 Recording Secy Service
1012912009 GJ CK#1227 - Business Services Conn Inv#9-133 Office work for w/e 267.60 10116 and 10/23/09
11/1212009 GJ CK#1228 - Business Seroices Conn Inv#9-137 O�ce work forwle 267.60 10/30/09 and 11/6109
11/2512009 GJ CK#1229 - Business Services Con Inv#9-144 Office work forwle 267.60 11/13 and 11120/09
12I0712009 GJ CK#1233 - Business Services Conn Inv#9-142 Attend qtrly meeting on 356.80 11/2109 & prepare minutes
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 10
Village of Tequesta 7122/2010
For the Period: 101112009 to 9130/2010 9:08 am
Original Bud, Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
12I10/2009 GJ CK#1231 - Business Senrices Conn Inv#9-150 - Office work for 267.60 wle 11127 and 12/04/09
12I23I2009 GJ CK#1235 - Business Services Conn Inv#9-153 Office work for wle 267.60 12111 and 12118/09
0110812010 GJ CK#1236 - Business Services Conn Inv#9-159 Office work for wle 267.60 12125109 and 111110
0112012010 GJ Record Business Services Connection Inv.#10-3 -$267,60 Office work forweek 267.60 ended 1/8I10 and 1/15110
02104/2010 GJ CK#1242 - Business Services Conn Inv#10-7 Office work for w!e 267.60 1/22 and 1I29/10
02/18I2010 GJ CK#1243 - Business Services Conn Inv#10-12 Office work for wle 133.80 2I5110 and 2112I10
02/24/2010 GJ Ck #1245 Business Services Connection Inv #10-18 -$481.68 Attend qtrly meeting 481.68 held on 2/1I10 & prepare minutes
03/0412010 GJ Ck #1244 Business Services Connection Inv #10-21 -$267.60 Office work for week 267.60 ended 2/19I10 &2/26/10
03/18I2010 GJ CK #1247 - BUSINESS SERVICES CONNE INV #10-24 -$267.70 OFFICE WORK FOR 267.60 WEEK ENDED 3l5/10 & 3112/10
04/01/2010 GJ Ck #1248 - Business Services Connection Inv #10-30 $267.60 Office work for wle 267.60 3/19/10 & 3I26I10
04/1512010 GJ Business Services Connection Inv#10-34 - Office work for wle 267.60 4l2 and 419110 -$267.60
04/16I2010 GJ Business Services Connection For special meeting on 3I30110 214.08 and prepare minutes -$214.08
0412912010 GJ Rec. Business Services Connection Inv#10-49 O�ce work for wle 267.60 4/16 and 4123110 -$267.60
05111/2010 GJ Business Services Connection Attend Joint GEand PS meeting 133.80 held 5/3110 - Inv#10-57 -$133.80
0511112010 GJ Business Services Connection Office work for wle 4I30 and 267.60 517I10 - Inv#10-60 $267.60
05/2612010 GJ Business Seroices Connection - Attend qtrly GEPF meeting heold on 513110 and 410.32 prepared minutes Inv#10-67 -$410.32
0512712010 GJ Business Services Connection - Office work for wle 5114110 and 267.60 5I21I10 Inv#10-64 -$267.60
0611012010 GJ Business Seroices Connection Office work for wle 5/28 & 6/4110 267.60 Inv#10-72 -$267.60
06/24/2010 GJ Business Services Connection Office work for wle 6111 & 267.60 6I18110 Inv#10-74 -$267.60
0710812010 GJ Business Services Connection Office work for w/e 6/25 and 712I10 133.80 Inv#10-76 -$133.80
Recording Secy Seroice 8,600.00 8,600.00 6,413.48 0.00 0.00 2,186.52 74.6
531.309 Actuarial Services
01I20/2010 GJ Garbiel, Roeder, Smith & Co Inv.#110225 $6,376.00 Completion of the 1011/09 6,376.00 valuation report 8 prep for mtg 1112109
05/20/2010 BA As per motion passed on May 03, 2010 at the Regular Quarterly Meeting 876.00
Actuarial Services 5,500.00 6,376.00 6,376.00 0.00 0.00 0.00 100.0
536.310 Pension Distribution/Benefits
04/0712010 GJ APR 10 - BENEFIT PAYMENT CATHERINE DING RETIREMENT $711.13 PER MONTH 2,844.52
05/03/2010 GJ MAY 10 - BENEFIT PAYMENT - C.HARDIN( RETIREMENT $711.13 711.13
06/30/2010 GJ JUNE 10 - BENEFIT PAYMENT - C.A.HARC RETIREMENT $711.13 711.13
Pension DistributionlBenefits 0.00 0.00 4,266.78 0.00 0.00 �,266.78 0.0
Travel & Per Diem 2,200.00 1,267.93 0.00 0.00 0.00 1,267.93 0.0
545.300 Insurance
10I2612009 GJ CK#1222 - Fiduciary liability insurance policy for period 10/1/09 to 10I1110 876.07
05120/2010 BA As per motion passed on May 03, 2010 at the Regular Quarterly Meeting 56.07
Insurance 820.00 876.07 876.07 0.00 0.00 0.00 100.0
549.300 Other Misc Chgs & Obligations
12131/2009 GJ Dec 09 - ADR Issuer Fee Salem 0.83
03/2612010 GJ Fedex charges incurred by General Employees Pension for shipping 18.74 C. Harding docs to Perry & Jensen
04130/2010 �J APR 10 - ADR ISSUER AND DEPOSITORY SALEM TRUST $3.00 3.00
05/31/2010 GJ MAY 10 - ADR ISSUER AND DEPOSITORY SALEM TRUST $6.42 6.42
0613012010 GJ JUNE 10 -ADR ISSUER FEE - SALEM TRU $6.60 6.60
Other Misc Chgs 8 Obligations 250.00 250.00 35.59 0.00 0.00 214.41 14.2
554.300 Books, Publ, Subs & Membership
12/07/2009 GJ CK#1230 - FPPTA Membership fee for year 2010 600.00 $600
Books, Publ, Subs & Membership 800.00 800.00 600.00 0.00 0.00 200.00 75.0
Seminars & Training - Pensions 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0
Operating ExpenditureslExpense 30,870.00 30,870.00 26,576.12 0.00 0.00 4,293.88 86.1
Acct Class: 531 Investment Expense
531.307 Investment Services
0112012010 GJ Record Dana Investment Statement of Management fees for QTR-ended 12131109 1,839.12 $1,839.12
04/0912010 GJ Record Dana Investment Statement of Management Fees 1,990.69 for Qtr-Ended 3I31110
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 11
Viliage of Tequesta 7/2212010
For the Period: 10I112009 to 9130/2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension-Gen
Expenditures
Dept: 000 General
Acct Class: 531 Investment Expense
05/20I2010 BA As per motion passed on May 03, 2010 at the Regular Quarterly Meeting 5,000.00
InvestmentServices 19,000.00 24,000.00 3,829.81 0.00 0.00 20,170.19 16.0
531.350 Custodial Services - Invest.
01112/2010 GJ Salem Fee & Commissions for the period 1011I09 to 12I31/09 854.25 $854.25
0111212010 RE Salem Fee & Commissions for the period 1011109 to 12/31109 -854.25 $854.25
0111212010 GJ Salem fee and commissions for the period 10/1109 to 12131I09 854.25 $854.25
04/14I2010 GJ SALEM FEE & COMMISSIONS FOR THE P 111/10 TO 3131110 $826.46 826.46
Custodial Seroices - Invest. 0.00 0.00 1,680.71 0.00 0.00 -1,680.71 0.0
531.355 Investment Advisors
0112012010 GJ Record Bogdahn Consulting Inv.#4824 $2,625.00 QMy fee 10101/09 to 12I31/09 2,625.00
04/16/2010 GJ Bogdahn Consulting Fee for Qtr Ending 03131/10 2,625.00 Inv#5068 -$2,625
Investment Advisors 0.00 0.00 5,250.00 0.00 0.00 -5,250.00 0.0
Investment Expense 19,000.00 24,000.00 10,760.52 0.00 0,00 13,239.48 44.8
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
12I31I2009 GJ Dec 09 - Wire fees to transfer funds to Sun American Bank 10.00 from Salem to Gen Empl Acct
0113112010 GJ Jan 10 - Wire fees to transfer funds to Sun American bank from 10.00 Salem Trust
Bank Charges 200.00 200.00 20.00 0.00 0.00 180.00 10.0
Excess of additions over deduc 206,130.00 201,130.00 0.00 0.00 0.00 201,130.00 0.0
Other Financing Sources & Uses 206,330.00 201,330.00 20.00 0.00 0.00 201,310.00 0.0
General 256,200.00 256,200.00 37,356.64 0.00 0.00 218,843.36 14.6
Dept: 165 Pension
Acct Class: 530 Operating ExpenditureslExpense
536.300 Pension Distributions/Refunds
0411612010 GJ Rec. Refund of Pension Contributions for Dittmeier, C. terminated on 4/7/10 6,299,69 $6,299.69
0511912010 GJ Refund of pension contributions N. Hunt terminated 515110 3,939.40 $3,939.40
Pension DistributionslRefunds 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Operating Expenditures/Expense 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Pension 0.00 0.00 10,239.09 0.00 0.00 -10,239.09 0.0
Expenditures 256,200.00 256,200.00 47,595.73 0.00 0.00 208,604.27 18.6
Net Effect for VillageEmployee Pension-Gen 0.00 0,00 154,702.87 0.00 0.00 -154,702.87
Change in Fund Balance: 154,702.87
INCOME STATEMENT
Fiscal Year to Date Paqe: 1
� r�� � �� , � � I �_ 712212010
, �.,
Villaqe of Tequesta ' � t � ` .-.� �.. � _ �
� ��� �� `���°�1�� \ � �_� � �';�����.� 9:38am
YEAR: THROUGH SEPTEMBER � d__ ` YTD Amd. Bud. YTD Actual
Fund: 601 - Villaqe Emplovee Pension-Fire
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestment Earnings 0.00 38,138.43
361.102 Dividend/Distributions 0.00 15,535.01
Unrestricted Investment Earnin 0.00 53,673.44
Acct Class: 367 Investment income
367.000 Gain/Loss-Sale of Investments 0.00 12,962.49
367.100 Unrealized gain/loss on invest 0.00 328.84
Investment income 0.00 13,291.33
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 216,200.00 226,889.04
368,002 Pension Fund Cont-Employee 70,600.00 59,833.62
Pension Contributions 286,800.00 286,722.66
Acct Class: 369 Miscellaneous Revenues
369.000 Other Miscellaneous Revenue 0.00 737.69
Miscellaneous Revenues 0.00 737.69
General 286,800.00 354,425.12
Revenues 286,800.00 354,425.12
Expenditures
Dept: 000 General
Acct Class: 530 Operatinq ExpenditureslExpense
531.301 Legal Services 8,000.00 7,100.92
531.304 Recording Secy Service 6,300.00 4,762.69
531.309 Actuarial Services 10,000.00 5,378.52
540.300 Travel & Per Diem 1,000.00 425.38
545.300 Insurance 2,500.00 2,365.09
549.300 Other Misc Chgs & Obligations 1,200.00 0.00
554.300 Books, Publ, Subs & Membership 1,000.00 300.00
554.600 Seminars & Training - Pensions 500.00 0.00
Operatinq Expenditures/Expense 30,500.00 20,332.60
Acct Class: 531 Investment Expense
531.307 Investment Services 26,500.00 9,668.45
531.350 Custodial Services - Invest. 0.00 1,556.30
531.355 Investment Advisors 0.00 5,431.13
Investment Expense 26,500.00 16,655.88
Acct Class: 590 Other Financinq Sources & Uses
549.391 Bank Charges 100.00 15.00
590.600 Excess of additions over deduc 229,700.00 0.00
Other Financinq Sources & Uses 229,800.00 15,00
General 286,800.00 37,003.48
Expenditures 286,800.00 37,003.48
Net Effect for Fund Villaqe Emplovee Pension-Fire 0.00 317,421.64
Grand Total Net Effect: 0.00 317,421,64
' Skipped Unbudgeted $0 Balance Accounts
REVENUEIEXPENDITURE REPORT
�- Fiscal Year to Date Page: 1
�, ( �°( : -� � � � 712212010
Village of Tequesta � �� �__. "- �4~�-���� � �- 1 ��`� �� �' �"��\�� � 9:08 am
�_..
For the Period: 101112009 to 9/3012010 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestment Earnings 0.00 0.00 38,138.43 0.00 0.00 -38,138.43 0.0
361.102 Dividend/Distributions 0.00 0.00 15,535.01 0.00 0.00 -15,535.01 0.0
Unrestricted Investment Eamin 0.00 0.00 53,673.44 0.00 0.00 -53,673.44 0.0
Acct Ciass: 367 Investment income
367.000 Gain/Loss-Sale of Investments 0.00 0.00 12,962.49 0,00 0.00 -12,962.49 0.0
367.100 Unrealized gainlloss on invest 0.00 0.00 328.84 0.00 0.00 -328.84 0.0
Investment income 0.00 0.00 13,291.33 0.00 0.00 -13,291.33 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 216,200.00 216,200.00 226,889.04 0.00 0.00 -10,689,04 104.9
368.002 Pension Fund Cont-Employee 70,600,00 70,600.00 59,833.62 0.00 0.00 10,766.38 84.8
Pension Contributions 286,800.00 286,800.00 286,722.66 0.00 0.00 77.34 100,0
Acct Class: 369 Misce�laneous Revenues
369.000 Other Miscellaneous Revenue 0.00 0.00 737.69 0.00 0.00 -737.69 0.0
Miscellaneous Revenues 0.00 0.00 737.69 0.00 0.00 -737.69 0.0
General 286,800.00 286,800,00 354,425.12 0.00 0.00 -67,625.12 123.6
Revenues 286,800.00 286,800.00 354,425.12 0.00 0.00 -67,625.12 123.6
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services 8,000.00 8,000.00 7,100.92 0.00 0.00 899.08 88.8
531.304 Recording Secy Service 6,300.00 6,300.00 4,762.69 0.00 0.00 1,537.31 75.6
531.309 Actuarial Services 10,000.00 10,000.00 5,378.52 0.00 0.00 4,621.48 53.8
540.300 Travel & Per Diem 1,000,00 1,000.00 425.38 0.00 0.00 574.62 42.5
545.3001nsurance 2,500.00 2,500.00 2,365.09 0.00 0,00 134.91 94.6
549.300 Other Misc Chgs & Obligations 1,200.00 1,200.00 0.00 0.00 0,00 1,200,00 0.0
554.300 Books, Publ, Subs & Membership 1,000.00 1,000.00 300.00 0.00 0.00 700.00 30.0
554.600 Seminars 8 Training - Pensions 500.00 500.00 0.00 0.00 0.00 500.00 0.0
Operating Expenditures/Expense 30,500.00 30,500.00 20,332.60 0.00 0.00 10,167.40 66.7
Acct Class: 531 Investment Expense
531.307 Investment Services 26,500.00 26,500.00 9,668.45 0.00 0.00 16,831.55 36.5
531.350 Custodial Services - Invest. 0.00 0.00 1,556.30 0.00 0.00 -1,556.30 0.0
531.355 Investment Advisors 0.00 0.00 5,431.13 0.00 0.00 -5,431.13 0.0
Investment Expense 26,500.00 26,500.00 16,655.88 0.00 0.00 9,844.12 62.9
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges 100.00 100.00 15.00 0.00 0.00 85.00 15.0
590.600 Excess of additions over deduc 229,700.00 229,700.00 0.00 0.00 0.00 229,700.00 0.0
Other Financing Sources & Uses 229,800.00 229,800.00 15.00 0.00 0.00 229,785.00 0.0
General 286,800.00 286,800.00 37,003.48 0.00 0.00 249,796.52 12.9
Expenditures 286,800.00 286,800.00 37,003.48 0.00 0.00 249,796.52 12.9
Net Effect for Village Employee Pension-Fire 0.00 0.00 317,421.64 0.00 0.00 -317,421.64 0.0
Change in Fund Balance: 317,421.64
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 1
Village of Tequesta ���"� � ��� � -� � 712212010
For the Period: 1011I2009 to 913012010 -� �` � �;` _- t ( ; e.� �,� ' � 4 � ; � ��" �'� �\ i �'`( --� � 9:08 am
l�
Original Bud. Amended Bu'd: YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interestlinvestment Earnings
10/31/2009 GJ Oct 09 Acc Income Salem Trust Pro Rata 11,331.22
10/31/2009 GJ Oct 09 Interest Salem Trust Pro Rata 3,660.22 $5,051.68
10/3112009 GJ Oct 09 Rvs Sep 09 Acc Income Salem Trust Pro Rata -12,141.60
1113012009 GJ Nov 09 Interest Salem Trust Pro Rata 5,124.92 $7,078.08
11I3012009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust Pro Rata -11,331.22 $15,637.90
1113012009 GJ Nov 09 Acc Income Salem Trust Pro Rata 12,926.72 $17,839.80
12/31/2009 GJ Dec 09 - Interest Salem - Pro Rata Share 3,881.26 $5,284.65
12I3112009 GJ Dec 09 Rvs Nov 09 Acc Income Salem - Pro Rata -12,926.72
1213112009 GJ Dec 09 - Acc Income Salem - Pro Rata Share 11,014.16
0113112010 GJ Jan 10 - Interest Salem Trust - Pro Rata Share 2,133.32
01/3112010 GJ Jan 10 - Rvs Dec 09 Acc Income Salem Trust - Pro Rata Share -11,014.16
0113112010 GJ Jan 10 - Acc Income Salem Trust - Pro Rata Share 12,404.38
0212812010 GJ FEB 10 - INTEREST - SALEM TRUST PRO RATA SHARE $3,069.46 2,219.91
0212812010 GJ FEB 10 - RVS JAN 10 ACCRUED INCOME SALEM TRUST - PRO RATA SHARE $14,1 -12,404.38
02/2812010 GJ FEB 10 - ACCRUED INCOME SALEM TRU; PRO RATA SHARE $21,939.38 15,867.13
03/3112010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST PRO-RATA SHARE -15,867.13
03/31I2010 GJ MAR 10 - ACCRUED INCOME SALEM TRUST PRO-RATA SHARE 14,080.64
03131/2010 GJ MAR 10 - INTEREST $6,660.56 SALEM TRUST PRO-RATA SHARE 4,826.64
04/30I2010 GJ APR 10 RVS MAR 10 ACCRUED INCOME : TRUST - PRO RATA SHARE $19,430.67 -14,080.64
04/30I2010 GJ APR 10 ACCRUED INCOME SALEM TRUS' PRO RATA SHARE $16,819.76 12,187.50
04/3012010 GJ APR 10 INTEREST SALEM TRUST PRO RATA SHARE $7,099.55 5,144.29
05/31/2010 GJ MAY 10 INTEREST SALEM TRUST - PRO f SHARE $8,492.29 6,152.84
05/31/2010 GJ MAY 10 RVS APR 10 ACCRUED INCOME : TRUST - PRO RATA SHARE $16,819.76 -12,187.50
05/31/2010 GJ MAY 10 ACCRUED INCOME SALEM TRUS PRO RATA SHARE $14,199.61 10,287.91
05/31/2010 GJ MAY 10 - ACCRUED INCOME SALEM TRU EQUITY ACCOUNT - PRO RATA SHARE 1,614.00 $2,227.68
O6/30/2010 GJ JUNE 10 - ACCRUED INCOME SALEM TRl PRO RATA SHARE $15,613,22 11,312.35
O6/30/2010 GJ JUNE 10 - INTEREST - EQ.ACCOUNT - SAI TRUST- PRO RATA SHARE $0.70 0.51
06130/2010 GJ JUNE 10 - INTEREST SALEM TRUST PRO RATA SHARE $8,037.92 5,823.77
06130/2010 GJ JUNE 10 - RVS MAY 10 ACCRUED INCOMI SALEM TRUST - PRO RATA SHARE -11,901.91
InteresUlnvestment Earnings 0.00 0.00 38,138.43 0.00 0.00 -38,138.43 0.0
361.102 DividendlDistributions
10/3112009 GJ Oct 09 Dividends Salem Trust - Pro Rata 2,252.43 $3,108.70
1113012009 GJ Nov 09 Dividends Salem Trust Pro Rata 939.68 $1,297.80
12/31I2009 GJ Dec 09 - Dividentl Salem - Pro Rata Share 3,841.85 $5,230.99
0113112010 GJ Jan 10 - Dividends Salem Trust - Pro Rata Share 1,419.00
02l2812010 GJ FEB 10 - DIVIDENDS - SALEM TRUST PRO RATA SHARE $923.54 667.93
03131/2010 GJ MAR 10 - DIVIDENDS $3,447.46 SALEM TRUST PRO-RATA SHARE 2,498.24
04/30/2010 GJ APR 10 DIVIDENDS SALEM TRUST PRO RATA SHARE $2,158.65 1,564.15
05131/2010 GJ MAY 10 DIVIDENDS SALEM TRUST - PRO SHARE $629.40 456.01
05131/2010 GJ MAY 10 DIVIDENDS - SALEM TRUST - EQI ACCOUNT - PRO RATA SHARE $458.70 332.34
06/30I2010 GJ JUNE 10 - DIVIDENDS SALEM TRUST PRO RATA SHARE $2,157.77 1,563.38
Dividend/Distributions 0.00 0.00 15,535.01 0.00 0.00 -15,535.01 0.0
Unrestricted Investment Eamin 0.00 0.00 53,673.44 0.00 0.00 -53,673.44 0.0
Acct Class: 367 Investment income
367.000 Gain/Loss-Sale of Investments
10/31I2009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata 469,114.15
1013112009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata -472,133.14
11/30/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata 309,113.34
11I30/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata -298,170.88
12131/2009 GJ Dec 09 - Loss on Sale of Invest Salem - Pro Rata Share 456,060.05
12131/2009 GJ Dec 09 - Loss on Sale of Invest Salem - Pro Rata Share -460,001.15
01I31I2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share 432,332.22
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 2
Village of Tequesta 712212010
For the Period: 10/112009 to 9/3012010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Revenues
Dept: 000 General
Acct Class: 367 Investment income
01I3112010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share -431,362.69
02I28I2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENl SALEM TRUST - PRO RATA SHARE 336,782.47
02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENl SALEM TRUST - PRO RATA SHARE -338,992.49
03131/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO-RATA SH� 516,743.76
03/31/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO-RATA SHI -506,121.78
04/3012010 GJ APR 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY PRO-RATA SH� 397,429.45 $5,059.95
04I3012010 GJ APR 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY PRO-RATA SHI -393,763.04 $5,059.95
05I3112010 GJ MAY 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY - PRO RATA Sh 1,277,940.48 $4,239.99
0513112010 GJ MAY 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY - PRO RATA SF-1,274,868.53 $4,239.99
05131I2010 GJ MAY 10 - LOSS ON SALE OF INVESTMEN' SALEM TRUST COMPANY - Eq.ACCOUNT 889,290.70 PRO RATA SHARE $10,402.01
05131/2010 GJ MAY 10 - LOSS ON SALE OF INVESTMEN' SALEM TRUST COMPANY - Eq.ACCOUNT -896,827.16 PRO RATA SHARE $10,402.01
06/30/2010 GJ JUNE 10 - GAIN ON SALE OF INVESTMEN SALEM TRUST PRO-RATA SHARE $547.! 554,837.71
06/30/2010 GJ JUNE 10 - GAIN ON SALE OF INVESTMEN SALEM TRUST PRO-RATA SHARE $547.! -554,440.98
Gain/Loss-Sale of Investments 0.00 0.00 12,962.49 0.00 0.00 -12,962.49 0.0
367.100 Unrealized gainlloss on invest
10/31/2009 GJ Oct 09 - Unrealized loss Salem Trust Pro Rata -91,401.12
1113012009 GJ Nov 09 - Unrealized Gain Salem Trust Pro Rata 87,311.07
12/31I2009 GJ Dec 09 Unrealized Gain Salem - Pro Rata Share 95,426.22
01/31/2010 GJ Jan 10 - Unrealized loss Salem Trust - Pro Rata Share -125,874.67
02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE 3,638,841.43
02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE -3,507,225.66
0313112010 GJ MAR 10 - UNREALIZED GAIN ON INVESTh SALEM TRUST COMPANY, PRO-RATA SH 3,856,128.21
0313112010 GJ MAR 10 - UNREALIZED GAIN ON INVESTh SALEM TRUST COMPANY, PRO-RATA SH-3,691,790.79
04/30/2010 GJ APR 10 - UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY PRO RATA SHE 3,993,622.23 $103,210,57
04I30/2010 GJ APR 10 - UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY PRO RATA SHf-3,918,836,45 $103,210.57
05131/2010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST COMPANY PRO RATA SH -2,266.35 $3,128.07
05/31/2010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST COMPANY PRO-RATA SHi -22,162.50 $30,589.20
05/3112010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST - EQUITY ACCOUNT -160,190.65 PRO RATA SHARE $221,098.91
06/3012010 GJ JUNE 10 - UNREALIZED LOSS ON INV. SA TRUST - PRO-RATA SHARE $4,088.66 -2,962.32
06/30/2010 GJ JUNE 10 - UNREALIZED LOSS ON INVEST SALEM TRUST PRO RATA SHARE -148,289.81
Unrealized gainlloss on invest 0.00 0.00 328.84 0.00 0.00 -328.84 0.0
Investment income 0.00 0.00 13,291.33 0.00 0.00 -13,291.33 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer
10/15/2009 GJ VOT PENSION DEPOSIT 10115/09 4,496.72
10129/2009 GJ VOT PENSION DEPOSIT 10129/09 5,791.20
1111212009 GJ VOT PENSION DEPOSIT 11/12/09 6,038.19
1112512009 GJ VOT PENSION DEPOSIT PID 11125I09 6,150.42
1 211 012 0 0 9 GJ VOT PENSION DEPOSIT 12110/09 7,676.08
12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 1212311 5,651.97
01I0712010 GJ VOT PENSION DEPOSIT 01107/10 7,178.57
01/21I2010 GJ VOT PENSION DEPOSIT-PD 01121110 5,717.31
02/0412010 GJ VOT PENSION DEPOSIT PAYDATE 021041' 11,438.43
02/04I2010 GJ VOT PENSION DEPOSIT P/D 02/04/10 38,656.28
02/1812010 GJ VOT PENSION DEPOSIT P/D 02/18I10 10,206.87
0310412010 GJ VOT PENSION DEPOSIT PID 03104110 11,232.71
0311812010 GJ VOT PENSION DEPOSIT PID 03/18110 10,175.59
0410112010 GJ VOT PENSION DEPOSIT P/D 04/1/10 10,441.47
0411512010 GJ VOT PENSION DEPOSIT 04I15110 10,687.60
04/2912010 GJ VOT PENSION DEPOSIT 04/15110 10,627.15
05I1312010 GJ VOT PENSION DEPOSIT 05113110 10,246.96
05/2712010 GJ VOT PENSION DEPOSIT PID 05127I10 10,405.56
06110I2010 GJ VOT PENSION DEPOSIT-P/D 06/10/10 11,224.16
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 3
Village of Tequesta 7122/2010
For the Period: 1011/2009 to 913012010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
O6/24I2010 GJ VOT PENSION DEPOSIT 06/24110 10,796.72
07/0812010 GJ VOT PENSION CONTRIBUTION 07108110 11,032.89
07122I2010 GJ VOT PENSION DEPOSIT 07/22I10 11,016.19
Pension Fund Cont-Employer 216,200.00 216,200.00 226,889.04 0.00 0.00 -10,689.04 104.9
368.002 Pension Fund Cont-Employee
10I1512009 GJ VOT PENSION DEPOSIT 10/15109 2,127.11
10129/2009 GJ VOT PENSION DEPOSIT 10/29/09 2,739.45
11/12/2009 GJ VOT PENSION DEPOSIT 11112/09 2,856.29
11/25/2009 GJ VOT PENSION DEPOSIT P/D 11125/09 2,909.38
1211012009 GJ VOT PENSION DEPOSIT 12I10I09 3,631.07
12123/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/23/1 2,673.59
01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 3,395.73
01/2112010 GJ VOT PENSION DEPOSIT-PD 01121110 2,704.50
02104/2010 GJ VOT PENSION DEPOSIT PAYDATE 02/041 3,016.46
0211812010 GJ VOT PENSION DEPOSIT PID 02/18110 2,691.69
03/0412010 GJ VOT PENSION DEPOSIT PID 03104110 2,962.21
03I1812010 GJ VOT PENSION DEPOSIT PID 03/18110 2,683.44
04/01I2010 GJ VOT PENSION DEPOSIT PID 0411/10 2,753.55
04/15I2010 GJ VOT PENSION DEPOSIT 04115110 2,818,46
04/29/2010 GJ VOT PENSION DEPOSIT 04/15110 2,802.52
05/1312010 GJ VOT PENS�ON DEPOSIT 05/13/10 2,702.26
05127/2010 GJ VOT PENSION DEPOSIT P/D 05127I10 2,744.08
O6/1012010 GJ VOT PENSION DEPOSIT-P/D O6/10/10 2,959.96
06I24/2010 GJ VOT PENSION DEPOSIT O6I24110 2,847.24
07/08I2010 GJ VOT PENSION CONTRIBUTION 07108110 2,909.52
0712212010 GJ VOT PENSION DEPOSIT 07/22110 2,905.11
Pension Fund Cont-Emptoyee 70,600.00 70,600.00 59,833.62 0.00 0.00 10,766.38 84.8
Pension Contributions 286,800.00 286,800.00 286,722.66 0.00 0.00 77.34 100.0
Acct Class: 369 Miscelianeous Revenues
369.000 Other Miscellaneous Revenue
02128/2010 GJ FEB 10 - RECLASSIFY DIVIDENDS AS A RETURN OF CAPITAI - SALEM TRUST CC 737.69 PRO RATA SHARE
Other Miscellaneous Rev 0.00 0.00 737.69 0.00 0.00 -737.69 0.0
Miscellaneous Revenues 0.00 0.00 737.69 0.00 0.00 -737.69 0.0
General 286,800.00 286,800.00 354,425.12 0.00 0.00 -67,625.12 123.6
Revenues 286,800.00 286,800.00 354,425.12 0.00 0.00 -67,625.12 123.6
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services
1110212009 GJ CK#1063 - Expenses for Perry & Jensen Legal service Inv#63370 346.28
12/07I2009 RE Rvs#237365 - CK#1069 - Perry 8 Jensen Legal services Inv#63413 -1,201.15 $1,659.05
12/07/2009 GJ CK#1069 - Perry & Jensen Legal services Inv�63413 1,201.15 $1,659.05
12/15/2009 GJ CK#1074 Perry & Jensen Legal Services Inv#63414 2,005.52 $2,770.05
01/20I2010 GJ Perry & Jensen - Legal Service expenses for period ended 12/15/09 Inv.#63466 194.83 $269.25
01I26I2010 GJ Record Perry & Jensen Legal service for period ended 664.57 1/15/10 -$918.42
02(2412010 GJ Ck #1087 Perry & Jensen - Legal service expenses for period ended 2/15I10 1,793.13 inv #63567 $2,478.75
03/19/2010 GJ Perry & Jensen - Legal services for period ended 3/15I10 234.43 Inv#63619 -$324.16
04/1912010 GJ Record Perry Jensen legal services for period ended 1,018.04 4/15/10 Inv#63658 $1,404.77
05/28/2010 GJ Perry & Jensen - Legal service expenses for period ended 5/15110 844.12 Inv#63732 -$1,147.37
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 4
Village of Tequesta 7122/2010
For the Period: 101112009 to 9I3012010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Expenditures
Dept: 000 General
AcctClass: 530 Operating Expenditures/Expense
Legal Services 8,000.00 8,000.00 7,100.92 0.00 0.00 899.08 88.8
531.304 Recording Secy Service
10129/2009 GJ CK#1064 Business Services Conn Inv#9-134 O�ce work for wle 194.68 10/16 and 10123/09
11/02/2009 GJ Ck#1066 Business Services Connection Attend meeting and prepare minutes for 25.88 meeting held on 1017/09 $35.68
11/12/2009 GJ CK#1067 - Business Services Conn Inv#9-136 Office work for w/e 194.68 10/30 and 11/6/09
11/25I2009 GJ CK#1068 Business Services Conn Inv#9-145 Office work for wle 193.88 11/13 and 11/20/09
12/07I2009 GJ CK#1073 - Business Services Conn Inv#9-149 Office work for w/e 193.75 11127 and 12/04/09 $267.60
12/10/2009 GJ CK#1070 - Business Services Conn Attend qtrly meeting on 11I2109 258.32 and prepare minutes $356.80
12/23I2009 GJ CK#1075 Business Services Conn Inv#9-154 Office work for w/e 193.75 12111 and 12118I09
01108/2010 GJ CK#1076 Business Services Conn Inv#9-158 Office work for w/e 193.64 12125109 and 1I1110
0112012010 GJ Rewrd Business Services Connection Inv.#10-4 -$267.60 Office work w/e 193.64 1/08/10 & 1/15/10
02I0112010 GJ Ck#1082 Business Services Connection Attend meeting and prepare minutes for 167.82 meeting on 1122I10 $231.92
02/04/2010 GJ CK#1083 - Business Services Conn Inv#10-8 Office work for wle 193.64 1/22 and 1/29/10
02/18I2010 GJ Ck#1084 - Business Services Conn Inv#10-13 - Office work for w/e 96.79 215I10 & 2I12I10
02/24/2010 GJ Ck #1085 Business Services Connection Attend meeting and prepare minutes for 400.07 meeting held on 2/1110 $553.04
03/04I2010 GJ Ck #1086 Business Services Connection Inv #10-20 -$267.60 Office work wle 193.58 2/19I10 & 2126/10
03118/2010 GJ CK #1089 BUSINESS SERVICS CONNECT INV #10-25 $267.60 OFFICE WORK W/E 193.54 315I10 & 3/12/10
04/01/2010 GJ Ck #1091 Business Services Connection Inv #10-29 $267.60 Office work w/e 193.54 3/19110 & 3/26/10
0411512010 GJ Business Services Connection Inv#10-35 - Office work for wle 193.92 412 and 4I9110 -$267.60
04122I2010 GJ Rec. Business Services Connection Attend special meeting on 4112I10 316.75 and prepare minutes $437.08
04129I2010 GJ Rec. Business Services Connection Inv#10-48 Office work for wle 193.92 4/16 and 4/23110 $267.60
05118I2010 GJ Business Services Connection Attend special meeting & prepared 98.44 minutes - 5I03/10 $401.40
05118I2010 GJ Business Services Connection Office work wle 4I30I10 196.87 and 5/7/10 -$267.60
05/27I2010 GJ Business Services Connection - Inv#10-65 Office work forwle 196.87 5/14110 and 5/21110 -$267.60
06110I2010 GJ Business Services Connection Office work for wle 5128 & 614/10 193.90 Inv#10-71 -$267.60
06/2412010 GJ Business Services Connection Office work for w/e 6111 & 6/18110 193.88 Inv#10-73 -$267.60
07/08/2010 GJ Business Services Connection Office work for w/e 6/25 and 7/2/10 96.94 Inv#10-77 -$133.80
Recording Secy Seroice 6,300.00 6,300.00 4,762.69 0.00 0.00 1,537.31 75.6
531.309 Actuarial Services
01I20/2010 GJ Gabriel, Roeder, Smith & Company Serv.rendered thru 11130/09 - Inv.110224 5,378.52 pro rata share $7,433.00
Actuarial Services 10,000.00 10,000.00 5,378.52 0.00 0.00 4,621.48 53.8
540.300 Travel 8 Per Diem
10/07I2009 GJ CK#1059 - Hotel accommodation at Radisson Resort Orlando for F. Dambra 208.50 to attend 41st Annual Pension Conf.
10/2812009 GJ CK#1065 - Frank D'Ambra reimb of travel and meal exps to attend 41st Annual 216.88 Pol. Officers & FlFighters Conf $299.06
Travel & Per Diem 1,000.00 1,000.00 425.38 0.00 0.00 574.62 42.5
545.300 Insurance
10I2612009 GJ CK#1060 Fiduciary liability insurance policy for period 1011/09 to 10/1110 2,365.09
Insurance 2,500.00 2,500.00 2,365.09 0.00 0.00 134.91 94.6
Other Misc Chgs & Obligations 1,200.00 1,200.00 0.00 0.00 0.00 1,200.00 0.0
554.300 Books, Publ, Subs & Membership
12/0712009 GJ CK#1072 - 50% each fire and police FPPTA Membership Fee for year 2010 300.00 $600.00
Books, Publ, Subs 8 Membership 1,000.00 1,000.00 300.00 0.00 0.00 700.00 30.0
Seminars & Training - Pensions 500.00 500.00 0.00 0.00 0.00 500.00 0.0
Operating Expenditures/Expense 30,500.00 30,500.00 20,332.60 0.00 0.00 10,167.40 66.7
Acct Class: 531 Investment Expense
531.307 Investment Services
01/20/2010 GJ Rockwood Capital - MGT Fee for Gtr ended 12131/09 $6,425.22 4,649.29
01I20/2010 GJ Bogdahn Consulting fee for Qtr ending 12131/09 Inv.#4825 $3,750.00 2,713.50
01/20/2010 GJ Reclassify Bogdahn Consulting Fee for Qtr-Ended 12131/09 -2,713.50 $3,750.00
04/26/2010 GJ Rec. Rockwood Capital Fees for qtr ended 3/31/10 5,019.16 $6,925.85
Investment Services 26,500.00 26,500.00 9,668.45 0.00 0.00 16,831.55 36,5
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 5
Village of Tequesta 7/2212010
For the Period: 10/112009 to 913012010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 601 - Village Employee Pension-Fire
Expenditures
Dept: 000 General
Acct Class: 531 Investment Expense
531.350 Custodial Services - Invest.
01/12I2010 GJ Salem fee and commissions for the period 1011I09 to 12/31/09 797.56 $1,102.52
04/30/2010 GJ TRUSTEE FEE &COMMISSIONS FOR THE 1/1l10 TO 3131I10 PRO RATA SHARE 758.74 $1,047.13
Custodial Services - Invest. 0.00 0.00 1,556.30 0.00 0.00 -1,556.30 0.0
531,355 Investment Advisors
01120I2010 GJ Reclassify Bogdahn Consulting Fee for Qtr-Ended 12/31/09 2,713.50 $3,750.00
0411612010 GJ Bogdahn Consulting fee for qtr ending 03131I10 2,717.63 Inv#5069 -$3,750
InvestmentAdvisors 0.00 0.00 5,431.13 0.00 0.00 -5,431.13 0.0
Investment Expense 26,500,00 26,500.00 16,655.88 0.00 0.00 9,844.12 62.9
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
10I3012009 GJ Oct 09 Wire fees to transfer fund to Sun America Bk 5.00 from Salem
12/3112009 GJ Dec 09 - Wire fees to transfer funds to Sun American Bank 5.00 Public Safety Acct.
01I31I2010 GJ Jan 10 - Wire fees to transfer funds to Sun American Bank from 5.00 Salem Trust
Bank Charges 100.00 100.00 15.00 0.00 0.00 85.00 15.0
Excess of additions over deduc 229,700.00 229,700.00 0.00 0.00 0.00 229,700.00 0.0
Other Financing Sources & Uses 229,800.00 229,800.00 15.00 0.00 0.00 229,785.00 0.0
General 286,800.00 286,800.00 37,003.48 0.00 0.00 249,796.52 12.9
Expenditures 286,800.00 286,800.00 37,003.48 0.00 0.00 249,796,52 12.9
Net Effect for Village Employee Pension-Fire 0.00 0.00 317,421.64 0.00 0.00 -317,421.64
Change in Fund Balance: 317,421.64
INCOME STATEMENT
Fiscal Year to Date Paqe: 3
-' �' } � � ;� �, � � _ � ' � 712212010
Villaae of Teauesta � t�_;�x � �." � " �,,�`° � � �� � � �� _ � � �° � `��. � �� ---�' 9:11 am
YEAR: THROUGH SEPTEMBER �� Y D Amd. Bud. YTD Actual
Fund: 603 - Villa4e Emplovee Pension-Polic
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestment Earnings 0.00 14,456.32
361.102 Dividend/Distributions 0.00 5,839.60
Unrestricted Investment Earnin 0.00 20,295.92
Acct Class: 367 Investment income
367.000 Gain/Loss-Sale of Investments 0.00 5,004.29
367.100 Unrealized gain/loss on invest 0.00 -1,556.69
Investment income 0,00 3,447.60
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 115,600.00 82,552.82
368.002 Pension Fund Cont-Employee 37,800.00 31,677.98
Pension Contributions 153,400.00 114,230.80
Acct Class: 369 Miscelianeous Revenues
369.000 Other Miscellaneous Revenue 0.00 282.31
Miscellaneous Revenues 0.00 282.31
General 153,400.00 138,256.63
Revenues 153,400.00 138,256.63
Expenditures
Dept: 000 General
Acct Class: 530 Operatinq ExqenditureslExpense
531.301 Legal Services 3,000.00 2,689.35
531.304 Recording Secy Service 2,100.00 1,802,43
531.309 Actuarial Services 4,000.00 2,054.48
540.300 Travel & Per Diem 1,000.00 290.68
545.300 Insurance 1,000.00 896,81
549.300 Other Misc Chgs & Obligations 900.00 0.00
554.300 Books, Publ, Subs & Membership 800.00 300.00
554.600 Seminars & Training - Pensions 500.00 0.00
Operatinq Expenditures/Expense 13,300.00 8,033.75
Acct Class: 531 Investment Expense
531.307 Investment Services 9,700.00 3,682.62
531.350 Custodial Services - Invest. 0.00 593.35
531.355 Investment Advisors 0.00 2,068.87
Investment Expense 9,700.00 6,344,84
Acct Class: 590 Other Financinq Sources & Uses
549.391 Bank Charges 100.00 15.00
590.600 Excess of additions over deduc 130,300.00 0.00
Other Financinq Sources & Uses 130,400.00 15.00
General 153,400.00 14,393.59
Expenditures 153,400.00 14,393.59
Net Effect for Fund Villaqe Emplovee Pension-Polic 0.00 123,863.04
Grand Total Net Effect: 0.00 595,987.55
' Skipped Unbudgeted $0 Balance Accounts
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date Page: 3
° � � `, �� � � �'`� � � 719 08 am
VillageofTequesta � r ��_C��'_�_ " ����' ��,� � � � � �-�� =� �� j '�
For the Period• 10I112009 to 9I3012010 Ori�inal Bud Amended Bud YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Village Employee Pension-Polic
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interestllnvestment Eamings 0.00 0.00 14,456.32 0.00 0.00 -14,456.32 0.0
361.102 Dividend/Distributions 0.00 0.00 5,839.60 0.00 0.00 -5,839.60 0.0
Unrestricted Investment Earnin 0.00 0.00 20,295.92 0.00 0.00 -20,295.92 0.0
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments 0.00 0.00 5,004.29 0.00 0.00 -5,004.29 0.0
367.100 Unrealized gain/loss on invest 0.00 0.00 -1,556.69 0.00 0.00 1,556.69 0.0
Investment income 0.00 0.00 3,447.60 0.00 0.00 -3,447.60 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer 115,600.00 115,600.00 82,552.82 0.00 0.00 33,047.18 71.4
368.002 Pension Fund Cont-Employee 37,800.00 37,800.00 31,677.98 0.00 0.00 6,122.02 83.8
Pension Contributions 153,400.00 153,400.00 114,230.80 0.00 0.00 39,169.20 74.5
Acct Class: 369 Miscellaneous Revenues
369.000 Other Miscellaneous Revenue 0.00 0.00 282.31 0.00 0.00 -282.31 0.0
Miscellaneous Revenues 0.00 0.00 282.31 0.00 0.00 -282.31 0.0
General 153,400.00 153,400.00 138,256.63 0.00 0.00 15,143.37 90.1
Revenues 153,400.00 153,400.00 138,256.63 0.00 0.00 15,143.37 90.1
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services 3,000.00 3,000.00 2,689.35 0.00 0.00 310.65 89.6
531.304 Recording Secy Service 2,100.00 2,100.00 1,802.43 0.00 0.00 297.57 85.8
531.309 Actuarial Services 4,000.00 4,000.00 2,054.48 0.00 0.00 1,945.52 51.4
540.300 Travel & Per Diem 1,000.00 1,000.00 290.68 0.00 0.00 709.32 29.1
545.3001nsurance 1,000.00 1,000.00 896.81 0.00 0.00 103.19 89.7
549.300 Other Misc Chgs 8 Obligations 900.00 900.00 0.00 0.00 0.00 900.00 0.0
554.300 Books, Publ, Subs 8 Membership 800.00 800.00 300.00 0.00 0.00 500.00 37.5
554.600 Seminars & Training - Pensions 500.00 500.00 0.00 0.00 0.00 500.00 0.0
Operating Expenditures/Expense 13,300.00 13,300.00 8,033.75 0.00 0.00 5,266.25 60.4
Acct Class: 531 Investment Expense
531.307 Investment Services 9,700.00 9,700.00 3,682.62 0.00 0.00 6,017.38 38.0
531.350 Custodial Services - Invest. 0.00 0.00 593.35 0.00 0.00 -593.35 0.0
531.3551nvestmentAdvisors 0.00 0.00 2,068.87 0.00 0.00 -2,068.87 0.0
Investment Expense 9,700.00 9,700.00 6,344.84 0.00 0.00 3,355.16 65.4
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges 100.00 100.00 15.00 0.00 0.00 85.00 15.0
590.600 Excess of additions over deduc 130,300.00 130,300.00 0.00 0.00 0.00 130,300.00 0.0
Other Financing Sources & Uses 130,400.00 130,400.00 15.00 0.00 0.00 130,385.00 0.0
General 153,400.00 153,400.00 14,393.59 0.00 0.00 139,006.41 9.4
Expenditures 153,400.00 153,400.00 14,393.59 0.00 0.00 139,006.41 9.4
Net Effect for Village Employee Pension-Polic 0.00 0.00 123,863.04 0.00 0.00 -123,863.04 0.0
Change in Fund Balance: 123,863.04
Grand Total Net Effect: 0.00 0.00 595,987.55 0.00 0.00 -595,987.55
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
` � ,, � Page: 12
Village of Tequesta � 7I22I2010
For the Period: 10/1/2009 to 9/30/2010 � �' - ��� .��` �,� � �� � �° � � � �� ��, �,�,� ��-� �� 9:08 am
Original Bud. Amended Bud. `4- YTD Actual URR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Vitlage Employee Pension-Polic
Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestment Eamings
1013112009 GJ Oct 09 Acc Income Salem Trust Pro Rata 4,306.68
10/31/2009 GJ Oct 09 Interest Salem Trust Pro Rata 1,391.46 $5,051.68
10/31/2009 GJ Oct 09 Rvs Sep 09 Acc income Salem Trust Pro Rata -4,600.82
11I30/2009 GJ Nov 09 Interest Salem Trust Pro Rata 1,953.16 $7,078.08
11/30/2009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust Pro Rata -4,306.68 $15,637.90
11/30/2009 GJ Nov 09 Acc Income Salem Trust Pro Rata 4,913.08 $17,839.80
12/3112009 GJ Dec 09 - Interest Salem - Pro Rata Share 1,403.39 $5,284.65
12131/2009 GJ Dec 09 Rvs Nov 09 Acc Income Salem - Pro Rata -4,913.08
1213112009 GJ Dec 09 - Acc Income Salem - Pro Rata Share 3,983.33
01I3112010 GJ Jan 10 - Acc Income Salem Trust - Pro Rata Share 4,742.95
01131/2010 GJ Jan 10 - Interest Salem Trust - Pro Rata Share 815.74
01/31/2010 GJ Jan 10 - Rvs Dec 09 Acc Income Salem Trust - Pro Rata Share -3,983.33
02128/2010 GJ FEB 10 - INTEREST - SALEM TRUST PRO RATA SHARE $3,069.46 849.55
02/28/2010 GJ FEB 10 - RVS JAN 10 ACCRUED INCOME SALEM TRUST - PRO RATA SHARE $14,1 -4,742.95
02128/2010 GJ FEB 10 - ACCRUED INCOME SALEM TRU: PRO RATA SHARE $21,939.38 6,072.25
0313112010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST PRO-RATA SHARE -6,072.25
03/31/2010 GJ MAR 10 - ACCRUED INCOME SALEM TRUST PRO-RATA SHARE 5,350.03
03/31I2010 GJ MAR 10 - INTEREST $6,660.56 SALEM TRUST PRO-RATA SHARE 1,833.92
04/30/2010 GJ APR 10 RVS MAR 10 ACCRUED INCOME ; TRUST - PRO RATA SHARE $19,430.67 -5,350.03
04130/2010 GJ APR 10 ACCRUED INCOME SALEM TRUS' PRO RATA SHARE $16,819.76 4,632.26
04/3012010 GJ APR 10 INTEREST SALEM TRUST PRO RATA SHARE $7,099.55 1,955.26
05/31/2010 GJ MAY 10 INTEREST SALEM TRUST - PRO f SHARE $8,492.29 2,339.45
05131/2010 GJ MAY 10 RVS APR 10 ACCRUED INCOME : TRUST - PRO RATA SHARE $16,819.76 -4,632.26
05/31I2010 GJ MAY 10 ACCRUED INCOME SALEM TRUS PRO RATA SHARE $14,199.61 3,911,70
05131I2010 GJ MAY 10 - ACCRUED INCOME SALEM TRU EQUITY ACCOUNT - PRO RATA SHARE 613.68 $2,227.68
06/30/2010 GJ JUNE 10 - ACCRUED INCOME SALEM TRl PRO RATA SHARE $15,613.22 4,300.87
06/30/2010 GJ JUNE 10 - INTEREST - EQ.ACCOUNT - SAI TRUST- PRO RATA SHARE $0.70 0.19
O6/30/2010 GJ JUNE 10 - INTEREST SALEM TRUST PRO RATA SHARE $8,037.92 2,214.15
06130/2010 GJ JUNE 10 - RVS MAY 10 ACCRUED INCOMI SALEM TRUST - PRO RATA SHARE -4,525.38
InteresUlnvestment Earnings 0.00 0.00 14,456.32 0.00 0.00 -14,456.32 0.0
361.102 Dividend/Distributions
10131/2009 GJ Oct 09 Dividends Salem Trust - Pro Rata 856.27 $3,108.70
11/30/2009 GJ Nov 09 Dividends Salem Trust Pro Rata 358.12 $1,297.80
12131/2009 GJ Dec 09 - Dividentl Salem - Pro Rata Share 1,389.14 $5,230.99
01/31/2010 GJ Jan 10 - Dividends Salem Trust - Pro Rata Share 542.60
0212812010 GJ FEB 10 - DIVIDENDS - SALEM TRUST PRO RATA SHARE $923.54 255.61
03131/2010 GJ MAR 10 - DIVIDENDS $3,447.46 SALEM TRUST PRO-RATA SHARE 949.22
04/30/2010 GJ APR 10 DIVIDENDS SALEM TRUST PRO RATA SHARE $2,158.65 594.50
0513112010 GJ MAY 10 DIVIDENDS SALEM TRUST - PRO SHARE $629.40 173.39
05/31I2010 GJ MAY 10 DIVIDENDS - SALEM TRUST - EQI ACCOUNT - PRO RATA SHARE $458.70 126.36
06/3012010 GJ JUNE 10 - DIVIDENDS SALEM TRUST PRO RATA SHARE $2,157.77 594.39
DividendlDistributions 0.00 0.00 5,839.60 0.00 0.00 -5,839.60 0.0
Unrestricted Investment Earnin 0.00 0.00 20,295.92 0.00 0.00 -20,295.92 0.0
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments
10I31I2009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata 178,297.04
10I31I2009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata -179,444.48
11/30/2009 GJ Nov 09 Gain on Saie of Invest Salem Trust Pro Rata 117,779.82
11I3012009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata -113,610.48
12/31/2009 GJ Dec 09 - Loss on Sale of Invest Salem - Pro Rata Share 164,936.75
12/31/2009 GJ Dec 09 - Loss on Sale of Invest Salem - Pro Rata Share -166,362.07
01/31I2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share 165,307.01
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 13
Village of Tequesta 7I2212010
For the Period: 10I112009 to 9/30I2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Village Employee Pension-Polic
Revenues
Dept: 000 General
Acct Class: 367 investment income
01131/2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share -164,936.30
02128/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENl SALEM TRUST - PRO RATA SHARE 128,884.63
02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENl SALEM TRUST - PRO RATA SHARE -129,730.39
02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE -1,342,194.18
02128/2010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR FEB 10 TO CORRECT ACCOUNT 1,342,194.18 SALEM TRUST COMPANY
03/31I2010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR MAR 10 TO CORRECT ACCOUNT 1,402,720.66 SALEM TRUST COMPANY
03/3112010 GJ MAR 10 - UNREALIZED GAIN ON INVESTh SALEM TRUST COMPANY, PRO-RATA SH-1,402,720.66
03/31/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO-RATA SHi 196,340.25
03I31I2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO-RATA SHI -192,304.36
04/30/2010 GJ APR 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY PRO-RATA SHI -149,662.56 $5,059.95
04130/2010 GJ APR 10 - UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY PRO RATA SH/-1,489,482.32 $103,210.57
04/30/2010 GJ APR 10 - GAIN ON SALE OF INVESTMENT SALEM TRUST COMPANY PRO-RATA SHl 151,056.10 $5,059.95
04/30/2010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR APR 10 TO CORRECT ACCOUNT 1,489,482.32 SALEM TRUST COMPANY
05/31I2010 GJ MAY 10 - GAIN ON SALE OF INVESTMENl SALEM TRUST COMPANY - PRO RATA SF 485,903.10 $4,239.99
05/3112010 GJ MAY 10 - GAIN ON SALE OF INVESTMENi SALEM TRUST COMPANY - PRO RATA SF -484,735.06 $4,239.99
0513112010 GJ MAY 10 - LOSS ON SALE OF INVESTMEN' SALEM TRUST COMPANY - Eq.ACCOUNT 338,129.28 PRO RATA SHARE $10,402.01
0513112010 GJ MAY 10 - LOSS ON SALE OF INVESTMEN" SALEM TRUST COMPANY - Eq.ACCOUNT -340,994.83 PRO RATA SHARE $10,402.01
06130/2010 GJ JUNE 10 - GAIN ON SALE OF INVESTMEN SALEM TRUST PRO-RATA SHARE $547.! 210,945.21
0613012010 GJ JUNE 10 - GAIN ON SALE OF INVESTMEN SALEM TRUST PRO-RATA SHARE $547.! -210,794.37
GainlLoss-Sale of Investments 0.00 0.00 5,004.29 0.00 0.00 -5,004.29 0,0
367.100 Unrealized gain/loss on invest
1013112009 GJ Oct 09 - Unrealized loss Salem Trust Pro Rata -34,738.98
11/30/2009 GJ Nov 09 - Unrealized Gain Salem Trust Pro Rata 33,267.67
12/31/2009 GJ Dec 09 Unrealized Gain Salem - Pro Rata Share 34,511.44
0113112010 GJ Jan 10 - Unrealized loss Salem Trust - Pro Rata Share -48,129.57
02128/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE 1,392,562.75
02128/2010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR FEB 10 TO CORRECT ACCOUNT -1,342,194.18 SALEM TRUST COMPANY
03/31/2010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR MAR 10 TO CORRECT ACCOUNT -1,402,720.66 SALEM TRUST COMPANY
03/31/2010 GJ MAR 10 - UNREALIZED GAIN ON INVESTA SALEM TRUST COMPANY, PRO-RATA SH 1,465,161.76
04/30/2010 GJ APR 10 - UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY PRO RATA SH/ 1,517,907.11 $103,210.57
0413012010 GJ TO RECLASSIFY UNREALIZED GAIN ON II FOR APR 10 TO CORRECT ACCOUNT -1,489,482.32 SALEM TRUST COMPANY
05/31/2010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST COMPANY PRO RATA SH -861.72 $3,128.07
05131/2010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST COMPANY PRO-RATA SHI -8,426.70 $30,589.20
05/3112010 GJ MAY 10 - UNREALIZED LOSS ON INVESTP SALEM TRUST - EQUITY ACCOUNT -60,908.26 PRO RATA SHARE $221,098.91
06/30I2010 GJ JUNE 10 - UNREALIZED LOSS ON INV. SA TRUST - PRO-RATA SHARE $4,088.66 -1,126.34
06I30/2010 GJ JUNE 10 - UNREALIZED IOSS ON INVES7 SALEM TRUST PRO RATA SHARE -56,378.69
Unrealized gain/loss on invest 0.00 0.00 -1,556.69 0.00 0.00 1,556.69 0,0
Investment income 0.00 0.00 3,447.60 0.00 0.00 -3,447.60 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer
10I15/2009 GJ VOT PENSION DEPOSIT 10115/09 2,300.62
10129/2009 GJ VOT PENSION DEPOSIT 10129/09 4,029.47
11/1212009 GJ VOT PENSION DEPOSIT 11/12I09 3,369.98
11/25/2009 GJ VOT PENSION DEPOSIT P/D 11/25I09 3,612.37
12/10/2009 GJ VOT PENSION DEPOSIT 12/10I09 3,734.52
12/23I2009 GJ VOT PENSION DEPOSIT PAYDATE 12/23/( 3,468.47
01I0712010 GJ VOT PENSION DEPOSIT 01/07110 4,500.96
01/21/2010 GJ VOT PENSION DEPOSIT-PD 01/21/10 3,210.94
02/0412010 GJ VOT PENSION DEPOSIT PAYDATE 02I04/' 4,361.30
02/0412010 GJ VOT PENSION DEPOSIT P/D 02/04/10 3,755.46
02118/2010 GJ VOT PENSION DEPOSIT PID 02/18/10 3,815.35
0310412010 GJ VOT PENSION DEPOSIT P/D 03/04/10 4,311.63
0311812010 GJ VOT PENSION DEPOSIT P/D 03/18/10 3,845.62
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 14
Village of Tequesta 7I22I2010
For the Period: 10/1/2009 to 9130I2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Village Employee Pension-Polic
Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
04101/2010 GJ VOT PENSION DEPOSIT P/D 0411/10 3,789.94
04/1512010 GJ VOT PENSION DEPOSIT 04/15/10 3,815.85
04129/2010 GJ VOT PENSION DEPOSIT 04/15110 3,699.55
05/13/2010 GJ VOT PENSION DEPOSIT 05113/10 3,699.19
05/27I2010 GJ VOT PENSION DEPOSIT P/D 05/27/10 3,831.52
06I10/2010 GJ VOT PENSION DEPOSIT-P/D O6/10/10 3,921.03
06/24/2010 GJ VOT PENSION DEPOSIT 06124110 3,674.54
07I08/2010 GJ VOT PENSION CONTRIBUTION 07/08/10 3,624.82
07/22/2010 GJ VOT PENSION DEPOSIT 07I22110 4,179.69
Pension Fund Cont-Employer 115,600,00 115,600.00 82,552.82 0.00 0.00 33,047.18 71.4
368.002 Pension Fund Cont-Employee
10/15/2009 GJ VOT PENSION DEPOSIT 10115/09 1,000.27
10I29/2009 GJ VOT PENSION DEPOSIT 10129I09 1,751.94
11112/2009 GJ VOT PENSION DEPOSIT 11112/09 1,46521
11/25/2009 GJ VOT PENSION DEPOSIT PID 11/25109 1,570.59
12/10/2009 GJ VOT PENSION DEPOSIT 12/10109 1,623.71
12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/2311 1,508.03
0110712010 GJ VOT PENSION DEPOSIT 01/07I10 1,956.94
01/21/2010 GJ VOT PENSION DEPOSIT-PD 01121I10 1,396.06
0210412010 GJ VOT PENSION DEPOSIT PAYDATE 021041' 1,673.56
02/18/2010 GJ VOT PENSION DEPOSIT PID 02I18110 1,464.06
03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 1,654.50
03/18/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 1,475.68
04101/2010 GJ VOT PENSION DEPOSIT P/D 04I1110 1,454.31
04I1512010 GJ VOT PENSION DEPOSIT 04I15110 1,464.26
04/29I2010 GJ VOT PENSION DEPOSIT 04/15/10 1,419.63
05/13/2010 GJ VOT PENSION DEPOSIT 05I13I10 1,419.49
05/27/2010 GJ VOT PENSION DEPOSIT PID 05/27/10 1,470.27
06110/2010 GJ VOT PENSION DEPOSIT-PID 06/10/10 1,504.62
06I2412010 GJ VOT PENSION DEPOSIT 06/24I10 1,410.03
07/08I2010 GJ VOT PENSION CONTRIBUTION 07/08I10 1,390.95
07I22I2010 GJ VOT PENSION DEPOSIT 07122/10 1,603.87
Pension Fund Cont-Employee 37,800.00 37,800.00 31,677.98 0.00 0.00 6,122.02 83.8
Pension Contributions 153,400.00 153,400.00 114,230.80 0.00 0.00 39,169.20 74.5
Acct Class: 369 Miscellaneous Revenues
369.000 Other Miscellaneous Revenue
02/28I2010 GJ FEB 10 - RECLASSIFY DIVIDENDS AS A RETURN OF CAPITAL - SALEM TRUST CC 282.31 PRO RATA SHARE
Other Miscellaneous Revenue 0.00 0.00 282.31 0.00 0.00 -282.31 0.0
Miscellaneous Revenues 0.00 0.00 282.31 0.00 0.00 -282.31 0.0
General 153,400.00 153,400.00 138,256.63 0.00 0.00 15,143.37 90.1
Revenues 153,400.00 153,400.00 138,256.63 0.00 0.00 15,143.37 90.1
Expenditures
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531,301 Legal Services
11/02/2009 GJ CK#1063 - Expenses for Perry & Jensen Legal service Inv#63370 131.22
12I0712009 RE Rvs#237365 - CK#1069 - Perry & Jensen Legal services Inv#63413 -457.90 $1,659.05
12/0712009 GJ CK#1069 - Perry & Jensen Legal services Inv#63413 457.90 $1,659.05
12/15/2009 GJ CK#1074 Perry & Jensen Legal Services Inv#63414 764.53 $2,770.05
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 15
Village of Tequesta 7/22I2010
For the Period: 10/112009 to 9/30I2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Village Employee Pension-Polic
Expenditures
Dept: 000 General
Acct Class: 530 Operating Expenditures/Expense
01I20I2010 GJ Perry & Jensen - Legal Service expenses for period ended 12115/09 Inv.#63466 74.42 $269.25
01126/2010 GJ Record Perry & Jensen Legal service for period ended 253.85 1115/10 -$918.42
02/24/2010 GJ Ck #1087 Perry & Jensen - Legal service expenses for period ended 2115/10 685.62 inv #63567 $2,478.75
03/19/2010 GJ Perry & Jensen - Legal services for period ended 3I15I10 89.73 Inv#63619 -$324.16
04119/2010 GJ Record Perry Jensen legal services for period ended 386.73 4115I10 Inv#63658 $1,404.77
0512812010 GJ Perry & Jensen - Legal service expenses for period ended 5I15I10 303.25 Inv#63732 -$1,147.37
Legal Services 3,000,00 3,000.00 2,689.35 0.00 0.00 310.65 89.6
531.304 Recording Secy Service
10/29/2009 GJ CK#1064 Business Services Conn Inv#9-134 Office work for w/e 72.92 10116 and 10/23/09
11/02/2009 GJ Ck#1066 Business Services Connection Attend meeting and prepare minutes for 9.80 meeting held on 1017/09 $35.68
11/12l2009 GJ CK#1067 - Business Services Conn Inv#9-136 O�ce work for wle 72.92 10/30 and 1116/09
11125/2009 GJ CK#1068 Business Services Conn Inv#9-145 Office work for w/e 73.72 11113 and 11I20/09
12I07I2009 GJ CK#1073 - Business Services Conn Inv#9-149 Office work for wle 73.85 11/27 and 12104/09 $267.60
12I10/2009 GJ CK#1070 - Business Services Conn Attend qtrly meeting on 11/2/09 98.48 and prepare minutes $356.80
12/23I2009 GJ CK#1075 Business Services Conn Inv#9-154 Office work for w/e 73.85 12/11 and 12118/09
01I08/2010 GJ CK#1076 Business Services Conn Inv#9-158 Office work for wle 73.96 12/25/09 and 1/1/10
01/20I2010 GJ Record Business Services Connection Inv.#10-4 -$267.60 Office work wle 73.96 1/08I10 & 1/15/10
02I01I2010 GJ Ck#1082 Business Services Connection Attend meeting and prepare minutes for 64.10 meeting on 1I22I10 $231.92
02/04/2010 GJ CK#1083 - Business Services Conn Inv#10-8 O�ce work for w/e 73.96 1122 and 1129/10
0211 S/2010 GJ Ck#1084 - Business Services Conn Inv#10-13 - Office work for wle 37.01 2/5I10 & 2/12/10
02124/2010 GJ Ck #1085 Business Services Connection Attend meeting and prepare minutes for 152.97 meeting held on 2/1I10 $553.04
03/04/2010 GJ Ck #1086 Business Services Con�ection Inv #10-20 -$267.60 Office work w/e 74.02 2119/10 & 2126/10
03/18/2010 GJ CK #1089 BUSINESS SERVICS CONNECT INV #10-25 $267.60 OFFICE WORK W/E 74.06 3/5/10 & 3112/10
04I01I2010 GJ Ck #1091 Business Services Connection Inv #10-29 $267.60 Office work wle 74.06 3/19110 & 3/26I10
04/15/2010 GJ Business Services Connection Inv#10-35 - Office work for wle 73.68 4l2 and 4I9110 -$267.60
04122/2010 GJ Rec. Business Services Connection Attend special meeting on 4112/10 120.33 and prepare minutes $437.08
04129/2010 GJ Rec. Business Services Connection Inv#10-48 Office work for w/e 73.68 4/16 and 4/23/10 $267.60
05/18/2010 GJ Business Services Connection Attend special meeting & prepared 35.36 minutes - 5I03/10 $401.40
0511812010 GJ Business Services Connection Office work w/e 4I30/10 70.73 and 5/7/10 -$267.60
05127/2010 GJ Business Services Connection - Inv#10-65 Office work for w/e 70.73 5/14I10 and 5I21I10 -$267.60
06/10/2010 GJ Business Services Connection Office work for w/e 5128 & 6I4I10 73.70 Inv#10-71 -$267.60
06/24I2010 GJ Business Services Connection Office work for w/e 6111 & 6/18110 73.72 Inv#10-73 -$267.60
07/08/2010 GJ Business Services Connection Office work for wle 6/25 and 7l2/10 36.86 Inv#10-77 -$133.80
Recording Secy Service 2,100.00 2,100.00 1,802.43 0.00 0.00 297.57 85.8
531.309 Actuarial Services
01/20/2010 GJ Gabriel, Roeder, Smith & Company Serv.rendered thru 11/30/09 - Inv.110224 2,054.48 pro rata share $7,433.00
Actuarial Services 4,000.00 4,000.00 2,054.48 0.00 0.00 1,945.52 51.4
540.300 Travel & Per Diem
10/07/2009 GJ CK#1059 - Hotel accommodation at Radisson Resort Orlando for F. Dambra 208.50 to attend 41st Annual Pension Conf.
10/28/2009 GJ CK#1065 - Frank D'Ambra reimb of travel and meal exps to attend 41st Annual 82.18 Pol. Officers & FlFighters Conf $299.06
Travel & Per Diem 1,000.00 1,000.00 290.68 0.00 0.00 709.32 29.1
545.300 Insurance
10126/2009 GJ CK#1060 Fiduciary liability insurance policy for period 10I1109 to 10/1/10 896.81
Insurance 1,000,00 1,000.00 896.81 0.00 0.00 103.19 89.7
Other Misc Chgs & Obligations 900.00 900.00 0.00 0.00 0.00 900.00 0.0
554.300 Books, Pubi, Subs & Membership
12/0712009 GJ CK#1072 - 50% each fire and police FPPTA Membership Fee for year 2010 300.00 $600.00
Books, Publ, Subs & Membership 800.00 800.00 300.00 0.00 0.00 500.00 37.5
Seminars & Training - Pensions 500.00 500.00 0.00 0.00 0.00 500.00 0.0
Operating Expenditures/Expense 13,300.00 13,300.00 8,033.75 0.00 0.00 5,266.25 60.4
Acct Class: 531 Investment Expense
REVENUEIEXPENDITURE REPORT
Fiscal Year to Date
Page: 16
Village of Tequesta 7/22/2010
For the Period: 10I1/2009 to 9/30/2010 9:08 am
Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud
Fund: 603 - Village Employee Pension-Polic
Expenditures
Dept: 000 General
Acct Class: 531 Investment Expense
531.307 Investment Services
01/20/2010 GJ Rockwood Capitai - MGT Fee for Gtr ended 12/31109 $6,425.22 1,775.93
01I20/2010 GJ Bogdahn Consulting fee for Qtr ending 12/31/09 Inv.#4825 $3,750.00 1,036.50
01/20I2010 GJ Reclassify Bogdahn Consulting Fee for Qtr-Ended 12131/09 -1,036.50 $3,750.00
04126/2010 GJ Rec. Rockwood Capital Fees for qtr ended 3I31I10 1,906.69 $6,925.85
Investment Services 9,700.00 9,700.00 3,682.62 0.00 0.00 6,017.38 38.0
531.350 Custodial Services - Invest.
01/12/2010 GJ Salem fee and commissions for the period 1011/09 to 12/31/09 304.96 $1,102.52
04/30I2010 GJ TRUSTEE FEE &COMMISSIONS FOR THE 1/1/10 TO 3/31/10 PRO RATA SHARE 288.39 $1,047.13
Custodial Services - Invest. 0.00 0.00 593.35 0.00 0.00 -593.35 0.0
531.355 Investment Advisors
01/20/2010 GJ Reclassify Bogdahn Consulting Fee for Qtr-Ended 12131/09 1,036.50 $3,750.00
04116/2010 GJ Bogdahn Consulting fee for qtr ending 03/31/10 1,032.37 Inv#5069 -$3,750
InvestmentAdvisors 0.00 0.00 2,068.87 0.00 0.00 -2,068.87 0.0
Investment Expense 9,700.00 9,700.00 6,344.84 0.00 0.00 3,355.16 65.4
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
10/30/2009 GJ Oct 09 Wire fees to transfer fund to Sun America Bk 5.00 from Salem
12/31I2009 GJ Dec 09 - Wire fees to transfer funds to Sun American Bank 5.00 Public Safety Acct.
01131/2010 GJ Jan 10 - Wire fees to transfer funds to Sun American Bank from 5.00 Salem Trust
Bank Charges 100.00 100.00 15.00 0.00 0.00 85.00 15.0
Excess of additions over deduc 130,300.00 130,300.00 0.00 0.00 0,00 130,300.00 0.0
Other Financing Sources & Uses 130,400.00 130,400.00 15.00 0.00 0.00 130,385.00 0.0
General 153,400.00 153,400.00 14,393.59 0.00 0.00 139,006.41 9.4
Expenditures 153,400.00 153,400.00 14,393.59 0.00 0.00 139,006.41 9.4
Net Effect for Village Employee Pension-Polic 0.00 0.00 123,863.04 0.00 0.00 -123,863.04
Change in Fund Balance: 123,863.04