Finding 1168465 (2022-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2026-01-08

AI Summary

  • Core Issue: The School District lacked adequate controls to ensure the Schedule of Expenditures of Federal Awards (SEFA) accurately reflected federal expenditures.
  • Impacted Requirements: Compliance with Uniform Guidance 2 CFR §200.510, which mandates accurate reporting of federal awards, was not met.
  • Recommended Follow-Up: The School District should enhance training on SEFA requirements and establish a review process to ensure accurate reporting and reconciliation with the general ledger.

Finding Text

Finding 2022 – 003: Reporting: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Criteria: Uniform Guidance 2 CFR §200.510 requires an auditee to “prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements [that]… at a minimum shall…list individual Federal programs by Federal agency… [and] provide total Federal awards expenditures for each individual Federal program and the Assistance Listing Number (ALN) or other identifying number when the ALN information is not available.” In accordance with Uniform Guidance, the School District is required to maintain a structure of internal control to ensure compliance with applicable reporting requirements. Condition: During fiscal year 2022, the School District did not have sufficient controls in place to ensure the SEFA accurately reflected each award’s federal expenditures. There were differences noted in reconciling expenditures from the original SEFA to the trial balance. These errors were corrected through adjustments proposed as part of the audit, and the final version of the SEFA reconciles to the School District’s general ledger. Questioned Costs: None. Cause: Insufficient training or understanding of Uniform Guidance, including some of the required elements of the SEFA, contributed to this finding. Effect: The School District could not produce an accurate and timely SEFA, which required additional effort and resources by the School District and auditor during the audit process. Recommendation: We recommend that the School District becomes familiar with the SEFA reporting elements required by Uniform Guidance and develop and implement a review process to ensure compliance with those reporting requirements. These processes and controls should include reconciling SEFA federal expenditures to the current year general ledger expenditures and reviewing other grant related information to ensure accuracy. Views of Responsible Officials: See the corrective action plan that accompanies the schedule of findings and questioned costs.

Corrective Action Plan

Finding 2022 – 003: Reporting: Preparation of the Schedule of Expenditures of Federal Awards (SEFA) Response: For the audit period and subsequent audit periods the employee responsible for the SEFA did not prepare the SEFA for the audit. For future audit periods the SEFA will be prepared by the Financial Consultant.

Categories

Reporting

Other Findings in this Audit

  • 1168466 2022-004
    Material Weakness Repeat
  • 1168467 2022-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.041 IMPACT AID $3.37M
84.425 EDUCATION STABILIZATION FUND $264,422
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $178,588
84.287 TWENTY-FIRST CENTURY COMMUNITY LEARNING CENTERS $66,518
10.553 SCHOOL BREAKFAST PROGRAM $29,834
84.027 SPECIAL EDUCATION GRANTS TO STATES $23,292
84.060 INDIAN EDUCATION GRANTS TO LOCAL EDUCATIONAL AGENCIES $19,750
10.555 NATIONAL SCHOOL LUNCH PROGRAM $4,385
10.579 CHILD NUTRITION DISCRETIONARY GRANTS LIMITED AVAILABILITY $3,863
84.358 RURAL EDUCATION $199