Finding 47769 (2022-002)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2023-05-23

AI Summary

  • Core Issue: The School District lacks adequate controls over equipment management, leading to a material weakness and noncompliance with federal requirements.
  • Impacted Requirements: Failure to maintain complete property records and conduct effective reconciliations violates Uniform Guidance and GaDOE guidelines.
  • Recommended Follow-Up: Develop a comprehensive equipment listing that includes all necessary details and ensure regular reconciliations to prevent misuse of federal funds.

Finding Text

FA 2022-002 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425U ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425W ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund ? Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over equipment and real property management as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $12,214,096 were expended and reported on the Tattnall County Board of Education?s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2022. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 ? Internal Controls. Provisions included in the Uniform Guidance, Section 200.313(d)(1) state, ?Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property.? In addition, the Uniform Guidance, Section 200.313(d)(2) states, ?A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years.? Condition: The following deficiencies were noted when reviewing the ESSER program equipment listing and physically locating five equipment items: ? Property records did not include the following required components for all items tested: (1) A description of the property, (2) a serial number or other identification number, (3) the source of funding for the property (including the FAIN), (4) who holds title, (5) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (6) the location, and (7) use and condition of the property. ? Two pieces of equipment with costs totaling $19,387 could not be physically located based on information included in the property records, and these items reflected serial numbers that did not agree to accounting records. ? The appropriate safeguarding and maintenance of three pieces of equipment with costs totaling $105,674 could not be determined based on the information included within the property records. ? While a physical inventory was performed, the results were not effectively reconciled to the equipment listing. Cause: In discussing these deficiencies with management, they stated that there are multiple inventory lists maintained by various personnel; however, there was no consistency among the listings. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to maintain a complete and accurate equipment listing and reconcile results of the physical inventory performed to the property records exposes the School District to unnecessary risk of error and misuse of equipment and/or federal funds. Recommendation: The School District should develop and maintain an equipment listing that reflects all required information, including a description, an identifying number, the source of funding, the title holder, the acquisition date, the cost, the percentage of federal participation in the project costs, the location, the use and condition, and any ultimate disposal data for each piece of equipment. In addition, management should implement controls to ensure that a complete physical inventory of equipment is performed, and the results are reconciled back to the equipment listing at least once every two years. Further, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding. FA 2022-002 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management Internal Control Impact: Material Weakness Compliance Impact: Material Noncompliance Federal Awarding Agency: U.S. Department of Education Pass-Through Entity: Georgia Department of Education AL Numbers and Titles: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425U ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund COVID-19 ? 84.425W ? American Rescue Plan Elementary and Secondary School Emergency Relief Fund ? Homeless Children and Youth Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021), S425W210011 (Year: 2021) Questioned Costs: None Identified Description: The policies and procedures of the School District were insufficient to provide adequate internal controls over equipment and real property management as it relates to the Elementary and Secondary School Emergency Relief Fund program. Background: On March 27, 2020, the Coronavirus Aid, Relief, and Economic Security (CARES) Act was signed into law. The CARES Act was designed to mitigate the economic effects of the COVID-19 pandemic in a variety of ways, including providing additional funding for local educational agencies (LEAs) navigating the impact of the COVID-19 outbreak. Provisions included in Title VIII of the CARES Act created the Education Stabilization Fund to provide financial resources to educational entities to prevent, prepare for, and respond to coronavirus. The CARES Act allocated $30.75 billion, the Coronavirus Response and Relief Supplemental Appropriations Act allocated an additional $81.9 billion, and the American Rescue Plan Act added $165.1 billion in funding to the Education Stabilization Fund. Multiple Education Stabilization Fund subprograms were created and allotted funding through the various COVID-19-related legislation. Of these programs, the Elementary and Secondary School Emergency Relief (ESSER) Fund was created to address the impact that COVID-19 has had, and continues to have, on elementary and secondary schools across the nation. ESSER funding was granted to the Georgia Department of Education (GaDOE) by the U.S. Department of Education (ED). GaDOE is responsible for distributing funds to LEAs and overseeing the expenditure of funds by LEAs. ESSER funds totaling $12,214,096 were expended and reported on the Tattnall County Board of Education?s Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2022. Criteria: As a recipient of federal awards, the School District is required to establish and maintain effective internal control over federal awards that provides reasonable assurance of managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards pursuant to Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), Section 200.303 ? Internal Controls. Provisions included in the Uniform Guidance, Section 200.313(d)(1) state, ?Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property.? In addition, the Uniform Guidance, Section 200.313(d)(2) states, ?A physical inventory of the property must be taken, and the results reconciled with the property records at least once every two years.? Condition: The following deficiencies were noted when reviewing the ESSER program equipment listing and physically locating five equipment items: ? Property records did not include the following required components for all items tested: (1) A description of the property, (2) a serial number or other identification number, (3) the source of funding for the property (including the FAIN), (4) who holds title, (5) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (6) the location, and (7) use and condition of the property. ? Two pieces of equipment with costs totaling $19,387 could not be physically located based on information included in the property records, and these items reflected serial numbers that did not agree to accounting records. ? The appropriate safeguarding and maintenance of three pieces of equipment with costs totaling $105,674 could not be determined based on the information included within the property records. ? While a physical inventory was performed, the results were not effectively reconciled to the equipment listing. Cause: In discussing these deficiencies with management, they stated that there are multiple inventory lists maintained by various personnel; however, there was no consistency among the listings. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to maintain a complete and accurate equipment listing and reconcile results of the physical inventory performed to the property records exposes the School District to unnecessary risk of error and misuse of equipment and/or federal funds. Recommendation: The School District should develop and maintain an equipment listing that reflects all required information, including a description, an identifying number, the source of funding, the title holder, the acquisition date, the cost, the percentage of federal participation in the project costs, the location, the use and condition, and any ultimate disposal data for each piece of equipment. In addition, management should implement controls to ensure that a complete physical inventory of equipment is performed, and the results are reconciled back to the equipment listing at least once every two years. Further, management should develop and implement a monitoring process to ensure that control procedures are being followed. Views of Responsible Officials: We concur with this finding.

Categories

Equipment & Real Property Management Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 47764 2022-001
    Significant Deficiency
  • 47765 2022-002
    Material Weakness
  • 47766 2022-001
    Significant Deficiency
  • 47767 2022-002
    Material Weakness
  • 47768 2022-001
    Significant Deficiency
  • 624206 2022-001
    Significant Deficiency
  • 624207 2022-002
    Material Weakness
  • 624208 2022-001
    Significant Deficiency
  • 624209 2022-002
    Material Weakness
  • 624210 2022-001
    Significant Deficiency
  • 624211 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $2.11M
10.553 School Breakfast Program $620,369
10.555 National School Lunch Program $568,873
84.371 Striving Readers $399,782
84.011 Migrant Education_state Grant Program $139,081
84.027 Special Education_grants to States $136,775
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $109,392
84.358 Rural Education $83,495
84.048 Career and Technical Education -- Basic Grants to States $39,675
93.575 Child Care and Development Block Grant $36,522
84.425 Education Stabilization Fund $33,027
84.365 English Language Acquisition State Grants $28,453
84.173 Special Education_preschool Grants $3,527
84.424 Student Support and Academic Enrichment Program $848