The URL can be used to link to this page

Home My WebLink About02. B) Cash ReportsApril 16, 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 December, 2017 and January and February, 2018. Respectfully submitted, UA'ZX)4 lrfmv.'l Tara J. Wendt, CPA Assistant Director of Finance City of Oshkosh TJW Enc City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 http://www.ci.oshkosh.wi.us OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of December 31, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $91,046,059.07 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 8,285.00 Police Pension 9,031.16 Firemen's Pension 6,882.20 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 3,825.42 Cemetery Perpetual Care 2,002.07 Leander Choate 5,337.98 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 9,830.03 Gould 200.00 Abbey Harris Library 3,981.87 Heyman 365.11 Hicks 1,700.05 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 161.84 Museum Endowment 2,469.90 Public Library Memorial Fund 113,363.31 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $5,640,247.68 0.00 91,058,194.07 0.00 557,119.28 15,913.36 141,926.01 283,439.70 15,836.25 1,211,299.39 55,596.94 237.32 7,308.56 3,441,550.86 0.00 3,628.61 218,434.49 34,168.51 185,191.82 4,479.89 1,029.00 4,423.92 1,233.75 58,539.01 246,286.39 1,576,211.18 443,866.55 1,109,455.41 173,264.46 353, 537.99 7,223.93 428,726.27 0.00 0.00 27,809.46 2,261.85 9,466.78 5,640,247.68 699,045.29 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of December 31, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS (continued) Page 2 of 2 Sarau $7.57 $5,140.52 Stanhilber - Library & Parks 18,710.99 778,717.94 Stanhilber - Parks Only 10.68 1,310.15 M. Zellmer Library 0.00 182,282.86 26,903.34 10,716,580.24 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,611.41 108,711.63 UTILITY FUNDS Water Utility - Operating $5,225,339.62 $1,096,866.25 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,443,080.39 Water Utility - Bond/Note 12,289,040.07 0.00 Sewerage Utility - Operating 7,419,259.93 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 15,245,019.16 118,773.02 Sewerage Utility - Debt Service 0.00 3,289,425.17 Storm Water Utility - Operating 2,485,606.12 514.68 Storm Water Utility - Bond/Note 6,259,099.93 0.00 Storm Water Utility - Debt Service 0.00 5,074,637.95 Parking Utility - Operating 86,989.69 49,010,354.52 0.00 15,087,697.83 TOTAL FUNDS $140,266,744.81 $32,252,282.67 CASH RECONCILIATION Associated Bank of Oshkosh $133,813,091.85 Sub -Total, Bank Balances 133,813,091.85 Less: Outstanding Checks 1,815,367.53 Total Cash in Banks 131,997,724.32 Plus, Cash/Deposits in Transit 8,269,020.49 TOTAL CASH $140,266,744.81 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of January 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $87,321,415.53 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 7,485.00 Police Pension 7,179.38 Firemen's Pension 5,634.24 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,295.36 Cemetery Perpetual Care 2,112.08 Leander Choate 5,285.61 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 9,830.03 Gould 200.00 Abbey Harris Library 3,868.16 Heyman 369.04 Hicks 1,700.05 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 163.78 Museum Endowment 2,469.90 Public Library Memorial Fund 114,464.35 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $5,639,380.88 0.00 87,332,750.53 0.00 5,639,380.88 557,126.04 12,813.62 141,946.88 283,612.61 15, 836.25 1,211,814.38 55,649.31 237.54 7,308.56 3,441,550.86 0.00 3,632.03 218,548.20 34,199.41 185, 354.27 4,479.89 1,029.00 4,428.09 1,234.91 58,554.55 246,518.40 1,576,211.18 443,866.55 1,109,455.41 173,264.46 353,537.99 7,230.09 428,764.45 0.00 0.00 27,809.46 2,263.98 9,466.78 699.072.92 TRUST FUNDS (continued) OTHER FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of January 31, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL Sarau $7.57 Stanhilber - Library & Parks 19,694.70 Stanhilber - Parks Only 10.68 M. Zellmer Library 0.00 Cable TV Franchise - Escrow GO-HNI Collateralization Museum Membership Fund 0.00 $5,145.36 778,848.05 1,310.15 184,787.35 26,903.34 0.00 0.00 10,100.22 10, 718, 065.51 98,638.15 108,738.37 UTILITY FUNDS Water Utility - Operating $2,029,149.57 $1,097,966.02 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,430,977.23 Water Utility - Bond/Note 12,296,748.91 0.00 Sewerage Utility - Operating 7,630,119.14 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 15,253,435.19 118,892.06 Sewerage Utility - Debt Service 0.00 3,270,233.92 Storm Water Utility - Operating 2,593,919.72 515.20 Storm Water Utility - Bond/Note 6,264,054.95 0.00 Storm Water Utility - Debt Service 0.00 5,061,948.43 Parking Utility - Operating 77,218.77 46,144,646.25 0.00 15,044,933.23 TOTAL FUNDS $133,674,997.75 $32,210,190.91 CASH RECONCILIATION Associated Bank of Oshkosh $132,907,567.55 Sub -Total, Bank Balances 132,907,567.55 Less: Outstanding Checks 1,029,985.48 Total Cash in Banks 131,877,582.07 Plus, Cash/Deposits in Transit 1,797,415.68 TOTAL CASH $133,674,997.75 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of February 28, 2018 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL General Fund $61,771,371.20 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 7,485.00 Police Pension 5,327.60 Firemen's Pension 6,140.78 Behncke Museum Trust 6,246.09 William E. Bray Museum Trust 4,327.27 Cemetery Perpetual Care 1,963.43 Leander Choate 5,229.81 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 9,830.03 Gould 200.00 Abbey Harris Library 3,747.02 Heyman 372.35 Hicks 1,700.05 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 165.43 Museum Endowment 2,469.90 Public Library Memorial Fund 115,409.47 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $20,060,230.57 0.00 61,782,706.20 0.00 557,132.88 11,468.38 141,967.98 283,796.82 15, 836.25 1,212,363.03 55,705.11 237.78 7,308.56 3,441,550.86 0.00 3,635.67 218,669.34 34,232.32 185, 527.34 4,479.89 1,029.00 4,432.53 1,236.15 58,571.10 246,765.57 1,626,349.81 460,253.14 1,144,666.16 178,763.36 364,757.56 7,236.65 428,805.12 0.00 0.00 27,809.46 2,266.25 9,466.78 20,060,230.57 699,100.86 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of February 28, 2018 Page 2 of 2 CASH CASH INVESTMENTS COST 2018 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,150.52 Stanhilber - Library & Parks 20,822.43 778,986.67 Stanhilber - Parks Only 10.68 1,310.15 M. Zellmer Library 0.00 186,571.48 26,903.34 10,838,102.29 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,660.85 108,761.07 UTILITY FUNDS Water Utility - Operating $2,030,326.97 $1,099,078.33 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,430,634.15 Water Utility - Bond/Note 12,304,345.90 0.00 Sewerage Utility - Operating 7,634,706.52 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 15,262,858.83 119,012.50 Sewerage Utility - Debt Service 0.00 3,266,985.94 Storm Water Utility - Operating 2,595,457.25 515.72 Storm Water Utility - Bond/Note 6,267,924.91 0.00 Storm Water Utility - Debt Service 0.00 5,059,823.57 Parking Utility - Operating 77,218.77 46,172,839.15 0.00 15,040,450.58 TOTAL FUNDS $108,153,585.21 $46,746,645.37 CASH RECONCILIATION Associated Bank of Oshkosh $108,879,128.16 Sub -Total, Bank Balances 108,879,128.16 Less: Outstanding Checks 857,035.43 Total Cash in Banks 108,022,092.73 Plus, Cash/Deposits in Transit 131,492.48 TOTAL CASH $108,153,585.21 Page 2 of 2