Finding 511964 (2024-001)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2024-11-25

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was improperly prepared, missing one Federal award and mislabeling others.
  • Impacted Requirements: Internal controls over compliance and financial management were insufficient, violating 2 CFR 200.303.
  • Recommended Follow-Up: Management should implement a review process where the Director of Operations approves the SEFA to ensure accuracy and completeness.

Finding Text

Finding: 2024-001: Improper Preparation of the Schedule of Expenditures of Federal Awards Information on the Federal Program: Assistance Listing Numbers 21.027 and 21.019 Criteria or Specific Requirement: According to 2 CFR 200.303, non-Federal entities should establish and maintain effective internal controls over compliance and financial management and reporting. These internal controls should be in compliance with guidance in the “Internal Control Integrated Framework,” issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). These controls should include timely reconciliation of Federal grant expenditures to ensure that the Schedule of Expenditures of Federal Awards (SEFA) is accurate and complete. Condition: During our audit procedures over the SEFA, we noticed that one Federal award (ALN 21.027) was not included on the SEFA when it should have been included. In addition, one award was improperly labeled as being a part of ALN 21.027, when it was in fact determined to be included in ALN 21.019. We also discovered another award was included in the SEFA, when it was determined that the award was not Federally funded and should have been removed from the SEFA. Cause: The identified condition was attributable to lack of sufficient internal control and review procedures in place over the SEFA. The award not included on the SEFA when it should have been was tracked within the accounting system as a Federal award, but was not properly recorded on the SEFA. The award tracked with the incorrect ALN and the award that was recorded on the SEFA when it should have been removed were both caused by error. Effect or Potential Effect: Significant time was required to receive an appropriately completed and accurate SEFA from management during the audit. Failure to provide an accurate SEFA during the audit could result in an incorrect major program determination and incomplete testing over the SEFA. Questioned Costs: N/A - Management ultimately corrected the errors identified during preparation of the SEFA. Context: We test the accuracy of the SEFA information by tracing to the grant agreements. Identification as a Repeat Finding: Not a repeat finding. Recommendation: We recommend that management design and implement a procedure to ensure that the SEFA, once prepared by the accounting team, is reviewed and approved by the Director of Operations to ensure that all Federal awards are properly included and tracked on the SEFA.

Categories

Reporting

Other Findings in this Audit

  • 511963 2024-001
    Significant Deficiency
  • 1088405 2024-001
    Significant Deficiency
  • 1088406 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
17.235 Senior Community Service Employment Program $1.43M
17.258 Wioa Adult Program $1.42M
17.259 Wioa Youth Activities $711,384
21.019 Coronavirus Relief Fund $583,327
21.027 Coronavirus State and Local Fiscal Recovery Funds $524,021
17.278 Wioa Dislocated Worker Formula Grants $160,114
93.558 Temporary Assistance for Needy Families $150,386
17.268 H-1b Job Training Grants $96,203
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $571