Audit 322331

FY End
2023-12-31
Total Expended
$10.52M
Findings
2
Programs
19
Organization: City of Evanston, Illinois (IL)
Year: 2023 Accepted: 2024-09-30

Organization Exclusion Status:

Checking exclusion status...

Contacts

Name Title Type
XKVUMPN8PBN1 Jess Tapia Auditee
8478662908 Hilda Renteria Auditor
No contacts on file

Notes to SEFA

Title: REPORTING ENTITY Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. This report on Federal Awards includes the federal awards of the City of Evanston, Illinois. The reporting entity for the city is based upon criteria established by the Governmental Accounting Standards Board (GASB). The City of Evanston is the primary government according to GASB criteria. On April 30, 2014, the Township was discontinued and dissolved following the March 18, 2014 general election vote taken by the registered voters of the Evanston Township. Pursuant to 60 ILCS 1/27-15 and 1/27-20, effective 12:00 a.m. May 1, 2014, the City of Evanston assumed all rights, powers, assets, property, obligations and duties of the Evanston Township, including the responsibilities of providing the services that were previously provided by the Township. Beginning May 1, 2014, the functions of the Township are reported along with the City.
Title: SUBRECIPIENTS Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. Of the federal expenditures presented in the schedule of expenditures of federal awards, the City of Evanston provided federal awards to subrecipients as follows: Federal Amount Program Title Assistance Provided to Listing Subrecipients Number Community Development Block Grants/Entitlement Grants 14.218 $279,995 COVID-19 Community Development Block Grants/Entitlement Grants 14.218 $251,263 Emergency Solutions Grant Program 14.231 $136,364 Home Investment Partnerships Program 14.239 $ 47,562 COVID-19 Coronavirus State and Local Fiscal Recovery Funds 21.027 $212,462
Title: PROGRAM INCOME Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. The City of Evanston received the following program income amounts for the year ended December 31, 2023. The balances of receipts are from letter of credit drawdowns for the program. The program expenditures for the year include expenditures of this program income Federal Program Title Assistance Amount Listing Number Community Development Block Grants/Entitlement Grants 14.218 $163,577 Home Investment Partnerships Program 14.239 $ 25,227 Neighborhood Stabilization Program 14.256 $ 6,833
Title: NOTES RECEIVABLE OUTSTANDING Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. The City of Evanston has several notes receivable outstanding as of December 31, 2023. These loans are for various uses. The Community Development Block Grants/Entitlement Grants Loan funds a number of programs to make decent housing available and affordable to low- and moderate-income families, and to help low- and moderate-income residents maintain their property. The Home Investment Partnerships Program Loan provides loans to housing developers to acquire, rehab or construct housing for low and moderate income households. Federal Program Title Assistance Amount Listing Number Community Development Block Grants/Entitlement Grants 14.218 $1,662,815 Home Investment Partnerships Program 14.239 $5,281,264 The notes receivable balances are not subject to continuing OMB Uniform Guidance compliance requirements
Title: LOANS PAYABLE OUTSTANDING Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. The City of Evanston has the following loans payable outstanding as of December 31, 2023. These loans are from The Capitalization Grants for Drinking Water and Clean Water State Revolving Funds. Projects funded were the sewer lining at Emerson and Davis streets, rehab of large diameter sewers and rehab of the Cleveland street sewer. Federal Program Title Assistance Amount Listing Number Capitalization Grants for Drinking Water State Revolving Funds 66.468 $665,847 Capitalization Grants for Clean Water State Revolving Funds 66.458 $655,570 The loan payable balances are not subject to continuing OMB Uniform Guidance compliance requirements.
Title: NONCASH ASSISTANCE Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. Of the federal expenditures presented in the schedule of expenditures of federal awards, the City of Evanston did not receive any noncash assistance during the year ended December 31, 2023.
Title: FEDERAL INSURANCE Accounting Policies: The accounting records for some grant programs are maintained on the modified accrual basis of accounting. Under the modified accrual basis, revenues are recorded when susceptible to accrual, i.e., both measurable and available. Available means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Expenditures are recorded when the liability is incurred. The accounting records for other grant programs are maintained on the accrual basis, i.e., when the revenue has been earned and the liability is incurred. The information in this schedule is presented in accordance with the requirements of OMB Uniform Guidance. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: The City of Evanston has not elected to use the 10% de minimis indirect cost rate. The City of Evanston had no federal insurance for the year ended December 31, 2023.

Finding Details

FINDING 2023-001 Procurement, Suspension and Debarment (Repeat Finding 2022-001 and 2021-001) Federal Agency: Department of the Treasury Federal Program: 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria: The Department of the Treasury’s Final Rule (Effective April 1, 2022) encouraged the use of internal Procurement Policies and Procedures when procuring products and/or services. The Department of the Treasury’s Compliance and Reporting Guidance report (Effective June 24, 2021 through April 30, 2025) required recipients (i.e., City of Evanston) to ensure any procurement using CSLFRF funds to be consistent with the procurement standards set forth in the Uniform Guidance at 2 CFR 200.317 through 2 CFR 200.327 as applicable. Procurement Standards of Title 2 of the Code of Federal Regulations (CFR) Part 200 Uniform Administrative Requirements, Costs Principles, and Audit Requirements for Federal Awards (Uniform Guidance) state that all non-federal entities will follow Section 200.318 through Section 200.327. A. Section 200.320 identifies four methods of procurement to be followed, among the methods of procurement the below are three identified thresholds: (a) Informal – micro purchases (any amount up to $10,000) (b) Informal – small purchases ($10,000.01 to $249,999.99) (c) Formal – sealed bids ($250,000 and above) (d) Noncompetitive procurement B. The City of Evanston Purchasing Manual requires the collection of three written quotes for any purchase between $2,500 and $25,000 purchased with federal grant funds, a formal bid process (Bid, RFP, RFQ) for any purchase $25,000 or above purchased with federal grant funds, and a justification memo for a sole source purchase for any amount above $2,500 purchased with federal grant funds. C. The City of Evanston Purchasing Manual requires that for purchases above $2,500 but less than $10,000, approval signature must be obtained from the Department Director. All purchases above $10,000 require approval signature from the City Manager. Purchases above $25,000 must also be approved by the City Council. D. Per Title 2 CFR section 180.300, participant entering into a covered transaction must verify that the person with whom it intends to do business is not excluded or disqualified by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person. E. Title 2 CFR section 200.303 states the following regarding internal control: “The auditee shall maintain internal control over Federal programs that provides reasonable assurance that the auditee is managing Federal awards in compliance with law, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its Federal programs.” Condition/Context: 1. We tested two purchase orders totaling $208,832.12. Our procedures revealed the following: a. Dated documentation that demonstrates suspension and debarment searches were performed prior to entering into a covered transaction were not retained in the respective procurement files. b. Documentation supporting multiple source solicitations was not available. Cause: 1. At the time these services were procured, the City of Evanston’s procurement policies requiring suspension and debarment checks were not implemented. 2. The City of Evanston’s procurement policies in relation to single source do not meet federal requirements. Effect: City of Evanston was not in compliance with Title 2 of the Code of Federal Regulations (CFR) Part 200 and the requirements outlined in the City of Evanston Purchasing Manual as it relates to purchases above $25,000. Additionally, the effect of noncompliance can result in questioned costs. Recommendation: We recommend that City of Evanston: a. Date or time stamp suspension and debarment searches when performed. b. Revise procurement policies to mirror federal guidelines and requirements in relation to single and sole source purchases. c. Communicate and re-enforce its procurement policies and procedures to ensure compliance with applicable requirements. d. Ensure all departments are following applicable procedure in a uniform manner. Views of Responsible Officials: The purchases in question were made in the Equipment Replacement Fund where debarment searches are not required. ARPA funds were transferred to the Equipment Replacement Fund after the vehicles were delivered. We supplied the list of exclusions issued by the Office of Inspector General, which, from a compliance standpoint, demonstrates that the vendors are not suspended or debarred before entering a covered transaction. The list covers a one-month window and does not provide an exact date for when the list is retrieved from the Office of Inspector General website. When performing debarment searches in SAM.gov, if a vendor opts not to register or does not complete full registration process, the search results will display no matches, rendering it inconclusive to determine their standing. To prevent any potential deficiencies in control procedures, we intend to adopt the supplementary risk-based assessments proposed by the firm.
FINDING 2023-001 Procurement, Suspension and Debarment (Repeat Finding 2022-001 and 2021-001) Federal Agency: Department of the Treasury Federal Program: 21.027 Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Criteria: The Department of the Treasury’s Final Rule (Effective April 1, 2022) encouraged the use of internal Procurement Policies and Procedures when procuring products and/or services. The Department of the Treasury’s Compliance and Reporting Guidance report (Effective June 24, 2021 through April 30, 2025) required recipients (i.e., City of Evanston) to ensure any procurement using CSLFRF funds to be consistent with the procurement standards set forth in the Uniform Guidance at 2 CFR 200.317 through 2 CFR 200.327 as applicable. Procurement Standards of Title 2 of the Code of Federal Regulations (CFR) Part 200 Uniform Administrative Requirements, Costs Principles, and Audit Requirements for Federal Awards (Uniform Guidance) state that all non-federal entities will follow Section 200.318 through Section 200.327. A. Section 200.320 identifies four methods of procurement to be followed, among the methods of procurement the below are three identified thresholds: (a) Informal – micro purchases (any amount up to $10,000) (b) Informal – small purchases ($10,000.01 to $249,999.99) (c) Formal – sealed bids ($250,000 and above) (d) Noncompetitive procurement B. The City of Evanston Purchasing Manual requires the collection of three written quotes for any purchase between $2,500 and $25,000 purchased with federal grant funds, a formal bid process (Bid, RFP, RFQ) for any purchase $25,000 or above purchased with federal grant funds, and a justification memo for a sole source purchase for any amount above $2,500 purchased with federal grant funds. C. The City of Evanston Purchasing Manual requires that for purchases above $2,500 but less than $10,000, approval signature must be obtained from the Department Director. All purchases above $10,000 require approval signature from the City Manager. Purchases above $25,000 must also be approved by the City Council. D. Per Title 2 CFR section 180.300, participant entering into a covered transaction must verify that the person with whom it intends to do business is not excluded or disqualified by: (a) Checking SAM Exclusions; or (b) Collecting a certification from that person; or (c) Adding a clause or condition to the covered transaction with that person. E. Title 2 CFR section 200.303 states the following regarding internal control: “The auditee shall maintain internal control over Federal programs that provides reasonable assurance that the auditee is managing Federal awards in compliance with law, regulations, and the provisions of contracts or grant agreements that could have a material effect on each of its Federal programs.” Condition/Context: 1. We tested two purchase orders totaling $208,832.12. Our procedures revealed the following: a. Dated documentation that demonstrates suspension and debarment searches were performed prior to entering into a covered transaction were not retained in the respective procurement files. b. Documentation supporting multiple source solicitations was not available. Cause: 1. At the time these services were procured, the City of Evanston’s procurement policies requiring suspension and debarment checks were not implemented. 2. The City of Evanston’s procurement policies in relation to single source do not meet federal requirements. Effect: City of Evanston was not in compliance with Title 2 of the Code of Federal Regulations (CFR) Part 200 and the requirements outlined in the City of Evanston Purchasing Manual as it relates to purchases above $25,000. Additionally, the effect of noncompliance can result in questioned costs. Recommendation: We recommend that City of Evanston: a. Date or time stamp suspension and debarment searches when performed. b. Revise procurement policies to mirror federal guidelines and requirements in relation to single and sole source purchases. c. Communicate and re-enforce its procurement policies and procedures to ensure compliance with applicable requirements. d. Ensure all departments are following applicable procedure in a uniform manner. Views of Responsible Officials: The purchases in question were made in the Equipment Replacement Fund where debarment searches are not required. ARPA funds were transferred to the Equipment Replacement Fund after the vehicles were delivered. We supplied the list of exclusions issued by the Office of Inspector General, which, from a compliance standpoint, demonstrates that the vendors are not suspended or debarred before entering a covered transaction. The list covers a one-month window and does not provide an exact date for when the list is retrieved from the Office of Inspector General website. When performing debarment searches in SAM.gov, if a vendor opts not to register or does not complete full registration process, the search results will display no matches, rendering it inconclusive to determine their standing. To prevent any potential deficiencies in control procedures, we intend to adopt the supplementary risk-based assessments proposed by the firm.