Loading...
HomeMy WebLinkAboutPension General_Documentation_Tab 14_05/05/2008VILLAGE OF TEQUESTA GENERAL EMPLOYEES' PENSION TRUST FUND RECONCILIATION OF GENERAL LEDGER WITH SALEM TRUST STATEMENTS FOR THE 2ND QUARTER ENDED MAR 31, 2008 • GENERAL LEDGER BALANCE -DEC 31, 2007 BALANCE Cash -Sun American Bank $ 1,448.32 Investments-Salem Trust 1,056,886.18 Accrued Income-Salem Trust 5,343.72 INCREASES CONTRIBUTIONS Employer Employee INTEREST 8 DIVIDENDS Interest Dividend Changes in Acc. Income OTHER Misc. Revenue Gain (Loss) on Sale of Assets Change in Investments UnRealized Gain (Loss) on Investments TOTAL INCREASES 29, 900.42 18, 571.39 48,471.81 4,114.06 2, 715.45 112.98 6,942.49 3.68 (1; 882.20) (64,958.50) (66,837.02) (11,422.72) .DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions Withholding Tax (9,915.15) (2,478.79) (12,393.94) ADMINISTRATIVE EXPENSES Gabriel, Roeder, Smith Hanson, Perry 8 Jensen PA Business Services Connection Bogdahn Consulting Salem Trust -Fees Dana Investments Wire Fees & Service Charge Foreign Tax W/H Foreign W/H Fee Travel & Per Diem (Reimb) Insurance TOTAL DEDUCTIONS Rounding Difference GENERAL LEDGER BALANCES -MARCH 31, 2008 ~al. as per Salem Trust Statement -Mar 31, 2008 Bal. as per Sun American Bank Statement -Mar 31, 2008 (689.81) (373.78) (1,125.00) (1, 705.69) (1, 506.27) (30.00) (32.71) (1.63) (5,464.89) DIFFERENCE $ 1,034,396.67 $ 1,033,067.15 $ 1,329.52 $ 1,034,396.67 rtcvcnuucnrcnuiiurtc rtervrti Page: 2 4/22/2008 Village of Tequesta 3:29 pm For the Period: 11112008 to 3131/2008 Original Bud Amended Bud QTD Actual Encumb YTD UnencBal % Bud Fund. 602 - VillageEmployee Pension-Gen Re es ~t: 000 General cct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 0.00 4,227.04 0.00 -4,227.04 0.0 361.102 DividendlDistributions n nn n nn ~ ~,s ~~ ~ ~~ ~ „~ .~ „„ ~ Unrestricted Investment Eamin 0.00 0.00 6,942.49 0.00 -6,942.49 0.0 Acct Class: 367 Investment income 367.000 Gain/Loss-Sale of Investments 0.00 0.00 -1,882.20 0.00 1,882.20 0.0 367.100 Unrealized gainlloss on invest 0.00 0.00 -64,958.50 0.00 64,958.50 0.0 Investment income 0.00 0.00 -66,840.70 0.00 66,840.70 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont-Employer 0.00 0.00 29,900.42 0.00 -29,900.42 0.0 368.002 Pension Fund Cont-Employee 0.00 0.00 18,571.39 0.00 -18,571.39 0.0 Pension Contributions 0.00 0.00 48,471.81 0.00 X8,471.81 0.0 Acct Class: MISC Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 0.00 13,500.00 3.68 0.00 13,496.32 0.0 Miscellaneous Revenues 0.00 13,500.00 3.68 0.00 13,496.32 0.0 General 0.00 13,500.00 -11,422.72 0.00 24,922.72 -84.6 Revenues 0.00 13,500.00 -11,422.72 0.00 24,922.72 -84.6 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 5~Legal Services 0.00 0.00 689.81 0.00 -689.81 0.0 5 Recording Secy Service 0.00 0.00 373.78 0.00 -373.78 0.0 531.309 Actuarial Services 0.00 5,500.00 0.00 0.00 5,500.00 0.0 Operating Expenditures/Expense 0.00 5,500.00 1,063.59 0.00 4,436.41 19.3 Acct Class: 531 Investment Expense 531.307 Investment Services 0.00 8,000.00 4,401.30 0.00 3,598.70 55.0 Investment Expense 0.00 8,000.00 4,401.30 0.00 3,598.70 55.0 General 0.00 13,500.00 5,464.89 0.00 8,035.11 40.5 Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 536.300 Pension DistributionslRefunds 0.00 0.00 12,393.94 0.00 -12,393.94 0.0 Operating ExpenditureslExpense Pension Expenditures 0.00 0.00 12,393.94 0.00 0.00 12,393.94 0.00 13, 500.00 17, 858.83 0.00 -12,393.94 0.0 0.00 -12,393.94 0.0 0.00 -4,358.83 132.3 Net Effect for VillageEmployee Pension-Gen Change in Fund Balance: 0.00 0.00 -29,281.55 -29,281.55 0.00 29,281.55 0.0 r~ ~J