Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II and ESSER III amounts reported for the reports covering the FY22 time period ($0 and $0, respectively) did not agree to the underlying expenditure records ($79,112 and $99,245 respectively, for the period of July 1, 2021 through June 30, 2022). Additionally, we noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($178,829 and $874,154, respectively) did not agree to the underlying expenditure records ($159,450 and $789,489), respectively, for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-005 Subject: Child Nutrition Cluster - Reporting Federal Agency: Department of Agriculture Federal Programs: School Breakfast Program, National School Lunch Program, Summer Food Service Program for Children Assistance Listings Numbers: 10.553, 10.555, 10.559 Federal Award Numbers and Years (or Other Identifying Numbers): 2022-2023, 2023-2024 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Monthly Sponsor Claims for Reimbursement (Claims) were submitted to the Indiana Department of Education based upon the number of meals served for the month. The Claims were prepared by the Food Service Manager or food service management company (FSMC) employee. INDIANA STATE BOARD OF ACCOUNTS 26 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation maintained manual meal count records. A point-of-sale system (POS) was used for some schools in some months, but it was not consistent. The reports from the POS identified second student meals and staff meals that were included in the amounts claimed for reimbursement. For all three Claims tested, there were differences between the Claims submitted and the School Corporation's detail meal count reports, resulting in over and under reporting and reimbursement. The Claims tested contained the following errors: The December 2022 claim reported 41 more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed reimbursement totaling $109. Of this total, $59 (22 meals) was due to improperly claiming second student or staff meals. The March 2023 claim in total reported more meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in overclaimed meals totaling $4,254. Of this total, $4,144 was due to claiming second student or staff meals, totaling $1,035, for breakfast and lunch. The School Corporation also underclaimed snacks by 421, which resulted in under reimbursement of $455. Finally, the claim also contained overcount errors of 136 meals, resulting in overclaimed reimbursement of $565. The August 2023 claim reported fewer meals served than the eligible meals per the School Corporation's detail meal count reports, which resulted in underclaimed meals in net totaling $11,474. The School Corporation did not claim meals served on August 31, 2023, totaling 3,879 meals. This resulted in underclaimed meal reimbursement totaling $13,767. The School Corporation also claimed 141 second student and staff meals, which resulted in overclaimed reimbursement totaling $480. Finally, the claim also contained overcount errors of 497 meals, resulting in overclaimed reimbursement of $1,813. 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.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 and 200.329. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 GARY COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation did not have effective internal control procedures in place over the Claims submitted. The Claims did not contain evidence of an oversight or review process in place to prevent, or detect and correct, errors. The Claims were prepared based upon a summary sheet prepared by the FSMC employee and were not verified back to the source records. Effect 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 system of internal controls and develop policies and procedures over the preparation and review of claims to ensure appropriate reviews, approval, and oversight are taking place. Additionally, management should develop policies and procedures to ensure that the FSMC provides the School Corporation with complete and accurate information for all claim submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II amount reported for the reports covering the FY22 time period ($230,281) did not agree to the underlying expenditure records ($4,290 for the period of July 1, 2021 through June 30, 2022). Additionally, we noted the School Corporation was unable to provide support for the FTE number reported as of 9/30/22 and 9/30/23. We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II amount reported for the reports covering the FY22 time period ($230,281) did not agree to the underlying expenditure records ($4,290 for the period of July 1, 2021 through June 30, 2022). Additionally, we noted the School Corporation was unable to provide support for the FTE number reported as of 9/30/22 and 9/30/23. We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-001 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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 data reported by the School Corporation to the Indiana Department of Education contained errors when compared to underlying supporting records of grant activity for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. The Annual Data Reports were prepared by School Corporation management and reviewed by someone other than the preparer, however, the review process in place did not prevent, or detect and correct, errors. During testing of the accuracy of the annual data reports, the following errors were noted: • The Year 2 Annual Data Report for the ESSER III (84.425U) grant award reported total disbursements of $2,219,321 for the period of July 1, 2021 through June 30, 2022 compared to underlying disbursement detail of $2,715,940. • The Year 3 Annual Data Report for the ESSER III (84.425U) grant award reported total disbursements of $224,309 for the period of July 1, 2022 through June 30, 2023 compared to underlying disbursement detail of $306,194. Identification as a repeat finding: Yes, see Finding 2022-009 in the prior period audit report. Recommendation: 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 which includes a comparison to the underlying funds ledger disbursement detail for the same period. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I and ESSER III amounts reported for the reports covering the FY22 time period ($22,163 and $409,347, respectively) did not agree to the underlying expenditure records ($3,796 and $404,347 respectively) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported for the reports covering the FY23 time period ($131,439) did not agree to the underlying expenditure records ($153,216) for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the FY23 annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I and ESSER III amounts reported for the reports covering the FY22 time period ($22,163 and $409,347, respectively) did not agree to the underlying expenditure records ($3,796 and $404,347 respectively) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported for the reports covering the FY23 time period ($131,439) did not agree to the underlying expenditure records ($153,216) for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the FY23 annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I and ESSER III amounts reported for the reports covering the FY22 time period ($22,163 and $409,347, respectively) did not agree to the underlying expenditure records ($3,796 and $404,347 respectively) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported for the reports covering the FY23 time period ($131,439) did not agree to the underlying expenditure records ($153,216) for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the FY23 annual data reports by someone other than the preparer. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($288,565 and $115,716, respectively) did not agree to the underlying expenditure records ($139,081 and $88,437, respectively) for the period of July 1, 2022 through June 30, 2023. Additionally, the School Corporation was not able to provide any support for the 86 full-time equivalent (FTE) positions on September 30, 2022, reported on the Year 3 CrossAct report or the 110 full-time equivalent (FTE) positions on September 30, 2023, reported on the Year 4 CrossAct report. Identification as a repeat finding: No. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($288,565 and $115,716, respectively) did not agree to the underlying expenditure records ($139,081 and $88,437, respectively) for the period of July 1, 2022 through June 30, 2023. Additionally, the School Corporation was not able to provide any support for the 86 full-time equivalent (FTE) positions on September 30, 2022, reported on the Year 3 CrossAct report or the 110 full-time equivalent (FTE) positions on September 30, 2023, reported on the Year 4 CrossAct report. Identification as a repeat finding: No. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-008 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U, 84.425W Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D210013, S425U210013, S425W210015 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context Internal control is generally defined as a process affected by an entity's oversight body, management, and other personnel that provides reasonable assurance that the objectives of an entity will be achieved. With respect to federal awards, nonfederal entities, such as the School Corporation, are required to establish and maintain internal control over federal awards that provides reasonable assurance that the nonfederal entity is managing the federal award in compliance with federal statutes, regulations, and terms and conditions of the federal awards. Internal control is not one event or circumstance, but a dynamic and iterative process. The internal control process is based on fundamental principles that operate as a whole but are best understood when analyzed individually. The fundamental principles are related to five components of internal control which are as follows: Control Environment, Risk Assessment, Control Activities, Information and Communication, and Monitoring. If a component is not effective, or the components are not operating together in an integrated manner, then an internal control system cannot be effective. Deficiencies as noted below were identified in the risk assessment, monitoring, and control activities components. Risk Assessment The School Corporation has not established a formal risk assessment process. There is no documented risk assessment policy, nor is there evidence of periodic risk identification, analysis, or evaluation. INDIANA STATE BOARD OF ACCOUNTS 33 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monitoring The School Corporation did not conduct ongoing or periodic reviews to ensure that internal controls were operating as intended and to identify areas for improvement. Furthermore, the School Corporation did not have a process to follow up on corrective actions written as a response to audit findings. Control Activities The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . . ," "LEA expenditures by ESSER Subgrant fund . . . ," and "Full-Time Equivalency Positions." As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, two ESSER III reports, and one ARP HCY II Report, for a total of six reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All six reports were selected for testing. Four of the reports were not supported by the School Corporation's records, and their accuracy and completeness could not be verified. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, the supplies line item could not be traced to the School Corporation's records. For ESSER II, Year 3, the School Corporation reported Other Purchased Services, but the School Corporation's supporting documentation did not include any items that would be classified as such. The ESSER III, Year 2 report, which covered the period of July 1, 2021 to June 30, 2022, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported the purchase of Chromebooks as Purchased Property Services, which was not the appropriate classification for the expenditure. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Purchased Property Services and Personnel Services - Salaries that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 34 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management of the School Corporation had not taken steps to design and implement policies and procedures to assess risks facing the School Corporation or to establish and operate monitoring activities that monitor the internal control system. Additionally, the School Corporation did not act upon its corrective action plan submitted in response to the same finding included in the prior audit and did not take further steps to ensure compliance. Effect As a result of the five components of internal control not being adequately designed and implemented, the internal control system cannot be effective. Thus, general risks or specific risks from fraud and significant changes could negatively impact the School Corporation, identified internal control deficiencies could continue, and unidentified flaws within the internal control system could exist. Additionally, due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. INDIANA STATE BOARD OF ACCOUNTS 35 CANNELTON CITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Recommendation We recommended that the School Corporation's management establish a proper system of internal controls, which would include policies and procedures related to risk assessment and monitoring. Additionally, we recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I amount reported on the Year 3 report ($86,004) did not agree to the underlying expenditure records ($196,436) for the period of July 1, 2021 through June 30, 2022. We also noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($0 and $1,684,755, respectively) did not agree to the underlying expenditure records ($1,391,963 and $4,330,649, respectively), for the period of July 1, 2022 through June 30, 2023. Identification as a repeat finding: Yes. See Finding 2022-003 in the prior audit report. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I amount reported on the Year 3 report ($86,004) did not agree to the underlying expenditure records ($196,436) for the period of July 1, 2021 through June 30, 2022. We also noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($0 and $1,684,755, respectively) did not agree to the underlying expenditure records ($1,391,963 and $4,330,649, respectively), for the period of July 1, 2022 through June 30, 2023. Identification as a repeat finding: Yes. See Finding 2022-003 in the prior audit report. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I amount reported on the Year 3 report ($86,004) did not agree to the underlying expenditure records ($196,436) for the period of July 1, 2021 through June 30, 2022. We also noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($0 and $1,684,755, respectively) did not agree to the underlying expenditure records ($1,391,963 and $4,330,649, respectively), for the period of July 1, 2022 through June 30, 2023. Identification as a repeat finding: Yes. See Finding 2022-003 in the prior audit report. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports, however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I amount reported on the Year 3 report ($86,004) did not agree to the underlying expenditure records ($196,436) for the period of July 1, 2021 through June 30, 2022. We also noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($0 and $1,684,755, respectively) did not agree to the underlying expenditure records ($1,391,963 and $4,330,649, respectively), for the period of July 1, 2022 through June 30, 2023. Identification as a repeat finding: Yes. See Finding 2022-003 in the prior audit report. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding Reference 2024-005 Federal Agency: U.S. Department of Homeland Security Pass-Through Agency: Central Office of Recovery, Reconstruction and Resiliency of Puerto Rico (COR3) Program: Disaster Grants – Public Assistance (Presidentially Declared Disaster) (ALN 97.036) Compliance Requirement: Reporting (L) Type of Finding: Significant Deficiency in Internal Controls (SD), Instance of Noncompliance (NC) This finding is similar to prior-year finding 2023-005. Statement of Condition In our Reporting Test, we evaluated the Quarterly Progress Reports of a total of twelve (12) projects for two quarters of fiscal year 2023-2024. During our audit procedures, we noted that the reports did not agree with the accounting and project records. Criteria 2 CFR 200.302 (a) states that the state’s and the other non-Federal entity’s financial management system, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. Also, 2 CFR 200.302 (b) (2) states that the financial management system of each non-Federal entity must provide 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 and 200.329. Cause of Condition The Municipality accounting controls and procedures fail to ensure accurate, current and complete disclosure of the financial results of federal assisted activities. Effect of Condition The expenses reported in the Quarterly Progress Reports do not agree with the accounting records. Recommendation We recommend Program Administrators reconcile the differences between the quarterly report and the accounting records before the submission of the next submission to the pass-through entity. Questioned Cost None. Prior Year Finding Yes. This finding is similar to prior-year finding 2023-005. Views of Responsible Officials and Planned Corrective Action We concur with the finding. We understand that only two (2) reports did not agree with the accounting records. We have consultants that are responsible for the preparation of these reports. Instructions were given to the consultants in order to correct the reports that do not agree with the accounting records. There was a misunderstanding with the reports, in which the past-through entity instructed that purchase orders and expenditures incurred should be reported. As subsequently clarified, only the expenditures incurred should be reported. Implementation Date: June 30, 2025 Responsible Person: Carmen López Interim Finance Director
Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) each year during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER III and CrossAct amounts reported for the period of July 1, 2021 through June 30, 2022 ($3,070, $745,718 and 119 employees respectively) did not agree to the underlying expenditure and employee records ($7,062, $754,729 and 207 employees respectively) for the same period. Additionally, we noted that the ESSER II, ESSER III and CrossAct amounts reported on the period of July 1, 2022 through June 30, 2023 ($452,658, $117,344 and 117 employees respectively) did not agree to the underlying expenditure and employee records ($62,794, $459,556 and 207 employees respectively) for the same period. Of the eight reports the School Corporation was required to submit during the audit period, auditable evidence of review and approval of these reports was only provided for two. Identification as a repeat finding: Yes, see Finding 2022-002.Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) each year during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER III and CrossAct amounts reported for the period of July 1, 2021 through June 30, 2022 ($3,070, $745,718 and 119 employees respectively) did not agree to the underlying expenditure and employee records ($7,062, $754,729 and 207 employees respectively) for the same period. Additionally, we noted that the ESSER II, ESSER III and CrossAct amounts reported on the period of July 1, 2022 through June 30, 2023 ($452,658, $117,344 and 117 employees respectively) did not agree to the underlying expenditure and employee records ($62,794, $459,556 and 207 employees respectively) for the same period. Of the eight reports the School Corporation was required to submit during the audit period, auditable evidence of review and approval of these reports was only provided for two. Identification as a repeat finding: Yes, see Finding 2022-002.Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U 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 Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) each year during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER III and CrossAct amounts reported for the period of July 1, 2021 through June 30, 2022 ($3,070, $745,718 and 119 employees respectively) did not agree to the underlying expenditure and employee records ($7,062, $754,729 and 207 employees respectively) for the same period. Additionally, we noted that the ESSER II, ESSER III and CrossAct amounts reported on the period of July 1, 2022 through June 30, 2023 ($452,658, $117,344 and 117 employees respectively) did not agree to the underlying expenditure and employee records ($62,794, $459,556 and 207 employees respectively) for the same period. Of the eight reports the School Corporation was required to submit during the audit period, auditable evidence of review and approval of these reports was only provided for two. Identification as a repeat finding: Yes, see Finding 2022-002.Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-006 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY22 time period ($99,969 and $251,848, respectively) did not agree to the underlying expenditure records ($105,319 and $369,743, respectively, for the period of July 1, 2021 through June 30, 2022). Additionally, we noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($168,087 and $266,122, respectively) did not agree to the underlying expenditure records ($169,046 and $241,329, respectively, for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-002. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-006 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY22 time period ($99,969 and $251,848, respectively) did not agree to the underlying expenditure records ($105,319 and $369,743, respectively, for the period of July 1, 2021 through June 30, 2022). Additionally, we noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($168,087 and $266,122, respectively) did not agree to the underlying expenditure records ($169,046 and $241,329, respectively, for the period of July 1, 2022 through June 30, 2023). We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-002. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers: S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER II and ESSER III amounts reported on the Year 3 report ($1,459,495 and $5,966,446, and $1,220,584 respectively) did not agree to the underlying expenditure records ($514,738 and $1,651,887 and $2,259,794, respectively), for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported on the Year 4 report ($395,303) did not agree to the underlying expenditure records ($1,247,686), for the period of July 1, 2022 through June 30, 2023. Finally, there was no formal review of the Annual Data Reports prior to their submission to the IDOE. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers: S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER II and ESSER III amounts reported on the Year 3 report ($1,459,495 and $5,966,446, and $1,220,584 respectively) did not agree to the underlying expenditure records ($514,738 and $1,651,887 and $2,259,794, respectively), for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported on the Year 4 report ($395,303) did not agree to the underlying expenditure records ($1,247,686), for the period of July 1, 2022 through June 30, 2023. Finally, there was no formal review of the Annual Data Reports prior to their submission to the IDOE. Identification as a repeat finding: No. Recommendation: 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. 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 (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers: S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I, ESSER II and ESSER III amounts reported on the Year 3 report ($1,459,495 and $5,966,446, and $1,220,584 respectively) did not agree to the underlying expenditure records ($514,738 and $1,651,887 and $2,259,794, respectively), for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II amount reported on the Year 4 report ($395,303) did not agree to the underlying expenditure records ($1,247,686), for the period of July 1, 2022 through June 30, 2023. Finally, there was no formal review of the Annual Data Reports prior to their submission to the IDOE. Identification as a repeat finding: No. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Finding: 2024-002 Federal Agency: U.S. Department of Treasury Pass-through Agency: N/A Federal Program Title: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Compliance Requirement: Reporting Type of Finding: Significant Deficiency Responsible Official: Verónica Hernández, Finance Director Prior year finding: 2023-002 Condition The required Quater Project and Expenditure (P & E) Report was not submitted. The report was required for the quarter period ended September 30, 2023, and was due on October 31, 2023. Criteria 2 CFR 200.328 and 31 CFR section 35.4(c) required financial and performance reporting information. The information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes, and preferably in coordination with performance reporting. Context We request the report submitted during the fiscal year to be audited and observed that the Quarter report ended in September 2023 was not submitted. Cause The Municipality failed to submission of the required report on time due to lack of knowledge of requisites and instructions about the completion of the report. Effect The Municipality did not comply with compliance requirements of the Program. It could affect the monitories of the Federal Awarding Agency assign the funds and affect the program outcomes. Questioned Costs None. Recommendation The Municipality should maintain the schedule of due dates of the required reports of each federal program in order to comply with the required submissions to the federal awarding agencies. Also, they had to submit the quarter report in order to complied with the requirements.
FINDING 2024-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-010. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Even though the reports were reviewed by someone other than the preparer, the School Corporation was not able to provide financial information that was used to determine amounts used in the reports. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants. For all four of the Reports, the School Corporation was unable to provide financial information to support the amounts in the Reports; therefore, the Indiana State Board of Accounts could not determine the accuracy of the Reports. Additionally, eight of eight key line items selected for testing could not be verified to the financial records. 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.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 and 200.329. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause According to the School Corporation, these issues were due to the reporting differences of how the annual expenditure report categories are different than the annual Data Collection reports. The School Corporation indicated that it had to go employee by employee to properly place them under the correct category using the reimbursement requests but did not retain that documentation of how it came to the numbers. Effect The failure to design and implement an effective internal control system enabled noncompliance to go undetected with the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure reports submitted are accurate and have supporting documentation. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-010. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Even though the reports were reviewed by someone other than the preparer, the School Corporation was not able to provide financial information that was used to determine amounts used in the reports. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants. For all four of the Reports, the School Corporation was unable to provide financial information to support the amounts in the Reports; therefore, the Indiana State Board of Accounts could not determine the accuracy of the Reports. Additionally, eight of eight key line items selected for testing could not be verified to the financial records. 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.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 and 200.329. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause According to the School Corporation, these issues were due to the reporting differences of how the annual expenditure report categories are different than the annual Data Collection reports. The School Corporation indicated that it had to go employee by employee to properly place them under the correct category using the reimbursement requests but did not retain that documentation of how it came to the numbers. Effect The failure to design and implement an effective internal control system enabled noncompliance to go undetected with the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure reports submitted are accurate and have supporting documentation. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-010. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Even though the reports were reviewed by someone other than the preparer, the School Corporation was not able to provide financial information that was used to determine amounts used in the reports. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants. For all four of the Reports, the School Corporation was unable to provide financial information to support the amounts in the Reports; therefore, the Indiana State Board of Accounts could not determine the accuracy of the Reports. Additionally, eight of eight key line items selected for testing could not be verified to the financial records. 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.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 and 200.329. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause According to the School Corporation, these issues were due to the reporting differences of how the annual expenditure report categories are different than the annual Data Collection reports. The School Corporation indicated that it had to go employee by employee to properly place them under the correct category using the reimbursement requests but did not retain that documentation of how it came to the numbers. Effect The failure to design and implement an effective internal control system enabled noncompliance to go undetected with the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure reports submitted are accurate and have supporting documentation. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-006 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana 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: Reporting Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-010. Condition and Context An effective internal control system was not designed or implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. Even though the reports were reviewed by someone other than the preparer, the School Corporation was not able to provide financial information that was used to determine amounts used in the reports. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants. For all four of the Reports, the School Corporation was unable to provide financial information to support the amounts in the Reports; therefore, the Indiana State Board of Accounts could not determine the accuracy of the Reports. Additionally, eight of eight key line items selected for testing could not be verified to the financial records. 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.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 and 200.329. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for the Federal awards that are renewed quarterly or annual, from the date of submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause According to the School Corporation, these issues were due to the reporting differences of how the annual expenditure report categories are different than the annual Data Collection reports. The School Corporation indicated that it had to go employee by employee to properly place them under the correct category using the reimbursement requests but did not retain that documentation of how it came to the numbers. Effect The failure to design and implement an effective internal control system enabled noncompliance to go undetected with the Reporting compliance requirement. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure reports submitted are accurate and have supporting documentation. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-004 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit four Annual Data Reports to the Indiana Department of Education (IDOE) each year during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the CrossAct amount reported on the Year 3 report (118 employees) did not agree to the underlying employee records (94 employees). Additionally, we noted that the CrossAct amount reported on the Year 4 report (104 employees) did not agree to the underlying employee records (112 employees). Additionally, for all reports the School Corporation was required to submit during the audit period, auditable evidence of review and approval of these reports was not provided. Identification as a repeat finding: This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
FINDING 2024-004 Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit four Annual Data Reports to the Indiana Department of Education (IDOE) each year during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the CrossAct amount reported on the Year 3 report (118 employees) did not agree to the underlying employee records (94 employees). Additionally, we noted that the CrossAct amount reported on the Year 4 report (104 employees) did not agree to the underlying employee records (112 employees). Additionally, for all reports the School Corporation was required to submit during the audit period, auditable evidence of review and approval of these reports was not provided. Identification as a repeat finding: This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
2024-002 - Untimely Reporting of Student Disbursements. Finding Type. Immaterial Noncompliance/Significant Deficiency in Internal Control over Compliance (Reporting). Program. Student Financial Assistance Cluster; U.S. Department of Education; Assistance Listing Number 84.063; Award Number P063P231638. Criteria. According to 2 CFR § 200.328, recipients of federal awards must submit financial reports as required by the Federal award. For Title IV programs, the Department of Education mandates that disbursement records for Pell grants be submitted to the Common Origination and Disbursement system no later than 15 days after making the disbursement or becoming aware of the need to adjust a student's previously reported disbursement. Condition. One student of the forty students tested received a disbursement that was not reported to the federal government within the required timeframe. Cause. Due to system errors, the College was not able to timely file the report with the Common Origination and Disbursement timely. Effect. As a result of this condition, the College did not fully comply with the requirements to report disbursements within 15 days of disbursing funds. Questioned Costs. No costs were required to be questioned as a result of this finding, in as much of our testing did not reveal any unallowed costs. Repeat Finding. Yes, 2023-001 in prior year. Recommendation. We recommend that the College implement policies and procedures, including designating an individual to oversee this reporting requirement, to ensure information is submitted to the Common Origination and Disbursement in a timely manner. View of Responsible Officials. Management believes this was an isolated incident and has prepared a Corrective Action Plan.
FINDING 2024-003 Subject: COVID-19 - Education Stabilization Fund - Reporting 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): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . .," "LEA expenditures by ESSER Subgrant fund . . .," and "Full-Time Equivalency Positions." During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, and two ESSER III reports for a total of five reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All five reports were selected for testing. Three of the reports were not supported by the School Corporation's records. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, Personnel Services - Salaries could not be traced to the School Corporation's records. For the ESSER II, Year 3 report, Supplies could not be traced to the School Corporation's records. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Personnel Services - Salaries and Supplies that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Due to problems encountered during the uploading process in JotForm, the School Corporation was unaware that information submitted was incorrect after multiple attempts at uploading at the Indiana Department of Education's request. Additionally, the School Corporation's management had not developed a system of internal controls to ensure that reports required for COVID-19 - Education Stabilization Funds were accurate, supported by the School Corporation's records, and reviewed prior to submission. Effect Due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. INDIANA STATE BOARD OF ACCOUNTS 22 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: COVID-19 - Education Stabilization Fund - Reporting 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): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . .," "LEA expenditures by ESSER Subgrant fund . . .," and "Full-Time Equivalency Positions." During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, and two ESSER III reports for a total of five reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All five reports were selected for testing. Three of the reports were not supported by the School Corporation's records. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, Personnel Services - Salaries could not be traced to the School Corporation's records. For the ESSER II, Year 3 report, Supplies could not be traced to the School Corporation's records. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Personnel Services - Salaries and Supplies that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Due to problems encountered during the uploading process in JotForm, the School Corporation was unaware that information submitted was incorrect after multiple attempts at uploading at the Indiana Department of Education's request. Additionally, the School Corporation's management had not developed a system of internal controls to ensure that reports required for COVID-19 - Education Stabilization Funds were accurate, supported by the School Corporation's records, and reviewed prior to submission. Effect Due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. INDIANA STATE BOARD OF ACCOUNTS 22 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: COVID-19 - Education Stabilization Fund - Reporting 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): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . .," "LEA expenditures by ESSER Subgrant fund . . .," and "Full-Time Equivalency Positions." During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, and two ESSER III reports for a total of five reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All five reports were selected for testing. Three of the reports were not supported by the School Corporation's records. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, Personnel Services - Salaries could not be traced to the School Corporation's records. For the ESSER II, Year 3 report, Supplies could not be traced to the School Corporation's records. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Personnel Services - Salaries and Supplies that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Due to problems encountered during the uploading process in JotForm, the School Corporation was unaware that information submitted was incorrect after multiple attempts at uploading at the Indiana Department of Education's request. Additionally, the School Corporation's management had not developed a system of internal controls to ensure that reports required for COVID-19 - Education Stabilization Funds were accurate, supported by the School Corporation's records, and reviewed prior to submission. Effect Due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. INDIANA STATE BOARD OF ACCOUNTS 22 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: COVID-19 - Education Stabilization Fund - Reporting 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): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . .," "LEA expenditures by ESSER Subgrant fund . . .," and "Full-Time Equivalency Positions." During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, and two ESSER III reports for a total of five reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All five reports were selected for testing. Three of the reports were not supported by the School Corporation's records. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, Personnel Services - Salaries could not be traced to the School Corporation's records. For the ESSER II, Year 3 report, Supplies could not be traced to the School Corporation's records. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Personnel Services - Salaries and Supplies that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Due to problems encountered during the uploading process in JotForm, the School Corporation was unaware that information submitted was incorrect after multiple attempts at uploading at the Indiana Department of Education's request. Additionally, the School Corporation's management had not developed a system of internal controls to ensure that reports required for COVID-19 - Education Stabilization Funds were accurate, supported by the School Corporation's records, and reviewed prior to submission. Effect Due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. INDIANA STATE BOARD OF ACCOUNTS 22 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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: COVID-19 - Education Stabilization Fund - Reporting 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): S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context As part of sound management of the federal award, the School Corporation was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The School Corporation had not properly designed or implemented such a system, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit annual data reports to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and key line items such as "Number of Specific Positions Supported with ESSER Funds," "Allocation of ESSER funds . . .," "LEA expenditures by ESSER Subgrant fund . . .," and "Full-Time Equivalency Positions." During the audit period, the School Corporation submitted one ESSER I report, two ESSER II reports, and two ESSER III reports for a total of five reports. There was no evidence of an oversight, review, or approval process to prevent, or detect and correct, errors prior to submission. All five reports were selected for testing. Three of the reports were not supported by the School Corporation's records. The following errors were identified: The ESSER II, Year 2 and Year 3 reports, which covered the periods of July 1, 2021 to June 30, 2022, and July 1, 2022 to June 30, 2023, respectively, Key Line Items were not able to be traced to supporting documentation. For both reports, Personnel Services - Salaries could not be traced to the School Corporation's records. For the ESSER II, Year 3 report, Supplies could not be traced to the School Corporation's records. The ESSER III, Year 3 report, which covered the period of July 1, 2022 to June 30, 2023, Key Line Items were not able to be traced to supporting documentation. The School Corporation reported amounts related to Personnel Services - Salaries and Supplies that were not supported by the School Corporation's records. The lack of internal controls and noncompliance were systemic issues throughout the audit period. INDIANA STATE BOARD OF ACCOUNTS 21 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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.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 and 200.329. . . ." 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. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Due to problems encountered during the uploading process in JotForm, the School Corporation was unaware that information submitted was incorrect after multiple attempts at uploading at the Indiana Department of Education's request. Additionally, the School Corporation's management had not developed a system of internal controls to ensure that reports required for COVID-19 - Education Stabilization Funds were accurate, supported by the School Corporation's records, and reviewed prior to submission. Effect Due to a lack of review and segregation of duties, the School Corporation submitted ESSER II and ESSER III reports that were not supported by the School Corporation's records. As a result, material noncompliance occurred and remained undetected. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish a proper system of internal controls and strengthen its policies and procedures to ensure all reports submitted are accurate. INDIANA STATE BOARD OF ACCOUNTS 22 SOUTH HARRISON COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I and ESSER II amounts reported for the reports covering the FY22 time period ($0 and $459,915 respectively) did not agree to the underlying expenditure records ($27,092 and $455,658 respectively) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($459,616 and $22,273 respectively) did not agree to the underlying expenditure records ($107,610 and $1,274,716 respectively) for the period of July 1, 2022 through June 30, 2023. We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Additionally, the School Corporation was unable to provide the supporting documents containing the FTEs reported as of 9/30/22 and 9/30/23. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-002. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.
Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards 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.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: 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 Reporting 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: The School Corporation was required to submit two Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the ESSER I and ESSER II amounts reported for the reports covering the FY22 time period ($0 and $459,915 respectively) did not agree to the underlying expenditure records ($27,092 and $455,658 respectively) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($459,616 and $22,273 respectively) did not agree to the underlying expenditure records ($107,610 and $1,274,716 respectively) for the period of July 1, 2022 through June 30, 2023. We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Additionally, the School Corporation was unable to provide the supporting documents containing the FTEs reported as of 9/30/22 and 9/30/23. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-002. Recommendation: 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.