HomeMy WebLinkAboutCash Report 12.2011City of Oshkosh
Finance Department
215 Church Ave., PO Box 1130
Of � Oshkosh, WI 54903 -1130
(920) 236 -5005 (920) 236 -5039 FAX
ON THE WATER
January 18, 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 December 31, 2011.
Respectfully submitted,
44ft <�;�10 -
Peggy Steeno.
Director of Finance
City of Oshkosh
PAS :lab
Ere
CITY OF OSHKOSH
CASH AND INVESTMENT RECAPITULATION
As of December 31, 2011
OPERATING FUNDS
General Fund
37,108,496.13
16,052,132.05
Treasurer's Working Fund
3,000.00
0.00
Other Petty Cash Funds
5,385.00 37,116,881.13
0.00
PENSION FUNDS
Police Pension
18,617.09
709,500.00
Firemen's Pension
17,463.63 36,080.72
259,792.50
TRUST FUNDS
Arps Trust
462.39
54,131.49
Behncke Library Trust
2,048.96
201,638.23
Behncke Museum Trust
76,206.45
68,426.65
William E. Bray Museum Trust
602.98
11,538.46
Cemetery Perpetual Care
3,570.07
542,988.78
Leander Choate
30.48
25,253.78
Clute
9.93
543.23
Amy Davies Library Fund
582.84
89,561.83
Durow Trust
0.00
2,901,319.83
Fisk - Gallup
4,914.76
0.00
Gould
200.00
3,550.66
Gruenwald Trust
36.30
2,540.00
Gruetzmacher Library Trust
156.71
8,650.00
Abbey Harris Library
468.23
86,384.25
Heyman
93.75
33,891 A5
Hicks
1,871.17
179,154.50
Hilton Ill
534.22
35,800.00
}Hilton Library & Museum
0.00
7,147.96
Hilton Special Library
210.09
13,850.00
Hoxtel Library Trust
171.06
9,700.00
Huhn Animal Shelter Trust
O.OG
4,356.86
Hume
43.31
1,207.20
James Trust
72.78
5,800.00
Kelsh Library Memorial Fund
10.64
2,700.00
Genevieve Kenny Library Trust
34.02
8,500.00
Kitz Museum Memorial Trust
19,285.01
10,178.39
Kitz Directors Trust
251,502.71
0.00
Hazel Kitzman Library Trust
0.00
79,128.45
Marie Lehnigk Library Fund
121.94
7,000.00
Malnar Children's Program Trust
10,304.50
10,400.00
16,052,132.05
969,292.50
Page 1 of 3
Maxwell - Crawford
123.71
7,841.41
Museum Endowment
37,976.37
104,701.37
John V. Nichols Digital Library Trust
662.11
51,000.00
Public Library Memorial Fund
1,140,581.95
338,000.00
Pine
49.40
5,700.00
Pittel
10.82
241.45
Rasmussen Library, Elizabeth
0.00
75,891.06
Rasmussen Library, Mabel
489.84
30,695.26
Roberts
105.48
2,213.20
Rojahn, Elizabeth
764.56
81,500.00
Rojahn, Frank Mace
923.71
82,700.00
Rojahn, Frank and Anna
56.37
5,285.00
Rotary
42.35
2,830.00
Ryan
91,997.99
3,575.00
Sarau
7.57
5,030.01
Stanhilber- Library & Parks
31,515.80
654,364.92
Stanhilber- Parks Only
10.68
2,100.00
M. Zellmer Library
1,189.64
65,920.25
S. Zellmer Library
1,631.68
1,681,685.33
67,650.00
5,992,580.93
OTHER FUNDS
Cable TV Franchise - Escrow
0.00
10,000.00
Flexible Benefits
64,056.88
0.00
Museum Membership Fund
0.00
64,056.88
96,66157
106,663.57
UTILITY FUNDS
Water Utility - Operating
7,803,206.60
2,560,632.04
Water Utility - Depreciation
0.00
136,546.86
Water Utility - Special Redemption
458,314.19
1,596,947.00
Water Utility - Bond/Note
4,394,868.19
57.86
Sewerage Utility - Operating
8,740,971.50
0.00
Sewerage Utility - Replacement
0.00
1,680,904.40
Sewerage Utility - Bond /Note
2,955,306.47
19.34
Sewerage Utility - Debt Service
686,456.00
374,399.00
Storm Water Utility - Operating
8,822,831.04
3,623,213.69
Storm Water Utility - Bond/Note
3,455,778.89
2,502,580.38
Storm Water Utility - Debt Service
944.68
1,925,145.00
Centre Utility Special Redemption
0.00
347,76177
Parking Utility - Operating
23,838.90
37,342,516.46
0.00
14,747,408.34
TOTAL FUNDS
76,241,220.52
37,868,077.39
Page 2 of 3
CASH
RECONCILIATION
TOTAL CASH
Associated Bank of Oshkosh
Sub-Total, Bank Balances
Less: Outstanding Checks
Total Cash in Banks
Plus, Cash/Deposits in Transit
75,641,918.45
75,641, 918.45
540.714.77
75,101,203.68
1,940,016.84
76,241,220,52
Page 3 of 3