Audit 354728

FY End
2023-06-30
Total Expended
$210.00M
Findings
8
Programs
19
Year: 2023 Accepted: 2025-04-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
556009 2023-004 Material Weakness - A
556010 2023-004 Material Weakness - A
556011 2023-004 Material Weakness - A
556012 2023-005 Material Weakness - F
1132451 2023-004 Material Weakness - A
1132452 2023-004 Material Weakness - A
1132453 2023-004 Material Weakness - A
1132454 2023-005 Material Weakness - F

Contacts

Name Title Type
GU56TZLJ71X9 Byron Schuenenman Auditee
6786760133 Christopher McKellar Auditor
No contacts on file

Notes to SEFA

Title: (1) Accounting Policies: The Schedule of Expenditures of Federal Awards includes the federal grant activity of the DeKalb County Board of Education and is presented on the modified accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles and Audit Requirements for Federal Awards . Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of the financial statements. De Minimis Rate Used: N Rate Explanation: The School District did not utilize the 10% de minimis indirect cost rate. The amounts shown for the Food Distribution Program represents the federally assigned value of nonmonetary assistance for donated commodities received and/or consumed by the system during the current fiscal year.

Finding Details

Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
U.S. Federal Communications Commission Program Name: Emergency Connectivity Funds Assistance Listing Number: 32.009 Finding: 2023-005 – Equipment & Real Property Management Criteria: Internal controls should be in place to ensure that equipment and real property management requirements are met as specified in the guidance provided by the Federal Communications Commission (FCC). FCC guidance specified that the District was required to maintain asset inventories of the devices purchased with the ECF program. The Uniform Guidance requires any recipients of federal awards to comply with the equipment and real property management requirements indicated by the grantor agency. Condition: The District did not have adequate internal controls to ensure compliance with equipment and real property management requirements. Context/cause: During our testing of equipment and real property requirements, the District made bulk purchases of laptops and wi-fi hot spots that had a total purchase value over the $10,000 capital asset threshold. Upon the initial review of the District’s capital asset listing, these bulk equipment purchases were not included. An adjustment in the General Fund totaling $19,776,000 was required to report the capital outlay expenditure and grant revenue. Effect: Equipment purchases made with grant funding could be improperly excluded from the capital asset listing which would misstate the District’s capital asset balances. Questioned Costs: $19,776,000 Recommendation: We recommend the District enhances internal controls to ensure accuracy and compliance with equipment and real property requirements. Auditee’s Response: We concur with this finding.
Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
Program Name: Child Nutrition Cluster Assistance Listing Number: 10.553 and 10.555 Pass-Through Agency: Georgia Department of Education Finding: 2023-004 – Allowable Costs Criteria: In accordance with the terms of the Child Nutrition Grant and 2 CFR 200, Cost Principles for States, Local Governments, and Indian Tribes, specific documentation must be maintained to support salaries and wages charged to the federal program. Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employees worked solely on that program for the period covered by the certification. These certifications will be prepared at least semiannually and will be signed by the employee or supervisory official having first-hand knowledge of the work performed by the employee. Where employees work on multiple activities or cost objectives, a distribution of their salaries or wages will be supported by personnel activity reports or equivalent documentation. Condition and Context: For the fiscal year ended June 30, 2023, internal controls over compliance were not sufficient to ensure the District was properly charging payroll costs which were reimbursed by the Child Nutrition grant. In our sample of forty (40) employees who were paid with Child Nutrition funds, we noted two of the selected employees did not have any of the required monthly certifications, six employees were missing one or more month’s certifications, and four employees’ certifications were missing signatures from the supervising official. Cause: A lack of oversight by personnel in the Office of Federal Grants and Program Compliance led to noncompliance with the requirements of the Uniform Guidance in relation to charging of personnel costs to a federal grant. Effects or Possible Effects: Personnel salaries unrelated to eligible Child Nutrition activities could be charged to and reimbursed by the District’s federal grants. Questioned Costs: All amounts paid to those employees who did not have a semiannual certification could be questioned. These amounted to $247,000. When comparing the known questioned costs to the sample total of $16,683,000, the error rate for the selected sample was 5%. The error rate projected onto the total population of payroll costs, resulted in a likely questioned cost of $4,884,000. Recommendation: We recommend District personnel perform periodic reviews of the general ledger to ensure appropriate documentation is obtained for all payroll costs charged to the Child Nutrition grant. Furthermore, in instances where changes are made to employee assignments (including termination) involving federal grants, we recommend the District review payroll costs for those employees in the periods immediately following the changes to ensure they are appropriately reflected in the accounting records and thus properly charged to the District’s federal grant programs. Auditee’s Response: We concur with this finding.
U.S. Federal Communications Commission Program Name: Emergency Connectivity Funds Assistance Listing Number: 32.009 Finding: 2023-005 – Equipment & Real Property Management Criteria: Internal controls should be in place to ensure that equipment and real property management requirements are met as specified in the guidance provided by the Federal Communications Commission (FCC). FCC guidance specified that the District was required to maintain asset inventories of the devices purchased with the ECF program. The Uniform Guidance requires any recipients of federal awards to comply with the equipment and real property management requirements indicated by the grantor agency. Condition: The District did not have adequate internal controls to ensure compliance with equipment and real property management requirements. Context/cause: During our testing of equipment and real property requirements, the District made bulk purchases of laptops and wi-fi hot spots that had a total purchase value over the $10,000 capital asset threshold. Upon the initial review of the District’s capital asset listing, these bulk equipment purchases were not included. An adjustment in the General Fund totaling $19,776,000 was required to report the capital outlay expenditure and grant revenue. Effect: Equipment purchases made with grant funding could be improperly excluded from the capital asset listing which would misstate the District’s capital asset balances. Questioned Costs: $19,776,000 Recommendation: We recommend the District enhances internal controls to ensure accuracy and compliance with equipment and real property requirements. Auditee’s Response: We concur with this finding.