Loading...
HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 10_05/05/2008 VILLAGE OF TEQUESTA PUBLIC SAFETY EMPLOYEES' PENSION TRUST FUND RECONCILIATION OF GENERAL LEDGER WITH SALEM TRUST STATEMENTS FOR THE 2ND QUARTER ENDING MAR 31, 2008 • GENERAL LEDGER BALANCES -DEC 31, 2007 Investments -Salem Trust -Fire BALANCE $ 3 232 01 Accrued Income -Salem Trust -Fire , , 8.32 $ 11 66 , 2.79 Investments -Salem Trust -Police $ 1,133,679.67 Accrued Income -Salem Trust -Police $ 4,091.35 INCREASES CONTRIBUTIONS Employer -Fire 28,149.10 Employer -Police 19,988.33 48,137.43 Employee -Fire 17,793.73 Employee -Police 8,690.57 26, 484.30 INTEREST & DIVIDENDS Interest 21, 864.61 Dividend 5,303.04 Changes in Accrued Income (198~94Z 26, 968.7 i OTHER Misc. Revenue Gain/Loss on Sale of Investments (17,036.09) UnRealized Gain/Loss on Investments (254,882.36) • (271,918.45) TOTAL INCREASES (170,328.01) DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions 0.00 ADMINISTRATIVE EXPENSES Hanson, Perry & Jensen PA (771.40) Business Services Connection (237.86) Salem -Fees (1,011.57) Bogdahn Consulting (2,000.00) Rockwood Capital Management (5,726.82) (9,747.65) TOTAL DEDUCTIONS (9,747.65) R ounding difference 0.02 GENERAL LEDGER BALANCES -Mar 31, 2008 $ 4 20 , 1,376.49 Bal. as per Salem Statement -Mar 31, 2008 a,2o1,37s.a9 $ 4,201,376.49 • Difference $ (0.00) ~~~rurvucnru.u~i urt[ tterVKl Page: 1 Village of Tequesta 4/22/2008 3:29 pm For the Period: 111/2008 to 3131/2008 Original Bud. Amended Bud OTD Actual Encumb YTD UnencBal % Bud Fund. 601 -Village Employee Pension-Fire R ues pt: 000 General Acct Class: 361 Unrestricted Investment Eamin 361.100 Interest Income 0.00 0.00 15,969.82 0.00 -15 969.82 0 0 361.102 DividendlDistributions 0.00 0.00 3,918.29 0.00 , -3,918.29 . 0.0 Unrestricted Investment Eamin 0.00 0.00 19,888.11 0.00 -19,888.11 0.0 Acct Class: 367 Investment income 367.000 Gainlloss-Sale of Investments 0.00 0.00 -12,583.90 0.00 12 583.90 0 0 367.100 Unrealized gainlloss on invest 0.00 0.00 -188,498.53 0.00 , 188,498.53 . 0.0 Investment income 0.00 0.00 -201,082.43 0.00 201,082.43 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 0.00 0.00 28,149.10 0.00 -28 149.10 0 0 368.002 Pension Fund Cont-Employee 0.00 0.00 17,793.73 0.00 , -17,793.73 . 0.0 Pension Contributions 0.00 0.00 45,942.83 0.00 -45,942.83 0.0 General 0.00 0.00 -135,251.49 0.00 135,251.49 0.0 Revenues 0.00 0.00 -135,251.49 0.00 135,251.49 0.0 ~~ Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531,301 Legal Services 0.00 0.00 570.76 0.00 -570 76 0 0 531.304 Recording Secy Service 0.00 0.00 175.92 0.00 . -175.92 . 0.0 Operating Expenditures/Expense 0.00 0.00 746.68 0.00 -746 68 0 0 ~cct Class: 531 Investment Expense . . 5 Investment Services 0.00 0.00 6,462.92 0.00 -6,462.92 0.0 Investment Expense 0.00 0.00 6,462.92 0.00 -6,462.92 0,0 General 0.00 0.00 7,209.60 0.00 -7,209.60 0.0 Expenditures 0.00 0.00 7,209.60 0.00 -7,209.60 0.0 Net Effect for Village Employee Pension-Fire 0.00 0.00 -142,461.09 0.00 142 461 09 0 0 Change in Fund Balance: -142,461.09 , . . • ~nui ~ vi~~ n~rvni Page: 3 Village of Tequesta 4/22/2008 3:29 pm For the Period: 111/2008 to 3/31/2008 Fund: 603 -Village Employee Pension-folic Ori final Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud Rev ues ~pt: 000 General cct Class: 361 Unrestricted Investment Eamin 361.100 Interest Income 361.102 DividendlDistributions 0.00 0.00 5,695.85 0.00 -5,695.85 0.0 0.00 0.00 1,384.75 0.00 -1,384.75 0.0 Unrestricted Investment Eamin 0.00 0.00 7,080.60 0.00 -7 080.60 0 0 Acct Class: 367 Investment income , . 367.000 Gain/Loss-Sale of Investments 0.00 0.00 -0 452 19 367.100 Unrealized gainlloss on invest 0 00 , . 0.00 4,452.19 0.0 . 0.00 -66,383.83 0.00 66,383.83 0.0 Investment income 0.00 0.00 -70,836.02 0.00 70 836.02 0 0 Acct Class: 368 Pension Contributions , . 368.001 Pension Fund Cont-Employer 0.00 0 00 19 988 33 368.002 Pension Fund Cont-Employee 0 00 . , . 0.00 -19,988.33 0.0 . 0.00 8,690,57 0.00 -8,690.57 0.0 Pension Contributions 0.00 0.00 28,678.90 0.00 -28,678.90 0.0 General 0.00 0.00 -35,076.52 0.00 35,076.52 0.0 Revenues 0.00 0.00 -35,076.52 0.00 35,076.52 0.0 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 531.304 Recording Secy Service Operating Expenditures/Expense cct Class: 531 Investment Expense 5 Investment Services Investment Expense General Expenditures Net Effect for Village Employee Pension-folic Change in Fund Balance: Grand Total Net Effect: 0.00 0.00 200.64 0.00 -200.64 0 0 0.00 0.00 61.94 0.00 -61.94 . 0.0 0.00 0.00 262.58 0.00 -262.58 0.0 0.00 0.00 2,275.47 0.00 -2,275.47 0.0 0.00 0.00 2,275.47 0.00 -2,275.47 0.0 0.00 0.00 2,538.05 0.00 -2,538.05 0.0 0.00 0.00 2,538.05 0.00 -2,538.05 0.0 0.00 0.00 -37,614.57 0.00 37,614.57 0.0 -37,614.57 0.00 0.00 -209,357.21 0.00 209,357.21 •