Finding 1222417 (2025-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-06-30
Audit: 406142
Organization: City of Coral Gables, Florida (FL)
Auditor: RSM US LLP

AI Summary

  • Core Issue: The City failed to include $66,963 in payroll expenditures for the HIDTA program in the SEFA, leading to incomplete federal expenditure reporting.
  • Impacted Requirements: This oversight violates the Uniform Guidance, which mandates accurate reporting of federal expenditures in the SEFA.
  • Recommended Follow-Up: Implement a formal reconciliation process between the general ledger and SEFA, ensure a secondary review for completeness, and maintain a comprehensive list of grant expenditures.

Finding Text

2025-003 – Significant Deficiency and Noncompliance Program: High Intensity Drug Trafficking Areas (HIDTA) Program Assistance Listing (ALN): 95.001 Federal Agency: Executive Office of the President Federal Award Numbers: G22MI0001A, G23MI0001A, G24MI0001A, HID1225G0597 Criteria: The Uniform Guidance requires the auditee to prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the financial statements that includes complete and accurate reporting of total federal expenditures for each program. Condition: The City’s original SEFA draft excluded $66,963 of payroll expenditures related to ALN 95.001, resulting in incomplete reporting of federal expenditures. Cause: The omission occurred due to oversight by personnel responsible for SEFA preparation. Effect or potential effect: The exclusion resulted in an understatement of federal expenditures of $66,963 and had the potential to impact major program determination. Questioned costs: None. Context: The issue relates to SEFA completeness. The error appears to be an isolated oversight and was discussed with the Grants Coordinator. Identification as a repeat finding, if applicable: Not applicable. Recommendation: We recommend the City to implement a formal reconciliation between the general ledger and SEFA, require secondary review for completeness, and utilize a full population listing of grant expenditures. Views of Responsible Officials: Management acknowledges the audit finding and recommendation. There was staff turnover during fiscal 2025 and the transactions missing from the SEFA occurred during the transition. In fiscal year 2026, the City hired a second grants coordinator to have adequate staff over the management and administration of grants. Management is committed to maintaining complete and accurate reporting of total federal expenditures for each grant program; and implementing a formal reconciliation of expenditures between the general ledger and SEFA.

Corrective Action Plan

Identifying number: 2025-003 Finding: The City’s original SEFA draft excluded $66,963 of payroll expenditures related to ALN 95.001, resulting in incomplete reporting of federal expenditures. Corrective Actions Planned: Beginning in fiscal year 2026, management will ensure that complete population of grant program expenditures are reconciled to the general ledger and project accounting module as part of the procedure in preparing the schedule of expenditures of federal awards. This corrective action plan has been assigned to Diana Gomez, Finance Director and will be completed by November 30, 2026, for all expenditures related to fiscal year 2026.

Categories

Reporting

Programs in Audit

ALN Program Name Expenditures
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $1.13M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $426,409
81.135 ADVANCED RESEARCH PROJECTS AGENCY - ENERGY $311,025
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $119,439
21.016 EQUITABLE SHARING $115,790
16.835 BODY WORN CAMERA POLICY AND IMPLEMENTATION $62,257
97.039 HAZARD MITIGATION GRANT $38,005
97.067 HOMELAND SECURITY GRANT PROGRAM $11,039