HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 11_02/01/2010REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131109
Village of Tequesta
For the Period: 10/1/2009 to 12131/2009
Page: 1
111912010
2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund Type: 600 Trust and Agency Funtls
Fund: 601 -Village Employee Pension-Fire
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 InteresUlnvestmentEarnings
10/3112009 GJ Oct 09 Acc Income Salem Trust Pro Rata 11,331.22
10/31/2009 GJ Oct 09 Interest Salem Trust Pro Rata 3,660.22 $5,051.68
10/3112009 GJ Oct 09 Rvs Sep 09 Acc Income Salem Trust Pro Rata -12,141.60
11/30/2009 GJ Nov 09 Interest Salem Trust Pro Rata 5,124.92 $7,078.08
11/30/2009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust Pro Rata -11,331.22 $15,637.90
11/3012009 GJ Nov 09 Acc Income Salem Trust Pro Rata 12,926.72 $17,839.80
1213112009 GJ Dec 09 -Interest Salem -Pro Rata Share 3,881.26 $5,284.65
1213112009 GJ Dec 09 Rvs Nov 09 Acc Income Salem -Pro Rata -12,926.72
1213112009 GJ Dec 09 -Acc Income Salem -Pro Rata Share 11,014.16
InteresUlnvestment Earnings 0.00 0.00 11,538.96 0.00 -11,538.96 0.0
361.102 Dividend/Distributions
10/31/2009 GJ Oct 09 Dividends Salem Trust -Pro Rata 2,252.43 $3,108.70
11/30/2009 GJ Nov 09 Dividends Salem Trust Pro Rata 939.68 $1,297.80
1213112009 GJ Dec 09 -Dividend Salem -Pro Rata Share 3,841.85 $5,230.99
DividendlDistributions 0.00 0.00 7,033.96 0.00 -7,033.96 0.0
Unrestricted Investment Earnin 0.00 0.00 18,572.92
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments
10/3112009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata 469,114.15
10/3112009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata -472,133.14
11/30/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata 309,113.34
11/30/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata -298,170.88
12/3112009 GJ Dec 09 -Loss on Sale of Invest Salem -Pro Rata Share 456,060.05
1213112009 GJ Dec 09 - Loss on Sale of Invest Salem -Pro Rata Share -460,001.15
GainlLoss-Sale of Investments 0.00 0.00 3,982.37
367.100 Unrealized gainlloss on invest
10/31/2009 GJ Oct 09 -Unrealized foss Salem Trust Pro Rata -91,401.12
11/30/2009 GJ Nov 09 -Unrealized Gain Salem Trust Pro Rata 87,311.07
'1213112009 GJ Dec 09 Unrealized Gain Salem -Pro Rata Share 95,426.22
Unrealized gainlloss on invest 0.00 0.00 91,336.17
Investment income
Acct Class: 368 Pension Contributions
368.001 Pension Fun d Cont-Employer
1011512009 GJ VOT PENSION DEPOSIT 10/15/09
10/2912009 GJ VOT PENSION DEPOSIT 10129/09
11/12/2009 GJ VOT PENSION DEPOSIT 11112109
11125/2009 GJ VOT PENSION DEPOSIT P/D 11/25109
12110/2009 GJ VOT PENSION DEPOSIT 12/10/09
12/2312009 GJ VOT PENSION DEPOSIT PAYDATE 12123/1
Pension Fund Cont-Employer
368.002 Pension Fund Cont-Employee
10/15/2009 GJ VOT PENSION DEPOSIT 10115109
10129/2009 GJ VOT PENSION DEPOSIT 10129/09
1111212009 GJ VOT PENSION DEPOSIT 11/12/09
1112512009 GJ VOT PENSION DEPOSIT P/D 11125109
12/1012009 GJ VOT PENSION DEPOSIT 12110109
12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 12/23/1
0.00 0.00 95,318.54
216,200.00 216,200.00
0.00 -18,572.92 0.0
0.00 -3,982.37 0.0
0.00 -91,336.17 0.0
0.00 -95,318.54 0.0
4,496.72
5,791.20
6,038.19
6,150.42
7,676.08
5,651.97
35,804.58
0.00 180,395.42 16.6
2,127.11
2,739.45
2,856.29
2,909.38
3,631.07
2,673.59
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131109
Page: 2
Village of Tequesta 111912010
For the Period: 101112009 to 12/3112009 2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund Type: 600 Trust and Agency Funds
Fund: 601 -Village Employee Pension-Fire
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
Pension Fund Cont-Employee 70,600.00 70,600.00 16,936.89 0.00 53,663.11 24.0
Pension Contributions 286,800.00 286,800.00 52,741.47 0.00 234,058.53 18.4
General 286,800.00 286,800.00 166,632.93 0.00 120,167.07 58.1
General Revenues 286,800.00 286,800.00 166,632.93 0.00 120,167.07 58.1
Revenues 286,800.00 286,800.00 166,632.93 0.00 120,167.07 58.1
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating Expenditures/Expense
531.301 Legal Services
11/02/2009 GJ CK#1063 -Expenses for Perry & Jensen Legal service Inv#63370 346.28
12/07/2009 RE Rvs#237365 - CK#1069 -Perry & Jensen Legal services Inv#63413 -1,201.15 $1,659.05
1210712009 GJ CK#1069 -Perry & Jensen Legal services Inu#63413 1,201.15 $1,659.05
1211512009 GJ CK#1074 Perry & Jensen Legal Services Inu#63414 2,005.52 $2,770.05
Legal Services 8,000.00 8,000.00 2,351.80 0.00 5,648.20 29.4
531.304 Recording Secy Service
1012912009 GJ CK#1064 Business Services Conn Inv#9-134 Office work for wle 194.68 10/16 and 10123109
11102/2009 GJ Ck#1066 Business Services Connection Attend meeting and prepare minutes for 25.88 meeting held on 1017/09 $35.68
1111212009 GJ CK#1067 -Business Services Conn Inv#9-136 Office work for wle 194.68 10/30 and 1116109
1112512009 GJ CK#1068 Business Services Conn Inv#9-145 Office work for wle 193.88 11113 and 11/20/09
12/07/2009 GJ CK#1073 -Business Services Conn Inv#9-149 Office work for w/e 193.75 11/27 and 12104/09 $267.60
12/10/2009 GJ CK#1070 -Business Services Conn Attend gtrly meeting on 1112/09 258.32 and prepare minutes $356.80
1212312009 GJ CK#1075 Business Services Conn Inv#9-154 Office work for wle 193.75 12/11 and 12118109
Recording Secy Service 6,300.00 6,300.00 1,254.94 0.00 5,045.06 19.9
Actuarial Services 10,000.00 10,000.00 0.00 0.00 10,000.00 0.0
540.300 Travel & Per Diem
10/07/2009 GJ CK#1059 -Hotel accommodation at Radisson Resort Orlando for F. Dambra 208.50 to attend 41st Annual Pension Conf.
10/28/2009 GJ CK#1065 - Frank D'Ambra reimb of travel and meal exps to attend 41 st Annual 216.88 Pol. Officers & FlFighters Conf $299.06
Travel & Per Diem 1,000.00 1,000.00 425.38 0.00 574.62 42.5
545.300 Insurance
1012612009 GJ CK#1060 Fiduciary liability insurance policy for period 1011/09 to 1011110 2,365.09
Insurance 2,500.00 2,500.00 2,365.09 0.00 134.91 94.6
Other Misc Chgs & Obligations 1,200.00 1,200.00 0.00 0.00 1,200.00 0.0
554.300 Books, Publ, Subs & Membership
1210712009 GJ CK#1072 - 50% each fire and police FPPTA Membership Fee for year 2010 300.00 $600.00
Books, Publ, Subs & Membership 1,000.00 1,000.00 300.00 0.00 700.00 30.0
Seminars & Training -Pensions 500.00 500.00 0.00 0.00 500.00 0.0
Operating Expenditures/Expense 30,500.00 30,500.00 6,697.21 0.00 23,802.79 22.0
Acct Class: 531 Investment Expense
Investment Services 26,500.00 26,500.00 0.00 0.00 26,500.00 0.0
Investment Expense 26,500.00 26,500.00 0.00 0.00 26,500.00 0.0
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
10/3012009 GJ Oct 09 Wire fees to transfer fund to Sun America Bk 5.00 from Salem
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131/09
Village of Tequesta
For the Period: 10/112009 to 12I31I2009
Page: 3
111912010
2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund Type: 600 Trust and Agency Funds
Fund: 601 -Village Employee Pension-Fire
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 590 Other Financing Sources & Uses
12I31I2009 GJ Dec 09 -Wire fees to transfer funds to Sun American Bank 5.00 Public Safety Acct.
Bank Charges 100.00 100.00 10.00 0.00 90.00 10.0
Excess of additions over deduc 229,700.00 229,700.00 0.00 0.00 229,700.00 0.0
Other Financing Sources & Uses 229,800.00 229,800.00 10.00 0.00 229,790.00 0.0
General 286,800.00 286,800.00 6,707.21 0.00 280,092.79 2.3
General Revenues 286,800.00 286,800.00 6,707.21 0.00 280,092.79 2.3
Expenditures 286,800.00 286,800.00 6,707.21 0.00 280,092.79 2.3
Net Effect for Village Employee Pension-Fire 0.00 0.00 159,925.72 0.00 -159,925.72
Change in Fund Balance: 159,925.72
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12/31109
Page: 7
Village of Tequesta 1/19/2010
For the Period: 101112009 to 1213112009 2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD Unencl3al % Bud
Fund Type: 600 Trust and Agency Funds
Fund: 603 -Village Employee Pension-folic
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Eamin
361.100 Interest/InvestmentEsrnings
10/31/2009 GJ Oct 09 Acc Income Salem Trust Pro Rata 4,306.68
10/31/2009 GJ Oct 09 Interest Salem Trust Pro Rata 1,391.46 $5,051.68
10/31/2009 GJ Oct 09 Rvs Sep 09 Acc Income Salem Trust Pro Rata x,600.82
11/30/2009 GJ Nov 09 Interest Salem Trust Pro Rata 1,953.16 $7,078.08
1113012009 GJ Nov 09 Rvs Oct 09 Acc Income Salem Trust Pro Rata -4,306.68 $15,637.90
1113012009 GJ Nov 09 Acc Income Salem Trust Pro Rata 4,913.08 $17,839.80
1213112009 GJ Dec 09 -Interest Salem -Pro Rata Share 1,403.39 $5,284.65
12/31/2009 GJ Dec 09 Rvs Nov 09 Acc Income Salem -Pro Rata -4,913.08
12/3112009 GJ Dec 09 -Acc Income Salem -Pro Rata Share 3,983.33
InteresUlnvestmentEamings 0.00 0.00 4,130.52 0.00 -4,130.52 0.0
361.102 Dividend/Distributions
10/31/2009 GJ Oct 09 Dividends Salem Trust -Pro Rata 856.27 $3,108.70
11130/2009 GJ Nov 09 Dividends Salem Trust Pro Rata 358.12 $1,297.80
1213112009 GJ Dec 09 -Dividend Salem -Pro Rata Share 1,389.14 $5,230.99
Dividend/Distributions 0.00 0.00 2,603.53 0.00 -2,603.53 0.0
Unrestricted Investment Earnin 0.00 0.00 6,734.05 0.00 -6,734.05 0.0
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments
10/31/2009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata 178,297.04
10/31/2009 GJ Oct 09 - Loss on sale of invest Salem Trust Pro Rata -179,444.48
11/30/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata 117,779.82
11130/2009 GJ Nov 09 Gain on Sale of Invest Salem Trust Pro Rata -113,610.48
12/31/2009 GJ Dec 09 -Loss on Sale of Invest Salem -Pro Rata Share 164,936.75
1213112009 GJ Dec 09 -Loss on Sale of Invest Salem -Pro Rata Share -166,362.07
Gain/Loss-Sale of Investments 0.00 0.00 1,596.58 0.00 -1,596.58 0.0
367.100 Unrealized gainlloss on invest
1013112009 GJ Oct 09 -Unrealized loss Salem Trust Pro Rata -34,738.98
1113012009 GJ Nov 09 -Unrealized Gain Salem Trust Pro Rata 33,267.67
1213112009 GJ Dec 09 Unrealized Gain Salem -Pro Rata Share 34,511.44
Unrealized gain/loss on invest 0.00 0.00 33,040.13 0.00 -33,040.13 0.0
Investment income
Acct Class: 368 Pension Contributions
368.001 Pension Fun d Cont-Employer
10/15/2009 GJ VOT PENSION DEPOSIT 10/15109
10129/2009 GJ VOT PENSION DEPOSIT 10129109
1111212009 GJ VOT PENSION DEPOSIT 11/12/09
11125/2009 GJ VOT PENSION DEPOSIT P/D 11/25109
1211012009 GJ VOT PENSION DEPOSIT 12/10/09
1212312009 GJ VOT PENSION DEPOSIT PAYDATE 1212311
Pension Fund Cont-Employer
368.002 Pension Fund Cont-Employee
10/1512009 GJ VOT PENSION DEPOSIT 10/15/09
10129/2009 GJ VOT PENSION DEPOSIT 10129/09
11/12/2009 GJ VOT PENSION DEPOSIT 11112/09
11/2512009 GJ VOT PENSION DEPOSIT PID 11/25109
12/10/2009 GJ VOT PENSION DEPOSIT 12/10/09
12/23/2009 GJ VOT PENSION DEPOSIT PAYDATE 12123/1
0.00 0.00 34,636.71
115,600.00 115,600.00
0.00 -34,636.71 0.0
2,300.62
4,029.47
3,369.98
3,612.37
3,734.52
3,468.47
20,515.43
0.00 95,084.57 17.7
1,000.27
1,751.94
1,465.21
1,570.59
1,623.71
1,508.03
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131109
Page: 8
Village of Tequesta 1/1912010
For the Period: 101112009 to 12/3112009 2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund Type: 600 Trust and Agency Funds
Fund: 603 -Village Employee Pension-folic
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
Pension Fund Cont-Employee 37,800.00 37,800.00 8,919.75 0.00 28,880.25 23.6
Pension Contributions 153,400.00 153,400.00 29,435.18 0.00 123,964.82 19.2
General 153,400.00 153,400.00 70,805.94 0.00 82,594.06 46.2
General Revenues 153,400.00 153,400.00 70,805.94 0.00 82,594.06 46.2
Revenues 153,400.00 153,400.00
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services
11/0212009 GJ CK#1063 -Expenses for Perry & Jensen Legal service Inv#63370
12/0712009 RE Rvs#237365 - CK#1069 -Perry & Jensen Legal services Inv#63413
12/0712009 GJ CK#1069 -Perry & Jensen Legal services Inv#63413
12/1512009 GJ CK#1074 Perry & Jensen Legal Services Inv#63414
Legal Services 3,000.00 3,000.00
531.304 Recording Secy Service
10/29/2009 GJ CK#1064 Business Services Conn Inv#9-134 Office work for wle
11/02/2009 GJ Ck#1066 Business Services Connection Attend meeting and prepare minutes for
11/12/2009 GJ CK#1067 -Business Services Conn Inv#9-136 Office work for w/e
1112512009 GJ CK#1068 Business Services Conn Inv#9-145 Office work for wle
12/0712009 GJ CK#1073 -Business Services Conn Inv#9-149 Office work for wle
1211012009 GJ CK#1070 -Business Services Conn Attend gtrly meeting on 1112109
1212312009 GJ CK#1075 Business Services Conn Inv#9-154 Office work for wle
Recording Secy Service 2,100.00 2,100.00
Actuarial Services 4,000.00 4,000.00
540.300 Travel & Per Diem
10/0712009 GJ CK#1059 -Hotel accommodation at Radisson Resort Orlando for F. Dambra
10/28/2009 GJ CK#1065 -Frank D'Ambra reimb of travel and meal exps to attend 41st Annual
Travel & Per Diem 1,000.00 1,000.00
545.300 Insurance
10/26/2009 GJ CK#1060 Fiduciary liability insurance policy for period 1011109 to 10/1/10
Insurance 1,000.00 1,000.00
Other Misc Chgs & Obligations 900.00 900.00
554.300 Books, Publ, Subs & Membership
1210712009 GJ CK#1072 - 50% each fire and police FPPTA Membership Fee for year 2010
Books, Publ, Subs & Membership 800.00 800.00
Seminars & Training -Pensions 500.00 500.00
70,805.94
131.22
457.90 $1,659.05
457,90 $1,659.05
764.53 $2,770.05
0.00 82,594.06 46.2
895.75 0.00 2,104.25 29.9
72.92 10116 and 10123/09
9.80 meeting held on 1017109 $35.68
72.92 10130 and 1116109
73.72 11113 and 11120/09
73.85 11127 and 12/04109 $267.60
98.48 and prepare minutes $356.80
73.85 12/11 and 12/18/09
475.54 0.00 1,624.46 22.6
0.00 0.00 4,000.00 0.0
208.50 to attend 41st Annual Pension Conf.
82.18 Pol. Officers & F/Fighters Conf $299.06
290.68 0.00 709.32 29.1
896.81
896.81 0.00 103.19 89.7
0.00 0.00 900.00 0.0
300.00 $600.00
300.00 0.00 500.00 37.5
0.00 0.00 500.00 0.0
Operating Expenditures/Expense
Acct Class: 531 Investment Expense
Investment Services
Investment Expense
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
1013012009 GJ Oct 09 Wire fees to transfer
13,300.00
9,700.00 13,300.00
9,700.00 2,858.78
0.00 0.00
0.00 10,441.22
9,700.00 21.5
0.0
9,700.00 9,700.00 0.00 0.00 9,700.00 0.0
fund to Sun America Bk
5.00 from Salem
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131109
Page: 9
Village of Tequesta 111912010
For the Period: 1011/2009 to 12/3112009 2:37 pm
Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud
Fund Type: 600 Trust and Agency Funds
Fund: 603 -Village Employee Pension-folic
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 590 Other Financing Sources & Uses
12131/2009 GJ Dec 09 -Wire fees to transfer funds to Sun American Bank 5.00 Public Safety Acct.
Bank Charges 100.00 100.00 10.00 0.00 90.00 10.0
Excess of additions over deduc 130,300.00 130,300.00 0.00 0.00 130,300.00 0.0
Other Financing Sources & Uses 130,400.00 130,400.00 10.00 0.00 130,390.00 0.0
General 153,400.00 153,400.00 2,868.78 0.00 150,531.22 1.9
General Revenues 153,400.00 153,400.00 2,868.78 0.00 150,531.22 1.9
Expenditures 153,400.00 153,400.00 2,868.78 0.00 150,531.22 1.9
Net Effect for Village Employee Pension-folic 0.00 0.00 67,937.16 0.00 -67,937.16
Change in Fund Balance: 67,937.16
Net Effect for Trust and Agency Funds 0.00 0.00 320,297.01 0.00 -320,297.01