Loading...
HomeMy WebLinkAboutDocumentation_Pension General_Tab 12_02/02/2009REVENUEIEXPENDITURE REPORT For Qtr Ended 12/31/08 Page: 1 Villa a of Te uesta 9 4 1/23/2009 For the Period: 10/112008 to 12/31/2008 11:07 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 Earnin 361.100 Interest Income 10/31/2008 GJ Oct 08 -Interest Salem Trust 2,541.15 $2,541.15 10/31/2008 GJ Oct 08 -Rvs Sep 08 Acc. Income -Salem -5,074.25 $5,074.25 10/3112008 GJ Oct 08 -Acc. Income Salem Trust 3,826.19 $3,826.19 11/30/2008 GJ Nov 08 Rvs Oct OS Acc. Income Salem Trust -3,826.19 $3,826.19 11/3012008 GJ Nov OS -Acc. Income Salem Trust 4,051.30 $4,051.30 11130/2008 GJ Nov OS - To record Interest Salem Trust 1,603.67 $1,603.67 12/31/2008 GJ Dec 08 Rvs. Nov 08 Acc. Income Salem Trust -4,051.30 $4,051.30 12/31/2008 GJ Dec 08 -Acc Income Salem Trust 5,078.73 $5,078.73 12/31/2008 GJ Dec 08 -Interest Salem Trust 586.60 $586.60 Interest Income 0.00 0.00 4,735.90 1,614.03 0.00 -0,735.90 0.0 361.102 Dividend/Distributions 10/31/2008 GJ Oct08-Dividends Salem Trust 1,204.75 $1,204.75 1113012008 GJ Nov O8 - To record Dividends Salem Trust 1,032.25 $1,032.25 12131/2008 GJ Dec OS -Dividends Salem Trust 1,511.81 %1,511.81 Dividend/Distributions 0.00 0.00 3,748.81 1,511.81 0.00 -3,748.81 0.0 UnrestrictedlnvestmentEamin 0.00 0.00 8,484.71 3,125.84 0.00 -8,484.71 0.0 Acct Class: 367 Investment income 367.000 GainlLoss-Sale of Investments 10/31/2008 GJ Oct 08 -Sale of Invest -Loss Salem Trust 66,013.21 10/31/2008 GJ Oct OS -Sale of Invest -Loss Salem Trust -78,669.75 11/30/2008 GJ Nov 08 -Sale of Invest -Loss Salem Trust 64,660.57 11/30/2008 GJ Nov O8 -Sale of Invest -Loss Salem Trust -65,654.48 12/31/2008 GJ Dec OS -Sale of Invest- Loss Salem Trust 108,033.72 1213112008 GJ Dec 08 -Sale of Invest -Loss Salem Trust -109,770.39 GainlLoss-Sale of Investments 0.00 0.00 -15,387.12 -1,736.67 0.00 15,387.12 0.0 367.100 Unrealized gain/loss on invest 10/31/2008 GJ Oct 08 -Unrealized loss Salem Trust -81,836.54 1113012008 GJ Nov 08 Unrealized Loss Salem Trust -19,825.59 $19,825.59 12131/2008 GJ Dec 08 -Unrealized Gain Salem Trust 20,884.55 $20,884.55 Unrealized gain/loss on invest 0.00 0.00 -80,777.58 20,884.55 0.00 80,777.58 0.0 Investment income 0.00 0.00 -96;164.70 19,147.88 0.00 96,164.70 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 10/1712008 GJ VOT PENSION DEPOSIT 10117/08 4,279.44 10/3112008 GJ VOT PENSION DEPOSIT 10131/08 5,311.18 11/14/2008 GJ VOT PENSION DEPOSIT 11114108 5,307.47 11/26/2008 GJ VOT PENSION DEPOSIT 11/26/08 5,330.43 12/12/2008 GJ VOT PENSION DEPOSIT 12/12/08 5,311.37 1212312008 GJ VOT PENSION DEPOSIT 12/23/08 5,338.86 Pension Fund Cont-Employer 133,000.00 133,000.00 30,878.75 10,650.23 0.00 102,121.25 23.2 368.002 Pension Fund Cont-Employee 10/17/2008 GJ VOT PENSION DEPOSIT 10/17108 2,654.74 10131/2008 GJ VOT PENSION DEPOSIT 10/31108 3,294.78 11/14/2008 GJ VOT PENSION DEPOSIT 11/14/08 3,292.47 11/2612008 GJ VOT PENSION DEPOSIT 11/26/08 3,306.72 1211212008 GJ VOT PENSION DEPOSIT 12112/08 3,294.90 12/23/2008 GJ VOT PENSION DEPOSIT 12123108 3,311.95 Pension Fund Cont-Employee 82,500.00 82,500.00 19,155.56 6,606.85 0.00 63,344.44 23.2 REVENUEIEXPENDITURE REPORT For Qtr Ended 12/31/08 Page: 2 Village of Tequesta 1123/2009 For the Period: 10/1/2008 to 12131/2008 1 1:07 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 602 - VillageEmployee Pension-Gen Revenues Dept: 000 General Pension Contributions 215,500.00 215,500.00 50,034.31 17,257.08 0.00 165,465.69 23.2 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 11/30/2008 GJ NOV 08 -FOREIGN TAX REFUND SALEM TRUST 5.41 $5.41 12/23/2008 GJ NOV 08 -FOREIGN TAX REFUND SALEM TRUST 5.41 $5.41 12/23/2008 RE NOV O8 -FOREIGN TAX REFUND SALEM TRUST -5.41 $5.41 Other Miscellaneous Revenue 0.00 0.00 5.41 0.00 0.00 -5.41 0.0 Miscellaneous Revenues 0.00 0.00 5.41 0.00 0.00 -5.41 0.0 General 215,500.00 215,500.00 -37,640.27 39,530.80 0.00 253,140.27 -17.5 Revenues 215,500.00 215,500.00 -37,640.27 39,530.80 0.00 253,140.27 -17.5 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 1110512008 GJ CK #1143 HANSON, PERRY & JENSEN LE SERVICES THRU SEP 15, 2008 - $449.00, 481.56 THRU SEP 30- $538.75, OCT 15- $481.56 12/10/2008 GJ Ck #1153 -Hanson, Perry & Jensen Inv #62749 -legal services thru 1,501.84 11115108 Legal Services 7,000.00 7,000.00 1,983.40 1,501.84 0.00 5,016.60 28.3 531.304 Recording Secy Service 10/14/2008 GJ CK #1142 -BUSINESS SERVICES CONNE INV #8-79 - $254.85 -OFFICE WORK FOR 254.85 WEEK ENDED OCT 3 & 10, 2008 1110412008 GJ CK #1149 -BUSINESS SERVICES CONNE INV #8-81 - $161.41 -OFFICE WORK FOR 161.41 WEEK ENDED OCT 17 & 24, 2008 11112/2008 GJ CK #1150 Business Services Conn inv#8-88 Office work for 305.82 wle 10131 & 11107/08 11126/2008 GJ CK#1151 -Business Services Conn Inv #8-91 - $254.85 for Office Work 254.85 W/E 11114 & 21, 2008 1113012008 GJ CK #1158 -Business Services Conn Inv #8-104 - $254.85 for Office Work 254.85 W/E 12/12 & 12/19108 12/10/2008 GJ Ck #1154 Business Services Conn Office work w/e 11/21 & 12/5/08 254.85 $254.85 12/1012008 GJ Ck #1156 -Business Services Conn Attend gtrly meeting & prep minutes 348.29 for meeting on 11/3/08 - $348.29 Recording Secy Service 7,580.00 7,580.00 1,834.92 603.14 0.00 5,745.08 24.2 Actuarial Services 8,000.00 8,000.00 0.00 0.00 0.00 8,000.00 0.0 Travel & Per Diem 2,870.00 2,870.00 0.00 0.00 0.00 2,870.00 0,0 545.300 Insurance 10/01/2008 GJ CK #1141 - GEHRING GROUP ANNUAL PF 10/01/08 - 9/30/09 FEDUCIARY LIABILITY 820.41 INSURANCE Insurance 1,000.00 1,000.00 820.41 0.00 0.00 179.59 82.0 Other Misc Chgs & Obligations 500.00 500.00 0.00 0.00 0.00 500.00 0.0 554.300 Books, Publ, Subs & Membership 11/3012008 GJ CK #1157 - FPPTA Membership Fee for 2009 600.00 $600.00 Books, Publ, Subs & Membership 600.00 600.00 600.00 0.00 0.00 0.00 100.0 Seminars & Training -Pensions 1,000.00 1,000.00 0.00 0.00 0.00 1,000.00 0.0 Operating Expenditures/Expense 28,550.00 28,550.00 5,238.73 2,104.98 0.00 23,311.27 18.3 Acct Class: 531 Investment Expense Investment Services 23,000.00 23,000.00 0.00 0.00 0.00 23,000.00 0.0 Investment Expense 23,000.00 23,000.00 0.00 0.00 0.00 23,000.00 0.0 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 11/05/2008 GJ NOVEMBER 08 -WIRE FEES TO TRANSFE FUNDS TO SUN AMERICAN BANK FROM ; 10.00 TRUST ON 11/05/08 $10.00 Bank Charges 230.00 230.00 10.00 0.00 0.00 220.00 4.3 Excess of additions over deduc 163,720.00 163,720.00 0.00 0.00 0.00 163,720.00 0.0 REVENUEIEXPENDITURE REPORT For Qtr Ended 12/31/08 Page: 3 Village of Tequesta 1/23/2009 For the Period: 101112008 to 12131/2008 11:07 am Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 602 -VillageEmployee Pension-Gen Expenditures Other Financing Sources & Uses 163,950.00 163,950.00 10.00 0.00 0.00 163,940.00 0.0 General 215,500.00 215,500.00 5,248.73 2,104.98 0.00 210,251.27 2.4 Expenditures 215,500.00 215,500.00 5,248.73 2,104.98 0.00 210,251.27 2.4 Net Effect for VillageEmployee Pension-Gen 0.00 0.00 -42,889.00 37,425.82 0.00 42,889.00 Change in Fund Balance: -42,889.00