The URL can be used to link to this page

Home My WebLink AboutDocumentation_Pension General_Tab 16_02/01/2010REVENUEIEXPENDITURE REPORT ForOtrEnded 12/31/09 Village of Tequesta For the Period: 101112009 to 12/3112009 Page: 4 1 /1 912 0 1 0 2:37 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud Fund Type: 600 Trust and Agency Funds Fund: 602 - V illageEmployee Pension-Gen Revenues Function: 000 General Revenues Dept: 000 Gen eral Acct Class: 361 Unrestricted Investment Earnin 361.100 InteresUlnvestment Earnings 10131/2009 GJ Oct 09 -Interest 1013112009 GJ Oct 09 Rvs Sep 09 Accrued Income 1013112009 GJ Oct 09 Rvs Sep 09 Accrued Income 1013112009 RE Rvs#237916 -Rvs Sep 09 Accrued Income 10/3112009 RE Rvs#237916 -Rvs Sep 09 Accrued Income 1013112009 GJ Oct 09 Rvs Sep 09 Acc Income 10/3112009 GJ Oct 09 Acc Income 1013112009 GJ Oct 09 Rvs Sep 09 Acc Income 10/3112009 GJ Oct 09 -Acc Income InYI 11/3012009 GJ Nov091nterest 11/3012009 GJ Nov 09 Rus Oct 09 Acc Income 11/30/2009 GJ Nov 09 Acc Income 11/30/2009 GJ Nov 09 Rvs Oct 09 Acc Income 11/30/2009 GJ Nov 09 Acc Income 11/30/2009 GJ Nov 09 -Interest 11/30/2009 RE Nov 09 Rvs Oct 09 Acc Income 1113012009 GJ Nov 09 Rvs Oct 09 Acc Income 1213112009 GJ Dec 09 -Interest 12131/2009 GJ Dec 09 Rvs Nov 09 Acc Income 1213112009 GJ Dec 09 -Acc Income 12131/2009 GJ Dec091nterest 12/31/2009 GJ Dec 09 Acc Income 12131/2009 GJ Dec 09 Rvs Nov 09 Acc Income Interestllnvestment Earnings 361.102 Dividend/Distributions 10131/2009 GJ Oct 09 -Dividends 11130/2009 GJ Nov 09 -Dividends 12/3112009 GJ Dec 09 -Dividends 1213112009 GJ Dec 09 -Dividend Dividend/Distributions Unrestricted Investment Earnin Acct Class: 367 Investment income 367.000 GainlLoss-Sale of Investments 1013112009 GJ Oct 09 -Sale of Invest -Loss 10131/2009 GJ Oct 09 -Sale of Invest -Loss 1113012009 GJ Nov 09 -Sale of invest 11/30/2009 GJ Nov 09 -Sale of invest 1213112009 GJ Dec 09 -Sale of Invest -Loss 12/3112009 GJ Dec 09 -Sale of Invest -Loss f 2!31/2009 GJ Dec 09 -Sale of Invest 12/31/2009 GJ Dec 09 -Sale of Invest Gain/Loss-Sale of Investments 367.100 Unreali zed gain/loss on invest 10131/2009 GJ Oct 09 -Unrealized loss 1013112009 GJ Oct 09 -Unrealized loss 10/3112009 GJ Oct 09 Unrealized loss 10/3112009 RE Rvs#237957 -Oct 09 -Unrealized loss 11/30/2009 GJ Nov 09 Unrealized gain 11/30/2009 GJ Nov 09 Unrealized gain 12/31/2009 GJ Dec 09 -Unrealized Gain from Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust InYI fund -Salem Trust Salem Trust Salem Trust Salem Trust Salem Salem Trust Salem Trust Salem Salem Trust Salem Trust 1,756.62 $1,756.62 -5,189.02 5,125.16 5,189.02 -5,125.16 -5,189.02 5,125.16 -78.69 78.71 2,378.49 $2,378.49 -5,125.16 $5,125.16 4,475.44 $4,475.44 -78.71 $78.71 172.35 $172.35 0.02 $.02 78.71 $78.71 -78.71 0.02 -172.35 218.85 662.46 $662.46 5,481.61 -4,475.44 0.00 0.00 5,230.36 0.00 -5,230.36 0.0 from Salem Trust 821.93 $821.93 Salem Trust 1,264.30 $1,264.30 Salem Trust 285.89 Salem Trust 1,380.12 $1,380.12 0.00 0.00 3,752.24 0.00 -3,752.24 0.0 0.00 0.00 8,982.60 0.00 -8,982.60 0.0 Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust 0.00 Salem Trust Salem Trust Salem Trust Salem Trust Salem Trust Int'I Fund -Salem Trust Salem Trust 0.00 13,292.16 -13,323.31 191,370.25 189,067.47 15,716.29 -15,784.56 -69,220.67 69,322.22 2,304.91 0.00 -2,304.91 0.0 -14,210.50 -3,542.07 -3,542.07 3,542.07 36,576.68 5,233.08 $5,233.08 2,546.11 REVENUEIEXPENDITURE REPORT ForOtrEnded 12/31/09 Page: 5 Village of Tequesta 1119/2010 For the Period: 10/112009 to 12/3112009 2:37 pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund Type: 600 Trust and Agency Funds Fund: 602 - VillageEmployee Pension-Gen Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 367 Investment income 1213112009 GJ Dec 09 Unrealized Gain Salem Trust 4,909.69 $4,909.69 Unrealized gainlloss on invest 0.00 0.00 31,512.99 0.00 -31,512.99 0.0 Investment income 0.00 0.00 33,817.90 0.00 -33,817.90 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 1011512009 GJ VOT PENSION DEPOSIT 10115/09 4,161.39 10/2912009 GJ VOT PENSION DEPOSIT 10129109 5,904.60 11/12/2009 GJ VOT PENSION DEPOSIT 11112/09 5,906.66 11/25/2009 GJ VOT PENSION DEPOSIT P/D 11125109 5,904.11 12/10/2009 GJ VOT PENSION DEPOSIT 12110109 5,907.20 12123/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/23/1 5,906.42 Pension Fund Cont-Employer 164,500.00 164,500.00 33,690.38 0.00 130,809.62 20.5 368.002 Pension Fund Cont-Employee 10115/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 11/12109 3,664.18 11/2512009 GJ VOT PENSION DEPOSIT PID 11/25/09 3,662.60 12/10/2009 GJ VOT PENSION DEPOSIT 12110109 3,664.52 12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/2311 3,664.03 Pension Fund Cont-Employee 91,700.00 91,700.00 20,899.75 0.00 70,800.25 22.8 Pension Contributions 256,200.00 256,200.00 54,590.13 0.00 201,609.87 21.3 General 256,200.00 256,200.00 97,390.63 0.00 158,809.37 38.0 General Revenues 256,200.00 256,200.00 97,390.63 0.00 158,809.37 38.0 Revenues 256,200.00 256,200.00 Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 11/0212009 FA CK#1226 Perry 8 Jensen -Legal services fy10. Inv#63369 11102/2009 GJ CK#1226 Perry and Jensen -Legal services fy10 Inu#63369 11/02/2009 RE Rvs#234634 - CK#1226 Perry & Jensen Legal services fy10. Inv#63369 12/0712009 RE Rvs#237361 - CK#1232 Perry & Jensen Legal Services - Inv#63414 12/07/2009 GJ CK#1232 Perry & Jensen Legal Services - Inv#63414 12115/2009 GJ CK#1234 -Perry & Jensen Legal Services Inv#63413 Legal Services 11,700.00 11,700.00 531.304 Recording Secy Service 10/2912009 GJ CK#1227 -Business Services Conn Inv#9-133 Office work forwle 11/1212009 GJ CK#1228 -Business Services Conn Inv#9-137 Office work forwle 11/25/2009 GJ CK#1229 -Business Services Con Inv#9-144 Office work forwle 12/0712009 GJ CK#1233 -Business Services Conn Inv#9-142 Attend gtrly meeting on 1211012009 GJ CK#1231 -Business Services Conn Inv#9-150 -Office work for 1212312009 GJ CK#1235 -Business Services Conn Inv#9-153 Office work for w/e Recording Secy Service 8,600.00 8,600.00 Actuarial Services 5,500.00 5,500.00 97,390.63 115.75 $115.75 115.75 $115.75 -115.75 $115.75 -2,770.05 $2,770.05 2,770.05 $2,770.05 1,659.05 $1,659.05 1,774.80 267.60 10116 and 10123/09 267.60 10130/09 and 1116/09 267.60 11113 and 11120/09 356.80 1112109 & prepare minutes 267.60 wle 11127 and 12/04/09 267.60 12111 and 12118!09 1,694.80 0.00 0.00 158,809.37 38.0 0.00 9,925.20 15.2 0.00 6,905.20 19.7 0.00 5,500.00 0.0 REVENUEIEXPENDITURE REPORT For Qtr Ended 12131109 Village of Tequesta For the Period: 1011/2009 to 12131/2009 Page: 6 1119/2010 2:37 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud Fund Type: 600 Trust and Agency Funds Fund: 602 -VillageEmployee Pension-Gen Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense Travel & Per Diem 2,200.00 2,200.00 0.00 0.00 2,200.00 0.0 545.300 Insurance 10/26/2009 GJ CK#1222 -Fiduciary liability insurance policy for period 1011109 to 1011/10 876.07 Insurance 820.00 820.00 876.07 0.00 -56.07 106.8 549.300 Other Misc Chgs & Obligations 12/3112009 GJ Dec 09 - ADR Issuer Fee Salem 0.83 Other Misc Chgs & Obligations 250.00 250.00 0.83 0.00 249.17 0.3 554.300 Books, Publ, Subs & Membership 1210712009 GJ CK#1230 - FPPTA Membership fee for year 2010 600.00 $600 Books, Publ, Subs & Membership 800.00 800.00 600.00 0.00 200.00 75.0 Seminars & Training -Pensions 1,000.00 1,000.00 0.00 0.00 1,000.00 0.0 Operating ExpenditureslExpense 30,870.00 30,870.00 4,946.50 0.00 25,923.50 16.0 Acct Class: 531 Investment Expense Investment Services 19,000.00 19,000.00 0.00 0.00 19,000.00 0.0 Investment Expense 19,000.00 19,000.00 0.00 0.00 19,000.00 0.0 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 12/31/2009 GJ Dec 09 -Wire fees to transfer funds to Sun American Bank 10.00 from Salem to Gen Empl Acct Bank Charges 200.00 200.00 10.00 0.00 190.00 5.0 Excess of additions over deduc 206,130.00 206,130.00 0.00 0.00 206,130.00 0.0 Other Financing Sources & Uses 206,330.00 206,330.00 10.00 0.00 206,320.00 0.0 General 256,200.00 256,200.00 4,956.50 0.00 251,243.50 1.9 General Revenues 256,200,00 256,200.00 4,956.50 0.00 251,243.50 1.9 Expenditures 256,200.00 256,200.00 4,956.50 0.00 251,243.50 1.9 Net Effect for VillageEmployee Pension-Gen Change in Fund Balance: 0.00 0.00 92,434.13 92,434.13 0.00 -92,434.13