Loading...
HomeMy WebLinkAboutPension General_Documentation_Tab 13_11/06/2006VILLAGE OF TEQUESTA GENERAL EMPLOYEES' PENSION TRUST FUND SCHEDULE OF INVESTMENT ACTIVITIES FOR THE QUARTER ENDING SEP 30, 2006 BEGINNING GL BALANCE -June 30, 2006 Independent Community Bank -Cash $ 847.59 Salem Trust Company 739,711.13 INCREASES CONTRIBUTIONS Employee 18,007.11 Village 29,026.48 47,033.59 INTEREST 8~ DIVIDENDS Interest 3, 815.00 Dividend 1,613.33 5,428.33 OTHER Change in Accrued Income 630.11 Gain (Loss) on Sale of Assets 1.57 Change in Investments UnRealized Gain (Loss) on Investments 8,439.73 TOTAL INCREASES 61,533.33 DEDUCTIONS DISTRIBUTIONS Refund of Pension Contributions (3,671.23) Withholding Tax (917.81) ADMINISTRATIVE EXPENSES Bogdahn Consulting (750.00) Salem Trust -Fees (543.01) Business Services Connection (265.82) Dana Investments (1,175.30) FPPTA Membership Dues Wire Fees & Service Charge (80.53) Foreign Tax W/Held Hanson, Perry & Jensen PA (932.20) Gabriel, Roeder, Smith & Co. TOTAL DEDUCTIONS (8,335.90) ENDING GL &ICB BALANCE -Sep 30, 2006 $ 793,756.15 Transaction in transit - A. Koch (2,256.83) Salem 8~ ICB Statement Balance -Sep 30, 2006 796,012.97 $ (0.01) BALANCE SHEET QUARTER ENDED 09/30/06 Village ofTequesta Page: 2 10/23/2006 4:24 pm As of: 9/30/2006 Balances 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 Acct Class: 115 Accounts Receivable 115.102 Employer Contrib. Receivable 115.112 Employee Contrib. Receivables Acct Class: 115 Accounts Receivable 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 F/B - Unreserved/Undesignated Total Reserves/Balances Total Liabilities & Balances 1,054.70 1,054.70 4,703.25 787,998.20 792,701.45 4,677.15 2,901.46 7,578.61 801,334.76 11.71 -407.88 -396.17 -396.17 585,494.92 216,236.01 801,730.93 801,730.93 801,334.76 INCOME STATEMENT QUARTER ENDED 9130/06 Page: 2 10/23/2006 Village of Teguesta 4:31 pm QTR: 4 OTD Amd. Bud. YTD Actual OTD Actual Fund: 602 - VillageEmplovee Pension-Gen Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0.00 14,587.29 4,445.11 361.102 Dividend Income 0.00 5,689.83 1,613.33 Unrestricted Investment Earnin 0.00 20,277.12 6,058.44 Acct Class: MISC Miscellaneous Revenues 367.000 Gainll_oss-Sale of Investments 0.00 760.03 1.57 367.100 Unrealized gain/loss on invest 0.00 45,513.63 8,439.73 368.001 Pension Fund Cont-Employer 0.00 108,015.05 33,987.91 368.002 Pension Fund Cont-Employee 0.00 64,871.84 21,032.17 369.000 Other Miscellaneous Revenue 0.00 1,471.50 0.00 Miscellaneous Revenues 0.00 220,632.05 63,461.38 General 0.00 240,909.17 69,519.82 Revenues 0.00 240,909.17 69,519.82 Expenditures Dept: 000 General Acct Class: 530 Operating Expenditures/Expense 531.301 Legal Services 0.00 2,479.23 932.20 531.304 Recording Secy Service 0.00 910.22 265.82 531.307 Investment Services 0.00 7,458.14 2,548.84 531.309 Actuarial Services 0.00 4,500.00 0.00 545.3001nsurance 0.00 743.00 0.00 549.300 Other Misc Chgs & Obligations 0.00 11.71 11.71 554.300 Books, Publ, Subs & Membership 0.00 225.00 0.00 Operating ExpenditureslExpense 0.00 16,327.30 3,758.57 General 0.00 16,327.30 3,758.57 Dept: 165 Pension Acct Class: 530 Operating Expenditures/Expense 536.300 Pension Distributions/Refunds 0.00 8,345.86 4,589.04 Operating ExpenditureslExpense 0.00 8,345.86 4,589.04 Pension 0.00 8,345.86 4,589.04 Expenditures 0.00 24,673.16 8,347.61 Net Effect for Fund VillageEmplovee Pension-Gen 0.00 216,236.01 61,172.21 'Skipped Budgeted & Unbudgeted $0 Balance Accounts REVENUE REPORT Village of Tequesta For the Period: 711/2006 to 9/3012006 Page: 3 1012312006 4:32 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud Fund: 602 - VillageEmployee Pension-Gen Revenues Dept: 000 General Acct Class: 361 Unrestricted Investment Earnin 361.100 Interest Income 0713112006 GJ JUL 06 -INTEREST -SALEM $776.44 776.44 0713112006 GJ JUL 06 -REV JUN 06 ACCRUED INCOME SALEM $4,073.14 -4,073.14 0713112006 GJ JUL 06 -ACCRUED INCOME SALEM - $4,621.00 4,621.00 08/31/2006 GJ AUG 06 -INTEREST -SALEM $1,557.82 1,557.82 0813112006 GJ AUG 06 -REV. JUL 06 ACCRUED INCOME SALEM $4,621.00 -4,621.00 08131/2006 GJ AUG 06 -ACCRUED INCOME SALEM - $4,893.53 4,893.53 0912912006 GJ SEP 06 -INTEREST -SALEM $1,480.74 1,480.74 0912912006 GJ SEP O6 -REVERSING AUG O6 ACCRUED INCOME $4,893.53 -4,893.53 09129/2006 GJ SEP 06 -ACCRUED INCOME -SALEM $4,703.25 4,703.25 Interest Income 0.00 0.00 4,445.11 0.00 -4,445.11 0.0 361.102 Dividend Income 0713112006 GJ JUL 06 -DIVIDENDS -SALEM $470.73 470.73 0813112006 GJ AUG 06 -DIVIDENDS -SALEM $390.10 390.10 09/2912006 GJ SEP 06 -DIVIDENDS -SALEM $752.50 752.50 Dividend Income 0.00 0.00 1,613.33 0.00 -1,613.33 0.0 Unrestricted Investment Earnin 0.00 0.00 6,058.44 0.00 -6,058.44 0.0 Acct Class: MISC Miscellaneous Revenues 367.000 GainlLoss-Sale of Investments 0713112006 GJ JUL 06 -SALE OF INVEST -LOSS SALEM ($0.59) -0.59 0813112006 GJ AUG 06 -SALE OF INVEST -GAIN SALEM $3.96 3.96 09129/2006 GJ SEP 06 -SALEM -SALE OF INVEST - LOSS - ($1.80) -1.80 GainlLoss-Sale of Investments 0.00 0.00 1.57 367.100 Unrealized gainlloss on invest 07/31/2006 GJ JUL 06 -UNREALIZED LOSS SALEM - ($5,167.78) -5,167.78 0813112006 GJ AUG O6 -UNREALIZED GAIN SALEM - $6,279.27 6,279.27 0912912006 GJ SEP 06 -SALEM -UNREALIZED GAIN $7,328.24 7,328.24 Unrealized gainlloss on invest 368.001 Pension Fund Cont-Employer 0711412006 PA VOT PENSION DEPOSIT-PID 07114106 07/2812006 PA VOT PENSION DEPOSITS-PID 07128106 0811112006 PA VOT PENSION DEPOSITS-PID 08/11106 08125/2006 PA VOT PENSION DEPOSIT-P/D 08125/06 0910812006 PA VOT PENSION DEPOSITS-PID 09108106 09/22/2006 PA VOT PENSION DEPOSIT-P1D 09/22106 0912812006 GJ do d coopers pension contributions to 09/28/2006 GJ rlc d cooper's pension contributions to 0912812006 GJ r/c d coopers pension contributions to 09/28/2006 RE correcting typo on je # 162560- 0912812006 RE correcting typo on je # 162560- 0913012006 PA VOT PENSION DEPOSIT-PID 09130106 Pension Fund Cont-Employer 368.002 Pension Fund Cont-Employee 07/14/2006 PA VOT PENSION DEPOSIT-PID 07114106 0712812006 PA VOT PENSION DEPOSITS-P/D 07128106 08/1112006 PA VOT PENSION DEPOSITS-PID 08111106 0812512006 PA VOT PENSION DEPOSIT-PID 08/25106 0910812006 PA VOT PENSION DEPOSITS-PID 09108/06 0912212006 PA VOT PENSION DEPOSIT-PID 09122106 0912812006 GJ rlc d coopers pension contributions to 0.00 0.00 8,439.73 4,382.50 5,639.21 4,764.19 4,808.78 4,714.34 4,717.46 correct accnt (genrl pension), they were 123.60 correct accnt (gend pension), they were 284.28 correct accnt (genrl pension), they were 284.28 correct accnt (genrl pension), they were -284.28 correct accnt (genrl pension), they were -123.60 SETTING UP ACCOUNTS REC FOR FYE 0 4,677.15 0.00 0.00 33,987.91 2,718.67 2,880.08 2,955.46 3,189.38 3,156.79 3,106.73 correct accnt (gend pension), they were 123.60 0.00 -1.57 0.0 0.00 -8,439.73 0.0 recrd'd as police contributions in error recrd'd as police contributions in error recrd'd as police contributions in error recrd'd as police contributions in error recrd'd as police contributions in error 0.00 -33,987.91 0.0 recrd'd as police contributions in error REVENUE REPORT Village of Tequesta For the Period: 7/112006 to 9130/2006 Page: 4 10/23/2006 4:32 pm Original Bud. Amended Bud. OTD Actual Encumb. YTD UnencBal % Bud Fund: 602 - VillageEmployee Pension-Gen Revenues Dept: 000 General Acct Class: MISC Miscellaneous Revenues 09130/2006 PA VOT PENSION DEPOSIT-PID 09130106 SETTING UP ACCOUNTS REC FOR FYE 0 2,901.46 Pension Fund Cont-Employee 0.00 0.00 21,032.17 0.00 -21,032.17 0.0 Miscellaneous Revenues 0.00 0.00 63,461.38 0.00 -63,461.38 0.0 General 0.00 0.00 69,519.82 0.00 -69,519.82 0.0 Revenues 0.00 0.00 69,519.82 0.00 -69,519.82 0.0 EXPENDITURE REPORT Village of Tequesta For the Period: 7/1/2006 to 913012006 Original Bud. Amended Bud. QTD Actual Encumb. YTD UnencBal % Bud Fund: 602 - VillageEmployee Pension-Gen Expenditures Dept: 000 General Acct Class: 530 Operating ExpenditureslExpense 531.301 Legal Services 0810712006 GJ AUG 06 - CK #1043 - HANSON, PERRY & JENSEN -INV #60735 - $932.20 Legal Services 0.00 0.00 531.304 Recording Secy Service 08107/2006 GJ AUG 06 - CK#1042 -BUSINESS SERV. CONNECTION -INV #T6-27 $265.82 Recording Secy Service 0.00 0.00 531.307 Investment Services 0810712006 GJ AUG 06 - CK#1044 - BOGDAHN CONSULT INV #1901 - $750.00 - QTRLY FEE 08/0712006 GJ AUG 06 - CK#1045 -DANA INVESTMENT STATEMENT OF MANAGEMENT FEES 08/0712006 GJ AUG 06 -ADMIN. EXPS. -SALEM FOR THE PERIOD 4/1106 TO 6/30/O6 0813112006 GJ AUG 06 -WIRE FEE TO TRANSFER FUNDS TO ICB FROM SALEM TRUST 0912912006 GJ SEP 06 -WIRE FEE TO TRANSFER FUNDS FROM SALEM TO ICB 09/2912006 GJ SEP 06 -CHECKS FEE -ORDERED CHECKS FROM ICB Investment Services 0.00 0.00 549.300 Other Misc Chgs & Obligations 0910712006 GJ SEP 06 - PYMT DUE TO GEN FUND FOR UNITED SHIPPING SOLUTIONS - OtherMisc Chgs & Obligations 0.00 0.00 Operating ExpenditureslExpense 0.00 0.00 3,758.57 0.00 -3,758.57 0.0 General 0.00 0.00 3,758.57 Dept: 165 Pension Acct Class: 530 Operating ExpenditureslExpense 536.300 Pension DistributionslRefunds 07118/2006 GJ JUL O6 - CK#1040 -RECORD REFUND OF PENSION CONTRIBS. - R. RAMDEEN 56.00 $56.00 07118/2006 GJ JUL 06 - CK#1041 -RECORD W/HOLD TAX - R. RAMDEEN $14.00 14.00 0811412006 GJ AUG O6 - CK#1046 -RECORD REFUND OF PENSION CONTRIBS. KEVIN SOSSI 201.50 $201.50 0811412006 GJ AUG O6 - CK#1047 -RECORD W/HOLD TAX FROM KEVIN SOSSI $50.38 50.38 09/2212006 GJ SEP 06 - CK #1049 -RECORD WIHOLD TAX FROM DAVID COOPER $289.22 289.22 09122/2006 GJ SEP O6 - CK #1048 -RECORD REFUND OF PENSION CONTRIBS - D. COOPER 1,156.90 $1,156.90 0912212006 GJ SEP 06 - CK #1051 - RECORD WIH TAX FROM ANNE KOCH - $564.21 564.21 0912212006 GJ SEP 06 - CK #1050 -RECORD REFUND OF PENSION CONTRIB. - A. KOCH 2,256.83 $2,256.83 Pension Distributions/Refunds 0.00 0.00 4,589.04 Operating ExpenditureslExpense 0.00 0.00 4,589.04 0.00 -4,589.04 0.0 932.20 FOR THE PERIOD ENDED 7/15106 932.20 0.00 -932.20 0.0 265.82 MEETING HELD ON 4/24106 265.82 0.00 -265.82 0.0 750.00 411106 TO 6130/06 1,175.30 PERIOD 2ND QUARTER 2006 543.01 30.00 10.00 40.53 2,548.84 0.00 -2,548.84 0.0 11.71 PENSION 11.71 0.00 -11.71 0.0 Page: 2 10/23/2006 4:33 pm 0.00 -3,758.57 0.0 0.00 -0,589.04 0.0 Pension 0.00 0.00 4,589.04 0.00 -4,589.04 0.0 Expenditures 0.00 0.00 8,347.61 0.00 -8,347.61 0.0