Loading...
HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 09_02/05/2007VILLAGE OF TEQUESTA PUBLIC SAFETY EMPLOYEES' PENSION TRUST FUND SCHEDULE OF INVESTMENT ACTIVITIES FOR THE QUARTER ENDING DEC 31, 2006 C~RAL LEDGER BALANCES - SEP 30, 2006 BALANCE 601-000-151.000 Investments -Salem Trust -Fire $ 2,519,641.74 601-000-135.100 Accrued Income -Salem Trust -Fire $ 10,091.53 603-000-151.000 Investments -Salem Trust -Police $ 816,544.82 603-000-135.100 -Accrued Income -Salem Trust -Police $ 3,271.20 INCREASES CONTRIBUTIONS Employer -Fire 29,272.96 Employer -Police 22,124.69 51, 397.65 State of Florida -Fire 18,971.37 State of Florida -Police 18,971.37 Employee -Fire 18,504.15 Employee -Police 9,619.44 INTEREST 8 DIVIDENDS 28,123.59 Interest 16,173.74 Dividend 5,860.83 Changes in Accrued Income 4,416.34 26,450.91 • OTHER Gain/Loss on Sale of Investments (855.91) UnRealized Gain/Loss on Investments 96,323.32 95,467.41 TOTAL INCREASES 220,410.93 DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions (2,048.78) (2,048.78) ADMINISTRATIVE EXPENSES Bogdahn Consulting (2,000.00) Misc. Charges -Shipping (67.67) Salem Trust -Fees (820.37) Rockwood Capital Management (4,436.94) Foreign Tax W/Held (23.41) Acordia Insurance (3,356.80) Hanson, Perry & Jensen PA (787.00) (11,492.19) TOTAL DEDUCTIONS (13,540.97) GENERAL LEDGER BALANCES - 12/31/06 $ 3,556,419.25 E •s per Salem Statement - 12/31/06 3,545,279.28 Add: Pension In Transit 11,139.97 $ 3,556,419.25 Difference $ - QUARTER ENDED 12!3 ] /06 Village of Teyuesta As of: 12/31 /2006 Page: 1 1 /25!2007 1:02 pm Balances . Fund Type: 600 Trust and Agency Funds Fund: 601 -Village Employee Pension-Fire Assets Acct Class: 101 Cash and Cash Equivalents 101.100 Cash -Bank of America • Acct Class: 101 Cash and Cash Equivalents Acct Class: 103 Investments 135.100 Accrued Income 15l .000 Investments Acct Class: 103 Investments Tota] Assets Liabilities Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) Acct Class: 208 Due to Other Funds Total Liabilities ReservesBalances Acct Class: 253 FB - Unreserved/Undesignated 271.000 Fund Balance 299.000 Change In Fund Balance Acct Class: 253 FB - Unreserved/Undesignated Tota] ReservesBalances Total Liabilities & Balances 0.01 -0.01 13,396.53 2,666,373.55 2,679,770.08 2,679,770.07 164.25 164.25 16425 2,548,561.35 ] 31,044.47 2,679,605.82 2,679,605.82 2,679,770.07 • QUARTER ENDED 12/31106 Page 1 1 /2512007 Village of Teguesta 1:05 pm QTR: 1 QTD Amd. Bud. YTD Actual QTD Actual Fund: 601 -Village Employee Pension-Fire venues Function: 000 General Revenues Dept: 000 General Acct Class. 311 General Property Taxes 312,510 Fire Insurance Prem Tax 0.00 0.00 0.00 General Property Taxes 0.00 0.00 0.00 Acct Class: 361 Unrestricted Investment Earnin 361,100 Interest Income 0.00 15,508.65 15,508.65 361.102 Dividend Income 0.00 4,422.97 4,422.97 361.103 Money funds Dividends 0.00 0.00 0.00 Unrestricted Investment Earnin 0.00 19,931.62 19,931.62 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0.00 -643.95 -643.95 367.100 Unrealized gainlloss on invest 0.00 72,680.33 72,680.33 368.001 Pension Fund Cont-Employer 0.00 25,870.13 25,870.13 368.002 Pension Fund Cont-Employee 0.00 16,353.14 16,353,14 369.000 Other Miscellaneous Revenue 0.00 0.00 0.00 Miscellaneous Revenues 0.00 114,259.65 114,259.65 General 0.00 134,191.27 134,191.27 General Revenues 0.00 134,191.27 134,191.27 Revenues 0.00 134,191.27 134,191.27 Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0.00 593.71 593.71 531.304 Recording Secy Service 0.00 0.00 0.00 531.307 Investment Services 0.00 17.69 17.69 531.309 Actuarial Services 0.00 0.00 0.00 534.300 Other Contractual Services 0.00 0.00 0.00 540.300 Travel & Per Diem 0.00 0.00 0.00 545.3001nsurance 0.00 2,535.40 2,535.40 549.300 Other Misc Chgs & Obligations 0.00 0.00 0.00 554.300 Books, Publ, Subs & Membership 0.00 0.00 0.00 554.600 Seminars & Training -Pensions 0.00 0.00 0.00 Operating Expenditures/Expense 0.00 3,146.80 3,146.80 General 0.00 3,146.80 3,146.80 General Revenues 0.00 3,146.80 3,146.80 Function: 518 Pension Benefits Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 531.300 Professional Services 0.00 0.00 0.00 531.307 Investment Services 0.00 0.00 0.00 536.300 Pension DistributionslRefunds 0.00 0.00 0.00 Operating Expenditures/Expense 0.00 0.00 0.00 Pension 0.00 0.00 0.00 Pension Benefits 0.00 0.00 0.00 Expenditures 0.00 3,146.80 3,146.80 Net Effect for Fund Village Employee Pension-Fire 0.00 131,044.47 131 044 47 • , . ntvtnut rctrurci QUARTER ENDED 12131/06 Village of Tequesta For the Period: 1011/2006 to 12131/2006 Page. 1 1/25/2007 1:07 pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 01 -Village Employee Pension-Fire Rt Function: 000 General Revenues Dept 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 10/31/2006 GJ OCT O6 -RVS SEP 06 ACCRUED INCOME SALEM -PRO RATA SHARE $13,362.73 -10,091.53 10/31/2006 GJ OCT O6 -ACCRUED INCOME -SALEM PRO RATA SHARE $12,283.17 9,279.93 10/3112006 GJ OCT 06 -INTEREST -SALEM -PRO RATA SHARE - $5,572.99 4,210.66 11/30/2006 GJ NOV 06 -RVS OCT 06 ACCRUED INCOME SALEM TRUST -PRO RATA SHARE •9,279.93 $12,283.17 11/30/2006 GJ NOV O6 -ACCRUED INCOME -SALEM TRUST -PRO RATA SHARE 10,271.80 $13,615.86 11/30/2006 GJ NOV O6 -INTEREST -SALEM TRUST PRO RATA SHARE 4,683.63 $6,208.78 12/3112006 GJ 12/31106 -INTEREST - $4,391.97 SALEM -PRO RATA 3,309.36 12/31/2006 GJ 12/31/06 -RVS NOV 06 ACC. INCOME SALEM -PRO RATA - $13,615.86 -10,271.80 12/3112006 GJ 12/31/06 -ACCRUED INCOME SALEM -PRO RATA - $17,779.07 13,396.53 Interest Income 361.102 Dividend Income 10/31/2006 GJ OCT 06 -DIVIDENDS -SALEM TRUST 11/3012006 GJ NOV O6 -DIVIDEND -SALEM TRUST 12/31/2006 GJ 12131/06 -DIVIDENDS - $1,548.87 Dividend Income Unrestricted Investment Earnin 0.00 PRO RATA SHARE - $2,638.46 PRO RATA SHARE SALEM-PRO RATA 0.00 0.00 0.00 15,508.65 0.00 -15,508.65 O.C 1,993.48 1,262.41 $1,673.50 1,167.08 0.00 4,422.97 0.00 x,422.97 0.0 0.00 19,931.62 0.00 -19,931.62 0.0 Acct Class: MISC Miscellaneous Revenues 367.000 GainlLoss-Sale of Investments 10/31/2006 GJ OCT O6 -GAIN ON SALE OF INVESTMENT SALEM • PRO RATA SHARE $704.02 ~ 1/30/2006 GJ NOV O6 -LOSS ON SALE OF INVESTMEN' SALEM TRUST • PRO RATA SHARE /2006 GJ 12/31/06 - LOSS ON SALE OF INVEST SALEM -PRO RATA ($1,072.24) GainlLoss-Sale of Investments 0.00 0.00 367.100 Unrealized gainlloss on invest 10/31/2006 GJ OCT 06 -UNREALIZED GAIN -SALEM PRO RATA SHARE $23,037,89 11/3012006 GJ NOV 06 -UNREALIZED GAIN SALEM • PRO RATA SHARE 12/31/2006 GJ 12/31/06 -UNREALIZED GAIN -SALEM PRO RATA - $12,583.97 Unrealized gain/loss on invest 368.001 Pensio n Fund Cont-Employer 10/06/2006 PA VOT PENSION DEPOSIT-P/D 10/06/O6 10/06/2006 PA VOT PENSION DEPOSIT-PID 09/30/O6 10/06/2006 RE VOT PENSION DEPOSIT-PID 09/30/06 10/2012006 PA VOT PENSION DEPOSIT-P/D 10/20/06 11/03/2006 PA VOT PENSION DEPOSITS-P/D 11/03/06 11117/2006 PA VOT PENSION DEPOSIT-PID 11/17/06 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 12/15/2006 PA VOT PENSION DEPOSIT-P/D 12115/06 12/29/2006 PA VOT PENSION DEPOSIT-P/D 12/29/06 0.00 0,00 Pension Fund Cont-Employer 368.002 Pension Fun d Cont-Employee 10/0612006 PA VOT PENSION DEPOSIT-P/D 10/06/06 10/06/2006 PA VOT PENSION DEPOSIT-P/D 09130/06 10!06/2006 RE VOT PENSION DEPOSIT-PID 09/30/06 10/20!2006 PA VOT PENSION DEPOSIT-PID 10/20/06 11/03/2006 PA VOT PENSION DEPOSITS-PID 11/03/06 11/17/2006 PA VOT PENSION DEPOSIT-P/D 11/17/06 '~/01I2006 PA VOT PENSION DEPOSIT-P/D 12/01106 /2006 PA VOT PENSION DEPOSIT-P/D 12115/06 912006 PA VOT PENSION DEPOSIT-PID 12129/06 0.00 0.00 531.89 -367.91 ($487.69) -807.93 -643.95 17,405.13 45,793.18 $60,701.46 9,482.02 72,680.33 0.00 643.95 0.0 0.00 -72,680.33 0.0 258.69 3,402.83 -3,402.83 3,722.32 4,257.36 4,217.79 4,883.84 4,115.91 4,414.22 25,870.13 0.00 -25,870.13 0.0 163.53 2,151.01 -2,151.01 2,352.97 2,691.18 2,666.17 3,087.19 2,601.76 2,790.34 rctvtrvut rctrurci QUARTER ENDED 12131/06 Page: 2 Village of Tequesta 1/25/2007 For the Period: 1011/2006 to 12/31/2006 1:07 pm Original Bud, Amended Bud. pTD Actual Encumb. YTD UnencBal % Bud 01 -Village Employee Pension-Fire Re Function: 000 General Revenues Dept. 000 General Acct Class: MISC Miscellaneous Revenues Pension Fund Cont-Employee 0.00 0.00 16,353.14 0.00 -16,353.14 0.0 Miscellaneous Revenues 0.00 0.00 114,259.65 0.00 -114,259.65 0.0 General 0,00 0.00 134,191.27 0.00 -134,191.27 0.0 General Revenues 0.00 0.00 134,191,27 0.00 -134,191.27 0.0 Revenues 0.00 0.00 134,191.27 • 0.00 -134,191.27 0.0 1I 1J u tnrtnui i unt ntrvn i QUARTER ENDED 12131106 Village of Tequesta For the Period: 101112006 to 12/3112006 Page: 1 1/2512007 1 OS pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud u i - vmage tmptoyee Nension-tire E res Function. 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531,301 Legal Services 12/31/2006 GJ 12/31106 - HANSON, PERRY 8 JENSEN SALEM -PRO RATA -LEGAL SERVICE 593,71 THRU NOV 15, 2006 $787,00 Legal Services 0.00 0.00 593.71 0.00 531,307 Investment Services 10126/2006 GJ OCT 06 -SALEM FEE PRO RATA SHARE 7/1 TO 9/30/06 - $820.37 619.54 10126/2006 RE OCT 06 -REVERSE 163808 -SALEM FEE 7/1 TO 9130106 - $820.37 -619.54 10/3112006 GJ OCT 06 -FOREIGN TAX W/HELD SALEM -PRO RATA SHARE ($23.41) 17.69 Investment Services 0.00 0.00 17.69 0.00 545.300 Insurance 10/19/2006 GJ OCT 06 - ACORDIA LIABILITY INSURANCE OCT 06 TO OCT 07 - $3,356.80 2,535.40 10119/2006 GJ 10/12/06 • ACORDIA LIAR. INSURANCE OCT 06 TO OCT 07 2,535.40 $3,356.80 10/19/2006 RE OCT 06 - REVERSE JE#162797 - ACORDIF OCT 06 TO OCT 07 $3 356 80 2 -593.71 0.0 17.69 0.0 - - ,535,40 Insurance 0.00 0.00 2,535.40 0.00 -2,535.40 0.0 Operating ExpenditureslExpense 0.00 0.00 3,146.80 0.00 -3,146.80 0.0 General 0.00 0.00 3,146.80 0.00 -3,146.80 0.0 General Revenues Ex^~^rlitures • 0.00 0.00 3,146.80 0.00 0.00 3,146.80 0.00 -3,146.80 0.0 0.00 -3,146.80 0.0 • L~i.~1 ~ ~. 1. Ui1LL 1 QUARTER ENDED 12/31!06 Page: 3 1;25/2007 Village of Tequesta 1 :02 pm As of: 12!31!2006 Balances • Fund Type: 600 Trust and Agency Funds Fund: 603 -Village Employee Pension-Polic Assets • Acct Class: 101 Cash and Cash Equivalents l 01.100 Cash -Bank of America 0.01 Acct Class: lOl Cash and Cash Equivalents 0.01 Acct Class: 103 Investments 135.100 Accrued Income 4,382.54 ] 51.000 Investments 872,266.63 Acct Class: 103 Investments 876,649.17 Total Assets 876,649.18 Liabilities Acct Class: 208 Due to Other Funds 207,001 Due to/from Genera] Fund (001) 164.25 207.602 Due to/fr - Pension/Gen (602) 407.88 Acct Class: 208 Due to Other Funds 572.13 Total Liabilities 572.13 ReservesBalances Acct Class: 253 FB - Unreserved/Undesignated 271.000 Fund Balance 82],744.29 299.000 Change In Fund Balance 54,332.76 Acct Class: 253 F/B - Unreserved/Undesignated 876,077.05 Total Reserves/Balances 876,077.05 Total Liabilities & Balances 876,649.18 • Village of Teguesfa QUARTER ENDED 12I31I06 Paoe: 3 112512007 1 05 pm QTR: 1 OTD Amd. Bud. YTD Actual OTD Actual Fund: 603 -Village Employee Pension-Polk evenues Function: 000 General Revenues Dept: 000 General Acct Class: 311 General Property Taxes 312.520 Casualty Insurance Premium Tax General Property Taxes Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 361.102 Dividend Income 361.103 Money funds Dividends Unrestricted Investment Earnin Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 367.100 Unrealized gainlloss on invest 368.001 Pension Fund Cont-Employer 368.002 Pension Fund Cont-Employee 369.000 Other Miscellaneous Revenue Miscellaneous Revenues General General Revenues Revenues Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense • 531.301 Legal Services 531.304 Recording Secy Service 531.307 Investment Services 531.309 Actuarial Services 534.300 Other Contractual Services 540.300 Travel & Per Diem 545.300 Insurance 549.300 Other Misc Chgs & Obligations 554.300 Books, Publ, Subs & Membership 554.600 Seminars & Training -Pensions Operating Expenditures/Expense General General Revenues Function: 518 Pension Benefits Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 531.300 Professional Services 531.307 Investment Services 536.300 Pension Distributions/Refunds Operating Expenditures/Expense Pension Pension Benefits Expenditures 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5,081.43 5,081.43 0.00 1,437.86 1,437.86 0.00 0.00 0.00 0.00 6,519.29 6,519.29 0.00 -211.96 -211.96 0.00 23,642.99 23,642.99 0.00 19,132.95 19,132.95 0.00 8,318.68 .8,318.68 0.00 0.00 0.00 0.00 50,882.66 50,882.66 0.00 57,401.95 57,401.95 0.00 57,401.95 57,401.95 0.00 57,401.95 57,401.95 0.00 193.29 193.29 0.00 0.00 0.00 0.00 5.72 5.72 0.00 0.00 0,00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 821.40 821.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,020.41 1,020.41 0.00 1,020.41 1,020.41 0.00 1,020.41 1,020.41 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,048.78 2,048.78 0.00 2,048.78 2,048.78 0.00 2,048.78 2,048.78 0.00 2,048.78 2,048.78 ~~~+~+ , vv.iV J,V VJ.IJ Net Effect for Fund Village Employee Pension-Polk 0.00 54,332.76 54,332.76 • KtVtNUt KtNUK I QUARTER ENDED 12131/06 Village of Tequesta For the Period: 10/1/2006 to 12/3112006 0.00 0.00 5,081.43 Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 3 -Village Employee Pension-folic Rev Function: 000 General Revenues Dept 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 1013112006 GJ OCT 06 -RVS SEP 06 ACCRUED INCOME SALEM -PRO RATA SHARE $13,362.73 -3,271.20 10/3112006 GJ OCT O6 -ACCRUED INCOME -SALEM PRO RATA SHARE $12,283.17 3,003.24 10/3112006 GJ OCT O6 -INTEREST -SALEM -PRO RATA SHARE - $5,572.99 1,362.33 11/30/2006 GJ NOV 06 -RVS OCT O6 ACCRUED INCOME SALEM TRUST -PRO RATA SHARE -3,003.24 $12,283.17 11/30/2006 GJ NOV 06 -ACCRUED INCOME -SALEM TRUST -PRO RATA SHARE 3,344.06 $13,615.86 11/30/2006 GJ NOV 06 -INTEREST -SALEM TRUST PRO RATA SHARE 1,525.15 $6,208.78 12131/2006 GJ 12/31/06 -INTEREST - $4,391.97 SALEM -PRO RATA 1,082.61 12/31/2006 GJ 12/31!06 -RVS NOV O6 ACC. INCOME SALEM -PRO RATA - $13,615.86 -3,344.06 12/3112006 GJ 12131/06 -ACCRUED INCOME SALEM -PRO RATA - $17,779.07 4,382.54 Interest Income 361.102 Dividend Income 10/3112006 GJ OCT O6 -DIVIDENDS -SALEM TRUST 11/30/2006 GJ NOV O6 -DIVIDEND -SALEM TRUST 12/31/2006 GJ 12/31/06 -DIVIDENDS - $1,548.87 Dividend Income PRO RATA SHARE - $2,638.46 PRO RATA SHARE SALEM -PRO RATA 0.00 644.98 411.09 $1,673.50 381.79 0.00 1,437.86 Page: 5 1125/2007 1:07 pm 0.00 -5,081.43 0.0 0.00 -1,437.86 0.0 Unrestricted Investment Eamin 0.00 0.00 6,519.29 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 10/31/2006 GJ OCT O6 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA SHARE $704.02 "30/2006 GJ NOV O6 -LOSS ON SALE OF INVESTMEN' SALEM TRUST -PRO RATA SHARE X006 GJ 12/31/06 -LOSS ON SALE OF INVEST SALEM -PRO RATA ($1,072.24) Gain/Loss-Sale of Investments 0.00 0.00 367.100 Unrealized gain/loss on invest 10/31/2006 GJ OCT O6 -UNREALIZED GAIN • SALEM PRO RATA SHARE $23,037,89 11/30/2006 GJ NOV 06 -UNREALIZED GAIN SALEM -PRO RATA SHARE 12/31/2006 GJ 12131/06 -UNREALIZED GAIN -SALEM PRO RATA - $12,583.97 Unrealized gain/loss on invest 368.001 Pensio n Fun d Cont-Employer 10/06/2006 PA VOT PENSION DEPOSIT-P/D 10/O6/O6 10/06/2006 PA VOT PENSION DEPOSIT-P/D 09/30/06 10106/2006 RE VOT PENSION DEPOSIT-P/D 09130/06 10/2012006 PA VOT PENSION DEPOSIT-P/D 10/20/06 11/0312006 PA VOT PENSION DEPOSITS-P/D 11/03/06 11/17/2006 PA VOT PENSION DEPOSIT-P/D 11/17106 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12101/06 12/15/2006 PA VOT PENSION DEPOSIT-P/D 12/15/06 12/29/2006 PA VOT PENSION DEPOSIT-P/D 12129/06 0.00 0.00 Pension Fund Cont-Employer 368.002 Pensio n Fun d Cont-Employee 10/06/2006 PA VOT PENSION DEPOSIT-P/D 10/06/06 10/O6/2006 PA VOT PENSION DEPOSIT-P/D 09/30/06 10/06/2006 RE VOT PENSION DEPOSIT-P/D 09/30/06 10/20/2006 PA VOT PENSION DEPOSIT-P/D 10/20/06 11/03/2006 PA VOT PENSION DEPOSITS-P/D 11/03/06 11/17/2006 PA VOT PENSION DEPOSIT-PID 11/17/06 "~ 112006 PA VOT PENSION DEPOSIT-P/D 12101/06 006 PA VOT PENSION DEPOSIT-P/D 12/15/06 12006 PA VOT PENSION DEPOSIT-P/D 12/29/06 0.00 0.00 172.13 -119.78 ($487.69) -264.31 -211, 96 5,632.76 14,908.28 $60,701,46 3,101.95 23,642.99 37.42 2,991, 74 -2,991.74 3,038.15 3,199.69 3,689.07 3,731.68 2,694.08 2,742.86 0.00 -6,519.29 0.0 0.00 211.96 0.0 0.00 -23,642.99 0.0 19,132.95 0.00 -19,132.95 0.0 16.27 1,300.76 -1,300.76 1,320.93 1,391.17 1,603.95 1,622.47 1,171.34 1,192.55 REVENUE REPORT QUARTER ENDED 12/31/06 Page: 6 Village of Tequesta 1/25/2007 For the Period. 10/1/2006 to 12/31/2006 1 07 pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 03 -Village Employee Pension-folic Re s Function. 000 General Revenues Dept: 000 General Acct Class: MISC Miscellaneous Revenues Pension Fund Cont-Employee 0.00 0.00 8,318.68 0,00 -8,318.68 0.0 Miscellaneous Revenues 0.00 - 0.00 50,882.66 0.00 -50,882.66 0.0 General 0.00 0.00 57,401.95 0.00 -57,401.95 0.0 General Revenues 0.00 0.00 57,401.95 0.00 -57,401.95 0.0 I Revenues 0.00 0.00 57,401.95 • 0.00 -57,401.95 0.0 txrtnuirurtt Ktrurti QUARTER ENDED 12,31/06 Village of Tequesta For the Period: 10/1/2006 to 12/31/2006 Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 03 -Village Employee Pension-Potic Ex res Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 12/31/2006 GJ 12/31106 - HANSON, PERRY 8 JENSEN SALEM -PRO RATA -LEGAL SERVICE 193.29 THRU NOV 15, 2006 $787.00 Legal Services 0.00 0.00 193.29 0.00 -193.29 0.0 531.307 Investment Services 10/26/2006 GJ OCT 06 -SALEM FEE PRO RATA SHARE 7/1 TO 9/30106 - $820.37 200.83 10/26/2006 RE OCT 06 -REVERSE 163808 -SALEM FEE 7/1 TO 9130/06 - $820.37 -200.83 10/31!2006 GJ OCT 06 -FOREIGN TAX W/HELD SALEM- PRO RATA SHARE ($23.41) 5.72 Investment Services 0.00 0.00 5.72 0.00 -5.72 0.0 545.300 Insurance 10/19/2006 GJ OCT O6 - ACORDIA LIABILITY INSURANCE OCT 06 TO OCT 07 • $3,356.80 821.40 10119/2006 GJ 10112/06 • ACORDIA LIAB. INSURANCE OCT O6 TO OCT 07 821.40 $3,356.80 10/19/2006 RE OCT 06 - REVERSE JE#162797 - ACORDIF OCT O6 TO OCT 07 - $3,356.80 -821.40 Insurance 0,00 0.00 821.40 0.00 -821.40 0.0 Operating Expenditures/Expense 0.00 0.00 General 0.00 0.00 General Revenues 0.00 0.00 Function: 518 Pension Benetts dept: 165 Pension ct Class: 530 Operating ExpenditureslExpense 5:, ension Distributions/Refunds 12/11/2006 GJ 12111/06 - ROBERT NEIER TERMINATED 11/3106 - REF OF PENSION CONTRIBS Pension Distributions/Refunds 0.00 0.00 Operating Expenditures/Expense 0.00 0.00 2,048.78 0.00 -2,048.78 0.0 Pension 0.00 0.00 2,048.78 0.00 -2,048.78 0.0 Pension Benefits 0.00 0.00 2,048.78 1,020.41 0.00 -1,020,41 0.0 1,020.41 0.00 -1,020.41 0.0 1,020.41 0.00 -1,020.41 0.0 2,048.78 $2,048.78 2,048.78 0.00 -2,048.78 0.0 Page: 3 112512007 1:08 pm 0.00 -2,048.78 0.0 Expenditures 0.00 0,00 3,069.19 0.00 -3,069.19 0.0 •