HomeMy WebLinkAbout05. Cash Report August 2017' 01-1-1
city
of
Oshkosh
October 9, 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 August, 2017.
Respectfully submitted,
Tara J. Wendt, CPA
Assistant Director of Finance
City of Oshkosh
TJW
Enc
City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 http://www.ci.oshkosh.wi.us
OPERATING FUNDS
PENSION FUNDS
TRUSTFUNDS
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of August 31, 2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
General Fund $52,523,208.69
Treasurer's Working Fund 3,850.00
Other Petty Cash Funds 8,285.00
Police Pension 16,438.28
Firemen's Pension 11,788.99
Behncke Museum Trust
6,246.09
William E. Bray Museum Trust
3,707.89
Cemetery Perpetual Care
31,502.25
Leander Choate
5,523.60
Clute
0.00
Amy Davies Library Fund
0.00
Durow Trust
0.00
Fisk -Gallup
14,869.03
Gould
200.00
Abbey Harris Library
4,384.88
Heyman
352.41
Hicks
1,493.05
Hilton Library & Museum
0.00
Hilton Special Library
0.00
Huhn Animal Shelter Trust
0.00
Hume
43.31
Kitz Museum Memorial Trust
5,503.05
Kitz Directors Trust
8,418.11
Library Collection Improvement Trust
0.00
Library Development and Support Trust
0.00
Library Facility Trust
0.00
Library Programming Support Trust
0.00
Library Technology Trust
0.00
Maxwell -Crawford
155.53
Museum Endowment
2,469.90
Public Library Memorial Fund
105,359.92
Pittel
0.00
Rasmussen Library, Mabel
0.00
Roberts
105.48
Rojahn, Frank and Anna
0.00
Page 1 of 2
$10,020,686.53
0.00
52,535,343.69 0.00 10,020,686.53
557,095.48
28,227.27 140,578.18
264,957.86
15,239.02
1,149,970.09
55,411.73
236.57
5,914.73
3,125,717.38
0.00
3,617.13
207,391.52
34,044.73
182,955.63
4,416.29
1,014.00
4,408.20
1,229.86
51,732.63
245,464.12
1,482,239.63
407,801.58
1,043,446.06
162,955.74
332,315.49
7,193.27
385,428.14
0.00
0.00
23,798.88
2,254.69
8,212.23
697,673.66
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION (continued)
As of August 31, 2017
Page 2 of 2
CASH
CASH
INVESTMENTS
COST
I 2017
TOTAL
AT COST
TOTAL
TRUST FUNDS (continued)
Sarau
$7.57
$5,124.25
Stanhilber - Library & Parks
22,718.73
706,981.29
Stanhilber- Parks Only
10.68
1,291.05
M. Zellmer Library
0.00
213,071.48
24,838.89
9,947,602.68
OTHER FUNDS
Cable TV Franchise - Escrow
0.00
10,100.22
GO-HNI Collateralization
Museum Membership Fund
0.00
0.00
98,530.14
108,630.36
UTILITY FUNDS
Water Utility - Operating
$7,553,532.35
$1,092,996.68
Water Utility - Depreciation
0.00
140,008.36
Water Utility - Special Redemption
0.00
3,458,824.67
Water Utility - Bond/Note
16,277,826.97
0.00
Sewerage Utility - Operating
9,348,574.20
0.00
Sewerage Utility - Replacement
0.00
1,924,392.01
Sewerage Utility - Bond/Note
15,910,610.78
5,548,180.44
Sewerage Utility - Debt Service
0.00
3,301,979.29
Storm Water Utility - Operating
6,195,899.60
512.87
Storm Water Utility - Bond/Note
13,331,750.80
0.00
Storm Water Utility - Debt Service
0.00
5,078,540.89
Parking Utility - Operating
96,490.37
68,714,685.07
0.00
20,545,435.21
TOTAL FUNDS
$121,491,327.51
$41,320,028.44
CASH
RECONCILIATION
Associated Bank of Oshkosh
$121,748,788.82
Sub -Total, Bank Balances
121,748,788.82
Less: Outstanding Checks
325,367.67
Total Cash in Banks
121,423,421.15
Plus, Cash/Deposits in Transit
67,906.36
TOTAL CASH
$121,491,327.51
Page 2 of 2