HomeMy WebLinkAbout06. 21-349JULY 13, 2021 21-349 RESOLUTION
(CARRIED __7-0_____ LOST _______ LAID OVER _______ WITHDRAWN _______)
PURPOSE: APPROVE CASH & INVESTMENT REPORT THROUGH MAY 2021
INITIATED BY: FINANCE DEPARTMENT
BE IT RESOLVED by the Common Council of the City of Oshkosh that the
Attached Cash and Investment Report through May 2021 is hereby approved.
Finance Department
City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 920.236.5005 http://www.ci.oshkosh.wi.us
July 6, 2021
City Manager and
Members of Common Council
City of Oshkosh, Wisconsin
City Manager and Council Members,
Attached is the Cash and Investment Report for City operations and trust accounts
through the month of May 2021.
Respectfully submitted,
Jennifer L. Messerschmidt, CPA
Assistant Director of Finance
JLM
Enc
Beginning
Balance
Period
Change
Ending
Balance
OPERATING CASH
0100 - GENERAL FUND $117,091,104.60 $416,531.74 $117,507,636.34
0707 - TRUST FUNDS
80501 - CEMETERY TRUST $7,713.54 $300.00 $8,013.54
80615 - OPL MEMORIALS $81,809.87 $81,809.87
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,555,858.66 $28,555,858.66
0242 - MUSEUM COLLECTIONS $618,584.08 $618,584.08
0302 - HEALTHY NEIGHBORHOOD INITIATVE $212,378.09 $212,378.09
0541 - WATER UTILITY $1,139,925.41 $1,139,925.41
0551 - SEWER UTILITY $2,065,384.06 $2,065,384.06
0561 - STORM WATER UTILITY $534.88 $534.88
0605 - POLICE PENSION FUND $573,780.40 $573,780.40
0607 - FIRE PENSION FUND $136,466.85 $136,466.85
0707 - TRUST FUNDS
80501 - CEMETERY TRUST $1,268,888.02 $1,268,888.02
80502 - HARVEY C CLUTE TRUST $134.30 $134.30
80503 - HEYMAN TRUST $36,081.62 $36,081.62
80504 - ROBERT J HUME TRUST $1,326.39 $1,326.39
80505 - AMBER H MAXWELL TRUST $7,643.99 $7,643.99
80506 - JOHN FRANCIS ROBERTS TRUST $2,458.00 $2,458.00
80507 - LOUISE SARAU TRUST $5,352.18 $5,352.18
80601 - OACF OPLCIF HOXTEL $20,034.96 $20,034.96
80605 - OACF OPLCIF ARCHER $2,266.47 $2,266.47
80607 - OACF OPLCIF A GRUENWALD $3,385.19 $3,385.19
80609 - OACF OPLCIF G HILTON $15,858.64 $15,858.64
80612 - OACF OPLCIF E W KELSH $3,528.55 $3,528.55
80613 - OACF OPLCIF G KENNY $12,370.79 $12,370.79
80618 - OACF OPLCIF SCHUSTER BOOKS $220,026.09 $220,026.09
80626 - M RASMUSSEN AMR EL PWR STOCK $32,920.43 $32,920.43
80627 - OACF OPLCIF S ZELLMER $107,555.60 $107,555.60
80628 - JOHN HICKS TRUST FUND $174,393.58 $174,393.58
80629 - OACF DEVELOPMENT & SUPPORT $669,186.39 $669,186.39
80630 - OACF FACILITY IMPROVEMENT $1,312,647.82 $1,312,647.82
80631 - OACF PROGRAMMING SUPPORT $750,176.82 $750,176.82
80632 - OACF TECHNOLOGY $384,211.99 $384,211.99
80633 - OACF COLLECTION IMPROVEMENT FUND $729,400.44 $729,400.44
80634 - OACF PRO SUPP FUND - MARY MALNAR $26,116.08 $26,116.08
City of Oshkosh
Cash and Investment Report
For Month Ended May 31, 2021
Beginning
Balance
Period
Change
Ending
Balance
City of Oshkosh
Cash and Investment Report
For Month Ended May 31, 2021
80635 - OACF TECH FUND - AV TRUST $31,004.92 $31,004.92
80636 - OACF TECH FUND - JOHN NICHOLS $70,299.69 $70,299.69
80637 - OACF OPLCIF-G JACKSON $2,017.41 $2,017.41
80638 - OACF OPLCIF-W STEIGER $11,839.40 $11,839.40
80639 - LEANDER CHOATE TRUST $62,180.87 $62,180.87
80641 - AMY DAVIES LIBRARY TRUST $7,853.95 $7,853.95
80642 - GEORGE HILTON LIBRARY & MUSEUM TRST $4,991.35 $4,991.35
80643 - GEORGE HILTON SPECIAL LIBRARY TRUST $1,247.31 $1,247.31
80644 - FRANK & ANNA ROJAHN TRUST $10,236.96 $10,236.96
80650 - ABBEY S HARRIS TRUST $237,515.59 $237,515.59
80651 - OPL-CIF-RASMUSSEN $13,089.13 $13,089.13
80652 - OPL-CIF-ROJAHN $655.65 $655.65
80701 - ETHEL J BEHNCKE MUSEUM TRUST $182,142.45 $182,142.45
80702 - WILLIAM E BRAY MUSEUM TRUST $17,270.51 $17,270.51
80703 - FREDERICK S & MARION H DUROW TRUST $3,325,416.66 $3,325,416.66
80704 - LONA & EDWARD G KITZ TRUST $69,684.52 $69,684.52
80705 - RICHARD KITZ DIRECTORS TRUST $262,603.13 $262,603.13
80706 - MUSEUM ENDOWMENT TRUST $436,755.51 $436,755.51
80801 - FISK-GALLUP TRUST $31,471.52 $31,471.52
80802 - EMMA J GOULD TRUST $3,974.30 $3,974.30
80803 - SOPHIE L HUHN TRUST $4,599.54 $4,599.54
80804 - JULIA L STANHILBER LIB & PKS TRUST $770,423.41 $770,423.41
80805 - JULIA L STANHILBER PARKS TRUST $1,304.37 $1,304.37
80901 - FIRE - ELLA MAE BECK BEQUEST $182.84 $182.84
80902 - POLICE - ELLA MAE BECK BEQUEST $51,876.73 $51,876.73
INVESTMENTS-DEPRECIATION FUND
0541 - WATER UTILITY $150,266.18 $150,266.18
INVESTMENTS-REVENUE BOND RESERVE
0541 - WATER UTILITY $5,110,173.16 $5,110,173.16
0551 - SEWER UTILITY $5,725,051.44 $5,725,051.44
0561 - STORM WATER UTILITY $7,594,924.76 $7,594,924.76