FA 2022-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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-001 Strengthen Controls over Expenditures Compliance Requirements: Activities Allowed or Unallowed Allowable Costs/Cost Principles Period of Performance Internal Control Impact: Significant Deficiency Compliance Impact: Nonmaterial 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: $108,220 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed that the School District?s internal control procedures were not operating appropriately to ensure that expenditures were allowable for the 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.403 ? Factors Affecting Allowability of Costs state that ?costs must meet the following general criteria in order to be allowable under Federal awards: (a) Be necessary and reasonable for the performance of the Federal award and be allocable thereto under these principles, (b) Conform to any limitations or exclusions set forth in these principles or in the Federal award as to types or amount of cost items, (c) Be consistent with policies and procedures that apply uniformly to both federally-financed and other activities of the non-Federal entity? (g) Be adequately documented? (h) Cost must be incurred during the approved budget period?? Additionally, provisions included in the Uniform Guidance, Section 200.77 state, ?Period of performance means the time during which the non-Federal entity may incur new obligations to carry out the work authorized under the Federal award.? Further, to assist school districts in improving their financial management systems and associated compliance over federal programs, GaDOE published the Financial Management for Georgia Local Units of Administration (FMGLUA) manual. The FMGLUA manual requires that LEAs submit a budget as part of each federal program?s Consolidated Application process. The program budget reflects details regarding the manner in which each school district intends to expend the program funds. The Consolidated Application, including the budget, for each program must be reviewed and approved by GaDOE personnel before the LEA is authorized to expend program funds. Amendments to the budget are to be submitted to and approved by GaDOE when a school district intends to spend funds in a manner not initially reported. Condition: A sample of 60 non-personal services expenditures was randomly selected for testing using a non-statistical sampling approach. In addition, equipment purchases were tested. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. This testing revealed the following deficiencies: ? Eight bus cameras, including installation fees, were purchased but were not installed and placed in service. These cameras were reflected on the Consolidated Application approved by GaDOE; however, the detailed budget line item stated that the cameras were to be installed and utilized, not stored in the event of future bus purchases. Therefore, $37,973 of these expenditures were deemed unallowable. ? Subscription charges related to bus cameras purchased were paid for a five-year period. Because the period of performance for this funding ends on September 30, 2024 and the liquidation period for the program ends 120 days thereafter, $69,034 of these expenditures were incurred after the period performance and deemed unallowable. ? One expenditure totaling $1,213 was not approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $257,408 in non-personal services expenditures, known questioned costs of $1,213 were identified. Using the total non-personal services expenditures population of $6,472,730, we project the likely questioned costs to be approximately $30,501. In addition, known questioned costs of $107,007 were also identified for expenditures that were not tested as part of a sample and were not incurred for a necessary and reasonable purpose and/or during the appropriate period. Therefore, the known questioned costs identified for the ESSER program totaled $108,220. Cause: In discussing these deficiencies with management, they stated that the Consolidated Application included the unallowable items purchased; however, the description reflected on the Consolidated Application did not agree to the items purchased. In addition, management was unaware that extra equipment and the multi-year service agreements on equipment were not allowable expenditures. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Additionally, failure to verify compliance with applicable policies and regulations, including reviewing approved budgets prior to the expenditure of federal program funds and ensuring that expenditures are incurred for a necessary and reasonable purpose and within the appropriate period of performance, may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with unapproved and unallowable expenditures. Recommendation: The School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process, fall within the respective federal program?s period of performance, and are deemed to be allowable before spending federal funds. 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. 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.