Finding 3577 (2022-002)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-12-06

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) did not include the Emergency Connectivity Fund Program, leading to an understatement of $81,750.
  • Impacted Requirements: Compliance with 2 CFR Subpart F Section 200.510b, which mandates a complete SEFA for federal program expenditures.
  • Recommended Follow-Up: Establish a review process for the SEFA involving key management to ensure all federal programs are accurately reported.

Finding Text

Identification of federal program: FEDERAL COMMUNICATIONS COMMISSION 32.009 Emergency Connectivity Fund Program passed through the Indiana Department of Education. Criteria: According to 2 CFR Subpart F Section 200.510b, the auditee must preapre a Schedule of Expenditures of Federal Awards (SEFA) for the period that includes all amounts spent on federal programs during the reporting period.Condition: The SEFA excluded the Emergency Connectivity Fund Program and was materially understated by $81,750.Cause: Grant agreements were not stored in a centralized location accessible to key members of management and the outsourced accountant.Effect: An audit adjustment was made to increase grant receivable and revenue by $494,757 in 2021 and adjust 2022 grant receivable, net assets with donor restriction, and revenue.Recommendation: PPHS should implement a review process for the SEFA whereby key members of management review the SEFA for completeness.Views of responsible officials: See attached corrective action plan.

Corrective Action Plan

2022-002 Criteria – According to 2 CFR Subpart F Section 200.510b, the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition – The SEFA excluded the Emergency Connectivity Fund Program and was materially understated by $81,750. Cause – PPHS had significant turnover in finance personnel during and after the 21-22 school year. Effect – An audit adjustment was made to add the Emergency Connectivity Fund Program expenditures of $81,750 to the SEFA. The increase in expenditures resulted in the selection of an additional major program to achieve the audit coverage required by the Uniform Guidance. Corrective Action Plan – PPHS had significant turnover in finance personnel during the 22-23 school year. PPHS hired a full-time Financial Controller on July 31st, 2023 and has been working with accounting consultants to improve processes and procedures throughout FY23. We will implement a review process for the SEFA whereby key members of management review the SEFA for completeness. Responsible for CAP – Todd Burleson, Financial Controller. Anticipated completion date – Processes were improved in FY23 through assistance from accounting consultants. Policies and procedures updates will be implemented in FY24.

Categories

Reporting

Other Findings in this Audit

  • 3576 2022-003
    Significant Deficiency
  • 580018 2022-003
    Significant Deficiency
  • 580019 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $520,235
84.010 Title I Grants to Local Educational Agencies $444,616
10.555 National School Lunch Program $302,815
32.009 Emergency Connectivity Fund Program $81,750
84.367 Improving Teacher Quality State Grants $9,202