Loading...
HomeMy WebLinkAbout03. Approval of Cash Report City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 http://www.ci.oshkosh.wi.us March 14, 2022 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 through the month of December 31, 2021. Respectfully submitted, Jennifer L. Messerschmidt, CPA Assistant Director of Finance City of Oshkosh JLM Enc Beginning Balance Period Change Ending Balance OPERATING CASH 0100 - GENERAL FUND $152,302,388.83 $22,007,312.08 $174,309,700.91 0707 - TRUST FUNDS 80501 - CEMETERY TRUST $11,024.66 $201.32 $11,225.98 80615 - OPL MEMORIALS $77,623.69 $4,382.80 $82,006.49 80706 - MUSEUM ENDOWMENT TRUST $0.00 $0.00 80801 - FISK-GALLUP TRUST $1,000.00 $1,000.00 TRUST AND INVESTMENTS 0100 - GENERAL FUND $28,547,865.95 $4,243.85 $28,552,109.80 0242 - MUSEUM COLLECTIONS $619,065.73 $5.26 $619,070.99 0302 - HEALTHY NEIGHBORHOOD INITIATVE $212,915.12 $18.08 $212,933.20 0541 - WATER UTILITY $1,140,121.57 $9.68 $1,140,131.25 0551 - SEWER UTILITY $2,092,095.10 $20,185.27 $2,112,280.37 0561 - STORM WATER UTILITY $534.98 $534.98 0605 - POLICE PENSION FUND $577,457.02 ($499,995.10)$77,461.92 0607 - FIRE PENSION FUND $137,202.87 ($137,200.59)$2.28 0707 - TRUST FUNDS 80501 - CEMETERY TRUST $1,275,493.43 $35,842.75 $1,311,336.18 80502 - HARVEY C CLUTE TRUST $67.35 $67.35 80503 - HEYMAN TRUST $36,069.34 ($4.83)$36,064.51 80504 - ROBERT J HUME TRUST $1,326.60 $0.01 $1,326.61 80505 - AMBER H MAXWELL TRUST $7,569.71 ($14.93)$7,554.78 80506 - JOHN FRANCIS ROBERTS TRUST $2,458.41 $0.02 $2,458.43 80507 - LOUISE SARAU TRUST $5,353.10 $0.04 $5,353.14 80601 - OACF OPLCIF HOXTEL $23,302.44 $879.42 $24,181.86 80605 - OACF OPLCIF ARCHER $2,586.26 $97.60 $2,683.86 80607 - OACF OPLCIF A GRUENWALD $3,862.87 $145.78 $4,008.65 80609 - OACF OPLCIF G HILTON $17,586.51 $663.71 $18,250.22 80612 - OACF OPLCIF E W KELSH $4,009.98 $151.34 $4,161.32 80613 - OACF OPLCIF G KENNY $14,047.74 $530.15 $14,577.89 80618 - OACF OPLCIF SCHUSTER BOOKS $249,387.40 $9,411.65 $258,799.05 80626 - M RASMUSSEN AMR EL PWR STOCK $32,926.07 $0.28 $32,926.35 80627 - OACF OPLCIF S ZELLMER $122,040.76 $4,605.69 $126,646.45 80628 - JOHN HICKS TRUST FUND $174,654.13 $2,075.13 $176,729.26 80629 - OACF DEVELOPMENT & SUPPORT $805,698.96 $37,010.79 $842,709.75 80630 - OACF FACILITY IMPROVEMENT $1,464,552.14 $55,270.78 $1,519,822.92 80631 - OACF PROGRAMMING SUPPORT $856,250.24 $32,314.05 $888,564.29 80632 - OACF TECHNOLOGY $438,425.45 $16,545.75 $454,971.20 80633 - OACF COLLECTION IMPROVEMENT FUND $810,766.40 $30,688.39 $841,454.79 80634 - OACF PRO SUPP FUND - MARY MALNAR $29,310.92 $1,106.17 $30,417.09 80635 - OACF TECH FUND - AV TRUST $35,379.78 $1,335.20 $36,714.98 City of Oshkosh Cash and Investment Report For Month Ended December 31, 2021 Beginning Balance Period Change Ending Balance City of Oshkosh Cash and Investment Report For Month Ended December 31, 2021 80636 - OACF TECH FUND - JOHN NICHOLS $71,827.37 $2,710.68 $74,538.05 80637 - OACF OPLCIF-G JACKSON $2,302.06 $86.88 $2,388.94 80638 - OACF OPLCIF-W STEIGER $13,949.05 $526.44 $14,475.49 80639 - LEANDER CHOATE TRUST $62,191.52 $0.52 $62,192.04 80641 - AMY DAVIES LIBRARY TRUST $7,855.30 $0.07 $7,855.37 80642 - GEORGE HILTON LIBRARY & MUSEUM TRST $4,932.67 ($17.49)$4,915.18 80643 - GEORGE HILTON SPECIAL LIBRARY TRUST $1,233.34 ($4.20)$1,229.14 80644 - FRANK & ANNA ROJAHN TRUST $11,310.17 $749.70 $12,059.87 80650 - ABBEY S HARRIS TRUST $237,531.49 ($5.34)$237,526.15 80651 - OPL-CIF-RASMUSSEN $14,867.16 $561.06 $15,428.22 80652 - OPL-CIF-ROJAHN $748.16 $28.23 $776.39 80701 - ETHEL J BEHNCKE MUSEUM TRUST $182,008.80 $1.53 $182,010.33 80702 - WILLIAM E BRAY MUSEUM TRUST $17,246.36 ($24.56)$17,221.80 80703 - FREDERICK S & MARION H DUROW TRUST $3,311,051.25 ($5,762.28)$3,305,288.97 80704 - LONA & EDWARD G KITZ TRUST $73,873.66 $10,512.69 $84,386.35 80705 - RICHARD KITZ DIRECTORS TRUST $262,648.14 $2.21 $262,650.35 80706 - MUSEUM ENDOWMENT TRUST $477,724.42 $12,943.40 $490,667.82 80801 - FISK-GALLUP TRUST $9,304.86 $0.08 $9,304.94 80802 - EMMA J GOULD TRUST $3,975.00 $0.03 $3,975.03 80803 - SOPHIE L HUHN TRUST $4,600.34 $0.04 $4,600.38 80804 - JULIA L STANHILBER LIB & PKS TRUST $750,530.70 $18,613.85 $769,144.55 80805 - JULIA L STANHILBER PARKS TRUST $1,304.58 $0.01 $1,304.59 80901 - FIRE - ELLA MAE BECK BEQUEST $0.00 $0.00 80902 - POLICE - ELLA MAE BECK BEQUEST $1.58 $1.58 INVESTMENTS-DEPRECIATION FUND 0541 - WATER UTILITY $152,209.53 $1,468.57 $153,678.10 INVESTMENTS-REVENUE BOND RESERVE 0541 - WATER UTILITY $5,092,198.17 $186.42 $5,092,384.59 0551 - SEWER UTILITY $5,694,124.47 $5,713.28 $5,699,837.75 0561 - STORM WATER UTILITY $7,558,811.04 ($9,247.50)$7,549,563.54