Finding 1099531 (2022-002)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2025-02-13
Audit: 342365
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.
  • Impacted Requirements: The inaccuracies violated the Single Audit Act and Uniform Guidance, which require accurate financial 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, including proper review of program income.

Finding Text

Assistance Listing Number, 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, Community Development Block Grant Entitlement Grants Cluster Federal Award Identification Number and Year - N/A Passthrough Entity - 66.818, Brownfields Assessment and Cleanup of Cooperative Agreements is direct funded. 14.218, Community Development Block Grant is passed through Wayne County, Michigan. Finding Type - Material weakness Repeat Finding - No 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, 2022, 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 $125,687. ALN 14.218 The expenditures reported on the SEFA were understated by $80,468. The errors noted above have been corrected on the SEFA as of September 30, 2022. Cause and Effect - Controls in place did not ensure the SEFA was complete and accurate for the fiscal period under audit, as the City did not include use of program income in its review of federal expenditures. The errors resulted in the understatement of federal expenditures, as noted in the context above. 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.

Categories

Reporting Material Weakness Matching / Level of Effort / Earmarking Program Income

Other Findings in this Audit

  • 523087 2022-002
    Material Weakness
  • 523088 2022-003
    Material Weakness
  • 523089 2022-002
    Material Weakness
  • 1099529 2022-002
    Material Weakness
  • 1099530 2022-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
97.044 Assistance to Firefighters Grant $504,636
66.818 Brownfields Multipurpose, Assessment, Revolving Loan Fund, and Cleanup Cooperative Agreements $125,687
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $92,551
14.218 Community Development Block Grants/entitlement Grants $80,468
10.569 Emergency Food Assistance Program (food Commodities) $79,520
20.205 Highway Planning and Construction $26,192
97.067 Homeland Security Grant Program $6,353
10.664 Cooperative Forestry Assistance $6,003