HomeMy WebLinkAboutDocumentation_Pension General_Tab 12_05/03/2010 REVENUE /EXPENDITURE REPORT
For Qtr Ended 3/31/10
Page: 4
Village of Tequesta 4/16/2010
For the Period: 1/112010 to 3/31/2010 9:20 am
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension -Gen
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interest/Investment Earnings
01/31/2010 GJ Jan 10 - Interest Salem Trust 0.10 $0.10
01/31/2010 GJ Jan 10 Rvs Dec 09 Acc Income Salem Trust - 218.85
01/31/2010 GJ Jan 10 Acc Income Salem Trust 172.69
01/31/2010 GJ Jan 10 -Interest Salem Trust 807.41
01/31/2010 GJ Jan 10 Rvs Dec 09 Acc Income Salem Trust - 5,481.61
01/31/2010 GJ Jan 10 Acc Income Salem Trust 5,853.53
02/28/2010 GJ FEB 10 - RVS.JAN 10 ACCRUED INCOME SALEM TRUST $5,853.53 - 5,853.53
02/2812010 GJ FEB 10 ACCRUED INCOME SALEM TRUS' $6,561.72 6,561.72
02/28/2010 GJ FEB 10 - INTEREST FROM SALEM TRUST $1,408.26 1,408.26
02/28/2010 GJ FEB 10 - RVS. JAN 10 ACCRUED INCOME SALEM TRUST $172.69 - 172.69
02/28/2010 GJ FEB 10 - ACCRUED INCOME - INT'L FUND SALEM TRUST $150.50 150.50
02/28/2010 GJ FEB 10 - INTEREST FROM SALEM TRUST 0.02
03/31/2010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST $6,561.72 - 6,561.72
03131/2010 GJ MAR 10 - ACCRUED INCOME SALEM TRUST $6,973.58 6,973.58
03/3112010 GJ MAR 10 - INTEREST FROM SALEM TRUS] $1,342.12 1,342.12
03/31/2010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST $150.50 - 150.50
03/31/2010 GJ MAR 10 - ACCRUED INCOME - INT'L FUN[ SALEM TRUST $355.20 355.20
03/31/2010 GJ MAR 10 - INTEREST FROM SALEM TRUST 0.05
Interest/InvestmentEarnings 0.00 0.00 5,186.28 0.00 - 5,186.28 0.0
361.102 Dividend /Distributions
01/3112010 GJ Jan 10 - Dividends Salem Trust 94.35 $94.34
01/31/2010 GJ Jan 10- Dividends Salem Trust 1,179.41 $1,179.41
02/28/2010 GJ FEB 10 - DIVIDENDS FROM SALEM TRUS $962.54 962.54
03/31/2010 GJ MAR 10 - DIVIDENDS FROM SALEM TRUS $1,414.94 1,414.94
03/31/2010 GJ MAR 10- DIVIDENDS FROM SALEM TRUST 78.96
Dividend /Distributions 0.00 0.00 3,730.20 0.00 - 3,730.20 0.0
Unrestricted Investment Earnin 0.00 0.00 8,916.48 0.00 - 8,916.48 0.0
Acct Class: 367 Investment income
367.000 Gain /Loss -Sale of Investments
01/31/2010 GJ Jan 10 - Sale of Invest Salem Trust 25,756.59
01/31/2010 GJ Jan 10 - Sale of Invest Salem Trust - 26,072.38
02/28/2010 GJ FEB 10 - SALE OF INVESTMENT - LOSS SALEM TRUST 175,737.52
02128/2010 GJ FEB 10 - SALE OF INVESTMENT - LOSS SALEM TRUST - 175,847.88
02/28/2010 GJ FEB 10 - SALE OF INVESTMENTS SALEM TRUST 43,524.24
02128/2010 GJ FEB 10 - SALE OF INVESTMENTS SALEM TRUST - 43,403.65
03/31/2010 GJ MAR 10 - SALE ON INVESTMENT - LOSS SALEM TRUST 85,053.88
03/3112010 GJ MAR 10 - SALE ON INVESTMENT - LOSS SALEM TRUST - 85,069.32
Gain /Loss -Sale of Investments 0.00 0.00 - 321.00 0.00 321.00 0.0
367.100 Unrealized gain/loss on invest
01/3112010 GJ Jan 10 - Unrealized loss Salem Trust - 5,186.22 ($5,186.22)
01/31/2010 GJ Jan 10 - Unrealized loss Salem Trust - 23,976.87
02/28/2010 GJ FEB 10 - SALE OF INVESTMENT SALEM T 1,239,106.35
02/28/2010 GJ FEB 10 - SALE OF INVESTMENT SALEM T - 1,212,142.60
02128/2010 GJ FEB 10 - UNREALIZED LOSS SALEM TRUST $112.84 - 128,153.75
02128/2010 GJ FEB 10 - UNREALIZED LOSS SALEM TRUST $112.84 128,040.91
03/31/2010 GJ MAR 10 - SALE OF INVESTMENT- SALEM UNREALIZED GAIN $38,158.98 1,298,279.30
03/31/2010 GJ MAR 10 - SALE OF INVESTMENT- SALEM UNREALIZED GAIN $38,158.98 - 1,260,120.32
03/31/2010 GJ MAR 10 - UNREALIZED GAIN SALEM TRUST $7,234.20 - 129,028.95
03/31/2010 GJ MAR 10 - UNREALIZED GAIN SALEM TRUST $7,234.20 136,263.15
Unrealized gain/loss on invest 0.00 0.00 43,081.00 0.00 - 43,081.00 0.0
REVENUE /EXPENDITURE REPORT
For Qtr Ended 3/31/10
Page: 5
Village of Tequesta 4/16/2010
For the Period: 1/112010 to 3/31/2010 9:20 am
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension -Gen
Revenues
Function: 000 General Revenues
D ept: 000 G
Investment income 0.00 0.00 42,760.00 0.00 - 42,760.00 0.0
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont - Employer
01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 5,874.12
01/21/2010 GJ VOT PENSION DEPOSIT -PD 01/21/10 5,576.08
02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02104/ 5,575.39
02/18/2010 GJ VOT PENSION DEPOSIT P/D 02/18/10 5,582.29
03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 5,582.09
03/18/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 5,694.72
Pension Fund Cont - Employer 0.00 0.00 33,884.69 0.00 - 33,884.69 0.0
368.002 Pension Fund Cont - Employee
01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 3,644.00
01/21/2010 GJ VOT PENSION DEPOSIT -PD 01/21/10 3,459.10
02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02/04/' 3,458.68
02/18/2010 GJ VOT PENSION DEPOSIT P/D 02/18/10 3,462.96
03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 3,462.83
03/18/2010 GJ VOT PENSION DEPOSIT P/D 03118/10 3,532.71
Pension Fund Cont- Employee 0.00 0.00 21,020.28 0.00 - 21,020.28 0.0
Pension Contributions 0.00 0.00 54,904.97 0.00 - 54,904.97 0.0
General 0.00 0.00 106,581.45 0.00 - 106,581.45 0.0
General Revenues 0.00 0.00 106,581.45 0.00 - 106,581.45 0.0
Revenues 0.00 0.00 106,581.45 0.00 - 106,581.45 0.0
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating Expenditures /Expense
531.301 Legal Services
01/20/2010 GJ Record Perry & Jensen legal servises Inv. #63465 - $257.75 257.75
01/26/2010 GJ Record Perry & Jensen Legal Services for period ended 1,030.92 1/15/10
02/24/2010 GJ Ck #1246 Perry & Jensen Legal services Inv #63566 - $2,679.30 1,648.38
03/19/2010 GJ Perry & Jensen - Legal services for the period ended 3/15/10 470.41 Inv#63618 - $470.41
Legal Services 0.00 0.00 3,407.46 0.00 - 3,407.46 0.0
531.304 Recording Secy Service
01/08/2010 GJ CK #1236 - Business Services Conn Inv#9 -159 Office work for w/e 267.60 12/25/09 and 1/1/10
01/20/2010 GJ Record Business Services Connection Inv. #10 -3 - $267.60 Office work for week 267.60 ended 1/8/10 and 1/15/10
02/04/2010 GJ CK #1242 - Business Services Conn Inv#10 -7 Office work for We 267.60 1/22 and 1/29/10
02/18/2010 GJ CK #1243 - Business Services Conn Inv#10 -12 Office work for Me 133.80 215/10 and 2/12/10
02/24/2010 GJ Ck #1245 Business Services Connection Inv #10 -18 - $481.68 Attend qtrly meeting 481.68 held on 211110 & prepare minutes
03/04/2010 GJ Ck #1244 Business Services Connection Inv #10 -21 - $267.60 Office work for week 267.60 ended 2/19/10 &2/26/10
03/18/2010 GJ CK #1247 - BUSINESS SERVICES CONNE INV #10 -24 - $267.70 OFFICE WORK FOR 267.60 WEEK ENDED 3/5/10 & 3/12/10
Recording Secy Service 0.00 0.00 1,953.48 0.00 - 1,953.48 0.0
531.309 Actuarial Services
01/20/2010 GJ Garbiel, Roeder, Smith & Cc Inv. #110225 $6,376.00 Completion of the 10/1/09 6,376.00 valuation report & prep for mtg 11/2109
Actuarial Services 0.00 0.00 6,376.00 0.00 - 6,376.00 0.0
549.300 Other Misc Chgs & Obligations
03/26/2010 GJ Fedex charges incurred by General Employees Pension for shipping 18.74 C. Harding docs to Perry & Jensen
REVENUE /EXPENDITURE REPORT
For Qtr Ended 3/31/10
Page: 6
Village of Tequesta 4/16/2010
For the Period: 1/1/2010 to 3/31/2010 9:20 am
Original Bud. Amended Bud. QTD Actual Encumb, YTD UnencBal % Bud
Fund: 602 - VillageEmployee Pension -Gen
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating Expenditures /Expense
Other Misc Chgs & Obligations 0.00 0.00 18.74 0.00 -18.74 0.0
Operating Expenditures /Expense 0.00 0.00 11,755.68 0.00 - 11,755.68 0.0
Acct Class: 531 Investment Expense
531.307 Investment Services
01/20/2010 GJ Record Dana 1 nvestment Statement of Management fees for QTR -ended 12 /31/09 1,839.12 $1,839.12
Investment Services 0.00 0.00 1,839.12 0.00 - 1,839.12 0.0
531.350 Custodial Services - Invest.
01/12/2010 GJ Salem Fee & Commissions for the period 10/1109 to 12/31/09 854.25 $854.25
01/12/2010 RE Salem Fee & Commissions for the period 10/1/09 to 12/31/09 - 854.25 $854.25
01/12/2010 GJ Salem fee and commissions for the period 10/1/09 to 12/31/09 854.25 $854.25
Custodial Services - Invest. 0.00 0.00 854.25 0.00 - 854.25 0.0
531.355 Investment Advisors
01120/2010 GJ Record Bogdahn Consulting Inv. #4824 $2,625.00 Qtrly fee 10/01/09 to 12/31/09 2,625.00
Investment Advisors 0.00 0.00 2,625.00 0.00 - 2,625.00 0.0
Investment Expense 0.00 0.00 5,318.37 0.00 - 5,318.37 0.0
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
01/31/2010 GJ Jan 10 -Wire fees to transfer funds to Sun American bank from 10.00 Salem Trust
Bank Charges 0.00 0.00 10.00 0.00 -10.00 0.0
Other Financing Sources & Uses 0.00 0.00 10.00 0.00 -10.00 0.0
General 0.00 0.00 17,084.05 0.00 - 17,084.05 0.0
General Revenues 0.00 0.00 17,084.05 0.00 - 17,084.05 0.0
Expenditures 0.00 0.00 17,084.05 0.00 - 17,084.05 0.0
Net Effect for VillageEmployee Pension -Gen 0.00 0.00 89,497.40 0.00 - 89,497.40
Change in Fund Balance: 89,497.40