HomeMy WebLinkAbout04. Cash ReportCity of Oshkosh
Finance Department
r� r 215 Church Ave., PO Box 1130
Of HK� c� H Oshkosh Wl 54903 -1130
(920) 236 -5005 (920) 236 -5039 FAX
ON THE WATER
October 15, 2012
City Manager and
Members of Common Council
City of Oshkosh, Wisconsin
City Manager and Council Members:
Peggy A. Steeno
Director
Attached is the Cash and Investment Recapitulation of City operations,
utility, and trust accounts for the Month of September, 2012.
Respectfully submitted,
P � - � Peggy S?eeno
Director of Finance
City of Oshkosh
PAS :lab
Enc
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of September 30, 2012
CASH CASH INVESTMENTS COST
2012 TOTAL AT COST TOTAL
OPERATING FUNDS
PENSION FUNDS
TRUST FUNDS
General Fund 25,800,44710
Treasurer's Working Fund 3,000.00
Other Petty Cash Funds 6,035.00
Police Pension 26,110.62
Firemen's Pension 16,289.92
Arps Trust
492.34
Behncke Library Trust
569.59
Behrncke Museum Trust
76,245.78
William E. Bray Museum Trust
923.90
Cemetery Perpetual Care
6,942.71
Leander Choate
30.09
Clute
9.93
Amy Davies Library Fund
117.62
Durow Trust
0.00
Fisk - Gallup
17,974.17
Gould
200.00
Gruenwald Trust
3.38
Gruetzmacher Library Trust
173.98
Abbey Harris Library
461.71
Heyman
137,13
Hicks
674.81
Hilton 111
480.68
Hilton Library & Museum
0.00
Hilton Special Library
266.90
Hoxtel Library Trust
951.98
Huhn Animal Shelter Trust
0.00
Hume
43.31
James Trust
484.36
Kelsh Library Memorial Fund
16.03
Genevieve Kenny Library Trust
50.99
Kitz Museum Memorial Trust
19,295.00
Kitz Directors Trust
252,105.10
Hazel Kitzman Library Trust
0.00
Marie Lehnigk Library Fund
135.92
Malnar Children's Program Trust
136.64
25,809,482.70
14,416,331.67
0.00
0.00
666,000.00
42,400.54 238,792.50
54,222.65
203,738.56
68,426.65
11,538.46
543,422.39
25,254.36
495.08
89,303.03
2,901,319.83
0.00
3,557.01
2,543.59
8,662.22
86,390.77
33,949.28
180,683.40
35,850.55
7,147.96
13,867.23
9,713.70
4,364.64
1,209.38
5,808.19
2,703.82
8,512.00
10,178.39
0.00
79,269.92
7,009.88
20,629.09
14,416,331.67
904,792.50
Page 1 of 3
Page 2 of 3
CASH
CASH
INVESTMENTS
COST
2012
TOTAL
AT COST
TOTAL
Maxwell- Crawford
47.61
7,853.91
Museum Endowment
15,799.99
104,701.37
John V. Nichols Digital Library Trust
147.23
51,072.02
Public Library Memorial Fund
1,135,835.12
345,056.82
Pine
910.78
5,708.05
Pittel
10.82
192.96
Rasmussen Library, Elizabeth
0.00
76,149.97
Rasmussen Library, Mabel
595.99
30,600.87
Roberts
105.48
2,217.19
Rojahn, Elizabeth
528.92
82,013.51
Rojahn, Frank Mace
88.82
83,818.20
Rojahn, Frank and Anna
82.37
5,285.41
Rotary
48.00
2,834.00
Ryan
182.49
94,708.56
Sarau
7.57
5,039.08
Stanhilber - Library & Parks
13,312.84
665,406.73
Stanhilber - Parks Only
10.68
2,100.00
M. Zellmer Library
425.88
66,926.74
S. Zellmer Library
1,279.71
1,548,344.35
69,256.64
6,120,714.06
OTHER FUNDS
Cable TV Franchise - Escrow
0.00
10,000.00
Flexible Benefits
41,968.50
0.00
Museum Membership Fund
0.00
41,968.50
96,711.78
106,711.78
UTILITY FUNDS
Water Utility - Operating
1,796,013.93
2,566,166.33
Water Utility - Depreciation
0.00
136,841.99
Water Utility - Special Redemption
0.00
1,596,147.00
Water Utility - Bond /Note
4,402,436.36
57.97
Sewerage Utility - Operating
3,711,759.76
0.00
Sewerage Utility - Replacement
0.00
1,817,740.04
Sewerage Utility - Bond /Note
2,960,390.34
19.34
Sewerage Utility - Debt Service
0.00
374,399.00
Storm Water Utility - Operating
0.00
142.63
Storm Water Utility - Bond /Note
3,008,225.76
2,507,989.19
Storm Water Utility - Debt Service
0.00
1,925,145.00
Centre Utility Special Redemption
0.00
0.00
Parking Utility - Operating
43,96'1.09
15,922,787.24
0.00
10,924,648.49
TOTAL FUNDS
43,364,983.33
32,473,198.50
Page 2 of 3
CASH
RECONCILIATION
TOTAL CASH
Associated Bank of Oshkosh
Sub - Total, Bank Balances
Less: Outstanding Checks
Total Cash in Banks
Plus, CashlDeposits in Transit
50,086,098.07
50,086,098.07
7,861,946.96
42,224,951.11
1,140,032.22
43,364,983.33
Page 3 of 3