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 State of Florida -Fire 18,971.37 State of Florida -Police Employee -Fire 18,504.15 Employee -Police 9,619.44 INTEREST 8 DIVIDENDS 51,397.65 18,971.37 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 $ - Village of Tequesta QUARTER ENDED 12/31/06 Page: l 1 /25/2007 1:02 pm As of: 12/3 l /2006 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 151.000 Investments :7 Acct Class: 103 Investments Total 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 Total 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 164.25 2,548,561.35 131,044.47 2,679,605.82 2,679,605.82 2,679,770.07 • QUARTER ENDED 12/31106 Village of Teguesta Page 1 1125/2007 1:05 pm QTR: 1 OTD Amd. Bud. YTD Actual OTD Actual Fund: 601 -Village Emplovee 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 Propertv 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 GainlLoss-Sale of Investments 0.00 -643.95 -643.95 367.100 Unrealized gain/loss 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 Expenditures/Expense 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 8 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 Distributions/Refunds 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 Emplovee Pension-Fire 0.00 131,044.47 131,044.47 • KtVtfVUt KtYUKI QUARTER ENDED 12/31106 Village o(Tequesta For the Period 101112006 to 12131/2006 Page. 1 112512007 1:07 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Buc 01 -Village Employee Pension-Fire Re Function: 000 General Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 10/31/2006 GJ OCT 06 -RVS SEP 06 ACCRUED INCOME SALEM -PRO RATA SHARE $13,362.73 -10,091.53 10!3112006 GJ OCT 06 -ACCRUED INCOME -SALEM PRO RATA SHARE $12,283.17 9,279.93 10/31/2006 GJ OCT O6 -INTEREST -SALEM -PRO RATA SHARE - $5,572.99 4,210.66 11/3012006 GJ NOV 06 -RVS OCT 06 ACCRUED INCOME SALEM TRUST -PRO RATA SHARE -9,279.93 $12,283.17 11/3012006 GJ NOV 06 -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/31106 -ACCRUED INCOME SALEM -PRO RATA - $17,779.07 13,396.53 Interest Income 361.102 Dividend Income 10/31/2006 GJ OCT O6 -DIVIDENDS -SALEM TRUST 1 1 /3 012 006 GJ NOV O6 -DIVIDEND -SALEM TRUST 12/31/2006 GJ 12/31/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 0.0 1,993,48 1,262.41 $1,673.50 1,167.08 0.00 4,422.97 0.00 -4,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 06 -GAIN ON SALE OF INVESTMENT SALEM -PRO RATA SHARE $704.02 ~ 1130/2006 GJ NOV O6 -LOSS ON SALE OF INVESTMENT 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 gain/loss on invest 10/31/2006 GJ OCT 06 -UNREALIZED GAIN -SALEM PRO RATA SHARE $23,037.89 11!30/2006 GJ NOV O6 -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 Pension Fund Cont-Employer 10/06/2006 PA VOT PENSION DEPOSIT-P/D 10/06106 10/0612006 PA VOT PENSION DEPOSIT-P/D 09/30/O6 10/O6I2006 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-P/D 11/17/06 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 12/15/2006 PA VOT PENSION DEPOSIT-P/D 12/15/06 12/29/2006 PA VOT PENSION DEPOSIT-P/D 12/29106 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/06/2006 PA VOT PENSION DEPOSIT-P/D 09/30106 10/0612006 RE VOT PENSION DEPOSIT-P/D 09/30106 10/20/2006 PA VOT PENSION DEPOSIT-P/D 10/20106 11/0312006 PA VOT PENSION DEPOSITS-P/D 11/03/06 11/17/2006 PA VOT PENSION DEPOSIT•P/D 11/17/06 '~/01i2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 /2006 PA VOT PENSION DEPOSIT-P/D 12/15/06 /2006 PA VOT PENSION DEPOSIT-P/D 12/29106 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 rctvtnut rctrurci QUARTER ENDED 12131/06 Page. 2 Village of Tequesta 1/2512007 For the Period. 1011/2006 to 12/3112006 1.07 pm Original Bud. Amended Bud. QTD 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 Revenues 0.00 0.00 134,191.27 0.00 0.00 134.191.27 0.00 -134,191.27 0.0 0.00 -134.191.27 0.0 i• i• tnrtnui i unt Ktr~tc i QUARTER ENDED 12/31106 Page: 1 Village of Tequesta 112512007 For the Period: 1011/2006 to 12/3112006 1:08 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 01 -Village Employee Pension-Fire ~ E res Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 12/3112006 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 1012612006 GJ OCT O6 -SALEM FEE PRO RATA SHARE 711 TO 9/30106 - $820.37 619.54 10/26/2006 RE OCT 06 -REVERSE 163808 -SALEM FEE 711 TO 9130106 - $820.37 -619.54 10131/2006 GJ OCT O6 -FOREIGN TAX WIHELD 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 LIAB. INSURANCE OCT O6 TO OCT 07 2,535.40 $3,356.80 1011912006 RE OCT O6 - REVERSE JE#162797 - ACORDIF OCT 06 TO OCT 07 - $3,356.80 -2,535.40 -593.71 0.0 17.69 0.0 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 0.00 0.00 3,146.80 0.00 -3,146.80 0.0 Ex~~^~iitures • 0.00 0.00 3,146.80 0.00 -3,146.80 0.0 I L~fLA1~t.L ~~11L 1. 1. QUARTER ENDED 12/31!06 Village of Tequesta Page: 3 1/25/2007 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 101.100 Cash -Bank of America 0.01 Acct Class: 101 Cash and Cash Equivalents 0.01 Acct Class: 103 Investments 135.100 Accrued Income 4,382.54 151.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 General 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 Acct Class: 253 F/B - Unreserved/1Jndesi nat d 54,332.76 g e 876,077.05 Total Reserves/Balances 876,077.05 Total Liabilities & Balances 876,649.18 QUARTER ENDED 12131/06 Page: 3 112512007 Village of Teguesla 1:05 pm OTR: 1 STD Amd. Bud, YTD Actual OTD Actual Fund: 603 -Village Emplovee Pension-folic venues Function: 000 General Revenues Dept 000 General Acct Class: 311 General Property Taxes 312,520 Casualty Insurance Premium 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 5,081.43 5,081.43 361.102 Dividend Income 0.00 1,437.86 1,437.86 361.103 Money funds Dividends 0.00 0.00 0.00 Unrestricted Investment Earnin 0.00 6,519.29 6,519.29 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0.00 -211.96 -211.96 367.100 Unrealized gainlloss on invest 0.00 23,642.99 23,642.99 368.001 Pension Fund Cont-Employer 0.00 19,132.95 19,132.95 368.002 Pension Fund Cont-Employee 0.00 8,318.68 8,318,68 369.000 Other Miscellaneous Revenue 0.00 0.00 0.00 Miscellaneous Revenues 0.00 50,882.66 50,882.66 General 0.00 57,401.95 57,401.95 General Revenues 0.00 57,401.95 57,401.95 Revenues 0.00 57,401.95 57,401.95 Expenditures Funclion: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0.00 193.29 193.29 . 531.304 Recording Secy Service 0.00 0.00 0.00 531.307 Investment Services 0.00 5.72 5,72 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 821.40 821.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 1,020.41 1,020.41 General 0.00 1,020.41 1,020.41 General Revenues 0.00 1,020.41 1,020.41 Function: 518 Pension Benefits Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 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 2,048.78 2,048.78 Operating Expenditures/Expense 0.00 2,048.78 2,048.78 Pension 0.00 2,048.78 2,048.78 Pension Benefits 0.00 2,048.78 2,048.78 Expenditures 0.00 3,069.19 3,069.19 Net Effect for Fund Village Emplovee Pension-folic 0.00 54,332.76 54,332.76 ~~ ~J KtVtNUt KtYUK I QUARTER ENDED 12131106 Village of Tequesta For the Period. 10/112006 to 12131/2006 Page. 5 1!2512007 1:07 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Buc 3 -Village Employee Pension-folic Re 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 O6 ACCRUED INCOME SALEM -PRO RATA SHARE $13,362.73 -3,271.20 10/31/2006 GJ OCT 06 -ACCRUED INCOME -SALEM PRO RATA SHARE $12,283,17 3,003.24 10/31/2006 GJ OCT 06 -INTEREST -SALEM -PRO RATA SHARE • $5,572.99 1,362.33 11130/2006 GJ NOV 06 -RVS OCT O6 ACCRUED INCOME SALEM TRUST -PRO RATA SHARE -3,003.24 $12,283.17 11130/2006 GJ NOV O6 -ACCRUED INCOME -SALEM TRUST -PRO RATA SHARE 3,344.06 $13,615.86 11/3012006 GJ NOV O6 -INTEREST -SALEM TRUST PRO RATA SHARE 1,525.15 $6,20878 12/3112006 GJ 12131/06 -INTEREST - $4,391.97 SALEM -PRO RATA 1,082.61 12/3112006 GJ 12/31/06 -RVS NOV O6 ACC. INCOME SALEM -PRO RATA - $13,615.86 -3,344.06 12/3112006 GJ 12(31106 -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/3012006 GJ NOV 06 -DIVIDEND -SALEM TRUST 12/31/2006 GJ 12/31/06 -DIVIDENDS - $1,548.87 Dividend Income Unrestricted Investment Earnin 0.00 0.00 5,081,43 PRO RATA SHARE - $2,63846 PRO RATA SHARE SALEM -PRO RATA 0.00 0.00 0.00 0.00 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 "3012006 GJ NOV O6 -LOSS ON SALE OF INVESTMENT SALEM TRUST -PRO RATA SHARE 006 GJ 12131/06 -LOSS ON SALE OF INVEST SALEM -PRO RATA ($1,072.24) GainlLoss-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 1113012006 GJ NOV O6 -UNREALIZED GAIN SALEM -PRO RATA SHARE 12/31/2006 GJ 12/31106 -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/06106 10/0612006 PA VOT PENSION DEPOSIT-P/D 09130/06 10106/2006 RE VOT PENSION DEPOSIT-P/D 09/30/06 10/20/2006 PA VOT PENSION DEPOSIT-P/D 10/20/06 11103/2006 PA VOT PENSION DEPOSITS-P/D 11/03/06 11117/2006 PA VOT PENSION DEPOSIT-P/D 11/17/06 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 12/15/2006 PA VOT PENSION DEPOSIT-P/D 12/15/06 12!29/2006 PA VOT PENSION DEPOSIT-P/D 12/29/06 0.00 0.00 Pension Fund Cont-Employer 368.002 Pensio n Fun d Cont-Employee 1010612006 PA VOT PENSION DEPOSIT-P/D 10106106 10/06/2006 PA VOT PENSION DEPOSIT-P/D 09/30106 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-P/D 11/17!06 ''r01/2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 2006 PA VOT PENSION DEPOSIT-PID 12/15/06 12006 PA VOT PENSION DEPOSIT-P1D 12/29/06 0.00 o.oo 644.98 411.09 $1,673.50 381.79 1,437.86 6,519.29 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 0.00 -5,081.43 0.0 0.00 -1,437.86 0.0 0.00 -6,519.29 0.0 0.00 211.96 0.0 0.00 -23,642.99 0.0 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 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 Village of Tequesta For the Period: 101112006 to 12/31/2006 03 -Village Employee Pension-folic Re s Function: 000 General Revenues Dept, 000 General Acct Class: MISC Miscellaneous Revenues Pension Fund Cont-Employee Miscellaneous Revenues REVENUE REPORT QUARTER ENDED 12131106 Original Bud. Amended Bud. OTD Actual 0.00 0.00 8,318.68 0.00 0.00 50,882.66 Page: 6 112512007 1:07 pm Encumb. YTD Unenc6al % Bud 0.00 -8,318,68 0.0 0,00 -50,882.66 0.0 General General Revenues 0.00 0.00 57,401.95 0.00 0.00 57,401.95 0.00 -57,401.95 0.0 0.00 -57,401.95 0.0 Revenues 0.00 0.00 57,401.95 i• 0.00 -57,401.95 0.0 i• txYtfVUI l UKt KtNUKI QUARTER ENDED 12/31/06 Page: 3 Village of Tequesta 112512007 For the Period: 101112006 to 12/31/2006 1:08 pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 03 -Village Employee Pension-folic Ex res Function: 000 General Revenues Dept. 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 12!31/2006 GJ 12131/06 - 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 9130/06 - $820.37 200.83 10/2612006 RE OCT 06 -REVERSE 163808 -SALEM FEE 711 TO 9130/06 - $820.37 -200.83 10/3112006 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 1011912006 GJ OCT O6 - ACORDIA LIABILITY INSURANCE OCT 06 TO OCT 07 - $3,356.80 821.40 10119/2006 GJ 10/12/06 - ACORDIA LIAB. INSURANCE OCT O6 TO OCT 07 821.40 $3,356.80 10119/2006 RE OCT 06 - REVERSE JE#162797 - ACORDIF OCT 06 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 1,020.41 0.00 -1,020.41 0.0 General 0.00 0.00 1,020.41 0.00 -1,020.41 0.0 General Revenues 0.00 0.00 1,020.41 0.00 -1,020.41 0.0 Function: 518 Pension Benefits ~epC. 165 Pension ct Class: 530 Operating Expenditures/Expense 5., 'ension Distributions/Refunds ~ 12/11/2006 GJ 12/11/06 -ROBERT NEIER TERMINATED 11!3/06 - REF OF PENSION CON TRIBS 2,048.78 $2,048.78 Pension Distributions/Refunds 0.00 0.00 2,048.78 0.00 -2,048.78 0.0 Operating ExpenditureslExpense 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 Benefts 0.00 0.00 2,048.78 0.00 -2,048.78 0.0 Expenditures 0.00 0.00 3,069.19 0.00 -3,069.19 0.0 •