HomeMy WebLinkAbout02. Cash Report December 2018 r,A
City
of;. &
Oshkosh
April 16, 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 December 2018.
Respectfully submitted,
r
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-1130 920.236.5005 http://www.ci.oshkosh.wi.us
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of December 31,2018
CASH CASH INVESTMENTS COST
2018 TOTAL AT COST TOTAL
OPERATING FUNDS
General Fund $76,916,714.62 $3,853,032.00
Treasurer's Working Fund 4,850.00 0.00
Other Petty Cash Funds 9,485.00 76,931,049.62 0.00 3,853,032.00
PENSION FUNDS
Police Pension 14,872.37 557,117.97
Firemen's Pension 5,756.05 20,628.42 140,018.34 697,136.31
TRUST FUNDS
Behncke Museum Trust 6,246.09 282,353.34
William E.Bray Museum Trust 4,912.38 14,461.81
Cemetery Perpetual Care 30,089.92 1,138,505.86
Leander Choate 4,420.96 56,607.63
Clute 0.00 241.64
Amy Davies Library Fund 0.00 6,920.53
Durow Trust 0.00 3,307,143.79
Fisk-Gallup 5,615.34 0.00
Gould 200.00 3,694.56
Abbey Harris Library 1,990.92 219,740.51
Heyman 407.57 34,706.72
Hicks 2,129.05 181,827.95
Hilton Library&Museum 0.00 4,290.51
Hilton Special Library 0.00 985.50
Huhn Animal Shelter Trust 0.00 4,504.34
Hume 43.31 1,256.18
Kitz Museum Memorial Trust 5,503.05 283,278.20
Kitz Directors Trust 8,418.11 250,763.52
Library Collection Improvement Trust 0.00 910,247.35
Library Development and Support Trust 0.00 438,783.78
Library Facility Trust 0.00 1,023,572.88
Library Programming Support Trust 0.00 606,580.88
Library Technology Trust 0.00 370,775.23
Maxwell-Crawford 183.17 7,313.78
Museum Endowment 2,569.90 391,001.66
Public Library Memorial Fund 99,801.58 0.00
Pittel 0.00 0.00
Rasmussen Library,Mabel 0.00 28,251.72
Roberts 105.48 2,302.98
Rojahn,Frank and Anna 0.00 8,035.94
Page 1 of 2
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION(continued)
As of December 31,2018
CASH CASH INVESTMENTS COST
2018 TOTAL AT COST TOTAL
TRUST FUNDS(continued)
Sarau $7.57 $5,233.95
Stanhilber-Library&Parks 24,312.84 771,604.62
Stanhilber-Parks Only 10.68 1,254.76
M.Zellmer Library 0.00 196,967.92 23,977.74 10,380,219.86
OTHER FUNDS
Cable TV Franchise-Escrow 0.00 10,304.00
GO-HNI Collateralization 0.00 204,380.34
Museum Membership Fund 0.00 0.00 92,429.88 307,114.22
UTILITY FUNDS
Water Utility-Operating $5,111,073.36 $1,115,717.48
Water Utility-Depreciation 0.00 143,665.00
Water Utility-Special Redemption 0.00 3,911,326.57
Water Utility-Bond/Note 7,396,532.56 0.00
Sewerage Utility-Operating 11,293,900.28 0.00
Sewerage Utility-Replacement 0.00 1,974,651.92
Sewerage Utility-Bond/Note 10,137,810.42 (0.00)
Sewerage Utility-Debt Service 0.00 4,489,492.26
Storm Water Utility-Operating 10,773,109.40 523.53
Storm Water Utility-Bond/Note 12,406,454.95 0.00
Storm Water Utility-Debt Service 0.00 5,599,247.29
Parking Utility-Operating 58,060.43 57,176,941.40 0.00 17,234,624.05
TOTAL FUNDS $134,325,587.36 $32,472,126.44
CASH
RECONCILIATION
Associated Bank of Oshkosh $127,948,134.37
Sub-Total,Bank Balances 127,948,134.37
Less: Outstanding Checks 992,689.78
Total Cash in Banks 126,955,444.59
Plus,Cash/Deposits in Transit 7,370,142.77
TOTAL CASH $134,325,587.36
Page 2 of 2