Finding 374273 (2023-003)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-03-06

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) did not match the accounting records and missed some federal awards.
  • Impacted Requirements: Compliance with 2 CFR Subpart F Section 200.510b, which mandates accurate reporting of federal expenditures.
  • Recommended Follow-up: Prepare the SEFA based on actual federal expenditures and establish a management review process for accuracy and completeness.

Finding Text

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 initial SEFA provided for audit did not agree to the accounting system general ledger expenditures for certain awards. In addition, not all federal awards were appropriately identified and included on the SEFA. Cause: PPHS had significant turnover in finance personnel during the 22-23 school year. In addition, the SEFA was prepared utilizing federal award revenue. Lastly, one award was incorrectly identified as other revenue instead of federal award revenue. Effect: The total federal award expenditures reported on the initial SEFA were reduced by $198,208. The following awards were reduced on the SEFA to agree to award expenditures by the following amounts: National School Lunch Program 10.555 $125,864, Charter Schools Program 84.282A $32,555, Elementary and Secondary School Emergency Relief 84.425D $92,405, and Emergency Connectivity Fund 32.009 $109,450. The following award was added to the SEFA Coronavirus State and Local Fiscal Recovery Funds 21.027 $164,766. Recommendation: PPHS should prepare the SEFA based on federal award expenditures, rather than revenue. In addition, 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

Criteria: According to 2 CFR Subpart F Section 200.51Ob, 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 initial SEFA provided for audit did not agree to the accounting system general ledger expenditures for certain awards. In addition, not all federal awards were appropriately identified and included on the SEFA. Cause: PPHS had significant turnover in finance personnel during the 22-23 school year. In addition, the SEFA was prepared utilizing federal award revenue. Lastly, one award was incorrectly identified as other revenue instead of federal award revenue. Effect: The total federal award expenditures reported on the initial SEFA were reduced by $198,208. The following awards were reduced on the SEFA to agree to award expenditures by the following amounts: National School Lunch Program 10.555 $125,864, Charter Schools Program 84.282A $32,555, Elementary and Secondary School Emergency Relief 84.425D $92,405, and Emergency Connectivity Fund 32.009 $109,450. The following award was added to the SEFA Coronavirus State and Local Fiscal Recovery Funds 21.027 $164,766. Corrective Action Plan - PPHS had significant turnover in finance personnel during the 22-23 school year. For FY24, we contracted with accounting consultants to assist with improving grant tracking and reporting. We posted a Staff Accountant position in January 2023 to assist with internal grant management and are hoping to fill this position in FY24 03. Contact Person(s) Responsible for CAP- Todd Burleson, Financial Controller. Anticipated completion date - Processes were improved in FY24 through assistance from accounting consultants. We anticipate hiring a Staff Accountant before 3/31/24.

Categories

Reporting

Other Findings in this Audit

  • 374274 2023-003
    Material Weakness
  • 374275 2023-003
    Material Weakness
  • 374276 2023-003
    Material Weakness
  • 374277 2023-003
    Material Weakness
  • 374278 2023-003
    Material Weakness
  • 950715 2023-003
    Material Weakness
  • 950716 2023-003
    Material Weakness
  • 950717 2023-003
    Material Weakness
  • 950718 2023-003
    Material Weakness
  • 950719 2023-003
    Material Weakness
  • 950720 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.282 Charter Schools $519,770
84.010 Title I Grants to Local Educational Agencies $459,839
21.027 Coronavirus State and Local Fiscal Recovery Funds $164,766
84.027 Special Education_grants to States $20,812
84.354 Credit Enhancement for Charter School Facilities $14,899
10.555 National School Lunch Program $14,530
84.425 Education Stabilization Fund $14,024
84.424 Student Support and Academic Enrichment Program $10,000
84.367 Improving Teacher Quality State Grants $4,072