Condition The required Annual Project and Expenditure (P & E) Report was submitted after its due date. The report was required for the annual peiod ended March 31, 2024, and was due on April 30, 2024. 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 the report was submitted after the due date. Cause The Municipality failed in 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 required reports of each federal program in order to comply with the required submissions to the federal awarding agencies.
Condition The required Annual Project and Expenditure (P & E) Report was submitted after its due date. The report was required for the annual peiod ended March 31, 2024, and was due on April 30, 2024. 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 the report was submitted after the due date. Cause The Municipality failed in 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 required reports of each federal program in order to comply with the required submissions to the federal awarding agencies.
Information on the federal program – Assistance Listing Number 93.918, Grants to Provide Outpatient Early Intervention Services with Respect to HIV Disease (Ryan White Part C), Federal Award No. H7631535 for project period January 1, 2022 through December 31, 2024 and Federal Award No. H7600531 for project period May 1, 2022 through April 30, 2025. Criteria or specific requirement – Recipients of funding under this federal program must comply with federal standards under 2 CFR section 200.307 for program income and 2 CFR section 200.328 for financial reporting. Condition – The Organization did not properly segregate or track the usage of program income in accordance with the terms of the Notice of Award. Additionally, the Organization improperly reported $0 program income on the Federal Financial Report for Federal Award H7631535 for reporting period ended December 31, 2023. Cause – Due to various turnovers within the finance department in 2024, there was a lack of appropriate knowledge surrounding program income requirements related to this program. Effect or potential effect – Federal standards were not appropriately followed for program income and financial reporting. Questioned costs – None Context – Per inquiry with management of the Organization, review of accounting records and testing of the Federal Financial Report, it was evident that program income was not being properly tracked or reported. Identification as a repeat finding, if applicable – not a repeat finding. Recommendation – We recommend the Organization implement additional internal controls surrounding the tracking and reporting of program income. We also recommend management perform a detailed review of all federal notices of award to ensure compliance with program income requirements. Views of responsible officials and planned corrective actions – See separate auditee document for planned corrective action.
2024-004: – Activities Allowed or Unallowed and Allowable Costs/Cost Principles – Significant Deficiency Federal Programs Assistance Listing Number 93.600 Head Start Department of Health and Human Services 2 CFR Part 200.328 Criteria The District’s internal controls related to employee wage or salary rates require the Director of the Head Start program to formally approve employee wage or salary rates. Condition Three employees of the Head Start program were found to not have formally approved wage or salary rates. Context Sixteen salaried employees and fifteen waged employees were tested out of a total of 55 employees. Cause Management oversight Effect An employee could have received an incorrect wage or salary. Questioned Costs None Recommendation We recommend the District adhere to their internal controls and formally approve all wage and salary employee approved rates. Repeat Finding This is not a repeat finding. Views of Responsible Officials
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, ESSER II, and ESSER III amounts reported for the reports covering the FY22 time period ($3,000, $0 and $0, respectively) did not agree to the underlying expenditure records ($0, $207,168, and $104,885, respectively, for the period of July 1, 2021 through June 30, 2022). Additionally, we noted that the ESSER I, ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($0, $328,359 and $334,119, respectively) did not agree to the underlying expenditure records ($0, $121,193 and $229,234, respectively, for the period of July 1, 2022 through June 30, 2023). 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, ESSER II, and ESSER III amounts reported for the reports covering the FY22 time period ($3,000, $0 and $0, respectively) did not agree to the underlying expenditure records ($0, $207,168, and $104,885, respectively, for the period of July 1, 2021 through June 30, 2022). Additionally, we noted that the ESSER I, ESSER II, and ESSER III amounts reported for the reports covering the FY23 time period ($0, $328,359 and $334,119, respectively) did not agree to the underlying expenditure records ($0, $121,193 and $229,234, respectively, for the period of July 1, 2022 through June 30, 2023). 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 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2024-001 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): FY2023, FY2024, FY23/FY24 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness INDIANA STATE BOARD OF ACCOUNTS 15 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context There were no internal controls in place to ensure that the School Corporation complied with the reporting requirements. The reimbursement request reports were prepared and submitted by the Food Service Director without any oversight, review, or approval process to ensure accuracy of the reports. There was no oversight to verify that the number of meals served matched the report filed. The lack of internal controls was systemic 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.301 states in part: "(a) The Federal awarding agency must measure the recipient's performance to show achievement of program goals and objectives, share lessons learned, improve program outcomes, and foster adoption of promising practices. Program goals and objectives should be derived from program planning and design. See § 200.202 for more information. Where appropriate, the Federal award may include specific program goals, indicators, targets, baseline data, data collection, or expected outcomes (such as outputs, or services performance or public impacts of any of these) with an expected timeline for accomplishment. Where applicable, this should also include any performance measures or independent sources of data that may be used to measure progress. The Federal awarding agency will determine how performance progress is measured, which may differ by program. Performance measurement progress must be both measured and reported. See § 200.329 for more information on monitoring program performance. The Federal awarding agency may include program-specific requirements, as applicable. These requirements must be aligned, to the extent permitted by law, with the Federal awarding agency strategic goals, strategic objectives or performance goals that are relevant to the program. See also OMB Circular A-11, Preparation, Submission, and Execution of the Budget Part 6. (b) The Federal awarding agency should provide recipients with clear performance goals, indicators, targets, and baseline data as described in § 200.211. Performance reporting frequency and content should be established to not only allow the Federal awarding agency to understand the recipient progress but also to facilitate identification of promising practices among recipients and build the evidence upon which the Federal awarding agency's program and performance decisions are made. See § 200.328 for more information on reporting program performance. . . ." INDIANA STATE BOARD OF ACCOUNTS 16 SOUTH VERMILLION COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause Management had not developed or implemented a system of internal controls that would have ensured that the monthly reimbursement request filed matched the meals served per the cafeteria software. Effect The failure to establish an effective internal control system could have resulted in the reimbursement request being filed for the wrong number of meals served. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management strengthen its system of internal controls to ensure that the reporting of meals served is verified for accuracy. 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 Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 ($90,217 and $238,439, respectively) did not agree to the underlying expenditure records ($81,958 and $400,439 respectively, for the period of July 1, 2021 through June 30, 2022). Identification as a repeat finding: This is a repeat finding form 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 Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 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 ($90,217 and $238,439, respectively) did not agree to the underlying expenditure records ($81,958 and $400,439 respectively, for the period of July 1, 2021 through June 30, 2022). Identification as a repeat finding: This is a repeat finding form 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: COVID-19 – Education Stabilization Fund – Reporting 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 4 annual data report for the ESSER I and the Year 3 annual data reports for ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds covering the period of July 1, 2022 through June 30, 2023. The amounts reported as expended in the annual data reports were underreported by $504,240 compared to underlying funds ledger detail. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 4 annual data report for the ESSER I and the Year 3 annual data reports for ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds covering the period of July 1, 2022 through June 30, 2023. The amounts reported as expended in the annual data reports were underreported by $504,240 compared to underlying funds ledger detail. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 4 annual data report for the ESSER I and the Year 3 annual data reports for ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds covering the period of July 1, 2022 through June 30, 2023. The amounts reported as expended in the annual data reports were underreported by $504,240 compared to underlying funds ledger detail. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 4 annual data report for the ESSER I and the Year 3 annual data reports for ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds covering the period of July 1, 2022 through June 30, 2023. The amounts reported as expended in the annual data reports were underreported by $504,240 compared to underlying funds ledger detail. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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: Significant Deficiency 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 3 and Year 4 annual data reports for the ESSER I, ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds. The amounts reported as expended in the Year 3 reports, which covers the period of July 1, 2021 through June 30, 2022, were underreported by $10,152. The amounts reported as expended in the Year 4 report, which covers the period of July 1, 2022 through June 30, 2023, were overreported by $43,050. This resulted in a net overreporting of $32,898. Annual Data Report Year 3 - Period of 7/1/21 - 6/30/22 As Reported Per Support Over (under) Reported ESSER I CARES $ 67,160 $ 64,712 $ (2,448) ESSER II 416,014 428,614 12,600 ESSER III (ARP) 441,903 441,903 - Total $ 925,077 $ 935,229 $ (10,152) Annual Data Report Year 4 - Period of 7/1/22 - 6/30/23 As Reported Per Support Over (under) Reported ESSER I CARES $ - $ 2,448 $ 2,448 ESSER II 60,897 200,041 139,144 ESSER III (ARP) 623,874 439,233 (184,641) Total $ 684,771 $ 641,722 $ 43,049 Additionally, Year 3 full-time equivalent employees were improperly reported at 84 instead of 87. Additionally, the CrossAct Detail for both Year 3 and Year 4 were not provided. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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: Significant Deficiency 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 3 and Year 4 annual data reports for the ESSER I, ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds. The amounts reported as expended in the Year 3 reports, which covers the period of July 1, 2021 through June 30, 2022, were underreported by $10,152. The amounts reported as expended in the Year 4 report, which covers the period of July 1, 2022 through June 30, 2023, were overreported by $43,050. This resulted in a net overreporting of $32,898. Annual Data Report Year 3 - Period of 7/1/21 - 6/30/22 As Reported Per Support Over (under) Reported ESSER I CARES $ 67,160 $ 64,712 $ (2,448) ESSER II 416,014 428,614 12,600 ESSER III (ARP) 441,903 441,903 - Total $ 925,077 $ 935,229 $ (10,152) Annual Data Report Year 4 - Period of 7/1/22 - 6/30/23 As Reported Per Support Over (under) Reported ESSER I CARES $ - $ 2,448 $ 2,448 ESSER II 60,897 200,041 139,144 ESSER III (ARP) 623,874 439,233 (184,641) Total $ 684,771 $ 641,722 $ 43,049 Additionally, Year 3 full-time equivalent employees were improperly reported at 84 instead of 87. Additionally, the CrossAct Detail for both Year 3 and Year 4 were not provided. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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: Significant Deficiency 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 3 and Year 4 annual data reports for the ESSER I, ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds. The amounts reported as expended in the Year 3 reports, which covers the period of July 1, 2021 through June 30, 2022, were underreported by $10,152. The amounts reported as expended in the Year 4 report, which covers the period of July 1, 2022 through June 30, 2023, were overreported by $43,050. This resulted in a net overreporting of $32,898. Annual Data Report Year 3 - Period of 7/1/21 - 6/30/22 As Reported Per Support Over (under) Reported ESSER I CARES $ 67,160 $ 64,712 $ (2,448) ESSER II 416,014 428,614 12,600 ESSER III (ARP) 441,903 441,903 - Total $ 925,077 $ 935,229 $ (10,152) Annual Data Report Year 4 - Period of 7/1/22 - 6/30/23 As Reported Per Support Over (under) Reported ESSER I CARES $ - $ 2,448 $ 2,448 ESSER II 60,897 200,041 139,144 ESSER III (ARP) 623,874 439,233 (184,641) Total $ 684,771 $ 641,722 $ 43,049 Additionally, Year 3 full-time equivalent employees were improperly reported at 84 instead of 87. Additionally, the CrossAct Detail for both Year 3 and Year 4 were not provided. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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: Significant Deficiency 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 3 and Year 4 annual data reports for the ESSER I, ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds. The amounts reported as expended in the Year 3 reports, which covers the period of July 1, 2021 through June 30, 2022, were underreported by $10,152. The amounts reported as expended in the Year 4 report, which covers the period of July 1, 2022 through June 30, 2023, were overreported by $43,050. This resulted in a net overreporting of $32,898. Annual Data Report Year 3 - Period of 7/1/21 - 6/30/22 As Reported Per Support Over (under) Reported ESSER I CARES $ 67,160 $ 64,712 $ (2,448) ESSER II 416,014 428,614 12,600 ESSER III (ARP) 441,903 441,903 - Total $ 925,077 $ 935,229 $ (10,152) Annual Data Report Year 4 - Period of 7/1/22 - 6/30/23 As Reported Per Support Over (under) Reported ESSER I CARES $ - $ 2,448 $ 2,448 ESSER II 60,897 200,041 139,144 ESSER III (ARP) 623,874 439,233 (184,641) Total $ 684,771 $ 641,722 $ 43,049 Additionally, Year 3 full-time equivalent employees were improperly reported at 84 instead of 87. Additionally, the CrossAct Detail for both Year 3 and Year 4 were not provided. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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: COVID-19 – Education Stabilization Fund – Reporting 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: Significant Deficiency 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 District'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. Internal controls were not adequate to detect and prevent errors in annual data submitted to the Indiana Department of Education. Questioned Costs: There were no questioned costs identified. Context: The School Corporation had not designed nor implemented a system of internal control to ensure that the annual Elementary and Secondary School Emergency Relief (ESSER) annual Data Collection reports (Reports) were complete and accurately submitted. The reports were prepared and submitted in JotForm, the online application used by the Indiana Department of Education to collect information, without an oversight or secondary review process in place to prevent or detect and correct errors. During the testing of the annual data reports, variances were noted in the amounts expended reported on the Year 3 and Year 4 annual data reports for the ESSER I, ESSER II and ESSER III grant awards when compared to underlying disbursement detail for the grant funds. The amounts reported as expended in the Year 3 reports, which covers the period of July 1, 2021 through June 30, 2022, were underreported by $10,152. The amounts reported as expended in the Year 4 report, which covers the period of July 1, 2022 through June 30, 2023, were overreported by $43,050. This resulted in a net overreporting of $32,898. Annual Data Report Year 3 - Period of 7/1/21 - 6/30/22 As Reported Per Support Over (under) Reported ESSER I CARES $ 67,160 $ 64,712 $ (2,448) ESSER II 416,014 428,614 12,600 ESSER III (ARP) 441,903 441,903 - Total $ 925,077 $ 935,229 $ (10,152) Annual Data Report Year 4 - Period of 7/1/22 - 6/30/23 As Reported Per Support Over (under) Reported ESSER I CARES $ - $ 2,448 $ 2,448 ESSER II 60,897 200,041 139,144 ESSER III (ARP) 623,874 439,233 (184,641) Total $ 684,771 $ 641,722 $ 43,049 Additionally, Year 3 full-time equivalent employees were improperly reported at 84 instead of 87. Additionally, the CrossAct Detail for both Year 3 and Year 4 were not provided. Identification as a repeat finding, if applicable: No. Recommendation: We recommend someone other than the preparer of the report perform a documented, secondary review of the report information 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-003 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. 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: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. 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: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. 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: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. 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: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. 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: Indiana Department of Education Federal Program: COVID-19 - Education Stablization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation was required to submit annual data reports to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. 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. The annual data reports were compiled, prepared, and submitted by the Treasurer without an oversight or review process in place to prevent, or detect and correct, errors. In addition, the five annual data reports were not supported by the School Corporation's records. The documentation used to prepare the reports was not retained by the School Corporation and the ledger activity for the time period of each report did not agree to the data submitted. As such, the Indiana State Board of Accounts could not verify the information submitted to the IDOE was accurate or complete. 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.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. . . ." 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. . . ." (3) Records that identify adequately the source and application of funds for federally funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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 A proper system of internal controls, which include segregation of key functions, was not established by management of the School Corporation to ensure that reports filed were supported by School Corporation records and had an independent review, for accuracy and completeness, prior to submission. Effect Without a proper system of internal controls in place that operated effectively, the School Corporation submitted reports that were not supported by School Corporation records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that documentation utilized in the preparation of the reports is maintained and that there is an independent review of the reports for accuracy and completeness prior to submission. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
Department of Labor Federal Financial Assistance Listing #17.270, YF-38599-22-60-A-19, 7/1/2023 – 6/30/2024 Reentry Employment Opportunities Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) states that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. 2 CFR 200.328 requires the auditee to submit financial reports as required by the federal award. Section 12.l. of the grant agreement requires quarterly financial reports on the ETA-9130 Financial Report which notes all financial data is required to be reported cumulative from grant inception, through the end of each reporting period. Expenditure data is required to be reported on an accrual basis. Condition: We identified that the 9130 financial reports were completed on the cash basis of accounting and were completed as of the date the report was submitted and not based on the specified quarterly reporting period. Additionally, documentation was not retained to support the numbers reported and there was no documented review or approval over the 9130 quarterly reports. Cause: Documentation was not retained to support the amounts being reported on the 9130 quarterly reports. Additionally, there was no documented review and approval. Effect: Without retaining documentation to support the amounts reported and to support oversight over the reporting process, demonstrating that the program complies with laws, regulations, and other compliance requirements is difficult. Questioned Costs: None reported. Context: In a statistical sample of four quarters, two quarters were selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend that management review the grant reporting requirements to ensure and understanding of the required reporting information. In addition, we suggest the Organization’s internal control procedures be reviewed and updated to include steps to retain the documentation which supports the information being reported to the federal government. Those procedures should also incorporate documentation of the review and approval of the quarterly reports prior to submission. Views of Responsible Officials: Management is in agreement.
Finding 2024-002: Reporting (Significant Deficiency) Information on the Federal Program: 45.301 - Institute of Museum and Library Services Criteria or Specific Requirement: As noted in 2 CFR §200.328 Monitoring and reporting program performance (b)(1), “The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency”. Condition: During the audit, we noted that the program reports selected for testing were not submitted within the timeframe stipulated in the award agreement. Cause: Management did not have effective internal controls in place to ensure that program reports would be submitted timely and in line with requirements in the award agreement. Effect or Potential Effect: Without established controls over reporting, there is a reasonable possibility that the Museum would not detect noncompliance in the normal course of performing duties and correct them in a timely manner. Questioned Costs: None noted. Context: 3 of the 3 program reports selected for testing were not submitted by the due date stipulated in the award agreement. Identification as a Repeat Finding, if Applicable: Not a repeat finding. Recommendation: We recommend that management of the Museum ensure that all programmatic reporting requirements are clearly communicated to program staff and managers. Controls should be implemented to ensure that reports are prepared and submitted within a timely manner to the Federal agency.
2024-001 U.S. Department of the Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal awarding agency. The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Condition: As of the March 31, 2024 reporting date, the Town’s Project and Expenditure Reports overstated expenditures by $821,704. Cause: The Town did not reconcile the Project and Expenditure report with the Town’s general ledger before submitting. Effect: The Town did not properly report grant expenditures in the Project and Expenditure reporting. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s general ledger before submission. Views of Responsible Official: Management agrees with the finding.
Compliance finding (Reporting). Criteria or specific requirement (including statutory, regulatory, or other citation) - A federal agency or pass-through entity must collect financial reports no less than annually, 2 CFR 200.328(b). To comply with this reporting requirement the Illinois State Board of Education (ISBE) requires that grant subrecipients (i.e., the District) submit quarterly expenditure reports. Condition - The District did not comply with the reporting requirements with respect to filing accurate quarterly reports with the ISBE. Questioned Costs – None. Context - The noncompliance resulted from the District filing a June 30, 2024, quarterly report with the ISBE claiming no grant expenditures. The actual expenditures incurred prior to June 30, 2024 was $1,407,464. These expenditures were claimed on subsequent expenditure reports filed with the ISBE. Effect - Incorrect financial information was submitted to the ISBE for the quarter ended June 30, 2024 which may result in potential errors in analysis or other determinations. Cause - The District understood that the grant expenditures could be claimed through the project end date which was September 30, 2024. The District had controls in place to accumulate the grant expenditure amounts as well as the filing of expenditure reports. Recommendation - Management should submit accurate expenditure reports regardless of the project end date. Management's response - Management concurs 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 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.
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.