Finding 258541 (2022-004)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-03-29

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) contained errors and did not accurately reflect the actual expenditures for several programs.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations Part 200, which mandates accurate reporting of federal awards and expenditures.
  • Recommended Follow-Up: Management should enhance SEFA preparation procedures, ensure a qualified accountant prepares it, and have it reviewed by the Chief Financial Officer or an equivalent.

Finding Text

Federal Program: All Criteria or Specific Requirement - Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Section 508 ? Auditee Responsibilities, requires the auditee to prepare a schedule of expenditures of federal awards. The schedule must provide the total federal awards expended for each individual federal program and the Assistance Listings Number. Condition - While performing audit procedures on the initial schedule of expenditures of federal awards (?SEFA?) provided, we noted several errors in the reported amounts as expenditures of federal awards. Cause - The internal controls in place to report expenditures of federal awards for reporting on the SEFA were not operating effectively. Effect - The initial SEFA did not accurately reflect the expenditures of federal awards for several programs. Questioned Costs - None Context - In performing audit procedures over the initial SEFA, we identified discrepancies for two programs where the expenditures of federal awards listed on the initial SEFA did not agree with confirmations received from the corresponding cognizant agency. Additionally, in performing audit procedures over grants, we identified three programs where the expenditures of federal awards were not included in the original SEFA. The final and correct amounts for those programs were $36,835. Repeat Finding - No Recommendation - We recommend that management review the current procedures in place for preparation of the SEFA. We also recommend that the SEFA be prepared by a qualified individual in the accounting department, and that review is performed by the Chief Financial Officer, or an equivalent individual.

Corrective Action Plan

Views of Responsible Officials and Planned Corrective Actions - Management concurs the initial Schedule of Federal Awards was prepared using the total program expenditures and not the program expenditures incurred using just the federal portion of the program funding. Unfortunately, information regarding the federal versus non-federal breakdown of awards is not available in initial program contracts. This information is only disclosed as part of the confirmation process. Management has begun working with the new accounting service provider to be cognizant of the program expenditures by funding source through the year. Management will also work closely with the auditors to ensure funding allocations per confirmations, if different than projected, are reflected properly in the Schedule of Federal Awards.

Categories

Reporting

Other Findings in this Audit

  • 258540 2022-003
    Significant Deficiency Repeat
  • 258542 2022-005
    -
  • 834982 2022-003
    Significant Deficiency Repeat
  • 834983 2022-004
    Significant Deficiency
  • 834984 2022-005
    -

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $1.07M
84.287 Twenty-First Century Community Learning Centers $255,468
16.726 Juvenile Mentoring Program $210,981
10.558 Child and Adult Care Food Program $206,200
14.881 Moving to Work Demonstration Program $140,114
10.599 South Carolina Snap Recipient Trafficking Prosecution Pilot $76,958
16.738 Edward Byrne Memorial Justice Assistance Grant Program $60,428
84.425 Education Stabilization Fund $36,835