Finding Text
Assistance Listing Number, Federal Agency, and Program Name - 84.425D, U.S. Department of Education, COVID 19 ESSER Formula Fund II 11r(2) and COVID 19 ESSER Formula Fund II Learning Loss 98c
Finding Type - Significant deficiency
Criteria - Per 2 CFR 200.510(b) and Section 500.508(b) of Title 2, Subtitle A, Chapter II, Part 200, Subpart F, auditees must prepare a schedule of expenditures of federal awards for the period covered by the auditee's financial statements, which must include the total federal awards expended as determined in accordance with Section 200.502. While not required, the auditee may choose to provide information requested by federal awarding agencies and pass through entities to make the schedule easier to use.
Condition - The schedule of expenditures of federal awards (SEFA) was not complete, as it omitted expenditures from two federal awards.
Questioned Costs - None
Identification of How Questioned Costs Were Computed - N/A
Context - Two grants were omitted from the SEFA prepared by management totaling $816,904 in expenditures, which was identified by the auditor during the annual audit and subsequently included on the SEFA. Expenditures were recorded in the School District's general ledger but were excluded from the School District's preparation of the SEFA.
Cause and Effect - The School District did not have sufficient controls in place to properly reconcile federal revenue to the federal expenditures reflected on the SEFA to validate that all federal grants awarded and expended were included in the SEFA.
Recommendation - The School District should implement a process to ensure that the SEFA is prepared timely and that all grant expenditures are included accurately.
Views of Responsible Officials and Corrective Action Plan - The School District will develop a SEFA checklist to help ensure all federal expenditures are properly reported. Additional processes will be put in place by management to review the SEFA in advance of the annual audit to effectively meet audit report timelines and help ensure completeness, validity, and accuracy of the final SEFA reporting.