HomeMy WebLinkAbout03. Cash Report July 2017 City
0'
Oshkosh
September 15, 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 July, 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 July 31,2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
OPERATING FUNDS
General Fund $64,086,295.94 $11,350,995.54
Treasurer's Working Fund 3,850.00 0.00
Other Petty Cash Funds 9,185.00 64,099,330.94 0.00 11,350,995.54
PENSION FUNDS
Police Pension 18,290.06 557,090.43
Firemen's Pension 12,951.90 31,241.96 140,562.60 697,653.03
TRUST FUNDS
Behncke Museum Trust 6,246.09 264,848.22
William E.Bray Museum Trust 3,678.58 15,239.02
Cemetery Perpetual Care 31,828.80 1,149,643.54
Leander Choate 5,556.81 55,378.52
Clute 0.00 236.43
Amy Davies Library Fund 0.00 5,914.73
Durow Trust 0.00 3,125,717.38
Fisk-Gallup 14,869.03 0.00
Gould 200.00 3,614.96
Abbey Harris Library 4,456.99 207,319.41
Heyman 349.48 34,025.14
Hicks 1,493.05 182,852.62
Hilton Library&Museum 0.00 4,416.29
Hilton Special Library 0.00 1,014.00
Huhn Animal Shelter Trust 0.00 4,405.56
Hume 43.31 1,229.12
Kitz Museum Memorial Trust 5,503.05 51,722.78
Kitz Directors Trust 8,418.11 245,317.00
Library Collection Improvement Trust 0.00 1,454,015.86
Library Development and Support Trust 0.00 399,746.78
Library Facility Trust 0.00 1,022,474.56
Library Programming Support Trust 0.00 159,710.47
Library Technology Trust 0.00 325,747.53
Maxwell-Crawford 154.05 7,189.36
Museum Endowment 2,469.90 385,403.93
Public Library Memorial Fund 76,133.69 0.00
Pittel 0.00 0.00
Rasmussen Library,Mabel 0.00 23,798.88
Roberts 105.48 2,253.34
Rojahn,Frank and Anna 0.00 8,212.23
Page 1 of 2
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION(continued)
As of July 31,2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
TRUST FUNDS(continued)
Sa rau $7.57 $5,121.18
Stanhilber-Library&Parks 21,057.85 706,898.79
Stanhilber-Parks Only 10.68 1,291.05
M.Zellmer Library 0.00 182,582.52 24,838.89 9,879,597.57
OTHER FUNDS
Cable TV Franchise-Escrow 0.00 10,034.96
GO-HNI Collateralization
Museum Membership Fund 0.00 0.00 98,509.22 108,544.18
UTILITY FUNDS
Water Utility-Operating $6,698,234.39 $1,092,175.32
Water Utility-Depreciation 0.00 140,008.36
Water Utility-Special Redemption 0.00 3,446,341.41
Water Utility-Bond/Note 16,269,677.01 0.00
Sewerage Utility-Operating 8,313,507.15 0.00
Sewerage Utility-Replacement 0.00 1,924,392.01
Sewerage Utility-Bond/Note 15,907,211.45 5,544,026.14
Sewerage Utility-Debt Service 0.00 3,292,602.43
Storm Water Utility-Operating 5,636,077.77 512.48
Storm Water Utility-Bond/Note 13,327,857.50 0.00
Storm Water Utility-Debt Service 0.00 5,066,696.49
Parking Utility-Operating 82,165.24 66,234,730.51 0.00 20,506,754.64
TOTAL FUNDS $130,547,885.93 $42,543,544.96
CASH
RECONCILIATION
Associated Bank of Oshkosh $129,122,656.89
Sub-Total,Bank Balances 129,122,656.89
Less: Outstanding Checks 565,460.57
Total Cash in Banks 128,557,196.32
Plus,Cash/Deposits in Transit 1,990,689.61
TOTAL CASH $130,547,885.93
Page 2 of 2