FA 2022-001 Improve Budgetary Controls over Expenditures Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Number and Title: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) Questioned Costs: $62,747.69 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed instances in which expenditures had not been properly approved by the pass-through entity. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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?? 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. Further, LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 ? Required Certifications, and include provisions that require LEAs ?to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets?? Condition: A sample of 60 nonpersonal services expenditures was randomly selected for testing using a non-statistical sampling approach. Four individually significant items were also selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Upon completing this testing, it was noted that three individually significant items totaling $48,037.69 and two randomly selected expenditures totaling $14,710.00 were not appropriately approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $2,037,733.28 in nonpersonal services expenditures, known questioned costs of $14,710.00 were identified. Using the total nonpersonal services expenditure population of $47,278,482.26, we project the likely questioned costs to be approximately $798,116.60. In addition, known questioned costs identified for improper payments associated with individually significant items tested totaled $48,037.69; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $62,747.69 and $846,154.29, respectively. Cause: In discussing these deficiencies with management, they stated that inadequate staffing levels led to the School District?s failure to establish appropriate internal control procedures, such as a review by appropriate personnel to ensure compliance with the Consolidated Application prior to the expenditure of federal funds. Additionally, the existence of multiple programs and associated Consolidated Applications led to the School District?s failure to establish appropriate internal control procedures to ensure the expenditure was approved on the specific Consolidated Application that funded the expenditure. Effect: The School District was not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to accurately develop and amend budget information through the Consolidated Application process and verify compliance with applicable policies and regulations prior to the expenditure of federal program funds 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 revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. In addition, 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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 Improve Budgetary Controls over Expenditures Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Number and Title: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) Questioned Costs: $62,747.69 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed instances in which expenditures had not been properly approved by the pass-through entity. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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?? 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. Further, LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 ? Required Certifications, and include provisions that require LEAs ?to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets?? Condition: A sample of 60 nonpersonal services expenditures was randomly selected for testing using a non-statistical sampling approach. Four individually significant items were also selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Upon completing this testing, it was noted that three individually significant items totaling $48,037.69 and two randomly selected expenditures totaling $14,710.00 were not appropriately approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $2,037,733.28 in nonpersonal services expenditures, known questioned costs of $14,710.00 were identified. Using the total nonpersonal services expenditure population of $47,278,482.26, we project the likely questioned costs to be approximately $798,116.60. In addition, known questioned costs identified for improper payments associated with individually significant items tested totaled $48,037.69; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $62,747.69 and $846,154.29, respectively. Cause: In discussing these deficiencies with management, they stated that inadequate staffing levels led to the School District?s failure to establish appropriate internal control procedures, such as a review by appropriate personnel to ensure compliance with the Consolidated Application prior to the expenditure of federal funds. Additionally, the existence of multiple programs and associated Consolidated Applications led to the School District?s failure to establish appropriate internal control procedures to ensure the expenditure was approved on the specific Consolidated Application that funded the expenditure. Effect: The School District was not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to accurately develop and amend budget information through the Consolidated Application process and verify compliance with applicable policies and regulations prior to the expenditure of federal program funds 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 revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. In addition, 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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 Improve Budgetary Controls over Expenditures Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Number and Title: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) Questioned Costs: $62,747.69 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed instances in which expenditures had not been properly approved by the pass-through entity. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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?? 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. Further, LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 ? Required Certifications, and include provisions that require LEAs ?to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets?? Condition: A sample of 60 nonpersonal services expenditures was randomly selected for testing using a non-statistical sampling approach. Four individually significant items were also selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Upon completing this testing, it was noted that three individually significant items totaling $48,037.69 and two randomly selected expenditures totaling $14,710.00 were not appropriately approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $2,037,733.28 in nonpersonal services expenditures, known questioned costs of $14,710.00 were identified. Using the total nonpersonal services expenditure population of $47,278,482.26, we project the likely questioned costs to be approximately $798,116.60. In addition, known questioned costs identified for improper payments associated with individually significant items tested totaled $48,037.69; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $62,747.69 and $846,154.29, respectively. Cause: In discussing these deficiencies with management, they stated that inadequate staffing levels led to the School District?s failure to establish appropriate internal control procedures, such as a review by appropriate personnel to ensure compliance with the Consolidated Application prior to the expenditure of federal funds. Additionally, the existence of multiple programs and associated Consolidated Applications led to the School District?s failure to establish appropriate internal control procedures to ensure the expenditure was approved on the specific Consolidated Application that funded the expenditure. Effect: The School District was not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to accurately develop and amend budget information through the Consolidated Application process and verify compliance with applicable policies and regulations prior to the expenditure of federal program funds 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 revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. In addition, 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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 Improve Budgetary Controls over Expenditures Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Number and Title: COVID-19 ? 84.425D ? Elementary and Secondary School Emergency Relief Fund Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) Questioned Costs: $62,747.69 Description: A review of expenditures charged to the Elementary and Secondary School Emergency Relief Fund program revealed instances in which expenditures had not been properly approved by the pass-through entity. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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?? 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. Further, LEA personnel must also provide program-specific assurances related to the ESSER program within the Consolidated Application system. These assurances are reflected in the Uniform Guidance, Section 200.415 ? Required Certifications, and include provisions that require LEAs ?to assure that expenditures are proper and in accordance with the terms and conditions of the Federal award and approved project budgets?? Condition: A sample of 60 nonpersonal services expenditures was randomly selected for testing using a non-statistical sampling approach. Four individually significant items were also selected for testing. These expenditures were reviewed to determine if appropriate internal controls were implemented and applicable compliance requirements were met. Upon completing this testing, it was noted that three individually significant items totaling $48,037.69 and two randomly selected expenditures totaling $14,710.00 were not appropriately approved by GaDOE through the Consolidated Application process as required. Questioned Costs: Upon testing a sample of $2,037,733.28 in nonpersonal services expenditures, known questioned costs of $14,710.00 were identified. Using the total nonpersonal services expenditure population of $47,278,482.26, we project the likely questioned costs to be approximately $798,116.60. In addition, known questioned costs identified for improper payments associated with individually significant items tested totaled $48,037.69; therefore, the known and likely questioned costs identified for all unallowable payments throughout the sample and individually significant items tested totaled $62,747.69 and $846,154.29, respectively. Cause: In discussing these deficiencies with management, they stated that inadequate staffing levels led to the School District?s failure to establish appropriate internal control procedures, such as a review by appropriate personnel to ensure compliance with the Consolidated Application prior to the expenditure of federal funds. Additionally, the existence of multiple programs and associated Consolidated Applications led to the School District?s failure to establish appropriate internal control procedures to ensure the expenditure was approved on the specific Consolidated Application that funded the expenditure. Effect: The School District was not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to accurately develop and amend budget information through the Consolidated Application process and verify compliance with applicable policies and regulations prior to the expenditure of federal program funds 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 revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that potential expenditures are approved through the Consolidated Application process and deemed to be allowable before spending federal funds. In addition, 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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 Indirect Costs Compliance Requirements: Activities Allowed/Unallowed Allowable Costs/Cost Principles 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 Federal Award Numbers: S425D210012 (Year: 2021), S425U210012 (Year: 2021) Questioned Costs: $559,442.53 Description: The School District charged indirect cost expenditures to the Elementary and Secondary School Emergency Relief Fund program in excess of the maximum amount allowed. 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 $199,433,680.30 were expended and reported on the DeKalb 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. Additionally, 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, (d) Be accorded consistent treatment. A cost may not be assigned to a Federal award as a direct cost if any other cost incurred for the same purpose in like circumstances has been allocated to the Federal award as an indirect cost?? 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 exclude certain costs in the calculation of the net expenditures to which the approved indirect cost rate can be applied, including the cost of capitalizable assets, rental costs, tuition remission, scholarships and fellowships, payments to charter schools, and subawards in excess of $25,000. Condition: A review of the School District?s accounting records and supporting documentation revealed that costs associated with capitalizable equipment, payments to charter schools, and rental costs were not appropriately deducted in the calculation of the net expenditures to which the approved unrestricted indirect cost rate was applied. Therefore, the School District claimed an additional $559,442.53 in indirect costs beyond the maximum indirect cost amount allowed. Questioned Costs: Known questioned costs of $559,442.53 were identified for excess indirect cost expenditures claimed. These known questioned costs related to expenditures that were not tested as part of a sample, and therefore, should not be projected to a population to determine likely questioned costs. Cause: In discussing these deficiencies with management, they stated that inadequate controls over decentralized activity input led to the School District?s failure to establish appropriate internal control procedures over recording ledger activity. Effect: The School District is not in compliance with the Uniform Guidance or GaDOE guidance related to the ESSER program. Failure to ensure that appropriate indirect cost amounts are charged to the ESSER program may expose the School District to unnecessary financial strains and shortages as GaDOE may require the School District to return funds associated with these unallowable expenditures. Recommendation: The School District should revise current internal control procedures related to the ESSER program. Where vulnerable, the School District should develop and/or modify its policies and procedures to ensure that ledger activity is recorded accurately. In addition, 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-003 Improve Controls over Equipment Compliance Requirement: Equipment and Real Property Management 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 Federal Award Numbers: S425D200012 (Year: 2020), S425D210012 (Year: 2021) S425U210012 (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 $199,433,680.30 were expended and reported on the DeKalb 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 related invoice documentation: ? Equipment items totaling $163,730.00 were included on the financial statement capital asset listing but were excluded from the program equipment listing; therefore, property records did not include the following required components for the omitted equipment items: (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) the acquisition date, (6) cost of the property, (7) percentage of Federal participation in the project costs for the Federal award under which the property was acquired, (8) the location, and (9) use and condition of the property. ? Building improvements of $3,573,167.42 were excluded from the program equipment listing. ? Because these items were not included on the program equipment listing, a complete physical inventory was not performed and reconciled back to the property records. Cause: In discussing this deficiency with the School District, they stated that those items included on the capital asset listing and excluded from the program equipment listing were discovered after preparation and submission of the program equipment listing but prior to the submission of the financial statement capital asset listing. In addition, the building improvements are capitalized at a higher threshold for financial statement purposes and were overlooked by the School District when preparing the program equipment listing. 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.