Audit 397560

Disaster Grants – Public Assistance (Presidentially Declared Disasters) Assistance Listing No. 97.036 U.S. Department of Homeland Security Criteria: Reporting (44 CFR 206.204) Entities are required to maintain adequate records that support amounts reported in financial reports to ensure accuracy; allow for proper oversight; and comply with applicable laws, regulations, and grant agreements. Condition: The quarterly performance reports did not agree to underlying data. Specifically, source records and supporting schedules used to compile reported information did not agree to the submitted report. Cause: The City does not have formalized procedures requiring staff to prepare and reconcile calculation worksheets that link performance report data to the underlying records. Staff indicated that calculations were performed manually. Effect or Potential Effect: Without adequate documentation supporting quarterly performance reports, reported performance data may be inaccurate, incomplete, or not fully supported. This increases the risk of noncompliance with Uniform Guidance reporting requirements, misreporting to federal agencies, and potential impacts on continued eligibility for federal funding. Questioned Costs: No unknown or questioned costs. Context: We selected a sample of two out of four reports submitted during the year for detailed testing. For both reports tested, we noted a 100% error rate related to inaccurate underlying documentation to support calculations, including aggregated output measures and derived performance indicators. The sampling methodology used is not, and is not intended to be, statistically valid. Repeat Finding: No Recommendation: We recommend management implement procedures ensuring that all performance report data requiring calculations are supported by reconciled worksheets that clearly document how reported amounts were derived from source records. Views of Responsible Officials: We agree with the finding. See separate report for planned corrective actions.