City of Mishawaka

Subject: 2023-002 Coronavirus State and Local Fiscal Recovery Funds – Reporting Federal Agency: Department of the Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Finding: Significant Deficiency and Noncompliance Criteria: 2 CFR 200.303 includes requirements related to internal controls for federal award programs, including that the Agency must, among other things, “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)”. Condition and Context: We noted the City submitted a report required under the Coronavirus State and Local Fiscal Recovery Funds which did not have adequate review of the report for accuracy of the information or inclusion of the appropriate key line items. This finding is a repeat finding of 2021-003 and 2022-002. Cause and Effect: We noted lack of internal controls surrounding the reporting process resulted in key line items to be misstated and the errors were identified subsequent to the initial submission. There were no questioned costs related to this issue. Recommendation: We recommend the City implement procedures to ensure reports are being reviewed by an individual or third-party familiar with the program prior to submission. Views of Responsible Officials and Planned Corrective Actions: The City agrees with the recommendation and plans to implement the recommendation during 2024.

Subject: 2023-002 Coronavirus State and Local Fiscal Recovery Funds – Reporting Federal Agency: Department of the Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Finding: Significant Deficiency Recommendation: The Auditor recommends the City implement procedures to ensure reports are being reviewed by an individual or third-party familiar with the grant prior to their submission, including reconciliation of the report to the general ledger system. Planned Corrective Actions: The City made corrections during calendar year 2023 for a corresponding 2022. This current findings is a result of not being able to make edits in the ARPA reporting portal. A 2022 expenditure was overstated, and this 2023 expenditure was understated by the same amount.

2022-002, 2021-003

Subject: 2022-002 Coronavirus State and Local Fiscal Recovery Funds ? Reporting Federal Agency: Department of the Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Finding: Significant Deficiency Criteria: 2 CFR 200.303 includes requirements related to internal controls for federal award programs, including that the Agency must, among other things, ?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)?. Condition and Context: We noted the City submitted a report required under the Coronavirus State and Local Fiscal Recovery Funds which did not have adequate review of the report for accuracy of the information or inclusion of the appropriate key line items. This finding is a repeat finding of 2021-03. Cause and Effect: We noted lack of internal controls surrounding the reporting process resulted in key line items to be misstated and the errors were identified subsequent to the initial submission. There were no questioned costs related to this issue. Recommendation: We recommend the City implement procedures to ensure reports are being reviewed by an individual or third-party familiar with the program prior to submission. Views of Responsible Officials and Planned Corrective Actions: The City agrees with the recommendation and plans to implement the recommendation during 2023.

Subject: 2022-002 Coronavirus State and Local Fiscal Recovery Funds ? Reporting Federal Agency: Department of the Treasury Federal Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Compliance Requirement: Reporting Audit Finding: Significant Deficiency Recommendation: The Auditor recommends the City implement procedures to ensure reports are being reviewed by an individual or third-party familiar with the grant prior to their submission, including reconciliation of the report to the general ledger system. Planned Corrective Actions: The City agrees with the recommendation and plans to implement the recommendation during 2023.

2021-003

2021-003 Coronavirus State and Local Fiscal Recovery Fund ? Assistance Listing No. 21.027 Significant Deficiency in Internal Control over Compliance ? L. Reporting Criteria: 2 CFR 200.303 includes requirements related to internal controls for federal award programs, including that the Agency must, among other things, ?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)?. Condition and Context: We noted the City submitted a report required under the Coronavirus State and Local Fiscal Recovery Fund which had no review of the report for accuracy of the information or inclusion of the appropriate key line items. Cause and Effect: We noted no noncompliance in relation to the report and the applicable compliance requirements. However, key line items could have been misstated without the errors being identified and corrected since no review of the report occurred prior to submission. Recommendation: We recommend the City implement procedures to ensure reports are being reviewed by a competent and capable individual or third-party prior to submission. Views of Responsible Officials and Planned Corrective Actions: The City agrees with the recommendation and plans to implement the recommendation during 2022.

Federal Award Findings and Questioned Costs Department of the Treasury 2021-003 Coronavirus State and Local Fiscal Recovery Fund ? Assistance Listing No. 21.027 Significant Deficiency in Internal Control over Compliance ? L. Reporting Recommendation: The Auditor recommends the City implement procedures to ensure reports are being reviewed by a competent and capable individual or third-party prior to their submission. Planned Corrective Actions: The City agrees with the recommendation and plans to implement the recommendation during 2022.