The URL can be used to link to this page

Home My WebLink About03. Cash Reports- October, November & December 2016lug. s P*p; Irl City of Oshkosh May 2, 2017 City Manager and Members of Common Council City of Oshkosh, Wisconsin City Manager and Council Members: Attached are the Cash and Investment Recapitulations of City operations, utility, and trust accounts for the Months of October, November, and December, 2016. Respectfully submitted, Tara J. Wendt, CPA Assistant Director of Finance City of Oshkosh TJW 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 TRUST FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of October 31, 2016 CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL General Fund ($1,522,903.08) Treasurer's Working Fund 2,850.00 Other Petty Cash Funds 5,135.00 Police Pension 13,166.35 Firemen's Pension 16,401.91 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,218.23 Cemetery Perpetual Care 38,745.12 Leander Choate 58,566.76 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 14,556.62 Gould 200.00 Abbey Harris Library 85,501.93 Heyman 323.34 Hicks 1,185.55 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 140.91 Museum Endowment 42,837.35 Public Library Memorial Fund 85,697.59 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $22,165,477.28 0.00 (1,514,918.08) 0.00 22,165,477.28 574,218.98 29,568.26 144,922.10 73,283.10 14, 530.29 985,155.14 2,368.16 290.12 5,437.66 3,151, 967.23 0.00 3,599.20 107,458.59 33, 878.70 180,692.25 4,401.52 1,011.00 4,388.06 1,223.74 32,095.34 0.00 1,321,815.76 355, 322.77 1,001,871.35 152,489.70 305, 700.33 7,265.26 333,163.71 0.00 0.00 22, 026.06 2,243.50 7,780.02 719,141.08 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of October 31, 2016 Page 2 of 2 CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,098.85 Stanhilber - Library & Parks 112,524.00 630,916.02 Stanhilber - Parks Only 10.68 1,287.23 M. Zellmer Library 0.00 943,118.96 24,498.41 8,773,259.07 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,281.31 108,316.27 UTILITY FUNDS Water Utility - Operating $1,203,278.38 $1,086,952.86 Water Utility - Depreciation 0.00 139,061.98 Water Utility - Special Redemption 0.00 3,178,782.06 Water Utility - Bond/Note 346,719.33 6,460,619.42 Sewerage Utility - Operating 11,987,067.83 0.00 Sewerage Utility - Replacement 0.00 1,911,384.12 Sewerage Utility - Bond/Note 0.00 14,979,976.57 Sewerage Utility - Debt Service 0.00 2,730,857.19 Storm Water Utility - Operating 5,025,706.57 510.02 Storm Water Utility - Bond/Note 4,926,940.51 0.00 Storm Water Utility - Debt Service 0.00 4,769,761.77 Parking Utility - Operating 56,597.13 23,546,309.75 0.00 35,257,905.99 TOTAL FUNDS $23,004,078.89 $67,024,099.69 CASH RECONCILIATION Associated Bank of Oshkosh $23,128,461.22 Sub -Total, Bank Balances 23,128,461.22 Less: Outstanding Checks 389,988.31 Total Cash in Banks 22,738,472.91 Plus, Cash/Deposits in Transit 265,605.98 TOTAL CASH $23,004,078.89 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUST FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of November 30, 2016 General Fund Treasurer's Working Fund Other Petty Cash Funds Police Pension Firemen's Pension Behncke Museum Trust William E. Bray Museum Trust Cemetery Perpetual Care Leander Choate Clute Amy Davies Library Fund Du row Trust Fisk -Gallup Gould Abbey Harris Library Heyman Hicks Hilton Library & Museum Hilton Special Library Huhn Animal Shelter Trust Hume Kitz Museum Memorial Trust Kitz Directors Trust Library Collection Improvement Trust Library Development and Support Trust Library Facility Trust Library Programming Support Trust Library Technology Trust Maxwell -Crawford Museum Endowment Public Library Memorial Fund Pittel Rasmussen Library, Mabel Roberts Rojahn, Frank and Anna CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL $2,525,243.10 $16,669,135.84 2,850.00 0.00 5,135.00 2,533,228.10 0.00 11,314.57 574,218.98 15,233.26 26,547.83 144,922.10 214,071.35 73,283.10 3,247.12 14,530.29 39,327.35 985,172.91 58,565.83 2,369.09 0.00 290.23 0.00 5,437.66 0.00 3,151,967.23 14, 556.62 0.00 200.00 3,600.61 85,486.28 107,474.24 325.89 33, 891.41 1,185.55 180,759.08 8.31 4,401.52 0.00 1,011.00 0.00 4,389.77 43.31 1,224.22 21,930.05 32,095.34 263,453.12 0.00 0.00 1,307,202.08 0.00 351,394.41 0.00 990,794.93 0.00 150, 803.82 0.00 302,445.59 142.19 7,267.84 42,837.35 333,163.71 85,828.69 0.00 0.00 0.00 0.00 22,026.06 105.48 2,244.38 0.00 7,780.02 Page 1 of 2 16,669,135.84 719,141.08 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of November 30, 2016 Page 2 of 2 CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,100.84 Stanhilber - Library & Parks 113,120.45 630,956.32 Stanhilber - Parks Only 10.68 1,287.23 M. Zellmer Library 0.00 944,453.19 24,498.41 8,738,863.34 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,310.53 108,345.49 UTILITY FUNDS Water Utility - Operating $6,730,057.00 $1,087,377.56 Water Utility - Depreciation 0.00 139,061.98 Water Utility - Special Redemption 0.00 3,178,231.56 Water Utility - Bond/Note 352,091.55 6,463,261.01 Sewerage Utility - Operating 12,122,738.35 0.00 Sewerage Utility - Replacement 0.00 1,911,384.12 Sewerage Utility - Bond/Note 0.00 14,987,152.09 Sewerage Utility - Debt Service 0.00 2,726,443.97 Storm Water Utility - Operating 4,408,156.36 510.22 Storm Water Utility - Bond/Note 4,932,422.66 0.00 Storm Water Utility - Debt Service 0.00 4,769,818.98 Parking Utility - Operating 58,937.62 28,604,403.54 0.00 35,263,241.49 TOTAL FUNDS $32,108,632.66 $61,498,727.24 CASH RECONCILIATION Associated Bank of Oshkosh $32,786,278.47 Sub -Total, Bank Balances 32,786,278.47 Less: Outstanding Checks 735,801.08 Total Cash in Banks 32,050,477.39 Plus, Cash/Deposits in Transit 58,155.27 TOTAL CASH $32,108,632.66 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of December 31, 2016 CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL General Fund $47,124,203.90 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 6,185.00 Police Pension 9,462.79 Firemen's Pension 13,985.30 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,276.66 Cemetery Perpetual Care 4,710.61 Leander Choate 58,564.96 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 1,808.79 Gould 200.00 Abbey Harris Library 85,471.52 Heyman 328.60 Hicks 1,286.05 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 143.52 Museum Endowment 42,837.35 Public Library Memorial Fund 88,510.76 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,840,288.74 0.00 47,134,238.90 0.00 11,840,288.74 574, 218.98 23,448.09 146,721.65 82,022.96 15,239.02 1, 046, 907.69 2,369.96 290.34 5,914.73 3,397,969.16 0.00 3,601.94 127,174.40 33,907.39 182,233.59 4,414.58 1,014.00 4,391.39 1,224.67 35,295.78 0.00 1,331,510.43 367, 897.00 1, 008, 992.15 153, 998.47 308, 028.55 7,275.40 345, 036.48 0.00 0.00 23,798.88 2,245.21 8,212.23 720,940.63 TRUST FUNDS (continued) OTHER FUNDS UTILITY FUNDS TOTALFUNDS CASH RECONCILIATION CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of December 31, 2016 Sarau Stanhilber - Library & Parks Stanhilber - Parks Only M. Zellmer Library Cable TV Franchise - Escrow GO-HNI Collateralization Museum Membership Fund Water Utility - Operating Water Utility - Depreciation Water Utility - Special Redemption Water Utility - Refunding Water Utility - Bond/Note Sewerage Utility - Operating Sewerage Utility - Replacement Sewerage Utility - Bond/Note Sewerage Utility - Debt Service Storm Water Utility - Operating Storm Water Utility - Bond/Note Storm Water Utility - Debt Service Parking Utility - Operating Associated Bank of Oshkosh Sub -Total, Bank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash/Deposits in Transit CASH CASH INVESTMENTS COST 2016 TOTAL AT COST TOTAL $7.57 $5,102.72 106,140.64 672,535.32 10.68 1,291.05 0.00 892,901.02 24,838.89 9,204,734.38 0.00 0.00 0.00 10, 034.96 200, 000.00 0.00 98,367.10 308,402.06 $3,944,285.48 $1,088,202.18 0.00 139, 061.98 0.00 3,147,268.15 7,901,931.25 0.00 10,041,473.32 6,466,795.65 12,623,712.87 0.00 0.00 1, 911, 384.12 0.00 15,001,960.09 0.00 2,695,278.19 3,695,882.32 510.61 10,079,447.52 0.00 0.00 4,731,576.55 61,248.56 48,347,981.32 0.00 35,182,037.52 $96,398,569.33 $57,256,403.33 $92,571,498.86 92,571,498.86 1,099,452.63 91,472, 046.23 4,926,523.10 TOTAL CASH $96,398,569.33 Page 2 of 2