Finding 393877 (2023-011)

Significant Deficiency Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-04-22
Audit: 304072
Organization: YWCA West Central Michigan (MI)

AI Summary

  • Core Issue: There is a significant deficiency in internal controls over compliance, specifically regarding the Schedule of Expenditures of Federal Awards (SEFA).
  • Impacted Requirements: The SEFA did not accurately report federal expenditures, violating 2 CFR 200.510(b) and §200.502.
  • Recommended Follow-Up: Enhance procedures to ensure the SEFA is complete and accurate, with a review by the CFO or CEO before finalization.

Finding Text

U.S. Department of Homeland Security, U.S. Department of Justice, and U.S. Department of Health and Human Services #2023-011 – Major Federal Award Finding Nature of Finding: Significant Deficiency in Internal Controls over Compliance This is a repeat of prior year finding #2022-007. Criteria/Condition: 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. For SEFA reporting, federal expenditures were not disclosed for one program and were overstated or understated for other programs. Cause/Context: Expenditures for the Emergency Food and Shelter National Board Program were excluded from the client-prepared SEFA. There were various other grants with allocations between state and federal funding that were not presented properly on the SEFA. The SEFA presented has been adjusted for these errors. Effect: Controls in place did not sufficiently ensure the completeness and accuracy of the SEFA. Recommendation: We recommend the Organization enhance its procedures and controls to ensure data accumulated to prepare the SEFA is complete and accurate. Views of Responsible Officials and Planned Corrective Actions: The Organization will implement the following changes in its accounting procedures: The Schedule of Expenditures of Federal Awards (SEFA) will be reviewed for accuracy by either the CFO or CEO after it is produced, to ensure that all federal awards are included, and that the amounts on the schedule are accurate.

Categories

Reporting

Other Findings in this Audit

  • 393863 2023-005
    Significant Deficiency Repeat
  • 393864 2023-006
    Material Weakness
  • 393865 2023-007
    Significant Deficiency
  • 393866 2023-005
    Significant Deficiency Repeat
  • 393867 2023-006
    Material Weakness
  • 393868 2023-007
    Significant Deficiency
  • 393869 2023-005
    Significant Deficiency Repeat
  • 393870 2023-006
    Material Weakness
  • 393871 2023-007
    Significant Deficiency
  • 393872 2023-005
    Significant Deficiency Repeat
  • 393873 2023-006
    Material Weakness
  • 393874 2023-007
    Significant Deficiency
  • 393875 2023-011
    Significant Deficiency Repeat
  • 393876 2023-011
    Significant Deficiency Repeat
  • 393878 2023-008
    Material Weakness Repeat
  • 393879 2023-009
    Significant Deficiency
  • 393880 2023-010
    Material Weakness
  • 393881 2023-011
    Significant Deficiency Repeat
  • 393882 2023-008
    Material Weakness Repeat
  • 393883 2023-009
    Significant Deficiency
  • 393884 2023-010
    Material Weakness
  • 393885 2023-011
    Significant Deficiency Repeat
  • 393886 2023-008
    Material Weakness Repeat
  • 393887 2023-009
    Significant Deficiency
  • 393888 2023-010
    Material Weakness
  • 393889 2023-011
    Significant Deficiency Repeat
  • 393890 2023-008
    Material Weakness Repeat
  • 393891 2023-009
    Significant Deficiency
  • 393892 2023-010
    Material Weakness
  • 393893 2023-011
    Significant Deficiency Repeat
  • 393894 2023-008
    Material Weakness Repeat
  • 393895 2023-009
    Significant Deficiency
  • 393896 2023-010
    Material Weakness
  • 393897 2023-011
    Significant Deficiency Repeat
  • 393898 2023-008
    Material Weakness Repeat
  • 393899 2023-009
    Significant Deficiency
  • 393900 2023-010
    Material Weakness
  • 393901 2023-011
    Significant Deficiency Repeat
  • 393902 2023-011
    Significant Deficiency Repeat
  • 393903 2023-011
    Significant Deficiency Repeat
  • 393904 2023-011
    Significant Deficiency Repeat
  • 393905 2023-011
    Significant Deficiency Repeat
  • 393906 2023-011
    Significant Deficiency Repeat
  • 393907 2023-004
    Material Weakness
  • 393908 2023-004
    Material Weakness
  • 393909 2023-004
    Material Weakness
  • 393910 2023-004
    Material Weakness
  • 393911 2023-004
    Material Weakness
  • 393912 2023-004
    Material Weakness
  • 393913 2023-004
    Material Weakness
  • 393914 2023-004
    Material Weakness
  • 393915 2023-004
    Material Weakness
  • 393916 2023-004
    Material Weakness
  • 970305 2023-005
    Significant Deficiency Repeat
  • 970306 2023-006
    Material Weakness
  • 970307 2023-007
    Significant Deficiency
  • 970308 2023-005
    Significant Deficiency Repeat
  • 970309 2023-006
    Material Weakness
  • 970310 2023-007
    Significant Deficiency
  • 970311 2023-005
    Significant Deficiency Repeat
  • 970312 2023-006
    Material Weakness
  • 970313 2023-007
    Significant Deficiency
  • 970314 2023-005
    Significant Deficiency Repeat
  • 970315 2023-006
    Material Weakness
  • 970316 2023-007
    Significant Deficiency
  • 970317 2023-011
    Significant Deficiency Repeat
  • 970318 2023-011
    Significant Deficiency Repeat
  • 970319 2023-011
    Significant Deficiency Repeat
  • 970320 2023-008
    Material Weakness Repeat
  • 970321 2023-009
    Significant Deficiency
  • 970322 2023-010
    Material Weakness
  • 970323 2023-011
    Significant Deficiency Repeat
  • 970324 2023-008
    Material Weakness Repeat
  • 970325 2023-009
    Significant Deficiency
  • 970326 2023-010
    Material Weakness
  • 970327 2023-011
    Significant Deficiency Repeat
  • 970328 2023-008
    Material Weakness Repeat
  • 970329 2023-009
    Significant Deficiency
  • 970330 2023-010
    Material Weakness
  • 970331 2023-011
    Significant Deficiency Repeat
  • 970332 2023-008
    Material Weakness Repeat
  • 970333 2023-009
    Significant Deficiency
  • 970334 2023-010
    Material Weakness
  • 970335 2023-011
    Significant Deficiency Repeat
  • 970336 2023-008
    Material Weakness Repeat
  • 970337 2023-009
    Significant Deficiency
  • 970338 2023-010
    Material Weakness
  • 970339 2023-011
    Significant Deficiency Repeat
  • 970340 2023-008
    Material Weakness Repeat
  • 970341 2023-009
    Significant Deficiency
  • 970342 2023-010
    Material Weakness
  • 970343 2023-011
    Significant Deficiency Repeat
  • 970344 2023-011
    Significant Deficiency Repeat
  • 970345 2023-011
    Significant Deficiency Repeat
  • 970346 2023-011
    Significant Deficiency Repeat
  • 970347 2023-011
    Significant Deficiency Repeat
  • 970348 2023-011
    Significant Deficiency Repeat
  • 970349 2023-004
    Material Weakness
  • 970350 2023-004
    Material Weakness
  • 970351 2023-004
    Material Weakness
  • 970352 2023-004
    Material Weakness
  • 970353 2023-004
    Material Weakness
  • 970354 2023-004
    Material Weakness
  • 970355 2023-004
    Material Weakness
  • 970356 2023-004
    Material Weakness
  • 970357 2023-004
    Material Weakness
  • 970358 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $215,454
14.267 Continuum of Care Program $169,460
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $162,890
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $103,037
16.017 Sexual Assault Services Formula Program $74,585
93.136 Injury Prevention and Control Research and State and Community Based Programs $56,938
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $42,541
93.558 Temporary Assistance for Needy Families $30,990
16.021 Justice Systems Response to Families $30,768
97.024 Emergency Food and Shelter National Board Program $3,977