Loading...
HomeMy WebLinkAbout03. Cash Report October 2018December 6, 2018 City Manager and Members of Common Council City of Oshkosh, Wisconsin City Manager and Council Members: Attached is the Cash and Investment Recapitulations of City operations, utility, and trust accounts for the Months of October 2018. Respectfully submitted, pw+2G�e% Jennifer L. Messerschmidt, CPA Assistant Director of Finance City of Oshkosh Enc City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 http://www.ci.oshkosh.wi.us OPERATING FUNDS PENSION FUNDS TRUST FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of October 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $58,819,950.49 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 8,485.00 Police Pension 16,813.10 Firemen's Pension 7,329.62 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,565.19 Cemetery Perpetual Care (336.03) Leander Choate 4,696.57 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust (175,803.46) Fisk -Gallup 5,615.34 Gould 200.00 Abbey Harris Library 2,589.31 Heyman 400.41 Hicks 2,021.80 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 179.58 Museum Endowment 2,469.90 Public Library Memorial Fund 95,776.10 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $3,835,502.85 0.00 58,832,285.49 0.00 536,491.30 24,142.72 136, 511.13 285, 557.20 15,836.25 1,217,606.12 56,238.35 240.06 7,308.56 3,441,550.86 0.00 3,670.46 219, 827.05 34, 546.87 181, 990.12 4,479.89 1,029.00 4,474.96 1,247.98 58,729.27 249,127.67 1,588, 388.76 470,296.03 1,148, 843.10 192,263.12 368,055.95 7,105.72 429,193.82 0.00 0.00 27,809.46 2,287.96 9,466.78 3,835,502.85 673, 002.43 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of October 31. 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,199.81 Stanhilber - Library & Parks 21,669.28 780,147.80 Stanhilber - Parks Only 10.68 1,473.63 M. Zellmer Library 0.00 (15,621.72) 26,903.34 10,840,895.95 OTHER FUNDS Cable TV Franchise - Escrow GO-HNI Collateralization Museum Membership Fund UTILITY FUNDS 0.00 10,100.22 0.00 203,135.14 0.00 0.00 92,375.84 305,611.20 Water Utility - Operating $6,008,972.46 $1,112,087.55 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,851,490.55 Water Utility - Bond/Note 7,380,393.72 0.00 Sewerage Utility - Operating 9,430,825.92 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 10,852,533.28 (0.00) Sewerage Utility - Debt Service 0.00 4,431,628.06 Storm Water Utility - Operating 9,140,934.36 521.82 Storm Water Utility - Bond/Note 12,911,115.40 0.00 Storm Water Utility - Debt Service 0.00 5,532,405.85 Parking Utility - Operating 54,864.45 55,779,639.59 0.00 16,992,534.20 TOTAL FUNDS $114,620,446.08 $32,647,546.63 CASH RECONCILIATION Associated Bank of Oshkosh $114,654,486.09 Sub -Total, Bank Balances 114,654,486.09 Less: Outstanding Checks 445,888.40 Total Cash in Banks 114,208,597.69 Plus, Cash/Deposits in Transit 411,848.39 TOTAL CASH $114,620,446.08 Page 2 of 2