HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 08_02/02/2009)REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131108
Village of Tequesta
For the Period: 10/1/2008 to 12131/2008
Fund: 601 -Village Employee Pension-Fire
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interest Income
10/31/2008 GJ Oct 08 -Interest
1013112008 GJ Oct 08 Rvs Sep 08 -Acc. Income
10/31/2008 GJ Oct OS -Accrued Income
11/30/2008 GJ Nou 08 -Interest
11/30/2008 GJ Nov 08 rvs Oct 08 Acc. Income
11/30/2008 GJ Nou 08 -Acc, Income
12/3112008 GJ Dec OS Rvs Nov 08 Acc Income
12/31/2008 GJ Dec 08 Acc. Income
12/31/2008 GJ Dec 08 Interest
Interest Income
361.102 Dividend/Distributions
10/3112008 GJ Oct 08 -Dividends
1113012008 GJ Nov 08 -Dividends
12131/2008 GJ Dec OS Dividends
DividendlDistributions
Unrestricted Investment Earnin
Acct Class: 367 Investment income
367.000 Gain/Loss-Sale of Investments
10/31 /2008 GJ Oct OS -Loss on sale of
10/31!2008 GJ Oct 08 -Loss on sale of
11/30/2008 GJ Nov 08 -Loss on sale of investment
11130/2008 GJ Nov 08 -Loss on sale of investment
12/3112008 GJ Dec OS -Loss on sale of invest
12/3112008 GJ Dec 08 -Loss on sale of invest
GainlLoss-Sale of Investments
367.100 Unrealized gain/loss on invest
10/3112008 GJ Oct 08 -Unrealized loss
11/30/2008 GJ Nov 08 -Unrealized Loss
12/3112008 GJ Dec OS Unrealized Gain
Unrealized gainlloss on invest
Investment income
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer
10/17/2008 GJ VOT PENSION DEPOSIT 10/17/08
10/31/2008 GJ VOT PENSION DEPOSIT 10/31/08
11/03/2008 BA As per minutes of Public Safety Officers
1111412008 GJ VOT PENSION DEPOSIT 11/14/08
1112612008 GJ VOT PENSION DEPOSIT 11/26/08
12112/2008 GJ VOT PENSION DEPOSIT 12112108
12/2312008 GJ VOT PENSION DEPOSIT 12123108
Pension Fund Cont-Employer
368.002 Pension Fund Cont-Employee
10/17/2008 GJ VOT PENSION DEPOSIT 10117/08
10/31/2008 GJ VOT PENSION DEPOSIT 10131108
11/03/2008 BA As per minutes of Public Safety Officers
11/14/2008 GJ VOT PENSION DEPOSIT 11/14/08
11/26/2008 GJ VOT PENSION DEPOSIT 11/26/08
12/1212008 GJ VOT PENSION DEPOSIT 12/12/08
12/2312008 GJ VOT PENSION DEPOSIT 12/23/08
Original Bud. Amended Bud. OTD Actual
Salem Trust Pro Rata
Salem Trust -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata Share
Salem -Pro Rata Share
0.00
Salem Trust -Pro Rata
Salem -Pro Rata
Salem -Pro Rata Share
0.00
0.00
investments -Salem
investments -Salem
Salem Trust -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata Share
Salem -Pro Rata Share
0.00
0.00
0.00
0.00
0.00
Salem Trust -Pro Rata
Salem -Pro Rata
Salem -Pro Rata Share
0.00 0.00
0.00
Pension Meeting held on 11103108
0.00
0.00 131,200.00
Pension Meeting held on 11103/08
6,248.71 $8,547.87
-12,414.07 $17,064.02
9,217.33 $12,609.21
4,261.80 $5,836.44
-9,217.33 $12,609.21
12,050.42 $16,502.90
-12,050.42 $16,520.90
10,789.73 $14,786.53
4,366.67 $5,984.11
13,252.84
1,768.46 $2,419.15
255.13 $349.40
3,328.32 $4,561.15
5,351.91
18,604.75
442,818.16 Pro rata share
-462,260.93 Pro rata share
351,834.95
-357,465.98
399,303.33
-406,657.07
-32,427.54
-300,902.77 (411,631.70
-75,557.70 ($103,475.35)
63,256.87 $86,688.87
-313,203.60
345,631.14
4,415.86
5,064.31
131,200.00
5,302,40
5,909.74
6,217.59
5,324.33
32,234.23
2,088.87
2,395.61
68,000.00
2,508.23
2,795.53
2,941.15
2,518.61
Page: 1
1 /21 /2009
11:14 am
Encumb. YTD UnencBal % Bud
0.00 -13,252.84 0.0
0.00 -5,351.91 0.0
0.00 -18,604.75 0.0
0.00 32,427.54 0.0
0.00 313,203.60 0.0
0.00 345,631.14 0.0
0.00 98,965.77 24.6
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12/31/08
Village of Tequesta
For the Period: 101112008 to 1213112008
Fund: 601 -Village Employee Pension-Fire
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
Pension Fund Cont-Employee
Pension Contributions
General
General Revenues
Original Bud. Amended Bud. QTD Actual
Encumb. YTD
Page: 2
1/21/2009
11:14 am
UnencBal % Bud
0.00 68,000.00 15,248. 00
0.00 199,200.00 47,482. 23
0.00 199,200.00 -279,544. 16
0.00 199,200.00 -279,544. 16
Revenues 0.00 199,200.00 -279,544.16
0.00
0.00
0.00
0.00
0.00
52,752.00 22.4
151,717.77 23.8
478,744.16 -140.3
478,744.16 -140.3
478,744.16 -140.3
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating ExpenditureslExpense
531.301 Legal Services
11/03/2008 GJ Rec. expenses for Hanson, Perry 8 Jensen legal service thru 10/15/08 -Inv #62684 344.29
11103/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11103/08 6,000.00
1211112008 GJ Ck #1861 Hanson, Perry & Jensen Legal Services thru 11/15108 1,147.87 Inv #62750 $1,572.00
12/1112008 RE Rvrs #214204 CK#1861 Hanson, Perry Legal Services thru 11/15/08 -1,147.87 Inv #62750 $1,572.00
1211112008 GJ Ck #1861 -Hanson, Perry & Jensen legal services thru 11115/08 1,147.87 Inv #62750 - $1,572.00
Legal Services 0.00 6,000.00 1,492.16 0.00 4,507.84 24.9
531.304 Recording Secy Service
10/15/2008 GJ Business Services Connection Office Work for Pension Board for 185.40 WIE 1013 & 10/10108 - $254.85
1110312008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03108 5,600.00
11/04/2008 GJ Business Services Connection Office work for pension board 117.43 wk ended 10/17 & 10124/08
11/12/2008 GJ Business Services Connection Office work for wle 222.48 10/17 & 11/07108
11/26/2008 GJ Ck #1860 Business Services Conn Office work w/e 11/26 & 12/05 186.09 $254.85
11/26/2008 GJ CK#1859 -Business Services Conn Inv #8-92 - $254.85 for Office Work 186.30 W/E 11/14 & 21, 2008
11/30/2008 GJ CK #1863 -Business Services Conn Inv #8-105 Office work for wle 186.09 12/12 & 12/1912008 - $254.85
12/1112008 GJ Ck #1862 -Business Services Conn Prep of minutes for meeting held on 198.50 1113108
12/1112008 RE Rvrs #214203 - CK#1862 Business Serv Co Prep of minutes for meeting held on -198.50 11/3108
12/1112008 GJ CK #1862 -Business Services Conn Prep. of minutes for meeeting held 198.50 on 11/3/08 - $271.84
Recording Secy Service 0.00 5,600.00 1,282.29 0.00 4,317.71 22.9
Actuarial Services 0.00 6,000.00 0.00 0.00 6,000.00 0.0
Travel & Per Diem 0.00 900.00 0.00 0.00 900.00 0.0
545.300 Insurance
10101/2008 GJ Fiduciary Liability Insurance Policy for 10101/08 to 09/30109 2,415.27 $3,317.56
11/03/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11103108 2,500.00
Insurance 0.00 2,500.00 2,415.27 0.00 84.73 96.6
Other Misc Chgs & Obligations 0.00 1,000.00 0.00 0.00 1,000.00 0.0
554.300 Books, Publ, Subs & Membership
11/03/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11103/08 550.00
11/30/2008 GJ CK#1001 - 50% Each Fire & Police FPPTA Membership fee for 2009 300.00 $600.00
Books, Publ, Subs & Membership 0.00 550.00 300.00 0.00 250.00 54.5
Seminars 8 Training -Pensions 0.00 300.00 0.00 0.00 300.00 0.0
Operating Expenditures/Expense 0.00 22,850.00 5,489.72 0.00 17,360.28 24.0
Acct Class: 531 Investment Expense
Investment Services 0.00 32,000.00 0.00 0.00 32,000.00 0.0
Investment Expense 0.00 32,000.00 0.00 0.00 32,000.00 0.0
Acct Class: 590 Other Financing Sources & Uses
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12131/08
Village of Tequesta
For the Period: 10/1/2008 to 12131/2008
Original Bud. Amended Bud. QTD Actual
Fund: 601 -Village Employee Pension-Fire
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
11103/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03108
11/24/2008 GJ NOVEMBER OS -WIRE FEES TO TRANSFE FUNDS TO SUN AMERICAN BANK-PUBLIC
12/02/2008 GJ DECEMBER 08 -CHECKS FEE, ORDEREC FROM SUN AMERICAN BANK - PUBLIC SF
12/10/2008 GJ DECEMBER 08 -WIRE FEES TO TRANSFE FUNDS TO SUN AMERICAN BANK - PUBLI
Bank Charges 0.00 120.00
Excess of additions over deduc 0.00 144,230.00
Other Financing Sources & Uses 0.00 144,350.00
General 0.00 199,200.00
General Revenues 0.00 199,200.00
Expenditures 0.00 199,200.00
Encumb. YTD
Page: 3
1 /21 /2009
11:14 am
UnencBal % Bud
120.00
5.00 FROM SALEM TRUST ON 11124108
38.48 $76.95
5.00 SAFETY FROM SALEM TRUST ON 12/10/0
48.48 0.00 71,52 40.4
0.00 0.00 144,230.00 0.0
48.48 0.00 144,301.52 0.0
5,538.20 0.00 193,661.80 2.8
5,538.20 0.00 193,661.80 2.8
5,538.20 0.00 193,661.80 2.8
Net Effect for Village Employee Pension-Fire 0.00 0.00 -285,082.36 0.00 285,082.36
Change in Funtl Balance: -285,082.36
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12/31/08
Village of Tequesta
For the Period: 10/1/2008 to 12/3112008
Fund: 603 -Village Employee Pension-folic
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 361 Unrestricted Investment Earnin
361.100 Interest Income
10/31/2008 GJ Oct OS -Interest
10/31/2008 GJ Oct OS Rvs Sep 08 -Acc. Income
10/31/2008 GJ Oct OS -Accrued Income
11/30/2008 GJ Nov 08 -Interest
11/30/2008 GJ Nov 08 rvs Oct 08 Acc. Income
1113012008 GJ Nov 08 -Acc. Income
12/3112008 GJ Dec 08 Rvs Nov 08 Acc Income
12/31/2008 GJ Dec 08 Acc. Income
1213112008 GJ Dec 08 Interest
Interest Income
361.102 Dividend/Distributions
10131/2008 GJ Oct 08 -Dividends
11/30/2008 GJ Nov 08 -Dividends
1213112008 GJ Dec 08 Dividends
DividendlDistributions
Unrestricted Investment Earnin
Acct Class: 367 Investment income
367.000 GainlLoss-Sale of Investments
10/31/2008 GJ Oct OS -Loss on sale of
10/31/2008 GJ Oct 08 -Loss on sale of
11/30/2008 GJ Nov 08 - Loss on sale of investment
11/30/2008 GJ Nov 08 - Loss on sale of investment
12/31/2008 GJ Dec 08 -Loss on sale of invest
12/3112008 GJ Dec 08 -Loss on sale of invest
GainlLoss-Sale of Investments
367.100 Unrealized gainlloss on invest
10131/2008 GJ Oct 08 -Unrealized loss
1113012008 GJ Nov 08 -Unrealized Loss
12131/2008 GJ Dec OS Unrealized Gain
Unrealized gainlloss on invest
Investment income
Acct Class: 368 Pension Contributions
368.001 Pension Fund Cont-Employer
10/17/2008 GJ VOT PENSION DEPOSIT 10117/08
10/31/2008 GJ VOT PENSION DEPOSIT 10131/08
11/03/2008 BA As per minutes of Public Safety Officers
11/1412008 GJ VOT PENSION DEPOSIT 11114/08
11/26/2008 GJ VOT PENSION DEPOSIT 11126(08
12/12/2008 GJ VOT PENSION DEPOSIT 12/12/08
12/23/2008 GJ VOT PENSION DEPOSIT 12/23/08
Pension Fund Cont-Employer
368.002 Pension Fund Cont-Employee
10117/2008 GJ VOT PENSION DEPOSIT 10/17/08
10/31/2008 GJ VOT PENSION DEPOSIT 10/31/08
11/0312008 BA As per minutes of Public Safety Officers
11/14/2008 GJ VOT PENSION DEPOSIT 11114108
11/26/2008 GJ VOT PENSION DEPOSIT 11126108
12/12/2008 GJ VOT PENSION DEPOSIT 12112/08
12/23/2008 GJ VOT PENSION DEPOSIT 12/23/08
Original Bud. Amended Bud. OTD Actual
Salem Trust Pro Rata
Salem Trust -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata Share
Salem -Pro Rata Share
0.00
Salem Trust -Pro Rata
Salem -Pro Rata
Salem -Pro Rata Share
0.00
0.00
investments -Salem
investments -Salem
Salem Trust -Pro Rata
Salem Trust -Pro Rata
Salem -Pro Rata Share
Salem -Pro Rata Share
0.00
Salem Trust -Pro Rata
Salem -Pro Rata
Salem -Pro Rata Share
0.00
0.00
Pension Meeting held on 11103/08
0.00
0.00
0.00
0.00
0.00
0.00
0.00 97,700.00
Pension Meeting held on 11/03108
2,299.16 $8,547.87
-4,649.95 $17,064.02
3,391.88 $12,609.21
1,574.64 $5,836.44
-3,391.88 $12,609.21
4,452.48 $16,502.90
-4,452.48 $16,520.90
3,996.80 $14,786.53
1,617.44 $5,984.11
4,838.09
650.69 $2,419.15
94.27 $349.40
1,232.83 $4,561.15
1,977.79
6,815.88
162,952.24 Pro rata share
-170,106.96 Pro rata share
129,998.72
-132,079.32
147,912.42
-150,636.43
-11,959.33
-110,728.93 (411,631.70
-27,917.65 ($103,475.35)
23,432.00 $86,688.87
-115,214.58
-127,173.91
2,632.86
3,408.25
97,700.00
3,433.13
3,855.17
3,360.41
2,766.85
19,456.67
1,144.72
1,481.85
42,500.00
1,492.66
1,676.16
1,461.05
1,202.98
Page: 1
1/21/2009
11:15 am
Encumb. YTD UnencBal % Bud
0.00 -4,838.09 0.0
0.00 -1,977.79 0.0
0.00 -6,815.88 0.0
0.00 11,959.33 0.0
0.00 115,214.58 0.0
0.00 127,173.91 0.0
0.00 78,243.33 19.9
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12/31/08
Vlllage of Tequesta
For the Period: 10/1/2008 to 12131/2008
Fund: 603 -Village Employee Pension-folic
Revenues
Function: 000 General Revenues
Dept: 000 General
Acct Class: 368 Pension Contributions
Pension Fund Cont-Employee
Pension Contributions
General
General Revenues
Original Bud. Amended Bud. QTD Actual
0.00 42,500.00
0.00 140,200.00
0.00 140,200.00
0.00 140,200.00
Revenues 0.00 140,200.00
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 530 Operating Expenditures/Expense
531.301 Legal Services
11/03/2008 GJ Rec. expenses for Hanson, Perry & Jensen legal service thru 10/15108 -Inv #62684
11/03/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03/08
12/11/2008 GJ Ck #1861 Hanson, Perry & Jensen Legal Services thru 11/15108
12/11/2008 RE Rvrs #214204 CK#1861 Hanson, Perry Legal Services thru 11/15108
12111/2008 GJ Ck #1861 -Hanson, Perry & Jensen legal services thru 11115/08
Legal Services 0.00 2,100.00
531.304 Recording Secy Service
10/15/2008 GJ Business Services Connection Office Work for Pension Board for
11/03/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11103/08
1110412008 GJ Business Services Connection Office work for pension board
11112/2008 GJ Business Services Connection Office work for wle
11/26/2008 GJ CK#1859 -Business Services Conn Inv #8-92 - $254.85 for Office Work
11/26/2008 GJ Ck #1860 Business Services Conn Office work wle 11/26 & 12105
11/30/2008 GJ CK #1863 -Business Services Conn Inv #8-105 Office work for wle
12/11/2008 GJ Ck #1862 -Business Services Conn Prep of minutes for meeting held on
12/11/2008 RE Rvrs #214203 - CK#1862 Business Serv Co Prep of minutes for meeting held on
12/11/2008 GJ CK #1862 -Business Services Conn Prep. of minutes for meeeting held
Recording Secy Service 0.00 1,850.00
Actuarial Services 0.00 2,000.00
Travel & Per Diem 0.00 900.00
545.300 Insurance
10/01/2008 GJ Fiduciary Liability Insurance Policy for 10/01/08 to 09130/09
11/03/2008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03/08
Insurance 0.00 1,000.00
Other Misc Chgs & Obligations 0.00 400.00
554.300 Books, Publ, Subs & Membership
11/0312008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03/08
11130/2008 GJ CK#1001 - 50% Each Fire & Police FPPTA Membership fee for 2009
Books, Publ, Subs & Membership 0.00 550.00
Seminars & Training -Pensions 0.00 300.00
Operating ExpenditureslExpense 0.00 9,100.00
Acct Class: 531 Investment Expense
Investment Services 0.00 10,700.00
Investment Expense 0.00 10,700.00
Acct Class: 590 Other Financing Sources & Uses
8,459.42
27,916.09
-92,441.94
-92,441.94
-92,441.94
Encumb. YTD
0.00
0.00
0.00
0.00
Page: 2
1 /21 /2009
11:15 am
UnencBal % Bud
34,040.58 19.9
112,283.91 19.9
232,641.94 -65.9
232,641.94 -65.9
0.00 232,641.94 -65.9
128.96
2,100.00
424.13 Inu #62750 $1,572.00
-024.13 Inv #62750 $1,572.00
424.13 Inv #62750 - $1,572.00
553.09 0.00 1,546.91 26.3
69.45 WIE 10/3 & 10110108 - $254. 85
1,850.00
43.98 wk ended 10/17 & 10/24/08
83.34 10/17 & 11/07/08
68.55 WIE 11/14 & 21, 2008
68.76 $254.85
68.76 12/12 & 12/1912008 - $254.85
73.34 11 /3/08
-73.34 11 /3/08
73.34 an 11/3/08 - $271.84
476.18 0.00 1,373.82 25.7
0.00 0.00 2,000.00 0.0
0.00 0.00 900.00 0.0
902.29 $3,317.56
1,000.00
902.29 0.00 97.71 90.2
0.00 0.00 400.00 0.0
550.00
300.00 $600.00
300.00 0.00 250.00 54.5
0.00 0.00 300.00 0.0
2,231.56 0.00 6,868.44 24.5
0.00 0.00 10,700.00 0.0
0.00 0.00 10,700.00 0.0
REVENUEIEXPENDITURE REPORT
For Qtr Ended 12/31108
Village of Tequesta
For the Period: 10/1/2008 to 12/3112008
Original Bud. Amended Bud. QTD Actual
Fund: 603 -Village Employee Pension-folic
Expenditures
Function: 000 General Revenues
Dept: 000 General
Acct Class: 590 Other Financing Sources & Uses
549.391 Bank Charges
11/0312008 BA As per minutes of Public Safety Officers Pension Meeting held on 11/03108
1112412008 GJ NOVEMBER 08 -WIRE FEES TO TRANSFE FUNDS TO SUN AMERICAN BANK-PUBLIC
12/02/2008 GJ DECEMBER OS -CHECKS FEE, ORDEREC FROM SUN AMERICAN BANK - PUBLIC SF
1211012008 GJ DECEMBER 08 -WIRE FEES TO TRANSFE FUNDS TO SUN AMERICAN BANK - PUBLI
Bank Charges 0.00 40.00
Excess of additions over deduc 0.00 120,360.00
Other Financing Sources & Uses 0.00 120,400.00
General 0.00 140,200.00
General Revenues 0.00 140,200.00
Expenditures 0.00 140,200.00
Net Effect for Village Employee Pension-folic 0.00 0.00
Change in Fund Balance:
Encumb. YTD
Page: 3
112112009
11:15 am
UnencBal % Bud
40.00
5.00 FROM SALEM TRUST ON 11124/08
38.47 $76.95
5.00 SAFETY FROM SALEM TRUST ON 12I10IC
48. 47 0.00 -8.47 121.2
0. 00 0.00 120,360.00 0.0
48. 47 0.00 120,351.53 0.0
2,280. 03 0.00 137,919.97 1.6
2,280. 03 0.00 137,919.97 1.6
2,280. 03 0.00 137,919.97 1.6
-94,721. 97 0.00 94,721.97
-94,721. 97