HomeMy WebLinkAbout06. Cash Report September 2017November 7, 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 September, 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 September 30, 2017
CASH CASH INVESTMENTS COST
2017 TOTAL AT COST TOTAL
OPERATING FUNDS
General Fund
$47,108,212.50
Treasurer's Working Fund
3,850.00
Other Petty Cash Funds
8,285.00 47,120,347.50
PENSION FUNDS
Police Pension
14,586.50
Firemen's Pension
10,541.03 25,127.53
TRUSTFUNDS
Behncke Museum Trust
6,246.09
William E. Bray Museum Trust
3,737.05
Cemetery Perpetual Care
31,792.51
Leander Choate
5,481.93
Clute
0.00
Amy Davies Library Fund
0.00
Durow Trust
0.00
Fisk -Gallup
14,786.03
Gould
200.00
Abbey Harris Library
4,294.40
Heyman
355.90
Hicks
1,596.55
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
157.24
Museum Endowment
2,469.90
Public Library Memorial Fund
106,613.02
Pittel
0.00
Rasmussen Library, Mabel
0.00
Roberts
105.48
Rojahn, Frank and Anna
0.00
Page 1 of 2
$9,632,605.87
0.00
0.00 9,632,605.87
557,101.02
140,595.27 697,696.29
265,095.43
15,239.02
1,150,379.83
55,453.40
236.75
5,914.73
3,125,717.38
0.00
3,619.85
207,482.00
34,069.31
183,084.89
4,416.29
1,014.00
4,411.52
1,230.78
51,744.99
245,648.72
1,480,602.88
407,350.28
1,042,291.30
162,775.39
331, 947.71
7,198.17
385,458.52
0.00
0.00
23,798.88
2,256.39
8,212.23
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION (continued)
As of September 30, 2017
Page 2 of 2
CASH
CASH
INVESTMENTS
COST
2017
TOTAL
AT COST
TOTAL
TRUST FUNDS (continued)
Sarau
$7.57
$5,128.10
Stanhilber - Library & Parks
24,475.70
707,084.81
Stanhilber - Parks Only
10.68
1,291.05
M. Zellmer Library
0.00
216,294.52
24,838.89
9,944,993.49
OTHER FUNDS
Cable TV Franchise - Escrow
0.00
10,100.22
GO-HNI Collateralization
Museum Membership Fund
0.00
0.00
98,549.71
108,649.93
UTILITY FUNDS
Water Utility - Operating
$7,881,103.20
$1,093,897.16
Water Utility - Depreciation
0.00
140,008.36
Water Utility - Special Redemption
0.00
3,448,721.68
Water Utility - Bond/Note
16,286,813.16
0.00
Sewerage Utility - Operating
9,788,118.20
0.00
Sewerage Utility - Replacement
0.00
1,924,392.01
Sewerage Utility - Bond/Note
15,919,394.25
5,552,796.46
Sewerage Utility - Debt Service
0.00
3,289,062.59
Storm Water Utility - Operating
6,650,318.42
513.29
Storm Water Utility - Bond/Note
13,339,110.61
0.00
Storm Water Utility - Debt Service
0.00
5,076,313.07
Parking Utility - Operating
81,627.37
69,946,485.21
0.00
20,525,704.62
TOTAL FUNDS
$117,308,254.76
$40,909,650.20
CASH
RECONCILIATION
Associated Bank of Oshkosh
$117,761,048.02
Sub -Total, Bank Balances
117,761,048.02
Less: Outstanding Checks
509,921.32
Total Cash in Banks
117,251,126.70
Plus, Cash/Deposits in Transit
57,128.06
TOTAL CASH
$117,308,254.76
Page 2 of 2