Loading...
HomeMy WebLinkAbout02. Cash ReportsJuly 5, 2017 City Manager and Members of Common Council City of Oshkosh, Wisconsin City Manager and Council Members: Attached are the Cash and Investment Recapitulations of City operations, utility, and trust accounts for the Months of January, February, March, April, and May, 2017. Respectfully submitted, r 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 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of January 31, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $49,221,170.49 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 6,185.00 Police Pension 7,611.01 Firemen's Pension 12,737.34 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,503.36 Cemetery Perpetual Care 3,978.70 Leander Choate 58,564.04 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 1,808.79 Gould 200.00 Abbey Harris Library 85,455.88 Heyman 331.63 Hicks 1,286.05 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 145.04 Museum Endowment 42,837.35 Public Library Memorial Fund 93,397.27 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,855,963.04 0.00 49,231,205.49 0.00 574,218.98 20,348.35 146,721.65 82,022.96 15,239.02 1,047,839.60 2,370.88 290.45 5,914.73 3,397,969.16 0.00 3,603.34 127,190.04 33,920.09 182,300.36 4,416.29 1,014.00 4,391.39 1,225.15 35,295.78 0.00 1,351,021.11 373,273.41 1,023,777.29 156,250.11 312,542.22 7,277.97 345,036.48 0.00 0.00 23,798.88 2,246.09 8,212.23 11, 855,963.04 720, 940.63 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of January 31, 2017 Page 2 of 2 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,104.71 Stanhilber - Library & Parks 107,767.28 672,575.57 Stanhilber - Parks Only 10.68 1,291.05 M. Zellmer Library 0.00 898,896.95 24,838.89 9,252,249.25 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,397.29 108,432.25 UTILITY FUNDS Water Utility - Operating $10,007,000.68 $1,088,642.90 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,153,442.51 Water Utility - Bond/Note 7,175,556.58 878,205.19 Sewerage Utility - Operating 17,409,316.56 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 0.00 10,509,400.86 Sewerage Utility - Debt Service 0.00 2,698,215.85 Storm Water Utility - Operating 3,814,965.58 510.82 Storm Water Utility - Bond/Note 10,068,198.36 0.00 Storm Water Utility - Debt Service 0.00 4,738,733.82 Parking Utility - Operating 58,743.05 48,533,780.81 0.00 25,131,552.32 TOTAL FUNDS $98,684,231.60 $47,069,137.49 CASH RECONCILIATION Associated Bank of Oshkosh $96,776,578.63 Sub -Total, Bank Balances 96,776,578.63 Less: Outstanding Checks 459,938.30 Total Cash in Banks 96,316,640.33 Plus, Cash/Deposits in Transit 2,367,591.27 TOTAL CASH $98,684,231.60 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUST FUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of February 28, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $35,038,870.70 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 9,185.00 Police Pension 5,759.23 Firemen's Pension 11,574.43 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,532.50 Cemetery Perpetual Care 4,064.33 Leander Choate 58,563.08 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 17,478.17 Gould 200.00 Abbey Harris Library 85,439.63 Heyman 334.38 Hicks 1,286.05 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 146.41 Museum Endowment 42,837.35 Public Library Memorial Fund 95,011.07 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,871,964.44 0.00 35,051,905.70 0.00 11, 871, 964.44 574,218.98 17,333.66 146,721.65 82,022.96 15,239.02 1,047, 853.97 2,371.84 290.57 5,914.73 3,397,969.16 0.00 3,604.80 127,206.29 33,933.28 182,369.71 4,416.29 1,014.00 4,393.17 1,225.65 35,295.78 0.00 1,373,293.81 379,427.13 1,040,655.10 158,825.83 317,694.73 7,280.64 345,036.48 0.00 0.00 23,798.88 2,247.00 8,212.23 720,940.63 TRUST FUNDS (continued) OTHER FUNDS UTILITY FUNDS TOTALFUNDS CASH RECONCILIATION CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of February 28, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL Sarau $7.57 $5,106.78 Stanhilber - Library & Parks 108,777.38 672,617.40 Stanhilber- Parks Only 10.68 1,291.05 M. Zellmer Library 0.00 917,291.91 24,838.89 9,305,447.17 Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,423.71 108,458.67 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 Parking Utility - Operating Associated Bank of Oshkosh Sub -Total, Bank Balances Less: Outstanding Checks Total Cash in Banks Plus, Cash/Deposits in Transit $10,009,538.78 0.00 0.00 7,178, 264.14 17,420,558.30 0.00 0.00 0.00 3, 816, 008.37 10,071, 544.13 0.00 58, 743.05 $84,777,311.57 84, 777, 311.57 534,462.23 84, 242, 849.34 298,338.70 TOTAL CASH $84,541,188.04 Page 2 of 2 48,554,656.77 $84,541,188.04 $1,089,096.31 140,008.36 3,160,759.34 878,091.91 0.00 1,924,392.01 10,513,514.70 2,703,431.60 511.03 0.00 4,744,934.48 0.00 25,154,739.74 $47,161,550.65 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of March 31. 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $38,743,904.69 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 9,185.00 Police Pension 3,907.45 Firemen's Pension 10,326.47 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,562.00 Cemetery Perpetual Care 4,064.33 Leander Choate 58,563.08 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 17,478.17 Gould 200.00 Abbey Harris Library 85,439.63 Heyman 337.04 Hicks 1,389.55 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 147.78 Museum Endowment 42,837.35 Public Library Memorial Fund 102,164.21 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,882,169.95 0.00 38,756,939.69 0.00 11, 882,169.95 577,959.15 14,233.92 147,422.92 82,022.96 15,239.02 1,047,853.97 2,371.84 290.57 5,914.73 3,397,969.16 0.00 3,604.80 127,206.29 33,933.28 182,369.71 4,416.29 1,014.00 4,393.17 1,225.65 35,295.78 0.00 1,377,247.43 380,519.47 1,043,651.09 159,283.09 318,609.34 7,280.64 345,036.48 0.00 0.00 23,798.88 2,247.00 8,212.23 725, 382.07 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of March 31, 2017 Page 2 of 2 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,106.78 Stanhilber - Library & Parks 110,531.57 672,617.40 Stanhilber- Parks Only 10.68 1,291.05 M. Zellmer Library 0.00 926,336.27 24,838.89 9,314,860.99 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,440.43 108,475.39 UTILITY FUNDS Water Utility - Operating $10,012,072.67 $1,089,740.69 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,161,920.60 Water Utility - Bond/Note 7,180,710.60 878,021.48 Sewerage Utility - Operating 17,424,968.28 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 0.00 10,518,616.87 Sewerage Utility - Debt Service 0.00 2,708,136.15 Storm Water Utility - Operating 3,816,974.38 511.33 Storm Water Utility - Bond/Note 10,074,567.14 0.00 Storm Water Utility - Debt Service 0.00 4,748,919.23 Parking Utility - Operating 58,743.05 48,568,036.12 0.00 25,170,266.72 TOTAL FUNDS $88,265,546.00 $47,201,155.12 CASH RECONCILIATION Associated Bank of Oshkosh $87,886,925.52 Sub -Total, Bank Balances 87,886,925.52 Less: Outstanding Checks 819,940.36 Total Cash in Banks 87,066,985.16 Plus, Cash/Deposits in Transit 1,198,560.84 TOTAL CASH $88,265,546.00 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of April 30, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $32,606,652.18 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 9,185.00 Police Pension 2,055.67 Firemen's Pension 9,078.51 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,591.43 Cemetery Perpetual Care 4,235.97 Leander Choate 58,562.09 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 15,142.03 Gould 200.00 Abbey Harris Library 85,422.92 Heyman 339.94 Hicks 1,389.55 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 149.29 Museum Endowment 42,837.35 Public Library Memorial Fund 104,519.92 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,892,968.01 0.00 32,619,687.18 0.00 11, 892, 968.01 578,055.61 11,134.18 147,519.38 82,022.96 15,239.02 1,047,907.01 2,373.24 290.74 5,914.73 3,397,969.16 0.00 3,606.93 127,230.04 33,952.57 182,471.12 4,416.29 1,014.00 4,395.77 1,226.38 35,295.78 0.00 1,395,014.87 394,895.41 1,055,857.76 161,146.10 322, 335.84 7,284.55 345,036.48 0.00 0.00 23,798.88 2,248.33 8,212.23 725, 574.99 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of April 30, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS (continued) Page 2 of 2 Sarau $7.57 $5,109.80 Stanhilber- Library & Parks 111,511.82 672,678.55 Stanhilber- Parks Only 10.68 1,291.05 M. Zellmer Library 0.00 927,523.87 24,838.89 9,365,074.48 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,455.53 108,490.49 UTILITY FUNDS Water Utility - Operating $10,892,901.34 $1,090,307.37 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,173,182.48 Water Utility - Bond/Note 7,183,420.11 0.35 Sewerage Utility - Operating 17,889,501.51 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility - Bond/Note 0.00 9,496,477.70 Sewerage Utility - Debt Service 0.00 3,284,779.81 Storm Water Utility - Operating 8,475,967.80 511.60 Storm Water Utility - Bond/Note 5,150,738.95 0.00 Storm Water Utility - Debt Service 0.00 4,762,697.90 Parking Utility - Operating 58,743.05 49,651,272.76 0.00 23,872,357.58 TOTAL FUNDS $83,209,617.99 $45,964,465.55 CASH RECONCILIATION Associated Bank of Oshkosh $76,798,607.39 Sub -Total, Bank Balances 76,798,607.39 Less: Outstanding Checks 456,078.69 Total Cash in Banks 76,342,528.70 Plus, Cash/Deposits in Transit 6,867,089.29 TOTAL CASH $83,209,617.99 Page 2 of 2 OPERATING FUNDS PENSION FUNDS TRUSTFUNDS CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION As of May 31, 2017 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL General Fund $49,082,341.82 Treasurer's Working Fund 3,850.00 Other Petty Cash Funds 9,185.00 Police Pension 203.89 Firemen's Pension 7,915.60 Behncke Museum Trust 214,071.35 William E. Bray Museum Trust 3,620.36 Cemetery Perpetual Care 489,525.58 Leander Choate 58,562.09 Clute 0.00 Amy Davies Library Fund 0.00 Durow Trust 0.00 Fisk -Gallup 15,142.03 Gould 200.00 Abbey Harris Library 85,422.92 Heyman 342.94 Hicks 1,389.55 Hilton Library & Museum 0.00 Hilton Special Library 0.00 Huhn Animal Shelter Trust 0.00 Hume 43.31 Kitz Museum Memorial Trust 21,930.05 Kitz Directors Trust 263,453.12 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 150.80 Museum Endowment 42,837.35 Public Library Memorial Fund 108,147.73 Pittel 0.00 Rasmussen Library, Mabel 0.00 Roberts 105.48 Rojahn, Frank and Anna 0.00 Page 1 of 2 $11,371,773.17 0.00 49,095,376.82 0.00 11,371,773.17 578,070.96 8,119.49 147, 534.73 82,022.96 15,239.02 691,021.76 2,373.24 290.74 5,914.73 3,397,969.16 0.00 3,606.93 127,230.04 33, 952.57 182,471.12 4,416.29 1,014.00 4,395.77 1,226.38 35,295.78 0.00 1,395,014.87 394,895.41 1,055,857.76 161,146.10 322, 335.84 7,284.55 345,036.48 0.00 0.00 23,798.88 2,248.33 8,212.23 725,605.69 CITY OF OSHKOSH CASH AND INVESTMENT RECAPITULATION (continued) As of May 31, 2017 Page 2 of 2 CASH CASH INVESTMENTS COST 2017 TOTAL AT COST TOTAL TRUST FUNDS (continued) Sarau $7.57 $5,109.80 Stanhilber - Library & Parks 112,152.22 672,678.55 Stanhilber- Parks Only 10.68 1,291.05 M. Zellmer Library 0.00 1,417,115.13 24,838.89 9,008,189.23 OTHER FUNDS Cable TV Franchise - Escrow 0.00 10,034.96 GO-HNI Collateralization Museum Membership Fund 0.00 0.00 98,455.53 108,490.49 UTILITY FUNDS Water Utility - Operating $6,714,835.85 $1,090,912.12 Water Utility - Depreciation 0.00 140,008.36 Water Utility - Special Redemption 0.00 3,181,234.68 Water Utility - Bond/Note 7,186,563.35 0.00 Sewerage Utility - Operating 4,887,178.83 0.00 Sewerage Utility - Replacement 0.00 1,924,392.01 Sewerage Utility- Bond/Note 0.00 9,501,719.81 Sewerage Utility - Debt Service 0.00 3,293,469.23 Storm Water Utility - Operating 4,704,069.74 511.88 Storm Water Utility - Bond/Note 3,382,679.73 0.00 Storm Water Utility - Debt Service 0.00 4,772,867.64 Parking Utility - Operating 87,224.59 26,962,552.09 0.00 23,905,115.73 TOTAL FUNDS $77,483,163.53 $45,119,174.31 CASH RECONCILIATION Associated Bank of Oshkosh $76,637,250.38 Sub -Total, Bank Balances 76,637,250.38 Less: Outstanding Checks 356,247.69 Total Cash in Banks 76,281,002.69 Plus, Cash/Deposits in Transit 1,202,160.84 TOTAL CASH $77,483,163.53 Page 2 of 2