Loading...
HomeMy WebLinkAbout02. Cash Report ^4 City Oshkosh November 4, 2020 City Manager and Members of Common Council City of Oshkosh, Wisconsin City Manager and Council Members: Attached is the Cash and Investment Report of City operations and trust accounts for the month of September. Respectfully submitted, 14114�- lY awl"wa* Jennifer L. Messerschmidt, CPA Assistant Director of Finance City of Oshkosh JLM Enc City Hall,215 Church Avenue P.O. Box 1 130 Oshkosh,WI 54903-1130 http://www.ci.oshkosh.wi.us ,&or City of Oshkosh Cash and Investment Report Oshkosh For Month Ended September 30, 2020 Beginning Period Ending Balance Change Balance OPERATING CASH 0100-GENERAL FUND $124,991,882.95 ($6,265,741.96) $118,726,140.99 0707-TRUST FUNDS 80501 -CEMETERY TRUST $5,260.72 $300.65 $5,561.37 80615-OPL MEMORIALS $107,459.79 $139.22 $107,599.01 80801 -FISK-GALLUP TRUST $1,000.00 $1,000.00 TRUST AND INVESTMENTS 0100-GENERAL FUND $28,531,196.17 ($574.55) $28,530,621.62 0225-CABLE TV ESCROW&CAPITAL $10,502.11 $0.17 $10,502.28 0242-MUSEUM COLLECTIONS $617,786.24 $389.96 $618,176.20 0302-HEALTHY NEIGHBORHOOD INITIATVE $211,333.26 $744.57 $212,077.83 0541-WATER UTILITY $1,139,849.60 $18.69 $1,139,868.29 0551-SEWER UTILITY $2,045,198.79 $2,045,198.79 0561- STORM WATER UTILITY $534.84 $0.01 $534.85 0605-POLICE PENSION FUND $566,519.06 $3,638.62 $570,157.68 0607-FIRE PENSION FUND $135,019.27 $725.00 $135,744.27 0701-PROPERTY TAXES $305.67 ($305.67) $0.00 0707-TRUST FUNDS 80501 -CEMETERY TRUST $1,268,113.81 $1,158.41 $1,269,272.22 80502-HARVEY C CLUTE TRUST $191.28 ($0.03) $191.25 80503-HEYMAN TRUST $36,021.97 $41.84 $36,063.81 80504-ROBERT J HUME TRUST $1,326.54 ($0.21) $1,326.33 80505-AMBER H MAXWELL TRUST $7,681.94 $22.68 $7,704.62 80506-JOHN FRANCIS ROBERTS TRUST $2,458.28 ($0.40) $2,457.88 80507-LOUISE SARAU TRUST $5,352.77 ($0.86) $5,351.91 80601 -OACF OPLCIF HOXTEL $18,195.74 ($407.92) $17,787.82 80605-OACF OPLCIF ARCHER $2,028.81 ($45.48) $1,983.33 80607-OACF OPLCIF A GRUENWALD $3,030.22 ($67.93) $2,962.29 80609-OACF OPLCIF G HILTON $14,877.42 ($333.53) $14,543.89 80612-OACF OPLCIF E W KELSH $3,158.55 ($70.80) $3,087.75 80613-OACF OPLCIF G KENNY $11,162.22 ($250.24) $10,911.98 80618-OACF OPLCIF SCHUSTER BOOKS $200,129.07 ($4,486.61) $195,642.46 80626-M RASMUSSEN AMR EL PWR STOCK $32,924.06 ($5.30) $32,918.76 80627-OACF OPLCIF S ZELLMER $97,072.59 ($2,176.23) $94,896.36 80628-JOHN HICKS TRUST FUND $185,797.23 $87.03 $185,884.26 80629-OACF DEVELOPMENT&SUPPORT $516,548.01 ($11,580.29) $504,967.72 80630-OACF FACILITY IMPROVEMENT $1,180,851.53 ($26,473.03) $1,154,378.50 80631 -OACF PROGRAMMING SUPPORT $683,981.92 ($15,333.91) $668,648.01 80632-OACF TECHNOLOGY $343,925.42 ($7,710.33) $336,215.09 80633-OACF COLLECTION IMPROVEMENT FUND $661,466.24 ($14,829.14) $646,637.10 80634-OACF PRO SUPP FUND-MARY MALNAR $25,753.21 ($577.35) $25,175.86 City of Oshkosh Cash and Investment Report For Month Ended September 30, 2020 Beginning Period Ending Balance Change Balance 80635-OACF TECH FUND-AV TRUST $27,753.88 ($622.20) $27,131.68 80636-OACF TECH FUND-JOHN NICHOLS $62,928.42 ($1,410.76) $61,517.66 80637-OACF OPLCIF-G JACKSON $1,805.86 ($40.48) $1,765.38 80638-OACF OPLCIF-W STEIGER $10,695.69 ($239.78) $10,455.91 80639-LEANDER CHOATE TRUST $62,187.70 ($10.00) $62,177.70 80641 -AMY DAVIES LIBRARY TRUST $7,854.81 ($1.26) $7,853.55 80642-GEORGE HILTON LIBRARY&MUSEUM TRST $4,865.45 $154.76 $5,020.21 80643-GEORGE HILTON SPECIAL LIBRARY TRUST $1,117.62 $35.45 $1,153.07 80645-MARGUERITE E ZELLMER TRUST $27,346.48 $430.85 $27,777.33 80650-ABBEY S HARRIS TRUST $237,455.53 $26.15 $237,481.68 80651 -OPL-CIF-RASMUSSEN $12,003.16 ($269.10) $11,734.06 80652-OPL-CIF-ROJAHN $586.90 ($13.16) $573.74 80701 -ETHEL J BEHNCKE MUSEUM TRUST $238,422.51 ($38.35) $238,384.16 80702-WILLIAM E BRAY MUSEUM TRUST $21,053.07 $92.65 $21,145.72 80703-FREDERICK S&MARION H DUROW TRUST $3,403,232.73 ($274.37) $3,402,958.36 80704-LONA& EDWARD G KITZ TRUST $66,647.17 ($3.65) $66,643.52 80705-RICHARD KITZ DIRECTORS TRUST $264,607.30 ($42.56) $264,564.74 80707-R KITZ BEQUEST $227,236.95 $6.49 $227,243.44 80801 -FISK-GALLUP TRUST $21,858.66 ($3.52) $21,855.14 80802-EMMA J GOULD TRUST $3,974.73 ($0.64) $3,974.09 80803-SOPHIE L HUHN TRUST $4,600.04 ($0.74) $4,599.30 80804-JULIA L STANHILBER LIB &PKS TRUST $800,899.33 ($106.13) $800,793.20 80805-JULIA L STANHILBER PARKS TRUST $1,304.52 ($0.21) $1,304.31 80901 -FIRE-ELLA MAE BECK BEQUEST $182.88 ($0.04) $182.84 80902-POLICE-ELLA MAE BECK BEQUEST $51,882.37 ($8.34) $51,874.03 INVESTMENTS-DEPRECIATION FUND 0541-WATER UTILITY $148,797.61 $148,797.61 INVESTMENTS-REVENUE BOND RESERVE 0541-WATER UTILITY $5,104,398.16 ($1,246.58) $5,103,151.58 0551-SEWER UTILITY $5,717,680.13 $10,843.73 $5,728,523.86 0561-STORM WATER UTILITY $7,578,344.69 $8,649.09 $7,586,993.78