The URL can be used to link to this page

Home My WebLink About04. Cash Reportsr,A cry of Oshkosh TO: Honorable Mayor and Members of the Common Council FROM: Trena Larson, Finance Director DATE: June 18, 2018 RE: March and April Cash Investment Recapitulations Attached is the Cash and Investment Recapitulations of City operations, utility, and trust accounts for the Months of March and April 2018. Respectfully submitted, Tena lw,son Trena Larson Director of Finance City of Oshkosh Enc City Hail, 215 Church Avenue P.O. Box 1 130 Oshkosh, WI 54403-1130 http://www,ci.oshkosh.wi.us OPERATING FUNDS PENSION FUNDS TRUST FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of March 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $65,188,679.56 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 7,485.00 Police Pension 3,475.82 Firemen's Pension 5,308.77 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,353.58 Cemetery Perpetual Care 1,608.53 Leander Choate 5,173.38 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 26,125.03 Gould 200.00 Abbey Harris Library 3,624.50 Heyman 375.54 Hicks 1,807.30 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 5,503.05 Kitz Directors Trust 8,418.11 Library Collection Improvement Trust 0.00 Library Development and Support Trust 0.00 Library Facility Trust 0.00 Library Programming Support Trust 0.00 Library Technology Trust 0.00 Maxwell -Crawford 167.05 Museum Endowment 2,469.90 Public Library Memorial Fund 117,460.93 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $20,068,516.46 0.00 65,200,014.56 0.00 20,068,516.46 557,419.30 8,784.59 142,271.04 283,983.13 15,836.25 1,212,917.93 55,761.54 238.02 7,308.56 3,441, 550.86 0.00 3,639.35 218,791.86 34,265.61 185,702.38 4,479.89 1,029.00 4,437.02 1,237.40 58,587.84 247,015.56 1,572,146.72 444,916.39 1,106,516.55 172,805.49 352,600.86 7,243.29 428,846.26 0.00 0.00 27,809.46 2,268.55 9,466.78 699,690.34 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of March 31, 2018 Page 2 of 2 CASH CASH INVESTMENTS COST I 2018 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,155.74 Stanhilber - Library & Parks 22,782.08 779,126.86 Stanhilber - Parks Only 10.68 1,310.15 M. Zellmer Library 0.00 206,482.11 26,903.34 10,713,898.64 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,685.18 108,785.40 UTILITY FUNDS Water Utility - Operating $2,031,480.51 $1,100,375.37 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,434,246.95 Water Utility - Bond/Note 12,311,897.02 0.00 Sewerage Utility - Operating 7,639,306.60 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 15,272,225.58 119,152.94 Sewerage Utility - Debt Service 0.00 3,278,782.11 Storm Water Utility - Operating 2,597,006.26 516.33 Storm Water Utility - Bond/Note 6,271,771.51 0.00 Storm Water Utility - Debt Service 0.00 5,069,922.01 Parking Utility - Operating 77,218.77 46,200,906.25 0.00 15,067,396.08 TOTAL FUNDS $111,616,187.51 $46,658,286.92 CASH RECONCILIATION Associated Bank of Oshkosh $112,270,252.53 Sub -Total, Bank Balances 112,270,252.53 Less: Outstanding Checks 1,423,063.10 Total Cash in Banks 110,847,189.43 Plus, Cash/Deposits in Transit 768,998.08 TOTAL CASH $111,616,187.51 Page 2 of 2 OPERATING FUNDS General Fund Treasurer's Working Fund Other Petty Cash Funds PENSION FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of April 30, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL $59,135,406.44 3,850.00 7,485.00 $19,168,429.06 0.00 59,146,741.44 0.00 19,168,429.06 Police Pension 22,624.04 536,427.67 Firemen's Pension 10,476.76 33,100.80 136,296.89 TRUST FUNDS Behncke Museum Trust 6,246.09 284,200.38 William E. Bray Museum Trust 4,382.94 15,836.25 Cemetery Perpetual Care 1,261.48 1,213,564.98 Leander Choate 5,107.57 55,827.35 Clute 0.00 238.30 Amy Davies Library Fund 0.00 7,308.56 Durow Trust 0.00 3,441,550.86 Fisk -Gallup 26,125.03 0.00 Gould 200.00 3,643.64 Abbey Harris Library 3,481.63 218,934.73 Heyman 378.94 34,304.43 Hicks 1,807.30 180,753.27 Hilton Library & Museum 0.00 4,479.89 Hilton Special Library 0.00 1,029.00 Huhn Animal Shelter Trust 0.00 4,442.26 Hume 43.31 1,238.86 Kitz Museum Memorial Trust 5,503.05 58,607.36 Kitz Directors Trust 8,418.11 247,307.07 Library Collection Improvement Trust 0.00 1,547,564.91 Library Development and Support Trust 0.00 450,920.93 Library Facility Trust 0.00 1,103,605.48 Library Programming Support Trust 0.00 165,719.71 Library Technology Trust 0.00 351,504.74 Maxwell -Crawford 168.78 7,251.03 Museum Endowment 2,469.90 428,894.23 Public Library Memorial Fund 84,254.76 0.00 Pittel 0.00 0.00 Rasmussen Library, Mabel 0.00 27,809.46 Roberts 105.48 2,271.23 Rojahn, Frank and Anna 0.00 9,466.78 Page 1 of 2 672,724.56 TRUST FUNDS (continued) OTHER FUNDS UTILITY FUNDS TOTALFUNDS CASH RECONCILIATION CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of April 30, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL Sarau $7.57 $5,161.82 Stanhilber - Library & Parks 23,794.03 779,126.86 Stanhilber - Parks Only 10.68 1,473.63 M. Zellmer Library 0.00 173,766.65 26,903.34 Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,710.32 Water Utility - Operating Water Utility - Depreciation Water Utility - Special Redemption Water Utility - Bond/Note Sewerage Utility - Operating Sewerage Utility - Replacement Sewerage Utility - Bond/Note Sewerage Utility - Debt Service Storm Water Utility - Operating Storm Water Utility - Bond/Note Storm Water Utility - Debt Service Parking Utility - Operating Associated Bank of Oshkosh Sub -Total, Bank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash/Deposits in Transit $3,130,560.42 0.00 0.00 11,223,544.55 8,443,567.64 0.00 14,004,337.81 0.00 5,674,277.54 2,928,664.51 0.00 77.218.77 $106,016,454.82 106,016,454.82 1,367,152.41 104,649,302.41 186,477.72 TOTAL CASH $104,835,780.13 Page 2 of 2 45,482,171.24 $104,835,780.13 $1,101,737.57 140,008.36 3,835,658.31 0.00 0.00 1,924,392.01 76.60 4,400,670.25 516.97 0.00 5,495,658.39 0.00 10,680,941.34 108.810.54 16,898,718.46 $47,529,623.96