The URL can be used to link to this page

Home My WebLink About02. Cash Report Oct/Nov 2017 City 0' Oshkosh February 5, 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 October and November, 2017. Respectfully submitted, d' ua;g 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 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of October 31,2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $41,310,128.69 $6,073,432.22 Treasurer's Working Fund 3,850.00 0.00 Other Petty Cash Funds 8,285.00 41,322,263.69 0.00 6,073,432.22 PENSION FUNDS Police Pension 12,734.72 557,107.02 Firemen's Pension 9,293.07 22,027.79 140,613.79 697,720.81 TRUST FUNDS Behncke Museum Trust 6,246.09 265,246.26 William E.Bray Museum Trust 3,766.15 15,239.02 Cemetery Perpetual Care 2,843.29 1,150,829.05 Leander Choate 5,436.24 55,499.09 Clute 0.00 236.95 Amy Davies Library Fund 0.00 5,914.73 Durow Trust 0.00 3,125,717.38 Fisk-Gallup 14,786.03 0.00 Gould 200.00 3,622.83 Abbey Harris Library 4,195.21 207,581.19 Heyman 358.97 34,096.26 Hicks 1,596.55 183,226.60 Hilton Library&Museum 0.00 4,416.29 Hilton Special Library 0.00 1,014.00 Huhn Animal Shelter Trust 0.00 4,415.16 Hume 43.31 1,231.79 Kitz Museum Memorial Trust 5,503.05 51,758.54 Kitz Directors Trust 8,418.11 245,851.10 Library Collection Improvement Trust 0.00 1,480,602.88 Library Development and Support Trust 0.00 407,350.28 Library Facility Trust 0.00 1,042,291.30 Library Programming Support Trust 0.00 162,775.39 Library Technology Trust 0.00 331,947.71 Maxwell-Crawford 158.79 7,203.54 Museum Endowment 2,469.90 385,491.82 Public Library Memorial Fund 110,192.49 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 23,798.88 Roberts 105.48 2,258.25 Rojahn,Frank and Anna 0.00 8,212.23 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of October 31,2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sa rau $7.57 $5,132.32 Stanhilber-Library&Parks 25,456.53 707,198.31 Stanhilber-Parks Only 10.68 1,291.05 M.Zellmer Library 0.00 191,794.44 24,838.89 9,946,289.09 OTHER FUNDS Cable TV Franchise-Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,571.31 108,671.53 UTILITY FUNDS Water Utility-Operating $9,815,567.99 $1,094,873.36 Water Utility-Depreciation 0.00 140,008.36 Water Utility-Special Redemption 0.00 3,448,391.03 Water Utility-Bond/Note 15,060,448.94 0.00 Sewerage Utility-Operating 13,539,442.09 0.00 Sewerage Utility-Replacement 0.00 1,924,392.01 Sewerage Utility-Bond/Note 15,927,899.07 1,884,690.92 Sewerage Utility-Debt Service 0.00 3,290,903.44 Storm Water Utility-Operating 9,686,347.58 513.75 Storm Water Utility-Bond/Note 10,804,597.54 0.00 Storm Water Utility-Debt Service 0.00 5,078,793.97 Parking Utility-Operating 82,682.71 74,916,985.92 0.00 16,862,566.84 TOTAL FUNDS $116,453,071.84 $33,688,680.49 CASH RECONCILIATION Associated Bank of Oshkosh $118,219,557.73 Sub-Total,Bank Balances 118,219,557.73 Less: Outstanding Checks 1,913,518.50 Total Cash in Banks 116,306,039.23 Plus,Cash/Deposits in Transit 147,032.61 TOTAL CASH $116,453,071.84 Page 2 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of November 30,2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL OPERATING FUNDS General Fund $47,179,788.22 $6,065,761.78 Treasurer's Working Fund 3,850.00 0.00 Other Petty Cash Funds 8,285.00 47,191,923.22 0.00 6,065,761.78 PENSION FUNDS Police Pension 10,882.94 557,112.93 Firemen's Pension 8,130.16 19,013.10 140,632.02 697,744.95 TRUST FUNDS Behncke Museum Trust 6,246.09 265,409.77 William E.Bray Museum Trust 3,795.17 15,239.02 Cemetery Perpetual Care 2,356.28 1,151,316.06 Leander Choate 5,386.71 55,548.62 Clute 0.00 237.16 Amy Davies Library Fund 0.00 5,914.73 Durow Trust 0.00 3,125,717.38 Fisk-Gallup 14,786.03 0.00 Gould 200.00 3,626.06 Abbey Harris Library 4,087.68 207,688.72 Heyman 362.00 34,125.48 Hicks 1,596.55 183,380.22 Hilton Library&Museum 0.00 4,416.29 Hilton Special Library 0.00 1,014.00 Huhn Animal Shelter Trust 0.00 4,419.10 Hume 43.31 1,232.89 Kitz Museum Memorial Trust 5,503.05 51,773.23 Kitz Directors Trust 8,418.11 246,070.50 Library Collection Improvement Trust 0.00 1,533,888.36 Library Development and Support Trust 0.00 432,008.76 Library Facility Trust 0.00 1,079,802.35 Library Programming Support Trust 0.00 168,633.52 Library Technology Trust 0.00 343,894.18 Maxwell-Crawford 160.29 7,209.36 Museum Endowment 2,469.90 385,527.92 Public Library Memorial Fund 111,382.89 0.00 Pittel 0.00 0.00 Rasmussen Library,Mabel 0.00 23,798.88 Roberts 105.48 2,260.26 Rojahn,Frank and Anna 0.00 8,212.23 Page 1 of 2 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION(continued) As of November 30,2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS(continued) Sa rau $7.57 $5,136.90 Stanhilber-Library&Parks 26,097.16 707,321.34 Stanhilber-Parks Only 10.68 1,291.05 M.Zellmer Library 0.00 193,014.95 24,838.89 10,080,953.23 OTHER FUNDS Cable TV Franchise-Escrow 0.00 10,100.22 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,591.56 108,691.78 UTILITY FUNDS Water Utility-Operating $9,486,336.50 $1,095,833.93 Water Utility-Depreciation 0.00 140,008.36 Water Utility-Special Redemption 0.00 3,441,718.92 Water Utility-Bond/Note 15,013,778.96 0.00 Sewerage Utility-Operating 13,268,234.84 0.00 Sewerage Utility-Replacement 0.00 1,924,392.01 Sewerage Utility-Bond/Note 15,236,692.08 1,886,344.44 Sewerage Utility-Debt Service 0.00 3,289,134.61 Storm WaterUtility-Operating 7,111,412.12 514.20 Storm Water Utility-Bond/Note 10,685,607.22 0.00 Storm Water Utility-Debt Service 0.00 5,068,755.06 Parking Utility-Operating 84,167.33 70,886,229.05 0.00 16,846,701.53 TOTAL FUNDS $118,290,180.32 $33,799,853.27 CASH RECONCILIATION Associated Bank of Oshkosh $119,431,778.62 Sub-Total,Bank Balances 119,431,778.62 Less: Outstanding Checks 1,204,245.43 Total Cash in Banks 118,227,533.19 Plus,Cash/Deposits in Transit 62,647.13 TOTAL CASH $118,290,180.32 Page 2 of 2