HomeMy WebLinkAbout22-185 State of Illinois )
County of Kane)
City of Elgin )
CERTIFICATE OF CITY CLERK
I, Kimberly Dewis, DO HEREBY CERTIFY that I am the duly qualified City Clerk of
the City of Elgin, in the Counties of Kane and Cook in the State of Illinois, and that as such City
Clerk I am the keeper and custodian of the files and records of said City of Elgin and the seal
thereof.
I DO FURTHER CERTIFY that the attached is a full, true, and correct copy of
RESOLUTION NO. 22-185
RESOLUTION
REGARDING THE ILLINOIS DEPARTMENT OF TRANSPORTATION
DOCUMENTATION REVIEW NO. 72 REGARDING THE RECEIPT OF MOTOR FUEL
TAX FUNDS BY THE CITY OF ELGIN FOR THE PERIOD OF JANUARY 1, 2011
THROUGH DECEMBER 31,2020
adopted by the Elgin City Council at its legally convened meeting held on October 26,2022.
In Witness Whereof, I have hereunto set my hand and affixed the corporate seal of the
City of Elgin at the said City in the County and State aforesaid this October 27, 2022.
Kimberly D s, y Clerk
(Sly'"
) .
Resolution No. 22-185
RESOLUTION
REGARDING THE ILLINOIS DEPARTMENT OF TRANSPORTATION
DOCUMENTATION REVIEW NO. 72 REGARDING THE RECEIPT OF MOTOR FUEL
TAX FUNDS BY THE CITY OF ELGIN FOR THE PERIOD OF JANUARY 1, 2011
THROUGH DECEMBER 31, 2020
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN, ILLINOIS,
that the Illinois Department of Transportation(IDOT)Documentation Review No. 72 covering the
receipt and distribution of Motor Fuel Tax (MFT) Funds by the City of Elgin for the period
beginning January 1, 2011 and ending December 31, 2020, a copy of which is attached hereto,
having been presented to the Mayor and City Council,be and is hereby approved.
BE IT FURTHER RESOLVED, that the City Clerk of the City of Elgin be and is hereby
directed that the attached IDOT Documentation Review No. 72 be filed and maintained as
permanent record of the City of Elgin.
_s/David J. Kaptain
David J. Kaptain, Mayor
Presented: October 26, 2022
Adopted: October 26, 2022
Omnibus Vote: Yeas: 9 Nays: 0
Attest:
s/Kimberly Dewis
Kimberly Dewis, City Clerk
Illinois Department of Transportation
Office of Highways Project Implementation / Region 1 /District 1
201 West Center Court/Schaumburg,Illinois 60196.1096
LOCAL ROADS AND STREETS
Motor Fuel Tax— Documentation Review
City of Elgin
Kane County
September 12, 2022
Ms. Kimberly Dewis
City Clerk
City of Elgin
150 Dexter Court
Elgin, IL 60120
Dear Ms. Dewis:
Enclosed is a copy of Documentation Review No. 72 covering the receipt
and disbursement of Motor Fuel Tax (MFT) Funds by the City for the period
beginning January 1, 2011 and ending December 31, 2020.
Please note any deficiencies (balances in brackets) indicated on the
Summary of Motor Fuel Tax Fund Transactions by Section and Categories
(BLR 15106). These deficit balances should be addressed by the City to
resolve the Unauthorized MFT Expenditures.
This report should be presented to the Mayor and City Council at the first
regular meeting after receipt of this letter and filed as a permanent record.
If you have any questions or need additional information, please contact
Marilin D. Solomon, Field Engineer, at (847) 705-4407 or via email at
Marilin.Solomon@illinois.gov.
Very truly yours,
Jose Rios, P.E.
Region One Engineer
By:
Charles F. iddle, P.E.
Bureau Chief of Local Roads and Streets
Enclosure
imnois Department
of Transportation Documentation Reviewer's Certificate
CITY OF ELGIN Documentation Review No. 72
We hereby certify that we have reviewed the books and records in so far as they pertain to the receipt and disbursement
of the Motor Fuel Tax Fund of the City of ELGIN for the period beginning Jan. 1, 2011 and ending Dec. 31, 2020,
and that entries for receipts in these books and records are true and correct and are in agreement with the records maintained by the
Department of Transportation and that entries for disbursements are supported by cancelled warrants or checks with exceptions noted
in the documentation review findings.
i
Reviewer
REVIEWED AND APPROVED BY
Date: ( ( CW- 14, rez
2 �Z 2
District Local Roads and Streets Engineer
Page 1 of 1
9/12/2022 9:53 AM
(9) IWKX IS PJ7t
of Transportaft, Fund Balance and Bank Reconciliation
CITY OF ELGIN Documentation Review Report No. 72
Documentation Review Period Jan. 1, 2011 - Dec. 31, 2020
Date: September 12, 2022
Fund Balance Unobli ated Obligated Total Outstanding Warrants
Balance Previous Documentation Review 753,565,54 1,462,686.06 709,120.52
Allotments 34,634,267.78 0.00 34,634,267.78
Total MFT Funds 33,880,702.24 1,462,686.06 35,343,388.30
Approved Authorizations 22,638,653.08 22,638,653.08 0.00
Other Receipts 902,218.46 902,218.46
Total 11,242,049.16 25,003 557.60 36,245,606.76
Disbursements 26,114,259.27 26,114,259.27
Surplus (Credits) 6,423,761.42 6,423,761.42 0.00
Unex ended Balance 17,665,810.58 7,534,463.09 10,131,347.49
Bank Reconciliation
Balance in IL Funds per Bank Certificate Dec. 31, 2020 6,192,755.97
Deduct Outstanding Warrants
Add Outstanding investments - PMA Accounts 3,661,009.99
Additions - Cash / 5th 3rd bank 277,581.53
Subtraction's
Net Balance in Account Dec. 31, 2020 10,131,347.49
J
Certified Correct u C
Reviewer
Page 1 of
9/12/2022 11 22 AM
( WmUnent Summary of Motor Fuel Tax Fund Transactions
p¢'T nip pn ay Sections and Categories
CITY OF ELGIN Documentation Review Period: January 1,2011 -December 31,2020 Documentation Review Report No.72
Balance Prev. Total Amount Other Total Funds Total Surplus to Unexpended Prev.Accumulated Total Accumulated
Section Review Authorized Adjustments Receipts Available Disbursements Unobligated Balance Disbursements Disbursements
Balance(Credits)
CONSTRUCTION PROJECTS
83-00128-00-WR
CONSTRUCTION 0.00 0.00 0.00 0.00 0,00
ENGINEERING 5,394.74 5,394.74 5,394.74 0.00 39,304.21 39,304.21
91-00145-00-PW
CONSTRUCTION 0.00 0.00 0.00 0.00 0.00
ENGINEERING 27,309.50 27,309-501 1 27,309.501 0.00 88 490.50 88,490.50
96-00159-00-CH
CONSTRUCTION 1 0.00 0.00 298,488.29 298,488.29 0.00 298,488.29
ENGINEERING 0.00 0.00 457,000.00 457,000.00 0,00 457,000.00
ROW 0.00 0.00 252.469.78 252,469.78 0.00 252,469.78
03-00172-00-BR
CONSTRUCTION 73,582.12 73.582.12 0.00 0.00 28,148,12 28,148.12
ENGINEER NG 0.00 0.00 0.00 0.00 0.00
10-00181-MTL
CONSTRUCTION 0.00 0.00 22,623.50 22.623.50 0.00 22,623.50
ENGINEERING 2,564.00 116.69 (2,447.31)1
2,447.31 2,447.31 2,564.00 2,447.31
15-00186-00-RS
CONSTRUCTION 0.00 0.00 164,919.94 164,919.94 0.00 164 919.94
ENGINEERING 0.00 0,00 0001 0 00 0.00
CONSTRUCTION 0.00 000
ENGINEERING 0.00 0.00
TOTALS 43,441.88 73,582,121 116.69 1 0.001 30,256.931 1A95,50151 1 32.704-24 1,197,948.82 158,506,83 1 1.353.891. 55
Page 1 015
9/122022 9.57 AM
&,Mnc=)md1I�f1t Summary of Motor Fuel Tax Fund Transactions
Ofl By Sections and Categories
CITY OF ELGIN Documentation Review Period: January 1,2011 -December 31,2020 Documentation Review Report No.72
Balance Prev. Total Amount Other Total Funds Total Surplus to Unexpended Prev.Accumulated Total Accumulated
Section Review Authorized Adjustments Receipts Available Disbursements Unobligated Balance Disbursements Disbursements
Balance(Credits)
MAINTENANCE PROGRAMS
98-00000-00-GM
MAINTENANCE 0.00 105,467.78 105,467.78 105,467.78 0,00 2,100,199.81 1,994,732.03
MAINT.ENG 0.00 14.708.87 14,708.87 14 708.87 0.00 28,854.25 14,145.38
99-00000-00-GM
MAINTENANCE 0.001 64,739.83 (64,739.83)1O.DO 0.001 1936,310.17 2,001,050.00
MAINT.ENGH 0.001 36,436.55 36,436.55 0.D0 I 0.00l 19,718.451 56.155.00
03-00000-00-GM
MAINTENANCE 0.00 0,001 1 0.001 1,727,477.03 1,727,477.03
MAINT.ENG11 0.001 1 21,578.821 1 21,578.821 1 21.578.82 1 0.001 147 317.22 1 125,738.40
05-00000-00-GM
MAINTENANCE 852.368.17 852,368.17 852,368.17 0.00 2,684 891.83 2.684.891.83
MAINT.ENG 14.828.07 14,828.07 0.00 OW 206,828 07 206.828 07
06-00000-00-GM
MAINTENANCEI 747,044.26 1 747,D44.26 f 1 747,044.261 O.00T 3,280,161.74 3,280,161.74
MAINT.ENG 7,965.48 7,965.48 0.00 0.001 205,385.48 205,365.48
07-00000-00-GM
MAINTENANCE 175,457.62 175.457.62 0.00 0.00 3,425,835.62 3,425,835.62
MAINT.ENG 931.52 931.52 0.00 0.00 155,513.12 155,513.12
08-00000-00-GM
MAINTENANCE 107,217.29 1 107.217.29 1 107217291 0.00 1 2,965,880.71 2.965.880.71
MAINT.ENG 77,564.19 1 77,564.19 77,564.191 0.001 29,225.81 29,225.81
09-MOO-00-GM
MAINTENANCE 208,743.24 208,743.24 208.743.24 0.0D 2,740,729.76 2,740,729.76
MAINT.ENG 38,456.00 38,456.00 38,456,00 0.00 7,524.00 7,524.00
TOTALS 1,832,210.46 300,359.07 40,579.09 0.00 2,173,148.62 1 0.00 2,1T3,148.62 0.00 21,661,833.07 21,621.253-98
Pape 2 of 5
9/12/2022 9:57 AM
Summary of Motor Fuel Tax Fund Transactions
Tprtpn By Sections and Categories
CITY OF ELGIN Documentation Review Period: January 1,2011 -December 31,2020 Documentation Review Report No.72
Balance Prev. Total Amount Other Total Funds Total Surplus to Unexpended Prev.Accumulated Total Accumulated
Section Review Authorized Adjustments Receipts Available Disbursements Unobigated Balance Disbursements Disbursements
Balance(Credits)
MAINTENANCE CONT.
10-00000-00-GM
MAINTENANCE 635,689.48 635,689.48 635.689.48 0.00 1,163,290.52 1,163,290.52
MAINT.ENG 6.294.01 6,294.01 6 294.01 0.00 100,810.03 100,810.03
11-00000-00-GM
MAINTENANCE 0.00 3,155,717.00 3,155,717.00 3,155.717.00 0.00 0.00 3,155,717.00
MAINT.ENG 0.00 0-001 0.00 0.00 0.00
12-00000-00-GM
MAINTENANCE 0.00 3,045.000.00 3,045,000.00 3,045,000.00 0.00 0.00 3,045,000.00
MAINT.ENG 0.00 0.00 0.00 0.00 0.00
0.00 0.00 0.00
13-00000-00-GM
MAINTENANCE 0.00 2.600,000.00 2,600,000.00 2,600,000.00 0.00 0.00 2,600,000.00
MAINT.ENG 0.00 0.00 0.00 0.00 0.00
14-00000-00-GM
MAINTENANCE 0.00 2,900,000.00 2,900,000.00 1 2,900,000,00 0.0ol 0.00 2,900,000.00
MAINT.ENG 0.00 0.001 0.001 0.00 0.00
0.001 0.001 0.00
15-00000-00-GM
MAINTENANCE 0.00 2,905.000.00 2,905,000,00 2,904,987.00 13.00 0.00 0.00 2.904,987.00
MAINT.EN 0.00 0.00 0.00 0.00 0.00
0.00 1 1 0.00 0.00
164HMM-00-GM
MAINTENANCE 0.00 3,000,000.00 3,000,000.00 1,913,170.00 1,086,830.00 0.00 0.00 1913,170.00
MAINT.ENG 0.00 0.00 0.00 0.00 0.00
TOTALS 641,983.49 17.605,717.00 7.0-01 0.00 18,247,700.49 16,518,874.00 1,728,826.49 0001 1,264,100.55 17,782,974.55
Pape 3 of 5
9112fZO22 9:57 AM
Mnois Dl3 1t Summary of Motor Fuel Tax Fund Transactions
Tf801t�d011 By Sections and Categories
CITY OF ELGIN Documentation Review Period: January 1,2011 -December 31,2020 Documentation Review Report No.72
Balance Prev. Total Amount Other Total Funds Total Surplus to Unexpended Prev.Accumulated Total Accumulated
Section Review Authorized Adjustments Receipts Available Disbursements Unobligated Balance Disbursements Disbursements
Balance(Credits)
17-00000-00-GM
MAINTENANCE 0.00 3,000,000.00 3,000,000.00 1,749,207.80 1,250,792.20 0.00 0.00 1,749,207.80
MAINT.ENG 0.00 0.00 0.00 0.00 0.00
18-00000-00-GM
MAINTENANCE 0.00 1,656,819.79 1,656,819.79 1,656,819,79 0.00 0.00 1,656,819.79
MAINT.ENG 0.00 0.00 0.00 0.00 0 00
19-00000-00-GM
MAINTENANCE 0.00 1 0.001 1,217,289.41 1,217,289.41 1,217,289.41
MAINT.ENG 0.00 0.00 0.00 0.00
20-00000-00-GM
MAINTENANCE 0.00 0.00 3,562,536 50 3,562,536 50 3.562.536.50
MAINT.ENG 0.00 0.00 156.400.00 156,400 00 156,400.00
TOTALS 0.00 1 4,656,819.791 0.001 0.001 4,656,819.79 8,342,253.50 1,250,792.20 4,936,225.91 0.001 8.342,253 50
Pape 4 or 5
W12=2 9:57 Au
IfrXAS Summary of Motor Fuel Tax Fund Transactions
of Tf O lOr1 By Sections and Categories
CITY OF ELGIN Documentation Review Period: January 1,2011 -December 31,2020 Documentation Review Report No.72
Surplus to
Balance Prev. Total Amount Other Total Funds Total UnobBalance(Cr Unexpended Prev.Accumulated Total Accumulated
Section Review Authorized Adjustments Receipts Available Disbursements lance(Creeledits) Balance Disbursements Disbursements
EARNEDINTEREST
00-00000-00-AC 65,204.24 65,204.24 130,408.48 130,408.48 0.00 65,204.24
0 1-00000-00-AC 52.624.57 52,624.57 105,249.14 105,249.14 0.00 52,624.57
02-00000-00-AC 30,673.23 30,673.23 61,346.46 61,346.46 0.00 30,673.23
03-00000-00-AC 17,792.69 17,792.69 35,585.38 35.585.38 0.00 17,792.69
04-00000-00-AC 35,164,41 35,164.41 70.328.82 70,328.82 0.00 35.164.41
05-00000-00-AC 113.583.78 113,583.78 227,167.56 227,167.56 0.00 113.583.78
06-00000-00-AC 113,485.35 113.485.35 226,970.70 226,970.70 0.00 113,485.35
07-00000-00-AC 121,479.70 121,479.70 242,959.40 242.959.40 0,00 121,479.70
08-00000-00-AC 54,056.85 Sk056.85 108,113.70 108.113.70 0.00 54 056,85
09-00000-00-AC 12,467.32 12,467.32 24,934.64 24,934.64 0.00 12.467.32
10-00000-00-AC 2,214.13 2,175.10 4,389.23 4,389,23 0.00 0.00
19-00000-00-AC 0.00 77,121.78 77,121.78 77,121.78 77,121.78
20-00000-00-AC 0.00 89,380.34 89,380.34 89,380.34 89,380.14
0.001 0.001 0.00
OTHER
10-00000-01-AC 249,000.00 249,000.00 0.00 0.00 249,000.00
10-00000-0 1-AA 13,760.54 13,760.54 0.00 0.00 13,760.54
10-00000-02-AA 2,034,227.20 210,649.36 2,244,876.56 2,244.876.56 210.649.36
10-00000-02-AC 212,175.46 212,175.46 0.00 0.00 212,175.46
02-00000-05-AC 0.00 836.36 836.36 836.36 0.00 836,36
19-OOOOD-01-AC 0.00 735,716.34 735.716.34 57.630.26 678,086.08 57.630.26
0.00 0.00 0.DO
TOTALS 968,066.01 2,175.10 40,695.78 902,218.46 104,368.23 57,630.26 1,238,289.87 1,400,288.36 0.00 68.176 08
Page 5 of 5
9/122022 9:57 AM
CHECK PROJECT
DATE NO SECTION INVOICE# PAYEE/COMMENTS DEBITS TOTAL
96-00159-00-CH Construction 298,488.29 298,488.29
96-00159-00-CH ROW 457,000.00 467,000.00
96-00159-00-CH Engineering 252,469.78 252,469.78
4/l/2015 09-00175-00-BT 108038 IDOT-City Share 75,792.39
12/l/2017 09-00175-00-BT 121419 IDOT- Final City Share 63,753.09 139 545.48
09-00175-00-BT Trans stems/ 36,173.55 36,173.55
10-00181-00-TL IDOT 22,623.50 22,623.50
10-00181-00-TL 2,447.31 2,447.31
15-00186-00-RS IDOT 164,919.94 164,919.94
17-00000-00-GM Per Expenditure Statement& Pay 1,749,207.80 1,749 207.80
18-00000-00-GM Per Expenditure Statement& Pay 1,656,819.79 1,666,819.79
12/16/2016 19-00000-00-GM Compass Minerals 54,865.13
12/3/2019 19-00000-00-GM Compass Minerals 195,501.02
12/16/2019 19-00000-00-GM Compass Minerals 42,024.25
12/16/2019 19-00000-00-GM Compass Minerals 100,554.61
12/16/2019 19-00000-00-GM Compass Minerals 2,136.60
12/30/2019 19-00000-00-GM Compass Minerals 95,348.17
12/30/2019 19-00000-00-GM Compass Minerals 12,601.76
12/30/2019 19-00000-00-GM Compass Minerals 29,393.45
11/5/2019 19-00000-00-GM Precision Pavement 108,927.33
1/2/2020 19-00000-00-GM Precision Pavement 153,133.08
12/31/2019 19-00000-00-GM ComEd & Direct Energy 422,804.01 1,217,289.41
11/2/2020 20-00000-00-GM Compass Mineral 30,245.00
11/2/2020 20-00000-00-GM Compass Mineral 18,227.77
11/2/2020 20-00000-00-GM Compass Mineral 38,581.69
11/2/2020 20-00000-00-GM Compass Mineral 10,345.12
4/20/2020 20-00000-00-GM Compass Mineral 96,904.87
4/20/2020 20-00000-00-GM Compass Mineral 2,228.57
4/20/2020 20-00000-00-GM Compass Mineral 91,393.48
4/20/2020 20-00000-00-GM Compass Mineral 126,383.52
3/12/2020 20-00000-00-GM Compass Mineral 96,144.92
2/11/2020 20-00000-00-GM Compass Mineral 56,447.01
2/11/2020 20-00000-00-GM Compass Mineral 40,252.63
Various 20-00000-00-GM ComEd & MC Squared Energy 664,922.42
12/31/2020 20-00000-00-GM Arrow Road Const 189,930.75
12/22/2020 20-00000-00-GM Arrow Road Const 564,388.74
10/20/2020 20-00000-00-GM Arrow Road Const 679,511.55
9/21/2020 20-00000-00-GM Arrow Road Const 465,476.49
CHECK PROJECT
DATE NO SECTION INVOICE# PAYEE/COMMENTS DEBITS TOTAL
10/6/2020 20-00000-00-GM Maintenance Coating 151,681.37
8/26/2020 20-00000-00-GM Maintenance Coating 52,748.23
11/19/2020 20-00000-00-GM Maintenance Coating 24,356.32
1/12/2021 20-00000-00-GM Allied Asphalt Paving 3,225.30
1/12/2021 20-00000-00-GM Allied Asphalt Paving 581.16
12/15/2020 20-00000-00-GM Allied Asphalt Paving 2,288.50
12/9/2020 20-00000-00-GM Allied Asphalt Paving 28.88
12/2/2020 20-00000-00-GM Allied Asphalt Paving 242.20
12/2/2020 20-00000-00-GM Allied Asphalt Paving 404.79
11/18/2020 20-00000-00-GM Allied Asphalt Paving 808.87
11/18/2020 20-00000-00-GM Allied Asphalt Paving 1,025.34
11/18/2020 20-00000-00-GM Allied Asphalt Paving 735.53
11/18/2020 20-00000-00-GM Allied Asphalt Paving 1,613.30
11/2/2020 20-00000-00-GM Allied Asphalt Paving 1,322.67
11/2/2020 20-00000-00-GM Allied Asphalt Paving 7,317.49
11/2/2020 20-00000-00-GM Allied Asphalt Paving 470.23
11/2/2020 20-00000-00-GM Allied Asphalt Paving 1,572.39
11/2/2020 20-00000-00-GM Allied Asphalt Paving 1,271.40
10/6/2020 20-00000-00-GM Allied Asphalt Paving 7,912.66
10/6/2020 20-00000-00-GM Allied Asphalt Paving 242.03
10/6/2020 20-00000-00-GM Allied Asphalt Paving 12,132.30
10/6/2020 20-00000-00-GM Allied Asphalt Paving 429.46
9120/2020 20-00000-00-GM Allied Asphalt Paving 6,384.38
9/21/2020 20-00000-00-GM Allied Asphalt Paving 2,317,36
9/21/2020 20-00000-00-GM Allied Asphalt Paving 9,929.35
9/8/2020 20-00000-00-GM Allied Asphalt Paving 3,193.06
9/8/2020 20-00000-00-GM Allied Asphalt Paving 2,918.50
9/8/2020 20-00000-00-GM Allied Asphalt Paving 12,268.91
9/8/2020 20-00000-00-GM Allied Asphalt Paving 3,369.99
8/25/2020 20-00000-00-GM Allied Asphalt Paving 5,301.84
8/25/2020 20-00000-00-GM Allied Asphalt Paving 1,806.01
8/11/2020 20-00000-00-GM Allied Asphalt Paving 3,071.82
8/11/2020 20-00000-00-GM Allied Asphalt Paving 530.25
8/11/2020 20-00000-00-GM Allied Asphalt Paving 4,014.71
7/28/2020 20-00000-00-GM Allied Asphalt Paving 5,442.18
7/14/2020 20-00000-00-GM Allied Asphalt Paving 4,077.17
7/14/2020 20-00000-00-GM Allied Asphalt Paving 633.15
7/14/2020 20-00000-00-GM Allied Asphalt Paving 5,098.15
7/14/2020 20-00000-00-GM Allied Asphalt Paving 1,693.90
6/30/2020 20-00000-00-GM Allied Asphalt Paving 1,518,31
6/30/2020 20-00000-00-GM Allied Asphalt Paving 2,104.74
6130/2015 20-00000-00-GM Allied Asphalt Paving 3,241.90
6/15/2020 20-00000-00-GM Allied Asphalt Paving 485.63
6/15/2020 20-00000-00-GM Allied Asphalt Paving 3,549.03
6/15/2020 20-00000-00-GM Allied Asphalt Paving 3,394.14
6/15/2020 20-00000-00-GM Allied Asphalt Paving 1,300.00
6/20/2020 20-00000-00-GM Allied Asphalt Paving 2,539.98
5/26/2020 20-00000-00-GM Allied As halt Paving 460.44
506/2020 20-00000-00-GM Allied Asphalt Paving 433.13
5/18/2020 20-00000-00-GM Allied Asphalt Paving 162.23
5/4/2020 20-00000-00-GM Allied Asphalt Paving 890.11
5/4/2020 20-00000-00-GM Allied Asphalt Paving 171.16
5/4/2020 20-00000-00-GM Allied Asphalt Paving 934.52
11/2/2020 20-00000-00-GM 1AC Ready Mix 874.00
10/20/2020 20-00000-00-GM I JAC Ready Mix 870.00
CHECK PROJECT
DATE I NO 11 SECTION INVOICE# PAYEE/COMMENTS DEBITS TOTAL
10/5/2020 20-00000-00-GM AC Ready Mix 885.00
8/25/2020 20-00000-00-GM AC Ready Mix 704.50
8/25/2020 20-00000-00-GM AC Ready Mix 997.50
8/11/2020 20-00000-00-GM AC Ready Mix 1,314.00
8/11/2020 20-00000-00-GM AC Ready Mix 885.00
8/11/2020 20-00000-00-GM AC Ready Mix 1,014.00
8/11/2020 20-00000-00-GM AC Ready Mix 910.00
7/28/2020 20-00000-00-GM AC Ready Mix 910.00
7/28/2020 20-00000-00-GM AC Ready Mix 1,168.00
7/14/2020 20-00000-00-GM AC Ready Mix 1,036.00
7/14/2020 20-00000-00-GM AC Ready Mix 956.25
7/14/2020 20-00000-00-GM AC Ready Mix 908.50
6/30/2020 20-00000-00-GM AC Ready Mix 956.25
6/30/2020 20-00000-00-GM AC Ready Mix 973.00
6/30/2020 20-00000-00-GM AC Ready Mix 1,287.00
6/30/2020 20-00000-00-GM AC Ready Mix 1,144.00
6115/2020 20-00000-00-GM AC Ready Mix 973.00
6/15/2020 20-00000-00-GM AC Ready Mix 1,007.00
6/15/2020 20-00000-00-GM AC Ready Mix 850.00
6/15/2020 20-00000-00-GM AC Ready Mix 973.00
6/2/2020 20-00000-00-GM AC Ready Mix 1,072.00
6/2/2020 20-00000-00-GM AC Ready Mix 770.00
6/2/2020 20-00000-00-GM AC Ready Mix 1,005.00
5/18/2020 20-00000-00-GM AC Ready Mix 1,062.50 3,662,636.50
2/9/2021 20-00000-00-GM HR Green 22,080.00
10/1/2020 20-00000-00-GM HR Green 9,200.00
9/22/2020 20-00000-00-GM HR Green 62,560.00
8/26/2020 20-00000-00-GM HR Green 16,560.00
6/16/2020 20-00000-00-GM HR Green 6,900.00
5/5/2020 20-00000-00-GM HR Green 39,100.00 156,400.00
TOTALS: 9,715,921.35 9,715,921.35ji
MFT Agency Transaction List
Agency Name: Elgin County: Kane Agency Type: Municipality District: 1
Beginning Unobligated Balance as of 12/31/2010 ($753,565.54) / Average MFT Allotment $222,044.22
Unobligated Balance as of 12I30/2020 $17,665,810.58 ✓ Average TRF Allotment $142,031.91
Total MFT and TRF Allotment $28,917,817.14 Total Authorizations $22,638,653.08 Paid to State Debits $0.00
Total Supplemental Allotments $5,716,450.64 Total Credits $6,423,761.49 Paid to State Credits $0.00
Date Transaction Type Category Section No. Memo Amount Balance Section
status
12/31/2010 Motor Fuel Tax Fund $225,997.30 ($527,568.24)
1/31/2011 Motor Fuel Tax Fund $244,489.81 ($283,078.43)
2/28/2011 Motor Fuel Tax Fund $196,880.34 ($86,198.09)
3/31/2011 Motor Fuel Tax Fund $223,586.63 $137,388.54
4/7/2011 Credit Interest 09-00000-00-AC $12,467.32 $149,855.86 C
4/7/2011 Credit Interest 03-00000-00-AC $17,792.69 $167,648.55 C
4/7/2011 Credit Interest 02-00000-00-AC $30,673.23 $198,321.78 C
4/7/2011 Credit Interest 04-00000-00-AC $35.164.41 $233,486.19 C
4/7/2011 Credit Interest 0 1-00000-00-AC $52.624,57 $286,110.76 C
4/7/2011 Credit Interest 08-00000-00-AC $54,056.85 $340,167,61 C
4/7/2011 Credit interest 00-00000-00-AC $65,204.24 $405.371,85 C
4/7/2011 Credit Interest 06-00000-00-AC $113,485.35 $518,857.20 C
4/7/2011 Credit Interest 05-00000-00-AC $113.583.78 $632,440.98 C
4/7/2011 Credit Interest 07-00000-00-AC $121,479.70 $753,920.68 C
4/202011 Authorization Maint. Engineer 99400000-00-GM $36,436.55 $717,484.13 C
4/20/2011 Authorization Maintenance 99-00000-00-GM $64,739.83 $652,744.30 C
4202011 Credit Other 02-00000-05-AC $836.36 $653,580.66 C
4/202011 Credit Maint. Engineer 98-00000-00-GM $14,708,87 $668,289.53 C
4/202011 Credit Maintenance 98-00000-OD-GM $105,467.78 $773,757.31 C
4/222011 Credit Maint. Engineer 03-00000-00-GM $21,578.82 $795,336.13 C
4/30/2011 Motor Fuel Tax Fund $216,585.63 $1.011,921.76
5/312011 Motor Fuel Tax Fund $212,478.54 $1,224,400.30
6/232011 Authorization Maint. Engineer 05-00000-00-GM $14,828.07 $1,209,572,23 C
623/2011 Credit Maintenance 05-00000-00-GM $852,368.17 $2,061,940.40 C
6/30/2011 Motor Fuel Tax Fund $197,707.52 $2,259,647.92
7/132011 Credit Engineering 83-00128-00-WR $5,394.74 $2,265,042.66 C
7/132011 Credit Engineering 91-00145-00-PW $27,309.50 $2,292,352.16 C
7/142011 Authorization Contract Construct 03-00172-00-BR $73,582.12 $2,218,770.04 C
7/14/2011 Authorization Maintenance 11-00000-00-GM $3,155,717.00 ($936,946.96) C
7/192011 Authorization Maint. Engineer 06-00000-00-GM $7,965.48 ($944,912.44) C
7/19/2011 Credit Maint. Engineer 08-00000-00-GM $77,564.19 ($867,348.25) C
7/192011 Credit Maintenance 08-00000-00-GM $107,217.29 ($760,130.96) C
Transactions with an Asterisk indicate an unprocessed transaction at the time report was requested.
9/12/2022 10:41.28 AM Filter Criteria:District=l County=All,Agency=Elgin,AgencyType-Municipality.FromDate=12/3l/2010,ToDate=12/3
7/19/2011 Credit Maintenance 06-00000-00-GM $747,044.26 ($13,086.70) C
7/31/2011 Motor Fuel Tax Fund $236,396.47 $223,309.77
8/15/2011 Supplemental Allotment 2nd IJN Installment $455,717.00 $679,026.77
8/19/2011 Authorization Maint. Engineer 07-00000-00-GM $931.52 $678,095.25 C
8/19/2011 Authorization Maintenance 07-00000-MGM $175,457.62 $502.637.63 C
8/31/2011 Motor Fuel Tax Fund $232,140.77 $734,778.40
9/30/2011 Motor Fuel Tax Fund $207,975.33 $942,753.73
10/31/2011 Motor Fuel Tax Fund $231,066.87 $1,173,820.60
11/30/2011 Motor Fuel Tax Fund $244,112.47 $1,417,933.07
12/31/2011 Motor Fuel Tax Fund $227.557.40 $1,645,490.47
1/18/2012 Supplemental Allotment FY12 High Growth City $82,048.00 $1,727,538.47
1131/2012 Motor Fuel Tax Fund $218,816.39 $1,946,354.86
2/29/2012 Motor Fuel Tax Fund $223,009.49 $2,169,364.35
3/31/2012 Motor Fuel Tax Fund $216,915.65 $2,386,280.00
4/10/2012 Authorization Maintenance 12-00000-00-GM $3,045,000.00 ($658,720.00) C
4/30/2012 Motor-Fuel Tax Fund $210,035.14 ($448,684.86)
5/31/2012 Motor Fuel Tax Fund $233,963.63 ($214,721.23)
6/30/2012 Motor Fuel Tax Fund $197,081.01 ($17,640.22)
7/31/2012 Motor Fuel Tax Fund $230,305.76 $212,665.54
8/31/2012 Motor Fuel Tax Fund $230,838.49 $443,504,03
9/30/2012 Motor Fuel Tax Fund $200,442•92 $643,946.95
10/3/2012 Supplemental Allotment 3rd IJN Installment $455,717.00 $1,099,663.95
10/31/2012 Motor Fuel Tax Fund $219,249.40 $1,318,913,35
11/8/2012 Supplemental Allotment FY13 High Growth City $82,003,00 $1,400,916.35
11/30/2012 Motor Fuel Tax Fund $233,733.23 $1,634,649.58
12/31/2012 Motor Fuel Tax Fund $223,951.32 $1,858,600.90
1/29/2013 Credit Interest 10-00000-00-AC $4,389.23 $1,862,990.13
1/29/2013 Credit Interest 09-00000-00-AC $12,467.32 $1,875,457.45
129/2013 Credit Interest 03-00000-00-AC $17,792.69 $1.893,250.14
1292013 Credit Interest 02-00000-00-AC $30,673.23 $1,923,923.37
1292013 Credit Interest 04-00000-00-AC $35,164.41 $1,959,087.78
1292013 Credit Interest 01-00000-00-AC $52,624,57 $2,011,712.35
1292013 Credit Interest 08-00000-00-AC $54,056.85 $2,065,769.20
1292013 Credit Interest 00-00000-00-AC $65,204.24 $2,130,973.44
1292013 Credit Interest 06-00000-00-AC $113,485.35 $2,244,458.79
1292013 Credit Interest 05-00000-00-AC $113,583.78 $2,358,042.57
1292013 Credit Interest 07-00000-00-AC $121,479.70 $2,479,522.27
1/312013 Motor Fuel Tax Fund $217,353.49 $2,696,875.76
2/28/2013 Motor Fuel Tax Fund $184,692.19 $2,881,567.95
3/31/2013 Motor Fuel Tax Fund $218,568.18 $3,100,136.13
4/302013 Motor Fuel Tax Fund $186,054.56 $3,286,190.69
5/312013 Motor Fuel Tax Fund $275,112.04 $3,561,302,73
Transactions with an Asterisk indicate an unprocessel t1ansaction at the time repot was requested.
9/1 2/2022 10 41:28AM Filter Criteria_District-1,County-AII,Agency-ElginAgencyType=Municipality,FromDate=12/31/2010,ToDate=12/3
6/30/2013 Motor Fuel Tax Fund $188,828.95 $3,750,131.68
7/31/2013 Motor Fuel Tax Fund $221,481.46 $3,971,613.14
8/31/2013 Motor Fuel Tax Fund $260.083.42 $4.231,696.56
9/26/2013 Authorization Other (Interest per audit) $2,175.10 $4,229,521.46
9/262013 Credit Maint. Engineer 10-00000-00-GM $6,294.01 $4,235,815.47 C
9/26/2013 Credit Maint. Engineer 09-00000-00-GM $38,456.00 $4,274,271.47 C
926/2013 Credit Maintenance 09-00000-00-GM $208,743.24 $4,483,014.71 C
9/26/2013 Credit Maintenance 10-00000-MGM $635,689.48 $5,118,704.19 C
9/30/2013 Motor Fuel Tax Fund $183,979.43 $5,302,683.62
10/92013 Supplemental Allotment FY2014 High Growth Cities $104,514.00 $5,407,197.62
10/31/2013 Motor Fuel Tax Fund $236,355.44 $5,643,553.06
11/6/2013 Supplemental Allotment FY2014 Illinois Jobs Now $455,717.00 $6,099,270.06
11/302013 Motor Fuel Tax Fund $203,876.93 $6,303,146.99
12/312013 Motor Fuel Tax Fund $270,724.28 $6,573,871.27
1/31/2014 Motor Fuel Tax Fund $238,561.94 $6,812,433,21
2/282014 Motor Fuel Tax Fund $219,712.70 $7,032,145.91
3282014 Authorization Maintenance 14-00000-00-GM $2,900,000.00 $4,132,145.91 C
3/312014 Motor Fuel Tax Fund $172,758.61 $4,304,904.52
4/30/2014 Motor Fuel Tax Fund $199,449.04 $4,504,353.56
4/30/2014 Supplemental Allotment FY2014 Illinois Jobs Now $455.717.00 $4,960,070.56
5/312014 Motor Fuel Tax Fund $280,039.71 $5,240,110.27
6/302014 Motor Fuel Tax Fund $210,590.21 $5,450.700.48
7/31/2014 Motor Fuel Tax Fund $236,064.96 $5,686,765.44
8272014 Supplemental Allotment FY2015 Capital Bill $455,717.00 $6,142,482.44
Program
8/31/2014 Motor Fuel Tax Fund $160,296.97 $6,302,779.41
9/242014 Supplemental Allotment FY2015 High Growth Cities $104,541.00 $6,407,320.41
9/302014 Motor Fuel Tax Fund $217,923.81 $6,625,244.22
10/312014 Motor Fuel Tax Fund $234,546.41 $6,859,790.63
11/30/2014 Motor Fuel Tax Fund $237,735.87 $7,097,526.50
12/31/2014 Motor Fuel Tax Fund $272.442.48 $7,369,968.98
1/31/2015 Motor Fuel Tax Fund $256,044.35 $7,626,013.33
2282015 Motor Fuel Tax Fund $194,360.71 $7.820.374.04
3/312015 Motor Fuel Tax Fund $99,707.80 $7,920,081.84
4/30/2015 Motor Fuel Tax Fund $251,623.12 $8,171,704.96
5/3 1 12 0 1 5 Motor Fuel Tax Fund $236,256,82 $8,407,961.78
6/302015 Motor Fuel Tax Fund $153,344.11 $8,561,305.89
7/312015 Motor Fuel Tax Fund $272,907.57 $8,834,213.46
8/312015 Motor Fuel Tax Fund $262,944.33 $9,097,157.79
Transactions with an Asterisk indicate an unprocessed transaction at the trme report was requested.
9/12/2022 10 41 28 AM Filter Criteria.District=l,County=All,Agency=E[gin AgencyType=Municipality,From Date=12/31/2010,ToDate=12/3
9/29/2015 Supplemental Allotment FY2016 High Growth Cities $104,700.00 $9,201,857.79
9/30/2015 Motor Fuel Tax Fund $177.059.95 $9.378,917.74
10/3112015 Motor Fuel Tax Fund $230,054.38 $9,608,972.12
11/30/2015 Motor Fuel Tax Fund $266,443.14 $9,875,415.26
12/31/2015 Motor Fuel Tax Fund $244,168.71 $10,119,583.97
1/31/2016 Motor Fuel Tax Fund $235.835.61 $10,355,419.58
2/29/2016 Motor Fuel Tax Fund $237,681.31 $10,593,100.89
3/31/2016 Motor Fuel Tax Fund $204,416.54 $10,797,517.43
4/30/2016 Motor Fuel Tax Fund $246.215.65 $11,043,733.08
5/31/2016 Motor Fuel Tax Fund $244,528.73 $11,288,261.81
6/30/2016 Motor Fuel Tax Fund $154,208.32 $11,442,470.13
7/31/2016 Motor Fuel Tax Fund $247,519.42 $11,689.989.55
8/31/2016 Motor Fuel Tax Fund $235,061.99 $11,925,051.54
9/14/2016 Supplemental Allotment FY2017 High Growth Cities $104,852.00 $12,029,903.54
9/30/2016 Motor Fuel Tax Fund $207.490.82 $12,237,394.36
10/312016 Motor Fuel Tax Fund $240,195.73 $12,477,590.09
11/302016 Motor Fuel Tax Fund $244,729.55 $12,722,319.64
12/312016 Motor Fuel Tax Fund $256,651.49 $12,978,971.13
1/312017 Motor Fuel Tax Fund $243,974.96 $13,222,946.09
2/282017 Motor Fuel Tax Fund $232,615.60 $13,455,561.69
3/312017 Motor Fuel Tax Fund $198,335.27 $13,653,896.96
4/30/2017 Motor Fuel Tax Fund $236,874.42 $13,890,771.38
5/312017 Motor Fuel Tax Fund $240,167.41 $14,130,938.79
6/302017 Motor Fuel Tax Fund $190,723.10 $14,321,661.89
7/132017 Authorization Maintenance 16-00000-00-GM $3,000,000.00 $11,321,661.89 C
7/31/2017 Motor Fuel Tax Fund $250,076.59 $11,571,738.48
8/312017 Motor Fuel Tax Fund $236,209.41 $11,807,947.89
9/282017 Supplemental Allotment FY2018 High Growth Cities $51,654.00 $11,859,601.89
9/302017 Motor Fuel Tax Fund $208,792.29 $12,068,394.18
10/312017 Motor Fuel Tax Fund $239,051.25 $12,307,445.43
11/30/2017 Motor Fuel Tax Fund $243,628.85 $12,551,074.28
12/312017 Motor Fuel Tax Fund $239,057.37 $12,790,131.65
1/292018 Supplemental Allotment FY2018 High Growth Cities $51,654.00 $12,841,785.65
-Second Part
1/312018 Motor Fuel Tax Fund $244,750.12 $13,086,535.77
2/282018 Motor Fuel Tax Fund $212,041.11 $13,298,576.88
3/31/2018 Motor Fuel Tax Fund $210,196.92 $13,508,773.80
4/302018 Motor Fuel Tax Fund $247,671.19 $13,756,444.99
5/312018 Motor Fuel Tax Fund $228,010.75 $13,984,455.74
6/302018 Motor Fuel Tax Fund $208.961.19 $14,193,416.93
Transactions with an Asterisk indicate an unprocessed transaction at the time report was requested.
9/12/2022 10:41 28 AM Filter Critedw District=1,County=All,Agency=Elgin,AgencyType=Municipality.From Date=12/31/2010,ToDate-1213
7/31/2018 Motor Fuel Tax Fund $245,255.02 $14,438,671.95
8/31/2018 Motor Fuel Tax Fund $236,495.79 $14,675,167.74
9/30/2018 Motor Fuel Tax Fund $197.554.98 $14,872,722.72
10/31/2018 Motor Fuel Tax Fund $259,194.79 $15,131,917.51
11/15/2018 Supplemental Allotment FY2019 High Growth Cities $102.263.00 $15,234,180.51
11/30/2018 Motor Fuel Tax Fund $244,031.66 $15,478,212.17
12/31/2018 Motor Fuel Tax Fund $234.980.68 $15,713.192.85
1/31/2019 Motor Fuel Tax Fund $234,721.60 $15,947,914.45
2/282019 Motor Fuel Tax Fund $213,480.70 $16,161,395.15
3/31/2019 Motor Fuel Tax Fund $204,153.40 $16,365,548.55
4/302019 Motor Fuel Tax Fund $239,469.45 $16,605,018.00
5/172019 Authorization Maintenance 17-00000-00-GM $3,000,000.00 $13,605,018.00 C
5/312019 Motor Fuel Tax Fund $219,458.81 $13,824,476.81
6/302019 Motor Fuel Tax Fund $200,065.90 $14,024,542.71
7/312019 Motor Fuel Tax Fund $250,071.15 $14,274,613.86
8/312019 MFT Transportation Renewal Fund $161,211.25 $14,435,825.11
813112019 Motor Fuel Tax Fund $198,556.71 $14,634,381.82
9/302019 MFT Transportation Renewal Fund $162,414.33 $14,796,796.15
9/302019 Motor Fuel Tax Fund $228,367.49 $15,025,163.64
10/312019 MFT Transportation Renewal Fund $146,099.66 $15,171,263.30
10/31/2019 Motor Fuel Tax Fund $212,465.89 $15,383,729.19
11/30/2019 MFT Transportation Renewal Fund $160,808.10 $15,544,537.29
11/30/2019 Motor Fuel Tax Fund $242,949.69 $15,787,486.98
12/2/2019 Authorization Maintenance 13-00000-00-GM $2,600,000.00 $13,187,486.98 C
12/162019 Supplemental Allotment FY2020 High Growth Cities $25,463.00 $13,212,949.98
1223/2019 Authorization Maintenance 15-00000-00-GM $2,900,000.00 $10,312,949.98 C
12/31/2019 MFT Transportation Renewal Fund $152,970.03 $10,465,920.01
12/312019 Motor Fuel Tax Fund $321,940.87 $10,787,860.88
1/2/2020 Authorization Maintenance 15-00000-00-GM per Sup Res $5,000.00 $10.782,860.88 C
122020 Credit Maintenance 15-00000-00-GM per Expenditure Statement $13.00 $10,782,873.88 C
12/2020 Credit Maintenance 16-00000-00-GM per Expenditure Statement $1,086,830.00 $11,869,703.88 C
1/282020 Credit Maintenance 17-00000-00-GM $1,250,792.20 $13,120,496.08 C
1/31/2020 MFT Transportation Renewal Fund $148,030.51 $13,268,526.59
Transactions with an Asterisk indicate an unprocessea transaction at the time report was requested.
9/12/2022 10:41:28 AM Filter Criteria District=l,County--All,Agency=Elgin Agency7ype=Municipality,From Date=1 213 1/201 0,ToDate-12/3
1/31/2020 Motor Fuel Tax Fund $188,493.63 $13,457,020.22
2/29/2020 MFT Transportation Renewal Fund $144,964.96 $13,601,985.18
2/29/2020 Motor Fuel Tax Fund $187,941.81 $13,789,926.99
3/30/2020 Authorization Maintenance 18-00000-00-GM per Expenditure Statement $1,656,819.79 $12,133.107.20 C
3/31/2020 MFT Transportation Renewal Fund $136,228.41 $12,269,335.61
3/31/2020 Motor Fuel Tax Fund $208,405.54 $12,477,741.15
4/30/2020 MFT Transportation Renewal Fund $128.688.07 $12,606,429.22
4/30/2020 Motor Fuel Tax Fund $192,183.51 $12,798,612.73
5/8/2020 Supplemental Allotment FY2020 Rebuild Illinois $1,188,335.82 $13,986,948.55
Installment#1
5/31/2020 MFT Transportation Renewal Fund $103,198.38 $14,090,146.93
5/31/2020 Motor Fuel Tax Fund $150,861.29 $14,241,008.22
6/29/2020 Supplemental Allotment FY2020 High Growth Cities $76,390.00 $14,317,398.22
Second Allotment
6/30/2020 MFT Transportation Renewal Fund $111,928.61 $14,429,326.83
6/30/2020 Motor Fuel Tax Fund $149,462.95 $14,578,789,78
7/24/2020 Supplemental Allotment FY2021 Rebuild Illinois $1,188,335.82 $15,767,125.60
Bond Grant Installment#2
7/31/2020 MFT Transportation Renewal Fund $133,859.30 $15,900,984.90
7/31/2020 Motor Fuel Tax Fund $186,012.31 $16,086,997.21
8/31/2020 MFT Transportation Renewal Fund $152,061.60 $16,239,058.81
8/31/2020 Motor Fuel Tax Fund $221,197.99 $16,460,256.80
9/30/2020 MFT Transportation Renewal Fund $145,384.52 $16,605,641.32
9/30/2020 Motor Fuel Tax Fund $201,324.65 $16,806,965.97
10/312020 MFT Transportation Renewal Fund $140,226.12 $16,947,192.09
10/31/2020 Motor Fuel Tax Fund $201,879.02 $17,149,071.11
11/62020 Supplemental Allotment FY2021 High Growth Cities $171,112.00 $17,320,183.11
11/30/2020 MFT Transportation Renewal Fund $144,436.66 $17.464,619.77
11/302020 Motor Fuel Tax Fund $201,190.81 $17,665,810.58
Transactions with an Asterisk indicate an unprocessed transaction at the time report was requested
9/12/2022 10:4128 AM Filter Criteria:District=l,County=All Agency=Elgin,AgencyType=Municipality,FromOate=12/31/2010.ToDate=12/3
l
Illinois Funds
Interest Distribution
December 2020
Daily Daily Daily Daily Daily Daily Daily Daily
Balance Balance Balance Balance Balance Balance Balance Balance
Fund 12/01/20 12/04/20 12/08/20 12/11/20 12/15/20 12/22/20 12/29/20. 01/01/21
010 36,050,596.49 36,093,771.65 36,093,771.65 38,343,908.77 39,613,381.41 39,613,381.41 39,613,381.41
275 1,021,621.29 1,021,621.29 1,021,621.29 1,021,621.29 1,021,621.29 521,621.29 739,682.19
280 2,294.45 2,294.45 2,294.45 2,294.45 2,294.45 2,294.45 2,294.45
290 5,846,642.67 5,846,642.67 6,192,270.14 6,192,270.14 6,192 270.14 6,192,270.14 6,192,270.14
385 2,371,921.99 2,371,921.99 2,371,921.99 2,775,379.52 2,775,379.52 275,379.52 275,379.52 - (p, )
45,293,076.89 45,336,252.05 45,681,879.52 48,335,474.17 49,604,946.81 46,604,946.81 46,823,007.71 0.00
3 4 3 4 7 7 3 31
010 108,151,789.47 144,375,086.60 108,281,314-95 iS3,375,635.08 277,293,669.87 277,293,669.87 118,940,144-23 0.00
275 3,064,863.87 4,086,495.16 3,064,863.87 4,086,485.16 7,151,349.03 3,651,349.03 2,219,046.57 0.00
280 6,983.35 9,277.80 6,883.35 9,177.80 16,061.15 16,061.15 6,983.35 0.00
290 17,539,928.01 23,386,570.68 18,576,810.42 24,769,080.56 43,345,890.98 43,345,890.98 18,576,810.42 0.00
385 7,M,765.97 9,497,687.96 7,115,765.97 11,101,518.08 19,427,656.64 1,927,656.64 826,138.56 0.00
135,879,230.67 181,345,008.20 137,045,638.56 193,341,896.68 347,234,627.67 326,234,627.67 140,469,023.13 0.00
Totals %of total Distribution
010 1,187,611,310.07 0.813 3,044.06 3,044.05-Rounded down
275 27,324,442.69 0.019 70.04
280 71,127.95 0.000 0.18
290 289,540,992.05 0.130 485.83
385 57,002,189.82 0.039 146.11
1,461,550,052.58 100.000 3,746.21
3,746.21
PRIME ~ PRIME Monthly Statement Please Note:
THE FUND WILL BE CLOSED JANUARY 18TH IN OBSERVANCE OF THE
City of Elgin MARTIN LUTHER KING,JR. HOLIDAY
Activity Summary (80141-113) 290- Motor Fuel Tax 12/112020-1MV2020
Investment Pool Summary ISC
Beginning Balance $3,144,159.42
Dividends $239.38 i
Purchases $1,016,611.19
Redemptions ($1,500,000.00)
Ending Balance $2,661,009.99
Average Monthly Rate 0.09%
Total 52,661,009.99
Total Fixed Income — �- .__.~ 51,000,000.00 ;
Account Total $3,661,009.99
Your PMA Portfolio Advisor
Courtney Soesbe
(630) 657-6421
csoesbe@pmanetwork.com
City of Elgin ,.
Debra Nawrocki n j PMA Financial Network
150 Dexter Court PMA 2135 CityGate Lane, 7th Floor
Elgin, IL 60120 Naperville, IL 60563
12/31/2020 1� 04:51:05 PM Questions: (844) 547-7463 City of Flnin (?QO- Mntnr Fival Tay 111) 1 /A
SPARED 06/17/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 1
OGRAM GM360L ACCOUNTING PERIOD 13/2020
ty of Elgin
---------------------------------------------------------------------------------------------------------------------------------
our PO ACCTG ----TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
BR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
------------------------------------------------------------------------------------ --------------------------------------------- /
ND 290 MOTOR FUEL TAX /
90-0000-001.00-00 MOTOR FUEL TAX / CASH .00 277,581.53
481 12/20 AJ 12/30/20 **OFFSET** JOURNAL SUMMARY 1,766.92-
AP DISBURSEMENT 06481
364 12/20 AJ 12/30/20 **OFFSET** DISBURSEMENTS/ACCO 1,766.92-
BATCH TYPE AP 06364
365 12/20 AJ 12/30/20 **OFFSET** CASH RECEIPTS/ACCO 500,000.00
BATCH TYPE CR 06365
364 12/20 AP 12/3C/20 0001648 DISBURSEMENT CASH 1,766.92
REIMBURSE ACCTS PAYABLE
395 12/20 AJ 12/26/20 **OFFSET** DISBURSEMENTS/ACCO 1,579,677.88-
BATCH TYPE AP 06C95
)96 12/20 A.7 12/26/20 **OFFSET** CASH RECEIPTS/ACCO 1,000,000.00
BATCH TYPE CR 06096
)95 12/20 AP 12/26/20 0001635 DISBURSEMENT CASH 579,677.88
REIMBURSE ACCTS PAYABLE ti
358 12/20 AJ 12/23/20 **OFFSET** JOURNAL SUMMARY 579,677.88-
AP DISBURSEMENT 06358
318 12/20 AJ 12/18/20 **OFFSET** JOURNAL SUMMARY 2,755.24-
AP DISBURSEMENT 06318
134 12/20 AJ 12/18/20 **OFFSET** DISBURSEMENTS/ACCO 2,755.24-
BATCH TYPE AP 06034
134 12/20 AP 12/18/20 0001584 DISBURSEMENT CASH 2,755.24
REIMBURSE ACCTS PAYABLE
131 12/20 AJ 12/15/20 **OFFSET** DISBURSEMENTS/A:CO 984,610.36-
BATCH TYPE AP OEC31
131 12/20 AP 12/15/20 0001564 DISBURSEMENT CASH 151.14
REIMBURSE ACCTS PAYABLE i
185 12/20 AJ 12/11/20 **OFFSET** JOURNAL SUMMARY 151.14-
AP DISBURSEMENT 06085
150 12/20 AJ 12/04/20 **OFFSET** JOURNAL SUMMARY 1,221.78-
AP DISBURSEMENT 05950
70 12/20 AJ 12/04/20 **OFFSET** DISBURSEMENTS/ACCO 1,221.78-
BATCH TYPE AP 05770
70 12/20 AP 12/04/20 0001512 DISBURSEMENT CASH 1,221.78
REIMBURSE ACCTS PAYABLE
61 11/20 AJ 11/30/20 **OFFSET** DISBURSEMENTS/ACCO 4,696.60-
BATCH TYPE AP 05761 6
61 11120 AP 11/30/20 0001497 DISBURSEMENT CASH 4,696.60
REIMBURSE ACCTS PAYABLE
60 11/20 AJ 11/25/20 **OFFSET•* JOURNAL SUMMARY 4,696.60- ;
AP DISBURSEMENT 05760
02 11/20 AJ 11/20/20 "OFFSET" OURNAL SUMMARY 44,617.33-
AP DISBURSEMENT 05702
47 11/20 AJ 11/20/20 **OFFSET** DISBURSEMENTS/ACCO 44,617.33-
BATCH TYPE AP 05247
48 11/20 AJ 11/20/20 **OFFSET** CASH RECEIPTS/ACCO 5,076.51
BATCH TYPE CR 05248
47 11/20 AP 11/20/20 0001448 DISBURSEMENT CASH 44,617.33
REIMBURSE ACCTS PAYABLE
45 11120 AJ 11/17/20 **OFFSET** DISBURSEMENTS/ACCO 86.1I-
r
EPARED 06/17/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 2
OGRAM GM360L ACCOUNTING PERIOD 13/2020
ty of Elgin
----------------------------------------------------------------------------------------------------------------------------------
DUP PO ACCTG TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
BR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
ND 290 MOTOR FUEL TAX
90-0000-001.00 00 MOTOR FUEL TAX / CASH continued
BATCH TYPE AP 05245
745 11/2C AP 11/17/20 CCO1436 DISBURSEMENT CASH 86.11
REIMBURSE ACCTS PAYABLE
519 11/20 A, 11/13/20 **OFFSET** JOURNAL SUMMARY 86.11-
AP DISBURSEMENT 05519
?41 11/20 AJ 11/10/20 **OFFSET** DISBURSEMENTS/ACCO 179,696.52-
BATCH TYPE AP 05241
?41 11/20 AP 11/10/20 0001392 DISBURSEMENT CASH 179,696.52
REIMBURSE ACCTS PAYABLE
131 11/20 AJ 11/06/20 **OFFSET** JOURNAL SUMMARY 179,696.52-
AP DISBURSEMENT 05431
>40 11/20 AJ 11/06/20 **OFFSET** CASH RECEIPTS/ACCO 171,112.00
BATCH TYPE CR 05243
S51 10/20 AJ 10/31/20 **OFFSET** DISBURSEMENTS/AC:!O 575.66-
BATCH TYPE AP 04531
:51 10/20 AP 10/31/20 0001355 DISBURSEMENT CASH 515.66
REIMBURSE ACCTS PAYABLE
!04 10/2D AJ 10/30/20 **OFFSET** JOURNAL SUMMARY 575.66-
AP DISBURSEMENT 05204
.09 10/20 AJ 10/23/20 **OFFSET'* :OURNAL SUMMARY 703,528.27-
AP DISBURSEMENT 05109
A 5 10/20 AJ 10/23/20 **OFFSET'* DISBURSEMENTS/ACCO 703,528.27-
BATCH TYPE AP 04545
A 5 10/20 AP 1D/23/20 0001314 DTSBURSEMENT CASH 703,528.27
REIMBURSE ACCTS PAYABLE
i43 10/20 AJ 10/20/20 **OFFSET'* DISBURSEMENTS/ACC() 35,551.95-
BATCH TYPE AP 04543
143 10/20 AP 10/20/20 0001302 DISBURSEMENT CASH 35,551.95
REIMBURSE ACCTS PAYABLE
�2D 10/20 AJ 10/16/20 **OFFSET** JOURNAL SUMMARY 35,551.95-
AP DISBURSEMENT '4320
35 10/20 AJ 10/09/20 **OFFSET** JOURNAL SUMMARY 173,419.12-
AP DISBURSEMENT 04835
37 10/20 AJ 10/09/20 **OFFSET** DISBURSEMENTS/ACCO 173,419.12-
BATCH TYPE AP 04537
37 10/20 AP 10/09/20 0001258 DISBURSEMENT CASH 173,419.12
REIMBURSE ACCTS PAYABLE
35 10/20 AJ 10/06/20 **OFFSET** DISBURSEMENTS/ACCO 35,542.93-
BATCH TYPE AP C4535
35 10/20 AP 10/06/20 D001245 DISBURSEMENT CASH 35,542.93
REIMBURSE ACCTS PAYABLE
94 10/20 AJ 10/02/20 **OFFSET** JOURNAL SUMMARY 35,542.93-
AP DISBURSEMENT 04594
76 09/20 AJ 09/25/20 **OFFSET** JOURNAL, SUMMARY 546,883.90-
AP DISBURSEMENT 04476
2l 09/20 AJ 09/25/20 **OFFSET** DISBURSEMENTS/ACCO 546,883.90-
BATCH TYPE AP 04021
2= 09/20 AP 09/25/20 0001182 DISBURSEMENT CASH 546,883.90
REIMBURSE ACCTS PAYABLE
i
:PARED 06117/2021, 11:27:50 ACCOUNT ACTIVITY LISTING PAGE 3
>GRAN GM360L
:y of Elgin
ACCOUNTING PERIOD 13/2020
------------ - -----------------------------------------------------------
)UP PO ACCTG ----TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
)R NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE i
-------------------------------------------------------------------------------------------------------
)D 290 MOTOR FUEL TAX
)0-0000-DO1.00-00 MOTOR FUEL TAX / CASH continued
)19 09/20 AJ 09/22/20 **OFFSET•* DISBURSEMENTS/ACCO 10,287.40-
BATCH TYPE AP 04019
)19 09/20 AP 09/22/20 0001167 DISBURSEMENT CASH 10,287.40
t
REIMBURSE ACCTS PAYABLE
!97 09/20 AJ 09/16/20 **OFFSET** JOURNAL SUMMARY 10,287.4D-
AP DISBURSEMENT 04297
!24 09/20 AJ 09/11/20 **OFFSET** JOURNAL SUMMARY 21,750.46-
AP DISBURSEMENT 04224
)13 09/20 AJ 09/11/20 **OFFSET** DISBURSEMENTS/ACCO 21,750.46-
BATCH TYPE AP 04013
113 IMB0 AP 09/11/20 0BLE DISBURSEMENT CASH 21,750.46
REIMBURSE ACCTS PAYABLE
)11 09/20 AJ 09/08/20 **OFFSET** DISBURSEMENTS/ACCO 500.86 ;
BATCH TYPE AP 14011
)11 09/20 AP 09/08/20 0001112 DISBURSEMENT CASH 500.86
REIMBURSE ACCTS PAYABLE
.16 09/20 AJ 09/04/20 "OFFSET** TOURNAL SUMMARY 500.86-
A7 D=SBURSEMENT 09116
a
156 08/20 AJ 08/28/20 **OFFSET** JOURNAL SUMMARY 78,451.95-
AP DISBURSEMENT 03956
)69 08/20 AJ 08/28/20 "OFFSET** DISBURSEMENTS/ACCO 78,451.95-
BATCH TYPE AP 03369
170 28/20 AJ 08/28/20 **OFFSET** CASH RECEIPTS/ACCO 184,433.08 f
BATCH TYPE CR 03370
�69 08/20 AP 08/28/20 0001059 DISBURSEMENT CASH 78,451.95
REIMBURSE ACCTS PAYABLE
;67 08120 AJ 08/25/20 **OFFSET** DISBURSEMENTS/ACCO 9,748.14-
BATCH TYPE AP 03367
167 09/20 AP 08/25/20 0001049 DISBURSEMENT CASH 9,748.14
REIMBURSE ACCTS PAYABLE
'73 08/20 AJ 08/19/20 **OFFSET** JOURNAL SUMMARY 9,748.14-
AP DISBURSEMENT 03773
89 08120 AJ 08/14/20 **OFFSET** JOURNAL SUMMARY 11,750.60-
AP DISBURSEMENT 03689
59 08/20 AJ 08/14/20 **OFFSET** DISBURSEMENTS/ACCO 11,750.60-
BATCH TYPE AP 03359
59 08/20 AP 08/14/20 0001008 DISBURSEMENT CASH 11,750.50
REIMBURSE ACCTS PAYABLE
61 08/20 AJ 08/11/20 **OFFSET** DISBURSEMENTS/ACCO 266.45-
BATCH TYPE AP 03361
61 08120 AP 08/11/20 0000990 DISBURSEMENT CASH 266.45
REIMBURSE ACCTS PAYABLE
40 08/20 AJ 08/07/20 **OFFSET** JOURNAL SUMMARY 266.45-
AP DISBURSEMENT 03540
79 07/20 AJ 07/31/20 **OFFSET** JOURNAL SUMMARY 40,964.22-
AP DISBURSEMENT 03379
00 07/20 AJ 07/31/20 **OFFSET** DISBURSEMENTS/ACCO 40,964.22-
BATCH TYPE AP 0320C
01 07/20 AJ 07/31/20 **OFFSET** CASH RECEIPTS/ACCO 1,188,335.82
tEPARED 06/17/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 4
IOGRAM GM360L ACCOUNTING PERIOD 13/2020
,ty of Elgin
•----------------------------------------------------------------------------------------------------------------------------------
IOUP PO ACCTG ----TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
IBR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
TND 290 MOTOR FUEL TAX
90-0000-001.00-00 MOTOR FUEL TAX / CASH continued
BATCH TYPE CR 03201
100 07/20 AP 07/31/20 0000935 DISBURSEMENT CASH 40,964.22
REIMBURSE ACCTS PAYABLE
803 07/20 AJ 07/28/20 **OFFSET** DISBURSEMENTS/ACCO 9,286.96-
BATCR TYPE AP C2803
803 07/20 AP 07/28/20 0000926 DISBURSEMENT CASH 9,286.96
REIMBURSE ACCTS PAYABLE
230 07/20 AJ 07/24/20 **OFFSET** JOURNAL SUMMARY 9,286.96-
AP D-SBURSEMENT D323C
165 07/20 AJ 07/17/20 **OFFSET** JOURNAL SUMMARY 14,482.81-
AP DISBURSEMENT 03165
797 07/20 AJ 07/17/20 **OFFSET** DISBURSEMENTS/ACCO 14,482.B1-
BATCH TYPE AP 02797
797 07/20 AP 07/17/20 0000879 DISBURSEMENT CASH 14,482.81
REIMBURSE ACCTS PAYABLE
795 07/20 AJ 07/I4/20 **OFFSET** DISBURSEMENTS/ACCO 43.26-
BATCH TYPE AP 02795
795 07/20 AP 07/14/20 0000863 DISBURSEMENT CASH 43.26
REIMBURSE ACCTS PAYABLE
020 07/20 AJ 07/10/20 **OFFSET** JOURNAL SUMMARY 43.26-
AP DISBURSEMENT 03020
792 07/20 AJ 07/D7/2D **OFFSET** CASH RECEIPTS/ACCO 76,390.00
BATCH TYPE CR 02792
917 07/20 AJ 07/02/20 *"OFFSET*' JOURNAL SUMMARY 45,385.57-
AP DISBURSEMENT 02917
789 07/20 AJ 07/02/20 **OFFSET** DISBURSEMENTS/ACCO 45,385.57-
BATCH TYPE AP 02789
789 07/20 AP 07/02/20 0000826 r.ISBURSEMENT CASH 45,385.57
REIMBURSE ACCTS, PAYABLE
392 06/20 AJ 06/30/20 **OFFSET** DISBURSEMENTS/ACCO 8,686.55-
BATCH TYPE AP 02392
392 06/20 AP 06/30/20 0000813 DISBURSEMENT CASH 8,686.55
REIMBURSE ACCTS PAYABLE
T61 06/20 AJ 06/26/20 **OFFSET** JOURNAL SUMMARY 8,686.55-
AP DISBURSEMENT 02761
388 C6/20 AJ 06/23/2� **OFFSET** DISBURSEMENTS/ACCO 19,511.45-
BATCH TYPE AP 02388
38@ 06/20 AP 06/23/20 0000771 DISBURSEMENT CASH 19,511.45
REIMBURSE ACCTS PAYABLE
i78 06/2D AJ 06/19/20 **OFFSET** JOURNAL SUMMARY 19,511.45-
AP DISBURSEMENT 02678
184 06/20 AJ 06/16/20 **OFFSET** DISBURSEMENTS/ACCO 49.44-
BATCH TYPE AP 02384
184 06/20 AP 06/16/20 0000751 DISBURSEMENT CASH 49.44
REIMBURSE ACCTS PAYABLE
,79 06/20 AJ 06/12/20 **OFFSET** JOURNAL SUMMARY 49.44-
AP DISBURSEMENT 02579
98 06/20 AJ 06/05/20 **OFFSET** JOURNAL SUMMARY 5,696.17-
AP DISBURSEMENT 02498
tEPARED 06/17/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 5
tOGRAM GH360L ACCOUNTING PERIOD 13/2020
Lty Of Elgin
tOUP 1PO ACCTG TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
IBR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
IND 290 MOTOR FUEL TAX
'90-0000-001.00-00 MOTOR FUEL TAX / CASH Continued
'378 06/20 AJ 06/05/20 **OFFSET** DISBURSEMENTS/ACCO 5,696.17-
BATCH TYPE AP 02378
378 06/2C AP 06/05/20 0000701 DISBURSEMENT CASH 5,696.17
REIMBURSE ACCTS PAYABLE
985 05/20 AJ 05/31/20 **OFFSET** DISBURSEMENTS/ACCO 46,576.72-
BATCH TYPE AP 01985
985 O5/20 AP 05/11/20 0000679 DISBURSEMENT CASH 46,576.72
REIMBURSE ACCTS PAYABLE
362 05/20 AJ 05/29/2C **OFFSET** JOURNAL SUMMARY 46,576.72-
AP DISBURSEMENT 02362
307 05/20 AJ 05/22/20 **OFFSET** JOURNAL SUMMARY 1,536.48-
AP DISBURSEMENT 02307
979 05/20 AJ 05/22/20 **OFFSET** DISBURSEMENTS/ACCO 1,536.48-
BATCH TYPE AP C1979
979 05/20 AP O /22/20 0000646 DISBURSEMENT CASH 1,536.48
REIMBURSE ACCTS PAYABLE
977 05/20 AJ 05/19/20 **OFFSET** DISBURSEMENTS/ACCO 238,481.45-
BATCH TYPE AP 01977
977 05/20 AP 05/19/20 0000633 DISBURSEMENT CASH 238,481.45
REIMBURSE ACCTS PAYABLE
175 05/20 AJ 05/15/20 **OFFSET** JOURNAL SUMMARY 238,481.45-
AP DISBURSEMENT 02.176
976 05/20 AJ 05/15/20 **OFFSET** CASH RECEIPTS/ACCO
1,188,335.82
BATCH TYPE CR 01976
973 05/20 AJ 05/12/2C **OFFSET** DISBURSEMENTS/ACCO 41,137.46-
BATCH TYPE AP 01973
973 05/20 AP 05/12/20 0'00595 DISBURSEMENT CASH 41,137.46
REIMBURSE ACCTS PAYABLE
ill 05120 AJ 05/08/20 **OFFSET** JOURNAL SUMMARY 41,137.46-
AP DISBURSEMENT 02111
969 05/20 AJ 05/05/20 **OFFSET** DISBURSEMENTS/ACCO 949.63-
BATCH TYPE AP 01969
969 05120 AP 05/05/20 0000566 DISBURSEMENT CASH 949.63
REIMBURSE ACCTS PAYABLE
396 05/20 AJ 05/01/20 **OFFSET** JOURNAL SUMMARY 949.63-
AP DISBURSEMENT 01996
196 04/20 AJ 04/24/20 **OFFSET** JOURNAL SUMMARY 328,856.51-
AP DISBURSEMENT 01896
i76 04/20 AJ 04/24/20 **OFFSET** DISBURSEMENTS/ACCO 328,856.51-
BATCH TYPE AP 01576
i76 04/20 AP 04/24/20 0000522 DISBURSEMENT CASH 328,856.51
REIMBURSE ACCTS PAYABLE
i74 04/20 AJ 04/21/2C **OFFSET** DISBURSEMENTS/ACCO 73.30-
BATCH TYPE AP 01574
)74 W20 AP 04/21/20 0000512 DISBURSEMENT CASH 73.30
REIMBURSE ACCTS PAYABLE
'91 04/20 AJ 04/17/20 **OFFSET** JOURNAL SUMMARY 73.30-
AP DISBURSEMENT 01791
]5 04/20 AJ 04/_0/20 **OFFSET** JOURNAL SUMMARY 47.06-
SPARED 06117/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 6
OGRAM GH360L ACCOUNTING PERIOD 13/2020
ty of Elgin
-----------------------------------------------------------------------------------------------------------------------------------
OUP PO ACCTG -- -TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
BR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
ND 290 MOTOR FUEL TAX
90-0000-CO1.00-00 MOTOR FUEL TAX / CASH Continued
AP DISBURSEMENT 01715
568 04/20 AJ C4/10/20 **OFFSET** DISBURSEMENTS/ACCO 47.06-
BATCH TYPE AP 01568
568 04/2D AP 04/10/20 0000465 DISBURSEMENT CASH 47.06
REIMBURSE ACCTS PAYABLE
566 04/20 AJ 04/07/20 **OFFSET** DISBURSEMENTS/ACCO 1,073.37-
BATCH TYPE AP 01566
566 04/20 AP 04/07/20 0000455 DISBURSEMENT CASH 1,073.37
REIMBURSE ACCTS PAYABLE
606 04/20 AJ 04/03/20 **OFFSET** JOURNAL SUMMARY 1,073.37-
AP DISBURSEMENT 01606
490 03/20 AJ 03/27/20 **OFFSET** JOURNAL SUMMARY 717.21-
AP DISBURSEMENT 01498
O11 03/20 AJ 03/77/20 **OFFSET** DISBURSEMENTS/ACCO 717.21-
BATCH TYPE AP 01311
%1 03/20 AP 03/27/20 0000386 DISBURSEMENT CASH 717.21
REIMBURSE ACCTS PAYABLE
009 03/20 AJ 33/24/20 **OFFSET** DISBURSEMENTS/ACCO 13,091.84-
BATCH TYPE AP 01009
009 03/20 AP C3/24/20 0000374 DISBURSEMENT CASH 13,091.84
REIMBURSE ACCTS PAYABLE
387 03/20 AJ 03/20/20 **OFFSET** JOURNAL SUMMARY 13,091.84-
AP DISBURSEMENT 01387
256 03/20 AJ 03/13/20 **OFFSET** JOURNAL SUMMARY 96,144.92-
AP DISBURSEMENT 01256
)03 03/20 AJ 03/13/20 **OFFSET** DISBURSEMENTS/ACCO 96,144.92-
BATCH TYPE AP 01003
)03 03/20 AP 03/13/20 0000331 DISBURSEMENT CASH 96,144.92
REIMBURSE ACCTS PAYABLE
)01 03/20 AJ 03/10/20 **OFFSET** DISBURSEMENTS/ACCO 646.96-
BATCH TYPE AP 01001
)02 03/20 AJ 03/10/20 **OFFSET** CASH RECEIPTS/ACCO 323,862.40
BATCH TYPE CR 01002
)01 03/20 AP 03/10/20 0000320 DISBURSEMENT CASH 646.96
REIMBURSE ACCTS PAYABLE
[41 03/20 AJ 03/06/20 **OFFSET** JOURNAL SUMMARY 646.96-
AP DISBURSEMENT 01141
536 02/20 AJ 02/29/20 **OFFSET** DISBURSEMENTS/ACCO 27,692.56-
BATCH TYPE AP 00536
i36 02/20 AP 02/29/20 0000261 DISBURSEMENT CASH 27,692.56
REIMBURSE ACCTS PAYABLE
!61 02/20 AJ 02/28/20 **OFFSET** JOURNAL SUMMARY 27,692.56-
AP DISBURSEMENT 00961
i32 02/2C AJ 02/25/20 **OFFSET** DISBURSEMENTS/ACCO 17,732.28-
BATCH TYPE AP C0532
02 )2/20 AP 02/25/20 0000239 DISBURSEMENT CASH 17,732.20
REIMBURSE ACCTS PAYABLE
146 02/20 AJ 02/21/20 **OFFSET** JOURNAL SUMMARY 17,732.28-
AP DISBURSEMENT 00846
EPARED 06/17/2021, 11:17:50 ACCOUNT ACTIVITY LISTING PAGE 7
OGRAM GM360L ACCOUNTING PERIOD 13/2020
ty of Elgin
------------------------- --------------- -- -_-------------------------------------------------------------------------------
DUP PO ACCTG ----TRANSACTION---- YTD/CURRENT YTD/CURRENT TRANSACTION CURRENT
BR NBR PER. CD DATE NUMBER DESCRIPTION ESTIM/APPROP ENCUMBRANCE AMOUNT BALANCE
--------------------------------------------------------------------------___-----------------------------------------------------
ND 290 MOTOR FUEL TAX
90-0000•-001.00-00 MOTOR FUEL TAX / CASH continued
742 02/20 AJ 02/14/20 **OFFSET** JOURNAL SUMMARY 96,699.64-
AP DISBURSEMENT 00742
526 02/20 AJ 02/14/20 **OFFSET** DISBURSEMENTSJACCO 96,699.64-
BATCH TYPE AP 00526
526 02/20 AP 02/14/20 0000202 DISBURSEMENT CASH 96,699.64
REIMBURSE ACCTS PAYABLE
524 02/20 AJ 02/11/20 **OFFSET** DTSBURSEMENTS/ACCO 556.87-
BATCH TYPE AP 00524
524 02/20 AP 02/11/20 0000182 DISBURSEMENT CASH 556.87
REIMBURSE ACCTS PAYABLE
528 02/20 AJ 02/07/20 **OFFSET** JOURNAL SUMMARY 556.87-
AP DISBURSEMENT CZ628
174 01/20 AJ 01/31/20 **OFFSET** JOURNAL SUMMARY 689.19-
AP DISBURSEMENT OC474
19 01/20 AJ 01/31/20 **OFFSET** DISBURSEMENTS/ACCO 689.19-
BATCH TYPE AP 00019
19 01/20 AP 01/31/20 0000125 DISBURSEMENT CASH 699.19
REIMBURSE ACCTS PAYABLE
22 01/20 AJ 01/03/20 **OFFSET** JCURNAL SUMMARY 137,343.38-
AP DISBURSEMENT 00022
3 01/20 AJ 01/03/20 **OFFSET** DISBURSEMENTS/ACCO 137,343.38-
BATCH TYPE AP CCO03
3 01/20 AP 01/03/20 0000008 DISBURSEMENT CASH 137,343.38
REIMBURSE ACCTS PAYABLE
1?5 04/20 AJ 01/01/20 ***YERD*** BALANCE FORWAR7 1,261,575.59 /
ACCOUNT TOTAL .00 277,581.53 ✓/
)C-0000-001.80-00 CASH / REPLACEMENT/VOIDED PAYMT .00 OD
'48 11/20 CR 11/20/20 LLG ALLIED ASPHALT PAVING CO 4,183.04-
VOID CITY CHECK #260853 s
105 11/20 AP 11/20/20 0261051 ALLIED ASPHALT PAV 4,183.04
d.
wrong emt
ACCOUNT TOTAL DD CO
0-0000-003.01-00 INVESTMENTS / GOVRNMT SECURTIES/POOLS 0 9,853,765.96
39 12/20 AJ 12/31/20 ZK INTEREST PA1 12/20 725.21
65 12/20 CR 12/3012D LLG I-PRIME MONEY MKT W/D 500,000.00-
96 12/20 CR 12/26/20 LLG I-PRIME MONEY MARKET W/D 11000,000.00-
95 12/20 AP 12/26/20 0001631 PMA FINANCIAL NETW 1,000,000.00
INVESTMENT PURCHASE
94 12/20 CR 12/24/20 LLG PMA FINANCIAL NETWORK 1,000,000.00-
CD MATURITY ,.
94 12/20 CR 12/24/20 LLG I-PRIME MONEY MARKET 1,016,611.'9
CD MATURITY
73 12/20 CR 12/08/20 LLG STATE OF ILLINOIS 945,627-47