Audit 363084

FY End
2024-09-30
Total Expended
$3.41M
Findings
22
Programs
10
Organization: City of Coral Gables, Florida (FL)
Year: 2024 Accepted: 2025-07-25
Auditor: Rsm US LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
571982 2024-003 Significant Deficiency - P
571983 2024-003 Significant Deficiency - P
571984 2024-003 Significant Deficiency - P
571985 2024-003 Significant Deficiency - P
571986 2024-003 Significant Deficiency - P
571987 2024-003 Significant Deficiency - P
571988 2024-003 Significant Deficiency - P
571989 2024-003 Significant Deficiency - P
571990 2024-003 Significant Deficiency - P
571991 2024-003 Significant Deficiency - P
571992 2024-003 Significant Deficiency - P
1148424 2024-003 Significant Deficiency - P
1148425 2024-003 Significant Deficiency - P
1148426 2024-003 Significant Deficiency - P
1148427 2024-003 Significant Deficiency - P
1148428 2024-003 Significant Deficiency - P
1148429 2024-003 Significant Deficiency - P
1148430 2024-003 Significant Deficiency - P
1148431 2024-003 Significant Deficiency - P
1148432 2024-003 Significant Deficiency - P
1148433 2024-003 Significant Deficiency - P
1148434 2024-003 Significant Deficiency - P

Contacts

Name Title Type
GW19L8Z6H7Q7 Sally Ola Ola Auditee
3054605295 Anil Harris Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: The Schedules are presented using the modified accrual basis of accounting for expenditures accounted for in the governmental funds and on the accrual basis of accounting for expenses of the proprietary fund types, which are described in Note 1 to the City’s basic financial statements. Such expenditures/expenses are recognized following the cost principles contained in the Uniform Guidance and Chapter 10.550, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. It was not used as allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards and Schedule of State Financial Assistance (the Schedules) includes the federal and state award activity of the City of Coral Gables, Florida (the City) under programs of the federal and state government for the year ended September 30, 2024. The information in the Schedules is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and Chapter 10.550, Rules of the Auditor General of the State of Florida (Chapter 10.550). Because the Schedules present only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in fund balance/net position or cash flows of the City.
Title: Summary of Significant Accounting Policies Accounting Policies: The Schedules are presented using the modified accrual basis of accounting for expenditures accounted for in the governmental funds and on the accrual basis of accounting for expenses of the proprietary fund types, which are described in Note 1 to the City’s basic financial statements. Such expenditures/expenses are recognized following the cost principles contained in the Uniform Guidance and Chapter 10.550, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. It was not used as allowed under the Uniform Guidance. The Schedules are presented using the modified accrual basis of accounting for expenditures accounted for in the governmental funds and on the accrual basis of accounting for expenses of the proprietary fund types, which are described in Note 1 to the City’s basic financial statements. Such expenditures/expenses are recognized following the cost principles contained in the Uniform Guidance and Chapter 10.550, wherein certain types of expenditures are not allowable or are limited as to reimbursement.
Title: Indirect Cost Rate Accounting Policies: The Schedules are presented using the modified accrual basis of accounting for expenditures accounted for in the governmental funds and on the accrual basis of accounting for expenses of the proprietary fund types, which are described in Note 1 to the City’s basic financial statements. Such expenditures/expenses are recognized following the cost principles contained in the Uniform Guidance and Chapter 10.550, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. It was not used as allowed under the Uniform Guidance. The City elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: Subrecipient Awards Accounting Policies: The Schedules are presented using the modified accrual basis of accounting for expenditures accounted for in the governmental funds and on the accrual basis of accounting for expenses of the proprietary fund types, which are described in Note 1 to the City’s basic financial statements. Such expenditures/expenses are recognized following the cost principles contained in the Uniform Guidance and Chapter 10.550, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. It was not used as allowed under the Uniform Guidance. The City did not make subawards of federal awards or state financial assistance during the year ended September 30, 2024.

Finding Details

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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.