Audit 367092

Department of Treasury, State of Iowa Chief Information Officer, Federal Financial Assistance Listing 21.027, NOFA #007 – 433524,433385, 2024 Coronavirus State and Local Fiscal Recovery Funds Preparation of Schedule of Expenditures of Federal Awards Material Weakness in Internal Control over Compliance Criteria: Proper controls over financial reporting include a system designed to prepare the schedule of expenditures of federal awards (the schedule) and the accompanying notes to the schedule. Condition: The Cooperative does not have an internal control system designed to provide for a complete and accurate schedule of federal expenditures of federal awards being audited. As auditors, we were requested to assist with the preparation of the schedule and accompanying notes to the schedule. Cause: Auditor assistance with preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Cooperative meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Cooperative would not be able to draft a complete and accurate schedule. Questioned Costs: None reported. Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: While we recognize that this condition is not unusual for an organization with limited staffing, it is important that the Cooperative is aware of this condition for financial reporting requirements relating to the Cooperative’s schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.

Department of Treasury, State of Iowa Chief Information Officer, Federal Financial Assistance Listing 21.027, NOFO #007 – 433524,433385, 2024 Coronavirus State and Local Fiscal Recovery Funds Procurement, Suspension & Debarment Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.318 maintains that recipients must have and use documented procurement policies and must conform procurement standards in sections 200.317 through 200.327. 2 CFR 200 Appendix II requires certain provisions be included in contracts if criteria are applicable. Additionally, 2 CFR 200.214 requires recipients to restrict the subawards and contract with certain parities that are debarred, suspended, or excluded from participation in Federal assistance programs or activities. Condition: Testing of the federal program identified the following: - One instance where the Cooperative followed a bid process, however, the documentation was not retained to support the selection. Additionally, the contract with the vendor was missing required contract provisions in accordance with Uniform Guidance. - Two instances where the Cooperative did not follow the procurement process as detailed in the procurement policy and did not have any formal documentation or contract in place with the vendor. - Three instances where the Cooperative entered into a contract with a vendor over $25,000 and there was no review performed to ensure the vendor was not suspended or debarred. Cause: Contract provisions were not evaluated compared to Uniform Guidance contract requirements. Contracts entered were not evaluated in accordance with Uniform Guidance as it relates to suspension and debarment. Effect: Ineffective controls over this area of compliance could result in a reasonable possibility the Cooperative would be noncompliant with the compliance requirements outlined above. Additionally, the cooperative may enter into a covered transaction with a vendor that is suspended or debarred. Questioned Costs: None reported. Context/Sampling: A nonstatistical sample of 3 out of 5 vendors were selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend that management implement procedures related to the review of contracts to ensure the procurement methods are being followed and to ensure contracts include the required Uniform Guidance provisions. Also, management should incorporate procedures to ensure vendors are not suspended or debarred from doing business with the federal government. Documentation should be retained to provide evidence that procedures were completed. Views of Responsible Officials: Management agrees with the finding.