HomeMy WebLinkAbout03. Cash Report City
0'.
ushkosh
July 18, 2017
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, 2017.
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
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of June 30,2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
OPERATING FUNDS
General Fund $37,405,801.31 $11,326,928.66
Treasurer's Working Fund 3,850.00 0.00
Other Petty Cash Funds 9,185.00 37,418,836.31 0.00 11,326,928.66
PENSION FUNDS
Police Pension 20,141.84 557,086.41
Firemen's Pension 14,199.86 34,341.70 140,550.18 697,636.59
TRUST FUNDS
Behncke Museum Trust 214,071.35 82,022.96
William E.Bray Museum Trust 3,649.24 15,239.02
Cemetery Perpetual Care 489,782.36 691,164.98
Leander Choate 58,558.14 2,377.19
Clute 0.00 291.22
Amy Davies Library Fund 0.00 5,914.73
Durow Trust 0.00 3,397,969.16
Fisk-Gallup 14,869.03 0.00
Gould 200.00 3,612.94
Abbey Harris Library 85,355.99 127,296.97
Heyman 346.19 34,006.92
Hicks 1,493.05 182,756.87
Hilton Library&Museum 0.00 4,416.29
Hilton Special Library 0.00 1,014.00
Huhn Animal Shelter Trust 0.00 4,403.10
Hume 43.31 1,228.43
Kitz Museum Memorial Trust 21,930.05 35,295.78
Kitz Directors Trust 263,453.12 0.00
Library Collection Improvement Trust 0.00 1,404,055.04
Library Development and Support Trust 0.00 397,478.61
Library Facility Trust 0.00 1,062,700.09
Library Programming Support Trust 0.00 162,190.38
Library Technology Trust 0.00 324,424.70
Maxwell-Crawford 152.41 7,295.57
Museum Endowment 42,837.35 345,036.48
Public Library Memorial Fund 109,822.61 0.00
Pittel 0.00 0.00
Rasmussen Library,Mabel 0.00 23,798.88
Roberts 105.48 2,252.08
Rojahn,Frank and Anna 0.00 8,212.23
Page 1 of 2
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION(continued)
As of June 30,2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
TRUST FUNDS(continued)
Sa rau $7.57 $5,118.32
Stanhilber-Library&Parks 113,908.43 672,850.87
Stanhilber-Parks Only 10.68 1,291.05
M.Zellmer Library 0.00 1,420,596.36 24,838.89 9,030,553.75
OTHER FUNDS
Cable TV Franchise-Escrow 0.00 10,034.96
GO-HNI Collateralization
Museum Membership Fund 0.00 0.00 98,477.25 108,512.21
UTILITY FUNDS
Water Utility-Operating $6,547,687.89 $1,091,520.79
Water Utility-Depreciation 0.00 140,008.36
Water Utility-Special Redemption 514,825.03 3,438,272.63
Water Utility-Bond/Note 6,924,835.84 0.00
Sewerage Utility-Operating 9,125,260.64 0.00
Sewerage Utility-Replacement 0.00 1,924,392.01
Sewerage Utility-Bond/Note 0.00 5,540,351.88
Sewerage Utility-Debt Service 0.00 3,286,903.55
Storm WaterUtility-Operating 5,159,074.35 512.17
Storm Water Utility-Bond/Note 3,087,320.67 0.00
Storm Water Utility-Debt Service 0.00 5,059,179.10
Parking Utility-Operating 76,453.48 31,435,457.90 0.00 20,481,140.49
TOTAL FUNDS $70,309,232.27 $41,644,771.70
CASH
RECONCILIATION
Associated Bank of Oshkosh $72,024,912.41
Sub-Total,Bank Balances 72,024,912.41
Less: Outstanding Checks 2,039,276.91
Total Cash in Banks 69,985,635.50
Plus,Cash/Deposits in Transit 323,596.77
TOTAL CASH $70,309,232.27
Page 2 of 2