Greensburg Community Schools

FINDING 2024-001 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed a system of internal controls in order to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management compliance requirement. A property record or capital asset listing is required to be maintained for all equipment purchased with the COVID-19 - Education Stabilization Fund grant award to ensure adequate safeguards are in place to prevent loss or damage of items. Equipment to be included in the listing is that which exceeds the School Corporation's capital asset threshold of $5,000. The School Corporation's capital asset listing did not include the following required information:  The source of funding for the property (including the federal award identification number).  The percentage of federal participation in the project costs for the federal award under which the property was acquired.  In one instance, it did not include an identification number. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." INDIANA STATE BOARD OF ACCOUNTS 16 GREENSBURG COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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. . . ." Cause The School Corporation's management was not aware of all the items required to be included in the capital asset listing. Effect The failure to establish an effective system of internal controls placed the School Corporation in noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation's capital asset listing did not include all information required for assets acquired with federal funds. Noncompliance with the grant agreement and the compliance requirement could result in the repayment of federal funds. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls that would ensure compliance with the Equipment and Real Property management records and update its capital asset listing to include all required information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2024-002 Subject: Special Education Cluster (IDEA) - Equipment and Real Property Management Federal Agency: Department of Education Federal Programs: COVID-19 - Special Education Grants to States, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027X, 84.173X Federal Award Numbers and Years (or Other Identifying Numbers): 22611-144-ARP, 22619-144-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context 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 compliance requirements. A property record or capital asset listing is required to be maintained for all equipment purchased with the COVID-19 - Education Stabilization Fund grant award to ensure adequate safeguards are in place to prevent loss or damage of items. Equipment to be included in the listing is that which exceeds the School Corporation's capital asset threshold of $5,000. The School Corporation's capital asset listing did not include the following required information:  The source of funding for the property (including the federal award identification number).  The percentage of federal participation in the project costs for the federal award under which the property was acquired.  The use and condition of the asset. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 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: INDIANA STATE BOARD OF ACCOUNTS 18 GREENSBURG COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." Cause The School Corporation's management was not aware of all the items required to be included in the capital asset listing. Effect The failure to establish an effective system of internal controls placed the School Corporation in noncompliance with the grant agreement and the Equipment and Real Property Management compliance requirement. The School Corporation's capital asset listing did not include all information required for assets acquired with federal funds. Noncompliance with the grant agreement and the compliance requirement could result in the repayment of federal funds. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls that would ensure compliance with the equipment and real property management records and update its capital asset listing to include all required information. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2024-003 Subject: Special Education Cluster (IDEA) - Earmarking Federal Agency: Indiana Department of Education Federal Programs: Special Education Grants to States, COVID-19 - Special Education Grants to States, Special Education Preschool Grants, COVID-19 - Special Education Preschool Grants Assistance Listings Numbers: 84.027A, 84.027X, 84.173A, 84.173X Federal Award Numbers and Years (or Other Identifying Numbers): 22611-144-PN01, 22619-144-PN01, 23611-144-PN01, 23619-144-PN01, 22611-144-ARP, 22619-144-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Matching, Level of Effort, Earmarking Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not in place at the School Corporation to ensure that the School Corporation complied with Earmarking compliance requirements. The School Corporation did not have adequate procedures in place to ensure the required level of expenditures for nonpublic school students was met. The School Corporation's payroll-related disbursements for Non-Public Proportionate Share were estimated based on actual hours worked by School Corporation staff at nonpublic schools in the previous school year. This amount was allocated over the biweekly salaries of employees providing services at the nonpublic schools. This resulted in a fixed amount of each biweekly pay being charged to the nonpublic accounts regardless of actual time spent by employees with nonpublic students in the given pay period. There was no reconciliation process between budgeted hours and actual hours worked with nonpublic students during each pay period. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.403 states in part: "Except where otherwise authorized by statute, costs must meet the following general criteria in order to be allowable under Federal awards: (g) Be adequately documented. . . ." INDIANA STATE BOARD OF ACCOUNTS 20 GREENSBURG COMMUNITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 2 CFR 200.208(b) states in part: "The Federal awarding agency or pass-through entity may adjust specific Federal award conditions as needed, . . ." 511 IAC 7-34-7(b) states: "The public agency, in providing special education and related services to students in nonpublic schools must expend at least an amount that is the same proportion of the public agency total subgrant under 20 U.S.C. 1411(f) as the number of nonpublic school students with disabilities, who are enrolled by their parents in nonpublic schools within its boundaries, is to the total number of students with disabilities of the same age range." Cause Management of the School Corporation had not designed a system of internal controls that would have ensured that time worked by certified staff for nonpublic schools was properly identified. Internal controls in place did not identify that an improper method was used to identify expenditures for nonpublic students with disabilities. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation was unable to ensure that the proportionate share required to be expended for nonpublic students was met. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure the Non-Public Proportionate Share amounts are spent based on actual charged time by staff working with the nonpublic students. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2022-001 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425 Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context An effective internal control system was not designed, nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation had not designed, nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection report (Report) was complete and accurately submitted. The Reports were prepared by one employee without a documented oversight, review, or approval process in place to prevent, or detect and correct, errors on the Reports. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause Management had not developed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control related to the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

FINDING 2022-002 Subject: Title I Grants to Local Educational Agencies - Internal Controls Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): 19611-001-PN01, 20611-001-PN01, 21611-001-PN01 Pass-Through Entity: Indiana Department of Education Compliance Requirements: Eligibility; Reporting; Matching, Level of Effort, Earmarking; Special Tests and Provisions - Annual Report Card, High School Graduation Rate Audit Finding: Material Weakness Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Eligibility The October 1st Real Time Report of Public Enrollment (PE) was used by the Indiana Department of Education to populate the enrollment and poverty status data in the Title I applications. These numbers were then used to calculate Percent Poverty, which was used to rank schools for Title I eligibility. One person was primarily responsible for compiling and uploading student data, including poverty status, for Real Time reports. There were no documented controls in place, such as an oversight, review, or approval process to ensure eligibility was properly determined. Reporting The Indiana Department of Education used the Form 9 financial reports submitted by the School Corporation in the state's submission of the average State Per Pupil Expenditure data submitted to the National Center for Education Statistics. The Treasurer was responsible for preparing and submitting the Form 9. There were no documented controls in place such as an oversight, review, or approval process to ensure expenditures were correctly reported. Matching, Level of Effort, Earmarking The Indiana Department of Education calculates the Maintenance of Effort - Level of Effort based on expenditure information submitted on the Form 9 for that fiscal year. The Treasurer was responsible for the preparation and submission of the Form 9. There were no documented internal controls in place such as an oversight, review, or approval process to ensure expenditures were correctly reported. Special Tests and Provisions - Annual Report Card, High School Graduation Rate One person was primarily responsible for removing students from a cohort and receiving required documentation to support their removal. There were no documented controls in place to ensure the proper exit code was entered and that the required documentation was obtained. The lack of internal controls was a systemic issue throughout the entire audit period. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the 'Internal Control Integrated Framework', issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." Cause Management had not designed or implemented a system of internal control that would have ensured compliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Effect The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a system of internal control related to the grant agreement and the Eligibility; the Reporting; the Matching, Level of Effort, Earmarking; and the Special Tests and Provisions - Annual Report Card, High School Graduation Rate compliance requirements. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION

GSA_MIGRATION