Finding 42410 (2022-003)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-03-23

AI Summary

  • Core Issue: Grant tracking spreadsheets for federal awards were not updated or reviewed properly.
  • Impacted Requirements: Internal controls over federal awards were insufficient, violating CFR Section 200.302.
  • Recommended Follow-up: Provide staff training, implement management reviews of spreadsheets, and perform monthly reconciliations.

Finding Text

Finding 2022-003 Assistance Listing Number: 14.231 Name of Federal Program or Cluster: Emergency Solutions Grant Program Name of Federal Agency: Department of Housing and Urban Development Name of Pass-through Entities: Wisconsin Department of Administration and City of Racine Criteria or Specific Requirement: The Code of Federal Regulations (CFR) Section 200.302 requires that nonfederal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the nonfederal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: Management?s grant tracking spreadsheets for federal awards were not properly updated or reviewed during the year. Cause: Due to staff turnover during the year, sufficient training for preparing grant tracking spreadsheets was not provided for new staff and no monitoring of this process was performed to ensure it was completed in a timely manner. Effect or Potential Effect: Unallowable costs could be charged to federal awards and not be detected and corrected. Repeat Finding: No Recommendation: We recommend the Organization provide additional training to staff responsible for tracking federal and state awards and utilize another member of management to review and approve the grant tracking spreadsheets routinely. Additionally, we recommend reconciliations be performed monthly between the grant spreadsheets and the financial reporting software.

Categories

Allowable Costs / Cost Principles Subrecipient Monitoring Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 42406 2022-003
    Significant Deficiency
  • 42407 2022-004
    Significant Deficiency
  • 42408 2022-003
    Significant Deficiency
  • 42409 2022-004
    Significant Deficiency
  • 42411 2022-004
    Significant Deficiency
  • 42412 2022-003
    Significant Deficiency
  • 42413 2022-004
    Significant Deficiency
  • 618848 2022-003
    Significant Deficiency
  • 618849 2022-004
    Significant Deficiency
  • 618850 2022-003
    Significant Deficiency
  • 618851 2022-004
    Significant Deficiency
  • 618852 2022-003
    Significant Deficiency
  • 618853 2022-004
    Significant Deficiency
  • 618854 2022-003
    Significant Deficiency
  • 618855 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.267 Continuum of Care Program $493,780
21.027 Coronavirus State and Local Fiscal Recovery Funds $220,000
14.231 Emergency Solutions Grant Program $137,758
93.558 Temporary Assistance for Needy Families $83,793