Finding 1166204 (2024-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-12-22

AI Summary

  • Core Issue: The District reported expenses to Cal-OES that were $484,041 higher than actual expenses due to duplicate entries.
  • Impacted Requirements: This overstatement led to receiving federal funds improperly and violated grant compliance and reporting standards.
  • Recommended Follow-Up: Simplify accounting records and enhance review processes before submitting reports to prevent future errors.

Finding Text

SA2024-001: Discrepancy in Expenses Reported to Cal-OES– Significant Deficiency AL number: 97.039 AL Title: Hazard Mitigation Grant Name of Federal Agency: Department of Homeland Security Criteria The District is responsible for a timely and accurate reporting of eligible grant expenses. Condition During the performance of the audit, we noted that District‘s reported expenses to Cal-OES exceeded the actual expenses by $484,041. Cause The District’s incorrectly recorded duplicate expenditures entries resulting in overstatement of reported expenditures. Questioned Costs: We question all costs noted above in the total amount of $484,041. Effect Because of overstatement of expenses, District received federal funds for which it was not entitled in addition to non-compliance of grant terms and uniform guidance reporting compliance requirements. Recommendation We recommend that the District simplify its structure of accounting records and properly review reports before submission. Management Response The duplicate reporting of costs occurred during a time when the District was transitioning grant financial reporting from the engineering department to the finance department. At the same time as this transition, the role assigned to grant financial reporting experienced turnover which required temporary workload redistribution. Because multiple employees across different departments were assisting with grant reporting during this period, there was an increased opportunity for error, and expenditures that had already been reported were inadvertently captured again on a later reimbursement request. Responsibility for financial expenditure reporting has now been formally transitioned to the Finance Department. This change minimizes errors in expenditure reporting due to Finance staff’s specialized knowledge of the financial system, and their experience in researching variances and verifying financial data. Engineering staff remain the program specialists and continue to provide programmatic narrative, technical context, and compliance reporting. This restructuring also centralizes financial reporting, and allows Finance to export data directly from the financial system rather than relying on a reporting tool that summarizes information separately. Additionally, after Engineering completes its programmatic review, the Finance Manager and the Finance Director provides review and approval of all grant-related financial reporting. This added layer of review and approval, ensures that all data is verified by multiple parties and accurately reported.

Corrective Action Plan

Responsibility for grant-related financial expenditure reporting has been formally transitioned to the Finance Department. This change reduces the risk of reporting errors by leveraging Finance Staff’s specialized knowledge of the financial system and experience in researching variances, reconciling accounts, and verifying financial data. Engineering staff will continue to serve as the program specialists and remain responsible for providing programmatic narratives, technical documentation, and compliance related information. This restricting centralizes financial reporting within Finance and allows expenditure data to be exported directly from the District’s financial system rather than relying on separate reporting tools that summarize information outside the general ledger. The District has also implemented a multi-staff financial review process to minimize errors with the creation of the Accounting Supervisor and Finance Manager positions. In addition, the District will simplify its structure of accounting records to minimize the possibility of errors to occur through the implementation of a new financial system.

Categories

Cash Management Reporting Significant Deficiency Matching / Level of Effort / Earmarking

Programs in Audit

ALN Program Name Expenditures
97.039 HAZARD MITIGATION GRANT $3.72M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $663,748
97.047 BRIC: BUILDING RESILIENT INFRASTRUCTURE AND COMMUNITIES $72,284