Loading...
HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 10_11/06/2006 VILLAGE OF TEQUESTA PUBLIC SAFETY EMPLOYEES' PENSION TRUST FUND SCHEDULE OF INVESTMENT ACTIVITIES • FOR THE QUARTER ENDING SEPT 30, 2006 BALANCE BEGINNING GL BALANCE -June 30, 2006 $ 3,049,561.39 INCREASES CONTRIBUTIONS Employee -Fire 14,498.19 Employee -Police 7,157.11 Village -Fire 22,935.66 Village -Police 16,461.35 State of Florida -Fire -Premium Tax OS 67,742.22 State of Florida -Police -Premium Tax O5 65,700.10 194,494.63 INTEREST & DIVIDENDS Interest 18,661.92 Dividend 4,629.80 23,291.72 OTHER Return of Capital 173.20 Class Action Proceed -Carnival Corp 5.33 Change in Accrued Income (80.30) Gain/Loss on Sale of Investments (2,443.73) Rounding off to GL (6.36) UnRealized Gain/Loss on Investments 93,788.75 91,436.89 TOTAL INCREASES 309,223.24 • DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions Federal Withholding Tax 0.00 ADMINISTRATIVE EXPENSES Bogdahn Consulting (2,000.00) Misc. Charges (Fedex) Fee on Dividend Salem Trust -Fees (637.63) Business Services Connection (507.47) Rockwood Capital Management (4,049.70) FPPTA Membership Dues FPPTA Reg. Fee & Travel Exps Foreign Tax W/Held (23.30) Gabriel, Roeder Hanson, Perry & Jensen PA (2,017.24) (9,235.34) Due to General Fund -11.71 (11.71) TOTAL DEDUCTIONS (9,247.05) ENDING GL BALANCE -Sep 30, 2006 $ 3,349,537.58 Due to General Fund -Fedex (11.71) Salem Statement Balance -Sep 30, 2006 $ 3,349,549.29 • $ BALANCE SHEET QUARTER ENDED 9/30/06 Village of Tequesta Page: 1 10/24/2006 10:04 am As of: 9/30/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 -0.01 Acct Class: 101 Cash and Cash Equivalents _O.pl Acct Class: 103 Investments 135.100 Accrued Income 10,091.53 151.000 Investments 2,519,641.74 15 ] .020 Investments -Salem Bank 0.00 Acct Class: 103 Investments 2,529,733.27 Acct Class: 115 Accounts Receivable 115.000 Accounts Receivable l 8,971.37 115.001 Accounts Receivable -COBRA 0.00 115.102 Employer Contrib. Receivable 3,402.83 115.112 Employee Contrib. Receivables 2,151.01 Acct Class: 115 Accounts Receivable 24,525.21 Acct Class: 130 Due from Other Funds 131.001 Due from General Fund (001) 0.00 131.603 Due from Police Pension (603) 0.00 Acct Class: 130 Due from Other Funds 0.00 • Total Assets 2,554,258.47 Liabilities Acct Class: 202 Accounts Payable 202.000 Accounts Payable 0.00 202.005 945-Transfer 0.00 202.007 Pension Refunds Payable 0.00 Acct Class: 202 Accounts Payable 0.00 Acct Class: 204 Accrued liabilities 217.002 Fed Withholding Pay 0.00 Acct Class: 204 Accrued liabilities 0.00 Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) 52.15 207.602 Due to/fr - Pension/Gen (602) 0.00 207.603 Due to/fr Pension/Police (603) 0.00 Acct Class: 208 Due to Other Funds 52.15 Acct Class: 210 Due to Other Governments 208.201 PBC Impact Fees 0.00 Acct Class: 210 Due to Other Governments 0.00 Total Liabilities 52.15 ReservesBalances • Acct Class: 253 FB - Unreserved/iJndesignated 271.000 Fund Balance 2 240 747 05 , , . 299.000 Change In Fund Balance 313,459.27 BALANCE SHEET QUARTER ENDED 9/30/06 Village of Teyuesta Page: 2 10/24/2006 10:04 am As of: 9/30/2006 • Fund Type: 600 Trust and Agency Funds Fund: 601 -Village Employee Pension-Fire ReservesBalances Acct Class: 253 F/B - Unreserved/LJndesignated Total Reserves/Balances Total Liabilities & Balances • Balances 2,554,206.32 2,554,206.32 2,554,258.47 • INCOME STATEMENT QUARTER ENDED 9l30I06 Page: 1 10/24/2006 Village of Tequesta 10:07 am QTR: 4 QTD Amd. Bud. YTD Actual OTD Actual Fund: 601 -Village Emplovee Pension-Fire evenues Dept: 000 General Acct Class: 311 General Propertv Taxes 312.510 Fire Insurance Prem Tax 0.00 86,713.59 86,713.59 General Propertv Taxes 0.00 86,713.59 86,713.59 Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 51,387.53 13,999.52 361.102 Dividend Income 0.00 16,132.53 3,531.24 361.103 Money funds Dividends 0.00 0.00 0.00 Unrestricted Investment Earnin 0.00 67,520.06 17,530.76 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0.00 -9,553.42 -1,846.78 367.100 Unrealized gain/loss on invest 0.00 53,189.70 71,244.88 368.001 Pension Fund Cont-Employer 0.00 102,193.51 26,338.49 368.002 Pension Fund Cont-Employee 0.00 62,555.20 16,649.20 369.000 Other Miscellaneous Revenue 0.00 531.45 130.03 Miscellaneous Revenues 0.00 208,916.44 112,515.82 General 0.00 363,150.09 216,760.17 Revenues 0.00 363,150.09 216,760.17 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0.00 2,698.65 1,549.42 531.304 Recording Secy Service 0.00 876.25 389.74 531.307 Investment Services 0.00 19,916.00 5 159.16 • 531.309 Actuarial Services 0.00 4,849.59 , 0.00 534.300 Other Contractual Services 0.00 0.00 0.00 540.300 Travel & Per Diem 0.00 377.17 0.00 545.3001nsurance 0.00 2,489.12 0.00 549.300 Other Misc Chgs & Obligations 0.00 52.15 9.00 554.300 Books, Publ, Subs & Membership 0.00 174.08 0.00 554.600 Seminars & Training -Pensions 0.00 309.64 0.00 Operating Expenditures/Expense 0.00 31,742.65 7,107.32 General 0.00 31,742.65 7,107.32 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 Expenditures Net Effect for Fund Village Emplovee Pension-Fire 0.00 0.00 0.00 0.00 0.00 0.00 0.00 17,948.17 0.00 0.00 17,948.17 0.00 0.00 17,948.17 0.00 0.00 49,690.82 7,107.32 0.00 313,459.27 209,652.85 r~ REVENUE REPORT QUARTER ENDED 9/30/06 Village of Tequesta Forthe Period: 7/1/2006 to 913012006 Page: 1 10124/2006 10:09 am _ Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 601 -Village Employee Pension-Fire Revenues Dept: 000 General Acct Class: 311 General Property Taxes 312.510 Fire Insurance Prem Tax 09/0512006 CR Rcd From: STATE OF FLORIDA Ref ID: PRRM TAX DIST #4072489 67,742.22 Drawer: 1 MON2 Type: MISC 4412 09/2912006 GJ 9/29/06 -RECORD 2005 FIREFIGHTERS' SUPPLE. COMPENSATION TRUST 18,971.37 CK #407-435-109 Fire Insurance Prem Tax 0.00 0.00 86,713.59 0.00 -86,713.59 0.0 General Property Taxes 0.00 Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 07/3112006 GJ JUL 06 -INTEREST -SALEM PRO RATA $5,557.66 07/31/2006 GJ JUL O6 -REV JUN O6 ACCRUED INCOME SALEM PRO RATA $13,443.03 0713112006 GJ JUL O6 -ACCRUED INCOME SALEM PRO RATA $13,283.24 08/3112006 GJ AUG O6 -REV. JUL 06 ACCRUED INCOME SALEM -PRO RATA $13,283.24 08/31/2006 GJ AUG 06 -ACCRUED INCOME SALEM -PRO RATA $13,049.89 08/3112006 GJ AUG 06 -INTEREST SALEM -PRO RATA $6,625.65 0912912006 GJ SEP 06 -INTEREST -SALEM PRO RATA SHARE $6,478.61 09/29/2006 GJ SEP O6 -REVERSING AUG 06 ACC. INC. SALEM PRO RATA $13,049.89 09/29/2006 GJ SEP O6 -ACCRUED INCOME SALEM PRO RATA $13,362.73 Interest Income 0.00 361.102 Dividend Income 0713112006 GJ JUL O6 -DIVIDENDS -SALEM PRO RATA $1,177.10 0813112006 GJ AUG 06 -DIVIDENDS SALEM -PRO RATA $1,667.68 09/29/2006 GJ SEP O6 -DIVIDENDS -SALEM PRO RATA - $1,785.02 Dividend Income 0.00 36 . Money funds Dividends Money funds Dividends Unrestricted Investment Earnin Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0713112006 GJ JUL O6 -LOSS ON SALE OF INVEST 08/31/2006 GJ AUG O6 -GAIN ON SALE OF INVEST. 09/2912006 GJ SEP O6 -LOSS ON SALE OF INVEST Gain/Loss-Sale of Investments 367.100 Unrealized gainlloss on invest 07/3112006 GJ JUL O6 -UNREALIZED GAIN 08/31/2006 GJ AUG O6 -UNREALIZED GAIN 09/29/2006 GJ SEP 06 -UNREALIZED GAIN Unrealized gainlloss on invest 368.001 Pension Fund Cont-Employer 07/14/2006 PA VOT PENSION DEPOSIT-P/D 07/14/06 0712812006 PA VOT PENSION DEPOSITS-P/D 07/28/06 08/11/2006 PA VOT PENSION DEPOSITS-PID 08111/06 08/25/2006 PA VOT PENSION DEPOSIT-PID 08125/06 09/08/2006 PA VOT PENSION DEPOSITS-PID 09/08106 09/22/2006 PA VOT PENSION DEPOSIT-PID 09/22106 09/3012006 PA VOT PENSION DEPOSIT-P/D 09/30/06 Pension Fund Cont-Employer Pension Fund Cont-Employee 1412006 PA VOT PENSION DEPOSIT-PID 07/14/06 07/28/2006 PA VOT PENSION DEPOSITS-PID 07/28106 0.00 86,713.59 4,268.06 -10,335.00 10,201.53 -10,201.53 10,009.27 5,081.98 4,892.95 -10,009.27 10,091.53 0.00 -86,713.59 0.0 0.00 13,999.52 0.00 -13,999.52 0.0 903.97 1,279.14 1,348.13 0.00 3,531.24 0.00 -3,531.24 0.0 0.00 0.00 0.00 0.00 0.00 0.0 0.00 0.00 17,530.76 0.00 -17,530.76 0.0 SALEM PRO RATA ($2,151.28) -1,652.18 SALEM -PRO RATA - $2,225.24 1,706.76 SALEM PRO RATA - ($2,517.69) -1,901.36 0.00 0.00 -1,846.78 0.00 1,846.78 0.0 SALEM PRO RATA - $18,954.57 14,557.11 SALEM -PRO RATA $14,660.87 11,244.89 SALEM PRO RATA $60,173.31 45,442.88 0.00 0.00 71,244.88 0.00 -71,244.88 0.0 3,742.18 3,756.93 3,830.04 3,738.84 3,625.96 4,241.71 SETTING UP ACCOUNTS REC F OR FYE 0 3,402.83 0.00 0.00 26,338.49 0.00 -26,338.49 0.0 2,365.52 2,374.85 REVENUE REPORT QUARTER ENDED 9/30/06 Village of Tequesta For the Period: 711/2006 to 9/3012006 Page: 2 10/24/2006 10:09 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 601 -Village Employee Pension-Fire Revenues Dept: 000 General Acct Class: MISC Miscellaneous Revenues 08/11/2006 PA VOT PENSION DEPOSITS-P/D 08/11/06 2,421.06 08/25/2006 PA VOT PENSION DEPOSIT-P/D 08125/06 2,363.41 09/OS/2006 PA VOT PENSION DEPOSITS-P/D 09/08/06 2,292.06 09/22/2006 PA VOT PENSION DEPOSIT-P/D 09/22/06 2,681.29 09130/2006 PA VOT PENSION DEPOSIT-P1D 09/30/06 SETTING UP ACCOUNTS REC FOR FYE 0 2,151.01 Pension Fund Cont-Employee 0.00 0.00 16,649.20 0.00 -16,649.20 0.0 369.000 Other Miscellaneous Revenue 09/29/2006 GJ SEP O6 -RETURN OF CAPITAL SALEM -PRO RATA $178.53 134.83 09/29/2006 GJ SEP O6 -ADJ. GL BALANCE TO MATCH SALEM TRUST BALANCE -PRO RATA -4.80 $6.36 Other Miscellaneous Revenue 0.00 0.00 130.03 0.00 -130.03 0.0 Miscellaneous Revenues 0.00 0.00 112,515.82 0.00 -112,515.82 0.0 General 0.00 0.00 216,760.17 0.00 -216,760.17 0.0 Revenues 0.00 0.00 216,760.17 0.00 -216,760.17 0.0 • • EXPENDITURE REPORT QUARTER ENDED 9/30/06 Village of Tequesta For the Period: 71112006 to 913012006 Page: 1 10/24/2006 10:11 am - Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 01 -Village Employee Pension-Fire Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 08/07/2006 GJ AUG O6 - HANSON, PERRY &JENSEN SALEM PRO RATA SHARE $1,221.54 939.12 LEGAL SERVICE THRU 6/15/06 09/29/2006 GJ SEP 06 - HANSON, PERRY &JENSEN SALEM PRO RATA $795.70 610.30 LEGAL SERVICE THRU 9/15/06 Legal Services 0.00 0.00 1,549.42 0.00 -1,549.42 0.0 531.304 Recording Secy Service 08/0712006 GJ AUG O6 -BUSINESS SERVICES CONNEC- SALEM PRO RATA SHARE $281.93 216.75 MEETING 4118106 09/29/2006 GJ SEP 06 -BUSINESS SERVICES CONNECT SALEM -PRO RATA SHARE $225.54 172.99 MEETING ON 8/7/06 Recording Secy Service 0.00 0.00 389.74 0.00 -389.74 0.0 531.307 Investment Services 08/07/2006 GJ AUG O6 -SALEM FEE -PRO RATA SHARE 01/01/06 TO 03/31/06 $792.00 608.89 08/07/2006 GJ AUG 06 -SALEM FEE -PRO RATA SHARE 411106 TO 6/30/06 $637.37 490.01 08/07/2006 GJ AUG O6 - BOGDAHN CONSULTING QTR FEE 6130/06 -SALEM PRO RATA 1,537.60 $2000.00 08/07/2006 GJ AUG O6 - ROCKWOOD CAPITAL -MGT FEE FOR QTR ENDED 6/30106 -SALEM 3,113.41 PRO RATA SHARE $4,049.70 08107/2006 GJ AUG 06 -ADJ. DIFF. OF .26 CENTS TO SALEM FEE. CORR. AMT $637.63 NOT 0.20 $637.37 08/07/2006 RE AUG 06 -SALEM FEE -PRO RATA SHARE 01/01/06 TO 03/31/06 $792.00 -608.89 Rev. JE #157988 08131/2006 GJ AUG O6 -FOREIGN TAX WlHELD SALEM -PRO RATA $23.30 17.94 Investment Services 0.00 0.00 5,159.16 0.00 -5,159.16 0.0 531.309 Actuarial Services Actuarial Services 0.00 0.00 0.00 0.00 0.00 0.0 534.300 Other Contractual Services Other Contractual Services 0.00 0.00 0.00 0.00 0.00 0.0 5 Travel & Per Diem Travel & Per Diem 0.00 0.00 0.00 0.00 0.00 0.0 545.300 Insurance Insurance 0.00 0.00 0.00 0.00 0.00 0.0 549.300 Other Misc Chgs & Obligations 09/07/2006 GJ SEP O6 - PYMT DUE TO GEN FUND FOR UNITED SHIPPING SOLUTIONS 9.00 PENSION Other Misc Chgs 8 Obligations 0.00 0.00 9.00 0.00 -9.00 0.0 554.300 Books, Publ, Subs 8 Membership Books, Publ, Subs & Membership 0.00 0.00 0.00 0.00 0.00 0.0 554.600 Seminars & Training -Pensions Seminars & Training -Pensions 0.00 0.00 0.00 0.00 0.00 0.0 Operating Expenditures/Expense 0.00 0.00 7,107.32 0.00 -7,107.32 0.0 General 0.00 0.00 7,107.32 0.00 -7,107.32 0.0 Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 531.300 Professional Services Professional Services 0.00 0.00 0.00 0.00 0.00 0.0 531.307 Investment Services Investment Services 0.00 0.00 0.00 0.00 0.00 0.0 536.300 Pension DistributionslRefunds • Pension Distributions/Refunds 0.00 0.00 0.00 0.00 0.00 0.0 EXPENDITURE REPORT QUARTER ENDED 9/30/06 Villa e of Te uesta Page: 2 9 9 10/24/2006 For the Period: 71112006 to 9130/2006 10:11 am _ Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 01 -Village Employee Pension-Fire Expenditures Dept: 165 Pension Operating Expenditures/Expense 0.00 0.00 0.00 0.00 0.00 0.0 Pension 0.00 0.00 0.00 0.00 0.00 0.0 Expenditures 0.00 0.00 7,107.32 0.00 -7,107.32 0.0 • • BALANCE SHEET QUARTER ENDED 9/30/06 Village of Tequesta Page: 5 10/24/2006 ] 0:04 am As of: 9/30/2006 Balances • Fund Type: 600 Trust and Agency Funds Fund: 603 -Village Employee Pension-Polk 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 3,27 ] .20 151.000 Investments 816,544.82 151.020 Investments -Salem Bank 0.00 Acct Class: 103 Investments 819,816.02 Acct Class: 115 Accounts Receivable 115.001 Accounts Receivable -COBRA 0.00 115.102 Employer Contrib. Receivable 2,991.74 115.112 Employee Contrib. Receivables 1,300.76 Acct Class: 115 Accounts Receivable 4,292.50 Acct Class: 130 Due from Other Funds 131.001 Due from General Fund (001) 0.00 Acct Class: 130 Due from Other Funds 0.00 Total Assets 824,108.53 Liabilities Acct Class: 202 Accounts Payable 202.000 Accounts Payable 0.00 202.005 945-Transfer 0.00 202.007 Pension Refunds Payable 0.00 Acct Class: 202 Accounts Payable 0.00 Acct Class: 204 Accrued liabilities 217.002 Fed Withholding Pay 0.00 Acct Class: 204 Accrued liabilities 0.00 Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) 15.52 207.415 Due to/from Comm Dev. (415) 0.00 207.601 Due to/from Pension/Fire (601) 0.00 207.602 Due to/fr - Pension/Gen (602) 407.88 Acct Class: 208 Due to Other Funds 423.40 Total Liabilities ~ 423.40 ReservesBalances Acct Class: 253 FB - Uru-eserved/Undesignated 271.000 Fund Balance 656,510.66 299.000 Change In Fund Balance 167,174.47 Acct Class: 253 F/B - Unreserved/IJndesignated 823,685.13 • Total Reserves/Balances 823,685.13 • BALANCE SHEET QUARTER ENDED 9/30/06 Village of Tequesta Page: 6 10/24/2006 10:04 am As of: 9/30/2006 Balances Fund Type: 600 Trust and Agency Funds Total Liabilities & Balances 824,108.53 • Village of Tequesta INCOME STATEMENT QUARTER ENDED 9/30/06 Pape: 3 10124/2006 10:07 am QTR: 4 QTD Amd. Bud. YTD Actual QTD Actual Fund: 603 -Village Emplovee Pension-folic evenues Dept: 000 General Acct Class: 311 General Propertv Taxes 312.520 Casualty Insurance Premium Tax 0.00 65,700.10 65,700.10 General Propertv Taxes 0.00 65,700.10 65,700.10 Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 15,771.01 4,582.10 361.102 Dividend Income 0.00 4,817.66 1,098.56 361.103 Money funds Dividends 0.00 0.00 O.OC Unrestricted Investment Earnin 0.00 20,588.67 5,680.6E Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0.00 -2,852.09 -596.95 367.100 Unrealized gain/loss on invest 0.00 16,900.19 22,543.87 368.001 Pension Fund Cont-Employer 0.00 70,169.44 19,168.81 368.002 Pension Fund Cont-Employee 0.00 29,116.60 8,334.27 369.000 Other Miscellaneous Revenue 0.00 160.32 42.14 Miscellaneous Revenues 0.00 113,494.46 49,492.14 General 0.00 199,783.23 120,872.90 Revenues 0.00 199,783.23 120,872.90 Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0.00 802.64 467.82 531.304 Recording Secy Service 0.00 259.51 117.73 531.307 Investment Services 0.00 5,857.84 1,551.47 531.309 Actuarial Services 0.00 1,440.41 0.00 • 534.300 Other Contractual Services 0.00 0.00 0.00 540.300 Travel & Per Diem 0.00 110.06 0.00 545.3001nsurance 0.00 728.88 0.00 549.300 Other Misc Chgs & Obligations 0.00 15.52 2.71 554.300 Books, Publ, Subs & Membership 0.00 50.92 0.00 554.600 Seminars & Training -Pensions 0.00 90.36 0.00 Operating Expenditures/Expense 0.00 9,356.14 2,139.73 General 0.00 9,356.14 2,139.73 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 23,252.62 0.00 Operating ExpenditureslExpense 0.00 23,252.62 0.00 Pension 0.00 23,252.62 0.00 Expenditures 0.00 32,608.76 2,139.73 Net Effect for Fund Village Emplovee Pension-folic 0.00 167,174.47 118,733.17 Grand Total Net Effect: 0.00 696,869.75 389,558.23 t REVENUE REPORT QUARTER ENDED 9/30/06 Village of Tequesta For the Period: 7/112006 to 9/30/2006 Page: 5 10124/2006 10:09 am _ Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-folic Revenues Dept: 000 General Acct Class: 311 General Property Taxes 312.520 Casualty Insurance Premium Tax 09/05/2006 CR Rcd From: STATE OF FLORIDA Ref ID: PREM TAX DIST #4072489 65,700.10 Drawer: 1 MON2 Type: MISC 4413 Casualty Insurance Premium Tax 0.00 0.00 65,700.10 0.00 -65,700.10 0.0 General Property Taxes 0.00 0.00 65,700.10 0.00 -65,700.10 0.0 Acct Class: 361 Unrestricted Investment Earnin 361.100 Interestlncome 07/3112006 GJ JUL 06 -INTEREST -SALEM PRO RATA $5,557.66 1,289.60 07/31/2006 GJ JUL 06 -REV JUN O6 ACCRUED INCOME SALEM PRO RATA $13,443.03 -3,108.03 07131/2006 GJ JUL O6 -ACCRUED INCOME SALEM PRO RATA $13,283.24 3,081.71 08/31/2006 GJ AUG 06 -REV. JUL O6 ACCRUED INCOME SALEM -PRO RATA $13,283.24 -3,081.71 08/31/2006 GJ AUG O6 -ACCRUED INCOME SALEM -PRO RATA $13,049.89 3,040.62 08/31/2006 GJ AUG 06 -INTEREST SALEM -PRO RATA $6,625.65 1,543.67 09/29/2006 GJ SEP 06 -INTEREST -SALEM PRO RATA SHARE $6,478.61 1,585.66 09/29/2006 GJ SEP 06 -REVERSING AUG 06 ACC. INC. SALEM PRO RATA $13,049.89 -3,040.62 09/29/2006 GJ SEP 06 -ACCRUED INCOME SALEM PRO RATA $13,362.73 3,271.20 Interest Income 0.00 0.00 4,582.10 0.00 -4,582.10 0.0 361.102 Dividend Income 07/31/2006 GJ JUL 06 -DIVIDENDS -SALEM PRO RATA $1,177.10 273.13 08/31/2006 GJ AUG 06 -DIVIDENDS SALEM -PRO RATA $1,667.68 388.54 09129/2006 GJ SEP O6 -DIVIDENDS -SALEM PRO RATA - $1,785.02 436.89 Dividend Income 0.00 0.00 1,098.56 0.00 -1,098.56 0.0 Money funds Dividends Money funds Dividends 0.00 0.00 0.00 0.00 0.00 0.0 Unrestricted Investment Earnin 0.00 0.00 5,680.66 0.00 -5,680.66 0.0 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 07/31/2006 GJ JUL O6 -LOSS ON SALE OF INVEST SALEM PRO RATA ($2,151.28) -499.10 08/31/2006 GJ AUG 06 -GAIN ON SALE OF INVEST. SALEM -PRO RATA - $2,225.24 518.48 09/29/2006 GJ SEP 06 -LOSS ON SALE OF INVEST SALEM PRO RATA - ($2,517.69) -616.33 Gain/Loss-Sale of Investments 0.00 0.00 -596.95 0.00 596.95 0.0 367.100 Unrealized gainlloss on invest 07/31/2006 GJ JUL 06 -UNREALIZED GAIN SALEM PRO RATA - $18,954.57 4,397.46 08/31/2006 GJ AUG 06 -UNREALIZED GAIN SALEM -PRO RATA $14,660.87 3,415.98 09/29/2006 GJ SEP O6 -UNREALIZED GAIN SALEM PRO RATA $60,173.31 14,730.43 Unrealized gainlloss on invest 0.00 0.00 22,543.87 0.00 -22,543.87 0.0 368.001 Pension Fund Cont-Employer 07/14/2006 PA VOT PENSION DEPOSIT-P/D 07/14/06 2,458.36 07/28/2006 PA VOT PEN510N DEPOSITS-PID 07/28/06 2,519.44 08/11/2006 PA VOT PENSION DEPOSITS-PID 08/11/06 2,550.87 08/25/2006 PA VOT PENSION DEPOSIT-PID 08/25/06 2,691.70 09/08/2006 PA VOT PENSION DEPOSITS-P/D 09/08106 2,856.89 09/22/2006 PA VOT PENSION DEPOSIT-P/D 09/22/06 3,384.09 09/28/2006 GJ rlc d coopers pension contributions to correct accnt (genrl pension), they were -284.28 recrd'd as police contributions in error 0912812006 GJ rlc d coopers pension contributions to correct accnt (genrl pension), they were -284.28 recrd'd as police contributions in error 09/2812006 RE correcting typo on je # 162560- correct accnt (genrl pension), they were 284.28 recrd'd as police contributions in error 3012006 PA VOT PENSION DEPOSIT-P/D 09130/06 SETTING UP ACCOUNTS REC FOR FYE 0 2,991.74 Pension Fund Cont-Employer 0.00 0.00 19,168.81 0.00 -19,168.81 0.0 REVENUE REPORT QUARTER ENDED 9/30106 Village of Tequesta For the Period: 7/1/2006 to 9/30/2006 Page: 6 10124/2006 10:09 am Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-folic Revenues Dept: 000 General Acct Class: MISC Miscellaneous Revenues 368.002 Pension Fund Cont-Employee 07/14/2006 PA VOT PENSION DEPOSIT-P/D 07/14/06 1,068.85 07/28/2006 PA VOT PENSION DEPOSITS-PID 07128106 1,095.41 08/11/2006 PA VOT PENSION DEPOSITS-P/D 08/11/06 1,109.07 08/25/2006 PA VOT PENSION DEPOSIT-PID 08125/06 1,170.30 09/08/2006 PA VOT PENSION DEPOSITS-P/D 09/08106 1,242.13 09122/2006 PA VOT PENSION DEPOSIT-PID 09122/06 1,471.35 09/28/2006 GJ rlc d coopers pension contributions to correct accnt (genrl pension), they were -123.60 recrd'd as police contributions in error 09/28/2006 GJ r/c d coopers pension contributions to correct accnt (genrl pension), they were -123.60 recrd'd as police contributions in error 09/28/2006 RE correcting typo on je # 162560- correct accnt (genrl pension), they were 123.60 recrd'd as police contributions in error 09/30/2006 PA VOT PENSION DEPOSIT-PID 09/30/06 SETTING UP ACCOUNTS REC FOR FYE 0 1,300.76 Pension Fund Cont-Employee 0.00 0.00 8,334.27 0.00 -8,334.27 0.0 369.000 Other Miscellaneous Revenue 09/29/2006 GJ SEP O6 -RETURN OF CAPITAL SALEM -PRO RATA $178.53 43.70 09129/2006 GJ SEP 06 -ADJ. GL BALANCE TO MATCH SALEM TRUST BALANCE -PRO RATA -1.56 $6.36 Other Miscellaneous Revenue 0.00 0.00 42.14 0.00 -42.14 0.0 Miscellaneous Revenues 0.00 0.00 49,492.14 0.00 -49,492.14 0.0 General 0.00 0.00 120,872.90 0.00 -120,872.90 0.0 RP.~ues 0.00 0.00 120,872.90 0.00 -120,872.90 0.0 • EXPENDITURE REPORT QUARTER ENDED 9/30/06 Village of Tequesta For the Period: 7/1/2006 to 9/3012006 Page: 5 10/24/2006 10:11 am _ Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 603 -Village Employee Pension-folic Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 08/07/2006 GJ AUG O6 - HANSON, PERRY &JENSEN SALEM PRO RATA SHARE $1,221.54 282.42 LEGAL SERVICE THRU 6115/06 09/29/2006 GJ SEP 06 - HANSON, PERRY &JENSEN SALEM PRO RATA $795.70 185.40 LEGAL SERVICE THRU 9/15/06 Legal Services 0.00 0.00 467.82 0.00 -467.82 0.0 531.304 Recording Secy Service 08/07/2006 GJ AUG O6 -BUSINESS SERVICES CONNEC- SALEM PRO RATA SHARE $281.93 65.18 MEETING 4/18/06 09/29/2006 GJ SEP O6 -BUSINESS SERVICES CONNECT SALEM -PRO RATA SHARE $225.54 52.55 MEETING ON 8/7/06 Recording Secy Service 0.00 0,00 117.73 0.00 -117.73 0.0 531.307 Investment Services 08/0712006 GJ AUG 06 -SALEM FEE -PRO RATA SHARE 01101106 TO 03/31/06 $792.00 183.11 08/0712006 GJ AUG 06 -SALEM FEE -PRO RATA SHARE 411106 TO 6130106 $637.37 147.36 08/07/2006 GJ AUG O6 • BOGDAHN CONSULTING QTR FEE 6/30/O6 -SALEM PRO RATA 462.40 $2000.00 08/07/2006 GJ AUG 06 - ROCKWOOD CAPITAL -MGT FEE FOR QTR ENDED 6130/06 -SALEM 936.29 PRO RATA SHARE $4,049.70 08/07/2006 GJ AUG O6 -ADJ. DIFF. OF .26 CENTS TO SALEM FEE. CORR. AMT $637.63 NOT 0.06 $637,37 08/07/2006 RE AUG 06 -SALEM FEE -PRO RATA SHARE 01101/06 TO 03/31/06 $792.00 -183.11 Rev. JE #157988 08/3112006 GJ AUG 06 -FOREIGN TAX W/HELD SALEM -PRO RATA $23.30 5.36 Investment Services 0.00 0.00 1,551.47 0.00 -1,551.47 0.0 531.309 Actuarial Services Actuarial Services 0.00 0.00 0.00 0.00 0.00 0.0 534.300 Other Contractual Services Other Contractual Services 0.00 0.00 0.00 0.00 0.00 0.0 • 5 Travel & Per Diem Travel & Per Diem 0.00 0.00 0.00 0.00 0.00 0.0 545.300 Insurance Insurance 0.00 0.00 0.00 0.00 0.00 0.0 549.300 Other Misc Chgs 8 Obligations 09/07/2006 GJ SEP O6 - PYMT DUE TO GEN FUND FOR UNITED SHIPPING SOLUTIONS 2.71 PENSION Other Misc Chgs & Obligations 0.00 0.00 2.71 0.00 -2.71 0.0 554.300 Books, Publ, Subs & Membership Books, Publ, Subs & Membership 0.00 0.00 0.00 0.00 0.00 0.0 554.600 Seminars & Training -Pensions Seminars & Training -Pensions 0.00 0.00 0.00 0.00 0.00 0.0 Operating Expenditures/Expense 0.00 0.00 2,139.73 0.00 -2,139.73 0.0 General Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 531.300 Professional Services Professional Services 531.307 Investment Services Investment Services 536.300 Pension Distributions/Refunds • Pension Distributions/Refunds 0.00 0.00 2,139.73 0.00 -2,139.73 0.0 0.00 0.00 0.00 0.00 0.00 0.0 0.00 0.00 0.00 0.00 0.00 0.0 0.00 0.00 0.00 0.00 0.00 0.0 EXPENDITURE REPORT QUARTER ENDED 9/30106 Village of Tequesta For the Period: 711/2006 to 9/30/2006 Page: 6 1012412006 10:11 am _ Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud mow - vmayc unNivycc rcnaivirr ~n~ Operating ExpenditureslExpense 0.00 0.00 0.00 0.00 0.00 0.0 Pension Expenditures 0.00 0.00 0.00 0.00 0.00 2,139.73 0.00 0.00 0.0 0.00 -2,139.73 0.0 i• i•