Loading...
HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 10_08/03/2009REVENUEIEXPENDITURE REPORT For the Period Ending 6130109 Page: 1 7/20/2009 Village of Tequesta 9:05 am For the Period: 101112008 to 6/3012009 Original Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 601 -Village Employee Pension-Fire Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 0.00 36,721.23 0.00 0.00 -36,721.23 0.0 361.102 DividendlDistributions 0.00 0.00 14,649.47 0.00 0.00 -14,649.47 0.0 Unrestricted Investment Eamin 0.00 0.00 51,370.70 0.00 0.00 -51,370.70 0.0 Acct Class: 367 Investment income 367.000 Gain/Loss-Saie of Investments 0.00 0.00 -29,886.31 0.00 0.00 29,886.31 0.0 367.100 Unrealized gainlloss on invest 0.00 0.00 -312,174.99 0.00 0.00 312,174.99 0.0 Investment income 0.00 0.00 -342,061.30 0.00 0.00 342,061.30 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 0.00 131,200.00 103,191.61 10,790.33 0.00 28,008.39 78.7 368.002 Pension Fund Cont-Employee 0.00 68,000.00 48,813.45 5,104.22 0.00 19,186.55 71.8 Pension Contributions 0.00 199,200.00 152,005.06 15,894.55 0.00 47,194.94 76.3 General 0.00 199,200.00 -138,685.54 15,894.55 0.00 337,885.54 -69.6 Revenues 0.00 199,200.00 -138,685.54 15,894.55 0.00 337,885.54 -69.6 Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0.00 6,000.00 6,497.71 619.75 0.00 -497.71 108.3 531.304 Recording Secy Service 0.00 5,600.00 3,968.54 414.99 0.00 1,631.46 70.9 531.309 Actuarial Services 0.00 6,000.00 8,496.35 5,525.79 0.00 -2,496.35 141.6 540.300 Travel & Per Diem 0.00 900.00 481.96 0.00 0.00 418.04 53.6 545.3001nsurance 0.00 2,500.00 2,415.27 0.00 0.00 84.73 96.6 549.300 Other Misc Chgs & Obligations 0.00 1,000.00 750.00 0.00 0.00 250.00 75.0 554.300 Books, Publ, Subs & Membership 0.00 550.00 700.00 0.00 0.00 -150.00 127.3 554.600 Seminars & Training -Pensions 0.00 300.00 385.00 0.00 0.00 -85.00 128.3 Operating Expenditures/Expense 0.00 22,850.00 23,694.83 6,560.53 0.00 -844.83 103.7 Acct Class: 531 Investment Expense 531.307 Investment Services 0.00 32,000.00 11,706.43 0.00 0.00 20,293.57 36.6 Investment Expense 0.00 32,000.00 11,706.43 0.00 0.00 20,293.57 36.6 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 0.00 120.00 68.48 5.00 0.00 51.52 57.1 590.600 Excess of additions over deduc 0.00 144,230.00 0.00 0.00 0.00 144,230.00 0.0 Other Financing Sources & Uses 0.00 144,350.00 68.48 5.00 0.00 144,281.52 0.0 General 0.00 199,200.00 35,469.74 6,565.53 0.00 163,730.26 17.8 Expenditures 0.00 199,200.00 35,4&9.74 6,565.53 0.00 163,730.26 17.8 Net Effect for Village Employee Pension-Fire 0.00 0.00 -174,155.28 9,329.02 0.00 174,155.28 0.0 Change in Fund Balance: -174,155.28 REVENUEIEXPENDITURE REPORT For the Period Ending 6130/09 Page: 4 712012009 Village of Tequesta 9:05 am For the Period: 10/1/2008 to 6/3012009 Ori final Bud. Amended Bud. YTD Actual CURR MTH Encumb. YTD UnencBal % Bud Fund: 603 -Village Employee Pension-folic Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 0.00 13,541.35 0.00 0.00 -13,541.35 0.0 361.102 Dividend/Distributions 0.00 0.00 5,419.08 0.00 0.00 -5,419.08 0.0 Unrestricted Investment Earnin 0.00 0.00 18,960.43 0,00 0.00 -18,960.43 0.0 Acct Class: 367 Investment income 367,000 GainlLoss-Sale of Investments 0.00 0.00 -11,088.81 0,00 0.00 11,088.81 0.0 367.100 Unrealized gainlloss on invest 0.00 0.00 -114,636.29 0.00 0.00 114,636.29 0,0 Investment income 0.00 0.00 -125,725.10 0.00 0.00 125,725.10 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 0.00 97,700.00 60,185.30 6,085.74 0.00 37,514.70 61.6 368.002 Pension Fund Cont-Employee 0.00 42,500.00 26,167.53 2,645.97 0.00 16,332.47 61.6 Pension Contributions 0.00 140,200.00 86,352.83 8,731.71 0.00 53,847.17 61.6 General 0.00 140,200.00 -20,411.84 8,731.71 0.00 160,611.84 -14.6 Revenues 0.00 140,200.00 -20,411.84 8,731.71 0.00 160,611.84 -14.6 Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0.00 2,100.00 2,403.28 230.50 0.00 -303.28 114.4 531.304 Recording Secy Service 0.00 1,850.00 1,470.21 154.17 0.00 379.79 79.5 531.309 Actuarial Services 0.00 2,000.00 3,157.65 2,055.21 0.00 -1,157.65 157.9 540.300 Travel 8 Per Diem 0.00 900.00 413.33 0.00 0.00 486.67 45.9 545.3001nsurance 0.00 1,000.00 902.29 0.00 0.00 97.71 90.2 549.300 Other Misc Chgs & Obligations 0.00 400.00 750.00 0.00 0.00 -350.00 187.5 554.300 Books, Publ, Subs & Membership 0.00 550.00 700.00 0.00 0.00 -150.00 127.3 554.600 Seminars & Training -Pensions 0.00 300.00 385.00 0.00 0.00 -85.00 128.3 Operating ExpenditureslExpense 0.00 9,100.00 10,181.76 2,439.88 0.00 -1,081.76 111.9 Acct Class: 531 Investment Expense 531.307 Investment Services 0.00 10,700.00 4,337.41 0.00 0.00 6,362.59 40.5 Investment Expense 0.00 10,700.00 4,337.41 0.00 0.00 6,362.59 40.5 Acct Class: 590 Other Financing Sources & Uses 549.391 Bank Charges 0.00 40.00 68.47 5.00 0.00 -28.47 171.2 590.600 Excess of additions over deduc 0.00 120,360.00 0.00 0.00 0.00 120,360.00 0.0 Other Financing Sources & Uses 0.00 120,400.00 68.47 5.00 0.00 120,331.53 0.1 General 0.00 140,200.00 14,587.64 2,444.88 0.00 125,612.36 10.4 Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 536.300 Pension Distributions/Refunds 0.00 0.00 12,267.59 0.00 0.00 -12,267.59 0.0 Operating ExpenditureslExpense 0.00 0.00 12,267.59 0.00 0.00 -12,267.59 0.0 Pension 0.00 0.00 12,267.59 0.00 0.00 -12,267.59 0.0 Expenditures 0.00 140,200.00 26,855.23 2,444.88 0.00 113,344.77 19.2 Net Effect for Village Employee Pension-folic 0.00 0.00 -47,267.07 6,286.83 0.00 47,267.07 0.0 Change in Fund Balance: -47,267.07 Grand Total Net Effect: 0.00 0.00 -160,627.23 26,192.69 0.00 160,627.23