Finding 573780 (2024-003)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-08-18
Audit: 364452
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over compliance due to incorrect reporting of costs in quarterly reports.
  • Impacted Requirements: Compliance with 2 CFR 200.303(a) is not met, as the District failed to ensure accurate financial reporting for federal awards.
  • Recommended Follow-up: The District should review and improve its data verification process for quarterly reports to ensure accuracy and compliance.

Finding Text

Department of Homeland Security, State of Nebraska Office of Emergency Management Agency, 97.039, DR‐4420‐NE‐0017 Hazard Mitigation Grant Program Reporting Significant Deficiency 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: Certain line items in the reports submitted for the quarters ended 3/31/2024 and 6/30/2024 contained costs from the incorrect period. Cause: The District utilized the “Job Analysis Report” and was unaware the report contained costs that were from the incorrect period. Effect: The District’s control process and procedures did not detect or correct the errors. Questioned Costs: No questioned costs over $25,000. Context/Sampling: Nonstatistical sampling was used. There were three quarterly reports submitted throughout the fiscal year. As such, three reports were selected for testing. Key line items were identified within the reports for testing. Repeat Finding form Prior Year: Yes, prior year finding 2023‐004. Recommendation: We recommend the District review the process surrounding the data utilized to put together the quarterly reports submitted to ensure the correct amounts are used and are properly supported. Views of Responsible Officials: Management agrees with the finding.

Corrective Action Plan

Federal Agency Name: Department of Homeland Security Pass‐Through Entity: State of Nebraska Office of Emergency Management Assistance Listing Number: 97.039 Program Name: Hazard Mitigation Grant Program Finding Summary: Certain line items in the reports submitted for the quarters ended 3/31/2024 and 6/30/2024 contained costs from the incorrect period. Corrective Action Plan: The State of Nebraska requires quarterly reporting on FEMA funded projects. The due date of the report is on the 15th of the month following the end of the quarter. Due to this timing and the month‐end closing process of Elkhorn RPPD’s financials, the costs for work order costs related to payroll benefits and any overheads are not included in the quarterly project costs. These are submitted the next quarterly report. Responsible Individuals: Carmen Christensen, CFO/Office Manager Anticipated Completion Date: Ongoing through the end of the grant award dated 9/17/2024.

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 573779 2024-002
    Material Weakness Repeat
  • 1150221 2024-002
    Material Weakness Repeat
  • 1150222 2024-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
97.039 Hazard Mitigation Grant $788,254