Finding 529736 (2024-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-03-24
Audit: 347702
Organization: City of Wyandotte, Michigan (MI)

AI Summary

  • Core Issue: The City’s schedule of expenditures of federal awards (SEFA) was inaccurate, leading to both understatements and overstatements of federal funding.
  • Impacted Requirements: Compliance with the Single Audit Act and Uniform Guidance was not met, as accurate financial statements are required for entities expending over $750,000 in federal awards.
  • Recommended Follow-Up: The City should establish a robust process to ensure the SEFA is complete and accurate, and review its procedures for reporting federal grant expenditures.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 21.027, U.S. Department of the Treasury, COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - ALN 21.027 SLFRP0127 Pass through Entity - ALN 21.027 - State of Michigan Finding Type - Material weakness Repeat Finding - Yes 2023-002 Criteria - The Single Audit Act and Uniform Guidance require a nonfederal entity that expends $750,000 or more of federal awards in a fiscal year to have a single or program-specific audit. 2 CFR §200.508 (b) indicates that the auditee must prepare financial statements, including the schedule of expenditures of federal awards in accordance with 2 CFR §200.510. Additionally, 2 CFR §200.502 describes the basis for determining the timing of when federal awards are deemed expended and, therefore, reportable on the schedule. Condition - The schedule of expenditures of federal awards (SEFA) was not accurate. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - During the fiscal year ended September 30, 2024, the City expended approximately $2,831,000 of federal funding. The initial draft of the SEFA included the following inaccuracies: ALN 66.818 - The expenditures reported on the SEFA were understated by $148,474. ALN 21.027 - The expenditures reported on the SEFA were overstated by $2,078,221. The SEFA was also ovestated by $116,625 related to a non federal program. The errors noted above have been corrected on the SEFA as of September 30, 2024. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit. The errors resulted in the overstatement of federal expenditures. Recommendation - We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - The City will review its process for identifying and communicating federal grant expenditures to its auditors.

Corrective Action Plan

Condition: The schedule of expenditures of federal awards (SEFA) was not accurate. Planned Corrective Action: The City will review its process for identifying and communicating Federal Grant expenditures to its auditors. Contact person responsible for corrective action: Robert McMahon, City Administrator Anticipated Completion Date: 09/30/2025

Categories

Reporting Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 529737 2024-002
    Material Weakness Repeat
  • 529738 2024-003
    Material Weakness Repeat
  • 1106178 2024-002
    Material Weakness Repeat
  • 1106179 2024-002
    Material Weakness Repeat
  • 1106180 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $522,106
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $148,474
16.922 Equitable Sharing Program $62,901
10.569 Emergency Food Assistance Program (food Commodities) $58,495
16.753 Congressionally Recommended Awards $39,464
14.218 Community Development Block Grants/entitlement Grants $35,014
90.404 Hava Election Security Grants $14,597