Loading...
HomeMy WebLinkAboutDocumentation_Pension Public Safety_Tab 06_05/03/2010 REVENUEIEXPENDITURE REPORT. For Qtr Ended 3131/10 Page: 1 Village of Tequesta 4/16/2010 For the Period: 1/1/2010 to 3131/2010 9:20 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund: 601 - Village Employee Pension -Fire 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- Pro Rata Share 2,133.32 01/31/2010 GJ Jan 10 - Rvs Dec 09 Acc Income Salem Trust - Pro Rata Share - 11,014.16 01/31/2010 GJ Jan 10 - Acc Income Salem Trust - Pro Rata Share 12,404.38 02/28/2010 GJ FEB 10 - INTEREST - SALEM TRUST PRO RATA SHARE $3,069.46 2,219.91 02/28/2010 GJ FEB 10 - RVS JAN 10 ACCRUED INCOME SALEM TRUST - PRO RATA SHARE $14,1 - 12,404.38 02/28/2010 GJ FEB 10 - ACCRUED INCOME SALEM TRW PRO RATA SHARE $21,939.38 15,867.13 03131/2010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST PRO -RATA SHARE - 15,867.13 03/31/2010 GJ MAR 10 -ACCRUED INCOME SALEM TRUST PRO -RATA SHARE 14,080.64 03/31/2010 GJ MAR 10 -INTEREST $6,660.56 SALEM TRUST PRO -RATA SHARE 4,826.64 Interest/Investment Earnings 0.00 0.00 12,246.35 0.00 - 12,246.35 0.0 361.102 Dividend /Distributions 01/31/2010 GJ Jan 10 -Dividends Salem Trust - Pro Rata Share 1,419.00 02/28/2010 GJ FEB 10 -DIVIDENDS -SALEM TRUST PRO RATA SHARE $923.54 667.93 03131/2010 GJ MAR 10 -DIVIDENDS $3,447.46 SALEM TRUST PRO -RATA SHARE 2,498.24 Dividend /Distributions 0.00 0.00 4,585.17 0.00 - 4,585.17 0.0 Unrestricted Investment Earnin 0.00 0.00 16,831.52 0.00 - 16,831.52 0.0 Acct Class: 367 Investment income 367.000 Gain /Loss -Sale of Investments 01/31/2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share 432,332.22 01/31/2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share - 431,362.69 02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENT SALEM TRUST - PRO RATA SHARE 336,782.47 02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENT SALEM TRUST - PRO RATA SHARE - 338,992.49 03/31/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO -RATA SK 516,743.76 03/31/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO -RATA SHi - 506,121.78 Gain /Loss -Sale of Investments 0.00 0.00 9,381.49 0.00 - 9,381.49 0.0 367.100 Unrealized gain /loss on invest 01/31/2010 GJ Jan 10 -Unrealized loss Salem Trust - Pro Rata Share - 125,874.67 02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE 3,638,841.43 02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE - 3,507,225.66 03/31/2010 GJ MAR 10 - UNREALIZED GAIN ON INVESTh SALEM TRUST COMPANY, PRO -RATA SH 3,856,128.21 03/31/2010 GJ MAR 10 - UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY, PRO -RATA SH- 3,691,790.79 Unrealized gain /loss on invest 0.00 0.00 170,078.52 0.00 - 170,078.52 0.0 Investment income 0.00 0.00 179,460.01 0.00 - 179,460.01 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont - Employer 01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 7,178.57 01/21/2010 GJ VOT PENSION DEPOSIT -PD 01/21/10 5,717.31 02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02/04/ 11,438.43 02/04/2010 GJ VOT PENSION DEPOSIT P/D 02/04/10 38,656.28 02/18/2010 GJ VOT PENSION DEPOSIT P/D 02/18110 10,206.87 03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 11,232.71 03118/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 10,175.59 Pension Fund Cont - Employer 0.00 0.00 94,605.76 0.00 - 94,605.76 0.0 368.002 Pension Fund Cont - Employee 01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 3,395.73 01/21/2010 GJ VOT PENSION DEPOSIT -PD 01121/10 2,704.50 02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02 /04/ 3,016.46 02118/2010 GJ VOT PENSION DEPOSIT P/D 02/18/10 2,691.69 03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 2,962.21 REVENUE /EXPENDITURE REPORT For Qtr Ended 3/31/10 Page: 2 Village of Tequesta 4/16/2010 For the Period: 1/1/2010 to 3/3112010 9:20 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund: 601 - Village Employee Pension -Fire Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 368 Pension Contributions 03/18/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 2,683.44 Pension Fund Cont - Employee 0.00 0.00 17,454.03 0.00 - 17,454.03 0.0 Pension Contributions 0.00 0.00 112,059.79 0.00 - 112,059.79 0.0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 02/28/2010 GJ FEB 10 -RECLASSIFY DIVIDENDS AS A RETURN OF CAPITAL - SALEM TRUST CC 737.69 PRO RATA SHARE Other Miscellaneous Revenue 0.00 0.00 737.69 0.00 - 737.69 0.0 Miscellaneous Revenues 0.00 0.00 737.69 0.00 - 737.69 0.0 General 0.00 0.00 309,089.01 0.00 - 309,089.01 0.0 General Revenues 0.00 0.00 309,089.01 0.00 - 309,089.01 0.0 Revenues 0.00 0.00 309,089.01 0.00 - 309,089.01 0.0 Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 01/20/2010 GJ Perry & Jensen - Legal Service expenses for period ended 12/15/09 Inv. #63466 194.83 $269.25 01/26/2010 GJ Record Perry & Jensen Legal service for period ended 664.57 1/15/10 - $918.42 0212412010 GJ Ck #1087 Perry & Jensen - Legal service expenses for period ended 2/15/10 1,793.13 inv #63567 $2,478.75 03/19/2010 GJ Perry & Jensen - Legal services for period ended 3/15/10 234.43 Inv#63619 - $324.16 Legal Services 0.00 0.00 2,886.96 0.00 - 2,886.96 0.0 531.304 Recording Secy Service 01/08/2010 GJ CK #1076 Business Services Conn Inv#9 -158 Office work for We 193.64 12/25109 and 1/1/10 01/20/2010 GJ Record Business Services Connection Inv. #10-4 - $267.60 Office work w/e 193.64 1/08/10 & 1/15/10 02/01/2010 GJ Ck#1082 Business Services Connection Attend meeting and prepare minutes for 167.82 meeting on 1/22/10 $231.92 02/04/2010 GJ CK #1083 - Business Services Conn Inv#10 -8 Office work for w/e 193.64 1/22 and 1129/10 02/1812010 GJ Ck #1084 - Business Services Conn Inv#10 -13 - Office work for w/e 96.79 2/5/10 & 2/12/10 02/24/2010 GJ Ck #1085 Business Services Connection Attend meeting and prepare minutes for 400.07 meeting held on 2/1/10 $553.04 03/04/2010 GJ Ck #1086 Business Services Connection Inv #10 -20 - $267.60 Office work w/e 193.58 2/19/10 & 2/26/10 03/18/2010 GJ CK #1089 BUSINESS SERVICS CONNECT INV #10 -25 $267.60 OFFICE WORK W/E 193.54 3/5/10 & 3/12/10 Recording Secy Service 0.00 0.00 1,632.72 0.00 - 1,632.72 0.0 531.309 Actuarial Services 01/20/2010 GJ Gabriel, Roeder, Smith & Company Serv.rendered thru 11/30/09 - Inv.110224 5,378.52 pro rata share $7,433.00 Actuarial Services 0.00 0.00 5,378.52 0.00 - 5,378.52 0.0 Operating Expenditures /Expense 0.00 0.00 9,898.20 0.00 - 9,898.20 0.0 Acct Class: 531 Investment Expense 531.307 Investment Services 01/20/2010 GJ Rockwood Capital - MGT Fee for Gtr ended 12131/09 $6,425.22 4,649.29 01/20/2010 GJ Bogdahn Consulting fee for Qtr ending 12/31/09 Inv.#4825 $3,750.00 2,713.50 01120010 GJ Reclassify Bogdahn Consulting Fee for Qtr -Ended 12131/09 - 2,713.50 $3,750.00 Investment Services 0.00 0.00 4,649.29 0.00 - 4,649.29 0.0 531.350 Custodial Services - Invest. 01/12/2010 GJ Salem fee and commissions for the period 10/1/09 to 12/31/09 797.56 $1,102.52 Custodial Services - Invest. 0.00 0.00 797.56 0.00 - 797.56 0.0 REVENUE /EXPENDITURE REPORT For Qtr Ended 3/31/10 Page: 3 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: 601 - Village Employee Pension -Fire Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 531 Investment Expense 531.355 Investment Advisors 01/20/2010 GJ Reclassify Bogdahn Consulting Fee for Qtr -Ended 12/31/09 2,713.50 $3,750.00 Investment Advisors 0.00 0.00 2,713.50 0.00 - 2,713.50 0.0 Investment Expense 0.00 0.00 8,160.35 0.00 - 8,160.35 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 5.00 Salem Trust Bank Charges 0.00 0.00 5.00 0.00 -5.00 0.0 Other Financing Sources & Uses 0.00 0.00 5.00 0.00 -5.00 0.0 General 0.00 0.00 18,063.55 0.00 - 18,063.55 0.0 General Revenues 0.00 0.00 18,063.55 0.00 - 18,063.55 0.0 Expenditures 0.00 0.00 18,063.55 0.00 - 18,063.55 0.0 Net Effect for Village Employee Pension -Fire 0.00 0.00 291,025.46 0.00 - 291,025.46 Change in Fund Balance: 291,025.46 REVENUEIEXPENDITURE REPORT For Qtr Ended 3/31/10 Page: 7 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: 603 - Village Employee Pension -Polic Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest/Investment Earnings 01131/2010 GJ Jan 10 - Acc Income Salem Trust - Pro Rata Share 4,742.95 01/31/2010 GJ Jan 10 - Interest Salem Trust - Pro Rata Share 815.74 01/3112010 GJ Jan 10 - Rvs Dec 09 Acc Income Salem Trust - Pro Rata Share - 3,983.33 02/28/2010 GJ FEB 10 -INTEREST -SALEM TRUST PRO RATA SHARE $3,069.46 849.55 02/28/2010 GJ FEB 10 - RVS JAN 10 ACCRUED INCOME SALEM TRUST - PRO RATA SHARE $14,1 - 4,742.95 02/28/2010 GJ FEB 10 - ACCRUED INCOME SALEM TRW PRO RATA SHARE $21,939.38 6,072.25 03/31/2010 GJ MAR 10 - RVS FEB 10 ACCRUED INCOME SALEM TRUST PRO -RATA SHARE - 6,072.25 03/31/2010 GJ MAR 10 -ACCRUED INCOME SALEM TRUST PRO -RATA SHARE 5,350.03 03131/2010 GJ MAR 10 -INTEREST $6,660.56 SALEM TRUST PRO -RATA SHARE 1,833.92 Interest/Investment Earnings 0.00 0.00 4,865.91 0.00 - 4,865.91 0.0 361.102 Dividend /Distributions 01/31/2010 GJ Jan 10 - Dividends Salem Trust - Pro Rata Share 542.60 02/28/2010 GJ FEB 10 - DIVIDENDS - SALEM TRUST PRO RATA SHARE $923.54 255.61 03/31/2010 GJ MAR 10 - DIVIDENDS $3,447.46 SALEM TRUST PRO -RATA SHARE 949.22 Dividend /Distributions 0.00 0.00 1,747.43 0.00 - 1,747.43 0.0 Unrestricted Investment Earnin 0.00 0.00 6,613.34 0.00 - 6,613.34 0.0 Acct Class: 367 Investment income 367.000 Gain /Loss -Sale of Investments 01/31/2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share 165,307.01 01/31/2010 GJ Jan 10 - Gain on sale of investments Salem Trust - Pro Rata Share - 164,936.30 02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENT SALEM TRUST - PRO RATA SHARE 128,884.63 02/28/2010 GJ FEB 10 - LOSS ON SALE OF INVESTMENI SALEM TRUST - PRO RATA SHARE - 129,730.39 02/28/2010 GJ FEB 10 - UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE - 1,342,194.18 03/31/2010 GJ MAR 10 - UNREALIZED GAIN ON INVESTh SALEM TRUST COMPANY, PRO -RATA SH - 1,402,720.66 03/31/2010 GJ MAR 10 - GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO -RATA SH) 196,340.25 03/31/2010 GJ MAR 10 -GAIN ON SALE OF INVESTMENI SALEM TRUST COMPANY PRO -RATA SHi - 192,304.36 GainlLoss -Sale of Investments 0.00 0.00 - 2,741,354.00 0.00 2,741,354.00 0.0 367.100 Unrealized gain /loss on invest 01131/2010 GJ Jan 10 - Unrealized loss Salem Trust - Pro Rata Share - 48,129.57 02/28/2010 GJ FEB 10 -UNREALIZED GAIN ON INVESTM SALEM TRUST PRO RATA SHARE 1,392,562.75 03/3112010 GJ MAR 10 -UNREALIZED GAIN ON INVESTN SALEM TRUST COMPANY, PRO -RATA SH 1,465,161.76 Unrealized gain /loss on invest 0.00 0.00 2,809,594.94 0.00 - 2,809,594.94 0.0 Investment income 0.00 0.00 68,240.94 0.00 - 68,240.94 0.0 Acct Class: 368 Pension Contributions 368.001 Pension Fund Cont - Employer 01/07/2010 GJ VOT PENSION DEPOSIT 01/07/10 4,500.96 01/21/2010 GJ VOT PENSION DEPOSIT -PD 01/21/10 3,210.94 02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02/04 / 4,361.30 02104/2010 GJ VOT PENSION DEPOSIT P/D 02/04/10 3,755.46 02/18/2010 GJ VOT PENSION DEPOSIT P/D 02/18/10 3,815.35 03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 4,311.63 03/18/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 3,845.62 Pension Fund Cont - Employer 0.00 0.00 27,801.26 0.00 - 27,801.26 0.0 368.002 Pension Fund Cont - Employee 01/07/2010 GJ VOT PENSION DEPOSIT 01107/10 1,956.94 01/2112010 GJ VOT PENSION DEPOSIT -PD 01/21/10 1,396.06 02/04/2010 GJ VOT PENSION DEPOSIT PAYDATE 02/04/ 1,673.56 02/18/2010 GJ VOT PENSION DEPOSIT P/D 02/18/10 1,464.06 03/04/2010 GJ VOT PENSION DEPOSIT P/D 03/04/10 1,654.50 REVENUE /EXPENDITURE REPORT For Qtr Ended 3/31/10 Page: 8 Village of Tequesta 4/16/2010 Forthe Period: 1/1/2010 to 3/31/2010 9:20 am Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund: 603 - Village Employee Pension -Polic Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 368 Pension Contributions 03/18/2010 GJ VOT PENSION DEPOSIT P/D 03/18/10 1,475.68 Pension Fund Cont - Employee 0.00 0.00 9,620.80 0.00 - 9,620.80 0.0 Pension Contributions 0.00 0.00 37,422.06 0.00 - 37,422.06 0.0 Acct Class: 369 Miscellaneous Revenues 369.000 Other Miscellaneous Revenue 020/2010 GJ FEB 10 -RECLASSIFY DIVIDENDS AS A RETURN OF CAPITAL - SALEM TRUST CC 282.31 PRO RATA SHARE Other Miscellaneous Revenue 0.00 0.00 282.31 0.00 - 282.31 0.0 Miscellaneous Revenues 0.00 0.00 282.31 0.00 - 282.31 0.0 General 0.00 0.00 112,558.65 0.00 - 112,558.65 0.0 General Revenues 0.00 0.00 112,558.65 0.00 - 112,558.65 0.0 Revenues 0.00 0.00 112,558.65 0.00 - 112,558.65 0.0 Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating Expenditures /Expense 531.301 Legal Services 01/20/2010 GJ Perry & Jensen - Legal Service expenses for period ended 12/15/09 Inv. #63466 74.42 $269.25 01/26/2010 GJ Record Perry & Jensen Legal service for period ended 253.85 1/15/10 - $918.42 02/24/2010 GJ Ck #1087 Perry & Jensen - Legal service expenses for period ended 2/15/10 685.62 inv #63567 $2,478.75 03/19/2010 GJ Perry & Jensen - Legal services for period ended 3/15/10 89.73 Inv#63619 - $324.16 Legal Services 0.00 0.00 1,103.62 0.00 - 1,103.62 0.0 531.304 Recording Secy Service 01/0812010 GJ CK #1076 Business Services Conn Inv#9 -158 Office work for w/e 73.96 12/25/09 and 1/1/10 01/20/2010 GJ Record Business Services Connection Inv. #10 -4 - $267.60 Office work w/e 73.96 1/08/10 & 1/15/10 02/01/2010 GJ Ck #1082 Business Services Connection Attend meeting and prepare minutes for 64.10 meeting on 1/22/10 $231.92 02/04/2010 GJ CK #1083 - Business Services Conn Inv#10 -8 Office work for w/e 73.96 1/22 and 1/29/10 02/18/2010 GJ Ck#1084 - Business Services Conn Inv#10 -13 - Office work for w/e 37.01 2/5/10 & 2/12/10 02/24/2010 GJ Ck #1085 Business Services Connection Attend meeting and prepare minutes for 152.97 meeting held on 2/1/10 $553.04 03/04/2010 GJ Ck #1086 Business Services Connection Inv #10 -20 - $267.60 Office work w/e 74.02 2/19/10 & 2/26/10 03/18/2010 GJ CK #1089 BUSINESS SERVICS CONNECT INV #10 -25 $267.60 OFFICE WORK W/E 74.06 315/10 & 3/12110 Recording Secy Service 0.00 0.00 624.04 0.00 - 624.04 0.0 531.309 Actuarial Services 01/20/2010 GJ Gabriel, Roeder, Smith & Company Serv.rendered thru 11/30/09 - Inv.110224 2,054.48 pro rata share $7,433.00 Actuarial Services 0.00 0.00 2,054.48 0.00 - 2,054.48 0.0 Operating Expenditures /Expense 0.00 0.00 3,782.14 0.00 - 3,782.14 0.0 Acct Class: 531 Investment Expense 531.307 Investment Services 01/20/2010 GJ Rockwood Capital - MGT Fee for Gtr ended 12/31/09 $6,425.22 1,775.93 01/20/2010 GJ Bogdahn Consulting fee for Qtr ending 12/31/09 Inv. #4825 $3,750.00 1,036.50 01/20/2010 GJ Reclassify Bogdahn Consulting Fee for Qtr -Ended 12131/09 - 1,036.50 $3,750.00 Investment Services 0.00 0.00 1,775.93 0.00 - 1,775.93 0.0 531.350 Custodial Services - Invest. 01/12/2010 GJ Salem fee and commissions for the period 10/1/09 to 12/31/09 304.96 $1,102.52 Custodial Services - Invest. 0.00 0.00 304.96 0.00 - 304.96 0.0 REVENUEIEXPENDITURE REPORT For Qtr Ended 3/31/10 Page: 9 Village of Tequesta 4/1612010 For the Period: 1/1/2010 to 3/31/2010 9:20 am Original Bud. Amended Bud. QTD Actual Encumb, YTD UnencBal % Bud Fund: 603 - Village Employee Pension -Polic Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 531 Investment Expense 531.355 Investment Advisors 01/20/2010 GJ Reclassify Bogdahn Consulting Fee for Qtr -Ended 12/31/09 1,036.50 $3,750.00 Investment Advisors 0.00 0.00 1,036.50 0.00 - 1,036.50 0.0 Investment Expense 0.00 0.00 3,117.39 0.00 - 3,117.39 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 5.00 Salem Trust Bank Charges 0.00 0.00 5.00 0.00 -5.00 0.0 Other Financing Sources & Uses 0.00 0.00 5.00 0.00 -5.00 0.0 General 0.00 0.00 6,904.53 0.00 - 6,904.53 0.0 General Revenues 0.00 0.00 6,904.53 0.00 - 6,904.53 0.0 Expenditures 0.00 0.00 6,904.53 0.00 - 6,904.53 0.0 Net Effect for Village Employee Pension -Polic 0.00 0.00 105,654.12 0.00 - 105,654.12 Change in Fund Balance: 105,654.12