Loading...
HomeMy WebLinkAbout03. Cash Report from December 2012- 4 O.l KW H ON THE WATER April 8, 2013 City of Oshkosh Finance Department 215 Church Ave., PO Box 1930 Oshkosh, WI 54903 -1130 (920) 236.5005 (920) 236 -5039 FAX 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 Recapitulations of City operations, utility, and trust accounts for the Months of December 2012, and January and February 2013. Respectfully submitted, Peggy Steeno Director of Finance City of Oshkosh PAS:Iab Enc APR 16 201;' CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of December 31, 2012 CASH CASH INVESTMENTS COST 2 042 TOTAL AT COST TOTAL OPERATING, FUNDS PENSION FUNDS TRUST FUNDS General Fund 48,437,834.05 12,441,672.70 Treasurer's Working Fund 3,000.00 0.00 Other Petty Cash Funds 6,035.00 48,446,869.05 0.00 Police Pension 13,917.69 666,000.00 Firemen's Pension 8,771.44 22,689.13 238,792,50 t Arps Trust 362.15 54,260.44 Behncke Library Trust 569.59 203,880.60 Behncke Museum Trust 76,466.72 68,426.65 William E. Bray Museum Trust 1,023.59 11,538.46 Cemetery Perpetual Care 27,662.61 521,265.43 Leander Choate 28.45 25,255.81 Clute 9.93 495.61 Amy Davies Library Fund 117.62 89,363.90 Drexler Trust 1,134,348.56 0.00 Durow Trust 0.00 3,028,847.77 Fisk - Gallup 1,895.52 0,00 Gould 200.00 3,559.50 Gruenwald Trust 3.38 2,545.36 Gruetzmacher Library Trust 173.98 8,668.25 Abbey Harris Library 434,11 86,418.37 Heyman 149.29 33,971.70 Hicks 765.56 180,805.75 Hilton 111 464.49 35,875,55 Hilton Library 8 Museum 0.00 7,147.96 Hilton Special Library 275.98 13,875.75 Hoxtel Library Trust 921.98 9,720.48 Huhn Animal Shelter Trust 0.00 4,367.68 Hume 43.31 1,210.23 James Trust 484.36 5,812.24 Kelsh Library Memorial Fund 92.04 2,605.70 Genevieve Kenny Library Trust 50.99 8,517.93 Kitz Museum Memorial Trust 19,351.12 10,178.39 Kitz Directors Trust 252,891.02 0,00 Hazel Kitzman Library Trust 0.00 79,325.18 Marie Lehnigk Library Fund 135.92 7,014.77 Malnar Children's Program Trust 136.64 20,643.48 12,441,672.70 904,792.50 Page 1 of 3 CASH CASH INVESTMENTS COST 2012 TOTAL AT COST TOTAL Maxwell- Crawford 53.71 7,858.75 Museum Endowment 44,324.60 104,701.37 John V. Nichols Digital Library Trust 147.23 51,107.62 Public Library Memorial Fund 6,502.25 345,297.36 Pine 549.53 5,712.03 Pittel 10.82 193.09 Rasmussen Library, Elizabeth 0.00 76,203.06 Rasmussen Library, Mabel 412.54 30,608.05 Roberts 105.48 2,218,74 Rojahn, Elizabeth 528.92 82,070.69 Rojahn, Frank Mace 88.82 83,876.64 Rojahn, Frank and Anna 196.14 5,285.62 Rotary 48.00 2,835.97 Ryan 182.49 94,774.59 Sarau 7.57 5,042.59 Stanhilber - Library & Parks 12,797.66 659,766.32 Stanhilber- Parks Only 10.68 2,100.00 M. Zellmer Library 841.59 66,954,21 S. Zellmer Library 986.11 1,586,773.05 69,284.75 6,221,490.39 OTHER FUNDS Cable TV Franchise - Escrow 0.00 90,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 7,336,781.95 2,567,955.38 Water Utility - Depreciation 0.00 136,937.40 Water Utility - Special Redemption 0,00 2,400,283.00 Water Utility - Bond/Note 5,987,016.22 0.00 Sewerage Utility - Operating 7,539,459.33 0.00 Sewerage Utility - Replacement 0.00 1,819,007.29 Sewerage Utility - Bond/Note 6,323,998.05 0,00 Sewerage Utility - Debt Service 0.00 1,593,371.00 Storm Water Utility - Operating 5,082,102.04 504.36 Storm Water Utility - Bond/Note 6,855,685.20 0.00 Storm Water Utility - Debt Service 0.00 2,373,365.00 Centre Utility Special Redemption 0.00 0.00 Parking Utility - Operating 63,186.09 39,188,228.88 0.00 10,811,423.43 TOTAL FUNDS 89,286,528.69 30,486,090.80 Page 2 of 3 CASH RECONCILIATION TOTALCASH Associated Bank of Oshkosh Sub - Total, Bank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash /Deposits in Transit 70,713,838.85 70,713,838.85 1,230,558.27 69,483,280.58 1 9,803,248.03 89,286,528.61 Page 3 of 3 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of January 31, 2013 CASH CASH INVESTMENTS COST 2013 TOTAL AT COST TOTAL OPERATING FUNDS PENSION FUNDS TRUST FUNDS General Fund 55,588,783.27 Treasurer's Working Fund 3,000.00 Other Petty Cash Funds 6,035.00 Police Pension 12,601.84 Firemen's Pension 6,245.03 Arps Trust 362.15 Behncke Library Trust 569.59 Behncke Museum Trust 76,466.72 William E. Bray Museum Trust 1,072.49 Cemetery Perpetual Care 27,676.51 Leander Choate 27.89 Clute 9.93 Amy Davies Library Fund 117.62 Drexler Trust 1,134,348.56 Durow Trust 0.00 Fisk - Gallup 1,895.52 Gould 200.00 Gruenwald Trust 3.38 Gruetzmacher Library Trust 173.98 Abbey Harris Library 424.69 Heyman 154.05 Hicks 765.56 Hilton Ill 464.49 Hilton Library & Museum 0.00 Hilton Special Library 279.57 Hoxtel Library Trust 921.98 Huhn Animal Shelter Trust 0.00 Hume 43.31 James Trust 484,36 Kelsh Library Memorial Fund 92.04 Genevieve Kenny Library Trust 50.99 Kitz Museum Memorial Trust 19,351.12 Kitz Directors Trust 254,391.02 Hazel Kitzman Library Trust 0.00 Marie Lehnigk Library Fund 135.92 Malnar Children's Program Trust 936.64 Page 1 of 3 12,450,107.16 0.00 55,597, 818.27 0.00 12,450,9 07.16 666,000.00 18,846.87 238,792.50 54,273.34 203,929.08 68,426.65 11,538.46 521,322.78 25,256.37 495.73 89, 384.68 0.00 3,028,847.77 0.00 3,560.35 2,545.96 8,670.31 86,427.79 33, 979.35 180, 847.53 35, 884.08 7,147:96 13, 878.65 9,722.79 4,368.72 1,210.52 5,813.62 2,606.33 8,519.95 10,178.39 0.00 79,344.05 7,016.44 20,648.39 904,792.50 CASH CASH INVESTMENTS COST 2013 TOTAL AT COST TOTAL OTHER FUNDS UTILITY FUNDS Maxwell- Crawford Museum Endowment John V. Nichols Digital Library Trust Public Library Memorial Fund Pine Pittel Rasmussen Library, Elizabeth Rasmussen Library, Mabel Roberts Rojahn, Elizabeth Rojahn, Frank Mace Rojahn, Frank and Anna Rotary Ryan Sarau Stanhilber - Library & Parks Stanhilber- Parks Only M. Zellmer Library S. Zellmer Library Cable N Franchise - Escrow Flexible Benefits Museum Membership Fund Water Utility - Operating Water Utility - Depreciation Water Utility - Special Redemption Water Utility - Bond /Note Sewerage Utility - Operating Sewerage Utility - Replacement Sewerage Utility - Bond/Note Sewerage Utility- Debt Service Storm Water Utility - Operating Storm Water Utility - Bond/Note Storm Water Utility - Debt Service Centre Utility Special Redemption Parking Utility - Operating 56.11 7,860.40 44,324.60 104,701.37 147.23 51,119.78 7,047,06 345,379.48 549.53 5,713.39 10.82 193.14 0.00 76,221,18 412.54 30,610.51 105.48 2,219.27 528.92 82,090.21 88.82 83,896.59 118.33 5,285.69 48.00 2,836.64 182.49 94,797.13 7.57 5,043.79 13,554.38 659,888.29 10.68 2,100.00 885.21 66,963.58 986.11 1,589,683.96 69,294.34 6,222,060.82 0.00 10, 000.00 41,968.50 0.00 0.00 41,968.50 96,711.78 106,711.78 5,728,804.55 2,568,566.07 0.00 136,969.96 0.00 2,400,283.00 5,987,114.96 0,00 7,540, 822.73 0.00 0.00 1,819,439.87 6,323,998.05 0.00 0.00 1,513,371.00 5,038,029.17 504.48 6,855,685.20 0.00 0.00 2,373,365.00 0.00 0.00 67,698.92 37,542,153.58 0.00 10,812,499.38 TOTAL FUNDS 94,790,471.18 30,496,171.64 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,495,400.90 75,495,400.90 440,975.70 75,054,425.20 19,781,045.98 94, 835,471.18 Page 3 of 3 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of February 28, 2013 OPERATING FUNDS PENSION FUNDS TRUST FUNDS General Fund Treasurer's Working Fund Other Petty Cash Funds Police Pension Firemen's Pension Arps Trust Behncke Library Trust Behncke Museum Trust William E. Bray Museum Trust Cemetery Perpetual Care Leander Choate Clute Amy Davies Library Fund Drexler Trust Durow Trust Fisk - Gallup Gould Gruenwald Trust Gruetzmacher Library Trust Abbey Harris Library Heyman Hicks Hilton III Hilton Library & Museum Hilton Special Library Hoxtel Library Trust Huhn Animal Shelter Trust Hume James Trust Kelsh Library Memorial Fund Genevieve Kenny Library Trust Kitt Museum Memorial Trust Kitz Directors Trust Hazel Kitzman Library Trust Marie Lehnigk Library Fund Malnar Children's Program Trust 2013 44,016,186.85 3,000.00 6,035.00 9,911,76 3,782.07 362.15 569.59 76,466.72 1,105.33 27,619.15 27.33 9.93 917.62 1,134,348.56 0.00 1,895.52 200.00 3.38 173.98 415.26 158.39 765.56 464.49 0.00 282.80 921.98 0.00 43.31 484.36 92.04 50.99 19,351.12 254,391.02 0.00 135.92 136.64 CASH TOTAL 9,161,552.85 0.00 44,025,221.85 0.00 666,000,00 13,693.83 238,792.50 54,286.25 203,977.58 68,426.65 11, 538.46 521,380.14 25,256.93 495.85 89,405.46 0.00 3,028,847.77 0.00 3,561.20 2,546.57 8,672.37 86,437.22 33,987.00 180, 889.30 35, 892.61 7,147.96 13, 881.56 9,725.10 4,369.76 1,210.81 5,815.00 2,606.95 8,521.98 10,178.39 0.00 79,362.92 7,018.11 20, 653.30 TOTAL 9,161,552.85 904, 792.50 Page 1 of 3 2013 TOTAL AT COST TOTAL Maxwell- Crawford 58.29 7,862.06 Museum Endowment 44,324.60 104,701.37 John V. Nichols Digital Library Trust 147.23 51,131.94 Public Library Memorial Fund 19,730.46 345,461.61 Pine 549.53 5,714.75 Pittel 10.82 193.19 Rasmussen Library, Elizabeth .0.00 76,239.31 Rasmussen Library, Mabel 412.54 30,612.97 Roberts 105.48 2,219.80 Rojahn, Elizabeth 528.92 82,109.73 Rojahn, Frank Mace 88.82 83,916.54 Rojahn, Frank and Anna 120.66 5,285.76 Rotary 48.00 2,837.31 Ryan 182.49 94,819.67 Sarau 7.57 5,044.99 Stan hilber- Library & Parks 14,518.16 660,009.64 Stanhilber- Parks Only 10.68 2,100.00 M. Zellmer Library 924.91 66,972.96 S. Zellmer Library 986.11 1,603,348.41 69,303.93 6,222,630.73 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 5,728,876.15 2,569,176.93 Water Utility - Depreciation 0.00 137,002.53 Water Utility - Special Redemption 0.00 2,400,283.00 Water Utility- Bond /Note 5,987,120.79 0.00 Sewerage Utility - Operating 7,540,905.37 0.00 Sewerage Utility - Replacement 0.00 1,819,872.56 Sewerage Utility - Bond /Note 6,323,998.05 0.00 Sewerage Utility - Debt Service 0.00 1,513,371.00 Storm Water Utility - Operating 5,038,084.87 504.60 Storm Water Utility - Bond /Note 6,855,685.20 0.00 Storm Water Utility - Debt Service 0.00 2,373,365.00 Centre Utility Special Redemption 0.00 0.00 Parking Utility - Operating 56,041.44 37,530,711.87 0.00 10,813,575.62 TOTAL FUNDS 83,214,944.46 27,209,263.48 Page 2 of 3 CASH RECONCILIATION TOTAL CASH Associated Bank of Oshkosh Sub - Total, Sank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash /Deposits in Transit 64,011,697.33 64,011,697.33 575,358.54 63,436,338.79 19, 778,605.67 83,214,944.46 Page 3 of 3