Finding 31792 (2022-003)

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

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was inaccurately prepared, missing key federal program expenditures.
  • Impacted Requirements: Compliance with Uniform Guidance Subpart F section 200.510, which mandates accurate reporting of federal awards and expenditures.
  • Recommended Follow-Up: Enhance controls and review processes to ensure all federal expenditures are correctly identified and reported on the SEFA.

Finding Text

2022-003) Preparation of Schedule of Expenditures and Federal Awards Questioned Costs: N/A Assistance Listing Numbers Name of Federal Program or Cluster 97.036 Disaster Grants-Public Assistance (Presidentially Declared Disasters) 84.425D ?Achieve? ? COVID-19 - ESSER II Formula 32.009 Emergency Connectivity Fund Criteria: The Uniform Guidance Subpart F section 200.510 requires the preparation of the Schedule of Expenditures of Federal Awards (SEFA) that includes an accurate reporting of federal awards expended based on the terms and conditions of the grants along with the amount of funds disbursed to sub-recipients. In order for the SEFA to be prepared accurately and properly report the amounts expended for federal awards, a system of controls should be in existence that includes the identification of federal expenditures, timely and accurate preparation and review of the amounts reported on the SEFA. Condition: The initial SEFA prepared by the School Bord?s did not accurately include or identify all the federal program expenditures. Universe/ Population: None Sample size: None Cause: The grant awards or agreements were not properly interpreted or reviewed to identify or determine the proper amount to be reported as expenditures or SEFA. Effect: The SEFA provided to us for audit did not contain all the federal programs or the correct amounts of federal expenditures based on the terms of the grant awards and requirements to reporting on some of the federal programs reported. Inaccuracies or excluding information on the SEFA causes delays in completing the single audit and risks filing a SEFA that is incomplete or inaccurate. Recommendation: The School Board should strengthen its controls including its review and approval processes over the identification of federal programs, and the information and balances that are accumulated and reported on the SEFA to make sure the expenditures reported are an accurate representation of federal expenditures. View of Responsible Official: Management agrees with finding. Disaster Grants through FEMA are managed by rules and processes that are not easily accounted for in traditional accounting systems. ESSER II and III grants relatively new and designed to be implemented over multiple years leading to shifting of expenditures from one grant to another depending on spending priorities. Procedures will be strengthened to fully and accurately identify all federal program expenditures and record in the appropriate accounting funds.

Corrective Action Plan

2022-003) Preparation of Schedule of Expenditures and Federal Awards CFDA Listing Numbers Name of Federal Program or Cluster 97.036 Disaster Grants-Public Assistance (Presidentially Declared Disasters) 84.425D ?Achieve? ? COVID-19 - ESSER II Formula 32.009 Emergency Connectivity Fund Disaster Grants through FEMA are managed by rules and processes that are not easily accounted for in traditional accounting systems. ESSER II and III grants are relatively new and designed to be implemented over multiple years leading to shifting of expenditures from one grant to another depending on spending priorities which can change. Grant coordination supervisor has been instructed to notify Director of Accounting and provide documentation when such changes take place. Procedures will be strengthened to fully and accurately identify all federal program expenditures and record in the appropriate accounting funds. Persons responsible: Wilfred Bourne, Chief Financial Officer; Dennis Bent, Director of Accounting Expected Completion date: December, 2023

Categories

Reporting

Other Findings in this Audit

  • 31793 2022-003
    Material Weakness
  • 31794 2022-003
    Material Weakness
  • 31795 2022-004
    Material Weakness
  • 608234 2022-003
    Material Weakness
  • 608235 2022-003
    Material Weakness
  • 608236 2022-003
    Material Weakness
  • 608237 2022-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $130.46M
84.010 Title I Grants to Local Educational Agencies $14.43M
10.555 National School Lunch Program $12.25M
84.425 Education Stabilization Fund $9.04M
84.027 Special Education_grants to States $6.64M
10.553 School Breakfast Program $3.13M
93.600 Head Start $3.08M
93.434 Every Student Succeeds Act/preschool Development Grants $1.76M
84.367 Improving Teacher Quality State Grants $1.55M
84.371 Comprehensive Literacy Development $826,104
32.009 Emergency Connectivity Fund Program $825,352
84.424 Student Support and Academic Enrichment Program $590,355
84.048 Career and Technical Education -- Basic Grants to States $494,489
93.575 Child Care and Development Block Grant $319,914
84.173 Special Education_preschool Grants $289,122
84.126 Rehabilitation Services_vocational Rehabilitation Grants to States $140,258
84.196 Education for Homeless Children and Youth $101,926
84.365 English Language Acquisition State Grants $79,573
12.U02 Department of the Navy - Jrotc $73,163
10.582 Fresh Fruit and Vegetable Program $60,426
12.U01 Department of the Army - Jrotc $41,723
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $40,799
84.377 School Improvement Grants $19,904
93.981 Improving Student Health and Academic Achievement Through Nutrition, Physical Activity and the Management of Chronic Conditions in Schools $9,937
10.559 Summer Food Service Program for Children $1,145