Finding 571987 (2024-003)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-07-25
Audit: 363084
Organization: City of Coral Gables, Florida (FL)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: The City failed to submit its audit package and data collection form on time to the federal audit clearinghouse, violating Uniform Guidance requirements.
  • Impacted Requirements: Timely submission is crucial for maintaining compliance with federal grant requirements and avoiding potential loss of funding.
  • Recommended Follow-Up: Enhance internal controls, develop contingency plans for system changes, and ensure proper training and resource allocation to prevent future delays.

Finding Text

2024-003 – Significant Deficiency and Noncompliance - Data Collection Form All Assistance Listing Numbers and Federal Agencies (and pass-through entities) included on the accompanying schedule of federal awards for the year ended September 30, 2024. Criteria: Uniform Guidance requires that the City’s annual audit package and data collection be submitted to the federal audit clearinghouse within 30 days after receipt of the auditor’s reports or 9 months after the end of the City’s fiscal year, whichever comes first. Condition: The City’s audit package and data collection form for the year ended September 30, 2024 was not submitted timely to the federal audit clearinghouse. Cause: The City implemented a new Enterprise Resource Planning (ERP) system which delayed the completion of the City’s annual audit. Context: See “Condition” above. Effect or potential effect: Failure to submit the annual audit package and data collection form to the federal audit clearinghouse in a timely manner could result in a loss of grant funding. Questioned costs: None. Identification as a repeat finding, if applicable: Not applicable. Recommendation: We recommend that the City enhance its internal control policies and procedures to mitigate the risk of future delays. This includes developing contingency plans for major system implementations and ensuring adequate training and resource allocation during such transition periods. Views of Responsible Officials: Management acknowledges that the City’s audit package and Data Collection Form were not submitted timely to the Federal Audit Clearinghouse within the required timeframe in accordance with Uniform Guidance (2 CFR 200.512). We understand the importance of timely submission in maintaining compliance with federal grant requirements and ensuring continued eligibility for federal funding. The delay was due to new ERP system conversion and staffing shortages. We will re-evaluate our current processes and ensure that all deadlines associated with the Single Audit process are clearly documented and monitored. We will conduct internal reviews after each year-end closing to ensure audit-related deadlines are met and updates will be provided to senior leadership as needed. We will strengthen internal controls and improve communication with our auditors to avoid future delays in submission to the Federal Audit Clearinghouse.

Categories

Allowable Costs / Cost Principles Eligibility Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 571982 2024-003
    Significant Deficiency
  • 571983 2024-003
    Significant Deficiency
  • 571984 2024-003
    Significant Deficiency
  • 571985 2024-003
    Significant Deficiency
  • 571986 2024-003
    Significant Deficiency
  • 571988 2024-003
    Significant Deficiency
  • 571989 2024-003
    Significant Deficiency
  • 571990 2024-003
    Significant Deficiency
  • 571991 2024-003
    Significant Deficiency
  • 571992 2024-003
    Significant Deficiency
  • 1148424 2024-003
    Significant Deficiency
  • 1148425 2024-003
    Significant Deficiency
  • 1148426 2024-003
    Significant Deficiency
  • 1148427 2024-003
    Significant Deficiency
  • 1148428 2024-003
    Significant Deficiency
  • 1148429 2024-003
    Significant Deficiency
  • 1148430 2024-003
    Significant Deficiency
  • 1148431 2024-003
    Significant Deficiency
  • 1148432 2024-003
    Significant Deficiency
  • 1148433 2024-003
    Significant Deficiency
  • 1148434 2024-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
97.039 Hazard Mitigation Grant $1.32M
95.001 High Intensity Drug Trafficking Areas Program $959,457
21.016 Equitable Sharing $326,145
16.922 Equitable Sharing Program $209,937
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $122,139
97.067 Homeland Security Grant Program $100,811
16.835 Body Worn Camera Policy and Implementation $38,922
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $26,581
81.000 Traffic Technology Services, Inc. $19,830
16.738 Edward Byrne Memorial Justice Assistance Grant Program $5,816