The URL can be used to link to this page

Home My WebLink About02. Cash Reports City 0' Oshkosh November 27, 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 August and September 2018. Respectfully submitted, P"qm w&"MjC"C-& 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 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of August 31,2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $53,847,180.42 $19,191,804.58 Treasurer's Working Fund 3,850.00 0.00 Other Petty Cash Funds 8,485.00 53,859,515.42 0.00 19,191,804.58 PENSION FUNDS Police Pension 17,068.70 536,469.07 Firemen's Pension 8,161.63 25,230.33 136,436.28 672,905.35 TRUST FUNDS Behncke Museum Trust 6,246.09 284,688.94 William E.Bray Museum Trust 4,503.37 15,836.25 Cemetery Perpetual Care 1,850.00 1,215,020.09 Leander Choate 4,959.58 55,975.34 Clute 0.00 238.94 Amy Davies Library Fund 0.00 7,308.56 Durow Trust (97,867.96) 3,441,550.86 Fisk-Gallup 10,305.88 0.00 Gould 200.00 3,653.30 Abbey Harris Library 3,160.33 219,256.03 Heyman 393.34 34,391.72 Hicks 1,914.55 181,198.63 Hilton Library&Museum 0.00 4,479.89 Hilton Special Library 0.00 1,029.00 Huhn Animal Shelter Trust 0.00 4,454.04 Hume 43.31 1,242.15 Kitz Museum Memorial Trust 5,503.05 58,651.26 Kitz Directors Trust 8,418.11 247,962.62 Library Collection Improvement Trust 0.00 1,584,721.83 Library Development and Support Trust 0.00 468,672.94 Library Facility Trust 0.00 1,145,055.81 Library Programming Support Trust 0.00 190,018.72 Library Technology Trust 0.00 366,484.86 Maxwell-Crawford 176.06 7,074.80 Museum Endowment 2,469.90 429,002.10 Public Library Memorial Fund 92,900.00 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 27,809.46 Roberts 105.48 2,277.25 Rojahn,Frank and Anna 0.00 9,466.78 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of August 31,2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sa rau $7.57 $5,175.50 Stanhilber-Library&Parks 28,696.24 779,494.44 Stanhilber-Parks Only 10.68 1,473.63 M.Zellmer Library 0.00 73,995.58 26,903.34 10,820,569.08 OTHER FUNDS Cable TV Franchise-Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,818.41 108,918.63 UTILITY FUNDS Water Utility-Operating $4,770,665.59 $1,108,471.51 Water Utility-Depreciation 0.00 140,008.36 Water Utility-Special Redemption 0.00 3,860,091.40 Water Utility-Bond/Note 8,887,768.19 0.00 Sewerage Utility-Operating 5,138,977.87 0.00 Sewerage Utility-Replacement 0.00 1,924,392.01 Sewerage Utility-Bond/Note 13,913,607.86 (0.00) Sewerage Utility-Debt Service 0.00 4,432,581.07 Storm Water Utility-Operating 7,043,524.42 520.13 Storm Water Utility-Bond/Note 13,779,049.45 0.00 Storm Water Utility-Debt Service 0.00 5,530,500.87 Parking Utility-Operating 113,838.10 53,647,431.48 0.00 16,996,565.35 TOTAL FUNDS $107,606,172.81 $47,790,762.99 CASH RECONCILIATION Associated Bank of Oshkosh $110,288,329.00 Sub-Total,Bank Balances 110,288,329.00 Less: Outstanding Checks 2,747,420.01 Total Cash in Banks 107,540,908.99 Plus,Cash/Deposits in Transit 65,263.82 TOTAL CASH $107,606,172.81 Page 2 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of September 30,2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $46,464,340.41 $19,191,734.81 Treasurer's Working Fund 3,850.00 0.00 Other Petty Cash Funds 8,485.00 46,476,675.41 0.00 19,191,734.81 PENSION FUNDS Police Pension 16,813.10 536,479.99 Firemen's Pension 7,329.62 24,142.72 136,473.04 672,953.03 TRUST FUNDS Behncke Museum Trust 6,246.09 285,252.46 William E.Bray Museum Trust 4,534.17 15,836.25 Cemetery Perpetual Care 171.60 1,216,698.49 Leander Choate 4,788.88 56,146.04 Clute 0.00 239.67 Amy Davies Library Fund 0.00 7,308.56 Durow Trust (175,803.46) 3,441,550.86 Fisk-Gallup 5,615.34 0.00 Gould 200.00 3,664.44 Abbey Harris Library 2,789.72 219,626.64 Heyman 397.03 34,492.42 Hicks 2,021.80 181,712.33 Hilton Library&Museum 0.00 4,479.89 Hilton Special Library 0.00 1,029.00 Huhn Animal Shelter Trust 0.00 4,467.62 Hume 43.31 1,245.93 Kitz Museum Memorial Trust 5,503.05 58,701.89 Kitz Directors Trust 8,418.11 248,718.77 Library Collection Improvement Trust 0.00 1,588,388.76 Library Development and Support Trust 0.00 470,296.03 Library Facility Trust 0.00 1,148,843.10 Library Programming Support Trust 0.00 192,263.12 Library Technology Trust 0.00 368,055.95 Maxwell-Crawford 177.88 7,094.87 Museum Endowment 2,469.90 429,126.53 Public Library Memorial Fund 93,994.42 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 27,809.46 Roberts 105.48 2,284.20 Rojahn,Frank and Anna 0.00 9,466.78 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of September 30,2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sa rau $7.57 $5,191.28 Stanhilber-Library&Parks 30,657.42 779,918.47 Stanhilber-Parks Only 10.68 1,473.63 M.Zellmer Library 0.00 (7,651.01) 26,903.34 10,838,286.78 OTHER FUNDS Cable TV Franchise-Escrow 0.00 10,100.22 GO-HNI Collateralization 0.00 203,135.14 Museum Membership Fund 0.00 0.00 98,844.94 312,080.30 UTILITY FUNDS Water Utility-Operating $4,483,051.63 $1,110,247.35 Water Utility-Depreciation 0.00 140,008.36 Water Utility-Special Redemption 0.00 3,848,496.73 Water Utility-Bond/Note 8,895,316.66 0.00 Sewerage Utility-Operating 6,451,853.18 0.00 Sewerage Utility-Replacement 0.00 1,924,392.01 Sewerage Utility-Bond/Note 13,924,706.47 (0.00) Sewerage Utility-Debt Service 0.00 4,419,068.19 Storm Water Utility-Operating 8,304,482.81 520.96 Storm Water Utility-Bond/Note 13,790,322.31 0.00 Storm Water Utility-Debt Service 0.00 5,518,505.04 Parking Utility-Operating 54,864.45 55,904,597.51 0.00 16,961,238.64 TOTAL FUNDS $102,397,764.63 $47,976,293.56 CASH RECONCILIATION Associated Bank of Oshkosh $104,172,645.42 Sub-Total,Bank Balances 104,172,645.42 Less: Outstanding Checks 1,886,890.44 Total Cash in Banks 102,285,754.98 Plus,Cash/Deposits in Transit 112,009.65 TOTAL CASH $102,397,764.63 Page 2 of 2