The URL can be used to link to this page

Home My WebLink About03. Cash Reports May, June & July 2018September 25, 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 May, June and July 2018. Respectfully submitted, Trena Larson Director of Finance City of Oshkosh Enc City Hall, 215 Church Avenue P.O. Box 1 130 Oshkosh, WI 54903-1130 http://www.ci.oshkosh.wi.us OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of May 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $53,144,358.29 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 7,485.00 Police Pension 20,772.26 Firemen's Pension 9,735.20 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,412.46 Cemetery Perpetual Care 579.70 Leander Choate 5,038.23 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 17,136.18 Gould 200.00 Abbey Harris Library 3,331.09 Heyman 382.44 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 170.53 Museum Endowment 2,469.90 Public Library Memorial Fund 87,277.35 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $19,174,490.57 0.00 53,155,693.29 0.00 19,174,490.57 536,427.67 30,507.46 136,296.89 284,429.29 15,836.25 1,214,246.76 55,896.69 238.60 7,308.56 3,441,550.86 0.00 3,648.17 219,085.27 34,345.33 180,961.94 4,479.89 1,029.00 4,447.78 1,240.40 58,627.93 247,614.22 1, 547, 564.91 450,920.93 1,103,605.48 165,719.71 351, 504.74 7,259.18 428, 944.77 0.00 0.00 27, 809.46 2,274.05 9,466.78 672,724.56 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of May 31, 2018 Page 2 of 2 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,168.23 Stanhilber - Library & Parks 24,476.24 779,299.09 Stanhilber- Parks Only 10.68 1,473.63 M. Zellmer Library 0.00 167,615.71 26,903.34 10,682,901.24 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,735.47 108,835.69 UTILITY FUNDS Water Utility - Operating $5,511,384.07 $1,101,737.57 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,849,370.57 Water Utility - Bond/Note 8,867,539.87 0.00 Sewerage Utility - Operating 6,541,520.72 0.00 Sewerage Utility- Replacement 0.00 1,924,392.01 Sewerage Utility- Bond/Note 11,008,960.22 76.60 Sewerage Utility - Debt Service 0.00 4,423,225.63 Storm Water Utility - Operating 5,603,370.60 516.97 Storm Water Utility - Bond/Note 2,931,457.37 0.00 Storm Water Utility - Debt Service 0.00 5,512,175.74 Parking Utility - Operating 116,480.70 40,580,713.55 0.00 16,951,503.45 TOTAL FUNDS $93,934,530.01 $47,590,455.51 CASH RECONCILIATION Associated Bank of Oshkosh $99,275,834.91 Sub -Total, Bank Balances 99,275,834.91 Less: Outstanding Checks 1,575,855.83 Total Cash in Banks 97,699,979.08 Plus, Cash/Deposits in Transit (3,765,449.07) TOTAL CASH $93,934,530.01 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of June 30. 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $44,570,962.60 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 7,485.00 Police Pension 18,920.48 Firemen's Pension 8,903.19 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,441.93 Cemetery Perpetual Care 773.33 Leander Choate 5,038.23 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 11,113.41 Gould 200.00 Abbey Harris Library 3,331.09 Heyman 385.99 Hicks 1,914.55 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 172.35 Museum Endowment 2,469.90 Public Library Memorial Fund 90,185.39 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $19,174,490.57 0.00 44, 582,297.60 0.00 19,174,490.57 536,427.67 27,823.67 136,296.89 284,429.29 15,836.25 1,214,246.76 55,896.69 238.60 7,308.56 3,441,550.86 0.00 3,648.17 219,085.27 34,345.33 180,961.94 4,479.89 1,029.00 4,447.78 1,240.40 58,627.93 247,614.22 1,547,564.91 450,920.93 1,103,605.48 165,719.71 351,504.74 7,259.18 428,944.77 0.00 0.00 27,809.46 2,274.05 9,466.78 672,724.56 TRUST FUNDS (continued) OTHER FUNDS UTILITY FUNDS TOTALFUNDS CASH RECONCILIATION TOTAL CASH CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of June 30, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL Sarau $7.57 $5,168.23 Stanhilber - Library & Parks 26,437.18 779,299.09 Stanhilber- Parks Only 10.68 1,473.63 M. Zellmer Library 0.00 166,797.64 26,903.34 10,682,901.24 Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,735.47 108,835.69 Water Utility - Operating $4,714,958.43 $1,101,737.57 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,849,370.57 Water Utility - Bond/Note 8,873,564.91 0.00 Sewerage Utility - Operating 4,643,793.27 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 13,892,748.11 76.60 Sewerage Utility - Debt Service 0.00 4,423,225.63 Storm Water Utility - Operating 7,077,966.65 516.97 Storm Water Utility - Bond/Note 2,933,449.14 0.00 Storm Water Utility - Debt Service 0.00 5,512,175.74 Parking Utility - Operating 116,240.74 42,252,721.25 0.00 16,951,503.45 $87,029,640.16 $47,590,455.51 Associated Bank of Oshkosh Sub -Total, Bank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash/Deposits in Transit $88,843,577.35 88,843,577.35 2,055,493.06 86,788,084.29 241, 555.87 $87,029,640.16 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of July 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $64,945,804.42 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 8,485.00 Police Pension 17,068.70 Firemen's Pension 8,071.18 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,472.56 Cemetery Perpetual Care 1,173.33 Leander Choate 5,038.23 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 11,113.41 Gould 200.00 Abbey Harris Library 3,331.09 Heyman 389.66 Hicks 1,914.55 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 174.21 Museum Endowment 2,469.90 Public Library Memorial Fund 90,787.24 Pittel 000 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $19,174,490.57 0.00 64,958,139.42 0.00 19,174,490.57 536,427.67 25,139.88 136,296.89 672,724.56 284,429.29 15,836.25 1,214,246.76 55,896.69 238.60 7,308.56 3,441,550.86 0.00 3,648.17 219,085.27 34,345.33 180, 961.94 4,479.89 1,029.00 4,447.78 1,240.40 58,627.93 247,614.22 1,547,564.91 450,920.93 1,103,605.48 165,719.71 351,504.74 7,065.55 428,944.77 0.00 0.00 27,809.46 2,274.05 9,466.78 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of July 31, 2018 Page 2 of 2 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,168.23 Stanhilber - Library & Parks 27,450.00 779,299.09 Stanhilber- Parks Only 10.68 1,473.63 M. Zellmer Library 0.00 168,848.47 26,903.34 10,682,707.61 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,735.47 108,835.69 UTILITY FUNDS Water Utility - Operating $4,662,968.15 $1,101,737.57 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,849,370.57 Water Utility - Bond/Note 8,880,226.12 0.00 Sewerage Utility - Operating 4,648,339.29 0.00 Sewerage Utility- Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 13,902,442.12 76.60 Sewerage Utility - Debt Service 0.00 4,423,225.63 Storm Water Utility - Operating 7,084,812.50 516.97 Storm Water Utility - Bond/Note 13,260,840.64 0.00 Storm Water Utility - Debt Service 0.00 5,512,175.74 Parking Utility - Operating 116,240.74 52,555,869.56 0.00 16,951,503.45 TOTAL FUNDS $117,707,997.33 $47,590,261.88 CASH RECONCILIATION Associated Bank of Oshkosh $118,497,886.17 Sub -Total, Bank Balances 118,497,886.17 Less: Outstanding Checks 1,989,314.71 Total Cash in Banks 116,508,571.46 Plus, Cash/Deposits in Transit 1,199,425.87 TOTAL CASH $117,707,997.33 Page 2 of 2