Department of Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Preparation of Schedule of Expenditures of Federal Awards
Significant Deficiency 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 form 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 Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Reporting
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.
Condition: In two of two quarterly reports tested, we noted the Cooperative improperly reported the federal, state, and local shares incurred during the reporting period.
Cause: The Cooperative’s independent review process over the quarterly performance reports did not identify the improperly excluded expenditures on the report.
Effect: Lack of compliance with designed internal controls over reporting could result in the Cooperative reporting incorrect or incomplete information.
Questioned Costs: None reported.
Context/Sampling: A nonstatistical sample of 2 out of 4 quarterly performance reports.
Repeat Finding from Prior Year: No
Recommendation: We recommend the Cooperative review internal control procedures over reporting to ensure reported amounts agree to supporting documentation including a reconciliation to the general ledger. In addition, we suggest the Cooperative implement a formal approval process and retain documentation to support evidence of the review.
Views of Responsible Officials: Management agrees with the finding.
Department of Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Cash Management
Material Weakness in Internal Control over Compliance
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.
Condition: In two of two draw requests tested, we noted that the Cooperative did not have formal documentation to support the review of the draw prior to submission for reimbursement.
Cause: The Cooperative did not have any formally documented review and approval over the draw requests.
Effect: Lack of properly designed controls could result in a reasonable possibility the Cooperative would not be able to demonstrate compliance with the federal program.
Questioned Costs: None reported.
Context/Sampling: There were two draw requests made during the year and both were tested.
Repeat Finding from Prior Year: No
Recommendation: We recommend the Cooperative review internal control procedures over cash management to implement a formal review and approval process over draw requests prior to submission. The procedures should incorporate steps to retain documentation to support evidence of the review.
Views of Responsible Officials: Management agrees with the finding.
Department of Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Preparation of Schedule of Expenditures of Federal Awards
Significant Deficiency 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 form 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 Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Reporting
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.
Condition: In two of two quarterly reports tested, we noted the Cooperative improperly reported the federal, state, and local shares incurred during the reporting period.
Cause: The Cooperative’s independent review process over the quarterly performance reports did not identify the improperly excluded expenditures on the report.
Effect: Lack of compliance with designed internal controls over reporting could result in the Cooperative reporting incorrect or incomplete information.
Questioned Costs: None reported.
Context/Sampling: A nonstatistical sample of 2 out of 4 quarterly performance reports.
Repeat Finding from Prior Year: No
Recommendation: We recommend the Cooperative review internal control procedures over reporting to ensure reported amounts agree to supporting documentation including a reconciliation to the general ledger. In addition, we suggest the Cooperative implement a formal approval process and retain documentation to support evidence of the review.
Views of Responsible Officials: Management agrees with the finding.
Department of Homeland Security, State of Iowa Department of Homeland Security and Emergency Management, 97.039, 4483DRIAP00000005, 2024
Hazard Mitigation Grant Program
Cash Management
Material Weakness in Internal Control over Compliance
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.
Condition: In two of two draw requests tested, we noted that the Cooperative did not have formal documentation to support the review of the draw prior to submission for reimbursement.
Cause: The Cooperative did not have any formally documented review and approval over the draw requests.
Effect: Lack of properly designed controls could result in a reasonable possibility the Cooperative would not be able to demonstrate compliance with the federal program.
Questioned Costs: None reported.
Context/Sampling: There were two draw requests made during the year and both were tested.
Repeat Finding from Prior Year: No
Recommendation: We recommend the Cooperative review internal control procedures over cash management to implement a formal review and approval process over draw requests prior to submission. The procedures should incorporate steps to retain documentation to support evidence of the review.
Views of Responsible Officials: Management agrees with the finding.