HomeMy WebLinkAbout06. Cash Report June 2019 City
f
Oshkosh
October 8, 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 month of June 2019.
Respectfully submitted,
*-I kk NCY1(/lW'Io4
Jennifer L. Messerschmidt, CPA
Assistant Director of Finance
JLM/pkl
Enclosure
Finance Department
City Hall,215 Church Avenue P.O.Box 1 130 Oshkosh,WI 54903-1 130 920.236.5005 http://www.ci.oshkosh.wi.us
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of June 30,2019
CASH CASH INVESTMENTS COST
2018 TOTAL AT COST TOTAL
OPERATING FUNDS
General Fund $78,688,667.14 $13,911,285.18
Treasurer's Working Fund 4,850.00 0.00
Other Petty Cash Funds 9,485.00 78,703,002.14 0.00 13,911,285.18
PENSION FUNDS
Police Pension 15,186.76 555,338.94
Firemen's Pension 12,006.00 27,192.76 128,755.41 684,094.35
TRUSTFUNDS
Behncke Museum Trust 47,014.25 188,615.83
William E.Bray Museum Trust 16,239.89 4,052.91
Cemetery Perpetual Care 110,591.31 1,038,416.72
Leander Choate 5,019.35 56,855.70
Clute 0.00 243.88
Amy Davies Library Fund 0.00 0.00
Durow Trust 0.00 3,296,967.07
Fisk-Gallup 15,668.12 0.00
Gould 200.00 3,728.78
Abbey Harris Library 108,254.11 125,216.65
Heyman 426.18 35,016.10
Hicks 10,647.65 175,046.02
Hilton Library&Museum 0.00 4,290.51
Hilton Special Library 0.00 985.50
Huhn Animal Shelter Trust 0.00 4,546.08
Hume 43.31 1,267.81
Kitz Museum Memorial Trust 5,503.05 284.559.36
Kitz Directors Trust 8,418.11 253,086.85
Library Collection Improvement Trust 0.00 989,325.54
Library Development and Support Trust 0.00 482,639.37
Library Facility Trust 0.00 1,129,785.86
Library Programming Support Trust 0.00 679,057.51
Library Technology Trust 0.00 415,604.37
Maxwell-Crawford 192.57 7,375.45
Museum Endowment 94,429.56 323,337.37
Public Library Memorial Fund 102,324.76 0.00
Pitlel 0.00 0.00
Rasmussen Library,Mabel 0.00 28,505.33
Roberts 105.48 2,324.32
Rojahn,Frank and Anna 0.00 8,040.71
Page 1 of 2
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION(continued)
As of June 30,2019
CASH CASH INVESTMENTS COST
2018 TOTAL AT COST TOTAL
TRUST FUNDS(continued)
Sarau $7.57 $5,282.44
Stanhilber-Library&Parks 186,765.78 633,677.26
Stanhilber-Parks Only 10.68 1,254.76
M.Zellmer Library 0.00 711,861.73 12,003.39 10,191,109.45
OTHER FUNDS
Tax Collection 0.00 304.75
Cable TV Franchise-Escrow 0.00 10,382.89
GO-HNI Collateralization 0.00 207,388.32
Museum Membership Fund 0.00 0.00 92,588.26 310,664.22
UTILITY FUNDS
Water Utility-Operating $4,846,823.56 $1,126,311.53
Water Utility-Depreciation 0.00 143,827.03
Water Utility-Special Redemption 74,3%01 3,989,283.14
Water Utility-Bond/Note 4,680,737.28 0.00
Sewerage Utility-Operating 3,697,785.16 0.00
Sewerage Utility-Replacement 0.00 1,976,879.03
Sewerage Utility-Bond/Note 6,680,112.17 (0.00)
Sewerage Utility-Debt Service 0.00 4,586,973.39
Storm Water Utility-Operating 8,264,310.56 528.50
Storm Water Utility-Bond/Note 15,292,847.06 0.00
Storm Water Utility-Debt Service 0.00 6,362,910.80
Parking Utility-Operating 68,034.62 43,605,000.42 0.00 18,186,713.42
TOTAL FUNDS $123,047,057.05 $43,283,86R62
CASH
RECONCILIATION
Associated Bank of Oshkosh $122,877,695.67
Sub-Total,Bank Balances 122,877,695.67
Less: Outstanding Checks 730,851.40
Total Cash in Banks 122,146,844.27
Plus,Cash/Deposits in Transit 900.212.78
TOTAL CASH $123,047,05T05
Page 2 of 2