Finding 1218754 (2025-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-06-25
Audit: 404862
Organization: Islamorada, Village of Islands (FL)
Auditor: CS&L CPAS

AI Summary

  • Core Issue: There is a material weakness in internal controls over financial reporting, leading to significant adjustments in financial statements.
  • Impacted Requirements: Financial statements and the Schedule of Expenditures of Federal Awards (SEFA) did not accurately reflect all transactions, violating accounting principles and Uniform Guidance.
  • Recommended Follow-Up: Management should enhance procedures for reconciling federal grant activities and ensure all reimbursable expenditures are matched to revenue and reported on the SEFA.

Finding Text

Material Weakness in Internal Control over Financial Reporting and the Preparation of the Schedule of Expenditures of Federal Awards and State Financial Assistance Criteria: Management is responsible for maintaining accurate accounting records and preparing financial statements and the Schedule of Expenditures of Federal Awards and State Financial Assistance (SEFA) in conformity with generally accepted accounting principles and Uniform Guidance requirements. Condition: During the audit, adjustments were posted to correct beginning net position in the Plantation Yacht Harbor Marina Fund in the amount of $1,821,000. For the year ended September 30, 2024, revenue and a related receivable were not reported to match expenditures reimbursable under a federal grant agreement. Additionally, the expenditures were not included in the SEFA. Content/Cause: Internal controls over financial reporting and the preparation of the SEFA were not sufficient to ensure all transactions were properly identified, recorded, and reported in the financial statements and related SEFA and subjected to the Single Audit. Effect: The Village reported a prior period adjustment in the Plantation Yacht Harbor Marina Fund in the amount of $1,821,000 to beginning net position. Additionally, this amount was included on the SEFA for the year ended September 30, 2025. Recommendation: We recommend management strengthen procedures for identifying and reconciling federal grant activity to the general ledger and reviewing year-end financial reporting schedules, including the SEFA. The reconciliation should ensure that reimbursable grant expenditures are properly matched to revenue and included on the SEFA, in the current period.

Corrective Action Plan

Subject: Response to Financial Statement Finding 2025-01 We appreciate the opportunity to respond to the financial statement finding titled "2025-01 Material Weakness in Internal Control Over Financial Reporting and the Preparation of the Schedule of Expenditures of Federal Awards" identified in the audit report dated September 30, 2025. Finding Summary: A material weakness was identified in internal control over financial reporting and the preparation of the Schedule of Expenditures of Federal Awards (SEFA). During the audit, a prior period adjustment of $1,821,000 was required to correct beginning net position in the Plantation Yacht Harbor Marina Fund. Additionally, for the fiscal year ended September 30, 2024, certain reimbursable federal grant expenditures were not properly matched with related revenue and receivables and were not included in the SEFA. These issues indicate that controls were not sufficient to ensure all transactions were accurately identified, recorded, and reported in accordance with generally accepted accounting principles and Uniform Guidance requirements. Management Response: Management acknowledges the material weakness in internal control over financial reporting and SEFA preparation. The identified condition resulted from incomplete identification and reconciliation of grant-related activity during fiscal year 2024, which led to the omission of reimbursable expenditures and related revenues from both the financial statements and the SEFA. Upon discovery, management recorded a prior period adjustment of $1,821,000 to correct beginning net position in the Plantation Yacht Harbor Marina Fund. The related grant expenditures have been properly included in the SEFA for the fiscal year ended September 30, 2025. Management agrees with the auditor’s recommendation and recognizes the need to strengthen internal controls surrounding the identification, reconciliation, and reporting of federal grant activity. Corrective Action Plan: To address this finding and strengthen internal controls, the Village has implemented and will continue to implement the following actions: Centralized Grant Tracking The Village has established a comprehensive grant tracking log to monitor all federal and state awards, including expenditures, reimbursement status, and SEFA reporting requirements. Enhanced SEFA Preparation Controls Year-end financial reporting procedures have been strengthened to include a formalized SEFA preparation and review process. This process includes reconciliation of the grant tracking log to the general ledger and a secondary review to ensure completeness and accuracy. Improved Coordination and Training Communication between the Finance Department and grant program managers has been enhanced to ensure timely identification of grant activity. Additional training on Uniform Guidance requirements and SEFA reporting has been provided to relevant staff. These control enhancements are designed to ensure that all reimbursable grant expenditures are properly identified, recorded, and reported in both the financial statements and the SEFA. Conclusion: Management has taken corrective action to address the identified material weakness and has implemented additional controls to improve the accuracy and completeness of financial reporting and SEFA preparation. Management believes these measures will effectively mitigate the risk of similar issues occurring in the future and will continue to monitor and refine these processes to ensure ongoing compliance with applicable accounting and federal reporting requirements

Categories

Reporting

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds (SLFRF) $1.82M