Finding 540982 (2024-008)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-03-31
Audit: 350587
Organization: City of Amsterdam, New York (NY)
Auditor: Rbt CPAS

AI Summary

  • Core Issue: The City failed to prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA), leading to discrepancies in reported expenditures.
  • Impacted Requirements: Compliance with federal and state regulations for SEFA preparation was not met, resulting in inaccuracies that require further audit adjustments.
  • Recommended Follow-Up: The City should enhance its understanding of SEFA preparation to ensure future submissions are complete and accurate, as this issue has recurred.

Finding Text

Finding 2023-008 Schedule of Expenditures of Federal Awards. Type of Finding: Internal Control Deficiency and Compliance Finding. Condition: The City did not prepare a complete and accurate Schedule of Expenditures of Federal Awards and State Transportation Assistance ("SEFA"). Criteria: The Schedule of Expenditures of Federal Awards and State Transportation Assistance is required to be prepared by the Auditee under federal and state regulations. Cause: Federal and state expenditures are not tracked by funding source. Reimbursements from funding sources are not always allocated accurately to federal and state revenue accounts when received. Effect: Total expenditures of federal awards and state transportation assistance reported on the SEFA as required for the single audit was not accurate, requiring additional research and audit adjustments. Repeat Finding: This is a repeat of finding 2023-007. Recommendation: RBT recommends that the City obtain a clearer understanding of the SEFA and the preparation process such that the annual compilation of data is complete and accurate. Auditee's Response: See corrective action plan.

Corrective Action Plan

The City Controller, City Engineer and Director of Community and Economic Development held meetings to discuss the development of a SharePoint site for all grant documentation. This is slowly starting to take shape and with the addition of an IT professional to the City's workforce, we are confident that the City will become much better at tracking federal and state expenditures by funding source. Louise Biron will be responsible for this finding and the anticipated completion date is June 30, 2025.

Categories

Reporting Internal Control / Segregation of Duties Cash Management

Other Findings in this Audit

  • 1117424 2024-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $344,496
20.205 Highway Planning and Construction $76,103
14.251 Economic Development Initiative, Community Project Funding, and Miscellaneous Grants $61,130
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $45,125
16.738 Edward Byrne Memorial Justice Assistance Grant Program $10,000
16.607 Bulletproof Vest Partnership Program $1,980