Audit 321859

FY End
2023-12-31
Total Expended
$6.35M
Findings
2
Programs
7
Organization: City of West Lafayette (IN)
Year: 2023 Accepted: 2024-09-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499074 2023-002 Material Weakness Yes I
1075516 2023-002 Material Weakness Yes I

Contacts

Name Title Type
JUE9CA8R5UE1 Peter Gray Auditee
7657755151 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the City under programs of the federal government for the year ended December 31, 2023. The information in the SEFA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the SEFA presents only a select portion of the operations of the City, it is not intended to and does not present the financial position of the City. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-87, Cost Principles for State, Local, and Indian Tribal Governments, or the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed or are limited as to reimbursement. When federal grants are received on a reimbursement basis, the federal awards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: Note 2. Indirect Cost Rate The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): CY 2021 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context Prior to entering into subawards and covered transactions with COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF), recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Upon inquiry of the City in order to review the procedures in place for verifying that an entity with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the City explained that they were checking for suspension and debarment status through the EPLS but were not retaining the search results. A population of two vendors with which there were nine covered transactions totaling $5,103,638 was identified. Both vendors were selected for testing. For each of the two vendors, the City did not retain any documentation that it verified the vendors were not suspended nor debarred or otherwise excluded or disqualified from participating in federal assistance programs or activities. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 15 CITY OF WEST LAFAYETTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause The City's policies and procedures did not include the retention of the EPLS search results conducted on vendors with whom a covered transaction was entered. Effect Without the proper implementation of an effectively designed system of internal controls, we could not verify that the City ensured vendors paid with federal funds were eligible to participate in federal programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City strengthen its policies and procedures to include documentation of the EPLS verification. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Suspension and Debarment Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): CY 2021 Compliance Requirement: Procurement and Suspension and Debarment Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context Prior to entering into subawards and covered transactions with COVID-19 - Coronavirus State and Local Fiscal Recovery Funds (SLFRF), recipients are required to verify that such contractors and subrecipients are not suspended, debarred, or otherwise excluded. "Covered transactions" include, but are not limited to, contracts for goods and services awarded under a nonprocurement transaction (i.e., grant agreement) that are expected to equal or exceed $25,000. The verification is to be done by checking the Excluded Parties List System (EPLS), collecting a certification from that person, or adding a clause or condition to the covered transaction with that person. Upon inquiry of the City in order to review the procedures in place for verifying that an entity with which it plans to enter into a covered transaction is not suspended, debarred, or otherwise excluded, the City explained that they were checking for suspension and debarment status through the EPLS but were not retaining the search results. A population of two vendors with which there were nine covered transactions totaling $5,103,638 was identified. Both vendors were selected for testing. For each of the two vendors, the City did not retain any documentation that it verified the vendors were not suspended nor debarred or otherwise excluded or disqualified from participating in federal assistance programs or activities. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: INDIANA STATE BOARD OF ACCOUNTS 15 CITY OF WEST LAFAYETTE SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 31 CFR 19.300 states: "When you enter into a covered transaction with another person at the next lower tier, you must verify that the person with whom you do business is not excluded or disqualified. You do this by: (a) Checking the EPLS; or (b) Collecting a certification from that person if allowed by this rule; or (c) Adding a clause or condition to the covered transaction with that person." Cause The City's policies and procedures did not include the retention of the EPLS search results conducted on vendors with whom a covered transaction was entered. Effect Without the proper implementation of an effectively designed system of internal controls, we could not verify that the City ensured vendors paid with federal funds were eligible to participate in federal programs. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the City strengthen its policies and procedures to include documentation of the EPLS verification. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.