Audit 404274

Information on the federal program: Subject: Education Stabilization Fund – Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425U Federal Award Numbers: S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness Criteria: 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) 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. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep the property in good condition. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: In our testing of four equipment selections, we noted the School Corporation did not add the capital asset to the capital asset listing. During the testing of equipment acquisitions, it was noted the School Corporation had not updated the capital asset ledger as of June 30, 2025 for equipment acquisitions made during the period under audit. Additionally, the capital asset ledger does not include required information, such as designation of federal funding, date acquired, capital asset categorization and useful life. Identification as a repeat finding: Yes, Finding 2023-004 Recommendation: We recommend that the School Corporation's management establish a system of internal controls related to the grant agreement and Equipment and Real Property Management compliance requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Information on the federal program: Subject: Education Stabilization Fund – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425U, 84.425D Federal Award Numbers: S425U210013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness Criteria: 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: The School Corporation did not have a review control in place to ensure the annual data report was reviewed by someone other than the preparer. In addition, original documents and related support were not maintained by the School Corporation. Cause: There were not sufficient internal controls in place to ensure the Annual Data Report agreed to the underlying fund ledger detail. Effect: The Annual Data Reports could be submitted with incorrect information. Questioned Costs: There were no questioned costs identified. Context: The School Corporation did not have a formal review process in place to review the Annual Data Reports that were required to be submitted during the audit period. Original copies of the reports and submission receipts were not maintained and therefore, we were unable to verify the reports were submitted by the required due dates. The Annual Data Report for the period of July 1, 2022 through June 30, 2023 was overstated by $36,297. Management could not provide support for Cross Act total employees reported at 147. Also, management here was a variance of 16 positions for Cross Act positions paid by ESSER. The amount reported was 135 while management’s support detail was 151 positions. Identification as a repeat finding, if applicable: Yes, Finding 2023-005. Recommendation: We recommend management review internal controls around the preparation, review, and submission of the Annual Data Reports to verify accuracy and that support detail is maintained. We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted and that the School Corporation maintain records to validate the reports were submitted timely. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.