Finding 526452 (2023-002)

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

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) was inaccurate, leading to an understatement of federal funding by over $744,000.
  • Impacted Requirements: The inaccuracies violated the Single Audit Act and Uniform Guidance, which require accurate reporting for entities expending over $750,000 in federal awards.
  • Recommended Follow-Up: The City should establish a reliable process to ensure the SEFA is complete and accurate to avoid future audit issues.

Finding Text

Assistance Listing, Federal Agency, and Program Name 66.818, U.S. Environmental Protection Agency, Brownfields Assessment and Cleanup Cooperative Agreements; 14.218, U.S. Department of Housing and Urban Development, CDBG Entitlement Grants Cluster Community Development Block Grant Federal Award Identification Number and Year N/A Pass through Entity ALN 14.218 Wayne County Finding Type Material weakness Repeat Finding Yes 2022 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, 2023, the City expended approximately $921,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 $689,255. ALN 14.218 The expenditures reported on the SEFA were understated by $55,192. The errors noted above have been corrected on the SEFA as of September 30, 2023. 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 understatement of federal expenditures. Additionally, the understatement of federal expenditures on the SEFA resulted in the incorrect conclusion that federal activity was below $750,000 and, therefore, a single audit was not needed. Recommendation We recommend the City implement a process to ensure that the SEFA is complete and accurate. Views of Responsible Officials and Corrective Action Plan 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

  • 526453 2023-002
    Material Weakness Repeat
  • 526454 2023-003
    Material Weakness Repeat
  • 526455 2023-004
    Material Weakness
  • 1102894 2023-002
    Material Weakness Repeat
  • 1102895 2023-002
    Material Weakness Repeat
  • 1102896 2023-003
    Material Weakness Repeat
  • 1102897 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $689,255
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $570,000
14.218 Community Development Block Grants/entitlement Grants $75,192
10.569 Emergency Food Assistance Program (food Commodities) $59,409
16.922 Equitable Sharing Program $58,000
97.067 Homeland Security Grant Program $22,093
97.044 Assistance to Firefighters Grant $10,281
11.419 Coastal Zone Management Administration Awards $7,500
90.404 Hava Election Security Grants $5,285