The URL can be used to link to this page

Home My WebLink About03. Cash Reports tl if 0)", Oshkosh May 23, 2019 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 January, February, March, and April 2019. Respectfully submitted, *, - � !�l�/�22ityxwo* Jennifer L. Messerschmidt, CPA Assistant Director of Finance City of Oshkosh JLM 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 January 31,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $73,663,661.11 $3,867,764.07 Treasurer's Working Fund 4,850.00 0.00 Other Petty Cash Funds 9,485.00 73,677,996.11 0.00 3,867,764.07 PENSION FUNDS Police Pension 12,982.36 557,129.34 Firemen's Pension 5,756.05 18,738.41 140,056.62 697,185.96 TRUST FUNDS Behncke Museum Trust 6,246.09 282,663.09 William E.Bray Museum Trust 4,954.23 14,461.81 Cemetery Perpetual Care 30,589.92 1,139,973.75 Leander Choate 4,420.96 56,701.45 Clute 0.00 242.04 Amy Davies Library Fund 0.00 6,920.53 Durow Trust 0.00 3,307,143.79 Fisk-Gallup 3,376.74 0.00 Gould 200.00 3,700.68 Abbey Harris Library 1,990.92 219,944.22 Heyman 411.47 34,762.07 Hicks 2,129.05 182,110.31 Hilton Library&Museum 0.00 4,290.51 Hilton Special Library 0.00 985.50 Huhn Animal Shelter Trust 0.00 4,511.81 Hume 43.31 1,258.26 Kitz Museum Memorial Trust 5,503.05 283,306.03 Kitz Directors Trust 8,418.11 251,179.15 Library Collection Improvement Trust 0.00 967,470.63 Library Development and Support Trust 0.00 466,365.95 Library Facility Trust 0.00 1,087,920.45 Library Programming Support Trust 0.00 646,105.31 Library Technology Trust 0.00 394,083.67 Maxwell-Crawford 185.11 7,324.81 Museum Endowment 2,569.90 394,458.48 Public Library Memorial Fund 101,183.29 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 28,251.72 Roberts 105.48 2,306.80 Rojahn,Frank and Anna 0.00 8,035.94 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of January 31,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sarau $7.57 $5,242.62 Stanhilber-Library&Parks 25,326.46 771,837.71 Stanhilber-Parks Only 10.68 1,254.76 M.Zellmer Library 0.00 197,672.34 23,977.74 10,598,791.59 OTHER FUNDS Tax Collection 0.00 304.29 Cable TV Franchise-Escrow 0.00 10,304.00 GO-HNI Collateralization 0.00 204,380.34 Museum Membership Fund 0.00 0.00 92,457.36 307,445.99 UTILITY FUNDS Water Utility-Operating $7,441,845.71 $1,117,566.73 Water Utility-Depreciation 0.00 143,827.03 Water Utility-Special Redemption 0.00 3,917,452.57 Water Utility-Bond/Note 4,955,061.22 0.00 Sewerage Utility-Operating 15,529,391.70 0.00 Sewerage Utility-Replacement 0.00 1,976,879.03 Sewerage Utility-Bond/Note 6,641,868.44 (0.00) Sewerage Utility-Debt Service 0.00 4,495,753.79 Storm Water Utility-Operating 16,861,362.81 524.40 Storm Water Utility-Bond/Note 6,806,421.67 0.00 Storm Water Utility-Debt Service 0.00 5,607,182.64 Parking Utility-Operating 50,177.35 58,286,128.90 0.00 17,259,186.19 TOTAL FUNDS $132,180,535.76 $32,730,373.80 CASH RECONCILIATION Associated Bank of Oshkosh $130,728,652.46 Sub-Total,Bank Balances 130,728,652.46 Less: Outstanding Checks 858,792.97 Total Cash in Banks 129,869,859.49 Plus,Cash/Deposits in Transit 2,310,676.27 TOTAL CASH $132,180,535.76 Page 2 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of February 28,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $53,261,139.07 $13,870,095.83 Treasurer's Working Fund 4,850.00 0.00 Other Petty Cash Funds 9,485.00 53,275,474.07 0.00 13,870,095.83 PENSION FUNDS Police Pension 12,555.80 557,139.61 Firemen's Pension 5,019.89 17,575.69 140,091.20 697,230.81 TRUST FUNDS Behncke Museum Trust 107,828.34 187,475.45 William E.Bray Museum Trust 4,984.19 14,461.81 Cemetery Perpetual Care 108,368.29 1,062,162.56 Leander Choate 4,420.96 56,786.67 Clute 0.00 242.40 Amy Davies Library Fund 0.00 6,920.53 Durow Trust 0.00 3,307,143.79 Fisk-Gallup 3,376.74 0.00 Gould 200.00 3,706.24 Abbey Harris Library 1,990.92 220,129.25 Heyman 415.15 34,812.34 Hicks 10,536.65 173,946.55 Hilton Library&Museum 0.00 4,290.51 Hilton Special Library 0.00 985.50 Huhn Animal Shelter Trust 0.00 4,518.59 Hume 43.31 1,260.15 Kitz Museum Memorial Trust 5,503.05 283,331.31 Kitz Directors Trust 8,418.11 251,556.68 Library Collection Improvement Trust 0.00 985,673.88 Library Development and Support Trust 0.00 467,512.25 Library Facility Trust 0.00 1,104,836.97 Library Programming Support Trust 0.00 658,235.99 Library Technology Trust 0.00 402,669.32 Maxwell-Crawford 186.96 7,334.83 Museum Endowment 94,429.56 314,690.18 Public Library Memorial Fund 61,326.08 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 28,251.72 Roberts 105.48 2,310.27 Rojahn,Frank and Anna 0.00 8,035.94 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of February 28,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sarau $7.57 $5,250.50 Stanhilber-Library&Parks 114,486.77 681,295.22 Stanhilber-Parks Only 10.68 1,254.76 M.Zellmer Library 0.00 526,638.81 23,977.74 10,305,059.90 OTHER FUNDS Tax Collection 0.00 304.29 Cable TV Franchise-Escrow 0.00 10,304.00 GO-HNI Collateralization 0.00 204,380.34 Museum Membership Fund 0.00 0.00 92,482.18 307,470.81 UTILITY FUNDS Water Utility-Operating $7,748,556.31 $1,119,237.48 Water Utility-Depreciation 0.00 143,827.03 Water Utility-Special Redemption 0.00 3,919,464.70 Water Utility-Bond/Note 4,661,321.11 0.00 Sewerage Utility-Operating 15,541,027.14 0.00 Sewerage Utility-Replacement 0.00 1,976,879.03 Sewerage Utility-Bond/Note 6,652,402.40 (0.00) Sewerage Utility-Debt Service 0.00 4,505,824.08 Storm Water Utility-Operating 16,873,212.31 525.18 Storm Water Utility-Bond/Note 6,819,202.40 0.00 Storm Water Utility-Debt Service 0.00 5,611,838.96 Parking Utility-Operating 50,177.35 58,345,899.02 0.00 17,277,596.46 TOTAL FUNDS $112,165,587.59 $42,457,453.81 CASH RECONCILIATION Associated Bank of Oshkosh $112,303,469.31 Sub-Total,Bank Balances 112,303,469.31 Less: Outstanding Checks 495,614.20 Total Cash in Banks 111,807,855.11 Plus,Cash/Deposits in Transit 357,732.48 TOTAL CASH $112,165,587.59 Page 2 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of March 31,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $55,988,782.44 $13,877,658.19 Treasurer's Working Fund 4,850.00 0.00 Other Petty Cash Funds 9,485.00 56,003,117.44 0.00 13,877,658.19 PENSION FUNDS Police Pension 13,970.41 559,001.82 Firemen's Pension 4,187.88 18,158.29 140,509.41 699,511.23 TRUST FUNDS Behncke Museum Trust 107,828.34 187,786.19 William E.Bray Museum Trust 16,216.83 4,041.52 Cemetery Perpetual Care 109,891.31 1,063,040.36 Leander Choate 4,420.96 56,880.79 Clute 0.00 242.80 Amy Davies Library Fund 0.00 0.00 Durow Trust 0.00 3,307,143.79 Fisk-Gallup 20,093.74 0.00 Gould 200.00 3,712.38 Abbey Harris Library 1,990.92 220,333.61 Heyman 418.80 34,867.86 Hicks 10,647.65 174,215.85 Hilton Library&Museum 0.00 4,290.51 Hilton Special Library 0.00 985.50 Huhn Animal Shelter Trust 0.00 4,526.08 Hume 43.31 1,262.24 Kitz Museum Memorial Trust 5,503.05 284,484.82 Kitz Directors Trust 8,418.11 251,973.63 Library Collection Improvement Trust 0.00 992,175.37 Library Development and Support Trust 0.00 470,595.96 Library Facility Trust 0.00 1,112,124.43 Library Programming Support Trust 0.00 662,577.69 Library Technology Trust 0.00 405,325.32 Maxwell-Crawford 188.84 7,345.90 Museum Endowment 94,429.56 316,436.51 Public Library Memorial Fund 84,757.46 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 28,251.72 Roberts 105.48 2,314.10 Rojahn,Frank and Anna 0.00 8,035.94 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of March 31,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sarau $7.57 $5,259.20 Stanhilber-Library&Parks 115,499.58 681,529.05 Stanhilber-Parks Only 10.68 1,254.76 M.Zellmer Library 0.00 580,672.19 12,003.39 10,305,017.27 OTHER FUNDS Tax Collection 0.00 304.52 Cable TV Franchise-Escrow 0.00 10,304.00 GO-HNI Collateralization 0.00 205,870.54 Museum Membership Fund 0.00 0.00 92,507.89 308,986.95 UTILITY FUNDS Water Utility-Operating $7,755,779.97 $1,121,092.58 Water Utility-Depreciation 0.00 143,827.03 Water Utility-Special Redemption 0.00 3,933,653.07 Water Utility-Bond/Note 4,665,790.86 0.00 Sewerage Utility-Operating 15,555,359.04 0.00 Sewerage Utility-Replacement 0.00 1,976,879.03 Sewerage Utility-Bond/Note 6,658,781.40 (0.00) Sewerage Utility-Debt Service 0.00 4,529,978.68 Storm Water Utility-Operating 16,889,392.07 526.05 Storm Water Utility-Bond/Note 6,825,741.37 0.00 Storm Water Utility-Debt Service 0.00 5,632,010.14 Parking Utility-Operating 65,177.35 58,416,022.06 0.00 17,337,966.58 TOTAL FUNDS $115,017,969.98 $42,529,140.22 CASH RECONCILIATION Associated Bank of Oshkosh $115,104,158.92 Sub-Total,Bank Balances 115,104,158.92 Less: Outstanding Checks 1,135,114.74 Total Cash in Banks 113,969,044.18 Plus,Cash/Deposits in Transit 1,048,925.80 TOTAL CASH $115,017,969.98 Page 2 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of April 30,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $49,569,219.29 $13,893,919.20 Treasurer's Working Fund 4,850.00 0.00 Other Petty Cash Funds 9,485.00 49,583,554.29 0.00 13,893,919.20 PENSION FUNDS Police Pension 13,543.85 559,012.87 Firemen's Pension 16,166.05 29,709.90 129,139.13 688,152.00 TRUST FUNDS Behncke Museum Trust 107,828.34 188,087.39 William E.Bray Museum Trust 16,228.40 4,041.52 Cemetery Perpetual Care 110,091.31 1,064,473.48 Leander Choate 4,420.96 56,972.02 Clute 0.00 243.19 Amy Davies Library Fund 0.00 0.00 Durow Trust 0.00 3,307,143.79 Fisk-Gallup 20,093.74 0.00 Gould 200.00 3,718.33 Abbey Harris Library 108,852.50 125,469.20 Heyman 422.47 34,921.68 Hicks 10,647.65 174,476.89 Hilton Library&Museum 0.00 4,290.51 Hilton Special Library 0.00 985.50 Huhn Animal Shelter Trust 0.00 4,533.34 Hume 43.31 1,264.26 Kitz Museum Memorial Trust 5,503.05 284,511.88 Kitz Directors Trust 8,418.11 252,377.79 Library Collection Improvement Trust 0.00 1,015,760.99 Library Development and Support Trust 0.00 482,132.73 Library Facility Trust 0.00 1,138,561.47 Library Programming Support Trust 0.00 678,328.25 Library Technology Trust 0.00 414,960.57 Maxwell-Crawford 190.71 7,356.63 Museum Endowment 94,429.56 323,040.98 Public Library Memorial Fund 94,902.72 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 28,251.72 Roberts 105.48 2,317.81 Rojahn,Frank and Anna 0.00 8,035.94 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of April 30,2019 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sarau $7.57 $5,267.64 Stanhilber-Library&Parks 211,752.79 597,255.71 Stanhilber-Parks Only 10.68 1,254.76 M.Zellmer Library 0.00 794,149.35 12,003.39 10,222,039.36 OTHER FUNDS Tax Collection 0.00 304.52 Cable TV Franchise-Escrow 0.00 10,304.00 GO-HNI Collateralization 0.00 205,870.54 Museum Membership Fund 0.00 0.00 92,536.28 309,015.34 UTILITY FUNDS Water Utility-Operating $7,764,013.83 $1,122,890.77 Water Utility-Depreciation 0.00 143,827.03 Water Utility-Special Redemption 0.00 3,947,058.12 Water Utility-Bond/Note 4,670,744.26 0.00 Sewerage Utility-Operating 14,972,744.84 0.00 Sewerage Utility-Replacement 0.00 1,976,879.03 Sewerage Utility-Bond/Note 6,665,850.64 (0.00) Sewerage Utility-Debt Service 0.00 4,544,185.10 Storm Water Utility-Operating 14,254,550.63 526.89 Storm Water Utility-Bond/Note 8,683,844.14 0.00 Storm Water Utility-Debt Service 0.00 6,311,476.66 Parking Utility-Operating 65,177.35 57,076,925.69 0.00 18,046,843.60 TOTAL FUNDS $107,484,339.23 $43,159,969.50 CASH RECONCILIATION Associated Bank of Oshkosh $107,885,908.71 Sub-Total,Bank Balances 107,885,908.71 Less: Outstanding Checks 585,194.62 Total Cash in Banks 107,300,714.09 Plus,Cash/Deposits in Transit 183,625.14 TOTAL CASH $107,484,339.23 Page 2 of 2