Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Pension General_Documentation_Tab 10_02/05/2007
VILLAGE OF TEQUESTA GENERAL EMPLOYEES' PENSION TRUST FUND SCHEDULE OF INVESTMENT ACTIVITIES FOR QTR ENDED 12/31/06 ENERAL LEDGER BALANCE -Sep 30, 2006 BALANCE 602-000-101.123 -Cash -Independent Community Bank $ 1,054.70 602-000-151.000 -Investments-Salem Trust 787,998.20 602-000-135.100 -Accrued Income-Salem Trust 4,703.25 INCREASES CONTRIBUTIONS Employer 34,466.55 Employee 21,381.24 INTEREST 8 DIVIDENDS Interest 4,723.39 Dividend 2,357.95 Changes in Acc. Income (6.35) OTHER Gain (Loss) on Sale of Assets (58.73) Change in Investments UnRealized Gain (Loss) on Investments 24,114.42 TOTAL INCREASES SEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions (12,151.98) Withholding Tax (3,037.99) ADMINISTRATIVE EXPENSES Bogdahn Consulting (1,125.00) Salem Trust -Fees (198.80) Business Services Connection (193.32) Dana Investments (1,252.47) Wire Fees & Service Charge (40.00) Insurance - Acordia (839.20) Shipping Expenses (11.71) Hanson, Perry & Jensen PA (1,577.61) TOTAL DEDUCTIONS GENERAL LEDGER BALANCES -Dec 31, 2006 Bal. as per Salem Trust Statement -12131/06 ADD: Pension Contribution In Transit ~al. as per Wachovia Statement al. as per Ind. Community Bank Statement -12/31106 LESS: Outstanding Check #1064-Hanson, Perry, Jensen ADJUSTED BANK BALANCE -Dec 31, 2006 55,847.79 7,074.99 24,055.69 86,978.47 (15,189.97) (5,238.11) $ 860,306.54 844,173.10 7,508.01 0.01 9,431.92 (806.50) $ 860,306.54 DIFFERENCE $ - BALANCE SHEET QUARTER ENDED 12/31/06 Page: 2 1 /25/2007 Village of Tequesta 1:02 pm • As of: 12/31/2006 Fund Type: 600 Trust and Agency Funds Fund: 602 - VillageEmployee Pension-Gen Assets Acct Class: 101 Cash and Cash Equivalents 101.123 Cash -Independent Community B • Acct Class: 101 Cash and Cash Equivalents Acct Class: 103 Investments 135.100 Accrued Income 151.000 Investments Acct Class: 103 Investments Total Assets Liabilities Acct Class: 208 Due to Other Funds 207.001 Due to/from General Fund (001) 207.603 Due to/fr Pension/Police (603) Acct Class: 208 Due to Other Funds Total Liabilities ReservesBalances Acct Class: 253 FB - Unreserved/Undesignated 271.000 Fund Balance 299.000 Change In Fund Balance Acct Class: 253 FB - Unreserved/Undesignated Total Reserves/Balances Total Liabilities & Balances Balances 8,625.42 8,625.42 4,696.90 846,984.22 851,681.12 860,306.54 164.25 -407.88 -243.63 -243.63 798,025.98 62, 524.19 860,550.17 860,550.17 860,306.54 • INCOME STATEMENT QUARTER ENDED 12/31/06 Village of Tequesta Page: 2 1 /25/2007 1:05 pm QTR: 1 QTD Amd. Bud. YTD Actual QTD Actual Fund: 602 - VillageEmplovee Pension-Gen evenues Function: 000 General Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 4,717.04 4,717.04 361.102 Dividend Income 0.00 2,357.95 2,357.95 361.103 Money funds Dividends 0.00 0.00 0.00 Unrestricted Investment Earnin 0.00 7,074.99 7,074.99 Acct Class: MISC Miscellaneous Revenues 367.000 Gain/Loss-Sale of Investments 0.00 -58.73 -58.73 367.100 Unrealized gain/loss on invest 0.00 24,114.42 24,114.42 367.110 Unrealized Gain/loss- Rockwood 0.00 0.00 0.00 368.001 Pension Fund Cont-Employer 0.00 29,789.40 29,789.40 368.002 Pension Fund Cont-Employee 0.00 18,479.78 18,479.78 369.000 Other Miscellaneous Revenue 0.00 0.00 0.00 Miscellaneous Revenues 0.00 72,324.87 72,324.87 General 0.00 79,399.86 79,399.86 General Revenues 0.00 79,399.86 79,399.86 Revenues 0.00 79,399.86 79,399.86 Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0.00 806.50 806.50 531.304 Recording Secy Service 0.00 0.00 0.00 531.307 Investment Services 0.00 40.00 40.00 • 531.309 Actuarial Services 0.00 0.00 0.00 534.300 Other Contractual Services 0.00 0.00 0.00 540.300 Travel & Per Diem 0.00 0.00 0.00 545.3001nsurance 0.00 839.20 839.20 549.300 Other Misc Chgs & Obligations 0.00 0.00 0.00 554.300 Books, Publ, Subs & Membership 0.00 0.00 0.00 554.600 Seminars & Training -Pensions 0.00 0.00 0.00 Operating Expenditures/Expense 0.00 1,685.70 1,685.70 General 0.00 1,685.70 1,685,70 General Revenues 0.00 1,685.70 1,685.70 Function: 518 Pension Benefits Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 531.300 Professional Services 0.00 0.00 0,00 531.307 Investment Services 0.00 0.00 0.00 536.300 Pension Distributions/Refunds 0.00 15,189.97 15,189.97 Operating Expenditures/Expense 0.00 15,189.97 15,189.97 Pension 0.00 15,189.97 15,189.97 Pension Benefits 0.00 15,189.97 15,189.97 Expenditures 0.00 16,875.67 16,875.67 Net Effect for Fund VillageEmplovee Pension-Gen 0.00 62,524.19 62,524.19 r ~ L_J REVENUE REPORT QUARTER ENDED 12131/06 Village of Tequesta For the Period: 10/1/2006 to 12131/2006 Page: 3 1/2512007 1:07 pm Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud 602 - VillageEmployee Pension-Gen Revenues Function: 000 General Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 10131/2006 GJ OCT O6 -INTEREST -SALEM $2861.97 2,861.97 10/31/2006 GJ OCT O6 -RVS SEP 06 ACCRUED INCOME SALEM TRUST $4,703.25 -4,703.25 10/3112006 GJ OCT O6 -ACCRUED INCOME SALEM TRUST $3251.42 3,251.42 11130/2006 GJ NOV O6 -INTEREST -SALEM $1,264.28 1,264.28 11130/2006 GJ NOV O6 -REVERSING OCT 06 ACC. INCOME -SALEM - $3,251.42 -3,251.42 11/3012006 GJ NOV O6 -ACCRUED INCOME -SALEM $3,997.44 3,997.44 12/3112006 GJ 12/31106 -INTEREST -SALEM $597.14 597.14 12/3112006 GJ 12131/06 -RVS NOV 06 ACCRUED INCOMI SALEM - $3,997.44 -3,997.44 12131/2006 GJ 12/31/06 -ACCRUED INCOME -SALEM $4,696.90 4,696.90 Interest Income 0.00 0.00 4,717.04 0.00 x,717.04 0.0 361.102 Dividend Income 10131/2006 GJ OCT 06 -DIVIDENDS -SALEM $483.68 483.68 11/30/2006 GJ NOV O6 -DIVIDENDS -SALEM $326.81 326.81 12/31/2006 GJ 12/31106-DIVIDENDS-SALEM $1,547.46 1,547.46 Dividend Income 0.00 0.00 2,357.95 0.00 -2,357.95 0.0 Unrestricted Investment Eamin 0.00 0.00 7,074.99 Acct Class: MISC Miscellaneous Revenues 367.000 GainlLoss-Sale of Investments 10/31/2006 GJ OCT O6 -SALEM TRUST SALE OF INVEST -LOSS ($71.10) -71.10 12006 GJ NOV 06 -SALE OF INVEST -GAIN SALEM $126.21 126.21 12006 GJ 12/31106 -SALE OF INVEST -LOSS ($113.84) -113.84 GainlLoss-Sale of Investments 0.00 0.00 -58.73 367.100 Unrealized gain/loss on invest 1013112006 GJ OCT O6 -SALEM TRUST UNREALIZED GAIN - $11,258.90 11,258.90 11130/2006 GJ NOV 06 -UNREALIZED GAIN -SALEM $8,749.45 8,749.45 1213112006 GJ 12/31/06 -UNREALIZED GAIN -SALEM $4,106.07 4,106.07 Unrealized gainlloss on invest 0.00 0.00 24,114.42 368.001 Pension Fund Cont-Employer 10/06/2006 PA VOT PENSION DEPOSIT-PID 09130/06 4,677.15 1010612006 RE VOT PENSION DEPOSIT-PID 09130106 -4,677.15 10/20/2006 PA VOT PENSION DEPOSIT-PID 10/20106 4,777.08 11/03/2006 PA VOT PENSION DEPOSITS-PID 11103/06 5,329.25 11/1712006 PA VOT PENSION DEPOSIT-P/D 11/17/06 5,161.01 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12/01/06 5,022.25 12/15/2006 PA VOT PENSION DEPOSIT-PID 12/15/06 4,866.23 12129/2006 PA VOT PENSION DEPOSIT-P/D 12/29/06 4,633.58 Pension Fund Cont-Employer 0.00 0.00 29,789.40 368.002 Pension Fund Cont-Employee 10/06/2006 PA VOT PENSION DEPOSIT-PID 09130106 2,901.46 1010612006 RE VOT PENSION DEPOSIT-PID 09/30106 -2,901.46 1012012006 PA VOT PENSION DEPOSIT-PID 10120/06 2,963.45 1110312006 PA VOT PENSION DEPOSITS-PID 11103106 3,305.99 1111712006 PA VOT PENSION DEPOSIT-PID 11/17/06 3,201.62 12/01/2006 PA VOT PENSION DEPOSIT-P/D 12101106 3,115.54 12115/2006 PA VOT PENSION DEPOSIT-PID 12/15106 3,018.75 /2006 PA VOT PENSION DEPOSIT-PID 12129/06 2,874.43 Pension Fund Cont-Employee 0.00 0.00 18,479.78 0.00 -7,074.99 0.0 0.00 58.73 0.0 0.00 -24,114.42 0.0 0.00 -29,789.40 0.0 0.00 -18,479.78 0.0 Village of Tequesta For the Period: 1011/2006 to 12/31/2006 602 - VillageEmployee Pension-Gen Revenues Function: 000 General Revenues Dept: 000 General Miscellaneous Revenues General REVENUE REPORT QUARTER ENDED 12131/06 Original Bud. Amended Bud. OTD Actual 0.00 0.00 72,324.87 0.00 0.00 79,399.86 Page: 4 112512007 1:07 pm Encumb. YTD UnencBal % Bud 0.00 -72,324.87 0.0 0.00 -79,399.86 0.0 General Revenues 0.00 0.00 79,399.86 0.00 -79,399.86 0.0 Revenues i• 0.00 0.00 79,399.86 0.00 -79,399.86 0.0 i• EXPENDITURE REPORT QUARTER ENDED 12/31/06 Village of Tequesta For the Period: 10/1/2006 to 12/31/2006 Page: 2 112512007 1:08 pm - Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud 602 - VillageEmployee Pension-Gen Expenditures Function: 000 General Revenues Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 11!0612006 GJ NOV O6 - CK #1055 - HANSON, PERRY & JENSEN -INV #61038 - $771.11 FOR 771.11 PERIOD ENDED 10115/06 1110612006 RE NOV O6 -REVERSE #163804 HANSON, PERRY 8 JENSEN CK #1055 - 771.11 FOR -771.11 PERIOD ENDED 10/15/06 12/27/2006 GJ DEC O6 - CK#1064 - HANSON, PERRY 8 JENSEN -INV #61105 - $806.50 806.50 FOR PERIOD ENDED 11/15/06 Legal Services 0.00 0.00 806.50 0.00 -806.50 0.0 531.307 Investment Services 10/2612006 GJ OCT O6 -ADMIN. EXPS. -SALEM FOR PERIOD 7/1 TO 9/30106 198.80 10/26/2006 RE OCT 06 -REVERSE 163807 -SALEM FOR PERIOD 7/1 TO 9/30106 -198.80 11/06/2006 GJ NOV 06 - CK #1053 -DANA INVESTMENT STATEMENT OF MGMT FEES FOR 1,252.47 PERIOD 3RD QUARTER 2006 11/06/2006 GJ NOV 06 - CK #1056 - BODGAHN CONSULT INV #2020 - $1125.00 QUARTERLY FEE 1,125.00 7/1106 TO 9130/06 11/06/2006 RE NOV O6 -REVERSE #163802 -DANA STATEMENT OF MGMT FEES FOR -1,252.47 PERIOD 3RD QUARTER 2006 11/0612006 RE NOV O6 -REVERSE #163803 - BOGDAHN INV #2020 - $1125.00 QUARTERLY FEE -1,125.00 7/1106 TO 9/30/06 11/07/2006 GJ 1117/06 -WIRE FEE TO TRANSFER FUNDS TO ICB FROM SALEM TRUST 10.00 12131/2006 GJ 12/31106 -WIRE FEE TO TRANSFER FUNDS TO ICB FROM SALEM ON 30.00 12/8; 12119 & 12121/06 Investment Services 0.00 0.00 40.00 0.00 -40.00 0.0 545.300 Insurance 10/12/2006 GJ 10112/06 - ACORDIA LIAB. INSURANCE OCT 06 TO OCT 07 839.20 $839.20 10/12/2006 GJ 10/12/06 - ACORDIA LIAB. INSURANCE OCT O6 TO OCT 07 $839.20 839.20 10/12/2006 RE 10/12/06 -REVERSE JE#163447 ACORDIA LIAB. INSUR - OCT O6 - OCT 07 -839.20 $839.20 Insurance 0.00 0.00 839.20 0.00 -839.20 0.0 .Operating Expenditures/Expense 0.00 0.00 1,685.70 0.00 -1,685.70 0.0 General 0.00 0.00 1,685.70 General Revenues 0.00 0.00 Function: 518 Pension Benefits Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 536.300 Pension Distributions/Refunds 12111/2006 GJ 12111106 - CK#1061 TO RECORD W/H TAX FROM DANIEL SOLTIS $62.14 1211112006 GJ 12111106 - CK#1058 -RECORD REFUND OF PENSION CONTRIBS. G. CARLISLE 12/11/2006 GJ 12/11106 - CK#1059 TO RECORD WIH TAX FROM G. CARLISLE $1,117.68 12/11/2006 GJ 12/11/06 - CK#1060 -RECORD REFUND OF PENSION CONTRIB. DANIEL SOLTIS 12/21/2006 GJ 12121106 - CK#1062 -RECORD REFUND OF PENSION CONTRIB - R. GARLO 12/21/2006 GJ 12/21106 - CK#1063 TO RECORD W/H TAX FROM R. GARLO - $1858.17 Pension Distributions/Refunds 0.00 0.00 1,685.70 62.14 4,470.72 $4,470.72 1,117.68 248.56 $248.56 7,432.70 $7,432.70 1,858.17 15,189.97 0.00 -1,685.70 0.0 0.00 -1,685.70 0.0 0.00 -15,189.97 0.0 Operating Expenditures/Expense 0.00 0.00 15,189.97 0.00 -15,189.97 0.0 Pension 0.00 0.00 15,189.97 0.00 -15,189.97 0.0 Pension Benefits 0.00 0.00 15,189.97 0.00 -15,189.97 0.0 Expenditures 0.00 0.00 16,875.67 0.00 -16,875.67 0.0 •