Finding 43301 (2022-007)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-06-04
Audit: 39808
Organization: YWCA West Central Michigan (MI)

AI Summary

  • Core Issue: There were inaccuracies in the Schedule of Expenditures of Federal Awards (SEFA), with overstatements and understatements in reported expenditures for multiple programs.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) regarding the preparation and accuracy of the SEFA was not met, leading to a repeat finding.
  • Recommended Follow-Up: Review and strengthen procedures for SEFA preparation, including verification of ALN numbers and involving a second staff member for accuracy checks before submission.

Finding Text

Assistance Listing Number, Federal Agency, and Program Name 93.558, U.S. Department of Health and Human Services, Temporary Assistance for Needy Families; 97.024, U.S. Department of Homeland Security, Emergency Food and Shelter National Board Program; 14.231, U.S. Department of Housing and Urban Development, Emergency Solutions Grant Program Federal Award Identification Number and Year 2101MITANF, 2021 and 2201MITANF, 2022; Not Applicable; E 20 DW 26 0001, 2020 Pass through Entity Michigan Department of Health and Human Services; United Way Finding Type Significant deficiency Repeat Finding Yes 2021 003 Criteria Per 2 CFR 200.510(b), the auditee must prepare a schedule of expenditures of federal awards (SEFA) for the period covered by the auditee's financial statements, which must include the total federal awards expended, as determined in accordance with ?200.502. Condition For SEFA reporting, expenditures were overstated for one program and understated for another. In addition, an ALN listed for expenditures was inaccurate. Questioned Costs None Identification of How Questioned Costs Were Computed Not applicable Context Expenditures for the Temporary Assistance for Needy Families program were overstated by $106,341. Expenditures for the Emergency Food and Shelter National Board Program were understated by $21,983. Expenditures for the Emergency Solutions Grant Program were listed under ALN 14.248. The SEFA presented has been adjusted for these errors. Cause and Effect Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation We recommend the Organization review its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions Grant documents will be reviewed upon receipt to determine the proper ALN and the federal portion of funding. All existing grants will also be reviewed. The ALN listed in each grant document will be used when completing the SEFA. A second staff member will verify the accuracy of the SEFA prior to submission. All ALN numbers will be reviewed upon receipt and verified with state analysts when applicable. The organization will ensure that the funding sources are verified to the most appropriate level at the state level to verify funds and funding sources.

Categories

Reporting

Other Findings in this Audit

  • 43296 2022-004
    Material Weakness
  • 43297 2022-004
    Material Weakness
  • 43298 2022-005
    Material Weakness
  • 43299 2022-005
    Material Weakness
  • 43300 2022-007
    Significant Deficiency Repeat
  • 43302 2022-006
    Significant Deficiency Repeat
  • 43303 2022-006
    Significant Deficiency Repeat
  • 43304 2022-006
    Significant Deficiency Repeat
  • 43305 2022-006
    Significant Deficiency Repeat
  • 43306 2022-007
    Significant Deficiency Repeat
  • 43307 2022-007
    Significant Deficiency Repeat
  • 43308 2022-004
    Material Weakness
  • 43309 2022-004
    Material Weakness
  • 43310 2022-005
    Material Weakness
  • 43311 2022-005
    Material Weakness
  • 619738 2022-004
    Material Weakness
  • 619739 2022-004
    Material Weakness
  • 619740 2022-005
    Material Weakness
  • 619741 2022-005
    Material Weakness
  • 619742 2022-007
    Significant Deficiency Repeat
  • 619743 2022-007
    Significant Deficiency Repeat
  • 619744 2022-006
    Significant Deficiency Repeat
  • 619745 2022-006
    Significant Deficiency Repeat
  • 619746 2022-006
    Significant Deficiency Repeat
  • 619747 2022-006
    Significant Deficiency Repeat
  • 619748 2022-007
    Significant Deficiency Repeat
  • 619749 2022-007
    Significant Deficiency Repeat
  • 619750 2022-004
    Material Weakness
  • 619751 2022-004
    Material Weakness
  • 619752 2022-005
    Material Weakness
  • 619753 2022-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
14.239 Home Investment Partnerships Program $393,560
93.558 Temporary Assistance for Needy Families $240,035
16.575 Crime Victim Assistance $223,195
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $169,669
14.267 Continuum of Care Program $148,885
93.136 Injury Prevention and Control Research and State and Community Based Programs $100,890
97.024 Covid-19 - Emergency Food and Shelter National Board Program $66,983
16.021 Justice Systems Response to Families $55,853
93.671 Covid-19 - Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $43,145
14.231 Covid-19 - Emergency Solutions Grant Program $37,298
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $27,539